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_PS_NODE dependencies on CZ_XFR_RUN_INFOS

Line 543: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;

539:
540: BEGIN
541:
542: BEGIN
543: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
544:
545: UPDATE CZ_XFR_RUN_INFOS SET
546: STARTED=SYSDATE,
547: LAST_ACTIVITY=SYSDATE

Line 545: UPDATE CZ_XFR_RUN_INFOS SET

541:
542: BEGIN
543: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
544:
545: UPDATE CZ_XFR_RUN_INFOS SET
546: STARTED=SYSDATE,
547: LAST_ACTIVITY=SYSDATE
548: WHERE RUN_ID=inRUN_ID;
549:

Line 552: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)

548: WHERE RUN_ID=inRUN_ID;
549:
550: EXCEPTION
551: WHEN NO_DATA_FOUND THEN
552: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
553: VALUES(inRUN_ID,SYSDATE,SYSDATE);
554: WHEN OTHERS THEN
555: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.MAIN_INTL_TEXT:RUNID',11276,inRun_Id);
556: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

Line 816: UPDATE CZ_XFR_RUN_INFOS

812: BEGIN
813: OPEN c_get_nErrors;
814: FETCH c_get_nErrors INTO nErrors;
815: CLOSE c_get_nErrors;
816: UPDATE CZ_XFR_RUN_INFOS
817: SET TOTAL_ERRORS=NVL(TOTAL_ERRORS,0)+NVL(nErrors,0),
818: COMPLETED=v_completed
819: WHERE RUN_ID=inRUN_ID;
820: COMMIT;

Line 1469: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;

1465:
1466: BEGIN
1467:
1468: BEGIN
1469: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
1470:
1471: UPDATE CZ_XFR_RUN_INFOS SET
1472: STARTED=SYSDATE,
1473: LAST_ACTIVITY=SYSDATE

Line 1471: UPDATE CZ_XFR_RUN_INFOS SET

1467:
1468: BEGIN
1469: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
1470:
1471: UPDATE CZ_XFR_RUN_INFOS SET
1472: STARTED=SYSDATE,
1473: LAST_ACTIVITY=SYSDATE
1474: WHERE RUN_ID=inRUN_ID;
1475:

Line 1478: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)

1474: WHERE RUN_ID=inRUN_ID;
1475:
1476: EXCEPTION
1477: WHEN NO_DATA_FOUND THEN
1478: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
1479: VALUES(inRUN_ID,SYSDATE,SYSDATE);
1480: END;
1481:
1482: if (CZ_IMP_ALL.get_time) then

Line 1900: UPDATE CZ_XFR_RUN_INFOS

1896: BEGIN
1897: OPEN c_get_nErrors;
1898: FETCH c_get_nErrors INTO nErrors;
1899: CLOSE c_get_nErrors;
1900: UPDATE CZ_XFR_RUN_INFOS
1901: SET TOTAL_ERRORS=NVL(TOTAL_ERRORS,0)+NVL(nErrors,0),
1902: COMPLETED=v_completed
1903: WHERE RUN_ID=inRUN_ID;
1904: COMMIT;

Line 3012: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;

3008:
3009: BEGIN
3010:
3011: BEGIN
3012: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
3013:
3014: UPDATE CZ_XFR_RUN_INFOS SET
3015: STARTED=SYSDATE,
3016: LAST_ACTIVITY=SYSDATE

Line 3014: UPDATE CZ_XFR_RUN_INFOS SET

3010:
3011: BEGIN
3012: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
3013:
3014: UPDATE CZ_XFR_RUN_INFOS SET
3015: STARTED=SYSDATE,
3016: LAST_ACTIVITY=SYSDATE
3017: WHERE RUN_ID=inRUN_ID;
3018:

Line 3021: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)

3017: WHERE RUN_ID=inRUN_ID;
3018:
3019: EXCEPTION
3020: WHEN NO_DATA_FOUND THEN
3021: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
3022: VALUES(inRUN_ID,SYSDATE,SYSDATE);
3023: WHEN OTHERS THEN
3024: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.MAIN_PS_NODE',11276,inRun_Id);
3025: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

Line 5163: UPDATE CZ_XFR_RUN_INFOS

5159: BEGIN
5160: OPEN c_get_nErrors;
5161: FETCH c_get_nErrors INTO nErrors;
5162: CLOSE c_get_nErrors;
5163: UPDATE CZ_XFR_RUN_INFOS
5164: SET TOTAL_ERRORS=NVL(TOTAL_ERRORS,0)+NVL(nErrors,0),
5165: COMPLETED=v_completed
5166: WHERE RUN_ID=inRUN_ID;
5167: COMMIT;