eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_MASS_SETTLEMENT_PVT dependencies on OZF_CLAIMS

Line 33: UPDATE ozf_claims_all

29: BEGIN
30: x_return_status := FND_API.g_ret_sts_success;
31:
32:
33: UPDATE ozf_claims_all
34: SET payment_status = 'PAID'
35: , status_code = 'CLOSED'
36: , user_status_id = OZF_UTILITY_PVT.get_default_user_status(
37: 'OZF_CLAIM_STATUS'

Line 1390: UPDATE ozf_claims_all

1386: RAISE FND_API.g_exc_unexpected_error;
1387: END IF;
1388:
1389: BEGIN
1390: UPDATE ozf_claims_all
1391: SET payment_status = 'PENDING'
1392: , status_code = 'PENDING_CLOSE'
1393: , user_status_id = OZF_UTILITY_PVT.get_default_user_status(
1394: 'OZF_CLAIM_STATUS'

Line 1670: FROM ozf_claims_all

1666: , receipt_number
1667: , source_object_id
1668: , source_object_number
1669: , amount_remaining
1670: FROM ozf_claims_all
1671: WHERE group_claim_id = cv_group_claim_id
1672: AND claim_class = cv_claim_class
1673: ORDER BY claim_date, group_claim_id;
1674:

Line 1691: FROM ozf_claims

1687: -- add addtional order by clause for mass settlement ordering rule criteria
1688:
1689: CURSOR csr_get_source_object_id(cv_claim_id IN NUMBER) IS
1690: SELECT source_object_id
1691: FROM ozf_claims
1692: WHERE claim_id = cv_claim_id;
1693:
1694: TYPE l_csr_claim_tbl IS TABLE OF csr_claims%ROWTYPE
1695: INDEX BY BINARY_INTEGER;

Line 2209: FROM ozf_claims_all

2205: CURSOR csr_claims_group( cv_group_claim_id IN NUMBER) IS
2206: SELECT claim_id
2207: , claim_number
2208: , object_version_number
2209: FROM ozf_claims_all
2210: WHERE group_claim_id = cv_group_claim_id;
2211:
2212: -- Fix for 5376466
2213: CURSOR csr_sysparam_defaults IS

Line 2369: FROM ozf_claims_all

2365: l_appr_req VARCHAR2(1);
2366:
2367: CURSOR csr_claim_obj_ver(cv_claim_id IN NUMBER) IS
2368: SELECT object_version_number
2369: FROM ozf_claims_all
2370: WHERE claim_id = cv_claim_id;
2371:
2372: CURSOR csr_mass_setl_appr_req IS
2373: SELECT NVL(attr_available_flag, 'N')

Line 2461: UPDATE ozf_claims_all

2457:
2458: l_owner_id := OZF_Utility_PVT.get_resource_id(FND_GLOBAL.user_id);
2459:
2460: --//Added by BKUNJAN Bug#5686706
2461: UPDATE ozf_claims_all
2462: SET payment_status = 'PENDING'
2463: , status_code = 'PENDING_APPROVAL'
2464: , user_status_id = OZF_UTILITY_PVT.get_default_user_status(
2465: 'OZF_CLAIM_STATUS'

Line 2492: UPDATE ozf_claims_all

2488: END IF;
2489:
2490: --//Commented by BKUNJAN Bug#5686706
2491: /*
2492: UPDATE ozf_claims_all
2493: SET payment_status = 'PENDING'
2494: , status_code = 'PENDING_APPROVAL'
2495: , user_status_id = OZF_UTILITY_PVT.get_default_user_status(
2496: 'OZF_CLAIM_STATUS'

Line 2589: UPDATE ozf_claims_all

2585:
2586: BEGIN
2587: SAVEPOINT Reject_Mass_Payment;
2588:
2589: UPDATE ozf_claims_all
2590: SET status_code = 'REJECTED'
2591: , user_status_id = l_rejected_user_status_id
2592: WHERE claim_id = p_group_claim_id;
2593:

Line 2595: UPDATE ozf_claims_all

2591: , user_status_id = l_rejected_user_status_id
2592: WHERE claim_id = p_group_claim_id;
2593:
2594: --bug5460095
2595: UPDATE ozf_claims_all
2596: SET status_code = 'OPEN'
2597: , user_status_id = l_open_user_status_id
2598: , amount_remaining = amount - NVL(amount_adjusted,0)
2599: , acctd_amount_remaining = acctd_amount - NVL(acctd_amount_adjusted,0)

Line 2970: UPDATE ozf_claims_all

2966: FETCH csr_user_status_id INTO l_close_user_status_id;
2967: CLOSE csr_user_status_id;
2968:
2969: BEGIN
2970: UPDATE ozf_claims_all
2971: SET payment_status = 'PAID'
2972: , status_code = 'CLOSED'
2973: , user_status_id = l_close_user_status_id
2974: WHERE claim_id = p_group_claim_id;

Line 3066: FROM ozf_claims_all

3062:
3063: CURSOR csr_claim_amount_rem(cv_claim_id IN NUMBER) IS
3064: SELECT amount_remaining
3065: , object_version_number
3066: FROM ozf_claims_all
3067: WHERE claim_id = cv_claim_id;
3068:
3069: CURSOR csr_get_set_of_books IS
3070: SELECT set_of_books_id

Line 3093: FROM ozf_claims_all

3089: --//Bugfix : 7439145
3090: CURSOR p_acctd_claim_amts(p_claim_id IN NUMBER) IS
3091: SELECT acctd_amount,
3092: acctd_amount_adjusted
3093: FROM ozf_claims_all
3094: WHERE claim_id =p_claim_id;
3095:
3096: l_ded_claim_tbl OZF_Claim_PVT.claim_tbl_type;
3097: l_opm_claim_tbl OZF_Claim_PVT.claim_tbl_type;

Line 3425: UPDATE ozf_claims_all

3421: OZF_Utility_PVT.debug_message('Update Claim Id:'||l_open_claim_tbl(i).claim_id);
3422: END IF;
3423:
3424: BEGIN
3425: UPDATE ozf_claims_all
3426: SET group_claim_id = l_group_claim_id
3427: --, gl_date = l_gl_date
3428: --, wo_rec_trx_id = l_wo_rec_trx_id
3429: WHERE claim_id = l_open_claim_tbl(i).claim_id;

Line 3654: UPDATE ozf_claims_all

3650: RAISE FND_API.g_exc_unexpected_error;
3651: END IF;
3652:
3653: BEGIN
3654: UPDATE ozf_claims_all
3655: SET amount = l_group_claim_amt
3656: , amount_remaining = l_group_trx_amt
3657: , amount_settled = l_group_settle_amt
3658: , amount_adjusted = l_group_rem_amt

Line 3672: UPDATE ozf_claims_all

3668: CLOSE p_acctd_claim_amts;
3669:
3670: l_act_amt_settled := l_act_amt - l_act_amt_adjusted;
3671:
3672: UPDATE ozf_claims_all
3673: SET amount_settled = p_open_claim_tbl(i).amount_settled,
3674: amount_remaining = amount -(amount_adjusted + p_open_claim_tbl(i).amount_settled),
3675: acctd_amount_settled = l_act_amt_settled,
3676: acctd_amount_remaining = l_act_amt - (l_act_amt_adjusted + l_act_amt_settled)