APPS.CZ_IMP_AC_MAIN dependencies on CZ_IMP_CUSTOMER_END_USER

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

245: ) IS
246: BEGIN
247: DECLARE
248: CURSOR c_imp_customerenduser IS
249: SELECT DELETED_FLAG, ROWID FROM CZ_IMP_CUSTOMER_END_USER WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID;
250: /* Internal vars */
251: nCommitCount PLS_INTEGER:=0; /*COMMIT buffer index */
252: nErrorCount PLS_INTEGER:=0; /*Error index */
253: nFailed PLS_INTEGER:=0; /*Failed records */

Line 272: UPDATE CZ_IMP_CUSTOMER_END_USER SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG) WHERE ROWID = p_imp_customerenduser.ROWID;

268:
269: EXIT WHEN(NOT x_imp_customerenduser_f Or nFailed >= Max_Err);
270: IF (p_imp_customerenduser.DELETED_FLAG IS NULL) THEN
271: BEGIN
272: UPDATE CZ_IMP_CUSTOMER_END_USER SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG) WHERE ROWID = p_imp_customerenduser.ROWID;
273: nCOmmitCount:=nCommitCount+1;
274: /* COMMIT if the buffer size is reached */
275: IF (nCommitCount>= COMMIT_SIZE) THEN
276: COMMIT;

Line 1354: FROM cz_imp_customer_end_user

1350:
1351: DECLARE
1352: CURSOR c_xfr_run_result IS
1353: SELECT DISPOSITION,REC_STATUS,COUNT(*)
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;