[Home] [Help]
273: ,x_claim_rec.deduction_attribute15
274: ,x_claim_rec.org_id
275: ,x_claim_rec.wo_rec_trx_id
276: ,x_claim_rec.legal_entity_id
277: FROM ozf_claims_all
278: WHERE claim_id = p_claim_id ;
279: x_return_status := FND_API.g_ret_sts_success;
280: EXCEPTION
281: WHEN OTHERS THEN
469: --Start:Bug:2781186
470: --Cursor to get customer reason,customer ref, reason code id
471: CURSOR csr_get_more_root_clm_dtls (cv_claim_id IN NUMBER) IS
472: SELECT claim_number, claim_id, customer_ref_number
473: FROM ozf_claims_all
474: WHERE claim_id = cv_claim_id;
475:
476: --Cursor to get customer reason,customer ref, reason code id in case of child cliam
477: CURSOR csr_get_more_chld_clm_dtls (cv_claim_id IN NUMBER) IS
475:
476: --Cursor to get customer reason,customer ref, reason code id in case of child cliam
477: CURSOR csr_get_more_chld_clm_dtls (cv_claim_id IN NUMBER) IS
478: SELECT p.claim_number, p.claim_id, c.customer_ref_number
479: FROM ozf_claims c , ozf_claims p
480: WHERE c.claim_id = cv_claim_id
481: AND c.root_claim_id = p.claim_id;
482: --End:Bug:2781186
483:
847: l_root_claim_number VARCHAR2(30);
848:
849: CURSOR csr_root_claim_number(cv_root_claim_id IN NUMBER) IS
850: SELECT claim_number
851: FROM ozf_claims
852: WHERE claim_id = cv_root_claim_id;
853:
854: BEGIN
855: -------------------- initialize -----------------------
991: WHERE reason_code_id = cv_reason_code_id;
992:
993: CURSOR csr_root_claim_number(cv_root_claim_id IN NUMBER) IS
994: SELECT claim_number
995: FROM ozf_claims
996: WHERE claim_id = cv_root_claim_id;
997:
998: CURSOR csr_credit_amount(cv_customer_trx_id IN NUMBER) IS
999: SELECT SUM(NVL(amount_line_items_remaining, 0))
1296: SELECT customer_reason, customer_ref_number, reason_code_id
1297: --, customer_ref_date --11.5.10 enhancements - TM should pass
1298: -- Uncomment and Corresponding change for this has to be done while assigning to code after
1299: -- AR enhancement for this is done.
1300: FROM ozf_claims_all
1301: WHERE claim_id = cv_claim_id;
1302:
1303: -- Cursor to get claim reason name
1304: CURSOR csr_get_reason_name (cv_reason_code_id IN NUMBER) IS
1595: WHERE reason_code_id = cv_reason_code_id;
1596:
1597: CURSOR csr_root_claim_number(cv_root_claim_id IN NUMBER) IS
1598: SELECT claim_number
1599: FROM ozf_claims
1600: WHERE claim_id = cv_root_claim_id;
1601:
1602: CURSOR csr_claim_type_rec_trx(cv_claim_type_id IN NUMBER) IS
1603: SELECT adj_rec_trx_id
1615: --Start:Bug:2781186
1616: -- Cursor to get customer reason,customer ref, reason code id
1617: CURSOR csr_get_more_root_clm_dtls (cv_claim_id IN NUMBER) IS
1618: SELECT claim_number, claim_id, customer_ref_number
1619: FROM ozf_claims_all
1620: WHERE claim_id = cv_claim_id;
1621:
1622: --Cursor to get customer reason,customer ref, reason code id in case of child cliam
1623: CURSOR csr_get_more_chld_clm_dtls (cv_claim_id IN NUMBER) IS
1621:
1622: --Cursor to get customer reason,customer ref, reason code id in case of child cliam
1623: CURSOR csr_get_more_chld_clm_dtls (cv_claim_id IN NUMBER) IS
1624: SELECT p.claim_number, p.claim_id, c.customer_ref_number
1625: FROM ozf_claims c , ozf_claims p
1626: WHERE c.claim_id = cv_claim_id
1627: AND c.root_claim_id = p.claim_id;
1628: --End:Bug:2781186
1629:
1960:
1961: --//Bug 5345095 BK Modif
1962: IF l_receivables_trx_id IS NOT NULL THEN
1963: BEGIN
1964: UPDATE ozf_claims_all
1965: SET wo_rec_trx_id = l_receivables_trx_id
1966: WHERE claim_id = p_claim_rec.claim_id
1967: AND wo_rec_trx_id IS NULL;
1968:
3978: l_settlement_amount NUMBER := NULL ;
3979:
3980: -- Start Fix for Bug4324426
3981: CURSOR csr_ded_details(p_customer_trx_id IN NUMBER) IS
3982: SELECT claim_id, amount_due_remaining FROM ozf_claims_all, ar_payment_schedules_all
3983: WHERE source_object_id = customer_trx_id
3984: AND source_object_class = class
3985: AND claim_class = 'DEDUCTION'
3986: AND cust_account_id = customer_id