Tuesday 19 August 2014

SQL Query Process

/* Formatted on 8/19/2014 9:14:59 AM (QP5 v5.115.810.9015) */
V_USER_ID                          NUMBER;
MENU_ID                            MENUITEM;
MENU_ID1                            MENUITEM;

BEGIN
   v_user_id   := NAME_IN ('USER.USER_ID');
   menu_id     := FIND_MENU_ITEM ('SPECIAL_C.SPECIAL42');
   menu_id1    := FIND_MENU_ITEM ('SPECIAL_C.SPECIAL45');

   IF v_user_id IS NULL
   THEN
      SET_MENU_ITEM_PROPERTY (menu_id, enabled, property_false);
      SET_MENU_ITEM_PROPERTY (menu_id1, enabled, property_false);
   ELSE
      SET_MENU_ITEM_PROPERTY (menu_id, enabled, property_true);
      SET_MENU_ITEM_PROPERTY (menu_id1, enabled, property_true);
   END IF;
END;


/* Formatted on 8/19/2014 9:16:22 AM (QP5 v5.115.810.9015) */
v_variable     varchar2(30);

BEGIN
   NULL;

   IF (NAME_IN ('SYSTEM.RECORD_STATUS') = 'INSERT')
   THEN
      fnd_message.set_string('End date is defaulted to inactivate the responsibility. To activate the responsibility, navigate to Actions>Activate Responsibilities');
      fnd_message.show;
   END IF;
END;

No comments:

Post a Comment