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_GL_INTERFACE_PVT dependencies on OZF_FUNDS_UTILIZED_ALL_B

Line 38: from ozf_funds_utilized_all_b

34: where claim_id = p_id;
35:
36: CURSOR util_org_id_csr (p_id in number) IS
37: select org_id
38: from ozf_funds_utilized_all_b
39: where utilization_id = p_id;
40:
41: BEGIN
42:

Line 43: IF p_source_table = 'OZF_FUNDS_UTILIZED_ALL_B' THEN

39: where utilization_id = p_id;
40:
41: BEGIN
42:
43: IF p_source_table = 'OZF_FUNDS_UTILIZED_ALL_B' THEN
44: OPEN util_org_id_csr (p_source_id);
45: FETCH util_org_id_csr INTO l_org_id;
46: CLOSE util_org_id_csr;
47: ELSIF p_source_table = 'OZF_CLAIMS_ALL' THEN

Line 193: from ozf_funds_utilized_all_b u

189: , u.object_id
190: , u.exchange_rate
191: , u.exchange_rate_type
192: , u.exchange_rate_date
193: from ozf_funds_utilized_all_b u
194: where u.utilization_id = p_id;
195:
196: -- get accrual details based on a claim
197: --(used when off-setting accruals paid through claims)

Line 216: , ozf_funds_utilized_all_b f

212: , f.cust_account_id
213: from ozf_claim_lines_util_all u
214: , ozf_claim_lines_all l
215: , ozf_claims_all c
216: , ozf_funds_utilized_all_b f
217: where u.claim_line_id = l.claim_line_id
218: and u.utilization_id = f.utilization_id
219: and l.claim_id = c.claim_id
220: and c.claim_id = p_id

Line 310: IF upper(p_source_table) = 'OZF_FUNDS_UTILIZED_ALL_B' THEN

306: END IF;
307:
308: END IF;
309:
310: IF upper(p_source_table) = 'OZF_FUNDS_UTILIZED_ALL_B' THEN
311:
312: IF p_account_type = 'ACCRUAL_LIABILITY' OR
313: p_account_type = 'EXPENSE ACCOUNT'
314: THEN

Line 546: , ozf_funds_utilized_all_b u

542: , f.ledger_id
543: , g.period_set_name
544: FROM ozf_funds_all_b f
545: , gl_sets_of_books g
546: , ozf_funds_utilized_all_b u
547: WHERE f.ledger_id = g.set_of_books_id
548: AND f.fund_id = u.fund_id
549: AND u.utilization_id = p_id;
550:

Line 561: IF upper(p_source_table) = 'OZF_FUNDS_UTILIZED_ALL_B' THEN

557: WHERE c.set_of_books_id = g.set_of_books_id
558: AND c.claim_id = p_id;
559:
560: BEGIN
561: IF upper(p_source_table) = 'OZF_FUNDS_UTILIZED_ALL_B' THEN
562: OPEN get_fund_type_csr(p_source_id);
563: FETCH get_fund_type_csr into l_type, x_sob_id, x_period_name;
564: CLOSE get_fund_type_csr;
565: IF l_type = 'FIXED' THEN

Line 822: from ozf_funds_utilized_all_b fu

818: l_sob number;
819:
820: CURSOR offer_code_csr(cv_utilization_id IN NUMBER) IS
821: select o.offer_code
822: from ozf_funds_utilized_all_b fu
823: , ozf_offers o
824: where fu.plan_type = 'OFFR'
825: and fu.plan_id = o.qp_list_header_id
826: and fu.utilization_id = cv_utilization_id;

Line 830: from ozf_funds_utilized_all_b fu

826: and fu.utilization_id = cv_utilization_id;
827:
828: CURSOR fund_number_csr(cv_utilization_id IN NUMBER) IS
829: select f.fund_number
830: from ozf_funds_utilized_all_b fu
831: , ozf_funds_all_b f
832: where fu.fund_id = f.fund_id
833: and fu.utilization_id = cv_utilization_id;
834:

Line 1004: IF (upper(p_gl_rec.source_table) = 'OZF_FUNDS_UTILIZED_ALL_B') THEN

1000: OZF_UTILITY_PVT.debug_message('l_cr_account_type_code:' || l_cr_account_type_code );
1001: OZF_UTILITY_PVT.debug_message('l_dr_account_type_code:' || l_dr_account_type_code);
1002: END IF;
1003:
1004: IF (upper(p_gl_rec.source_table) = 'OZF_FUNDS_UTILIZED_ALL_B') THEN
1005:
1006: IF OZF_DEBUG_HIGH_ON THEN
1007: OZF_UTILITY_PVT.debug_message('Getting GL Account for debiting');
1008: END IF;

Line 1145: IF upper(p_gl_rec.source_table) = 'OZF_FUNDS_UTILIZED_ALL_B' THEN

1141: END IF;
1142: END IF;
1143: OZF_UTILITY_PVT.debug_message('After Get_gl_account');
1144: -- for accruals and accrual adjustments
1145: IF upper(p_gl_rec.source_table) = 'OZF_FUNDS_UTILIZED_ALL_B' THEN
1146: IF p_gl_rec.event_type_code = 'ACCRUAL_CREATION' OR
1147: p_gl_rec.event_type_code = 'ACCRUAL_ADJUSTMENT' THEN
1148:
1149: IF OZF_DEBUG_LOW_ON THEN

Line 1292: from ozf_funds_utilized_all_b

1288: where claim_id = p_id;
1289:
1290: CURSOR util_gl_date_csr (p_id in number) IS
1291: select gl_date
1292: from ozf_funds_utilized_all_b
1293: where utilization_id = p_id;
1294:
1295: CURSOR csr_get_gl_date_type(p_id IN NUMBER) IS
1296: SELECT gl_date_type

Line 1302: IF p_source_table = 'OZF_FUNDS_UTILIZED_ALL_B' THEN

1298: WHERE org_id = NVL(p_id, -99);
1299:
1300: BEGIN
1301:
1302: IF p_source_table = 'OZF_FUNDS_UTILIZED_ALL_B' THEN
1303:
1304: OPEN util_gl_date_csr (p_source_id);
1305: FETCH util_gl_date_csr INTO l_gl_date;
1306: CLOSE util_gl_date_csr;

Line 1362: from ozf_funds_utilized_all_b

1358: where claim_id = p_id;
1359:
1360: CURSOR util_org_id_csr (p_id in number) IS
1361: select org_id
1362: from ozf_funds_utilized_all_b
1363: where utilization_id = p_id;
1364:
1365: BEGIN
1366:

Line 1367: IF p_source_table = 'OZF_FUNDS_UTILIZED_ALL_B' THEN

1363: where utilization_id = p_id;
1364:
1365: BEGIN
1366:
1367: IF p_source_table = 'OZF_FUNDS_UTILIZED_ALL_B' THEN
1368: OPEN util_org_id_csr (p_source_id);
1369: FETCH util_org_id_csr INTO l_org_id;
1370: CLOSE util_org_id_csr;
1371: ELSIF p_source_table = 'OZF_CLAIMS_ALL' THEN

Line 1976: FROM ozf_funds_utilized_all_b

1972:
1973: --ER 13069257
1974: CURSOR c_util_details IS
1975: SELECT org_id, gl_date,adjustment_type
1976: FROM ozf_funds_utilized_all_b
1977: WHERE utilization_id = p_utilization_id;
1978:
1979: CURSOR c_get_entity_type_code(cv_event_type_code IN VARCHAR2) IS
1980: SELECT entity_code

Line 2699: , ozf_funds_utilized_all_b ofa

2695: SELECT NVL(osp.post_to_gl, 'F')
2696: , NVL(osp.gl_acct_for_offinv_flag, 'F'),plan_curr_amount, --ninarasi fix for bug 13054588
2697: plan_curr_amount_remaining -- Fix for Bug 13596344
2698: FROM ozf_sys_parameters_all osp
2699: , ozf_funds_utilized_all_b ofa
2700: WHERE osp.org_id = ofa.org_id
2701: AND ofa.utilization_id = p_id;
2702:
2703: CURSOR claim_gl_posting_csr(p_id in number) IS

Line 2714: ozf_funds_utilized_all_b b

2710: --//Bug fix 10037158
2711: CURSOR offer_type_csr(p_id in number) IS
2712: SELECT offer_type FROM
2713: ozf_offers a,
2714: ozf_funds_utilized_all_b b
2715: WHERE a.qp_list_header_id = b.plan_id
2716: AND b.utilization_id = p_id;
2717:
2718: l_offer_type varchar2(30) ;

Line 2757: IF p_gl_rec.source_table = 'OZF_FUNDS_UTILIZED_ALL_B' THEN

2753: --//ER#9382547 ChRM-SLA Uptake
2754: /*
2755: -- [BEGIN OF BUG 4039894 FIXING]
2756: -- Avoid GL entry creation if posting was done before for utilization.
2757: IF p_gl_rec.source_table = 'OZF_FUNDS_UTILIZED_ALL_B' THEN
2758: OPEN chk_ae_exist(p_gl_rec.source_id, 'OZF_FUNDS_UTILIZED_ALL_B');
2759: FETCH chk_ae_exist INTO l_acc_event_id;
2760: CLOSE chk_ae_exist;
2761:

Line 2758: OPEN chk_ae_exist(p_gl_rec.source_id, 'OZF_FUNDS_UTILIZED_ALL_B');

2754: /*
2755: -- [BEGIN OF BUG 4039894 FIXING]
2756: -- Avoid GL entry creation if posting was done before for utilization.
2757: IF p_gl_rec.source_table = 'OZF_FUNDS_UTILIZED_ALL_B' THEN
2758: OPEN chk_ae_exist(p_gl_rec.source_id, 'OZF_FUNDS_UTILIZED_ALL_B');
2759: FETCH chk_ae_exist INTO l_acc_event_id;
2760: CLOSE chk_ae_exist;
2761:
2762: IF l_acc_event_id IS NOT NULL THEN

Line 2781: ELSIF upper(p_gl_rec.source_table) = 'OZF_FUNDS_UTILIZED_ALL_B' THEN

2777: IF upper(p_gl_rec.source_table) = 'OZF_CLAIMS_ALL' THEN
2778: OPEN claim_gl_posting_csr(p_gl_rec.source_id);
2779: FETCH claim_gl_posting_csr INTO l_post_to_gl;
2780: CLOSE claim_gl_posting_csr;
2781: ELSIF upper(p_gl_rec.source_table) = 'OZF_FUNDS_UTILIZED_ALL_B' THEN
2782: --Fix for Bug 13596344
2783: OPEN accrual_gl_posting_csr(p_gl_rec.source_id);
2784: FETCH accrual_gl_posting_csr INTO l_post_to_gl, l_off_inv_gl,
2785: l_utiz_amount,l_utiz_amt_rem; --ninarasi fix for bug 13054588

Line 2821: IF UPPER(p_gl_rec.source_table) = 'OZF_FUNDS_UTILIZED_ALL_B' AND l_offer_type = 'TERMS' THEN

2817: OZF_Utility_PVT.write_conc_log('GL posting for Off Invoice is not required when gl_acct_for_offinv_flag is not checked.');
2818: END IF;
2819:
2820: --//Bugfix 10037158
2821: IF UPPER(p_gl_rec.source_table) = 'OZF_FUNDS_UTILIZED_ALL_B' AND l_offer_type = 'TERMS' THEN
2822: l_post_to_gl := 'F';
2823: IF OZF_DEBUG_LOW_ON THEN
2824: OZF_Utility_PVT.debug_message('GL posting for Terms Upgrade Offer is not required.');
2825: END IF;

Line 2829: IF (p_gl_rec.event_type_code = 'PAID_ADJUSTMENT' AND upper(p_gl_rec.source_table) = 'OZF_FUNDS_UTILIZED_ALL_B')THEN

2825: END IF;
2826: END IF;
2827:
2828: -- Fix for Bug 13596344
2829: IF (p_gl_rec.event_type_code = 'PAID_ADJUSTMENT' AND upper(p_gl_rec.source_table) = 'OZF_FUNDS_UTILIZED_ALL_B')THEN
2830: l_utiz_amount := l_utiz_amt_rem;
2831: END IF;
2832:
2833: --ninarasi fix for bug 13054588

Line 2867: IF UPPER(p_gl_rec.source_table) = 'OZF_FUNDS_UTILIZED_ALL_B' THEN

2863: -- create the extract table for accrual and claim settlement
2864: OZF_Utility_PVT.debug_message('SYSPARAM: Post to GL is ' || l_post_to_gl);
2865: OZF_Utility_PVT.debug_message('Source Table : ' || p_gl_rec.source_table);
2866: IF l_post_to_gl = 'T' THEN
2867: IF UPPER(p_gl_rec.source_table) = 'OZF_FUNDS_UTILIZED_ALL_B' THEN
2868:
2869: OZF_Utility_PVT.write_conc_log('Before Calling Create_SLA_Accrual_Extract');
2870: Create_SLA_Accrual_Extract (
2871: p_api_version => 1.0

Line 3886: l_gl_rec.source_table := 'OZF_FUNDS_UTILIZED_ALL_B';

3882: -- construct gl interface record
3883: l_gl_rec.event_type_code := p_event_type_code;
3884: l_gl_rec.event_status_code := 'ACCOUNTED';
3885: l_gl_rec.source_id := p_utilization_id;
3886: l_gl_rec.source_table := 'OZF_FUNDS_UTILIZED_ALL_B';
3887: l_gl_rec.dr_code_combination_id := p_dr_code_combination_id;
3888: l_gl_rec.cr_code_combination_id := p_cr_code_combination_id;
3889: --ER 13069257
3890: l_gl_rec.SKIP_ACCOUNT_GEN_FLAG := l_skip_acct_gen_flag;