DBA Data[Home] [Help]

APPS.OZF_AR_INTERFACE_PVT dependencies on OZF_CLAIMS_ALL

Line 282: FROM ozf_claims_all

278: ,x_claim_rec.org_id
279: ,x_claim_rec.customer_reason -- 11.5.10 Enhancements. TM should pass.
280: ,x_claim_rec.ship_to_cust_account_id
281: ,x_claim_rec.legal_entity_id
282: FROM ozf_claims_all
283: WHERE claim_id = p_claim_id ;
284:
285: x_return_status := FND_API.g_ret_sts_success;
286: EXCEPTION

Line 2051: , ozf_claims_all oc

2047:
2048: CURSOR claim_gl_posting_csr(p_id in number) IS
2049: SELECT osp.post_to_gl
2050: FROM ozf_sys_parameters_all osp
2051: , ozf_claims_all oc
2052: WHERE NVL(osp.org_id, -99) = NVL(oc.org_id, -99)
2053: AND oc.claim_id = p_id;
2054:
2055:

Line 2165: UPDATE ozf_claims_all

2161:
2162: /* ------- End API Logic ------------------------------------- */
2163:
2164: /* ------- Begin Update Claim Payment Status ----------------- */
2165: UPDATE ozf_claims_all
2166: SET payment_status = 'INTERFACED'
2167: WHERE claim_id = p_claim_id;
2168: /* ------- End Update Claim Payment Status ------------------- */
2169: