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 28: from ozf_funds_utilized_all_b

24: where claim_id = p_id;
25:
26: CURSOR util_org_id_csr (p_id in number) IS
27: select org_id
28: from ozf_funds_utilized_all_b
29: where utilization_id = p_id;
30:
31: BEGIN
32:

Line 33: IF p_source_table = 'OZF_FUNDS_UTILIZED_ALL_B' THEN

29: where utilization_id = p_id;
30:
31: BEGIN
32:
33: IF p_source_table = 'OZF_FUNDS_UTILIZED_ALL_B' THEN
34: OPEN util_org_id_csr (p_source_id);
35: FETCH util_org_id_csr INTO l_org_id;
36: CLOSE util_org_id_csr;
37: ELSIF p_source_table = 'OZF_CLAIMS_ALL' THEN

Line 81: l_source_table varchar2(30) := 'OZF_FUNDS_UTILIZED_ALL_B';

77: l_line_id number;
78: l_item_id number;
79: l_price_adj_id number;
80: l_source_id number;
81: l_source_table varchar2(30) := 'OZF_FUNDS_UTILIZED_ALL_B';
82:
83: -- accounts
84: l_expense_account number;
85: l_accrual_liability number;

Line 142: from ozf_funds_utilized_all_b u

138: , u.product_level_type
139: , u.product_id
140: , u.price_adjustment_id
141: , u.cust_account_id
142: from ozf_funds_utilized_all_b u
143: where u.utilization_id = p_id;
144:
145: -- get accrual details based on a claim
146: --(used when off-setting accruals paid through claims)

Line 165: , ozf_funds_utilized_all_b f

161: , f.cust_account_id
162: from ozf_claim_lines_util_all u
163: , ozf_claim_lines_all l
164: , ozf_claims_all c
165: , ozf_funds_utilized_all_b f
166: where u.claim_line_id = l.claim_line_id
167: and u.utilization_id = f.utilization_id
168: and l.claim_id = c.claim_id
169: and c.claim_id = p_id;

Line 210: , ozf_funds_utilized_all_b f

206: , c.claim_id
207: from ozf_claim_lines_util_all u
208: , ozf_claim_lines_all l
209: , ozf_claims_all c
210: , ozf_funds_utilized_all_b f
211: where u.claim_line_id = l.claim_line_id
212: and u.utilization_id = f.utilization_id
213: and c.claim_id = l.claim_id
214: and l.claim_line_id = p_id;

Line 249: , ozf_funds_utilized_all_b f

245: , c.claim_id
246: from ozf_claim_lines_util_all u
247: , ozf_claim_lines_all l
248: , ozf_claims_all c
249: , ozf_funds_utilized_all_b f
250: where u.claim_line_id = l.claim_line_id
251: and u.utilization_id = f.utilization_id
252: and c.claim_id = l.claim_id
253: and u.claim_line_util_id = p_id;

Line 262: , ozf_funds_utilized_all_b ofa

258: , osp.gl_id_accr_promo_liab -- accrual liability account
259: , osp.gl_id_ded_clearing -- vendor clearing account
260: , osp.gl_rec_clearing_account -- receivables clearing account
261: FROM ozf_sys_parameters_all osp
262: , ozf_funds_utilized_all_b ofa
263: WHERE osp.org_id = NVL(ofa.org_id, -99)
264: AND ofa.utilization_id = p_id;
265:
266: CURSOR claim_get_sys_param_csr(p_id in number) IS

Line 307: from ozf_funds_utilized_all_b fu

303: --(used when posting off-invoice discounts)
304: --(and when profile 'OM: Show Discount Details on Invoice' is set to 'No')
305: CURSOR get_revenue_acct_csr1(p_utiz_id in number) IS
306: select cgl.code_combination_id
307: from ozf_funds_utilized_all_b fu
308: , oe_price_adjustments pa
309: , oe_order_lines_all ol
310: , oe_order_headers_all oh
311: , ra_customer_trx_lines_all ctl

Line 328: from ozf_funds_utilized_all_b fu

324: --(used when posting off-invoice discounts)
325: --(and when profile 'OM: Show Discount Details on Invoice' is set to 'Yes')
326: CURSOR get_revenue_acct_csr2(p_utiz_id in number) IS
327: select cgl.code_combination_id
328: from ozf_funds_utilized_all_b fu
329: , oe_price_adjustments pa
330: , oe_order_lines_all ol
331: , oe_order_headers_all oh
332: , ra_customer_trx_lines_all ctl

Line 350: from ozf_funds_utilized_all_b fu

346: -- get order number and order line number for a utilization
347: CURSOR get_order_line_csr(p_utiz_id in number) IS
348: select oh.order_number
349: , ol.line_number
350: from ozf_funds_utilized_all_b fu
351: , oe_price_adjustments pa
352: , oe_order_lines_all ol
353: , oe_order_headers_all oh
354: where fu.price_adjustment_id = pa.price_adjustment_id

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

402: OZF_Utility_PVT.debug_message('p_account_type : '||p_account_type);
403: END IF;
404:
405: l_acct_gen_tbl := acct_gen_tbl();
406: IF upper(p_source_table) = 'OZF_FUNDS_UTILIZED_ALL_B' THEN
407:
408: -- get default accounts from system parameters
409: OPEN accrual_get_sys_param_csr(p_source_id);
410: FETCH accrual_get_sys_param_csr INTO l_expense_account,

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

699: -- get the profile value for GL Accounting mode
700: l_bg_process_mode := nvl(fnd_profile.value('OZF_CLAIM_SETL_ACCT_BG'),'Y');
701:
702: IF l_bg_process_mode = 'N' THEN
703: IF upper(p_source_table) = 'OZF_FUNDS_UTILIZED_ALL_B' THEN
704: l_bg_process_mode := 'Y';
705: END IF;
706: END IF;
707:

Line 865: , ozf_funds_utilized_all_b u

861: , f.ledger_id
862: , g.period_set_name
863: FROM ozf_funds_all_b f
864: , gl_sets_of_books g
865: , ozf_funds_utilized_all_b u
866: WHERE f.ledger_id = g.set_of_books_id
867: AND f.fund_id = u.fund_id
868: AND u.utilization_id = p_id;
869:

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

876: WHERE c.set_of_books_id = g.set_of_books_id
877: AND c.claim_id = p_id;
878:
879: BEGIN
880: IF upper(p_source_table) = 'OZF_FUNDS_UTILIZED_ALL_B' THEN
881: OPEN get_fund_type_csr(p_source_id);
882: FETCH get_fund_type_csr into l_type, x_sob_id, x_period_name;
883: CLOSE get_fund_type_csr;
884: IF l_type = 'FIXED' THEN

Line 1173: from ozf_funds_utilized_all_b fu

1169: l_sob number;
1170:
1171: CURSOR offer_code_csr(cv_utilization_id IN NUMBER) IS
1172: select o.offer_code
1173: from ozf_funds_utilized_all_b fu
1174: , ozf_offers o
1175: where fu.plan_type = 'OFFR'
1176: and fu.plan_id = o.qp_list_header_id
1177: and fu.utilization_id = cv_utilization_id;

Line 1181: from ozf_funds_utilized_all_b fu

1177: and fu.utilization_id = cv_utilization_id;
1178:
1179: CURSOR fund_number_csr(cv_utilization_id IN NUMBER) IS
1180: select f.fund_number
1181: from ozf_funds_utilized_all_b fu
1182: , ozf_funds_all_b f
1183: where fu.fund_id = f.fund_id
1184: and fu.utilization_id = cv_utilization_id;
1185:

Line 1305: , ozf_funds_utilized_all_b fu

1301: CURSOR get_product_line_csr(p_claim_id in number) IS
1302: select lu.claim_line_util_id
1303: from ozf_claim_lines_all ln
1304: , ozf_claim_lines_util_all lu
1305: , ozf_funds_utilized_all_b fu
1306: , ozf_offers o
1307: , ams_custom_setup_attr c
1308: where ln.claim_line_id = lu.claim_line_id
1309: and fu.utilization_id = lu.utilization_id

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

1524: END IF;
1525:
1526: x_amount_tbl := amount_tbl_type();
1527: -- for accruals and accrual adjustments
1528: IF upper(p_gl_rec.source_table) = 'OZF_FUNDS_UTILIZED_ALL_B' THEN
1529: IF p_gl_rec.event_type_code = 'ACCRUAL' OR
1530: p_gl_rec.event_type_code = 'ACCRUAL_ADJUSTMENT' OR
1531: p_gl_rec.event_type_code = 'OFF_INVOICE' THEN
1532: IF p_gl_rec.adjustment_type = 'P' THEN

Line 1840: from ozf_funds_utilized_all_b

1836: where claim_id = p_id;
1837:
1838: CURSOR util_gl_date_csr (p_id in number) IS
1839: select gl_date
1840: from ozf_funds_utilized_all_b
1841: where utilization_id = p_id;
1842:
1843: CURSOR csr_get_gl_date_type(p_id IN NUMBER) IS
1844: SELECT gl_date_type

Line 1850: IF p_source_table = 'OZF_FUNDS_UTILIZED_ALL_B' THEN

1846: WHERE org_id = NVL(p_id, -99);
1847:
1848: BEGIN
1849:
1850: IF p_source_table = 'OZF_FUNDS_UTILIZED_ALL_B' THEN
1851:
1852: OPEN util_gl_date_csr (p_source_id);
1853: FETCH util_gl_date_csr INTO l_gl_date;
1854: CLOSE util_gl_date_csr;

Line 1909: from ozf_funds_utilized_all_b

1905: where claim_id = p_id;
1906:
1907: CURSOR util_org_id_csr (p_id in number) IS
1908: select org_id
1909: from ozf_funds_utilized_all_b
1910: where utilization_id = p_id;
1911:
1912: BEGIN
1913:

Line 1914: IF p_source_table = 'OZF_FUNDS_UTILIZED_ALL_B' THEN

1910: where utilization_id = p_id;
1911:
1912: BEGIN
1913:
1914: IF p_source_table = 'OZF_FUNDS_UTILIZED_ALL_B' THEN
1915: OPEN util_org_id_csr (p_source_id);
1916: FETCH util_org_id_csr INTO l_org_id;
1917: CLOSE util_org_id_csr;
1918: ELSIF p_source_table = 'OZF_CLAIMS_ALL' THEN

Line 2484: , ozf_funds_utilized_all_b ofa

2480: SELECT osp.post_to_gl
2481: , osp.transfer_to_gl_in
2482: , osp.gl_acct_for_offinv_flag
2483: FROM ozf_sys_parameters_all osp
2484: , ozf_funds_utilized_all_b ofa
2485: WHERE osp.org_id = NVL(ofa.org_id, -99)
2486: AND ofa.utilization_id = p_id;
2487:
2488: CURSOR claim_gl_posting_csr(p_id in number) IS

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

2555: END IF;
2556:
2557: -- [BEGIN OF BUG 4039894 FIXING]
2558: -- Avoid GL entry creation if posting was done before for utilization.
2559: IF p_gl_rec.source_table = 'OZF_FUNDS_UTILIZED_ALL_B' THEN
2560: OPEN chk_ae_exist(p_gl_rec.source_id, 'OZF_FUNDS_UTILIZED_ALL_B');
2561: FETCH chk_ae_exist INTO l_acc_event_id;
2562: CLOSE chk_ae_exist;
2563:

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

2556:
2557: -- [BEGIN OF BUG 4039894 FIXING]
2558: -- Avoid GL entry creation if posting was done before for utilization.
2559: IF p_gl_rec.source_table = 'OZF_FUNDS_UTILIZED_ALL_B' THEN
2560: OPEN chk_ae_exist(p_gl_rec.source_id, 'OZF_FUNDS_UTILIZED_ALL_B');
2561: FETCH chk_ae_exist INTO l_acc_event_id;
2562: CLOSE chk_ae_exist;
2563:
2564: IF l_acc_event_id IS NOT NULL THEN

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

2578: -- check if post to gl flag in system parameter is set to T
2579: OPEN claim_gl_posting_csr(p_gl_rec.source_id);
2580: FETCH claim_gl_posting_csr INTO l_post_to_gl, l_transfer_to_gl_in;
2581: CLOSE claim_gl_posting_csr;
2582: ELSIF upper(p_gl_rec.source_table) = 'OZF_FUNDS_UTILIZED_ALL_B' THEN
2583: -- check if post to gl flag in system parameter is set to T
2584: OPEN accrual_gl_posting_csr(p_gl_rec.source_id);
2585: FETCH accrual_gl_posting_csr INTO l_post_to_gl, l_transfer_to_gl_in, l_off_inv_gl;
2586: CLOSE accrual_gl_posting_csr;

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

3563: -- construct gl interface record
3564: l_gl_rec.event_type_code := p_utilization_type;
3565: l_gl_rec.event_status_code := 'ACCOUNTED';
3566: l_gl_rec.source_id := p_utilization_id;
3567: l_gl_rec.source_table := 'OZF_FUNDS_UTILIZED_ALL_B';
3568: l_gl_rec.adjustment_type := p_adjustment_type;
3569: l_gl_rec.dr_code_combination_id := p_dr_code_combination_id;
3570: l_gl_rec.cr_code_combination_id := p_cr_code_combination_id;
3571: l_gl_rec.skip_account_gen_flag := p_skip_acct_gen_flag;