APPS.CZ_IMP_PR_XFR dependencies on CZ_IMP_PRICE

Line 19: FROM CZ_IMP_PRICE_GROUP WHERE CZ_IMP_PRICE_GROUP.RUN_ID = inRUN_ID AND REC_STATUS='PASS';

15: SELECT PRICE_GROUP_ID,DESC_TEXT,NAME,CURRENCY,RUN_ID,DISPOSITION,DELETED_FLAG,
16: USER_STR01,USER_STR02,USER_STR03,USER_STR04,
17: USER_NUM01,USER_NUM02,USER_NUM03,USER_NUM04,CREATION_DATE,LAST_UPDATE_DATE,
18: CREATED_BY,LAST_UPDATED_BY,SECURITY_MASK,CHECKOUT_USER,ORIG_SYS_REF
19: FROM CZ_IMP_PRICE_GROUP WHERE CZ_IMP_PRICE_GROUP.RUN_ID = inRUN_ID AND REC_STATUS='PASS';
20: X_XFR_PRICEGROUP_F BOOLEAN:=FALSE;
21: X_ERROR BOOLEAN:=FALSE;
22: P_XFR_PRICEGROUP C_XFR_PRICE_GROUP%ROWTYPE;
23: /* INTERNAL VARS*/

Line 102: UPDATE CZ_IMP_price_group

98: 1,1,NULL,P_XFR_PRICEGROUP.CHECKOUT_USER,
99: P_XFR_PRICEGROUP.ORIG_SYS_REF);
100: NINSERTCOUNT:=NINSERTCOUNT+1;
101: BEGIN
102: UPDATE CZ_IMP_price_group
103: SET REC_STATUS='OK'
104: WHERE PRICE_GROUP_ID=p_xfr_pricegroup.PRICE_GROUP_ID AND RUN_ID=inRUN_ID;
105: END;
106: EXCEPTION

Line 110: UPDATE CZ_IMP_price_group

106: EXCEPTION
107: WHEN OTHERS THEN
108: NFAILED:=NFAILED +1;
109: BEGIN
110: UPDATE CZ_IMP_price_group
111: SET REC_STATUS='ERR'
112: WHERE PRICE_GROUP_ID=p_xfr_pricegroup.PRICE_GROUP_ID AND RUN_ID=inRUN_ID;
113: END;
114: X_ERROR:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_XFR.XFR_PRICE_GROUP',11276);

Line 146: UPDATE CZ_IMP_price_group

142: NFAILED :=NFAILED+1;
143: ELSE
144: NUPDATECOUNT :=NUPDATECOUNT+1;
145: BEGIN
146: UPDATE CZ_IMP_price_group
147: SET REC_STATUS='OK'
148: WHERE PRICE_GROUP_ID=p_xfr_pricegroup.PRICE_GROUP_ID AND RUN_ID=inRUN_ID;
149: END;
150: END IF;

Line 155: UPDATE CZ_IMP_price_group

151: EXCEPTION
152: WHEN OTHERS THEN
153: NFAILED :=NFAILED+1;
154: BEGIN
155: UPDATE CZ_IMP_price_group
156: SET REC_STATUS='ERR'
157: WHERE PRICE_GROUP_ID=p_xfr_pricegroup.PRICE_GROUP_ID AND RUN_ID=inRUN_ID;
158: END;
159: X_ERROR:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_XFR.XFR_PRICE_GROUP',11276);

Line 186: FROM CZ_IMP_PRICE

182: BEGIN
183: DECLARE CURSOR C_XFR_PRICE
184: IS
185: SELECT *
186: FROM CZ_IMP_PRICE
187: WHERE CZ_IMP_PRICE.RUN_ID = inRUN_ID AND REC_STATUS='PASS';
188: X_XFR_PRICE_F BOOLEAN:=FALSE;
189: X_ERROR BOOLEAN:=FALSE;
190: P_XFR_PRICE C_XFR_PRICE%ROWTYPE;

Line 187: WHERE CZ_IMP_PRICE.RUN_ID = inRUN_ID AND REC_STATUS='PASS';

183: DECLARE CURSOR C_XFR_PRICE
184: IS
185: SELECT *
186: FROM CZ_IMP_PRICE
187: WHERE CZ_IMP_PRICE.RUN_ID = inRUN_ID AND REC_STATUS='PASS';
188: X_XFR_PRICE_F BOOLEAN:=FALSE;
189: X_ERROR BOOLEAN:=FALSE;
190: P_XFR_PRICE C_XFR_PRICE%ROWTYPE;
191: /* INTERNAL VARS*/

Line 242: UPDATE CZ_IMP_price

238: P_XFR_PRICE.DELETED_FLAG,
239: SYSDATE,SYSDATE,1,1,NULL,P_XFR_PRICE.CHECKOUT_USER);
240: NINSERTCOUNT:=NINSERTCOUNT+1;
241: BEGIN
242: UPDATE CZ_IMP_price
243: SET REC_STATUS='OK'
244: WHERE PRICE_GROUP_ID=p_xfr_price.PRICE_GROUP_ID
245: AND ITEM_ID=P_XFR_PRICE.ITEM_ID AND RUN_ID=inRUN_ID;
246: END;

Line 251: UPDATE CZ_IMP_price

247: EXCEPTION
248: WHEN OTHERS THEN
249: NFAILED:=NFAILED +1;
250: BEGIN
251: UPDATE CZ_IMP_price
252: SET REC_STATUS='ERR'
253: WHERE PRICE_GROUP_ID=p_xfr_price.PRICE_GROUP_ID
254: AND ITEM_ID=P_XFR_PRICE.ITEM_ID AND RUN_ID=inRUN_ID;
255: END;

Line 279: UPDATE CZ_IMP_price

275: NFAILED :=NFAILED+1;
276: ELSE
277: NUPDATECOUNT :=NUPDATECOUNT+1;
278: BEGIN
279: UPDATE CZ_IMP_price
280: SET REC_STATUS='OK'
281: WHERE PRICE_GROUP_ID=p_xfr_price.PRICE_GROUP_ID
282: AND ITEM_ID=P_XFR_PRICE.ITEM_ID AND RUN_ID=inRUN_ID;
283: END;

Line 289: UPDATE CZ_IMP_price

285: EXCEPTION
286: WHEN OTHERS THEN
287: NFAILED :=NFAILED+1;
288: BEGIN
289: UPDATE CZ_IMP_price
290: SET REC_STATUS='ERR'
291: WHERE PRICE_GROUP_ID=p_xfr_price.PRICE_GROUP_ID
292: AND ITEM_ID=P_XFR_PRICE.ITEM_ID AND RUN_ID=inRUN_ID;
293: END;