APPS.OE_OE_FOLDER_EXT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 13

   SELECT action_id,object,action_name,user_entered_prompt,
         folder_id,width,access_key,DISPLAY_AS_BUTTON_FLAG
   FROM  OE_Custom_Actions
   WHERE DISPLAY_AS_BUTTON_FLAG='Y' AND
         folder_id=l_folder_id;*/

Line: 21

   SELECT *
   FROM
     (SELECT action_id,
        object,
        action_name,
        user_entered_prompt,
        folder_id,
        width,
        access_key,
        display_as_button_flag,
        nvl(user_entered_prompt,    default_prompt) PROMPT
     FROM oe_custom_actions
      WHERE display_as_button_flag = 'Y'
      AND folder_id = l_folder_id
      UNION
      SELECT action_id,
        object,
        action_name,
        NULL,
        NULL,
        width,
        NULL,
        display_as_button_flag,
        decode(action_name,    'RITEMS',    'Related Items',    'BOOK_ORDER',    'Book Order',    initcap(action_name)) PROMPT
     FROM oe_default_actions od
      WHERE display_as_button_flag = 'Y'
      AND NOT EXISTS
       (SELECT action_id
        FROM oe_custom_actions oc
        WHERE oc.action_id = od.action_id
        AND folder_id = l_folder_id)
     )
   ORDER BY PROMPT;

Line: 57

   SELECT action_id,object,action_name,
         width,DISPLAY_AS_BUTTON_FLAG
   FROM  OE_Default_Actions  OD
   WHERE DISPLAY_AS_BUTTON_FLAG='Y' AND
   NOT EXISTS
  (SELECT action_id FROM
   OE_CUSTOM_ACTIONS OC
   WHERE OC.action_id=OD.action_id
   AND Folder_Id=l_folder_id);

Line: 114

   SELECT action_id,object,action_name,user_entered_prompt,
         folder_id,width,access_key,display_as_button_flag,default_prompt
   FROM  OE_Custom_Actions
   WHERE folder_id=l_folder_id;

Line: 120

   SELECT action_id,object,action_name,
         width,display_as_button_flag
   FROM  OE_Default_Actions  OD
   WHERE  NOT EXISTS
  (SELECT action_id FROM
   OE_CUSTOM_ACTIONS OC
   WHERE OC.action_id=OD.action_id
   AND Folder_Id=l_folder_id);

Line: 145

             SELECT default_prompt into
                    x_buttons_tbl(l_count).default_prompt
             FROM  oe_custom_actions
             WHERE action_name=BUTTONS.Action_Name
             AND default_prompt IS NOT NULL
             AND ROWNUM=1;

Line: 169

             SELECT default_prompt into
                    x_buttons_tbl(l_count).default_prompt
             FROM  oe_custom_actions
             WHERE action_name=BUTTONS.Action_Name
             AND default_prompt IS NOT NULL
             AND ROWNUM=1;

Line: 210

      SELECT ACTION_ID
      INTO l_action_id
      FROM OE_Custom_Actions
      WHERE action_id=p_config_buttons_tbl(i).action_id
      AND folder_id=p_folder_id;

Line: 216

      UPDATE OE_Custom_Actions
      SET action_name=p_config_buttons_tbl(i).action_name,
          width=p_config_buttons_tbl(i).width,
          user_entered_prompt=p_config_buttons_tbl(i).user_entered_prompt,
          access_key=p_config_buttons_tbl(i).access_key,
          display_as_button_flag=p_config_buttons_tbl(i).display_as_button
      WHERE action_id=p_config_buttons_tbl(i).action_id
      AND folder_id=p_folder_id;

Line: 227

      INSERT INTO OE_Custom_Actions
      (
      action_name,
      width,
      folder_id,
      user_entered_prompt,
      access_key,
      display_as_button_flag,
      default_prompt,
      action_id,
      CREATED_BY,
      CREATION_DATE,
      LAST_UPDATE_DATE,
      LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN

       )
       Values(
         p_config_buttons_tbl(i).action_name ,
         p_config_buttons_tbl(i).width,
         p_folder_id,
         p_config_buttons_tbl(i).user_entered_prompt,
         p_config_buttons_tbl(i).access_key,
         p_config_buttons_tbl(i).display_as_button,
         p_config_buttons_tbl(i).default_prompt,
         p_config_buttons_tbl(i).action_id,
         fnd_profile.value('USER_ID'),
         sysdate,
         sysdate,
         fnd_profile.value('USER_ID'),
         fnd_profile.value('USER_ID')
        );

Line: 280

PROCEDURE INSERT_FOLDER(p_folder_extension_id IN Number,
                       p_object IN Varchar2,
                       p_user_id IN Number,
                       p_folder_id IN Number,
                       p_pricing_tab IN Varchar2 Default Null,
                       p_service_tab IN Varchar2 Default Null,
                       p_others_tab IN Varchar2 Default Null,
                       p_addresses_tab IN varchar2 Default Null,
                       p_returns_tab  IN Varchar2 Default Null,
                       p_shipping_tab IN Varchar2 Default Null,
                       p_headers_others_tab IN Varchar2 Default Null,
                       p_options_details IN Varchar2 Default Null,
                       p_services_details IN Varchar2 Default Null,
                       p_adjustment_details IN Varchar2 Default Null,
                       p_related_item_details IN Varchar2 Default Null,
                       p_pricing_ava_details IN Varchar2 Default Null,
                       p_default_line_region IN Varchar2 Default Null
                     )
IS PRAGMA AUTONOMOUS_TRANSACTION;

Line: 301

  SELECT FOLDER_EXTENSION_ID
  INTO l_folder_extension_id
  FROM oe_folder_extensions
  WHERE  folder_id=p_folder_id;

Line: 306

  UPDATE oe_folder_extensions
  SET DISPLAY_LINE_OTHERS=p_others_tab,
     DISPLAY_LINE_PRICING=p_pricing_tab,
     DISPLAY_LINE_SERVICES=p_service_tab,
     DISPLAY_LINE_ADDRESSES=p_addresses_tab,
     DISPLAY_LINE_RETURNS=p_returns_tab,
     DISPLAY_LINE_SHIPPING=p_shipping_tab,
     DEFAULT_LINE_REGION=p_default_line_region,
     DISPLAY_ORDER_OTHERS=p_headers_others_tab,
     DISPLAY_OPTIONS_DETAILS=p_options_details,
     DISPLAY_SERVICES_DETAILS=p_services_details,
     DISPLAY_ADJUSTMENT_DETAILS=p_adjustment_details,
     DISPLAY_RELATED_ITEMS_DETAILS=p_related_item_details,
     DISPLAY_PRICING_AVA_DETAILS= p_pricing_ava_details
  WHERE FOLDER_ID=p_folder_id;

Line: 325

  INSERT INTO oe_folder_extensions
   (FOLDER_EXTENSION_ID,
    OBJECT,
    USER_ID,
    FOLDER_ID,
    APPLICATION_ID,
    DISPLAY_LINE_OTHERS ,
    DISPLAY_LINE_PRICING,
    DISPLAY_LINE_SERVICES,
    DISPLAY_LINE_ADDRESSES,
    DISPLAY_LINE_RETURNS,
    DISPLAY_LINE_SHIPPING,
    DISPLAY_ORDER_OTHERS,
    DISPLAY_OPTIONS_DETAILS,
    DISPLAY_SERVICES_DETAILS,
    DISPLAY_ADJUSTMENT_DETAILS,
    DISPLAY_RELATED_ITEMS_DETAILS,
    DISPLAY_PRICING_AVA_DETAILS,
    DEFAULT_LINE_REGION,
      CREATED_BY,
      CREATION_DATE,
      LAST_UPDATE_DATE,
      LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN
   ) VALUES
  (
   oe_folder_extensions_s.nextval,
   p_object,
   p_user_id,
   p_folder_id,
   fnd_profile.value('RESP_APPL_ID'),
   p_others_tab,
   p_pricing_tab,
   p_service_tab,
   p_addresses_tab,
   p_returns_tab,
   p_shipping_tab,
   p_headers_others_tab,
   p_options_details,
   p_services_details,
   p_adjustment_details,
   p_related_item_details,
   p_pricing_ava_details ,
   p_default_line_region,
   1,
   sysdate,
   sysdate,
   1,
   1
   );

Line: 383

END INSERT_FOLDER;

Line: 415

    SELECT FDF.Folder_Id
    FROM FND_DEFAULT_FOLDERS FDF, FND_FOLDERS FF
    WHERE
    FDF.OBJECT=p_order_folder_object
    AND (FDF.USER_ID=l_user_id OR (FDF.APPLICATION_ID=l_folder_app_id
    AND FDF.USER_ID=l_responsibility_id))
    AND FDF.FOLDER_ID=FF.FOLDER_ID
    AND FF.LANGUAGE=l_lang
    ORDER BY FDF.USER_ID DESC;

Line: 426

    SELECT FDF.Folder_Id
    FROM FND_DEFAULT_FOLDERS FDF, FND_FOLDERS FF
    WHERE
    FDF.OBJECT=p_line_folder_object
    AND (FDF.USER_ID=l_user_id OR (FDF.APPLICATION_ID=l_folder_app_id
    AND FDF.USER_ID=l_responsibility_id))
    AND FDF.FOLDER_ID=FF.FOLDER_ID
    AND FF.LANGUAGE=l_lang
    ORDER BY FDF.USER_ID DESC;

Line: 445

    SELECT FOLDER_EXTENSION_ID,
          DISPLAY_ORDER_OTHERS
    INTO   l_folder_extension_id,
          x_header_others_flag
    FROM  OE_FOLDER_EXTENSIONS
    WHERE folder_id=l_folder_header_id ;

Line: 466

    SELECT FOLDER_EXTENSION_ID,
          DISPLAY_LINE_OTHERS,
          DISPLAY_LINE_ADDRESSES,
          DISPLAY_LINE_PRICING,
          DISPLAY_LINE_SERVICES,
          DISPLAY_LINE_RETURNS,
          DISPLAY_LINE_SHIPPING,
          DISPLAY_OPTIONS_DETAILS,
          DISPLAY_SERVICES_DETAILS,
          DISPLAY_ADJUSTMENT_DETAILS,
          DISPLAY_RELATED_ITEMS_DETAILS,
          DISPLAY_PRICING_AVA_DETAILS,
          DEFAULT_LINE_REGION
    INTO   l_folder_extension_id,
          x_others_flag,
          x_addresses_flag,
          x_pricing_flag,
          x_services_flag,
          x_returns_flag,
          x_shipping_flag,
          x_options_details ,
          x_services_details,
          x_adjustment_details,
          x_related_item_details,
          x_pricing_ava_details ,
          x_default_line_region
    FROM  OE_FOLDER_EXTENSIONS
    WHERE folder_id=l_folder_line_id ;

Line: 521

PROCEDURE DELETE_FOLDER(p_folder_extension_id IN Number Default Null ,
                       p_folder_id IN Number
                     )
IS PRAGMA AUTONOMOUS_TRANSACTION;

Line: 528

   DELETE FROM OE_CUSTOM_ACTIONS
   WHERE folder_id=p_folder_id;

Line: 531

   DELETE FROM oe_folder_extensions
   WHERE  folder_id=p_folder_id;

Line: 543

END DELETE_FOLDER;