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);
40: Dbms_Output.put_line(' Total number of Non-versioned ICCs : '||v_not_versioned);
41:
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);
40: Dbms_Output.put_line(' Total number of Non-versioned ICCs : '||v_not_versioned);
41:
42:
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);
40: Dbms_Output.put_line(' Total number of Non-versioned ICCs : '||v_not_versioned);
41:
42:
43: SELECT message_text into draft_str
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);
40: Dbms_Output.put_line(' Total number of Non-versioned ICCs : '||v_not_versioned);
41:
42:
43: SELECT message_text into draft_str
44: FROM fnd_new_messages