DBA Data[Home] [Help]

APPS.EGO_P4T_UPGRADE_PVT dependencies on DBMS_OUTPUT

Line 37: Dbms_Output.put_line('PIM For Telco upgrade script execution:');

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:

Line 38: Dbms_Output.put_line(' Total number of Item Catalog Categories available : '||v_icc_count);

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:

Line 39: Dbms_Output.put_line(' Total number of Versioned ICCs : '||v_versioned);

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

Line 40: Dbms_Output.put_line(' Total number of Non-versioned ICCs : '||v_not_versioned);

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