APPS.CZ_IMP_PR_MAIN dependencies on CZ_IMP_PRICE_GROUP

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

66: ) IS
67: BEGIN
68: DECLARE
69: CURSOR c_imp_pricegroup IS
70: SELECT DELETED_FLAG, ROWID FROM CZ_IMP_PRICE_GROUP WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID;
71: /* Internal vars */
72: nCommitCount PLS_INTEGER:=0; /*COMMIT buffer index */
73: nErrorCount PLS_INTEGER:=0; /*Error index */
74: nFailed PLS_INTEGER:=0; /*Failed records */

Line 93: UPDATE CZ_IMP_PRICE_GROUP SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG) WHERE ROWID = p_imp_pricegroup.ROWID;

89:
90: EXIT WHEN(NOT x_imp_pricegroup_f Or nFailed >= Max_Err);
91: IF (p_imp_pricegroup.DELETED_FLAG IS NULL) THEN
92: BEGIN
93: UPDATE CZ_IMP_PRICE_GROUP SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG) WHERE ROWID = p_imp_pricegroup.ROWID;
94: nCOmmitCount:=nCommitCount+1;
95: /* COMMIT if the buffer size is reached */
96: IF (nCommitCount>= COMMIT_SIZE) THEN
97: COMMIT;

Line 352: FROM CZ_IMP_price_group

348:
349: DECLARE
350: CURSOR c_xfr_run_result IS
351: SELECT DISPOSITION,REC_STATUS,COUNT(*)
352: FROM CZ_IMP_price_group
353: WHERE RUN_ID = inRUN_ID
354: GROUP BY DISPOSITION,REC_STATUS;
355:
356: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;