[Home] [Help]
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');
12: draft_str VARCHAR2(2000);
13: default_ver_str varchar2(2000);
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
33: SELECT Count(*) INTO v_not_versioned FROM mtl_item_catalog_groups_b
34: WHERE item_catalog_group_id NOT IN
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:');
38: Dbms_Output.put_line(' Total number of Item Catalog Categories available : '||v_icc_count);
39: Dbms_Output.put_line(' Total number of Versioned ICCs : '||v_versioned);
58: message_name = 'EGO_ICC_DEFAULT_VERS' AND
59: language_code = USERENV('LANG') ;
60:
61: for rec in non_ver_iccs loop
62: insert into EGO_MTL_CATALOG_GRP_VERS_B
63: (item_catalog_group_id,
64: version_seq_id,
65: version_description,
66: start_active_date,
81: FND_GLOBAL.USER_ID,
82: sysdate,
83: FND_GLOBAL.LOGIN_ID);
84:
85: insert into EGO_MTL_CATALOG_GRP_VERS_B
86: (item_catalog_group_id,
87: version_seq_id,
88: version_description,
89: start_active_date,