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_RESULTS

Line 1086: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE='CZ_CONTACTS';

1082: PROCEDURE RPT_CONTACT ( inRUN_ID IN PLS_INTEGER ) AS
1083: x_error BOOLEAN:=FALSE;
1084: BEGIN
1085: BEGIN
1086: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE='CZ_CONTACTS';
1087:
1088: EXCEPTION
1089: WHEN NO_DATA_FOUND THEN NULL;
1090: END;

Line 1099: ins_disposition cz_xfr_run_results.disposition%TYPE;

1095: FROM cz_imp_contact
1096: WHERE RUN_ID = inRUN_ID
1097: GROUP BY DISPOSITION,REC_STATUS;
1098:
1099: ins_disposition cz_xfr_run_results.disposition%TYPE;
1100: ins_rec_status cz_xfr_run_results.rec_status%TYPE ;
1101: ins_rec_count cz_xfr_run_results.records%TYPE ;
1102:
1103: BEGIN

Line 1100: ins_rec_status cz_xfr_run_results.rec_status%TYPE ;

1096: WHERE RUN_ID = inRUN_ID
1097: GROUP BY DISPOSITION,REC_STATUS;
1098:
1099: ins_disposition cz_xfr_run_results.disposition%TYPE;
1100: ins_rec_status cz_xfr_run_results.rec_status%TYPE ;
1101: ins_rec_count cz_xfr_run_results.records%TYPE ;
1102:
1103: BEGIN
1104:

Line 1101: ins_rec_count cz_xfr_run_results.records%TYPE ;

1097: GROUP BY DISPOSITION,REC_STATUS;
1098:
1099: ins_disposition cz_xfr_run_results.disposition%TYPE;
1100: ins_rec_status cz_xfr_run_results.rec_status%TYPE ;
1101: ins_rec_count cz_xfr_run_results.records%TYPE ;
1102:
1103: BEGIN
1104:
1105: OPEN c_xfr_run_result;

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

1106: LOOP
1107: FETCH c_xfr_run_result INTO ins_disposition,ins_rec_status,ins_rec_count;
1108: EXIT WHEN c_xfr_run_result%NOTFOUND;
1109:
1110: INSERT INTO CZ_XFR_RUN_RESULTS(RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)
1111: VALUES(inRUN_ID,'CZ_CONTACTS',ins_disposition,ins_rec_status,ins_rec_count);
1112:
1113: END LOOP;
1114: CLOSE c_xfr_run_result;

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

1121:
1122: DECLARE
1123: nErrors PLS_INTEGER;
1124: CURSOR c_get_nErrors IS
1125: SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS
1126: WHERE REC_STATUS<>'OK' AND RUN_ID=inRUN_ID
1127: AND IMP_TABLE='CZ_CONTACTS';
1128: BEGIN
1129: OPEN c_get_nErrors;

Line 1151: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE='CZ_CUSTOMERS';

1147: PROCEDURE RPT_CUSTOMER ( inRUN_ID IN PLS_INTEGER ) AS
1148: x_error BOOLEAN:=FALSE;
1149: BEGIN
1150: BEGIN
1151: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE='CZ_CUSTOMERS';
1152:
1153: EXCEPTION
1154: WHEN NO_DATA_FOUND THEN NULL;
1155: END;

Line 1164: ins_disposition cz_xfr_run_results.disposition%TYPE;

1160: FROM cz_imp_customer
1161: WHERE RUN_ID = inRUN_ID
1162: GROUP BY DISPOSITION,REC_STATUS;
1163:
1164: ins_disposition cz_xfr_run_results.disposition%TYPE;
1165: ins_rec_status cz_xfr_run_results.rec_status%TYPE ;
1166: ins_rec_count cz_xfr_run_results.records%TYPE ;
1167:
1168: BEGIN

Line 1165: ins_rec_status cz_xfr_run_results.rec_status%TYPE ;

1161: WHERE RUN_ID = inRUN_ID
1162: GROUP BY DISPOSITION,REC_STATUS;
1163:
1164: ins_disposition cz_xfr_run_results.disposition%TYPE;
1165: ins_rec_status cz_xfr_run_results.rec_status%TYPE ;
1166: ins_rec_count cz_xfr_run_results.records%TYPE ;
1167:
1168: BEGIN
1169:

Line 1166: ins_rec_count cz_xfr_run_results.records%TYPE ;

1162: GROUP BY DISPOSITION,REC_STATUS;
1163:
1164: ins_disposition cz_xfr_run_results.disposition%TYPE;
1165: ins_rec_status cz_xfr_run_results.rec_status%TYPE ;
1166: ins_rec_count cz_xfr_run_results.records%TYPE ;
1167:
1168: BEGIN
1169:
1170: OPEN c_xfr_run_result;

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

1171: LOOP
1172: FETCH c_xfr_run_result INTO ins_disposition,ins_rec_status,ins_rec_count;
1173: EXIT WHEN c_xfr_run_result%NOTFOUND;
1174:
1175: INSERT INTO CZ_XFR_RUN_RESULTS(RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)
1176: VALUES(inRUN_ID,'CZ_CUSTOMERS',ins_disposition,ins_rec_status,ins_rec_count);
1177:
1178: END LOOP;
1179: CLOSE c_xfr_run_result;

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

1186:
1187: DECLARE
1188: nErrors PLS_INTEGER;
1189: CURSOR c_get_nErrors IS
1190: SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS
1191: WHERE REC_STATUS<>'OK' AND RUN_ID=inRUN_ID
1192: AND IMP_TABLE='CZ_CUSTOMERS';
1193: BEGIN
1194: OPEN c_get_nErrors;

Line 1216: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE='CZ_ADDRESSES';

1212: PROCEDURE RPT_ADDRESS ( inRUN_ID IN PLS_INTEGER ) AS
1213: x_error BOOLEAN:=FALSE;
1214: BEGIN
1215: BEGIN
1216: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE='CZ_ADDRESSES';
1217:
1218: EXCEPTION
1219: WHEN NO_DATA_FOUND THEN NULL;
1220: END;

Line 1229: ins_disposition cz_xfr_run_results.disposition%TYPE;

1225: FROM cz_imp_address
1226: WHERE RUN_ID = inRUN_ID
1227: GROUP BY DISPOSITION,REC_STATUS;
1228:
1229: ins_disposition cz_xfr_run_results.disposition%TYPE;
1230: ins_rec_status cz_xfr_run_results.rec_status%TYPE ;
1231: ins_rec_count cz_xfr_run_results.records%TYPE ;
1232:
1233: BEGIN

Line 1230: ins_rec_status cz_xfr_run_results.rec_status%TYPE ;

1226: WHERE RUN_ID = inRUN_ID
1227: GROUP BY DISPOSITION,REC_STATUS;
1228:
1229: ins_disposition cz_xfr_run_results.disposition%TYPE;
1230: ins_rec_status cz_xfr_run_results.rec_status%TYPE ;
1231: ins_rec_count cz_xfr_run_results.records%TYPE ;
1232:
1233: BEGIN
1234:

Line 1231: ins_rec_count cz_xfr_run_results.records%TYPE ;

1227: GROUP BY DISPOSITION,REC_STATUS;
1228:
1229: ins_disposition cz_xfr_run_results.disposition%TYPE;
1230: ins_rec_status cz_xfr_run_results.rec_status%TYPE ;
1231: ins_rec_count cz_xfr_run_results.records%TYPE ;
1232:
1233: BEGIN
1234:
1235: OPEN c_xfr_run_result;

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

1236: LOOP
1237: FETCH c_xfr_run_result INTO ins_disposition,ins_rec_status,ins_rec_count;
1238: EXIT WHEN c_xfr_run_result%NOTFOUND;
1239:
1240: INSERT INTO CZ_XFR_RUN_RESULTS(RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)
1241: VALUES(inRUN_ID,'CZ_ADDRESSES',ins_disposition,ins_rec_status,ins_rec_count);
1242:
1243: END LOOP;
1244: CLOSE c_xfr_run_result;

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

1251:
1252: DECLARE
1253: nErrors PLS_INTEGER;
1254: CURSOR c_get_nErrors IS
1255: SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS
1256: WHERE REC_STATUS<>'OK' AND RUN_ID=inRUN_ID
1257: AND IMP_TABLE='CZ_ADDRESSES';
1258: BEGIN
1259: OPEN c_get_nErrors;

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

1276: PROCEDURE RPT_ADDRESS_USES ( inRUN_ID IN PLS_INTEGER ) AS
1277: x_error BOOLEAN:=FALSE;
1278: BEGIN
1279: BEGIN
1280: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE='CZ_ADDRESS_USES';
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_address_use
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,'CZ_ADDRESS_USES',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<>'OK' AND RUN_ID=inRUN_ID
1321: AND IMP_TABLE='CZ_ADDRESS_USES';
1322: BEGIN
1323: OPEN c_get_nErrors;

Line 1345: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE='CZ_CUSTOMER_END_USERS';

1341: PROCEDURE RPT_CUSTOMER_END_USER ( inRUN_ID IN PLS_INTEGER ) AS
1342: x_error BOOLEAN:=FALSE;
1343: BEGIN
1344: BEGIN
1345: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE='CZ_CUSTOMER_END_USERS';
1346:
1347: EXCEPTION
1348: WHEN NO_DATA_FOUND THEN NULL;
1349: END;

Line 1358: ins_disposition cz_xfr_run_results.disposition%TYPE;

1354: FROM cz_imp_customer_end_user
1355: WHERE RUN_ID = inRUN_ID
1356: GROUP BY DISPOSITION,REC_STATUS;
1357:
1358: ins_disposition cz_xfr_run_results.disposition%TYPE;
1359: ins_rec_status cz_xfr_run_results.rec_status%TYPE ;
1360: ins_rec_count cz_xfr_run_results.records%TYPE ;
1361:
1362: BEGIN

Line 1359: ins_rec_status cz_xfr_run_results.rec_status%TYPE ;

1355: WHERE RUN_ID = inRUN_ID
1356: GROUP BY DISPOSITION,REC_STATUS;
1357:
1358: ins_disposition cz_xfr_run_results.disposition%TYPE;
1359: ins_rec_status cz_xfr_run_results.rec_status%TYPE ;
1360: ins_rec_count cz_xfr_run_results.records%TYPE ;
1361:
1362: BEGIN
1363:

Line 1360: ins_rec_count cz_xfr_run_results.records%TYPE ;

1356: GROUP BY DISPOSITION,REC_STATUS;
1357:
1358: ins_disposition cz_xfr_run_results.disposition%TYPE;
1359: ins_rec_status cz_xfr_run_results.rec_status%TYPE ;
1360: ins_rec_count cz_xfr_run_results.records%TYPE ;
1361:
1362: BEGIN
1363:
1364: OPEN c_xfr_run_result;

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

1365: LOOP
1366: FETCH c_xfr_run_result INTO ins_disposition,ins_rec_status,ins_rec_count;
1367: EXIT WHEN c_xfr_run_result%NOTFOUND;
1368:
1369: INSERT INTO CZ_XFR_RUN_RESULTS(RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)
1370: VALUES(inRUN_ID,'CZ_CUSTOMER_END_USERS',ins_disposition,ins_rec_status,ins_rec_count);
1371:
1372: END LOOP;
1373: CLOSE c_xfr_run_result;

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

1380:
1381: DECLARE
1382: nErrors PLS_INTEGER;
1383: CURSOR c_get_nErrors IS
1384: SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS
1385: WHERE REC_STATUS<>'OK' AND RUN_ID=inRUN_ID
1386: AND IMP_TABLE='CZ_CUSTOMER_END_USERS';
1387: BEGIN
1388: OPEN c_get_nErrors;

Line 1410: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE='CZ_END_USERS';

1406: PROCEDURE RPT_END_USER ( inRUN_ID IN PLS_INTEGER ) AS
1407: x_error BOOLEAN:=FALSE;
1408: BEGIN
1409: BEGIN
1410: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE='CZ_END_USERS';
1411:
1412: EXCEPTION
1413: WHEN NO_DATA_FOUND THEN NULL;
1414: END;

Line 1423: ins_disposition cz_xfr_run_results.disposition%TYPE;

1419: FROM cz_imp_end_user
1420: WHERE RUN_ID = inRUN_ID
1421: GROUP BY DISPOSITION,REC_STATUS;
1422:
1423: ins_disposition cz_xfr_run_results.disposition%TYPE;
1424: ins_rec_status cz_xfr_run_results.rec_status%TYPE ;
1425: ins_rec_count cz_xfr_run_results.records%TYPE ;
1426:
1427: BEGIN

Line 1424: ins_rec_status cz_xfr_run_results.rec_status%TYPE ;

1420: WHERE RUN_ID = inRUN_ID
1421: GROUP BY DISPOSITION,REC_STATUS;
1422:
1423: ins_disposition cz_xfr_run_results.disposition%TYPE;
1424: ins_rec_status cz_xfr_run_results.rec_status%TYPE ;
1425: ins_rec_count cz_xfr_run_results.records%TYPE ;
1426:
1427: BEGIN
1428:

Line 1425: ins_rec_count cz_xfr_run_results.records%TYPE ;

1421: GROUP BY DISPOSITION,REC_STATUS;
1422:
1423: ins_disposition cz_xfr_run_results.disposition%TYPE;
1424: ins_rec_status cz_xfr_run_results.rec_status%TYPE ;
1425: ins_rec_count cz_xfr_run_results.records%TYPE ;
1426:
1427: BEGIN
1428:
1429: OPEN c_xfr_run_result;

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

1430: LOOP
1431: FETCH c_xfr_run_result INTO ins_disposition,ins_rec_status,ins_rec_count;
1432: EXIT WHEN c_xfr_run_result%NOTFOUND;
1433:
1434: INSERT INTO CZ_XFR_RUN_RESULTS(RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)
1435: VALUES(inRUN_ID,'CZ_END_USERS',ins_disposition,ins_rec_status,ins_rec_count);
1436:
1437: END LOOP;
1438: CLOSE c_xfr_run_result;

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

1445:
1446: DECLARE
1447: nErrors PLS_INTEGER;
1448: CURSOR c_get_nErrors IS
1449: SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS
1450: WHERE REC_STATUS<>'OK' AND RUN_ID=inRUN_ID
1451: AND IMP_TABLE='CZ_END_USERS';
1452: BEGIN
1453: OPEN c_get_nErrors;

Line 1475: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE='CZ_END_USER_GROUPS';

1471: PROCEDURE RPT_END_USER_GROUP ( inRUN_ID IN PLS_INTEGER ) AS
1472: x_error BOOLEAN:=FALSE;
1473: BEGIN
1474: BEGIN
1475: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE='CZ_END_USER_GROUPS';
1476:
1477: EXCEPTION
1478: WHEN NO_DATA_FOUND THEN NULL;
1479: END;

Line 1488: ins_disposition cz_xfr_run_results.disposition%TYPE;

1484: FROM cz_imp_end_user_group
1485: WHERE RUN_ID = inRUN_ID
1486: GROUP BY DISPOSITION,REC_STATUS;
1487:
1488: ins_disposition cz_xfr_run_results.disposition%TYPE;
1489: ins_rec_status cz_xfr_run_results.rec_status%TYPE ;
1490: ins_rec_count cz_xfr_run_results.records%TYPE ;
1491:
1492: BEGIN

Line 1489: ins_rec_status cz_xfr_run_results.rec_status%TYPE ;

1485: WHERE RUN_ID = inRUN_ID
1486: GROUP BY DISPOSITION,REC_STATUS;
1487:
1488: ins_disposition cz_xfr_run_results.disposition%TYPE;
1489: ins_rec_status cz_xfr_run_results.rec_status%TYPE ;
1490: ins_rec_count cz_xfr_run_results.records%TYPE ;
1491:
1492: BEGIN
1493:

Line 1490: ins_rec_count cz_xfr_run_results.records%TYPE ;

1486: GROUP BY DISPOSITION,REC_STATUS;
1487:
1488: ins_disposition cz_xfr_run_results.disposition%TYPE;
1489: ins_rec_status cz_xfr_run_results.rec_status%TYPE ;
1490: ins_rec_count cz_xfr_run_results.records%TYPE ;
1491:
1492: BEGIN
1493:
1494: OPEN c_xfr_run_result;

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

1495: LOOP
1496: FETCH c_xfr_run_result INTO ins_disposition,ins_rec_status,ins_rec_count;
1497: EXIT WHEN c_xfr_run_result%NOTFOUND;
1498:
1499: INSERT INTO CZ_XFR_RUN_RESULTS(RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)
1500: VALUES(inRUN_ID,'CZ_END_USER_GROUPS',ins_disposition,ins_rec_status,ins_rec_count);
1501:
1502: END LOOP;
1503: CLOSE c_xfr_run_result;

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

1510:
1511: DECLARE
1512: nErrors PLS_INTEGER;
1513: CURSOR c_get_nErrors IS
1514: SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS
1515: WHERE REC_STATUS<>'OK' AND RUN_ID=inRUN_ID
1516: AND IMP_TABLE='CZ_END_USER_GROUPS';
1517: BEGIN
1518: OPEN c_get_nErrors;

Line 1540: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE='CZ_USER_GROUPS';

1536: PROCEDURE RPT_USER_GROUP ( inRUN_ID IN PLS_INTEGER ) AS
1537: x_error BOOLEAN:=FALSE;
1538: BEGIN
1539: BEGIN
1540: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE='CZ_USER_GROUPS';
1541:
1542: EXCEPTION
1543: WHEN NO_DATA_FOUND THEN NULL;
1544: END;

Line 1553: ins_disposition cz_xfr_run_results.disposition%TYPE;

1549: FROM cz_imp_user_group
1550: WHERE RUN_ID = inRUN_ID
1551: GROUP BY DISPOSITION,REC_STATUS;
1552:
1553: ins_disposition cz_xfr_run_results.disposition%TYPE;
1554: ins_rec_status cz_xfr_run_results.rec_status%TYPE ;
1555: ins_rec_count cz_xfr_run_results.records%TYPE ;
1556:
1557: BEGIN

Line 1554: ins_rec_status cz_xfr_run_results.rec_status%TYPE ;

1550: WHERE RUN_ID = inRUN_ID
1551: GROUP BY DISPOSITION,REC_STATUS;
1552:
1553: ins_disposition cz_xfr_run_results.disposition%TYPE;
1554: ins_rec_status cz_xfr_run_results.rec_status%TYPE ;
1555: ins_rec_count cz_xfr_run_results.records%TYPE ;
1556:
1557: BEGIN
1558:

Line 1555: ins_rec_count cz_xfr_run_results.records%TYPE ;

1551: GROUP BY DISPOSITION,REC_STATUS;
1552:
1553: ins_disposition cz_xfr_run_results.disposition%TYPE;
1554: ins_rec_status cz_xfr_run_results.rec_status%TYPE ;
1555: ins_rec_count cz_xfr_run_results.records%TYPE ;
1556:
1557: BEGIN
1558:
1559: OPEN c_xfr_run_result;

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

1560: LOOP
1561: FETCH c_xfr_run_result INTO ins_disposition,ins_rec_status,ins_rec_count;
1562: EXIT WHEN c_xfr_run_result%NOTFOUND;
1563:
1564: INSERT INTO CZ_XFR_RUN_RESULTS(RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)
1565: VALUES(inRUN_ID,'CZ_USER_GROUPS',ins_disposition,ins_rec_status,ins_rec_count);
1566:
1567: END LOOP;
1568: CLOSE c_xfr_run_result;

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

1575:
1576: DECLARE
1577: nErrors PLS_INTEGER;
1578: CURSOR c_get_nErrors IS
1579: SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS
1580: WHERE REC_STATUS<>'OK' AND RUN_ID=inRUN_ID
1581: AND IMP_TABLE='CZ_USER_GROUPS';
1582: BEGIN
1583: OPEN c_get_nErrors;