APPS.CZ_IMP_AC_MAIN dependencies on CZ_IMP_USER_GROUP

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

419: ) IS
420: BEGIN
421: DECLARE
422: CURSOR c_imp_usergroup IS
423: SELECT DELETED_FLAG, ROWID FROM CZ_IMP_USER_GROUP WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID;
424: /* Internal vars */
425: nCommitCount PLS_INTEGER:=0; /*COMMIT buffer index */
426: nErrorCount PLS_INTEGER:=0; /*Error index */
427: nFailed PLS_INTEGER:=0; /*Failed records */

Line 446: UPDATE CZ_IMP_USER_GROUP SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG) WHERE ROWID = p_imp_usergroup.ROWID;

442:
443: EXIT WHEN(NOT x_imp_usergroup_f Or nFailed >= Max_Err);
444: IF (p_imp_usergroup.DELETED_FLAG IS NULL) THEN
445: BEGIN
446: UPDATE CZ_IMP_USER_GROUP SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG) WHERE ROWID = p_imp_usergroup.ROWID;
447: nCOmmitCount:=nCommitCount+1;
448: /* COMMIT if the buffer size is reached */
449: IF (nCommitCount>= COMMIT_SIZE) THEN
450: COMMIT;

Line 1549: FROM cz_imp_user_group

1545:
1546: DECLARE
1547: CURSOR c_xfr_run_result IS
1548: SELECT DISPOSITION,REC_STATUS,COUNT(*)
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;