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 2042: , ozf_claims_all oc

2038:
2039: CURSOR claim_gl_posting_csr(p_id in number) IS
2040: SELECT osp.post_to_gl
2041: FROM ozf_sys_parameters_all osp
2042: , ozf_claims_all oc
2043: WHERE NVL(osp.org_id, -99) = NVL(oc.org_id, -99)
2044: AND oc.claim_id = p_id;
2045:
2046:

Line 2156: UPDATE ozf_claims_all

2152:
2153: /* ------- End API Logic ------------------------------------- */
2154:
2155: /* ------- Begin Update Claim Payment Status ----------------- */
2156: UPDATE ozf_claims_all
2157: SET payment_status = 'INTERFACED'
2158: WHERE claim_id = p_claim_id;
2159: /* ------- End Update Claim Payment Status ------------------- */
2160: