APPS.OZF_SPECIAL_PRICING_PVT dependencies on OZF_RESALE_LINES_INT_ALL

Line 367: UPDATE ozf_resale_lines_int_all

363:
364: -- There is something wrong with this order. dispute all the orders
365: -- and move to the next one.
366: -- JXWU move update to common pvt
367: UPDATE ozf_resale_lines_int_all
368: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
369: dispute_code = 'OZF_RESALE_MULTI_HEADER',
370: followup_action_code = 'C',
371: response_type = 'CA',

Line 782: FROM ozf_resale_lines_int_all b

778: FND_MESSAGE.get_string('OZF','OZF_RESALE_AGR_TYPE_WNG'),
779: 'AGREEMENT_TYPE',
780: NULL,
781: org_id
782: FROM ozf_resale_lines_int_all b
783: WHERE b.status_code = 'OPEN'
784: AND b.tracing_flag = 'F'
785: AND b.agreement_type <>'SPO'
786: AND b.resale_batch_id = p_resale_batch_id

Line 803: UPDATE ozf_resale_lines_int_all

799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
800: END;
801:
802: BEGIN
803: UPDATE ozf_resale_lines_int_all
804: SET status_code = 'DISPUTED',
805: dispute_code = 'OZF_RESALE_AGRM_TYPE_WNG',
806: followup_action_code = 'C',
807: response_type = 'CA',

Line 842: FROM ozf_resale_lines_int_all b

838: fnd_message.get_string('OZF','OZF_RESALE_PUR_PRICE_MISSING'),
839: 'PURCHASE_PRICE',
840: NULL,
841: org_id
842: FROM ozf_resale_lines_int_all b
843: WHERE b.status_code = 'OPEN'
844: AND b.tracing_flag = 'F'
845: AND b.purchase_price IS NULL
846: AND b.resale_batch_id = p_resale_batch_id

Line 863: UPDATE ozf_resale_lines_int_all

859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
860: END;
861:
862: BEGIN
863: UPDATE ozf_resale_lines_int_all
864: SET status_code = 'DISPUTED',
865: dispute_code = 'OZF_RESALE_PUR_PRICE_MISSING',
866: followup_action_code = 'C',
867: response_type = 'CA',

Line 1170: UPDATE ozf_resale_lines_int_all

1166: END IF;
1167:
1168: -- SET Batch as DISPUTED
1169: -- SLKRISHN change to common procedure
1170: UPDATE ozf_resale_lines_int_all
1171: SET status_code = 'DISPUTED',
1172: dispute_code = 'OZF_LT_INVT',
1173: followup_action_code = 'C',
1174: response_type = 'CA',

Line 1178: UPDATE ozf_resale_lines_int_all

1174: response_type = 'CA',
1175: response_code = 'N'
1176: WHERE resale_line_int_id = l_resale_int_rec.resale_line_int_id;
1177: ELSE
1178: UPDATE ozf_resale_lines_int_all
1179: SET status_code= 'PROCESSED'
1180: WHERE resale_line_int_id = l_resale_int_rec.resale_line_int_id
1181: AND tracing_flag = 'T';
1182: END IF;

Line 1185: UPDATE ozf_resale_lines_int_all

1181: AND tracing_flag = 'T';
1182: END IF;
1183: ELSE
1184: -- 7570302 update stock sale line to PROCESSED if inventory validation disabled
1185: UPDATE ozf_resale_lines_int_all
1186: SET status_code= 'PROCESSED'
1187: WHERE resale_line_int_id = l_resale_int_rec.resale_line_int_id
1188: AND tracing_flag = 'T';
1189: END IF;

Line 1194: /* UPDATE ozf_resale_lines_int_all

1190: END LOOP;
1191: END IF;
1192: -- the following piece of code has been commented in order to validate the tracing lines.
1193: -- ???? UPDATE tracing order lines to processed for this order to be processed
1194: /* UPDATE ozf_resale_lines_int_all
1195: SET status_code = 'PROCESSED'
1196: WHERE status_code = 'OPEN'
1197: AND order_number = p_order_number
1198: AND sold_from_cust_account_id = p_sold_from_cust_account_id

Line 1275: UPDATE ozf_resale_lines_int_all

1271: END IF;
1272: --
1273: -- SET Batch as DISPUTED
1274: -- SLKRISHN change to common procedure
1275: UPDATE ozf_resale_lines_int_all
1276: SET status_code = 'DISPUTED',
1277: dispute_code = 'OZF_LT_INVT',
1278: followup_action_code = 'C',
1279: response_type = 'CA',