[Home] [Help]
14: IS
15:
16: CURSOR csr_claim IS
17: SELECT org_id
18: FROM ozf_claims_all
19: WHERE cstl_wf_item_key = p_item_key;
20:
21: l_org_id NUMBER;
22:
201: CURSOR csr_claim_version(cv_claim_id IN NUMBER) IS
202: SELECT object_version_number
203: , status_code
204: , org_id
205: FROM ozf_claims_all
206: WHERE claim_id = cv_claim_id;
207:
208: l_claim_id NUMBER;
209: l_object_version NUMBER;
361: SELECT root_claim_id
362: , payment_method
363: , vendor_id
364: , vendor_site_id
365: FROM ozf_claims_all
366: WHERE claim_id = cv_claim_id;
367:
368: /* == Stuff used for Getting Split info ==== */
369:
368: /* == Stuff used for Getting Split info ==== */
369:
370: CURSOR csr_is_split( cv_claim_id IN NUMBER ) IS
371: SELECT COUNT(claim_id)
372: FROM ozf_claims
373: WHERE root_claim_id = cv_claim_id ;
374:
375: CURSOR csr_get_split_details (cv_claim_id IN NUMBER ) IS
376: SELECT c.claim_number,
377: lk.meaning,
378: c.amount,
379: c.amount_remaining,
380: c.amount_settled
381: FROM ozf_claims c
382: , ozf_lookups lk
383: WHERE root_claim_id = cv_claim_id
384: AND c.status_code = lk.lookup_code
385: AND lk.lookup_type = 'OZF_CLAIM_STATUS'
839: -- Cursor to get claim payment_method
840: CURSOR csr_get_settle_method(cv_claim_id IN NUMBER) IS
841: SELECT payment_method
842: , org_id
843: FROM ozf_claims_all
844: WHERE claim_id = cv_claim_id;
845:
846:
847: TYPE trx_number_type IS VARRAY(5) OF VARCHAR2(30);
1317: l_trx_attribute_name VARCHAR2(30);
1318:
1319: CURSOR csr_get_org(cv_claim_id IN NUMBER) IS
1320: SELECT org_id
1321: FROM ozf_claims_all
1322: WHERE claim_id = cv_claim_id;
1323:
1324: CURSOR csr_del_settle_doc(cv_claim_id IN NUMBER) IS
1325: SELECT settlement_doc_id
1543:
1544: CURSOR csr_claim_version(cv_claim_id IN NUMBER) IS
1545: SELECT object_version_number
1546: , org_id
1547: FROM ozf_claims_all
1548: WHERE claim_id = cv_claim_id;
1549:
1550: CURSOR csr_user_status_id(cv_status_code IN VARCHAR2) IS
1551: SELECT user_status_id
1727:
1728: CURSOR csr_claim_version(cv_claim_id IN NUMBER) IS
1729: SELECT object_version_number
1730: , org_id
1731: FROM ozf_claims_all
1732: WHERE claim_id = cv_claim_id;
1733:
1734: CURSOR csr_user_status_id(cv_status_code IN VARCHAR2) IS
1735: SELECT user_status_id
1909: , root_claim_id
1910: , sales_rep_id
1911: , vendor_id
1912: , vendor_site_id
1913: FROM ozf_claims_all
1914: WHERE claim_id = cv_claim_id;
1915:
1916: CURSOR csr_owner(cv_owner_id IN NUMBER) IS
1917: SELECT fnd.user_name
2439:
2440: --kdass - Bug 9137090 - commented since this debug message introduced junk character in the out param l_msg_data
2441: --OZF_Utility_PVT.debug_message('Start == Item Type:'||l_itemtype||'-- Item key:'||l_itemkey);
2442: BEGIN
2443: UPDATE ozf_claims_all
2444: SET cstl_wf_item_key = l_itemkey
2445: WHERE claim_id = p_claim_id;
2446: EXCEPTION
2447: WHEN OTHERS THEN
2512: -- Bug4308173
2513: CURSOR claim_gl_posting_csr(p_id in number) IS
2514: SELECT osp.post_to_gl
2515: FROM ozf_sys_parameters_all osp
2516: , ozf_claims_all oc
2517: WHERE osp.org_id = oc.org_id
2518: AND oc.claim_id = p_id;
2519: l_post_to_gl VARCHAR2(1);
2520: l_claim_id NUMBER;
2873:
2874: CURSOR csr_claim_version(cv_claim_id IN NUMBER) IS
2875: SELECT object_version_number
2876: , org_id
2877: FROM ozf_claims_all
2878: WHERE claim_id = cv_claim_id;
2879:
2880: CURSOR csr_claim_settle(cv_claim_id IN NUMBER) IS
2881: SELECT claim_number
2891: , set_of_books_id
2892: , gl_date
2893: , claim_class
2894: , payment_reference_id
2895: FROM ozf_claims
2896: WHERE claim_id = cv_claim_id;
2897:
2898:
2899: l_claim_settle csr_claim_settle%ROWTYPE;