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;

1 comment:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, BI Publisher, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete