DECLARE
xrowid VARCHAR2 (2000);
BEGIN
FND_MENU_ENTRIES_PKG.INSERT_ROW (xrowid, -- Rowid
87216, -- Menu ID
201, -- Sequence Number
50138, -- Sub menu ID
NULL, -- 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
50138, -- Sub menu ID
NULL, -- 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