14: l_org_id number;
15:
16: cursor get_claim_org_csr(p_id in number) is
17: select org_id
18: from ozf_claims_all
19: where claim_id = p_id;
20:
21: begin
22:
350: , rlk_cm.meaning
351: , rlk_adj.meaning
352: , lk_pm.meaning
353: , 'resource_name'
354: FROM ozf_claims_all c
355: , hz_cust_accounts a
356: , hz_parties hp
357: , ozf_claim_types_all_vl ct
358: , hz_cust_site_uses_all hc
617: , rlk_cm.meaning
618: , rlk_adj.meaning
619: , lk_pm.meaning
620: , 'resource_name'
621: FROM ozf_claims_all c
622: , hz_cust_accounts a
623: , hz_parties hp
624: , ozf_claim_types_all_vl ct
625: , hz_cust_site_uses_all hc
920: , rlk_cm.meaning
921: , rlk_adj.meaning
922: , lk_pm.meaning
923: , 'resource_name'
924: FROM ozf_claims_all c
925: , hz_cust_accounts a
926: , hz_parties hp
927: , ozf_claim_types_all_vl ct
928: , hz_cust_site_uses_all hc
1173: , rlk_cm.meaning
1174: , rlk_adj.meaning
1175: , lk_pm.meaning
1176: , 'resource_name'
1177: FROM ozf_claims_all c
1178: , hz_cust_accounts a
1179: , hz_parties hp
1180: , ozf_claim_types_all_vl ct
1181: , hz_cust_site_uses_all hc
1428: , rlk_cm.meaning
1429: , rlk_adj.meaning
1430: , lk_pm.meaning
1431: , 'resource_name'
1432: FROM ozf_claims_all c
1433: , hz_cust_accounts a
1434: , hz_parties hp
1435: , ozf_claim_types_all_vl ct
1436: , hz_cust_site_uses_all hc
1689: , claim_date
1690: , due_date
1691: , owner_id
1692: , currency_code
1693: FROM ozf_claims_all
1694: WHERE claim_id = p_act_id;
1695:
1696: CURSOR c_claim_rec(p_claim_id IN NUMBER) IS
1697: SELECT c.claim_number
1707: , rlk_adj.meaning
1708: , lk_pm.meaning
1709: , 'resource_name'
1710: , c.comments
1711: FROM ozf_claims_all c
1712: , hz_cust_accounts a
1713: , hz_parties hp
1714: , ozf_claim_types_all_vl ct
1715: , hz_cust_site_uses_all hc
1773: CLOSE c_claim_obj;
1774:
1775: IF (funcmode = 'RUN') THEN
1776: BEGIN
1777: UPDATE ozf_claims_all
1778: SET appr_wf_item_key = itemkey
1779: WHERE claim_id = l_activity_id;
1780:
1781: IF ( l_approval_type = 'CLAIM' ) THEN
2101: SELECT object_version_number
2102: --, user_status_id
2103: , owner_id
2104: , comments
2105: FROM ozf_claims_all --//Bugfix : 8442938 - Changed table name from ozf_claims to ozf_claims_all
2106: WHERE claim_id = l_claim_id;
2107:
2108: BEGIN
2109: x_return_status := FND_API.g_ret_sts_success;
2117:
2118: l_object_version_number := l_object_version_number + 1;
2119:
2120: BEGIN
2121: UPDATE ozf_claims_all
2122: SET OBJECT_VERSION_NUMBER = l_object_version_number
2123: WHERE claim_id = p_claim_id;
2124: EXCEPTION
2125: WHEN OTHERS THEN
2231: l_claim_id1 NUMBER :=0;
2232:
2233: CURSOR csr_claim_obj_ver(cv_claim_id IN NUMBER) IS
2234: SELECT object_version_number
2235: FROM ozf_claims_all
2236: WHERE claim_id = cv_claim_id;
2237:
2238: CURSOR csr_get_claim_amount (cv_claim_id IN NUMBER) IS
2239: SELECT amount_settled
2237:
2238: CURSOR csr_get_claim_amount (cv_claim_id IN NUMBER) IS
2239: SELECT amount_settled
2240: , payment_method
2241: FROM ozf_claims_all
2242: WHERE claim_id = cv_claim_id;
2243:
2244: -- Added for Bug 14106958
2245: CURSOR p_acctd_claim_amts(p_claim_id IN NUMBER) IS
2246: SELECT claim_id,acctd_amount,
2247: acctd_amount_adjusted,
2248: amount,
2249: amount_adjusted
2250: FROM ozf_claims_all
2251: WHERE group_claim_id =p_claim_id;
2252:
2253:
2254: BEGIN
2586: FETCH p_acctd_claim_amts
2587: INTO l_claim_id1,l_act_amt,l_act_amt_adjusted,l_amt,l_amt_adjusted;
2588: l_amt_settled := l_amt - l_amt_adjusted;
2589: l_act_amt_settled := l_act_amt - l_act_amt_adjusted;
2590: UPDATE ozf_claims_all
2591: SET amount_settled = l_amt_settled,
2592: amount_remaining = l_amt -(l_amt_adjusted + l_amt_settled),
2593: acctd_amount_settled = l_act_amt_settled,
2594: acctd_amount_remaining = l_act_amt - (l_act_amt_adjusted + l_act_amt_settled),