APPS.CZ_IMP_AC_MAIN dependencies on CZ_IMP_END_USER

Line 306: SELECT DELETED_FLAG, ROWID FROM CZ_IMP_END_USER WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID;

302: ) IS
303: BEGIN
304: DECLARE
305: CURSOR c_imp_enduser IS
306: SELECT DELETED_FLAG, ROWID FROM CZ_IMP_END_USER WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID;
307: /* Internal vars */
308: nCommitCount PLS_INTEGER:=0; /*COMMIT buffer index */
309: nErrorCount PLS_INTEGER:=0; /*Error index */
310: nFailed PLS_INTEGER:=0; /*Failed records */

Line 329: UPDATE CZ_IMP_END_USER SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG) WHERE ROWID = p_imp_enduser.ROWID;

325:
326: EXIT WHEN(NOT x_imp_enduser_f Or nFailed >= Max_Err);
327: IF (p_imp_enduser.DELETED_FLAG IS NULL) THEN
328: BEGIN
329: UPDATE CZ_IMP_END_USER SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG) WHERE ROWID = p_imp_enduser.ROWID;
330: nCOmmitCount:=nCommitCount+1;
331: /* COMMIT if the buffer size is reached */
332: IF (nCommitCount>= COMMIT_SIZE) THEN
333: COMMIT;

Line 364: SELECT DELETED_FLAG, ROWID FROM CZ_IMP_END_USER_GROUP WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID;

360: ) IS
361: BEGIN
362: DECLARE
363: CURSOR c_imp_endusergroup IS
364: SELECT DELETED_FLAG, ROWID FROM CZ_IMP_END_USER_GROUP WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID;
365: /* Internal vars */
366: nCommitCount PLS_INTEGER:=0; /*COMMIT buffer index */
367: nErrorCount PLS_INTEGER:=0; /*Error index */
368: nFailed PLS_INTEGER:=0; /*Failed records */

Line 387: UPDATE CZ_IMP_END_USER_GROUP SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG) WHERE ROWID = p_imp_endusergroup.ROWID;

383:
384: EXIT WHEN(NOT x_imp_endusergroup_f Or nFailed >= Max_Err);
385: IF (p_imp_endusergroup.DELETED_FLAG IS NULL) THEN
386: BEGIN
387: UPDATE CZ_IMP_END_USER_GROUP SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG) WHERE ROWID = p_imp_endusergroup.ROWID;
388: nCOmmitCount:=nCommitCount+1;
389: /* COMMIT if the buffer size is reached */
390: IF (nCommitCount>= COMMIT_SIZE) THEN
391: COMMIT;

Line 1419: FROM cz_imp_end_user

1415:
1416: DECLARE
1417: CURSOR c_xfr_run_result IS
1418: SELECT DISPOSITION,REC_STATUS,COUNT(*)
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;

Line 1484: FROM cz_imp_end_user_group

1480:
1481: DECLARE
1482: CURSOR c_xfr_run_result IS
1483: SELECT DISPOSITION,REC_STATUS,COUNT(*)
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;