APPS.OZF_CHARGEBACK_PVT dependencies on OZF_RESALE_LINES_INT_ALL

Line 183: FROM ozf_resale_lines_int_all

179: , bill_to_city
180: , bill_to_state
181: , bill_to_postal_code
182: , bill_to_country
183: FROM ozf_resale_lines_int_all
184: WHERE resale_batch_id = cv_resale_batch_id
185: AND status_code = 'PROCESSED'
186: AND ( duplicated_line_id IS NULL
187: OR ( duplicated_line_id IS NOT NULL AND duplicated_adjustment_id = -1))

Line 204: FROM ozf_resale_lines_int_all

200: , end_cust_state
201: , end_cust_postal_code
202: , end_cust_country
203: , end_cust_site_use_code
204: FROM ozf_resale_lines_int_all
205: WHERE resale_batch_id = cv_resale_batch_id
206: AND status_code = 'PROCESSED'
207: AND ( duplicated_line_id IS NULL
208: OR ( duplicated_line_id IS NOT NULL AND duplicated_adjustment_id = -1))

Line 384: UPDATE ozf_resale_lines_int_all

380: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
382: END IF;
383:
384: UPDATE ozf_resale_lines_int_all
385: SET bill_to_party_id = l_new_party_rec.party_id
386: , bill_to_party_site_id = l_new_party_rec.party_site_id
387: WHERE resale_batch_id = p_resale_batch_id
388: AND bill_to_party_id IS NULL

Line 439: UPDATE ozf_resale_lines_int_all

435: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
437: END IF;
438:
439: UPDATE ozf_resale_lines_int_all
440: SET end_cust_party_id = l_new_party_rec.party_id
441: , end_cust_party_site_id = l_new_party_rec.party_site_id
442: WHERE resale_batch_id = p_resale_batch_id
443: AND end_cust_party_id IS NULL

Line 503: UPDATE ozf_resale_lines_int_all

499:
500: -- There is something wrong with this order. dispute all the orders
501: -- and move to the next one.
502: -- JXWU move update to common pvt
503: UPDATE ozf_resale_lines_int_all
504: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
505: dispute_code = 'OZF_RESALE_MULTI_HEADER',
506: followup_action_code = 'C',
507: response_type = 'CA',

Line 958: FROM ozf_resale_lines_int_all

954: SELECT resale_line_int_id,
955: 'OZF_RESALE_PUR_PRICE_MISSING',
956: 'PURCHASE_PRICE',
957: NULL
958: FROM ozf_resale_lines_int_all
959: WHERE resale_batch_id = p_batch_id
960: AND status_code IN (OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED)
961: AND tracing_flag = 'F'
962: AND purchase_price IS NULL;

Line 1283: UPDATE ozf_resale_lines_int_all

1279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1280: END IF;
1281:
1282: BEGIN
1283: UPDATE ozf_resale_lines_int_all
1284: SET status_code =OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1285: dispute_code = 'OZF_RESALE_PRICE_ERROR',
1286: followup_action_code = 'C',
1287: response_type = 'CA',

Line 2358: UPDATE ozf_resale_lines_int_all

2354: GOTO END_LOOP;
2355: END IF;
2356:
2357: -- Bug 4387465 (+)
2358: UPDATE ozf_resale_lines_int_all
2359: SET status_code= 'PROCESSED'
2360: WHERE status_code = 'OPEN'
2361: AND order_number = l_order_num_tbl(i)
2362: AND sold_from_cust_account_id = l_cust_account_id_tbl(i)