APPS.OZF_SPECIAL_PRICING_PVT dependencies on OZF_RESALE_LINES_INT_ALL

Line 392: UPDATE ozf_resale_lines_int_all

388:
389: -- There is something wrong with this order. dispute all the orders
390: -- and move to the next one.
391: -- JXWU move update to common pvt
392: UPDATE ozf_resale_lines_int_all
393: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
394: dispute_code = 'OZF_RESALE_MULTI_HEADER',
395: followup_action_code = NVL2(followup_action_code,followup_action_code,'C'),
396: response_type = 'CA',

Line 838: FROM ozf_resale_lines_int_all b

834: FND_MESSAGE.get_string('OZF','OZF_RESALE_AGR_TYPE_WNG'),
835: 'AGREEMENT_TYPE',
836: NULL,
837: org_id
838: FROM ozf_resale_lines_int_all b
839: WHERE b.status_code = 'OPEN'
840: AND b.tracing_flag = 'F'
841: AND b.agreement_type <>'SPO'
842: AND b.resale_batch_id = p_resale_batch_id

Line 859: UPDATE ozf_resale_lines_int_all

855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
856: END;
857:
858: BEGIN
859: UPDATE ozf_resale_lines_int_all
860: SET status_code = 'DISPUTED',
861: dispute_code = 'OZF_RESALE_AGRM_TYPE_WNG',
862: followup_action_code = NVL2(followup_action_code,followup_action_code,'C'),
863: response_type = 'CA',

Line 898: FROM ozf_resale_lines_int_all b

894: fnd_message.get_string('OZF','OZF_RESALE_PUR_PRICE_MISSING'),
895: 'PURCHASE_PRICE',
896: NULL,
897: org_id
898: FROM ozf_resale_lines_int_all b
899: WHERE b.status_code = 'OPEN'
900: AND b.tracing_flag = 'F'
901: AND b.purchase_price IS NULL
902: AND b.resale_batch_id = p_resale_batch_id

Line 919: UPDATE ozf_resale_lines_int_all

915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
916: END;
917:
918: BEGIN
919: UPDATE ozf_resale_lines_int_all
920: SET status_code = 'DISPUTED',
921: dispute_code = 'OZF_RESALE_PUR_PRICE_MISSING',
922: followup_action_code = NVL2(followup_action_code,followup_action_code,'C'),
923: response_type = 'CA',

Line 1246: UPDATE ozf_resale_lines_int_all

1242: END IF;
1243:
1244: -- SET Batch as DISPUTED
1245: -- SLKRISHN change to common procedure
1246: UPDATE ozf_resale_lines_int_all
1247: SET status_code = 'DISPUTED',
1248: dispute_code = 'OZF_LT_INVT',
1249: followup_action_code = NVL2(followup_action_code,followup_action_code,'C'),
1250: response_type = 'CA',

Line 1254: UPDATE ozf_resale_lines_int_all

1250: response_type = 'CA',
1251: response_code = 'N'
1252: WHERE resale_line_int_id = l_resale_int_rec.resale_line_int_id;
1253: ELSE
1254: UPDATE ozf_resale_lines_int_all
1255: SET status_code= 'PROCESSED'
1256: WHERE resale_line_int_id = l_resale_int_rec.resale_line_int_id
1257: AND tracing_flag = 'T';
1258: END IF;

Line 1261: UPDATE ozf_resale_lines_int_all

1257: AND tracing_flag = 'T';
1258: END IF;
1259: ELSE
1260: -- 7570302 update stock sale line to PROCESSED if inventory validation disabled
1261: UPDATE ozf_resale_lines_int_all
1262: SET status_code= 'PROCESSED'
1263: WHERE resale_line_int_id = l_resale_int_rec.resale_line_int_id
1264: AND tracing_flag = 'T';
1265: END IF;

Line 1270: /* UPDATE ozf_resale_lines_int_all

1266: END LOOP;
1267: END IF;
1268: -- the following piece of code has been commented in order to validate the tracing lines.
1269: -- ???? UPDATE tracing order lines to processed for this order to be processed
1270: /* UPDATE ozf_resale_lines_int_all
1271: SET status_code = 'PROCESSED'
1272: WHERE status_code = 'OPEN'
1273: AND order_number = p_order_number
1274: AND sold_from_cust_account_id = p_sold_from_cust_account_id

Line 1355: UPDATE ozf_resale_lines_int_all

1351: END IF;
1352: --
1353: -- SET Batch as DISPUTED
1354: -- SLKRISHN change to common procedure
1355: UPDATE ozf_resale_lines_int_all
1356: SET status_code = 'DISPUTED',
1357: dispute_code = 'OZF_LT_INVT',
1358: followup_action_code = 'C',
1359: response_type = 'CA',