APPS.EGO_WF_WRAPPER_PVT SQL Statements

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

Line: 311

    SELECT MTL_BUSINESS_EVENTS_S.NEXTVAL into l_event_num FROM dual;  --Bug: 5606011

Line: 337

  l_parameter_list.DELETE;

Line: 355

PROCEDURE Raise_Item_Create_Update_Event (
                           p_event_name          IN   VARCHAR2
                          ,p_request_id          IN   NUMBER    DEFAULT NULL
                          ,p_Organization_Id     IN   NUMBER    DEFAULT NULL
                          ,p_organization_code   IN   VARCHAR2  DEFAULT NULL
                          ,p_Inventory_Item_Id   IN   NUMBER    DEFAULT NULL
                          ,p_item_number         IN   VARCHAR2  DEFAULT NULL
                          ,p_item_description    IN   VARCHAR2  DEFAULT NULL
			  ,p_is_master_attr_modified IN   VARCHAR2  DEFAULT 'N'
                          ,x_msg_data            OUT  NOCOPY VARCHAR2
                          ,x_return_status       OUT  NOCOPY VARCHAR2
                          )
IS
  l_parameter_list         WF_PARAMETER_LIST_T := WF_PARAMETER_LIST_T();

Line: 378

    SELECT MTL_BUSINESS_EVENTS_S.NEXTVAL into l_event_num FROM dual;  --Bug: 5606011

Line: 415

  l_parameter_list.DELETE;

Line: 421

END Raise_Item_Create_Update_Event;

Line: 461

    SELECT MTL_BUSINESS_EVENTS_S.NEXTVAL into l_event_num FROM dual;  --Bug: 5606011

Line: 560

            SELECT raise_item_cat_assign_event, raise_alt_cat_hier_chg_event, raise_catalog_cat_chg_event
            INTO l_raise_item_cat_assign, l_raise_alt_cat_hier_chg, l_raise_catalog_cat_chg
            FROM mtl_category_sets_b
            WHERE category_set_id = p_catalog_id;

Line: 588

    l_parameter_list.DELETE;

Line: 620

    SELECT MTL_BUSINESS_EVENTS_S.NEXTVAL into l_event_num FROM dual;  --Bug: 5606011

Line: 650

            SELECT raise_item_cat_assign_event, raise_alt_cat_hier_chg_event, raise_catalog_cat_chg_event
            INTO l_raise_item_cat_assign, l_raise_alt_cat_hier_chg, l_raise_catalog_cat_chg
            FROM mtl_category_sets_b
            WHERE category_set_id = p_category_set_id;

Line: 677

    l_parameter_list.DELETE;

Line: 697

         ,p_last_update_date      IN   VARCHAR2
         ,x_msg_data              OUT  NOCOPY VARCHAR2
         ,x_return_status         OUT  NOCOPY VARCHAR2
         )
IS

  l_parameter_list         WF_PARAMETER_LIST_T := WF_PARAMETER_LIST_T();

Line: 711

  SELECT  TO_CHAR( SYSTIMESTAMP, 'dd-mon-yyyy hh24:mi:ss:ffff' )
  INTO    l_event_key
  FROM    DUAL;

Line: 748

  WF_EVENT.AddParameterToList( p_name             => 'LAST_UPDATE_DATE'
                              ,p_value            => p_last_update_date
                              ,p_ParameterList    => l_parameter_List);

Line: 756

  l_parameter_list.DELETE;