DBA Data[Home] [Help]

APPS.CZ_IMP_PS_NODE dependencies on DBMS_UTILITY

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

556: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
557: END;
558:
559: if (CZ_IMP_ALL.get_time) then
560: st_time := dbms_utility.get_time();
561: end if;
562:
563: CND_INTL_TEXT(inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);
564:

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

562:
563: CND_INTL_TEXT(inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);
564:
565: if (CZ_IMP_ALL.get_time) then
566: end_time := dbms_utility.get_time();
567: d_str := inRun_id || ' CND intl text :' || (end_time-st_time)/100.00;
568: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'CND',11299,inRun_Id);
569: end if;
570: KRS_INTL_TEXT(inRUN_ID,COMMIT_SIZE,MAX_ERR,INSERTS,UPDATES,FAILED,DUPS,NOCHANGE,inXFR_GROUP);

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

569: end if;
570: KRS_INTL_TEXT(inRUN_ID,COMMIT_SIZE,MAX_ERR,INSERTS,UPDATES,FAILED,DUPS,NOCHANGE,inXFR_GROUP);
571:
572: if (CZ_IMP_ALL.get_time) then
573: end_time := dbms_utility.get_time();
574: d_str := inRun_id || ' KRS intl text :' || (end_time-st_time)/100.00;
575: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'KRS',11299,inRun_Id);
576: end if;
577:

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

578: /* Make sure that the error count has not been reached */
579: XFR_INTL_TEXT(inRUN_ID,COMMIT_SIZE,MAX_ERR,nXfrInsertCount,nXfrUpdateCount,FAILED,nNoChangeCount,inXFR_GROUP);
580:
581: if (CZ_IMP_ALL.get_time) then
582: end_time := dbms_utility.get_time();
583: d_str := inRun_id || ' XFR intl text :' || (end_time-st_time)/100.00;
584: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'XFR',11299,inRun_Id);
585: end if;
586:

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

1479: VALUES(inRUN_ID,SYSDATE,SYSDATE);
1480: END;
1481:
1482: if (CZ_IMP_ALL.get_time) then
1483: st_time := dbms_utility.get_time();
1484: end if;
1485:
1486: CND_DEVL_PROJECT(inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);
1487:

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

1485:
1486: CND_DEVL_PROJECT(inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);
1487:
1488: if (CZ_IMP_ALL.get_time) then
1489: end_time := dbms_utility.get_time();
1490: d_str := inRun_id || ' CND projects :' || (end_time-st_time)/100.00;
1491: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'CND',11299,inRun_Id);
1492: end if;
1493:

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

1491: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'CND',11299,inRun_Id);
1492: end if;
1493:
1494: if (CZ_IMP_ALL.get_time) then
1495: st_time := dbms_utility.get_time();
1496: end if;
1497:
1498: KRS_DEVL_PROJECT(inRUN_ID,COMMIT_SIZE,MAX_ERR,INSERTS,UPDATES,FAILED,DUPS,NOCHANGE,inXFR_GROUP,inCONFIG_ENGINE_TYPE);
1499:

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

1497:
1498: KRS_DEVL_PROJECT(inRUN_ID,COMMIT_SIZE,MAX_ERR,INSERTS,UPDATES,FAILED,DUPS,NOCHANGE,inXFR_GROUP,inCONFIG_ENGINE_TYPE);
1499:
1500: if (CZ_IMP_ALL.get_time) then
1501: end_time := dbms_utility.get_time();
1502: d_str := inRun_id || ' KRS projects :' || (end_time-st_time)/100.00;
1503: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'KRS',11299,inRun_Id);
1504: end if;
1505:

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

1503: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'KRS',11299,inRun_Id);
1504: end if;
1505:
1506: if (CZ_IMP_ALL.get_time) then
1507: st_time := dbms_utility.get_time();
1508: end if;
1509: XFR_DEVL_PROJECT(inRUN_ID,COMMIT_SIZE,MAX_ERR,nXfrInsertCount,
1510: nXfrUpdateCount,FAILED,nNoChangeCount,inXFR_GROUP, p_rp_folder_id);
1511: if (CZ_IMP_ALL.get_time) then

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

1508: end if;
1509: XFR_DEVL_PROJECT(inRUN_ID,COMMIT_SIZE,MAX_ERR,nXfrInsertCount,
1510: nXfrUpdateCount,FAILED,nNoChangeCount,inXFR_GROUP, p_rp_folder_id);
1511: if (CZ_IMP_ALL.get_time) then
1512: end_time := dbms_utility.get_time();
1513: d_str := inRun_id || ' XFR projects :' || (end_time-st_time)/100.00;
1514: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'XFR',11299,inRun_Id);
1515: end if;
1516:

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

3025: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
3026: END;
3027:
3028: if (CZ_IMP_ALL.get_time) then
3029: st_time := dbms_utility.get_time();
3030: end if;
3031:
3032: CND_PS_NODE (inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);
3033:

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

3031:
3032: CND_PS_NODE (inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);
3033:
3034: if (CZ_IMP_ALL.get_time) then
3035: end_time := dbms_utility.get_time();
3036: d_str := inRun_id || ' CND ps :' || (end_time-st_time)/100.00;
3037: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'CND',11299,inRun_Id);
3038: end if;
3039:

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

3039:
3040: KRS_PS_NODE (inRUN_ID,COMMIT_SIZE,MAX_ERR,INSERTS,UPDATES,FAILED,DUPS,NOCHANGE,inXFR_GROUP);
3041:
3042: if (CZ_IMP_ALL.get_time) then
3043: end_time := dbms_utility.get_time();
3044: d_str := inRun_id || ' KRS ps :' || (end_time-st_time)/100.00;
3045: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'KRS',11299,inRun_Id);
3046: end if;
3047:

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

3068: fnd_stats.gather_table_stats('CZ', 'CZ_PS_NODES');
3069: x_error:=cz_utils.log_report('Gather Stats : End' ,1,'CZ_IMP_PS_NODE.XFR',11299,inRun_Id);
3070:
3071: if (CZ_IMP_ALL.get_time) then
3072: end_time := dbms_utility.get_time();
3073: d_str := inRun_id || ' XFR gather_stats :' || (end_time-st_time)/100.00;
3074: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'XFR',11299,inRun_Id);
3075: end if;
3076: END IF;

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

3077:
3078: XFR_PS_NODE (inRUN_ID,COMMIT_SIZE,MAX_ERR,nXfrInsertCount,nXfrUpdateCount,FAILED,nNoChangeCount,inXFR_GROUP);
3079:
3080: if (CZ_IMP_ALL.get_time) then
3081: end_time := dbms_utility.get_time();
3082: d_str := inRun_id || ' XFR ps :' || (end_time-st_time)/100.00;
3083: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'XFR',11299,inRun_Id);
3084: end if;
3085: