APPS.CZ_IMP_PR_XFR dependencies on CZ_IMP_PRICE_GROUP

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);