APPS.OZF_OM_PAYMENT_PVT dependencies on OZF_CLAIMS

Line 275: FROM ozf_claims

271: ,x_claim_rec.deduction_attribute14
272: ,x_claim_rec.deduction_attribute15
273: ,x_claim_rec.org_id
274: ,x_claim_rec.order_type_id
275: FROM ozf_claims
276: WHERE claim_id = p_claim_id ;
277:
278: x_return_status := FND_API.g_ret_sts_success;
279: EXCEPTION

Line 536: l_header_rec.orig_sys_document_ref := 'OZF_CLAIMS_ALL:'||p_x_claim_rec.claim_number;

532: IF l_tm_order_source_id IS NOT NULL THEN
533: l_header_rec.order_source_id := l_tm_order_source_id;
534: END IF;
535:
536: l_header_rec.orig_sys_document_ref := 'OZF_CLAIMS_ALL:'||p_x_claim_rec.claim_number;
537:
538: l_header_rec.order_type_id := p_x_claim_rec.order_type_id;
539:
540: l_header_rec.sold_to_org_id := p_x_claim_rec.cust_account_id;

Line 891: UPDATE ozf_claims_all

887: | 6. Update RMA order information in Claim after order is
888: | been successfully created.
889: *------------------------------------------------------*/
890:
891: UPDATE ozf_claims_all
892: SET payment_reference_id = l_x_header_rec.header_id
893: , payment_reference_number = l_x_header_rec.order_number
894: , payment_reference_date = l_x_header_rec.ordered_date
895: WHERE claim_id = p_x_claim_rec.claim_id;