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.

[Home] [Help]

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 1394: UPDATE ozf_claims_all

1390: RAISE FND_API.g_exc_unexpected_error;
1391: END IF;
1392:
1393: BEGIN
1394: UPDATE ozf_claims_all
1395: SET payment_status = 'PENDING'
1396: , status_code = 'PENDING_CLOSE'
1397: , user_status_id = OZF_UTILITY_PVT.get_default_user_status(
1398: 'OZF_CLAIM_STATUS'

Line 1676: FROM ozf_claims_all

1672: , receipt_number
1673: , source_object_id
1674: , source_object_number
1675: , amount_remaining
1676: FROM ozf_claims_all
1677: WHERE group_claim_id = cv_group_claim_id
1678: AND claim_class = cv_claim_class
1679: ORDER BY claim_date, group_claim_id;
1680:

Line 1697: FROM ozf_claims

1693: -- add addtional order by clause for mass settlement ordering rule criteria
1694:
1695: CURSOR csr_get_source_object_id(cv_claim_id IN NUMBER) IS
1696: SELECT source_object_id
1697: FROM ozf_claims
1698: WHERE claim_id = cv_claim_id;
1699:
1700: TYPE l_csr_claim_tbl IS TABLE OF csr_claims%ROWTYPE
1701: INDEX BY BINARY_INTEGER;

Line 2215: FROM ozf_claims_all

2211: CURSOR csr_claims_group( cv_group_claim_id IN NUMBER) IS
2212: SELECT claim_id
2213: , claim_number
2214: , object_version_number
2215: FROM ozf_claims_all
2216: WHERE group_claim_id = cv_group_claim_id;
2217:
2218: -- Fix for 5376466
2219: CURSOR csr_sysparam_defaults IS

Line 2375: FROM ozf_claims_all

2371: l_appr_req VARCHAR2(1);
2372:
2373: CURSOR csr_claim_obj_ver(cv_claim_id IN NUMBER) IS
2374: SELECT object_version_number
2375: FROM ozf_claims_all
2376: WHERE claim_id = cv_claim_id;
2377: /*
2378: CURSOR csr_mass_setl_appr_req IS
2379: SELECT NVL(attr_available_flag, 'N')

Line 2482: UPDATE ozf_claims_all

2478:
2479: l_owner_id := OZF_Utility_PVT.get_resource_id(FND_GLOBAL.user_id);
2480:
2481: --//Added by BKUNJAN Bug#5686706
2482: UPDATE ozf_claims_all
2483: SET payment_status = 'PENDING'
2484: , status_code = 'PENDING_APPROVAL'
2485: , user_status_id = OZF_UTILITY_PVT.get_default_user_status(
2486: 'OZF_CLAIM_STATUS'

Line 2513: UPDATE ozf_claims_all

2509: END IF;
2510:
2511: --//Commented by BKUNJAN Bug#5686706
2512: /*
2513: UPDATE ozf_claims_all
2514: SET payment_status = 'PENDING'
2515: , status_code = 'PENDING_APPROVAL'
2516: , user_status_id = OZF_UTILITY_PVT.get_default_user_status(
2517: 'OZF_CLAIM_STATUS'

Line 2610: UPDATE ozf_claims_all

2606:
2607: BEGIN
2608: SAVEPOINT Reject_Mass_Payment;
2609:
2610: UPDATE ozf_claims_all
2611: SET status_code = 'REJECTED'
2612: , user_status_id = l_rejected_user_status_id
2613: WHERE claim_id = p_group_claim_id;
2614:

Line 2616: UPDATE ozf_claims_all

2612: , user_status_id = l_rejected_user_status_id
2613: WHERE claim_id = p_group_claim_id;
2614:
2615: --bug5460095
2616: UPDATE ozf_claims_all
2617: SET status_code = 'OPEN'
2618: , user_status_id = l_open_user_status_id
2619: , amount_remaining = amount - NVL(amount_adjusted,0)
2620: , acctd_amount_remaining = acctd_amount - NVL(acctd_amount_adjusted,0)

Line 2756: FROM ozf_claims_all

2752:
2753: CURSOR cur_current_status (p_claim_id IN NUMBER)IS
2754: SELECT status_code,
2755: user_status_id
2756: FROM ozf_claims_all
2757: WHERE claim_id =p_claim_id;
2758:
2759: BEGIN
2760: -------------------- initialize -----------------------

Line 2815: OZF_claims_history_PVT.Check_Create_History(

2811: IF l_status_code ='CLOSED' THEN
2812: l_claim_rec.status_code :=l_status_code;
2813: l_claim_rec.user_status_id :=l_user_status_id;
2814:
2815: OZF_claims_history_PVT.Check_Create_History(
2816: p_claim => l_claim_rec,
2817: p_event => 'UPDATE',
2818: x_history_event => l_history_event,
2819: x_history_event_description => l_history_event_description,

Line 2832: OZF_claims_history_PVT.Create_History(

2828: END IF;
2829:
2830: IF (l_needed_to_create = 'Y') THEN
2831: -- CREATE history
2832: OZF_claims_history_PVT.Create_History(
2833: p_claim_id => l_claim_id_tbl(i),
2834: p_history_event => l_history_event,
2835: p_history_event_description => l_history_event_description,
2836: x_claim_history_id => l_claim_history_id,

Line 3041: OZF_claims_history_PVT.Check_Create_History(

3037: l_claim_rec_hist.claim_id :=l_settlement_doc_tbl(j).payment_reference_id;
3038: l_claim_rec_hist.status_code :='CLOSED';
3039: l_claim_rec_hist.user_status_id :=OZF_UTILITY_PVT.get_default_user_status('OZF_CLAIM_STATUS','CLOSED');
3040:
3041: OZF_claims_history_PVT.Check_Create_History(
3042: p_claim => l_claim_rec_hist,
3043: p_event => 'UPDATE',
3044: x_history_event => l_history_event,
3045: x_history_event_description => l_history_event_description,

Line 3058: OZF_claims_history_PVT.Create_History(

3054: END IF;
3055:
3056: IF (l_needed_to_create = 'Y') THEN
3057: -- CREATE history
3058: OZF_claims_history_PVT.Create_History(
3059: p_claim_id => l_settlement_doc_tbl(j).payment_reference_id,
3060: p_history_event => l_history_event,
3061: p_history_event_description => l_history_event_description,
3062: x_claim_history_id => l_claim_history_id,

Line 3093: UPDATE ozf_claims_all

3089: FETCH csr_user_status_id INTO l_close_user_status_id;
3090: CLOSE csr_user_status_id;
3091:
3092: BEGIN
3093: UPDATE ozf_claims_all
3094: SET payment_status = 'PAID'
3095: , status_code = 'CLOSED'
3096: , user_status_id = l_close_user_status_id
3097: WHERE claim_id = p_group_claim_id;

Line 3189: FROM ozf_claims_all

3185:
3186: CURSOR csr_claim_amount_rem(cv_claim_id IN NUMBER) IS
3187: SELECT amount_remaining
3188: , object_version_number
3189: FROM ozf_claims_all
3190: WHERE claim_id = cv_claim_id;
3191:
3192: CURSOR csr_get_set_of_books IS
3193: SELECT set_of_books_id

Line 3233: FROM ozf_claims_all

3229: SELECT acctd_amount,
3230: acctd_amount_adjusted,
3231: amount,
3232: amount_adjusted
3233: FROM ozf_claims_all
3234: WHERE claim_id =p_claim_id;
3235:
3236: l_ded_claim_tbl OZF_Claim_PVT.claim_tbl_type;
3237: l_opm_claim_tbl OZF_Claim_PVT.claim_tbl_type;

Line 3580: UPDATE ozf_claims_all

3576: OZF_Utility_PVT.debug_message('Update Claim Id:'||l_open_claim_tbl(i).claim_id);
3577: END IF;
3578:
3579: BEGIN
3580: UPDATE ozf_claims_all
3581: SET group_claim_id = l_group_claim_id
3582: , comments = l_comments
3583: --, gl_date = l_gl_date
3584: --, wo_rec_trx_id = l_wo_rec_trx_id

Line 3810: UPDATE ozf_claims_all

3806: RAISE FND_API.g_exc_unexpected_error;
3807: END IF;
3808:
3809: BEGIN
3810: UPDATE ozf_claims_all
3811: SET amount = l_group_claim_amt
3812: , amount_remaining = l_group_trx_amt
3813: , amount_settled = l_group_settle_amt
3814: , amount_adjusted = l_group_rem_amt

Line 3832: UPDATE ozf_claims_all

3828:
3829: l_amt_settled := l_act_amt - l_act_amt_adjusted;
3830: l_act_amt_settled := l_act_amt - l_act_amt_adjusted;
3831:
3832: UPDATE ozf_claims_all
3833: SET amount_settled = l_amt_settled,
3834: amount_remaining = l_amt -(l_amt_adjusted + l_amt_settled),
3835: acctd_amount_settled = l_act_amt_settled,
3836: acctd_amount_remaining = l_act_amt - (l_act_amt_adjusted + l_act_amt_settled),