DECLARE
xrowid VARCHAR2 (2000);
BEGIN
FND_MENUS_PKG.UPDATE_ROW (87216, -- Menu ID
'XX_TEST_MENU', -- Menu Name
'XX Test Menu', -- User Menu Name
x_menu_type => 'Standard',
x_description => 'Menu Updated from Backend',
x_creation_date => SYSDATE,
x_created_by => fnd_global.user_id,
x_last_update_date => SYSDATE,
x_last_updated_by => fnd_global.user_id, --userid
x_last_update_login => fnd_global.login_id);
COMMIT;
EXCEPTION
WHEN OTHERS
THEN
ROLLBACK;
DBMS_OUTPUT.put_line (SQLERRM);
END;
/
xrowid VARCHAR2 (2000);
BEGIN
FND_MENUS_PKG.UPDATE_ROW (87216, -- Menu ID
'XX_TEST_MENU', -- Menu Name
'XX Test Menu', -- User Menu Name
x_menu_type => 'Standard',
x_description => 'Menu Updated from Backend',
x_creation_date => SYSDATE,
x_created_by => fnd_global.user_id,
x_last_update_date => SYSDATE,
x_last_updated_by => fnd_global.user_id, --userid
x_last_update_login => fnd_global.login_id);
COMMIT;
EXCEPTION
WHEN OTHERS
THEN
ROLLBACK;
DBMS_OUTPUT.put_line (SQLERRM);
END;
/
No comments:
Post a Comment