APPS.CZ_IMP_IM_MAIN dependencies on CZ_IMP_ITEM_TYPE_PROPERTY

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

333: ) IS
334: BEGIN
335: DECLARE
336: CURSOR c_imp_itemtypeprop IS
337: SELECT DELETED_FLAG, ROWID FROM CZ_IMP_ITEM_TYPE_PROPERTY WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID;
338: /* Internal vars */
339: nCommitCount PLS_INTEGER:=0; /*COMMIT buffer index */
340: nErrorCount PLS_INTEGER:=0; /*Error index */
341: nDups PLS_INTEGER:=0; /*Dupl records */

Line 364: UPDATE CZ_IMP_ITEM_TYPE_PROPERTY SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG) WHERE ROWID = p_imp_itemtypeprop.ROWID;

360: END IF;
361:
362: IF (p_imp_itemtypeprop.DELETED_FLAG IS NULL) THEN
363: BEGIN
364: UPDATE CZ_IMP_ITEM_TYPE_PROPERTY SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG) WHERE ROWID = p_imp_itemtypeprop.ROWID;
365: nCOmmitCount:=nCommitCount+1;
366: /* COMMIT if the buffer size is reached */
367: IF (nCommitCount>= COMMIT_SIZE) THEN
368: COMMIT;

Line 1219: FROM CZ_IMP_item_type_property

1215:
1216: DECLARE
1217: CURSOR c_xfr_run_result IS
1218: SELECT DISPOSITION,REC_STATUS,COUNT(*)
1219: FROM CZ_IMP_item_type_property
1220: WHERE RUN_ID = inRUN_ID
1221: GROUP BY DISPOSITION,REC_STATUS;
1222:
1223: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;