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

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

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

Line 501: UPDATE CZ_XFR_RUN_INFOS SET

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

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

504: WHERE RUN_ID=inRUN_ID;
505:
506: EXCEPTION
507: WHEN NO_DATA_FOUND THEN
508: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
509: VALUES(inRUN_ID,SYSDATE,SYSDATE);
510:
511: WHEN OTHERS THEN
512: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.MAIN_CONTACT',11276);

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

573: dummy CHAR(1);
574:
575: BEGIN
576: BEGIN
577: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
578:
579: UPDATE CZ_XFR_RUN_INFOS SET
580: STARTED=SYSDATE,
581: LAST_ACTIVITY=SYSDATE

Line 579: UPDATE CZ_XFR_RUN_INFOS SET

575: BEGIN
576: BEGIN
577: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
578:
579: UPDATE CZ_XFR_RUN_INFOS SET
580: STARTED=SYSDATE,
581: LAST_ACTIVITY=SYSDATE
582: WHERE RUN_ID=inRUN_ID;
583:

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

582: WHERE RUN_ID=inRUN_ID;
583:
584: EXCEPTION
585: WHEN NO_DATA_FOUND THEN
586: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
587: VALUES(inRUN_ID,SYSDATE,SYSDATE);
588:
589: WHEN OTHERS THEN
590: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.MAIN_CUSTOMER',11276);

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

646: dummy CHAR(1);
647:
648: BEGIN
649: BEGIN
650: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
651:
652: UPDATE CZ_XFR_RUN_INFOS SET
653: STARTED=SYSDATE,
654: LAST_ACTIVITY=SYSDATE

Line 652: UPDATE CZ_XFR_RUN_INFOS SET

648: BEGIN
649: BEGIN
650: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
651:
652: UPDATE CZ_XFR_RUN_INFOS SET
653: STARTED=SYSDATE,
654: LAST_ACTIVITY=SYSDATE
655: WHERE RUN_ID=inRUN_ID;
656:

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

655: WHERE RUN_ID=inRUN_ID;
656:
657: EXCEPTION
658: WHEN NO_DATA_FOUND THEN
659: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
660: VALUES(inRUN_ID,SYSDATE,SYSDATE);
661:
662: WHEN OTHERS THEN
663: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.MAIN_ADDRESS',11276);

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

719: dummy CHAR(1);
720:
721: BEGIN
722: BEGIN
723: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
724:
725: UPDATE CZ_XFR_RUN_INFOS SET
726: STARTED=SYSDATE,
727: LAST_ACTIVITY=SYSDATE

Line 725: UPDATE CZ_XFR_RUN_INFOS SET

721: BEGIN
722: BEGIN
723: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
724:
725: UPDATE CZ_XFR_RUN_INFOS SET
726: STARTED=SYSDATE,
727: LAST_ACTIVITY=SYSDATE
728: WHERE RUN_ID=inRUN_ID;
729:

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

728: WHERE RUN_ID=inRUN_ID;
729:
730: EXCEPTION
731: WHEN NO_DATA_FOUND THEN
732: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
733: VALUES(inRUN_ID,SYSDATE,SYSDATE);
734:
735: WHEN OTHERS THEN
736: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.MAIN_ADDRESS_USES',11276);

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

792: dummy CHAR(1);
793:
794: BEGIN
795: BEGIN
796: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
797:
798: UPDATE CZ_XFR_RUN_INFOS SET
799: STARTED=SYSDATE,
800: LAST_ACTIVITY=SYSDATE

Line 798: UPDATE CZ_XFR_RUN_INFOS SET

794: BEGIN
795: BEGIN
796: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
797:
798: UPDATE CZ_XFR_RUN_INFOS SET
799: STARTED=SYSDATE,
800: LAST_ACTIVITY=SYSDATE
801: WHERE RUN_ID=inRUN_ID;
802:

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

801: WHERE RUN_ID=inRUN_ID;
802:
803: EXCEPTION
804: WHEN NO_DATA_FOUND THEN
805: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
806: VALUES(inRUN_ID,SYSDATE,SYSDATE);
807:
808: WHEN OTHERS THEN
809: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.MAIN_CUSTOMER_END_USER',11276);

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

867:
868: BEGIN
869:
870: BEGIN
871: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
872:
873: UPDATE CZ_XFR_RUN_INFOS SET
874: STARTED=SYSDATE,
875: LAST_ACTIVITY=SYSDATE

Line 873: UPDATE CZ_XFR_RUN_INFOS SET

869:
870: BEGIN
871: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
872:
873: UPDATE CZ_XFR_RUN_INFOS SET
874: STARTED=SYSDATE,
875: LAST_ACTIVITY=SYSDATE
876: WHERE RUN_ID=inRUN_ID;
877:

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

876: WHERE RUN_ID=inRUN_ID;
877:
878: EXCEPTION
879: WHEN NO_DATA_FOUND THEN
880: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
881: VALUES(inRUN_ID,SYSDATE,SYSDATE);
882:
883: WHEN OTHERS THEN
884: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.MAIN_END_USER',11276);

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

945:
946: BEGIN
947:
948: BEGIN
949: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
950:
951: UPDATE CZ_XFR_RUN_INFOS SET
952: STARTED=SYSDATE,
953: LAST_ACTIVITY=SYSDATE

Line 951: UPDATE CZ_XFR_RUN_INFOS SET

947:
948: BEGIN
949: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
950:
951: UPDATE CZ_XFR_RUN_INFOS SET
952: STARTED=SYSDATE,
953: LAST_ACTIVITY=SYSDATE
954: WHERE RUN_ID=inRUN_ID;
955:

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

954: WHERE RUN_ID=inRUN_ID;
955:
956: EXCEPTION
957: WHEN NO_DATA_FOUND THEN
958: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
959: VALUES(inRUN_ID,SYSDATE,SYSDATE);
960:
961: WHEN OTHERS THEN
962: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.MAIN_END_USER_GROUP',11276);

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

1025:
1026: BEGIN
1027:
1028: BEGIN
1029: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
1030:
1031: UPDATE CZ_XFR_RUN_INFOS SET
1032: STARTED=SYSDATE,
1033: LAST_ACTIVITY=SYSDATE

Line 1031: UPDATE CZ_XFR_RUN_INFOS SET

1027:
1028: BEGIN
1029: SELECT 'X' INTO dummy FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=inRUN_ID;
1030:
1031: UPDATE CZ_XFR_RUN_INFOS SET
1032: STARTED=SYSDATE,
1033: LAST_ACTIVITY=SYSDATE
1034: WHERE RUN_ID=inRUN_ID;
1035:

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

1034: WHERE RUN_ID=inRUN_ID;
1035:
1036: EXCEPTION
1037: WHEN NO_DATA_FOUND THEN
1038: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
1039: VALUES(inRUN_ID,SYSDATE,SYSDATE);
1040:
1041: WHEN OTHERS THEN
1042: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.MAIN_USER_GROUP',11276);

Line 1132: UPDATE CZ_XFR_RUN_INFOS

1128: BEGIN
1129: OPEN c_get_nErrors;
1130: FETCH c_get_nErrors INTO nErrors;
1131: CLOSE c_get_nErrors;
1132: UPDATE CZ_XFR_RUN_INFOS
1133: SET TOTAL_ERRORS=NVL(TOTAL_ERRORS,0)+NVL(nErrors,0),
1134: COMPLETED='1'
1135: WHERE RUN_ID=inRUN_ID;
1136: COMMIT;

Line 1197: UPDATE CZ_XFR_RUN_INFOS

1193: BEGIN
1194: OPEN c_get_nErrors;
1195: FETCH c_get_nErrors INTO nErrors;
1196: CLOSE c_get_nErrors;
1197: UPDATE CZ_XFR_RUN_INFOS
1198: SET TOTAL_ERRORS=NVL(TOTAL_ERRORS,0)+NVL(nErrors,0),
1199: COMPLETED='1'
1200: WHERE RUN_ID=inRUN_ID;
1201: COMMIT;

Line 1262: UPDATE CZ_XFR_RUN_INFOS

1258: BEGIN
1259: OPEN c_get_nErrors;
1260: FETCH c_get_nErrors INTO nErrors;
1261: CLOSE c_get_nErrors;
1262: UPDATE CZ_XFR_RUN_INFOS
1263: SET TOTAL_ERRORS=NVL(TOTAL_ERRORS,0)+NVL(nErrors,0),
1264: COMPLETED='1'
1265: WHERE RUN_ID=inRUN_ID;
1266: 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='1'
1329: WHERE RUN_ID=inRUN_ID;
1330: COMMIT;

Line 1391: UPDATE CZ_XFR_RUN_INFOS

1387: BEGIN
1388: OPEN c_get_nErrors;
1389: FETCH c_get_nErrors INTO nErrors;
1390: CLOSE c_get_nErrors;
1391: UPDATE CZ_XFR_RUN_INFOS
1392: SET TOTAL_ERRORS=NVL(TOTAL_ERRORS,0)+NVL(nErrors,0),
1393: COMPLETED='1'
1394: WHERE RUN_ID=inRUN_ID;
1395: COMMIT;

Line 1456: UPDATE CZ_XFR_RUN_INFOS

1452: BEGIN
1453: OPEN c_get_nErrors;
1454: FETCH c_get_nErrors INTO nErrors;
1455: CLOSE c_get_nErrors;
1456: UPDATE CZ_XFR_RUN_INFOS
1457: SET TOTAL_ERRORS=NVL(TOTAL_ERRORS,0)+NVL(nErrors,0),
1458: COMPLETED='1'
1459: WHERE RUN_ID=inRUN_ID;
1460: COMMIT;

Line 1521: UPDATE CZ_XFR_RUN_INFOS

1517: BEGIN
1518: OPEN c_get_nErrors;
1519: FETCH c_get_nErrors INTO nErrors;
1520: CLOSE c_get_nErrors;
1521: UPDATE CZ_XFR_RUN_INFOS
1522: SET TOTAL_ERRORS=NVL(TOTAL_ERRORS,0)+NVL(nErrors,0),
1523: COMPLETED='1'
1524: WHERE RUN_ID=inRUN_ID;
1525: COMMIT;

Line 1586: UPDATE CZ_XFR_RUN_INFOS

1582: BEGIN
1583: OPEN c_get_nErrors;
1584: FETCH c_get_nErrors INTO nErrors;
1585: CLOSE c_get_nErrors;
1586: UPDATE CZ_XFR_RUN_INFOS
1587: SET TOTAL_ERRORS=NVL(TOTAL_ERRORS,0)+NVL(nErrors,0),
1588: COMPLETED='1'
1589: WHERE RUN_ID=inRUN_ID;
1590: COMMIT;