APPS.CZ_IMP_IM_MAIN dependencies on CZ_IMP_ITEM_MASTER

Line 14: FROM CZ_IMP_ITEM_MASTER

10: BEGIN
11: DECLARE
12: CURSOR c_imp_itemmaster IS
13: SELECT DELETED_FLAG, SRC_APPLICATION_ID, SRC_TYPE_CODE, DECIMAL_QTY_FLAG, ROWID
14: FROM CZ_IMP_ITEM_MASTER
15: WHERE REC_STATUS IS NULL
16: AND RUN_ID = inRUN_ID;
17: /* Internal vars */
18: nCommitCount PLS_INTEGER:=0; /*COMMIT buffer index */

Line 43: UPDATE CZ_IMP_ITEM_MASTER

39: END IF;
40:
41: IF (p_imp_itemmaster.DELETED_FLAG IS NULL) THEN
42: BEGIN
43: UPDATE CZ_IMP_ITEM_MASTER
44: SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG)
45: WHERE ROWID = p_imp_itemmaster.ROWID;
46: nCOmmitCount:=nCommitCount+1;
47: /* COMMIT if the buffer size is reached */

Line 61: UPDATE CZ_IMP_ITEM_MASTER SET DECIMAL_QTY_FLAG = '0'

57: END IF;
58:
59: IF (p_imp_itemmaster.DECIMAL_QTY_FLAG IS NULL) THEN
60: BEGIN
61: UPDATE CZ_IMP_ITEM_MASTER SET DECIMAL_QTY_FLAG = '0'
62: WHERE ROWID = p_imp_itemmaster.ROWID;
63:
64: nCOmmitCount:=nCommitCount+1;
65: /* COMMIT if the buffer size is reached */

Line 79: UPDATE CZ_IMP_ITEM_MASTER

75: END IF;
76:
77: IF (p_imp_itemmaster.SRC_APPLICATION_ID IS NULL AND p_imp_itemmaster.SRC_TYPE_CODE IS NULL) THEN
78: BEGIN
79: UPDATE CZ_IMP_ITEM_MASTER
80: SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG),
81: SRC_APPLICATION_ID = cnDefSrcAppId,
82: SRC_TYPE_CODE = cnDefSrcTypeCode
83: WHERE ROWID = p_imp_itemmaster.ROWID;

Line 97: UPDATE CZ_IMP_ITEM_MASTER

93: FAILED:=FAILED+1;
94: END;
95: ELSIF (p_imp_itemmaster.SRC_APPLICATION_ID IS NULL) THEN
96: BEGIN
97: UPDATE CZ_IMP_ITEM_MASTER
98: SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG),
99: SRC_APPLICATION_ID = cnDefSrcAppId
100: WHERE ROWID = p_imp_itemmaster.ROWID;
101: nCOmmitCount:=nCommitCount+1;

Line 114: UPDATE CZ_IMP_ITEM_MASTER

110: FAILED:=FAILED+1;
111: END;
112: ELSIF (p_imp_itemmaster.SRC_TYPE_CODE IS NULL) THEN
113: BEGIN
114: UPDATE CZ_IMP_ITEM_MASTER
115: SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG),
116: SRC_TYPE_CODE = cnDefSrcTypeCode
117: WHERE ROWID = p_imp_itemmaster.ROWID;
118: nCOmmitCount:=nCommitCount+1;

Line 1007: FROM CZ_IMP_item_master

1003:
1004: DECLARE
1005: CURSOR c_xfr_run_result IS
1006: SELECT DISPOSITION,REC_STATUS,COUNT(*)
1007: FROM CZ_IMP_item_master
1008: WHERE RUN_ID = inRUN_ID
1009: GROUP BY DISPOSITION,REC_STATUS;
1010:
1011: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;