APPS.EGO_EBI_ITEM_LOAD SQL Statements

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

Line: 15

    DELETE FROM EGO_EBI_ITEM_LOAD_LOG;

Line: 41

  SELECT count(*) INTO  l_logItemCount  FROM EGO_EBI_ITEM_LOAD_LOG;

Line: 47

     x_err_msg := x_err_msg || '\n Inserting Records to Event log table';

Line: 50

     INSERT INTO EGO_EBI_ITEM_LOAD_LOG (INVENTORY_ITEM_ID,ORGANIZATION_ID, EVENT_ID)
        SELECT INVENTORY_ITEM_ID, ORGANIZATION_ID, NULL
        FROM MTL_SYSTEM_ITEMS_B
        WHERE ORGANIZATION_ID = p_organization_id
          AND bom_item_type in (1, 2, 4)
          AND customer_order_flag = 'Y'
          AND customer_order_enabled_flag = 'Y';

Line: 61

     SELECT MAX(NVL(EVENT_ID,0)) into l_eventId FROM EGO_EBI_ITEM_LOAD_LOG;

Line: 66

     SELECT count(*) INTO l_ItemCount FROM EGO_EBI_ITEM_LOAD_LOG WHERE EVENT_ID IS NULL;

Line: 72

       UPDATE EGO_EBI_ITEM_LOAD_LOG
        SET EVENT_ID = l_eventId
       WHERE EVENT_ID IS NULl AND  ROWNUM < l_batch_size +1;

Line: 108

  SELECT count(*) INTO  l_logItemCount
  FROM EGO_EBI_ITEM_LOAD_LOG
  WHERE ORGANIZATION_ID =  p_organization_id
    AND EVENT_ID = p_event_id;

Line: 119

     DELETE FROM  EGO_EBI_ITEM_LOAD_LOG
     WHERE ORGANIZATION_ID = p_organization_id AND
           EVENT_ID = p_event_id AND
           INVENTORY_ITEM_ID NOT IN(
                    SELECT INVENTORY_ITEM_ID
                    FROM MTL_SYSTEM_ITEMS_B
                    WHERE ORGANIZATION_ID = p_organization_id
                      AND bom_item_type in (1, 2, 4)
                      AND customer_order_flag = 'Y'
                      AND customer_order_enabled_flag = 'Y');

Line: 130

       SELECT MAX(NVL(EVENT_ID,0))+1 into l_eventId FROM EGO_EBI_ITEM_LOAD_LOG;

Line: 131

       UPDATE EGO_EBI_ITEM_LOAD_LOG
            SET EVENT_ID = l_eventId
            WHERE EVENT_ID = p_event_id   ;

Line: 171

  l_parameter_list.DELETE;