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

1133:
1134: DECLARE
1135: CURSOR c_xfr_run_result IS
1136: SELECT DISPOSITION,REC_STATUS,COUNT(*)
1137: FROM CZ_IMP_item_type
1138: WHERE RUN_ID = inRUN_ID
1139: GROUP BY DISPOSITION,REC_STATUS;
1140:
1141: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;

Line 1208: FROM CZ_IMP_item_type_property

1204:
1205: DECLARE
1206: CURSOR c_xfr_run_result IS
1207: SELECT DISPOSITION,REC_STATUS,COUNT(*)
1208: FROM CZ_IMP_item_type_property
1209: WHERE RUN_ID = inRUN_ID
1210: GROUP BY DISPOSITION,REC_STATUS;
1211:
1212: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;