APPS.INVUPCTF SQL Statements

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

Line: 4

PROCEDURE  UPDATE_CATALOG_STATUS_FLAG(
current_catalog_id          IN    NUMBER,
current_element_name        IN    VARCHAR2
)
IS

 el_value     VARCHAR2(30);

Line: 13

 select msi.inventory_item_id  III
 from   mtl_system_items_B  msi
 where  msi.item_catalog_group_id = current_catalog_id
   and  msi.catalog_status_flag <> 'N';

Line: 24

     SELECT ELEMENT_VALUE INTO el_value
       FROM MTL_DESCR_ELEMENT_VALUES MDEV
      WHERE MDEV.INVENTORY_ITEM_ID = get_iii_cursor_row.III
        AND MDEV.ELEMENT_NAME = current_element_name;

Line: 30

         UPDATE MTL_SYSTEM_ITEMS_B  MSI
            SET MSI.CATALOG_STATUS_FLAG = 'N'
          WHERE MSI.INVENTORY_ITEM_ID = get_iii_cursor_row.III
            AND MSI.ITEM_CATALOG_GROUP_ID = current_catalog_id;

Line: 38

END  UPDATE_CATALOG_STATUS_FLAG;

Line: 41

PROCEDURE  UPDATE_CATSTAT_FLAG_NEW_DE(
current_catalog_id     IN    NUMBER)
IS
BEGIN
       UPDATE MTL_SYSTEM_ITEMS_B  MSI
          SET MSI.CATALOG_STATUS_FLAG = 'N'
         WHERE MSI.ITEM_CATALOG_GROUP_ID = current_catalog_id
           AND MSI.CATALOG_STATUS_FLAG <> 'N';

Line: 50

END UPDATE_CATSTAT_FLAG_NEW_DE;

Line: 63

  SELECT  count(*) INTO t_count
  FROM  DUAL
  WHERE  EXISTS
         ( SELECT null
           FROM  MTL_DESCRIPTIVE_ELEMENTS  E
               , MTL_DESCR_ELEMENT_VALUES  V
           WHERE  E.REQUIRED_ELEMENT_FLAG = 'Y'
             AND  E.ITEM_CATALOG_GROUP_ID = current_catalog_id
             AND  V.INVENTORY_ITEM_ID = current_inv_item_id
             AND  V.ELEMENT_NAME = E.ELEMENT_NAME
             AND  V.ELEMENT_VALUE IS NULL
         );