APPS.CZ_IMP_PR_MAIN dependencies on CZ_IMP_PRICE

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

9: ) IS
10: BEGIN
11: DECLARE
12: CURSOR c_imp_price IS
13: SELECT DELETED_FLAG, ROWID FROM CZ_IMP_PRICE WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID;
14: /* Internal vars */
15: nCommitCount PLS_INTEGER:=0; /*COMMIT buffer index */
16: nErrorCount PLS_INTEGER:=0; /*Error index */
17: nFailed PLS_INTEGER:=0; /*Failed records */

Line 36: UPDATE CZ_IMP_PRICE SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG) WHERE ROWID = p_imp_price.ROWID;

32:
33: EXIT WHEN(NOT x_imp_price_f Or nFailed >= Max_Err);
34: IF (p_imp_price.DELETED_FLAG IS NULL) THEN
35: BEGIN
36: UPDATE CZ_IMP_PRICE SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG) WHERE ROWID = p_imp_price.ROWID;
37: nCOmmitCount:=nCommitCount+1;
38: /* COMMIT if the buffer size is reached */
39: IF (nCommitCount>= COMMIT_SIZE) THEN
40: COMMIT;

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 287: FROM CZ_IMP_price

283:
284: DECLARE
285: CURSOR c_xfr_run_result IS
286: SELECT DISPOSITION,REC_STATUS,COUNT(*)
287: FROM CZ_IMP_price
288: WHERE RUN_ID = inRUN_ID
289: GROUP BY DISPOSITION,REC_STATUS;
290:
291: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;

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;