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_CLAIMS_ALL

Line 33: from ozf_claims_all

29: l_org_id number;
30:
31: CURSOR claim_org_id_csr (p_id in number) IS
32: select org_id
33: from ozf_claims_all
34: where claim_id = p_id;
35:
36: CURSOR util_org_id_csr (p_id in number) IS
37: select org_id

Line 47: ELSIF p_source_table = 'OZF_CLAIMS_ALL' THEN

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
48: OPEN claim_org_id_csr (p_source_id);
49: FETCH claim_org_id_csr INTO l_org_id;
50: CLOSE claim_org_id_csr;
51: END IF;

Line 142: , ozf_claims_all c

138: CURSOR get_claim_type_acc_csr(cv_claim_id in number) IS
139: select ct.gl_id_ded_clearing -- vendor clearing account
140: , ct.gl_id_ded_adj_clearing -- receivables clearing account
141: from ozf_claim_types_all_b ct
142: , ozf_claims_all c
143: where ct.claim_type_id = c.claim_type_id
144: and c.claim_id = cv_claim_id;
145:
146: -- default accounts from System Parameter

Line 153: , ozf_claims_all oc

149: , osp.gl_id_accr_promo_liab -- accrual liability account
150: , osp.gl_id_ded_clearing -- vendor clearing account
151: , osp.gl_rec_clearing_account -- receivables clearing account
152: FROM ozf_sys_parameters_all osp
153: , ozf_claims_all oc
154: WHERE osp.org_id = NVL(oc.org_id, -99)
155: AND oc.claim_id = p_id;
156:
157: -- get accrual totals based on a claim and accrual currency

Line 165: , ozf_claims_all c

161: , l.acctd_amount
162: , c.currency_code
163: , c.claim_id
164: FROM ozf_claim_lines_all l
165: , ozf_claims_all c
166: WHERE l.claim_id = c.claim_id
167: --AND l.earnings_associated_flag = 'T'
168: AND l.claim_line_id = p_id;
169:

Line 215: , ozf_claims_all c

211: , f.price_adjustment_id
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

Line 343: ELSIF upper(p_source_table) = 'OZF_CLAIMS_ALL' THEN

339: l_acct_gen_tbl(l_rec_num).offer_id := null;
340: END IF;
341: CLOSE get_util_acc_csr;
342: END IF;
343: ELSIF upper(p_source_table) = 'OZF_CLAIMS_ALL' THEN
344: l_claim_id := p_source_id;
345:
346: IF p_account_type = 'ACCRUAL_LIABILITY'
347: OR p_account_type = 'EXPENSE ACCOUNT' THEN

Line 555: FROM ozf_claims_all c

551: CURSOR get_claim_class_csr(p_id in number) IS
552: SELECT c.claim_class
553: , c.set_of_books_id
554: , g.period_set_name
555: FROM ozf_claims_all c
556: , gl_sets_of_books g
557: WHERE c.set_of_books_id = g.set_of_books_id
558: AND c.claim_id = p_id;
559:

Line 576: ELSIF upper(p_source_table) = 'OZF_CLAIMS_ALL' THEN

572: FND_MSG_PUB.add;
573: END IF;
574: x_return_status := FND_API.g_ret_sts_error;
575: END IF;
576: ELSIF upper(p_source_table) = 'OZF_CLAIMS_ALL' THEN
577: OPEN get_claim_class_csr(p_source_id);
578: FETCH get_claim_class_csr into l_type, x_sob_id, x_period_name;
579: CLOSE get_claim_class_csr;
580:

Line 690: FROM ozf_claim_sttlmnt_methods_all csm,ozf_claims_all c

686: IS
687:
688: CURSOR taxfor_csr (p_claim_id IN NUMBER)IS
689: SELECT tax_for
690: FROM ozf_claim_sttlmnt_methods_all csm,ozf_claims_all c
691: WHERE csm.settlement_method = c.payment_method
692: AND c.claim_id =p_claim_id
693: AND csm.org_id = c.org_id;
694:

Line 837: from ozf_claims_all

833: and fu.utilization_id = cv_utilization_id;
834:
835: CURSOR claim_number_csr(cv_claim_id IN NUMBER) IS
836: select claim_number
837: from ozf_claims_all
838: where claim_id = cv_claim_id;
839:
840: BEGIN
841: IF OZF_DEBUG_HIGH_ON THEN

Line 956: FROM ozf_claims_all cla

952:
953: -- Fix for Bug#13721874
954: CURSOR c_claim_source_info (p_claim_id IN NUMBER)IS
955: SELECT cla.source_object_class
956: FROM ozf_claims_all cla
957: WHERE claim_id = p_claim_id;
958: l_source_object_class VARCHAR2(30);
959:
960:

Line 1080: ELSIF(upper(p_gl_rec.source_table) = 'OZF_CLAIMS_ALL') THEN

1076: END IF;
1077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1078: END IF;
1079: END IF;
1080: ELSIF(upper(p_gl_rec.source_table) = 'OZF_CLAIMS_ALL') THEN
1081:
1082: IF OZF_DEBUG_HIGH_ON THEN
1083: OZF_UTILITY_PVT.debug_message('l_source_object_class:' || l_source_object_class);
1084: END IF;

Line 1172: ELSIF upper(p_gl_rec.source_table) = 'OZF_CLAIMS_ALL' THEN

1168: END IF;
1169: x_return_status := FND_API.g_ret_sts_error;
1170: END IF;
1171:
1172: ELSIF upper(p_gl_rec.source_table) = 'OZF_CLAIMS_ALL' THEN
1173:
1174:
1175: IF p_gl_rec.event_type_code IN ('SETTLE_BY_CREDIT_MEMO','SETTLE_BY_AR_AP_NETTING','SETTLE_BY_ACCOUNTING_ONLY',
1176: 'SETTLE_BY_AR_CUSTOM')

Line 1287: from ozf_claims_all

1283: CURSOR claim_gl_date_csr (p_id in number) IS
1284: select gl_date
1285: , claim_date
1286: , org_id
1287: from ozf_claims_all
1288: where claim_id = p_id;
1289:
1290: CURSOR util_gl_date_csr (p_id in number) IS
1291: select gl_date

Line 1312: ELSIF p_source_table = 'OZF_CLAIMS_ALL' THEN

1308: IF l_gl_date IS NULL THEN
1309: l_gl_date := SYSDATE;
1310: END IF;
1311:
1312: ELSIF p_source_table = 'OZF_CLAIMS_ALL' THEN
1313:
1314: OPEN claim_gl_date_csr (p_source_id);
1315: FETCH claim_gl_date_csr INTO l_gl_date, l_claim_date, l_org_id;
1316: CLOSE claim_gl_date_csr;

Line 1357: from ozf_claims_all

1353: l_org_id number;
1354:
1355: CURSOR claim_org_id_csr (p_id in number) IS
1356: select org_id
1357: from ozf_claims_all
1358: where claim_id = p_id;
1359:
1360: CURSOR util_org_id_csr (p_id in number) IS
1361: select org_id

Line 1371: ELSIF p_source_table = 'OZF_CLAIMS_ALL' THEN

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
1372: OPEN claim_org_id_csr (p_source_id);
1373: FETCH claim_org_id_csr INTO l_org_id;
1374: CLOSE claim_org_id_csr;
1375: END IF;

Line 1552: , ozf_claims_all c

1548: , SUM(u.fxgl_acctd_amount)
1549: , c.currency_code
1550: FROM ozf_claim_lines_util_all u
1551: , ozf_claim_lines_all l
1552: , ozf_claims_all c
1553: WHERE l.claim_id = c.claim_id
1554: AND l.earnings_associated_flag = 'T'
1555: AND l.claim_line_id = u.claim_line_id
1556: AND c.claim_id = p_claim_id

Line 1629: IF (upper(p_gl_rec.source_table) = 'OZF_CLAIMS_ALL' AND p_gl_rec.adjustment_type = 'N'

1625:
1626: -- Fix for Bug 7430768
1627: -- Fix for Bug 8274064, This will only valid for -ve adjustment for claims
1628: -- Fix for Bug 8666602
1629: IF (upper(p_gl_rec.source_table) = 'OZF_CLAIMS_ALL' AND p_gl_rec.adjustment_type = 'N'
1630: AND p_gl_rec.event_type_code <> 'SETTLE_BY_DEBIT') THEN
1631: x_ae_line_tbl(i).entered_dr := (l_amount_tbl(i).entered_dr)*-1;
1632: x_ae_line_tbl(i).entered_cr := (l_amount_tbl(i).entered_cr)*-1;
1633: x_ae_line_tbl(i).accounted_dr := (l_amount_tbl(i).accounted_dr)*-1;

Line 1678: IF upper(p_gl_rec.source_table) = 'OZF_CLAIMS_ALL' THEN

1674: END LOOP;
1675: --x_ae_line_tbl := l_ae_line_tbl;
1676:
1677: -- R12 FXGL Enhancement
1678: IF upper(p_gl_rec.source_table) = 'OZF_CLAIMS_ALL' THEN
1679: G_CLAIM_ID := p_gl_rec.source_id;
1680: l_rec_num := x_ae_line_tbl.count;
1681:
1682: l_line_type_code := get_account_type_code(

Line 2290: FROM ozf_claims_all cla, ozf_sys_parameters_all osp

2286: WHERE HOU.ORGANIZATION_ID = p_org_id;
2287:
2288: CURSOR c_claim_info (p_claim_id IN NUMBER)IS
2289: SELECT cla.gl_date, cla.org_id, cla.claim_date, osp.gl_date_type,cla.payment_method
2290: FROM ozf_claims_all cla, ozf_sys_parameters_all osp
2291: WHERE claim_id = p_claim_id
2292: AND cla.org_id = osp.org_id;
2293:
2294: CURSOR c_count_claim_utils(p_id IN NUMBER) IS

Line 2331: ozf_claims_all oc

2327:
2328: CURSOR csr_inv_cancel_date(cv_claim_id IN NUMBER) IS
2329: SELECT cancelled_date
2330: FROM ap_invoices_all ap,
2331: ozf_claims_all oc
2332: WHERE claim_id = cv_claim_id
2333: AND TO_NUMBER(ap.reference_key1) = oc.claim_id
2334: AND ap.vendor_id = oc.vendor_id
2335: AND ap.vendor_site_id = oc.vendor_site_id

Line 2706: , ozf_claims_all oc

2702:
2703: CURSOR claim_gl_posting_csr(p_id in number) IS
2704: SELECT NVL(osp.post_to_gl, 'F')
2705: FROM ozf_sys_parameters_all osp
2706: , ozf_claims_all oc
2707: WHERE osp.org_id = oc.org_id
2708: AND oc.claim_id = p_id;
2709:
2710: --//Bug fix 10037158

Line 2777: IF upper(p_gl_rec.source_table) = 'OZF_CLAIMS_ALL' THEN

2773: */
2774:
2775:
2776: -- check if post to gl flag in system parameter is set to T
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

Line 2845: IF upper(p_gl_rec.source_table) = 'OZF_CLAIMS_ALL' THEN

2841:
2842: --//ER#9382547 ChRM-SLA Uptake
2843: /*
2844: -- check if claim has promotions. create gl entries only for promotional claims
2845: IF upper(p_gl_rec.source_table) = 'OZF_CLAIMS_ALL' THEN
2846: OPEN promo_claim_csr(p_gl_rec.source_id);
2847: FETCH promo_claim_csr INTO l_asso_amount;
2848: CLOSE promo_claim_csr;
2849:

Line 2890: ELSIF UPPER(p_gl_rec.source_table) = 'OZF_CLAIMS_ALL' THEN

2886: RAISE FND_API.G_EXC_ERROR;
2887: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2889: END IF;
2890: ELSIF UPPER(p_gl_rec.source_table) = 'OZF_CLAIMS_ALL' THEN
2891:
2892: Create_SLA_Claim_Extract (
2893: p_api_version => 1.0
2894: ,p_init_msg_list => FND_API.G_FALSE

Line 3371: where source_table = 'OZF_CLAIMS_ALL'

3367: , org_id
3368: , accounting_date
3369: , object_version_number
3370: from ozf_acctng_events_all
3371: where source_table = 'OZF_CLAIMS_ALL'
3372: and source_id = p_source_id;
3373:
3374: -- Get header details for given accounting event
3375: CURSOR get_ae_header_csr( p_accounting_event_id in NUMBER ) IS

Line 4002: FROM ozf_claim_sttlmnt_methods_all csm,ozf_claims_all c

3998: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| l_api_name;
3999:
4000: CURSOR taxfor_csr (p_claim_id IN NUMBER)IS
4001: SELECT tax_for
4002: FROM ozf_claim_sttlmnt_methods_all csm,ozf_claims_all c
4003: WHERE csm.settlement_method = c.payment_method
4004: AND c.claim_id =p_claim_id
4005: AND csm.org_id = c.org_id;
4006:

Line 4075: l_gl_rec.source_table := 'OZF_CLAIMS_ALL';

4071: END IF;
4072:
4073: l_gl_rec.event_status_code := 'ACCOUNTED';
4074: l_gl_rec.source_id := p_claim_id;
4075: l_gl_rec.source_table := 'OZF_CLAIMS_ALL';
4076: -- Adjutment Type Logic is now seeded with JLTs via switch
4077: /*IF p_claim_class IN ('CLAIM', 'DEDUCTION') THEN
4078: l_gl_rec.adjustment_type := 'P';
4079: ELSIF p_claim_class IN ('CHARGE', 'OVERPAYMENT') THEN