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 998: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE=v_table_name;

994: v_ok VARCHAR2(4) := 'OK';
995: v_completed VARCHAR2(1) := '1';
996: BEGIN
997: BEGIN
998: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE=v_table_name;
999:
1000: EXCEPTION
1001: WHEN NO_DATA_FOUND THEN NULL;
1002: END;

Line 1011: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;

1007: FROM CZ_IMP_item_master
1008: WHERE RUN_ID = inRUN_ID
1009: GROUP BY DISPOSITION,REC_STATUS;
1010:
1011: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
1012: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
1013: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
1014:
1015: BEGIN

Line 1012: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;

1008: WHERE RUN_ID = inRUN_ID
1009: GROUP BY DISPOSITION,REC_STATUS;
1010:
1011: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
1012: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
1013: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
1014:
1015: BEGIN
1016:

Line 1013: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;

1009: GROUP BY DISPOSITION,REC_STATUS;
1010:
1011: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
1012: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
1013: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
1014:
1015: BEGIN
1016:
1017: OPEN c_xfr_run_result;

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

1018: LOOP
1019: FETCH c_xfr_run_result INTO ins_disposition,ins_rec_status,ins_rec_count;
1020: EXIT WHEN c_xfr_run_result%NOTFOUND;
1021:
1022: INSERT INTO CZ_XFR_RUN_RESULTS(RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)
1023: VALUES(inRUN_ID,v_table_name,ins_disposition,ins_rec_status,ins_rec_count);
1024:
1025: END LOOP;
1026: CLOSE c_xfr_run_result;

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

1033:
1034: DECLARE
1035: nErrors PLS_INTEGER;
1036: CURSOR c_get_nErrors IS
1037: SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS
1038: WHERE REC_STATUS<>v_ok AND RUN_ID=inRUN_ID
1039: AND IMP_TABLE=v_table_name;
1040: BEGIN
1041: OPEN c_get_nErrors;

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

1065: v_ok VARCHAR2(4) := 'OK';
1066: v_completed VARCHAR2(1) := '1';
1067: BEGIN
1068: BEGIN
1069: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE=v_table_name;
1070:
1071: EXCEPTION
1072: WHEN NO_DATA_FOUND THEN NULL;
1073: END;

Line 1082: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;

1078: FROM CZ_IMP_item_property_value
1079: WHERE RUN_ID = inRUN_ID
1080: GROUP BY DISPOSITION,REC_STATUS;
1081:
1082: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
1083: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
1084: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
1085:
1086: BEGIN

Line 1083: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;

1079: WHERE RUN_ID = inRUN_ID
1080: GROUP BY DISPOSITION,REC_STATUS;
1081:
1082: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
1083: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
1084: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
1085:
1086: BEGIN
1087:

Line 1084: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;

1080: GROUP BY DISPOSITION,REC_STATUS;
1081:
1082: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
1083: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
1084: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
1085:
1086: BEGIN
1087:
1088: OPEN c_xfr_run_result;

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

1089: LOOP
1090: FETCH c_xfr_run_result INTO ins_disposition,ins_rec_status,ins_rec_count;
1091: EXIT WHEN c_xfr_run_result%NOTFOUND;
1092:
1093: INSERT INTO CZ_XFR_RUN_RESULTS(RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)
1094: VALUES(inRUN_ID,v_table_name,ins_disposition,ins_rec_status,ins_rec_count);
1095:
1096: END LOOP;
1097: CLOSE c_xfr_run_result;

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

1104:
1105: DECLARE
1106: nErrors PLS_INTEGER;
1107: CURSOR c_get_nErrors IS
1108: SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS
1109: WHERE REC_STATUS<>v_ok AND RUN_ID=inRUN_ID
1110: AND IMP_TABLE=v_table_name;
1111: BEGIN
1112: OPEN c_get_nErrors;

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

1135: v_ok VARCHAR2(4) := 'OK';
1136: v_completed VARCHAR2(1) := '1';
1137: BEGIN
1138: BEGIN
1139: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE=v_table_name;
1140:
1141: EXCEPTION
1142: WHEN NO_DATA_FOUND THEN NULL;
1143: END;

Line 1152: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;

1148: FROM CZ_IMP_item_type
1149: WHERE RUN_ID = inRUN_ID
1150: GROUP BY DISPOSITION,REC_STATUS;
1151:
1152: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
1153: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
1154: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
1155:
1156: BEGIN

Line 1153: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;

1149: WHERE RUN_ID = inRUN_ID
1150: GROUP BY DISPOSITION,REC_STATUS;
1151:
1152: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
1153: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
1154: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
1155:
1156: BEGIN
1157:

Line 1154: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;

1150: GROUP BY DISPOSITION,REC_STATUS;
1151:
1152: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
1153: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
1154: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
1155:
1156: BEGIN
1157:
1158: OPEN c_xfr_run_result;

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

1159: LOOP
1160: FETCH c_xfr_run_result INTO ins_disposition,ins_rec_status,ins_rec_count;
1161: EXIT WHEN c_xfr_run_result%NOTFOUND;
1162:
1163: INSERT INTO CZ_XFR_RUN_RESULTS(RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)
1164: VALUES(inRUN_ID,v_table_name,ins_disposition,ins_rec_status,ins_rec_count);
1165:
1166: END LOOP;
1167: CLOSE c_xfr_run_result;

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

1174:
1175: DECLARE
1176: nErrors PLS_INTEGER;
1177: CURSOR c_get_nErrors IS
1178: SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS
1179: WHERE REC_STATUS<>v_ok AND RUN_ID=inRUN_ID
1180: AND IMP_TABLE=v_table_name;
1181: BEGIN
1182: OPEN c_get_nErrors;

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

1206: v_ok VARCHAR2(4) := 'OK';
1207: v_completed VARCHAR2(1) := '1';
1208: BEGIN
1209: BEGIN
1210: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE=v_table_name;
1211:
1212: EXCEPTION
1213: WHEN NO_DATA_FOUND THEN NULL;
1214: END;

Line 1223: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;

1219: FROM CZ_IMP_item_type_property
1220: WHERE RUN_ID = inRUN_ID
1221: GROUP BY DISPOSITION,REC_STATUS;
1222:
1223: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
1224: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
1225: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
1226:
1227: BEGIN

Line 1224: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;

1220: WHERE RUN_ID = inRUN_ID
1221: GROUP BY DISPOSITION,REC_STATUS;
1222:
1223: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
1224: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
1225: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
1226:
1227: BEGIN
1228:

Line 1225: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;

1221: GROUP BY DISPOSITION,REC_STATUS;
1222:
1223: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
1224: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
1225: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
1226:
1227: BEGIN
1228:
1229: OPEN c_xfr_run_result;

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

1230: LOOP
1231: FETCH c_xfr_run_result INTO ins_disposition,ins_rec_status,ins_rec_count;
1232: EXIT WHEN c_xfr_run_result%NOTFOUND;
1233:
1234: INSERT INTO CZ_XFR_RUN_RESULTS(RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)
1235: VALUES(inRUN_ID,v_table_name,ins_disposition,ins_rec_status,ins_rec_count);
1236:
1237: END LOOP;
1238: CLOSE c_xfr_run_result;

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

1245:
1246: DECLARE
1247: nErrors PLS_INTEGER;
1248: CURSOR c_get_nErrors IS
1249: SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS
1250: WHERE REC_STATUS<>v_ok AND RUN_ID=inRUN_ID
1251: AND IMP_TABLE=v_table_name;
1252: BEGIN
1253: OPEN c_get_nErrors;

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

1276: v_ok VARCHAR2(4) := 'OK';
1277: v_completed VARCHAR2(1) := '1';
1278: BEGIN
1279: BEGIN
1280: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE=v_table_name;
1281:
1282: EXCEPTION
1283: WHEN NO_DATA_FOUND THEN NULL;
1284: END;

Line 1293: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;

1289: FROM CZ_IMP_property
1290: WHERE RUN_ID = inRUN_ID
1291: GROUP BY DISPOSITION,REC_STATUS;
1292:
1293: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
1294: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
1295: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
1296:
1297: BEGIN

Line 1294: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;

1290: WHERE RUN_ID = inRUN_ID
1291: GROUP BY DISPOSITION,REC_STATUS;
1292:
1293: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
1294: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
1295: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
1296:
1297: BEGIN
1298:

Line 1295: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;

1291: GROUP BY DISPOSITION,REC_STATUS;
1292:
1293: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
1294: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
1295: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
1296:
1297: BEGIN
1298:
1299: OPEN c_xfr_run_result;

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

1300: LOOP
1301: FETCH c_xfr_run_result INTO ins_disposition,ins_rec_status,ins_rec_count;
1302: EXIT WHEN c_xfr_run_result%NOTFOUND;
1303:
1304: INSERT INTO CZ_XFR_RUN_RESULTS(RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)
1305: VALUES(inRUN_ID,v_table_name,ins_disposition,ins_rec_status,ins_rec_count);
1306:
1307: END LOOP;
1308: CLOSE c_xfr_run_result;

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

1315:
1316: DECLARE
1317: nErrors PLS_INTEGER;
1318: CURSOR c_get_nErrors IS
1319: SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS
1320: WHERE REC_STATUS<>v_ok AND RUN_ID=inRUN_ID
1321: AND IMP_TABLE=v_table_name;
1322: BEGIN
1323: OPEN c_get_nErrors;