APPS.OZF_TRACING_ORDER_PVT dependencies on OZF_RESALE_LINES_INT_ALL

Line 178: FROM ozf_resale_lines_int_all

174: , bill_to_city
175: , bill_to_state
176: , bill_to_postal_code
177: , bill_to_country
178: FROM ozf_resale_lines_int_all
179: WHERE resale_batch_id = cv_resale_batch_id
180: AND status_code = 'PROCESSED'
181: AND ( duplicated_line_id IS NULL
182: OR ( duplicated_line_id IS NOT NULL AND duplicated_adjustment_id = -1))

Line 199: FROM ozf_resale_lines_int_all

195: , end_cust_state
196: , end_cust_postal_code
197: , end_cust_country
198: , end_cust_site_use_code
199: FROM ozf_resale_lines_int_all
200: WHERE resale_batch_id = cv_resale_batch_id
201: AND status_code = 'PROCESSED'
202: AND ( duplicated_line_id IS NULL
203: OR ( duplicated_line_id IS NOT NULL AND duplicated_adjustment_id = -1))

Line 354: UPDATE ozf_resale_lines_int_all

350: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
352: END IF;
353:
354: UPDATE ozf_resale_lines_int_all
355: SET bill_to_party_id = l_new_party_rec.party_id
356: , bill_to_party_site_id = l_new_party_rec.party_site_id
357: WHERE resale_batch_id = p_resale_batch_id
358: AND bill_to_party_id IS NULL

Line 409: UPDATE ozf_resale_lines_int_all

405: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
407: END IF;
408:
409: UPDATE ozf_resale_lines_int_all
410: SET end_cust_party_id = l_new_party_rec.party_id
411: , end_cust_party_site_id = l_new_party_rec.party_site_id
412: WHERE resale_batch_id = p_resale_batch_id
413: AND end_cust_party_id IS NULL

Line 471: UPDATE ozf_resale_lines_int_all

467:
468: -- There is something wrong with this order. dispute all the orders
469: -- and move to the next one.
470: -- JXWU move update to common pvt
471: UPDATE ozf_resale_lines_int_all
472: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
473: dispute_code = 'OZF_RESALE_MULTI_HEADER',
474: followup_action_code = NVL2(followup_action_code,followup_action_code,'C'),
475: response_type = 'CA',

Line 723: UPDATE ozf_resale_lines_int_all

719:
720: -- UPDATE batch line status to CLOSEd for each OPEN and duplicated lines.
721:
722: BEGIN
723: UPDATE ozf_resale_lines_int_all
724: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_CLOSED
725: WHERE resale_batch_id = p_resale_batch_id
726: --Bug# 8414563 fixed by ateotia(+)
727: --AND status_code in(OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED);

Line 878: FROM ozf_resale_lines_int_all b

874: FND_MESSAGE.get_string('OZF','OZF_RESALE_NON_TRC'),
875: 'TRACING_FLAG',
876: tracing_flag,
877: org_id
878: FROM ozf_resale_lines_int_all b
879: WHERE b.status_code = 'OPEN'
880: AND b.tracing_flag = 'F'
881: AND b.resale_batch_id = p_resale_batch_id
882: AND NOT EXISTS(SELECT 1

Line 897: UPDATE ozf_resale_lines_int_all

893: p_token_value => l_full_name||': END');
894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
895: END;
896:
897: UPDATE ozf_resale_lines_int_all
898: SET status_code = 'DISPUTED',
899: dispute_code = 'OZF_RESALE_NON_TRC',
900: followup_action_code = NVL2(followup_action_code,followup_action_code,'C'),
901: response_type = 'CA',