APPS.OZF_AP_INTERFACE_PVT dependencies on OZF_CLAIMS_ALL

Line 142: FROM ozf_claims_all

138: ,x_claim_rec.effective_date
139: ,x_claim_rec.comments
140: ,x_claim_rec.org_id
141: ,x_claim_rec.legal_entity_id
142: FROM ozf_claims_all
143: WHERE claim_id = p_claim_id ;
144:
145: x_return_status := FND_API.g_ret_sts_success;
146: EXCEPTION

Line 561: ,'OZF_CLAIMS_ALL'

557: ,l_vendor_clearing_account
558: ,l_claim_rec.org_id
559: ,l_final_descr
560: ,682
561: ,'OZF_CLAIMS_ALL'
562: ,l_claim_rec.claim_id
563: ,l_claim_rec.customer_ref_date
564: ,l_claim_rec.customer_ref_number
565: ,l_claim_rec.customer_reason

Line 648: ,'OZF_CLAIMS_ALL'

644: ,l_accts_pay_code_comb_id
645: ,l_claim_rec.org_id
646: ,l_claim_rec.legal_entity_id
647: ,682
648: ,'OZF_CLAIMS_ALL'
649: ,l_claim_rec.claim_id
650: ,l_claim_rec.customer_ref_date
651: ,l_claim_rec.customer_ref_number
652: ,l_claim_rec.customer_reason

Line 659: UPDATE ozf_claims_all

655: , 'Y'
656: );
657:
658: --Update payment information in Claim after invoice is been created.
659: UPDATE ozf_claims_all
660: SET payment_reference_id = l_invoice_id
661: , payment_reference_number = l_claim_number
662: , payment_reference_date = l_claim_rec.settled_date
663: , payment_status = 'INTERFACED'

Line 667: UPDATE ozf_claims_all

663: , payment_status = 'INTERFACED'
664: WHERE claim_id = p_claim_id;
665: -- if invoice is already created, update payment_status and payment_reference_number only
666: ELSE -- [ if l_x_claim_number is NOT NULL ]
667: UPDATE ozf_claims_all
668: SET payment_status = 'INTERFACED'
669: , payment_reference_number = l_claim_number
670: , payment_reference_date = l_claim_rec.settled_date
671: , payment_reference_id = l_invoice_id