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 435: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;

431:
432: BEGIN
433:
434: BEGIN
435: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
436:
437: UPDATE CZ_XFR_RUN_INFOS SET
438: STARTED=SYSDATE,
439: LAST_ACTIVITY=SYSDATE

Line 437: UPDATE CZ_XFR_RUN_INFOS SET

433:
434: BEGIN
435: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
436:
437: UPDATE CZ_XFR_RUN_INFOS SET
438: STARTED=SYSDATE,
439: LAST_ACTIVITY=SYSDATE
440: WHERE RUN_ID=inRUN_ID;
441:

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

440: WHERE RUN_ID=inRUN_ID;
441:
442: EXCEPTION
443: WHEN NO_DATA_FOUND THEN
444: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
445: VALUES(inRUN_ID,SYSDATE,SYSDATE);
446: WHEN OTHERS THEN
447: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.MAIN_INTL_TEXT:RUNID',11276,inRun_Id);
448: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

Line 697: UPDATE CZ_XFR_RUN_INFOS

693: BEGIN
694: OPEN c_get_nErrors;
695: FETCH c_get_nErrors INTO nErrors;
696: CLOSE c_get_nErrors;
697: UPDATE CZ_XFR_RUN_INFOS
698: SET TOTAL_ERRORS=NVL(TOTAL_ERRORS,0)+NVL(nErrors,0),
699: COMPLETED=v_completed
700: WHERE RUN_ID=inRUN_ID;
701: COMMIT;

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

1247:
1248: BEGIN
1249:
1250: BEGIN
1251: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
1252:
1253: UPDATE CZ_XFR_RUN_INFOS SET
1254: STARTED=SYSDATE,
1255: LAST_ACTIVITY=SYSDATE

Line 1253: UPDATE CZ_XFR_RUN_INFOS SET

1249:
1250: BEGIN
1251: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
1252:
1253: UPDATE CZ_XFR_RUN_INFOS SET
1254: STARTED=SYSDATE,
1255: LAST_ACTIVITY=SYSDATE
1256: WHERE RUN_ID=inRUN_ID;
1257:

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

1256: WHERE RUN_ID=inRUN_ID;
1257:
1258: EXCEPTION
1259: WHEN NO_DATA_FOUND THEN
1260: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
1261: VALUES(inRUN_ID,SYSDATE,SYSDATE);
1262: END;
1263:
1264: if (CZ_IMP_ALL.get_time) then

Line 1650: UPDATE CZ_XFR_RUN_INFOS

1646: BEGIN
1647: OPEN c_get_nErrors;
1648: FETCH c_get_nErrors INTO nErrors;
1649: CLOSE c_get_nErrors;
1650: UPDATE CZ_XFR_RUN_INFOS
1651: SET TOTAL_ERRORS=NVL(TOTAL_ERRORS,0)+NVL(nErrors,0),
1652: COMPLETED=v_completed
1653: WHERE RUN_ID=inRUN_ID;
1654: COMMIT;

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

2610:
2611: BEGIN
2612:
2613: BEGIN
2614: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
2615:
2616: UPDATE CZ_XFR_RUN_INFOS SET
2617: STARTED=SYSDATE,
2618: LAST_ACTIVITY=SYSDATE

Line 2616: UPDATE CZ_XFR_RUN_INFOS SET

2612:
2613: BEGIN
2614: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
2615:
2616: UPDATE CZ_XFR_RUN_INFOS SET
2617: STARTED=SYSDATE,
2618: LAST_ACTIVITY=SYSDATE
2619: WHERE RUN_ID=inRUN_ID;
2620:

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

2619: WHERE RUN_ID=inRUN_ID;
2620:
2621: EXCEPTION
2622: WHEN NO_DATA_FOUND THEN
2623: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
2624: VALUES(inRUN_ID,SYSDATE,SYSDATE);
2625: WHEN OTHERS THEN
2626: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.MAIN_PS_NODE',11276,inRun_Id);
2627: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;

Line 4711: UPDATE CZ_XFR_RUN_INFOS

4707: BEGIN
4708: OPEN c_get_nErrors;
4709: FETCH c_get_nErrors INTO nErrors;
4710: CLOSE c_get_nErrors;
4711: UPDATE CZ_XFR_RUN_INFOS
4712: SET TOTAL_ERRORS=NVL(TOTAL_ERRORS,0)+NVL(nErrors,0),
4713: COMPLETED=v_completed
4714: WHERE RUN_ID=inRUN_ID;
4715: COMMIT;