APPS.EGO_P4T_UPGRADE_PVT dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 7: select a.item_catalog_group_id as IccID from mtl_item_catalog_groups_b a

3:
4: PROCEDURE upgrade_to_pim4telco (start_effective_date IN DATE)
5: IS
6: cursor non_ver_iccs IS
7: select a.item_catalog_group_id as IccID from mtl_item_catalog_groups_b a
8: where a.item_catalog_group_id not in
9: (SELECT DISTINCT item_catalog_group_id FROM EGO_MTL_CATALOG_GRP_VERS_B);
10:
11: profile_value varchar2(1) := fnd_profile.value('EGO_ENABLE_P4T');

Line 25: SELECT Count(*) INTO v_icc_count FROM mtl_item_catalog_groups_b;

21: return;
22: end if;
23:
24: --No of ICC
25: SELECT Count(*) INTO v_icc_count FROM mtl_item_catalog_groups_b;
26:
27: --No of ICC VERSIONED
28: SELECT Count(*) INTO v_versioned FROM mtl_item_catalog_groups_b
29: WHERE item_catalog_group_id IN

Line 28: SELECT Count(*) INTO v_versioned FROM mtl_item_catalog_groups_b

24: --No of ICC
25: SELECT Count(*) INTO v_icc_count FROM mtl_item_catalog_groups_b;
26:
27: --No of ICC VERSIONED
28: SELECT Count(*) INTO v_versioned FROM mtl_item_catalog_groups_b
29: WHERE item_catalog_group_id IN
30: (SELECT DISTINCT item_catalog_group_id FROM EGO_MTL_CATALOG_GRP_VERS_B);
31:
32: --No of ICC NOT VERSIONED

Line 33: SELECT Count(*) INTO v_not_versioned FROM mtl_item_catalog_groups_b

29: WHERE item_catalog_group_id IN
30: (SELECT DISTINCT item_catalog_group_id FROM EGO_MTL_CATALOG_GRP_VERS_B);
31:
32: --No of ICC NOT VERSIONED
33: SELECT Count(*) INTO v_not_versioned FROM mtl_item_catalog_groups_b
34: WHERE item_catalog_group_id NOT IN
35: (SELECT DISTINCT item_catalog_group_id FROM EGO_MTL_CATALOG_GRP_VERS_B);
36:
37: Dbms_Output.put_line('PIM For Telco upgrade script execution:');