DBA Data[Home] [Help]

APPS.OZF_AP_INTERFACE_PVT dependencies on OZF_CLAIMS_ALL

Line 144: FROM ozf_claims_all

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

Line 620: ,'OZF_CLAIMS_ALL'

616: ,l_vendor_clearing_account
617: ,l_claim_rec.org_id
618: ,l_final_descr
619: ,682
620: ,'OZF_CLAIMS_ALL'
621: ,l_claim_rec.claim_id
622: ,l_claim_rec.customer_ref_date
623: ,l_claim_rec.customer_ref_number
624: ,l_claim_rec.customer_reason

Line 729: ,'OZF_CLAIMS_ALL'

725: ,l_accts_pay_code_comb_id
726: ,l_claim_rec.org_id
727: ,l_claim_rec.legal_entity_id
728: ,682
729: ,'OZF_CLAIMS_ALL'
730: ,l_claim_rec.claim_id
731: ,l_claim_rec.customer_ref_date
732: ,l_claim_rec.customer_ref_number
733: ,l_claim_rec.customer_reason

Line 742: UPDATE ozf_claims_all

738: , l_lookup_type_code
739: );
740:
741: --Update payment information in Claim after invoice is been created.
742: UPDATE ozf_claims_all
743: SET payment_reference_id = l_invoice_id
744: , payment_reference_number = l_claim_number
745: , payment_reference_date = l_claim_rec.settled_date
746: , payment_status = 'INTERFACED'

Line 750: UPDATE ozf_claims_all

746: , payment_status = 'INTERFACED'
747: WHERE claim_id = p_claim_id;
748: -- if invoice is already created, update payment_status and payment_reference_number only
749: ELSE -- [ if l_x_claim_number is NOT NULL ]
750: UPDATE ozf_claims_all
751: SET payment_status = 'INTERFACED'
752: , payment_reference_number = l_claim_number
753: , payment_reference_date = l_claim_rec.settled_date
754: , payment_reference_id = l_invoice_id