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

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

Line 506: UPDATE CZ_XFR_RUN_INFOS SET

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

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

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

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

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

Line 610: UPDATE CZ_XFR_RUN_INFOS SET

606:
607: BEGIN
608: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
609:
610: UPDATE CZ_XFR_RUN_INFOS SET
611: STARTED=SYSDATE,
612: LAST_ACTIVITY=SYSDATE
613: WHERE RUN_ID=inRUN_ID;
614:

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

613: WHERE RUN_ID=inRUN_ID;
614:
615: EXCEPTION
616: WHEN NO_DATA_FOUND THEN
617: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
618: VALUES(inRUN_ID,SYSDATE,SYSDATE);
619:
620: WHEN OTHERS THEN
621: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.MAIN_ITEM_PROPERTY_VALUE',11276,inRun_ID);

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

708:
709: BEGIN
710:
711: BEGIN
712: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
713:
714: UPDATE CZ_XFR_RUN_INFOS SET
715: STARTED=SYSDATE,
716: LAST_ACTIVITY=SYSDATE

Line 714: UPDATE CZ_XFR_RUN_INFOS SET

710:
711: BEGIN
712: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
713:
714: UPDATE CZ_XFR_RUN_INFOS SET
715: STARTED=SYSDATE,
716: LAST_ACTIVITY=SYSDATE
717: WHERE RUN_ID=inRUN_ID;
718:

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

717: WHERE RUN_ID=inRUN_ID;
718:
719: EXCEPTION
720: WHEN NO_DATA_FOUND THEN
721: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
722: VALUES(inRUN_ID,SYSDATE,SYSDATE);
723:
724: WHEN OTHERS THEN
725: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.MAIN_ITEM_TYPE',11276,inRun_ID);

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

808:
809: BEGIN
810:
811: BEGIN
812: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
813:
814: UPDATE CZ_XFR_RUN_INFOS SET
815: STARTED=SYSDATE,
816: LAST_ACTIVITY=SYSDATE

Line 814: UPDATE CZ_XFR_RUN_INFOS SET

810:
811: BEGIN
812: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
813:
814: UPDATE CZ_XFR_RUN_INFOS SET
815: STARTED=SYSDATE,
816: LAST_ACTIVITY=SYSDATE
817: WHERE RUN_ID=inRUN_ID;
818:

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

817: WHERE RUN_ID=inRUN_ID;
818:
819: EXCEPTION
820: WHEN NO_DATA_FOUND THEN
821: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
822: VALUES(inRUN_ID,SYSDATE,SYSDATE);
823:
824: WHEN OTHERS THEN
825: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.MAIN_ITEM_TYPE_PROPERTY',11276,inRun_ID);

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

914:
915: BEGIN
916:
917: BEGIN
918: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
919:
920: UPDATE CZ_XFR_RUN_INFOS SET
921: STARTED=SYSDATE,
922: LAST_ACTIVITY=SYSDATE

Line 920: UPDATE CZ_XFR_RUN_INFOS SET

916:
917: BEGIN
918: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
919:
920: UPDATE CZ_XFR_RUN_INFOS SET
921: STARTED=SYSDATE,
922: LAST_ACTIVITY=SYSDATE
923: WHERE RUN_ID=inRUN_ID;
924:

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

923: WHERE RUN_ID=inRUN_ID;
924:
925: EXCEPTION
926: WHEN NO_DATA_FOUND THEN
927: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
928: VALUES(inRUN_ID,SYSDATE,SYSDATE);
929:
930: WHEN OTHERS THEN
931: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.MAIN_PROPERTY',11276,inRun_ID);

Line 1044: UPDATE CZ_XFR_RUN_INFOS

1040: BEGIN
1041: OPEN c_get_nErrors;
1042: FETCH c_get_nErrors INTO nErrors;
1043: CLOSE c_get_nErrors;
1044: UPDATE CZ_XFR_RUN_INFOS
1045: SET TOTAL_ERRORS=NVL(TOTAL_ERRORS,0)+NVL(nErrors,0),
1046: COMPLETED=v_completed
1047: WHERE RUN_ID=inRUN_ID;
1048: COMMIT;

Line 1115: UPDATE CZ_XFR_RUN_INFOS

1111: BEGIN
1112: OPEN c_get_nErrors;
1113: FETCH c_get_nErrors INTO nErrors;
1114: CLOSE c_get_nErrors;
1115: UPDATE CZ_XFR_RUN_INFOS
1116: SET TOTAL_ERRORS=NVL(TOTAL_ERRORS,0)+NVL(nErrors,0),
1117: COMPLETED=v_completed
1118: WHERE RUN_ID=inRUN_ID;
1119: COMMIT;

Line 1185: UPDATE CZ_XFR_RUN_INFOS

1181: BEGIN
1182: OPEN c_get_nErrors;
1183: FETCH c_get_nErrors INTO nErrors;
1184: CLOSE c_get_nErrors;
1185: UPDATE CZ_XFR_RUN_INFOS
1186: SET TOTAL_ERRORS=NVL(TOTAL_ERRORS,0)+NVL(nErrors,0),
1187: COMPLETED=v_completed
1188: WHERE RUN_ID=inRUN_ID;
1189: COMMIT;

Line 1256: UPDATE CZ_XFR_RUN_INFOS

1252: BEGIN
1253: OPEN c_get_nErrors;
1254: FETCH c_get_nErrors INTO nErrors;
1255: CLOSE c_get_nErrors;
1256: UPDATE CZ_XFR_RUN_INFOS
1257: SET TOTAL_ERRORS=NVL(TOTAL_ERRORS,0)+NVL(nErrors,0),
1258: COMPLETED=v_completed
1259: WHERE RUN_ID=inRUN_ID;
1260: COMMIT;

Line 1326: UPDATE CZ_XFR_RUN_INFOS

1322: BEGIN
1323: OPEN c_get_nErrors;
1324: FETCH c_get_nErrors INTO nErrors;
1325: CLOSE c_get_nErrors;
1326: UPDATE CZ_XFR_RUN_INFOS
1327: SET TOTAL_ERRORS=NVL(TOTAL_ERRORS,0)+NVL(nErrors,0),
1328: COMPLETED=v_completed
1329: WHERE RUN_ID=inRUN_ID;
1330: COMMIT;