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_RESULTS

Line 987: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE=v_table_name;

983: v_ok VARCHAR2(4) := 'OK';
984: v_completed VARCHAR2(1) := '1';
985: BEGIN
986: BEGIN
987: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE=v_table_name;
988:
989: EXCEPTION
990: WHEN NO_DATA_FOUND THEN NULL;
991: END;

Line 1000: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;

996: FROM CZ_IMP_item_master
997: WHERE RUN_ID = inRUN_ID
998: GROUP BY DISPOSITION,REC_STATUS;
999:
1000: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
1001: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
1002: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
1003:
1004: BEGIN

Line 1001: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;

997: WHERE RUN_ID = inRUN_ID
998: GROUP BY DISPOSITION,REC_STATUS;
999:
1000: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
1001: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
1002: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
1003:
1004: BEGIN
1005:

Line 1002: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;

998: GROUP BY DISPOSITION,REC_STATUS;
999:
1000: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
1001: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
1002: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
1003:
1004: BEGIN
1005:
1006: OPEN c_xfr_run_result;

Line 1011: INSERT INTO CZ_XFR_RUN_RESULTS(RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)

1007: LOOP
1008: FETCH c_xfr_run_result INTO ins_disposition,ins_rec_status,ins_rec_count;
1009: EXIT WHEN c_xfr_run_result%NOTFOUND;
1010:
1011: INSERT INTO CZ_XFR_RUN_RESULTS(RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)
1012: VALUES(inRUN_ID,v_table_name,ins_disposition,ins_rec_status,ins_rec_count);
1013:
1014: END LOOP;
1015: CLOSE c_xfr_run_result;

Line 1026: SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS

1022:
1023: DECLARE
1024: nErrors PLS_INTEGER;
1025: CURSOR c_get_nErrors IS
1026: SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS
1027: WHERE REC_STATUS<>v_ok AND RUN_ID=inRUN_ID
1028: AND IMP_TABLE=v_table_name;
1029: BEGIN
1030: OPEN c_get_nErrors;

Line 1058: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE=v_table_name;

1054: v_ok VARCHAR2(4) := 'OK';
1055: v_completed VARCHAR2(1) := '1';
1056: BEGIN
1057: BEGIN
1058: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE=v_table_name;
1059:
1060: EXCEPTION
1061: WHEN NO_DATA_FOUND THEN NULL;
1062: END;

Line 1071: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;

1067: FROM CZ_IMP_item_property_value
1068: WHERE RUN_ID = inRUN_ID
1069: GROUP BY DISPOSITION,REC_STATUS;
1070:
1071: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
1072: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
1073: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
1074:
1075: BEGIN

Line 1072: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;

1068: WHERE RUN_ID = inRUN_ID
1069: GROUP BY DISPOSITION,REC_STATUS;
1070:
1071: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
1072: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
1073: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
1074:
1075: BEGIN
1076:

Line 1073: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;

1069: GROUP BY DISPOSITION,REC_STATUS;
1070:
1071: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
1072: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
1073: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
1074:
1075: BEGIN
1076:
1077: OPEN c_xfr_run_result;

Line 1082: INSERT INTO CZ_XFR_RUN_RESULTS(RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)

1078: LOOP
1079: FETCH c_xfr_run_result INTO ins_disposition,ins_rec_status,ins_rec_count;
1080: EXIT WHEN c_xfr_run_result%NOTFOUND;
1081:
1082: INSERT INTO CZ_XFR_RUN_RESULTS(RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)
1083: VALUES(inRUN_ID,v_table_name,ins_disposition,ins_rec_status,ins_rec_count);
1084:
1085: END LOOP;
1086: CLOSE c_xfr_run_result;

Line 1097: SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS

1093:
1094: DECLARE
1095: nErrors PLS_INTEGER;
1096: CURSOR c_get_nErrors IS
1097: SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS
1098: WHERE REC_STATUS<>v_ok AND RUN_ID=inRUN_ID
1099: AND IMP_TABLE=v_table_name;
1100: BEGIN
1101: OPEN c_get_nErrors;

Line 1128: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE=v_table_name;

1124: v_ok VARCHAR2(4) := 'OK';
1125: v_completed VARCHAR2(1) := '1';
1126: BEGIN
1127: BEGIN
1128: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE=v_table_name;
1129:
1130: EXCEPTION
1131: WHEN NO_DATA_FOUND THEN NULL;
1132: END;

Line 1141: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;

1137: FROM CZ_IMP_item_type
1138: WHERE RUN_ID = inRUN_ID
1139: GROUP BY DISPOSITION,REC_STATUS;
1140:
1141: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
1142: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
1143: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
1144:
1145: BEGIN

Line 1142: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;

1138: WHERE RUN_ID = inRUN_ID
1139: GROUP BY DISPOSITION,REC_STATUS;
1140:
1141: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
1142: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
1143: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
1144:
1145: BEGIN
1146:

Line 1143: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;

1139: GROUP BY DISPOSITION,REC_STATUS;
1140:
1141: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
1142: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
1143: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
1144:
1145: BEGIN
1146:
1147: OPEN c_xfr_run_result;

Line 1152: INSERT INTO CZ_XFR_RUN_RESULTS(RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)

1148: LOOP
1149: FETCH c_xfr_run_result INTO ins_disposition,ins_rec_status,ins_rec_count;
1150: EXIT WHEN c_xfr_run_result%NOTFOUND;
1151:
1152: INSERT INTO CZ_XFR_RUN_RESULTS(RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)
1153: VALUES(inRUN_ID,v_table_name,ins_disposition,ins_rec_status,ins_rec_count);
1154:
1155: END LOOP;
1156: CLOSE c_xfr_run_result;

Line 1167: SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS

1163:
1164: DECLARE
1165: nErrors PLS_INTEGER;
1166: CURSOR c_get_nErrors IS
1167: SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS
1168: WHERE REC_STATUS<>v_ok AND RUN_ID=inRUN_ID
1169: AND IMP_TABLE=v_table_name;
1170: BEGIN
1171: OPEN c_get_nErrors;

Line 1199: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE=v_table_name;

1195: v_ok VARCHAR2(4) := 'OK';
1196: v_completed VARCHAR2(1) := '1';
1197: BEGIN
1198: BEGIN
1199: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE=v_table_name;
1200:
1201: EXCEPTION
1202: WHEN NO_DATA_FOUND THEN NULL;
1203: END;

Line 1212: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;

1208: FROM CZ_IMP_item_type_property
1209: WHERE RUN_ID = inRUN_ID
1210: GROUP BY DISPOSITION,REC_STATUS;
1211:
1212: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
1213: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
1214: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
1215:
1216: BEGIN

Line 1213: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;

1209: WHERE RUN_ID = inRUN_ID
1210: GROUP BY DISPOSITION,REC_STATUS;
1211:
1212: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
1213: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
1214: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
1215:
1216: BEGIN
1217:

Line 1214: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;

1210: GROUP BY DISPOSITION,REC_STATUS;
1211:
1212: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
1213: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
1214: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
1215:
1216: BEGIN
1217:
1218: OPEN c_xfr_run_result;

Line 1223: INSERT INTO CZ_XFR_RUN_RESULTS(RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)

1219: LOOP
1220: FETCH c_xfr_run_result INTO ins_disposition,ins_rec_status,ins_rec_count;
1221: EXIT WHEN c_xfr_run_result%NOTFOUND;
1222:
1223: INSERT INTO CZ_XFR_RUN_RESULTS(RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)
1224: VALUES(inRUN_ID,v_table_name,ins_disposition,ins_rec_status,ins_rec_count);
1225:
1226: END LOOP;
1227: CLOSE c_xfr_run_result;

Line 1238: SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS

1234:
1235: DECLARE
1236: nErrors PLS_INTEGER;
1237: CURSOR c_get_nErrors IS
1238: SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS
1239: WHERE REC_STATUS<>v_ok AND RUN_ID=inRUN_ID
1240: AND IMP_TABLE=v_table_name;
1241: BEGIN
1242: OPEN c_get_nErrors;

Line 1269: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE=v_table_name;

1265: v_ok VARCHAR2(4) := 'OK';
1266: v_completed VARCHAR2(1) := '1';
1267: BEGIN
1268: BEGIN
1269: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE=v_table_name;
1270:
1271: EXCEPTION
1272: WHEN NO_DATA_FOUND THEN NULL;
1273: END;

Line 1282: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;

1278: FROM CZ_IMP_property
1279: WHERE RUN_ID = inRUN_ID
1280: GROUP BY DISPOSITION,REC_STATUS;
1281:
1282: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
1283: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
1284: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
1285:
1286: BEGIN

Line 1283: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;

1279: WHERE RUN_ID = inRUN_ID
1280: GROUP BY DISPOSITION,REC_STATUS;
1281:
1282: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
1283: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
1284: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
1285:
1286: BEGIN
1287:

Line 1284: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;

1280: GROUP BY DISPOSITION,REC_STATUS;
1281:
1282: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
1283: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
1284: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
1285:
1286: BEGIN
1287:
1288: OPEN c_xfr_run_result;

Line 1293: INSERT INTO CZ_XFR_RUN_RESULTS(RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)

1289: LOOP
1290: FETCH c_xfr_run_result INTO ins_disposition,ins_rec_status,ins_rec_count;
1291: EXIT WHEN c_xfr_run_result%NOTFOUND;
1292:
1293: INSERT INTO CZ_XFR_RUN_RESULTS(RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)
1294: VALUES(inRUN_ID,v_table_name,ins_disposition,ins_rec_status,ins_rec_count);
1295:
1296: END LOOP;
1297: CLOSE c_xfr_run_result;

Line 1308: SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS

1304:
1305: DECLARE
1306: nErrors PLS_INTEGER;
1307: CURSOR c_get_nErrors IS
1308: SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS
1309: WHERE REC_STATUS<>v_ok AND RUN_ID=inRUN_ID
1310: AND IMP_TABLE=v_table_name;
1311: BEGIN
1312: OPEN c_get_nErrors;