set serveroutput on
column date_column new_value today_var
select to_char(sysdate,'YYYYMMDDHHMI') date_column from dual
/
--
spool XXAJ_PO_APPROVAL_DETAILS_DATA
--
BEGIN
-- Add Request Set to request group.
BEGIN
fnd_set.add_set_to_group (request_set => 'XXAJ_PO_APPROVAL_DETAILS',
set_application => 'Order Management',
request_group => 'ALL Reports',
group_application => 'ONT'
);
DBMS_OUTPUT.PUT_LINE ('"XXAJ_PO_APPROVAL_DETAILS" attached to request group uccessfully ');
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.PUT_LINE ('Error in attaching "XXAJ_PO_APPROVAL_DETAILS" to equest group ' || SQLERRM);
END;
--
COMMIT;
Ur's
AmarAlam
column date_column new_value today_var
select to_char(sysdate,'YYYYMMDDHHMI') date_column from dual
/
--
spool XXAJ_PO_APPROVAL_DETAILS_DATA
--
BEGIN
-- Add Request Set to request group.
BEGIN
fnd_set.add_set_to_group (request_set => 'XXAJ_PO_APPROVAL_DETAILS',
set_application => 'Order Management',
request_group => 'ALL Reports',
group_application => 'ONT'
);
DBMS_OUTPUT.PUT_LINE ('"XXAJ_PO_APPROVAL_DETAILS" attached to request group uccessfully ');
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.PUT_LINE ('Error in attaching "XXAJ_PO_APPROVAL_DETAILS" to equest group ' || SQLERRM);
END;
--
COMMIT;
Ur's
AmarAlam
0 comments:
Post a Comment