APPS.EGO_P4T_UPGRADE_PVT SQL Statements

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

Line: 7

      select a.item_catalog_group_id as IccID from  mtl_item_catalog_groups_b a
      where a.item_catalog_group_id not in
      (SELECT DISTINCT item_catalog_group_id FROM EGO_MTL_CATALOG_GRP_VERS_B);

Line: 25

    SELECT Count(*) INTO v_icc_count FROM  mtl_item_catalog_groups_b;

Line: 28

    SELECT Count(*) INTO v_versioned FROM  mtl_item_catalog_groups_b
    WHERE item_catalog_group_id IN
    (SELECT DISTINCT item_catalog_group_id FROM EGO_MTL_CATALOG_GRP_VERS_B);

Line: 33

    SELECT Count(*) INTO v_not_versioned FROM  mtl_item_catalog_groups_b
    WHERE item_catalog_group_id NOT IN
    (SELECT DISTINCT item_catalog_group_id FROM EGO_MTL_CATALOG_GRP_VERS_B);

Line: 43

    SELECT message_text into draft_str
    FROM fnd_new_messages
    WHERE
    application_id = (SELECT application_id
                      FROM fnd_application
                      WHERE application_short_name = 'EGO') AND
    message_name = 'EGO_ICC_DRAFT_VERSION' AND
    language_code = USERENV('LANG') ;

Line: 52

    SELECT message_text into default_ver_str
    FROM fnd_new_messages
    WHERE
    application_id = (SELECT application_id
                      FROM fnd_application
                      WHERE application_short_name = 'EGO') AND
    message_name = 'EGO_ICC_DEFAULT_VERS' AND
    language_code = USERENV('LANG')  ;

Line: 62

        insert into EGO_MTL_CATALOG_GRP_VERS_B
          (item_catalog_group_id,
          version_seq_id,
          version_description,
          start_active_date,
          end_active_date,
          created_by,
          creation_date,
          last_updated_by,
          last_update_date,
          last_update_login)
        values
          (rec.IccID,
          0,
          draft_str,
          null,
          null,
          FND_GLOBAL.USER_ID,
          sysdate,
          FND_GLOBAL.USER_ID,
          sysdate,
          FND_GLOBAL.LOGIN_ID);

Line: 85

        insert into EGO_MTL_CATALOG_GRP_VERS_B
          (item_catalog_group_id,
          version_seq_id,
          version_description,
          start_active_date,
          end_active_date,
          created_by,
          creation_date,
          last_updated_by,
          last_update_date,
          last_update_login)
        values
          (rec.IccID,
          1,
          default_ver_str,
          nvl(start_effective_date, sysdate),
          null,
          FND_GLOBAL.USER_ID,
          sysdate,
          FND_GLOBAL.USER_ID,
          sysdate,
          FND_GLOBAL.LOGIN_ID);