Friday, September 8, 2017

API to Delete Function/Sub Menu in FND Menu (FND_MENU_ENTRIES_PKG.DELETE_ROW)

DECLARE
   l_seq   NUMBER := 1;
BEGIN
   BEGIN
      FND_MENU_ENTRIES_PKG.DELETE_ROW (x_menu_id          => 1026906,
                                       -- Menu ID
                                       x_entry_sequence   => l_seq -- Sequence Number
                                                                  );
   EXCEPTION
      WHEN OTHERS
      THEN
         DBMS_OUTPUT.put_line (SQLERRM || ' Is the error');
   END;
END;
/

No comments:

Post a Comment

API to Delete FND Application (FND_APPLICATION_PKG.DELETE_ROW)

BEGIN    FND_APPLICATION_PKG.DELETE_ROW (X_APPLICATION_ID => 20003); END; /