APPS.CZ_IMP_IM_MAIN dependencies on CZ_IMP_ITEM_TYPE

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

271: ) IS
272: BEGIN
273: DECLARE
274: CURSOR c_imp_itemtype IS
275: SELECT DELETED_FLAG, ROWID FROM CZ_IMP_ITEM_TYPE WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID;
276: /* Internal vars */
277: nCommitCount PLS_INTEGER:=0; /*COMMIT buffer index */
278: nErrorCount PLS_INTEGER:=0; /*Error index */
279: nDups PLS_INTEGER:=0; /*Dupl records */

Line 301: UPDATE CZ_IMP_ITEM_TYPE SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG) WHERE ROWID = p_imp_itemtype.ROWID;

297: END IF;
298:
299: IF (p_imp_itemtype.DELETED_FLAG IS NULL) THEN
300: BEGIN
301: UPDATE CZ_IMP_ITEM_TYPE SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG) WHERE ROWID = p_imp_itemtype.ROWID;
302: nCOmmitCount:=nCommitCount+1;
303: /* COMMIT if the buffer size is reached */
304: IF (nCommitCount>= COMMIT_SIZE) THEN
305: COMMIT;

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 1148: FROM CZ_IMP_item_type

1144:
1145: DECLARE
1146: CURSOR c_xfr_run_result IS
1147: SELECT DISPOSITION,REC_STATUS,COUNT(*)
1148: FROM CZ_IMP_item_type
1149: WHERE RUN_ID = inRUN_ID
1150: GROUP BY DISPOSITION,REC_STATUS;
1151:
1152: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;

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;