DBA Data[Home] [Help]

APPS.CZ_IMP_PS_NODE dependencies on DBMS_UTILITY

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

448: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
449: END;
450:
451: if (CZ_IMP_ALL.get_time) then
452: st_time := dbms_utility.get_time();
453: end if;
454:
455: CND_INTL_TEXT(inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);
456:

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

454:
455: CND_INTL_TEXT(inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);
456:
457: if (CZ_IMP_ALL.get_time) then
458: end_time := dbms_utility.get_time();
459: d_str := inRun_id || ' CND intl text :' || (end_time-st_time)/100.00;
460: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'CND',11299,inRun_Id);
461: end if;
462:

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

462:
463: KRS_INTL_TEXT(inRUN_ID,COMMIT_SIZE,MAX_ERR,INSERTS,UPDATES,FAILED,DUPS,inXFR_GROUP);
464:
465: if (CZ_IMP_ALL.get_time) then
466: end_time := dbms_utility.get_time();
467: d_str := inRun_id || ' KRS intl text :' || (end_time-st_time)/100.00;
468: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'KRS',11299,inRun_Id);
469: end if;
470:

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

472:
473: XFR_INTL_TEXT(inRUN_ID,COMMIT_SIZE,MAX_ERR,nXfrInsertCount,nXfrUpdateCount,FAILED,inXFR_GROUP);
474:
475: if (CZ_IMP_ALL.get_time) then
476: end_time := dbms_utility.get_time();
477: d_str := inRun_id || ' XFR intl text :' || (end_time-st_time)/100.00;
478: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'XFR',11299,inRun_Id);
479: end if;
480:

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

1261: VALUES(inRUN_ID,SYSDATE,SYSDATE);
1262: END;
1263:
1264: if (CZ_IMP_ALL.get_time) then
1265: st_time := dbms_utility.get_time();
1266: end if;
1267:
1268: CND_DEVL_PROJECT(inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);
1269:

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

1267:
1268: CND_DEVL_PROJECT(inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);
1269:
1270: if (CZ_IMP_ALL.get_time) then
1271: end_time := dbms_utility.get_time();
1272: d_str := inRun_id || ' CND projects :' || (end_time-st_time)/100.00;
1273: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'CND',11299,inRun_Id);
1274: end if;
1275:

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

1273: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'CND',11299,inRun_Id);
1274: end if;
1275:
1276: if (CZ_IMP_ALL.get_time) then
1277: st_time := dbms_utility.get_time();
1278: end if;
1279:
1280: KRS_DEVL_PROJECT(inRUN_ID,COMMIT_SIZE,MAX_ERR,INSERTS,UPDATES,FAILED,DUPS,inXFR_GROUP);
1281:

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

1279:
1280: KRS_DEVL_PROJECT(inRUN_ID,COMMIT_SIZE,MAX_ERR,INSERTS,UPDATES,FAILED,DUPS,inXFR_GROUP);
1281:
1282: if (CZ_IMP_ALL.get_time) then
1283: end_time := dbms_utility.get_time();
1284: d_str := inRun_id || ' KRS projects :' || (end_time-st_time)/100.00;
1285: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'KRS',11299,inRun_Id);
1286: end if;
1287:

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

1285: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'KRS',11299,inRun_Id);
1286: end if;
1287:
1288: if (CZ_IMP_ALL.get_time) then
1289: st_time := dbms_utility.get_time();
1290: end if;
1291: XFR_DEVL_PROJECT(inRUN_ID,COMMIT_SIZE,MAX_ERR,nXfrInsertCount,
1292: nXfrUpdateCount,FAILED,inXFR_GROUP, p_rp_folder_id);
1293: if (CZ_IMP_ALL.get_time) then

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

1290: end if;
1291: XFR_DEVL_PROJECT(inRUN_ID,COMMIT_SIZE,MAX_ERR,nXfrInsertCount,
1292: nXfrUpdateCount,FAILED,inXFR_GROUP, p_rp_folder_id);
1293: if (CZ_IMP_ALL.get_time) then
1294: end_time := dbms_utility.get_time();
1295: d_str := inRun_id || ' XFR projects :' || (end_time-st_time)/100.00;
1296: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'XFR',11299,inRun_Id);
1297: end if;
1298:

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

2627: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
2628: END;
2629:
2630: if (CZ_IMP_ALL.get_time) then
2631: st_time := dbms_utility.get_time();
2632: end if;
2633:
2634: CND_PS_NODE (inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);
2635:

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

2633:
2634: CND_PS_NODE (inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);
2635:
2636: if (CZ_IMP_ALL.get_time) then
2637: end_time := dbms_utility.get_time();
2638: d_str := inRun_id || ' CND ps :' || (end_time-st_time)/100.00;
2639: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'CND',11299,inRun_Id);
2640: end if;
2641:

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

2641:
2642: KRS_PS_NODE (inRUN_ID,COMMIT_SIZE,MAX_ERR,INSERTS,UPDATES,FAILED,DUPS,inXFR_GROUP);
2643:
2644: if (CZ_IMP_ALL.get_time) then
2645: end_time := dbms_utility.get_time();
2646: d_str := inRun_id || ' KRS ps :' || (end_time-st_time)/100.00;
2647: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'KRS',11299,inRun_Id);
2648: end if;
2649:

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

2649:
2650: XFR_PS_NODE (inRUN_ID,COMMIT_SIZE,MAX_ERR,nXfrInsertCount,nXfrUpdateCount,FAILED,inXFR_GROUP);
2651:
2652: if (CZ_IMP_ALL.get_time) then
2653: end_time := dbms_utility.get_time();
2654: d_str := inRun_id || ' XFR ps :' || (end_time-st_time)/100.00;
2655: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'XFR',11299,inRun_Id);
2656: end if;
2657: