APPS.OZF_CHARGEBACK_PVT dependencies on OZF_RESALE_LINES_INT_ALL

Line 249: FROM ozf_resale_lines_int_all

245: , bill_to_city
246: , bill_to_state
247: , bill_to_postal_code
248: , bill_to_country
249: FROM ozf_resale_lines_int_all
250: WHERE resale_batch_id = cv_resale_batch_id
251: AND status_code = 'PROCESSED'
252: AND ( duplicated_line_id IS NULL
253: OR ( duplicated_line_id IS NOT NULL AND duplicated_adjustment_id = -1))

Line 270: FROM ozf_resale_lines_int_all

266: , end_cust_state
267: , end_cust_postal_code
268: , end_cust_country
269: , end_cust_site_use_code
270: FROM ozf_resale_lines_int_all
271: WHERE resale_batch_id = cv_resale_batch_id
272: AND status_code = 'PROCESSED'
273: AND ( duplicated_line_id IS NULL
274: OR ( duplicated_line_id IS NOT NULL AND duplicated_adjustment_id = -1))

Line 550: UPDATE ozf_resale_lines_int_all

546: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
548: END IF;
549:
550: UPDATE ozf_resale_lines_int_all
551: SET bill_to_party_id = l_new_party_rec.party_id
552: , bill_to_party_site_id = l_new_party_rec.party_site_id
553: WHERE resale_batch_id = p_resale_batch_id
554: AND bill_to_party_id IS NULL

Line 605: UPDATE ozf_resale_lines_int_all

601: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
603: END IF;
604:
605: UPDATE ozf_resale_lines_int_all
606: SET end_cust_party_id = l_new_party_rec.party_id
607: , end_cust_party_site_id = l_new_party_rec.party_site_id
608: WHERE resale_batch_id = p_resale_batch_id
609: AND end_cust_party_id IS NULL

Line 680: UPDATE ozf_resale_lines_int_all

676:
677: -- There is something wrong with this order. dispute all the orders
678: -- and move to the next one.
679: -- JXWU move update to common pvt
680: UPDATE ozf_resale_lines_int_all
681: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
682: dispute_code = 'OZF_RESALE_MULTI_HEADER',
683: followup_action_code = 'C',
684: response_type = 'CA',

Line 1212: FROM ozf_resale_lines_int_all

1208: SELECT resale_line_int_id,
1209: 'OZF_RESALE_PUR_PRICE_MISSING',
1210: 'PURCHASE_PRICE',
1211: NULL
1212: FROM ozf_resale_lines_int_all
1213: WHERE resale_batch_id = p_batch_id
1214: AND status_code IN (OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED)
1215: AND tracing_flag = 'F'
1216: AND purchase_price IS NULL;

Line 1541: UPDATE ozf_resale_lines_int_all

1537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1538: END IF;
1539:
1540: BEGIN
1541: UPDATE ozf_resale_lines_int_all
1542: SET status_code =OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1543: dispute_code = 'OZF_RESALE_PRICE_ERROR',
1544: followup_action_code = NVL2(followup_action_code,followup_action_code,'C'),
1545: response_type = 'CA',

Line 2623: UPDATE ozf_resale_lines_int_all

2619: GOTO END_LOOP;
2620: END IF;
2621:
2622: -- Bug 4387465 (+)
2623: UPDATE ozf_resale_lines_int_all
2624: SET status_code= 'PROCESSED'
2625: WHERE status_code = 'OPEN'
2626: AND order_number = l_order_num_tbl(i)
2627: AND sold_from_cust_account_id = l_cust_account_id_tbl(i)