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.

APPS.CZ_IMP_SINGLE dependencies on DBMS_UTILITY

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

206: FETCH C_REF_PART_NBR INTO DFLT_REFPARTNBR;
207: CLOSE C_REF_PART_NBR;
208:
209: if (CZ_IMP_ALL.get_time) then
210: st_time := dbms_utility.get_time();
211: end if;
212:
213: SELECT DISTINCT INVENTORY_ITEM_ID, ORGANIZATION_ID, SEGMENT1, CONCATENATED_SEGMENTS, ITEM_DESC,
214: FIXED_LEAD_TIME, BOM_ITEM_TYPE, CUSTOMER_ORDER_ENABLED_FLAG,

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

223: WHERE ORGANIZATION_ID=nOrg_ID AND TOP_ITEM_ID=nTop_ID
224: AND EXPLOSION_TYPE=sExpl_type;
225:
226: if (CZ_IMP_ALL.get_time) then
227: end_time := dbms_utility.get_time();
228: d_str := inRun_Id || ' Bulk collect item master (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
229: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_id);
230: end if;
231:

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

279: nIndex := nIndex + 1;
280: END LOOP;
281:
282: if (CZ_IMP_ALL.get_time) then
283: loop_end_time := dbms_utility.get_time();
284: --dbms_output.put_line ('loop over coll. (' || nTop_Id || ') :' || (loop_end_time-end_time)/100.00);
285: end if;
286:
287: FORALL i IN 1..iOrigSysRef.COUNT

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

298: iFskItemType(i), iFskItemType(i),
299: iSrcApplicationId(i), iSrcTypeCode(i));
300:
301: if (CZ_IMP_ALL.get_time) then
302: insert_end_time := dbms_utility.get_time();
303: --dbms_output.put_line ('Insert imp item master (' || nTop_Id || ') :' || (insert_end_time-end_time)/100.00);
304: end if;
305:
306:

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

847:
848: nIndex := 1;
849:
850: if (CZ_IMP_ALL.get_time) then
851: st_time := dbms_utility.get_time();
852: end if;
853:
854: l_lang := userenv('LANG');
855:

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

873: END IF;
874: END IF;
875:
876: if (CZ_IMP_ALL.get_time) then
877: end_time := dbms_utility.get_time();
878: d_str := inRun_Id || ' Extract ps structure (' || nTop_Id || ' - count - ' || componentItemId.COUNT || ' ) :' || (end_time-st_time)/100.00;
879: x_ERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
880: end if;
881:

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

879: x_ERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
880: end if;
881:
882: if (CZ_IMP_ALL.get_time) then
883: st_time := dbms_utility.get_time();
884: end if;
885:
886: --DBMS_OUTPUT.PUT_LINE('COUNT IS:'||ComponentItemId.COUNT);
887: FOR i IN ComponentItemId.FIRST..ComponentItemId.LAST LOOP

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

1342: END IF;
1343: END LOOP;
1344:
1345: if (CZ_IMP_ALL.get_time) then
1346: end_time := dbms_utility.get_time();
1347: d_str := inRun_Id || ' loop ps structure (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
1348: x_error:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1349: end if;
1350:

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

1348: x_error:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1349: end if;
1350:
1351: if (CZ_IMP_ALL.get_time) then
1352: st_time := dbms_utility.get_time();
1353: end if;
1354:
1355:
1356:

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

1421: iSrcApplicationId(i), ifskItemMaster22(i), iIBLinkItemFlag(i),
1422: iShippableItemFlag(i), iInventoryTransactableFlag(i), iAssembleToOrder(i), iSerializableItemFlag(i)); -- changes for TSO
1423:
1424: if (CZ_IMP_ALL.get_time) then
1425: end_time := dbms_utility.get_time();
1426: d_str := inRun_Id || ' Insert ps nodes (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
1427: x_error:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1428: end if;
1429:

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

1480: fnd_stats.gather_table_stats('CZ', 'CZ_XFR_PROJECT_BILLS');
1481: x_error:=cz_utils.log_report('Gather Stats : End',1,'EXTRACTION',11299,inRun_Id);
1482:
1483: if (CZ_IMP_ALL.get_time) then
1484: end_time := dbms_utility.get_time();
1485: d_str := inRun_Id || ' Gather Stats :' || (end_time-st_time)/100.00;
1486: x_error:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1487: end if;
1488: END IF;

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

1570:
1571: BEGIN
1572:
1573: if (CZ_IMP_ALL.get_time) then
1574: st_time := dbms_utility.get_time();
1575: end if;
1576:
1577: OPEN c_onl_ps_node;
1578:

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

1619:
1620: END LOOP;
1621:
1622: if (CZ_IMP_ALL.get_time) then
1623: end_time := dbms_utility.get_time();
1624: d_str := inRun_Id || ' Deleted ps node check (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
1625: x_error:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1626: end if;
1627:

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

1841: END LOOP;
1842: END IF;
1843:
1844: if (CZ_IMP_ALL.get_time) then
1845: end_time := dbms_utility.get_time();
1846: d_str := inRun_Id || ' Extract text (' || nTop_Id || ' - Count - ' || iLocalizedStr.COUNT || ') :' || (end_time-st_time)/100.00;
1847: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1848: end if;
1849:

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

1911:
1912: BEGIN
1913: gModelItemId_tbl.delete;
1914: if (CZ_IMP_ALL.get_time) then
1915: st_time := dbms_utility.get_time();
1916: end if;
1917:
1918: l_lang := userenv('LANG');
1919:

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

1927: AND TOP_ITEM_ID=nTop_ID AND EXPLOSION_TYPE=sExpl_type
1928: AND language = l_lang;
1929:
1930: if (CZ_IMP_ALL.get_time) then
1931: end_time := dbms_utility.get_time();
1932: d_str := inRun_Id || ' Extract projects (' || nTop_Id || ' - Count - ' || OrganizationId.COUNT || ') :' || (end_time-st_time)/100.00;
1933: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1934: end if;
1935:

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

1956: nIndex := nIndex + 1;
1957: END LOOP;
1958:
1959: if (CZ_IMP_ALL.get_time) then
1960: loop_end_time := dbms_utility.get_time();
1961: d_str := inRun_Id || ' Loop Projects (' || nTop_Id || ') :' || (loop_end_time-end_time)/100.00;
1962: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1963: end if;
1964:

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

1972: inRun_ID, iName(i), iDescText(i), iDescText(i), iPlanLevel(i), nModelId, iModelType(i),
1973: iInventoryItemId(i), iProductKey(i), G_CAPTION_RULE_DESC, G_CAPTION_RULE_NAME, g_CONFIG_ENGINE_TYPE);
1974:
1975: if (CZ_IMP_ALL.get_time) then
1976: insert_end_time := dbms_utility.get_time();
1977: d_str := inRun_Id || ' Insert projects (' || nTop_Id || ') :' || (insert_end_time-loop_end_time)/100.00;
1978: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1979: end if;
1980:

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

2007: l_name_method VARCHAR2(255);
2008:
2009: BEGIN
2010: if (CZ_IMP_ALL.get_time) then
2011: st_time := dbms_utility.get_time();
2012: end if;
2013:
2014: fnd_profile.get('CZ_SEGS_FOR_ITEMTYPE_NAME', l_name_method);
2015:

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

2035: WHERE ITEM_CATALOG_GROUP_ID = itemCatalogGroupId(i);
2036: END IF;
2037:
2038: if (CZ_IMP_ALL.get_time) then
2039: end_time := dbms_utility.get_time();
2040: d_str := inRun_Id || ' Insert item type (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2041: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2042: end if;
2043: COMMIT;

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

2700:
2701: BEGIN
2702:
2703: if (CZ_IMP_ALL.get_time) then
2704: st_time := dbms_utility.get_time();
2705: end if;
2706:
2707: FORALL i IN 1..itemCatalogGroupId.COUNT
2708: INSERT INTO CZ_IMP_PROPERTY

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

2711: FROM CZ_EXV_ITEM_PROPERTIES
2712: WHERE ITEM_CATALOG_GROUP_ID = itemCatalogGroupId(i);
2713:
2714: if (CZ_IMP_ALL.get_time) then
2715: end_time := dbms_utility.get_time();
2716: d_str := inRun_Id || ' Insert property (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2717: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2718: end if;
2719:

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

2804: END IF;
2805: END LOOP;
2806: CLOSE C_DATATYPE;
2807: if (CZ_IMP_ALL.get_time) then
2808: loop_end_time := dbms_utility.get_time();
2809: d_str := inRun_Id || ' Resolve property datatype (' || nTop_Id || ') :' || (loop_end_time-end_time)/100.00;
2810: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2811: end if;
2812: EXCEPTION

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

2838:
2839: BEGIN
2840:
2841: if (CZ_IMP_ALL.get_time) then
2842: st_time := dbms_utility.get_time();
2843: end if;
2844:
2845: FORALL i IN 1..itemCatalogGroupId.COUNT
2846: INSERT INTO CZ_IMP_ITEM_TYPE_PROPERTY

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

2851: FROM CZ_EXV_ITEM_PROPERTIES
2852: WHERE ITEM_CATALOG_GROUP_ID = itemCatalogGroupId(i);
2853:
2854: if (CZ_IMP_ALL.get_time) then
2855: end_time := dbms_utility.get_time();
2856: d_str := inRun_Id || ' Insert item Type prop (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2857: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2858: end if;
2859:

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

2886:
2887: BEGIN
2888:
2889: if(CZ_IMP_ALL.get_time) then
2890: st_time := dbms_utility.get_time();
2891: end if;
2892:
2893: FORALL i IN 1..inventoryItemId.COUNT
2894: INSERT INTO CZ_IMP_ITEM_PROPERTY_VALUE

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

2908: AND ORGANIZATION_ID = nOrg_ID
2909: AND ELEMENT_VALUE IS NOT NULL;
2910:
2911: if (CZ_IMP_ALL.get_time) then
2912: loop_end_time := dbms_utility.get_time();
2913: d_str := inRun_Id || ' Bulk collect prop val (' || 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:

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

2944: --DBMS_OUTPUT.ENABLE;
2945: --DBMS_OUTPUT.PUT_LINE('EXTRACTING TABLE: ' || lower_table_name);
2946: IF(lower_table_name='cz_item_masters') THEN
2947: if (CZ_IMP_ALL.get_time) then
2948: st_time := dbms_utility.get_time();
2949: end if;
2950: EXTR_ITEM_MASTER(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
2951: if (CZ_IMP_ALL.get_time) then
2952: end_time := dbms_utility.get_time();

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

2948: st_time := dbms_utility.get_time();
2949: end if;
2950: EXTR_ITEM_MASTER(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
2951: if (CZ_IMP_ALL.get_time) then
2952: end_time := dbms_utility.get_time();
2953: d_str := inRun_Id || ' Extract item master (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2954: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2955: end if;
2956: ELSIF(lower_table_name='cz_ps_nodes') THEN

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

2954: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2955: end if;
2956: ELSIF(lower_table_name='cz_ps_nodes') THEN
2957: if (CZ_IMP_ALL.get_time) then
2958: st_time := dbms_utility.get_time();
2959: end if;
2960: EXTR_PS_NODE(inRun_ID,nOrg_ID,nTop_ID,sExpl_type,nModelId);
2961: if (CZ_IMP_ALL.get_time) then
2962: end_time := dbms_utility.get_time();

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

2958: st_time := dbms_utility.get_time();
2959: end if;
2960: EXTR_PS_NODE(inRun_ID,nOrg_ID,nTop_ID,sExpl_type,nModelId);
2961: if (CZ_IMP_ALL.get_time) then
2962: end_time := dbms_utility.get_time();
2963: d_str :=inRun_Id || ' Extract ps structure (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2964: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2965: end if;
2966: ELSIF(lower_table_name='cz_localized_texts') THEN

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

2964: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2965: end if;
2966: ELSIF(lower_table_name='cz_localized_texts') THEN
2967: if (CZ_IMP_ALL.get_time) then
2968: st_time := dbms_utility.get_time();
2969: end if;
2970: EXTR_INTL_TEXT(inRun_ID,nOrg_ID,nTop_ID,sExpl_type,nModelId);
2971: if (CZ_IMP_ALL.get_time) then
2972: end_time := dbms_utility.get_time();

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

2968: st_time := dbms_utility.get_time();
2969: end if;
2970: EXTR_INTL_TEXT(inRun_ID,nOrg_ID,nTop_ID,sExpl_type,nModelId);
2971: if (CZ_IMP_ALL.get_time) then
2972: end_time := dbms_utility.get_time();
2973: d_str := inRun_Id || ' Extract intl text (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2974: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2975: end if;
2976: ELSIF(lower_table_name='cz_devl_projects') THEN

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

2974: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2975: end if;
2976: ELSIF(lower_table_name='cz_devl_projects') THEN
2977: if (CZ_IMP_ALL.get_time) then
2978: st_time := dbms_utility.get_time();
2979: end if;
2980: EXTR_DEVL_PROJECT(inRun_ID,nOrg_ID,nTop_ID,sExpl_type,nModelId);
2981: if (CZ_IMP_ALL.get_time) then
2982: end_time := dbms_utility.get_time();

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

2978: st_time := dbms_utility.get_time();
2979: end if;
2980: EXTR_DEVL_PROJECT(inRun_ID,nOrg_ID,nTop_ID,sExpl_type,nModelId);
2981: if (CZ_IMP_ALL.get_time) then
2982: end_time := dbms_utility.get_time();
2983: d_str := inRun_Id || ' Extract devl project (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2984: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2985: end if;
2986: ELSIF(lower_table_name='cz_item_types') THEN

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

2984: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2985: end if;
2986: ELSIF(lower_table_name='cz_item_types') THEN
2987: if (CZ_IMP_ALL.get_time) then
2988: st_time := dbms_utility.get_time();
2989: end if;
2990: EXTR_ITEM_TYPES(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
2991: if (CZ_IMP_ALL.get_time) then
2992: end_time := dbms_utility.get_time();

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

2988: st_time := dbms_utility.get_time();
2989: end if;
2990: EXTR_ITEM_TYPES(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
2991: if (CZ_IMP_ALL.get_time) then
2992: end_time := dbms_utility.get_time();
2993: d_str := inRun_Id || ' Extract item types (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2994: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2995: end if;
2996: ELSIF(lower_table_name='cz_properties') THEN

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

2994: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2995: end if;
2996: ELSIF(lower_table_name='cz_properties') THEN
2997: if (CZ_IMP_ALL.get_time) then
2998: st_time := dbms_utility.get_time();
2999: end if;
3000: EXTR_PROPERTIES(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
3001:
3002: EXTR_APC_PROPERTIES(p_run_id => inRun_ID,

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

3004: p_top_item_id => nTop_ID,
3005: p_expl_type => sExpl_type);
3006:
3007: if (CZ_IMP_ALL.get_time) then
3008: end_time := dbms_utility.get_time();
3009: d_str := inRun_Id || ' Extract property (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
3010: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
3011: end if;
3012: ELSIF(lower_table_name='cz_item_type_properties') THEN

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

3010: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
3011: end if;
3012: ELSIF(lower_table_name='cz_item_type_properties') THEN
3013: if (CZ_IMP_ALL.get_time) then
3014: st_time := dbms_utility.get_time();
3015: end if;
3016: EXTR_ITEM_TYPE_PROPERTIES(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
3017: if (CZ_IMP_ALL.get_time) then
3018: end_time := dbms_utility.get_time();

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

3014: st_time := dbms_utility.get_time();
3015: end if;
3016: EXTR_ITEM_TYPE_PROPERTIES(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
3017: if (CZ_IMP_ALL.get_time) then
3018: end_time := dbms_utility.get_time();
3019: d_str := inRun_Id || ' Extract item type property (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
3020: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
3021: end if;
3022: ELSIF(lower_table_name='cz_item_property_values') THEN

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

3020: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
3021: end if;
3022: ELSIF(lower_table_name='cz_item_property_values') THEN
3023: if (CZ_IMP_ALL.get_time) then
3024: st_time := dbms_utility.get_time();
3025: end if;
3026: EXTR_ITEM_PROPERTY_VALUES(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
3027: if (CZ_IMP_ALL.get_time) then
3028: end_time := dbms_utility.get_time();

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

3024: st_time := dbms_utility.get_time();
3025: end if;
3026: EXTR_ITEM_PROPERTY_VALUES(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);
3027: if (CZ_IMP_ALL.get_time) then
3028: end_time := dbms_utility.get_time();
3029: d_str := inRun_Id || ' Extract item property value (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
3030: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
3031: end if;
3032: ELSE

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

3057: --DBMS_OUTPUT.ENABLE;
3058: --DBMS_OUTPUT.PUT_LINE('IMPORTING TABLE: ' || lower_table_name);
3059: IF(lower_table_name='cz_item_masters') THEN
3060: if (CZ_IMP_ALL.get_time) then
3061: st_time := dbms_utility.get_time();
3062: end if;
3063: CZ_IMP_IM_MAIN.MAIN_ITEM_MASTER(inRun_ID, commit_size, max_err,
3064: Inserts, Updates, x_failed, Dups,NoChange, inXFR_GROUP);
3065: if (CZ_IMP_ALL.get_time) then

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

3062: end if;
3063: CZ_IMP_IM_MAIN.MAIN_ITEM_MASTER(inRun_ID, commit_size, max_err,
3064: Inserts, Updates, x_failed, Dups,NoChange, inXFR_GROUP);
3065: if (CZ_IMP_ALL.get_time) then
3066: end_time := dbms_utility.get_time();
3067: d_str := inRun_Id || ' Populate items :' || (end_time-st_time)/100.00;
3068: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3069: end if;
3070: ELSIF(lower_table_name='cz_ps_nodes') THEN

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

3068: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3069: end if;
3070: ELSIF(lower_table_name='cz_ps_nodes') THEN
3071: if (CZ_IMP_ALL.get_time) then
3072: st_time := dbms_utility.get_time();
3073: end if;
3074: CZ_IMP_PS_NODE.MAIN_PS_NODE(inRun_ID, commit_size, max_err,
3075: Inserts, Updates, x_failed, Dups, NoChange,inXFR_GROUP);
3076: if (CZ_IMP_ALL.get_time) then

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

3073: end if;
3074: CZ_IMP_PS_NODE.MAIN_PS_NODE(inRun_ID, commit_size, max_err,
3075: Inserts, Updates, x_failed, Dups, NoChange,inXFR_GROUP);
3076: if (CZ_IMP_ALL.get_time) then
3077: end_time := dbms_utility.get_time();
3078: d_str := inRun_Id || ' Populate product structure :' || (end_time-st_time)/100.00;
3079: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3080: end if;
3081: ELSIF(lower_table_name='cz_localized_texts') THEN

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

3079: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3080: end if;
3081: ELSIF(lower_table_name='cz_localized_texts') THEN
3082: if (CZ_IMP_ALL.get_time) then
3083: st_time := dbms_utility.get_time();
3084: end if;
3085: CZ_IMP_PS_NODE.MAIN_INTL_TEXT(inRun_ID, commit_size, max_err,
3086: Inserts, Updates, x_failed, Dups, NoChange,inXFR_GROUP);
3087: if (CZ_IMP_ALL.get_time) then

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

3084: end if;
3085: CZ_IMP_PS_NODE.MAIN_INTL_TEXT(inRun_ID, commit_size, max_err,
3086: Inserts, Updates, x_failed, Dups, NoChange,inXFR_GROUP);
3087: if (CZ_IMP_ALL.get_time) then
3088: end_time := dbms_utility.get_time();
3089: d_str := inRun_Id || ' Populate intl text :' || (end_time-st_time)/100.00;
3090: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3091: end if;
3092: ELSIF(lower_table_name='cz_devl_projects') THEN

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

3090: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3091: end if;
3092: ELSIF(lower_table_name='cz_devl_projects') THEN
3093: if (CZ_IMP_ALL.get_time) then
3094: st_time := dbms_utility.get_time();
3095: end if;
3096: CZ_IMP_PS_NODE.MAIN_DEVL_PROJECT(inRun_ID, commit_size, max_err,
3097: Inserts, Updates, x_failed, Dups,NoChange,
3098: inXFR_GROUP,p_rp_folder_id, g_CONFIG_ENGINE_TYPE);

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

3096: CZ_IMP_PS_NODE.MAIN_DEVL_PROJECT(inRun_ID, commit_size, max_err,
3097: Inserts, Updates, x_failed, Dups,NoChange,
3098: inXFR_GROUP,p_rp_folder_id, g_CONFIG_ENGINE_TYPE);
3099: if (CZ_IMP_ALL.get_time) then
3100: end_time := dbms_utility.get_time();
3101: d_str := inRun_Id || ' Populate project :' || (end_time-st_time)/100.00;
3102: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3103: end if;
3104: ELSIF(lower_table_name='cz_item_property_values') THEN

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

3102: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3103: end if;
3104: ELSIF(lower_table_name='cz_item_property_values') THEN
3105: if (CZ_IMP_ALL.get_time) then
3106: st_time := dbms_utility.get_time();
3107: end if;
3108: CZ_IMP_IM_MAIN.MAIN_ITEM_PROPERTY_VALUE(inRun_ID, commit_size, max_err,
3109: Inserts, Updates, x_failed, Dups, NoChange,inXFR_GROUP);
3110: if (CZ_IMP_ALL.get_time) then

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

3107: end if;
3108: CZ_IMP_IM_MAIN.MAIN_ITEM_PROPERTY_VALUE(inRun_ID, commit_size, max_err,
3109: Inserts, Updates, x_failed, Dups, NoChange,inXFR_GROUP);
3110: if (CZ_IMP_ALL.get_time) then
3111: end_time := dbms_utility.get_time();
3112: d_str := inRun_Id || ' Populate item property val :' || (end_time-st_time)/100.00;
3113: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3114: end if;
3115: ELSIF(lower_table_name='cz_item_types') THEN

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

3113: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3114: end if;
3115: ELSIF(lower_table_name='cz_item_types') THEN
3116: if (CZ_IMP_ALL.get_time) then
3117: st_time := dbms_utility.get_time();
3118: end if;
3119: CZ_IMP_IM_MAIN.MAIN_ITEM_TYPE(inRun_ID, commit_size, max_err,
3120: Inserts, Updates, x_failed, Dups, NoChange,inXFR_GROUP);
3121: if (CZ_IMP_ALL.get_time) then

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

3118: end if;
3119: CZ_IMP_IM_MAIN.MAIN_ITEM_TYPE(inRun_ID, commit_size, max_err,
3120: Inserts, Updates, x_failed, Dups, NoChange,inXFR_GROUP);
3121: if (CZ_IMP_ALL.get_time) then
3122: end_time := dbms_utility.get_time();
3123: d_str := inRun_Id || ' Populate item type :' || (end_time-st_time)/100.00;
3124: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3125: end if;
3126: ELSIF(lower_table_name='cz_item_type_properties') THEN

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

3124: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3125: end if;
3126: ELSIF(lower_table_name='cz_item_type_properties') THEN
3127: if (CZ_IMP_ALL.get_time) then
3128: st_time := dbms_utility.get_time();
3129: end if;
3130: CZ_IMP_IM_MAIN.MAIN_ITEM_TYPE_PROPERTY(inRun_ID, commit_size, max_err,
3131: Inserts, Updates, x_failed, Dups, inXFR_GROUP);
3132: if (CZ_IMP_ALL.get_time) then

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

3129: end if;
3130: CZ_IMP_IM_MAIN.MAIN_ITEM_TYPE_PROPERTY(inRun_ID, commit_size, max_err,
3131: Inserts, Updates, x_failed, Dups, inXFR_GROUP);
3132: if (CZ_IMP_ALL.get_time) then
3133: end_time := dbms_utility.get_time();
3134: d_str := inRun_Id || ' Populate item type property :' || (end_time-st_time)/100.00;
3135: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3136: end if;
3137: ELSIF(lower_table_name='cz_properties') THEN

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

3135: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3136: end if;
3137: ELSIF(lower_table_name='cz_properties') THEN
3138: if (CZ_IMP_ALL.get_time) then
3139: st_time := dbms_utility.get_time();
3140: end if;
3141: CZ_IMP_IM_MAIN.MAIN_PROPERTY(inRun_ID, commit_size, max_err,
3142: Inserts, Updates, x_failed, Dups, NoChange,inXFR_GROUP, p_rp_folder_id);
3143: if (CZ_IMP_ALL.get_time) then

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

3140: end if;
3141: CZ_IMP_IM_MAIN.MAIN_PROPERTY(inRun_ID, commit_size, max_err,
3142: Inserts, Updates, x_failed, Dups, NoChange,inXFR_GROUP, p_rp_folder_id);
3143: if (CZ_IMP_ALL.get_time) then
3144: end_time := dbms_utility.get_time();
3145: d_str := inRun_Id || ' Populate property :' || (end_time-st_time)/100.00;
3146: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3147: end if;
3148: ELSE

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

3506: END IF;
3507: END IF;
3508:
3509: if (CZ_IMP_ALL.get_time) then
3510: bom_explode_st := dbms_utility.get_time();
3511: end if;
3512:
3513: IF((inRunExploder = 1) and (NOT(GET_REMOTE_IMPORT))) THEN
3514:

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

3565: END;
3566: END IF;
3567:
3568: if (CZ_IMP_ALL.get_time) then
3569: bom_explode_end := dbms_utility.get_time();
3570: d_str := inRunId || ' Bom Exploder (' || inTopId || ') :' || (bom_explode_end-bom_explode_st)/100.00;
3571: xERROR:=cz_utils.log_report(d_str,1,'BOM_EXPLODER',11299,inRunId);
3572: end if;
3573:

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

3992: FETCH C_BILL_OF_MATERIAL INTO cFound;
3993: IF(C_BILL_OF_MATERIAL%FOUND)THEN
3994:
3995: if (CZ_IMP_ALL.get_time) then
3996: extract_st := dbms_utility.get_time();
3997: end if;
3998:
3999: --LA 9595142 Clear import_enabled_tbl before and after extraction
4000: import_enabled_tbl.DELETE;

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

4030: END IF;
4031: END LOOP;
4032:
4033: if (CZ_IMP_ALL.get_time) then
4034: extract_end := dbms_utility.get_time();
4035: d_str := genRun_Id || ' EXTRACT PS - TOTAL (' || nTop_Id || ') :' || (extract_end-extract_st)/100.00;
4036: xERROR:=cz_utils.log_report(d_str,1,'EXTRACT_PS_NODE',11299,genRun_ID);
4037: end if;
4038:

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

4100: repItemId.DELETE;
4101: hashCatalog.DELETE;
4102:
4103: if (CZ_IMP_ALL.get_time) then
4104: st_time := dbms_utility.get_time();
4105: end if;
4106:
4107: l_lang := userenv('LANG');
4108:

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

4145: xERROR:=cz_utils.log_report(SQLERRM,1,'CZ_IMP_SINGLE.IMPORTSINGLEBILL.CATALOG',11276,genRun_ID);
4146: END;
4147:
4148: if (CZ_IMP_ALL.get_time) then
4149: end_time := dbms_utility.get_time();
4150: d_str := genRun_Id ||' Collect Catalog group id (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
4151: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,genRun_ID);
4152: end if;
4153: