APPS.CZ_IMP_AC_MAIN dependencies on CZ_IMP_CUSTOMER

Line 73: SELECT DELETED_FLAG, ROWID FROM CZ_IMP_CUSTOMER WHERE REC_STATUS IS NULL

69: ) IS
70: BEGIN
71: DECLARE
72: CURSOR c_imp_customer IS
73: SELECT DELETED_FLAG, ROWID FROM CZ_IMP_CUSTOMER WHERE REC_STATUS IS NULL
74: AND RUN_ID = inRUN_ID;
75: /* Internal vars */
76: nCommitCount PLS_INTEGER:=0; /*COMMIT buffer index */
77: nErrorCount PLS_INTEGER:=0; /*Error index */

Line 97: UPDATE CZ_IMP_CUSTOMER

93:
94: EXIT WHEN(NOT x_imp_customer_f Or nFailed >= Max_Err);
95: IF (p_imp_customer.DELETED_FLAG IS NULL) THEN
96: BEGIN
97: UPDATE CZ_IMP_CUSTOMER
98: SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG)
99: WHERE ROWID = p_imp_customer.ROWID;
100: nCOmmitCount:=nCommitCount+1;
101: /* COMMIT if the buffer size is reached */

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 1160: FROM cz_imp_customer

1156:
1157: DECLARE
1158: CURSOR c_xfr_run_result IS
1159: SELECT DISPOSITION,REC_STATUS,COUNT(*)
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;

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;