APPS.CZ_IMP_AC_MAIN dependencies on CZ_IMP_END_USER_GROUP

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 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;