DECLARE
xrowid VARCHAR2 (2000);
BEGIN
fnd_menu_entries_pkg.insert_row (
xrowid, -- Rowid
87216, -- Menu ID
201, -- Sequence Number
NULL, -- Sub menu ID
50138, -- Function ID
'Y', -- Grant Flag
NULL, -- Prompt
NULL, -- Description
SYSDATE, -- Creation Date
-1, -- Created by
SYSDATE, Last update date
-1, -- Last Updated by
-1 -- Last update login
);
COMMIT;
EXCEPTION
WHEN OTHERS
THEN
ROLLBACK;
DBMS_OUTPUT.put_line (SQLERRM);
END;
xrowid VARCHAR2 (2000);
BEGIN
fnd_menu_entries_pkg.insert_row (
xrowid, -- Rowid
87216, -- Menu ID
201, -- Sequence Number
NULL, -- Sub menu ID
50138, -- Function ID
'Y', -- Grant Flag
NULL, -- Prompt
NULL, -- Description
SYSDATE, -- Creation Date
-1, -- Created by
SYSDATE, Last update date
-1, -- Last Updated by
-1 -- Last update login
);
COMMIT;
EXCEPTION
WHEN OTHERS
THEN
ROLLBACK;
DBMS_OUTPUT.put_line (SQLERRM);
END;
No comments:
Post a Comment