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

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

498:
499: BEGIN
500:
501: BEGIN
502: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
503:
504: UPDATE CZ_XFR_RUN_INFOS SET
505: STARTED=SYSDATE,
506: LAST_ACTIVITY=SYSDATE

Line 504: UPDATE CZ_XFR_RUN_INFOS SET

500:
501: BEGIN
502: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
503:
504: UPDATE CZ_XFR_RUN_INFOS SET
505: STARTED=SYSDATE,
506: LAST_ACTIVITY=SYSDATE
507: WHERE RUN_ID=inRUN_ID;
508:

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

507: WHERE RUN_ID=inRUN_ID;
508:
509: EXCEPTION
510: WHEN NO_DATA_FOUND THEN
511: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
512: VALUES(inRUN_ID,SYSDATE,SYSDATE);
513:
514: WHEN OTHERS THEN
515: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.MAIN_ITEM_MASTER',11276,inRun_ID);

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

599:
600: BEGIN
601:
602: BEGIN
603: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
604:
605: UPDATE CZ_XFR_RUN_INFOS SET
606: STARTED=SYSDATE,
607: LAST_ACTIVITY=SYSDATE

Line 605: UPDATE CZ_XFR_RUN_INFOS SET

601:
602: BEGIN
603: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
604:
605: UPDATE CZ_XFR_RUN_INFOS SET
606: STARTED=SYSDATE,
607: LAST_ACTIVITY=SYSDATE
608: WHERE RUN_ID=inRUN_ID;
609:

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

608: WHERE RUN_ID=inRUN_ID;
609:
610: EXCEPTION
611: WHEN NO_DATA_FOUND THEN
612: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
613: VALUES(inRUN_ID,SYSDATE,SYSDATE);
614:
615: WHEN OTHERS THEN
616: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.MAIN_ITEM_PROPERTY_VALUE',11276,inRun_ID);

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

701:
702: BEGIN
703:
704: BEGIN
705: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
706:
707: UPDATE CZ_XFR_RUN_INFOS SET
708: STARTED=SYSDATE,
709: LAST_ACTIVITY=SYSDATE

Line 707: UPDATE CZ_XFR_RUN_INFOS SET

703:
704: BEGIN
705: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
706:
707: UPDATE CZ_XFR_RUN_INFOS SET
708: STARTED=SYSDATE,
709: LAST_ACTIVITY=SYSDATE
710: WHERE RUN_ID=inRUN_ID;
711:

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

710: WHERE RUN_ID=inRUN_ID;
711:
712: EXCEPTION
713: WHEN NO_DATA_FOUND THEN
714: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
715: VALUES(inRUN_ID,SYSDATE,SYSDATE);
716:
717: WHEN OTHERS THEN
718: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.MAIN_ITEM_TYPE',11276,inRun_ID);

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

800:
801: BEGIN
802:
803: BEGIN
804: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
805:
806: UPDATE CZ_XFR_RUN_INFOS SET
807: STARTED=SYSDATE,
808: LAST_ACTIVITY=SYSDATE

Line 806: UPDATE CZ_XFR_RUN_INFOS SET

802:
803: BEGIN
804: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
805:
806: UPDATE CZ_XFR_RUN_INFOS SET
807: STARTED=SYSDATE,
808: LAST_ACTIVITY=SYSDATE
809: WHERE RUN_ID=inRUN_ID;
810:

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

809: WHERE RUN_ID=inRUN_ID;
810:
811: EXCEPTION
812: WHEN NO_DATA_FOUND THEN
813: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
814: VALUES(inRUN_ID,SYSDATE,SYSDATE);
815:
816: WHEN OTHERS THEN
817: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.MAIN_ITEM_TYPE_PROPERTY',11276,inRun_ID);

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

904:
905: BEGIN
906:
907: BEGIN
908: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
909:
910: UPDATE CZ_XFR_RUN_INFOS SET
911: STARTED=SYSDATE,
912: LAST_ACTIVITY=SYSDATE

Line 910: UPDATE CZ_XFR_RUN_INFOS SET

906:
907: BEGIN
908: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
909:
910: UPDATE CZ_XFR_RUN_INFOS SET
911: STARTED=SYSDATE,
912: LAST_ACTIVITY=SYSDATE
913: WHERE RUN_ID=inRUN_ID;
914:

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

913: WHERE RUN_ID=inRUN_ID;
914:
915: EXCEPTION
916: WHEN NO_DATA_FOUND THEN
917: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
918: VALUES(inRUN_ID,SYSDATE,SYSDATE);
919:
920: WHEN OTHERS THEN
921: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.MAIN_PROPERTY',11276,inRun_ID);

Line 1033: UPDATE CZ_XFR_RUN_INFOS

1029: BEGIN
1030: OPEN c_get_nErrors;
1031: FETCH c_get_nErrors INTO nErrors;
1032: CLOSE c_get_nErrors;
1033: UPDATE CZ_XFR_RUN_INFOS
1034: SET TOTAL_ERRORS=NVL(TOTAL_ERRORS,0)+NVL(nErrors,0),
1035: COMPLETED=v_completed
1036: WHERE RUN_ID=inRUN_ID;
1037: COMMIT;

Line 1104: UPDATE CZ_XFR_RUN_INFOS

1100: BEGIN
1101: OPEN c_get_nErrors;
1102: FETCH c_get_nErrors INTO nErrors;
1103: CLOSE c_get_nErrors;
1104: UPDATE CZ_XFR_RUN_INFOS
1105: SET TOTAL_ERRORS=NVL(TOTAL_ERRORS,0)+NVL(nErrors,0),
1106: COMPLETED=v_completed
1107: WHERE RUN_ID=inRUN_ID;
1108: COMMIT;

Line 1174: UPDATE CZ_XFR_RUN_INFOS

1170: BEGIN
1171: OPEN c_get_nErrors;
1172: FETCH c_get_nErrors INTO nErrors;
1173: CLOSE c_get_nErrors;
1174: UPDATE CZ_XFR_RUN_INFOS
1175: SET TOTAL_ERRORS=NVL(TOTAL_ERRORS,0)+NVL(nErrors,0),
1176: COMPLETED=v_completed
1177: WHERE RUN_ID=inRUN_ID;
1178: COMMIT;

Line 1245: UPDATE CZ_XFR_RUN_INFOS

1241: BEGIN
1242: OPEN c_get_nErrors;
1243: FETCH c_get_nErrors INTO nErrors;
1244: CLOSE c_get_nErrors;
1245: UPDATE CZ_XFR_RUN_INFOS
1246: SET TOTAL_ERRORS=NVL(TOTAL_ERRORS,0)+NVL(nErrors,0),
1247: COMPLETED=v_completed
1248: WHERE RUN_ID=inRUN_ID;
1249: COMMIT;

Line 1315: UPDATE CZ_XFR_RUN_INFOS

1311: BEGIN
1312: OPEN c_get_nErrors;
1313: FETCH c_get_nErrors INTO nErrors;
1314: CLOSE c_get_nErrors;
1315: UPDATE CZ_XFR_RUN_INFOS
1316: SET TOTAL_ERRORS=NVL(TOTAL_ERRORS,0)+NVL(nErrors,0),
1317: COMPLETED=v_completed
1318: WHERE RUN_ID=inRUN_ID;
1319: COMMIT;