eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.CZ_IMP_SINGLE dependencies on DBMS_UTILITY

Line 188: st_time := dbms_utility.get_time();

184: FETCH C_REF_PART_NBR INTO DFLT_REFPARTNBR;
185: CLOSE C_REF_PART_NBR;
186:
187: if (CZ_IMP_ALL.get_time) then
188: st_time := dbms_utility.get_time();
189: end if;
190:
191: SELECT DISTINCT INVENTORY_ITEM_ID, ORGANIZATION_ID, SEGMENT1, CONCATENATED_SEGMENTS, ITEM_DESC,
192: FIXED_LEAD_TIME, BOM_ITEM_TYPE, CUSTOMER_ORDER_ENABLED_FLAG,

Line 205: end_time := dbms_utility.get_time();

201: WHERE ORGANIZATION_ID=nOrg_ID AND TOP_ITEM_ID=nTop_ID
202: AND EXPLOSION_TYPE=sExpl_type;
203:
204: if (CZ_IMP_ALL.get_time) then
205: end_time := dbms_utility.get_time();
206: d_str := inRun_Id || ' Bulk collect item master (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
207: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_id);
208: end if;
209:

Line 259: loop_end_time := dbms_utility.get_time();

255: nIndex := nIndex + 1;
256: END LOOP;
257:
258: if (CZ_IMP_ALL.get_time) then
259: loop_end_time := dbms_utility.get_time();
260: --dbms_output.put_line ('loop over coll. (' || nTop_Id || ') :' || (loop_end_time-end_time)/100.00);
261: end if;
262:
263: FORALL i IN 1..iOrigSysRef.COUNT

Line 278: insert_end_time := dbms_utility.get_time();

274: iFskItemType(i), iFskItemType(i),
275: iSrcApplicationId(i), iSrcTypeCode(i));
276:
277: if (CZ_IMP_ALL.get_time) then
278: insert_end_time := dbms_utility.get_time();
279: --dbms_output.put_line ('Insert imp item master (' || nTop_Id || ') :' || (insert_end_time-end_time)/100.00);
280: end if;
281:
282:

Line 824: st_time := dbms_utility.get_time();

820:
821: nIndex := 1;
822:
823: if (CZ_IMP_ALL.get_time) then
824: st_time := dbms_utility.get_time();
825: end if;
826:
827: l_lang := userenv('LANG');
828:

Line 850: end_time := dbms_utility.get_time();

846: END IF;
847: END IF;
848:
849: if (CZ_IMP_ALL.get_time) then
850: end_time := dbms_utility.get_time();
851: d_str := inRun_Id || ' Extract ps structure (' || nTop_Id || ' - count - ' || componentItemId.COUNT || ' ) :' || (end_time-st_time)/100.00;
852: x_ERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
853: end if;
854:

Line 856: st_time := dbms_utility.get_time();

852: x_ERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
853: end if;
854:
855: if (CZ_IMP_ALL.get_time) then
856: st_time := dbms_utility.get_time();
857: end if;
858:
859: --dbms_output.put_line('COUNT IS:'||ComponentItemId.COUNT);
860: FOR i IN ComponentItemId.FIRST..ComponentItemId.LAST LOOP

Line 1319: end_time := dbms_utility.get_time();

1315: END IF;
1316: END LOOP;
1317:
1318: if (CZ_IMP_ALL.get_time) then
1319: end_time := dbms_utility.get_time();
1320: d_str := inRun_Id || ' loop ps structure (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
1321: x_error:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1322: end if;
1323:

Line 1325: st_time := dbms_utility.get_time();

1321: x_error:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1322: end if;
1323:
1324: if (CZ_IMP_ALL.get_time) then
1325: st_time := dbms_utility.get_time();
1326: end if;
1327:
1328:
1329:

Line 1398: end_time := dbms_utility.get_time();

1394: iSrcApplicationId(i), ifskItemMaster22(i), iIBLinkItemFlag(i),
1395: iShippableItemFlag(i), iInventoryTransactableFlag(i), iAssembleToOrder(i), iSerializableItemFlag(i)); -- changes for TSO
1396:
1397: if (CZ_IMP_ALL.get_time) then
1398: end_time := dbms_utility.get_time();
1399: d_str := inRun_Id || ' Insert ps nodes (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
1400: x_error:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1401: end if;
1402:

Line 1512: st_time := dbms_utility.get_time();

1508:
1509: BEGIN
1510:
1511: if (CZ_IMP_ALL.get_time) then
1512: st_time := dbms_utility.get_time();
1513: end if;
1514:
1515: OPEN c_onl_ps_node;
1516:

Line 1561: end_time := dbms_utility.get_time();

1557:
1558: END LOOP;
1559:
1560: if (CZ_IMP_ALL.get_time) then
1561: end_time := dbms_utility.get_time();
1562: d_str := inRun_Id || ' Deleted ps node check (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
1563: x_error:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1564: end if;
1565:

Line 1783: end_time := dbms_utility.get_time();

1779: END LOOP;
1780: END IF;
1781:
1782: if (CZ_IMP_ALL.get_time) then
1783: end_time := dbms_utility.get_time();
1784: d_str := inRun_Id || ' Extract text (' || nTop_Id || ' - Count - ' || iLocalizedStr.COUNT || ') :' || (end_time-st_time)/100.00;
1785: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1786: end if;
1787:

Line 1853: st_time := dbms_utility.get_time();

1849:
1850: BEGIN
1851: gModelItemId_tbl.delete;
1852: if (CZ_IMP_ALL.get_time) then
1853: st_time := dbms_utility.get_time();
1854: end if;
1855:
1856: l_lang := userenv('LANG');
1857:

Line 1869: end_time := dbms_utility.get_time();

1865: AND TOP_ITEM_ID=nTop_ID AND EXPLOSION_TYPE=sExpl_type
1866: AND language = l_lang;
1867:
1868: if (CZ_IMP_ALL.get_time) then
1869: end_time := dbms_utility.get_time();
1870: d_str := inRun_Id || ' Extract projects (' || nTop_Id || ' - Count - ' || OrganizationId.COUNT || ') :' || (end_time-st_time)/100.00;
1871: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1872: end if;
1873:

Line 1898: loop_end_time := dbms_utility.get_time();

1894: nIndex := nIndex + 1;
1895: END LOOP;
1896:
1897: if (CZ_IMP_ALL.get_time) then
1898: loop_end_time := dbms_utility.get_time();
1899: d_str := inRun_Id || ' Loop Projects (' || nTop_Id || ') :' || (loop_end_time-end_time)/100.00;
1900: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1901: end if;
1902:

Line 1914: insert_end_time := dbms_utility.get_time();

1910: inRun_ID, iName(i), iDescText(i), iDescText(i), iPlanLevel(i), nModelId, iModelType(i),
1911: iInventoryItemId(i), iProductKey(i), G_CAPTION_RULE_DESC, G_CAPTION_RULE_NAME, g_CONFIG_ENGINE_TYPE);
1912:
1913: if (CZ_IMP_ALL.get_time) then
1914: insert_end_time := dbms_utility.get_time();
1915: d_str := inRun_Id || ' Insert projects (' || nTop_Id || ') :' || (insert_end_time-loop_end_time)/100.00;
1916: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1917: end if;
1918:

Line 1949: st_time := dbms_utility.get_time();

1945: l_name_method VARCHAR2(255);
1946:
1947: BEGIN
1948: if (CZ_IMP_ALL.get_time) then
1949: st_time := dbms_utility.get_time();
1950: end if;
1951:
1952: fnd_profile.get('CZ_SEGS_FOR_ITEMTYPE_NAME', l_name_method);
1953:

Line 1977: end_time := dbms_utility.get_time();

1973: WHERE ITEM_CATALOG_GROUP_ID = itemCatalogGroupId(i);
1974: END IF;
1975:
1976: if (CZ_IMP_ALL.get_time) then
1977: end_time := dbms_utility.get_time();
1978: d_str := inRun_Id || ' Insert item type (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
1979: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1980: end if;
1981: COMMIT;

Line 2634: st_time := dbms_utility.get_time();

2630:
2631: BEGIN
2632:
2633: if (CZ_IMP_ALL.get_time) then
2634: st_time := dbms_utility.get_time();
2635: end if;
2636:
2637: FORALL i IN 1..itemCatalogGroupId.COUNT
2638: INSERT INTO CZ_IMP_PROPERTY

Line 2645: end_time := dbms_utility.get_time();

2641: FROM CZ_EXV_ITEM_PROPERTIES
2642: WHERE ITEM_CATALOG_GROUP_ID = itemCatalogGroupId(i);
2643:
2644: if (CZ_IMP_ALL.get_time) then
2645: end_time := dbms_utility.get_time();
2646: d_str := inRun_Id || ' Insert property (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2647: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2648: end if;
2649:

Line 2738: loop_end_time := dbms_utility.get_time();

2734: END IF;
2735: END LOOP;
2736: CLOSE C_DATATYPE;
2737: if (CZ_IMP_ALL.get_time) then
2738: loop_end_time := dbms_utility.get_time();
2739: d_str := inRun_Id || ' Resolve property datatype (' || nTop_Id || ') :' || (loop_end_time-end_time)/100.00;
2740: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2741: end if;
2742: EXCEPTION

Line 2772: st_time := dbms_utility.get_time();

2768:
2769: BEGIN
2770:
2771: if (CZ_IMP_ALL.get_time) then
2772: st_time := dbms_utility.get_time();
2773: end if;
2774:
2775: FORALL i IN 1..itemCatalogGroupId.COUNT
2776: INSERT INTO CZ_IMP_ITEM_TYPE_PROPERTY

Line 2785: end_time := dbms_utility.get_time();

2781: FROM CZ_EXV_ITEM_PROPERTIES
2782: WHERE ITEM_CATALOG_GROUP_ID = itemCatalogGroupId(i);
2783:
2784: if (CZ_IMP_ALL.get_time) then
2785: end_time := dbms_utility.get_time();
2786: d_str := inRun_Id || ' Insert item Type prop (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2787: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2788: end if;
2789:

Line 2820: st_time := dbms_utility.get_time();

2816:
2817: BEGIN
2818:
2819: if(CZ_IMP_ALL.get_time) then
2820: st_time := dbms_utility.get_time();
2821: end if;
2822:
2823: FORALL i IN 1..inventoryItemId.COUNT
2824: INSERT INTO CZ_IMP_ITEM_PROPERTY_VALUE

Line 2842: loop_end_time := dbms_utility.get_time();

2838: AND ORGANIZATION_ID = nOrg_ID
2839: AND ELEMENT_VALUE IS NOT NULL;
2840:
2841: if (CZ_IMP_ALL.get_time) then
2842: loop_end_time := dbms_utility.get_time();
2843: d_str := inRun_Id || ' Bulk collect prop val (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2844: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2845: end if;
2846:

Line 2878: st_time := dbms_utility.get_time();

2874: --DBMS_OUTPUT.ENABLE;
2875: --DBMS_OUTPUT.PUT_LINE('EXTRACTING TABLE: ' || lower_table_name);
2876: IF(lower_table_name='cz_item_masters') THEN
2877: if (CZ_IMP_ALL.get_time) then
2878: st_time := dbms_utility.get_time();
2879: end if;
2880: EXTR_ITEM_MASTER(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
2881: if (CZ_IMP_ALL.get_time) then
2882: end_time := dbms_utility.get_time();

Line 2882: end_time := dbms_utility.get_time();

2878: st_time := dbms_utility.get_time();
2879: end if;
2880: EXTR_ITEM_MASTER(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
2881: if (CZ_IMP_ALL.get_time) then
2882: end_time := dbms_utility.get_time();
2883: d_str := inRun_Id || ' Extract item master (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2884: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2885: end if;
2886: ELSIF(lower_table_name='cz_ps_nodes') THEN

Line 2888: st_time := dbms_utility.get_time();

2884: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2885: end if;
2886: ELSIF(lower_table_name='cz_ps_nodes') THEN
2887: if (CZ_IMP_ALL.get_time) then
2888: st_time := dbms_utility.get_time();
2889: end if;
2890: EXTR_PS_NODE(inRun_ID,nOrg_ID,nTop_ID,sExpl_type,nModelId);
2891: if (CZ_IMP_ALL.get_time) then
2892: end_time := dbms_utility.get_time();

Line 2892: end_time := dbms_utility.get_time();

2888: st_time := dbms_utility.get_time();
2889: end if;
2890: EXTR_PS_NODE(inRun_ID,nOrg_ID,nTop_ID,sExpl_type,nModelId);
2891: if (CZ_IMP_ALL.get_time) then
2892: end_time := dbms_utility.get_time();
2893: d_str :=inRun_Id || ' Extract ps structure (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2894: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2895: end if;
2896: ELSIF(lower_table_name='cz_localized_texts') THEN

Line 2898: st_time := dbms_utility.get_time();

2894: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2895: end if;
2896: ELSIF(lower_table_name='cz_localized_texts') THEN
2897: if (CZ_IMP_ALL.get_time) then
2898: st_time := dbms_utility.get_time();
2899: end if;
2900: EXTR_INTL_TEXT(inRun_ID,nOrg_ID,nTop_ID,sExpl_type,nModelId);
2901: if (CZ_IMP_ALL.get_time) then
2902: end_time := dbms_utility.get_time();

Line 2902: end_time := dbms_utility.get_time();

2898: st_time := dbms_utility.get_time();
2899: end if;
2900: EXTR_INTL_TEXT(inRun_ID,nOrg_ID,nTop_ID,sExpl_type,nModelId);
2901: if (CZ_IMP_ALL.get_time) then
2902: end_time := dbms_utility.get_time();
2903: d_str := inRun_Id || ' Extract intl text (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2904: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2905: end if;
2906: ELSIF(lower_table_name='cz_devl_projects') THEN

Line 2908: st_time := dbms_utility.get_time();

2904: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2905: end if;
2906: ELSIF(lower_table_name='cz_devl_projects') THEN
2907: if (CZ_IMP_ALL.get_time) then
2908: st_time := dbms_utility.get_time();
2909: end if;
2910: EXTR_DEVL_PROJECT(inRun_ID,nOrg_ID,nTop_ID,sExpl_type,nModelId);
2911: if (CZ_IMP_ALL.get_time) then
2912: end_time := dbms_utility.get_time();

Line 2912: end_time := dbms_utility.get_time();

2908: st_time := dbms_utility.get_time();
2909: end if;
2910: EXTR_DEVL_PROJECT(inRun_ID,nOrg_ID,nTop_ID,sExpl_type,nModelId);
2911: if (CZ_IMP_ALL.get_time) then
2912: end_time := dbms_utility.get_time();
2913: d_str := inRun_Id || ' Extract devl project (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2914: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2915: end if;
2916: ELSIF(lower_table_name='cz_item_types') THEN

Line 2918: st_time := dbms_utility.get_time();

2914: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2915: end if;
2916: ELSIF(lower_table_name='cz_item_types') THEN
2917: if (CZ_IMP_ALL.get_time) then
2918: st_time := dbms_utility.get_time();
2919: end if;
2920: EXTR_ITEM_TYPES(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
2921: if (CZ_IMP_ALL.get_time) then
2922: end_time := dbms_utility.get_time();

Line 2922: end_time := dbms_utility.get_time();

2918: st_time := dbms_utility.get_time();
2919: end if;
2920: EXTR_ITEM_TYPES(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
2921: if (CZ_IMP_ALL.get_time) then
2922: end_time := dbms_utility.get_time();
2923: d_str := inRun_Id || ' Extract item types (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2924: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2925: end if;
2926: ELSIF(lower_table_name='cz_properties') THEN

Line 2928: st_time := dbms_utility.get_time();

2924: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2925: end if;
2926: ELSIF(lower_table_name='cz_properties') THEN
2927: if (CZ_IMP_ALL.get_time) then
2928: st_time := dbms_utility.get_time();
2929: end if;
2930: EXTR_PROPERTIES(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
2931:
2932: EXTR_APC_PROPERTIES(p_run_id => inRun_ID,

Line 2938: end_time := dbms_utility.get_time();

2934: p_top_item_id => nTop_ID,
2935: p_expl_type => sExpl_type);
2936:
2937: if (CZ_IMP_ALL.get_time) then
2938: end_time := dbms_utility.get_time();
2939: d_str := inRun_Id || ' Extract property (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2940: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2941: end if;
2942: ELSIF(lower_table_name='cz_item_type_properties') THEN

Line 2944: st_time := dbms_utility.get_time();

2940: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2941: end if;
2942: ELSIF(lower_table_name='cz_item_type_properties') THEN
2943: if (CZ_IMP_ALL.get_time) then
2944: st_time := dbms_utility.get_time();
2945: end if;
2946: EXTR_ITEM_TYPE_PROPERTIES(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
2947: if (CZ_IMP_ALL.get_time) then
2948: end_time := dbms_utility.get_time();

Line 2948: end_time := dbms_utility.get_time();

2944: st_time := dbms_utility.get_time();
2945: end if;
2946: EXTR_ITEM_TYPE_PROPERTIES(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
2947: if (CZ_IMP_ALL.get_time) then
2948: end_time := dbms_utility.get_time();
2949: d_str := inRun_Id || ' Extract item type property (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2950: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2951: end if;
2952: ELSIF(lower_table_name='cz_item_property_values') THEN

Line 2954: st_time := dbms_utility.get_time();

2950: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2951: end if;
2952: ELSIF(lower_table_name='cz_item_property_values') THEN
2953: if (CZ_IMP_ALL.get_time) then
2954: st_time := dbms_utility.get_time();
2955: end if;
2956: EXTR_ITEM_PROPERTY_VALUES(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
2957: if (CZ_IMP_ALL.get_time) then
2958: end_time := dbms_utility.get_time();

Line 2958: end_time := dbms_utility.get_time();

2954: st_time := dbms_utility.get_time();
2955: end if;
2956: EXTR_ITEM_PROPERTY_VALUES(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
2957: if (CZ_IMP_ALL.get_time) then
2958: end_time := dbms_utility.get_time();
2959: d_str := inRun_Id || ' Extract item property value (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2960: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2961: end if;
2962: ELSE

Line 2990: st_time := dbms_utility.get_time();

2986: --DBMS_OUTPUT.ENABLE;
2987: --DBMS_OUTPUT.PUT_LINE('IMPORTING TABLE: ' || lower_table_name);
2988: IF(lower_table_name='cz_item_masters') THEN
2989: if (CZ_IMP_ALL.get_time) then
2990: st_time := dbms_utility.get_time();
2991: end if;
2992: CZ_IMP_IM_MAIN.MAIN_ITEM_MASTER(inRun_ID, commit_size, max_err,
2993: Inserts, Updates, x_failed, Dups, inXFR_GROUP);
2994: if (CZ_IMP_ALL.get_time) then

Line 2995: end_time := dbms_utility.get_time();

2991: end if;
2992: CZ_IMP_IM_MAIN.MAIN_ITEM_MASTER(inRun_ID, commit_size, max_err,
2993: Inserts, Updates, x_failed, Dups, inXFR_GROUP);
2994: if (CZ_IMP_ALL.get_time) then
2995: end_time := dbms_utility.get_time();
2996: d_str := inRun_Id || ' Populate items :' || (end_time-st_time)/100.00;
2997: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
2998: end if;
2999: ELSIF(lower_table_name='cz_ps_nodes') THEN

Line 3001: st_time := dbms_utility.get_time();

2997: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
2998: end if;
2999: ELSIF(lower_table_name='cz_ps_nodes') THEN
3000: if (CZ_IMP_ALL.get_time) then
3001: st_time := dbms_utility.get_time();
3002: end if;
3003: CZ_IMP_PS_NODE.MAIN_PS_NODE(inRun_ID, commit_size, max_err,
3004: Inserts, Updates, x_failed, Dups, inXFR_GROUP);
3005: if (CZ_IMP_ALL.get_time) then

Line 3006: end_time := dbms_utility.get_time();

3002: end if;
3003: CZ_IMP_PS_NODE.MAIN_PS_NODE(inRun_ID, commit_size, max_err,
3004: Inserts, Updates, x_failed, Dups, inXFR_GROUP);
3005: if (CZ_IMP_ALL.get_time) then
3006: end_time := dbms_utility.get_time();
3007: d_str := inRun_Id || ' Populate product structure :' || (end_time-st_time)/100.00;
3008: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3009: end if;
3010: ELSIF(lower_table_name='cz_localized_texts') THEN

Line 3012: st_time := dbms_utility.get_time();

3008: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3009: end if;
3010: ELSIF(lower_table_name='cz_localized_texts') THEN
3011: if (CZ_IMP_ALL.get_time) then
3012: st_time := dbms_utility.get_time();
3013: end if;
3014: CZ_IMP_PS_NODE.MAIN_INTL_TEXT(inRun_ID, commit_size, max_err,
3015: Inserts, Updates, x_failed, Dups, inXFR_GROUP);
3016: if (CZ_IMP_ALL.get_time) then

Line 3017: end_time := dbms_utility.get_time();

3013: end if;
3014: CZ_IMP_PS_NODE.MAIN_INTL_TEXT(inRun_ID, commit_size, max_err,
3015: Inserts, Updates, x_failed, Dups, inXFR_GROUP);
3016: if (CZ_IMP_ALL.get_time) then
3017: end_time := dbms_utility.get_time();
3018: d_str := inRun_Id || ' Populate intl text :' || (end_time-st_time)/100.00;
3019: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3020: end if;
3021: ELSIF(lower_table_name='cz_devl_projects') THEN

Line 3023: st_time := dbms_utility.get_time();

3019: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3020: end if;
3021: ELSIF(lower_table_name='cz_devl_projects') THEN
3022: if (CZ_IMP_ALL.get_time) then
3023: st_time := dbms_utility.get_time();
3024: end if;
3025: CZ_IMP_PS_NODE.MAIN_DEVL_PROJECT(inRun_ID, commit_size, max_err,
3026: Inserts, Updates, x_failed, Dups,
3027: inXFR_GROUP,p_rp_folder_id);

Line 3029: end_time := dbms_utility.get_time();

3025: CZ_IMP_PS_NODE.MAIN_DEVL_PROJECT(inRun_ID, commit_size, max_err,
3026: Inserts, Updates, x_failed, Dups,
3027: inXFR_GROUP,p_rp_folder_id);
3028: if (CZ_IMP_ALL.get_time) then
3029: end_time := dbms_utility.get_time();
3030: d_str := inRun_Id || ' Populate project :' || (end_time-st_time)/100.00;
3031: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3032: end if;
3033: ELSIF(lower_table_name='cz_item_property_values') THEN

Line 3035: st_time := dbms_utility.get_time();

3031: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3032: end if;
3033: ELSIF(lower_table_name='cz_item_property_values') THEN
3034: if (CZ_IMP_ALL.get_time) then
3035: st_time := dbms_utility.get_time();
3036: end if;
3037: CZ_IMP_IM_MAIN.MAIN_ITEM_PROPERTY_VALUE(inRun_ID, commit_size, max_err,
3038: Inserts, Updates, x_failed, Dups, inXFR_GROUP);
3039: if (CZ_IMP_ALL.get_time) then

Line 3040: end_time := dbms_utility.get_time();

3036: end if;
3037: CZ_IMP_IM_MAIN.MAIN_ITEM_PROPERTY_VALUE(inRun_ID, commit_size, max_err,
3038: Inserts, Updates, x_failed, Dups, inXFR_GROUP);
3039: if (CZ_IMP_ALL.get_time) then
3040: end_time := dbms_utility.get_time();
3041: d_str := inRun_Id || ' Populate item property val :' || (end_time-st_time)/100.00;
3042: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3043: end if;
3044: ELSIF(lower_table_name='cz_item_types') THEN

Line 3046: st_time := dbms_utility.get_time();

3042: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3043: end if;
3044: ELSIF(lower_table_name='cz_item_types') THEN
3045: if (CZ_IMP_ALL.get_time) then
3046: st_time := dbms_utility.get_time();
3047: end if;
3048: CZ_IMP_IM_MAIN.MAIN_ITEM_TYPE(inRun_ID, commit_size, max_err,
3049: Inserts, Updates, x_failed, Dups, inXFR_GROUP);
3050: if (CZ_IMP_ALL.get_time) then

Line 3051: end_time := dbms_utility.get_time();

3047: end if;
3048: CZ_IMP_IM_MAIN.MAIN_ITEM_TYPE(inRun_ID, commit_size, max_err,
3049: Inserts, Updates, x_failed, Dups, inXFR_GROUP);
3050: if (CZ_IMP_ALL.get_time) then
3051: end_time := dbms_utility.get_time();
3052: d_str := inRun_Id || ' Populate item type :' || (end_time-st_time)/100.00;
3053: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3054: end if;
3055: ELSIF(lower_table_name='cz_item_type_properties') THEN

Line 3057: st_time := dbms_utility.get_time();

3053: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3054: end if;
3055: ELSIF(lower_table_name='cz_item_type_properties') THEN
3056: if (CZ_IMP_ALL.get_time) then
3057: st_time := dbms_utility.get_time();
3058: end if;
3059: CZ_IMP_IM_MAIN.MAIN_ITEM_TYPE_PROPERTY(inRun_ID, commit_size, max_err,
3060: Inserts, Updates, x_failed, Dups, inXFR_GROUP);
3061: if (CZ_IMP_ALL.get_time) then

Line 3062: end_time := dbms_utility.get_time();

3058: end if;
3059: CZ_IMP_IM_MAIN.MAIN_ITEM_TYPE_PROPERTY(inRun_ID, commit_size, max_err,
3060: Inserts, Updates, x_failed, Dups, inXFR_GROUP);
3061: if (CZ_IMP_ALL.get_time) then
3062: end_time := dbms_utility.get_time();
3063: d_str := inRun_Id || ' Populate item type property :' || (end_time-st_time)/100.00;
3064: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3065: end if;
3066: ELSIF(lower_table_name='cz_properties') THEN

Line 3068: st_time := dbms_utility.get_time();

3064: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3065: end if;
3066: ELSIF(lower_table_name='cz_properties') THEN
3067: if (CZ_IMP_ALL.get_time) then
3068: st_time := dbms_utility.get_time();
3069: end if;
3070: CZ_IMP_IM_MAIN.MAIN_PROPERTY(inRun_ID, commit_size, max_err,
3071: Inserts, Updates, x_failed, Dups, inXFR_GROUP, p_rp_folder_id);
3072: if (CZ_IMP_ALL.get_time) then

Line 3073: end_time := dbms_utility.get_time();

3069: end if;
3070: CZ_IMP_IM_MAIN.MAIN_PROPERTY(inRun_ID, commit_size, max_err,
3071: Inserts, Updates, x_failed, Dups, inXFR_GROUP, p_rp_folder_id);
3072: if (CZ_IMP_ALL.get_time) then
3073: end_time := dbms_utility.get_time();
3074: d_str := inRun_Id || ' Populate property :' || (end_time-st_time)/100.00;
3075: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3076: end if;
3077: ELSE

Line 3282: bom_explode_st := dbms_utility.get_time();

3278: END IF;
3279: END IF;
3280:
3281: if (CZ_IMP_ALL.get_time) then
3282: bom_explode_st := dbms_utility.get_time();
3283: end if;
3284:
3285: IF((inRunExploder = 1) and (NOT(GET_REMOTE_IMPORT))) THEN
3286:

Line 3341: bom_explode_end := dbms_utility.get_time();

3337: END;
3338: END IF;
3339:
3340: if (CZ_IMP_ALL.get_time) then
3341: bom_explode_end := dbms_utility.get_time();
3342: d_str := inRunId || ' Bom Exploder (' || inTopId || ') :' || (bom_explode_end-bom_explode_st)/100.00;
3343: xERROR:=cz_utils.log_report(d_str,1,'BOM_EXPLODER',11299,inRunId);
3344: end if;
3345:

Line 3669: extract_st := dbms_utility.get_time();

3665: FETCH C_BILL_OF_MATERIAL INTO cFound;
3666: IF(C_BILL_OF_MATERIAL%FOUND)THEN
3667:
3668: if (CZ_IMP_ALL.get_time) then
3669: extract_st := dbms_utility.get_time();
3670: end if;
3671:
3672: -- Clear processed_expl_tbl before and after ps node extraction.
3673: processed_expls_tbl.DELETE;

Line 3701: extract_end := dbms_utility.get_time();

3697: END IF;
3698: END LOOP;
3699:
3700: if (CZ_IMP_ALL.get_time) then
3701: extract_end := dbms_utility.get_time();
3702: d_str := genRun_Id || ' EXTRACT PS - TOTAL (' || nTop_Id || ') :' || (extract_end-extract_st)/100.00;
3703: xERROR:=cz_utils.log_report(d_str,1,'EXTRACT_PS_NODE',11299,genRun_ID);
3704: end if;
3705:

Line 3754: st_time := dbms_utility.get_time();

3750: repItemId.DELETE;
3751: hashCatalog.DELETE;
3752:
3753: if (CZ_IMP_ALL.get_time) then
3754: st_time := dbms_utility.get_time();
3755: end if;
3756:
3757: l_lang := userenv('LANG');
3758:

Line 3799: end_time := dbms_utility.get_time();

3795: xERROR:=cz_utils.log_report(SQLERRM,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL.CATALOG',11276,genRun_ID);
3796: END;
3797:
3798: if (CZ_IMP_ALL.get_time) then
3799: end_time := dbms_utility.get_time();
3800: d_str := genRun_Id ||' Collect Catalog group id (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
3801: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,genRun_ID);
3802: end if;
3803: