APPS.OZF_TRACING_ORDER_PVT dependencies on OZF_RESALE_LINES_INT_ALL

Line 164: FROM ozf_resale_lines_int_all

160: , bill_to_city
161: , bill_to_state
162: , bill_to_postal_code
163: , bill_to_country
164: FROM ozf_resale_lines_int_all
165: WHERE resale_batch_id = cv_resale_batch_id
166: AND status_code = 'PROCESSED'
167: AND ( duplicated_line_id IS NULL
168: OR ( duplicated_line_id IS NOT NULL AND duplicated_adjustment_id = -1))

Line 185: FROM ozf_resale_lines_int_all

181: , end_cust_state
182: , end_cust_postal_code
183: , end_cust_country
184: , end_cust_site_use_code
185: FROM ozf_resale_lines_int_all
186: WHERE resale_batch_id = cv_resale_batch_id
187: AND status_code = 'PROCESSED'
188: AND ( duplicated_line_id IS NULL
189: OR ( duplicated_line_id IS NOT NULL AND duplicated_adjustment_id = -1))

Line 312: UPDATE ozf_resale_lines_int_all

308: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
310: END IF;
311:
312: UPDATE ozf_resale_lines_int_all
313: SET bill_to_party_id = l_new_party_rec.party_id
314: , bill_to_party_site_id = l_new_party_rec.party_site_id
315: WHERE resale_batch_id = p_resale_batch_id
316: AND bill_to_party_id IS NULL

Line 367: UPDATE ozf_resale_lines_int_all

363: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
365: END IF;
366:
367: UPDATE ozf_resale_lines_int_all
368: SET end_cust_party_id = l_new_party_rec.party_id
369: , end_cust_party_site_id = l_new_party_rec.party_site_id
370: WHERE resale_batch_id = p_resale_batch_id
371: AND end_cust_party_id IS NULL

Line 427: UPDATE ozf_resale_lines_int_all

423:
424: -- There is something wrong with this order. dispute all the orders
425: -- and move to the next one.
426: -- JXWU move update to common pvt
427: UPDATE ozf_resale_lines_int_all
428: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
429: dispute_code = 'OZF_RESALE_MULTI_HEADER',
430: followup_action_code = 'C',
431: response_type = 'CA',

Line 821: FROM ozf_resale_lines_int_all b

817: FND_MESSAGE.get_string('OZF','OZF_RESALE_NON_TRC'),
818: 'TRACING_FLAG',
819: tracing_flag,
820: org_id
821: FROM ozf_resale_lines_int_all b
822: WHERE b.status_code = 'OPEN'
823: AND b.tracing_flag = 'F'
824: AND b.resale_batch_id = p_resale_batch_id
825: AND NOT EXISTS(SELECT 1

Line 840: UPDATE ozf_resale_lines_int_all

836: p_token_value => l_full_name||': END');
837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
838: END;
839:
840: UPDATE ozf_resale_lines_int_all
841: SET status_code = 'DISPUTED',
842: dispute_code = 'OZF_RESALE_NON_TRC',
843: followup_action_code = 'C',
844: response_type = 'CA',