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_CLAIM_ACCRUAL_PVT dependencies on OZF_CLAIM_LINES_UTIL

Line 1613: FND_DSQL.add_text( ') utiz, ozf_claim_lines_util lu '||

1609: FND_DSQL.add_text( ') utiz ) '||
1610: 'GROUP BY cust_account_id, plan_type, plan_id, bill_to_site_use_id, product_level_type, product_id, currency_code '||
1611: 'ORDER BY cust_account_id, plan_type, plan_id, bill_to_site_use_id, product_level_type, product_id ');
1612: ELSIF p_summary_view = 'DEL_GRP_LINE_UTIL' THEN
1613: FND_DSQL.add_text( ') utiz, ozf_claim_lines_util lu '||
1614: 'WHERE lu.utilization_id = utiz.utilization_id '||
1615: 'AND lu.claim_line_id = ');
1616: FND_DSQL.add_bind( l_funds_util_flt.claim_line_id );
1617: FND_DSQL.add_text( ' ORDER BY utiz.creation_date desc ');

Line 2257: FROM ozf_claim_lines_util

2253:
2254: -- Bug fix 7463302
2255: CURSOR csr_claim_line_util_amount(cv_claim_line_util_id IN NUMBER) IS
2256: SELECT nvl(amount,0)
2257: FROM ozf_claim_lines_util
2258: WHERE claim_line_util_id = cv_claim_line_util_id;
2259:
2260: CURSOR csr_function_currency(cv_org_id NUMBER) IS
2261: SELECT gs.currency_code

Line 2270: FROM ozf_claim_lines_util

2266:
2267: --nepanda Fix for Bug 9075792 - this code is moved to java layer to ClaimAssoVO
2268: CURSOR csr_line_util_sum_amount(cv_claim_line_id IN NUMBER) IS
2269: SELECT SUM(amount)
2270: FROM ozf_claim_lines_util
2271: WHERE claim_line_id = cv_claim_line_id;
2272:
2273: /*CURSOR csr_total_util_lines (cv_claim_line_id IN NUMBER)IS
2274: SELECT COUNT(1),

Line 2276: FROM ozf_claim_lines_util_all

2272:
2273: /*CURSOR csr_total_util_lines (cv_claim_line_id IN NUMBER)IS
2274: SELECT COUNT(1),
2275: MAX(claim_line_util_id)
2276: FROM ozf_claim_lines_util_all
2277: WHERE claim_line_id = cv_claim_line_id; */
2278:
2279: l_sum_amount NUMBER :=0;
2280: l_last_record_num NUMBER := 0;

Line 2430: INSERT INTO ozf_claim_lines_util_all (

2426: END IF;
2427:
2428: IF l_line_util_tbl.COUNT = G_BULK_LIMIT OR i = p_line_util_tbl.LAST THEN
2429: FORALL i IN NVL(l_line_util_tbl.FIRST, 1) .. NVL(l_line_util_tbl.LAST, 0)
2430: INSERT INTO ozf_claim_lines_util_all (
2431: claim_line_util_id,
2432: object_version_number,
2433: last_update_date,
2434: last_updated_by,

Line 2550: UPDATE ozf_claim_lines_util_all

2546: l_line_util_amount := l_line_util_amount + (l_entered_diff_amount - l_sum_amount);
2547:
2548: -- Round the Last Record
2549: IF l_original_total_amount <> 0 THEN --ninarasi fix for 12.2 bug
2550: UPDATE ozf_claim_lines_util_all
2551: SET amount = l_line_util_amount
2552: WHERE claim_line_util_id = l_last_line_util_id;
2553: END IF;
2554:

Line 2658: SELECT ozf_claim_lines_util_all_s.NEXTVAL

2654: l_convert_exchange_rate NUMBER;
2655: l_counter NUMBER;
2656:
2657: CURSOR csr_line_util_seq IS
2658: SELECT ozf_claim_lines_util_all_s.NEXTVAL
2659: FROM DUAL;
2660:
2661: CURSOR csr_line_util_count(cv_line_util_id IN NUMBER) IS
2662: SELECT COUNT(claim_line_util_id)

Line 2663: FROM ozf_claim_lines_util

2659: FROM DUAL;
2660:
2661: CURSOR csr_line_util_count(cv_line_util_id IN NUMBER) IS
2662: SELECT COUNT(claim_line_util_id)
2663: FROM ozf_claim_lines_util
2664: WHERE claim_line_util_id = cv_line_util_id;
2665:
2666: BEGIN
2667: --------------------- initialize -----------------------

Line 2766: --Since, amount column of OZF_CLAIM_LINES_UTIL table expect amount in CLAIM currency. Hence, need to convert

2762: l_line_util_rec.acctd_amount := l_line_util_rec.amount;
2763: END IF;
2764: END IF; --l_utilization_id > -1 check
2765: END IF; --ninarasi fix for bug currency error.
2766: --Since, amount column of OZF_CLAIM_LINES_UTIL table expect amount in CLAIM currency. Hence, need to convert
2767: --l_line_util_rec.amount into CLAIM currency, before creation of association record.
2768: IF l_line_util_rec.amount IS NOT NULL AND l_line_util_rec.amount <> 0 THEN
2769: IF l_currency_rec.association_currency_code <> l_currency_rec.claim_currency_code THEN
2770: OZF_UTILITY_PVT.Convert_Currency

Line 2833: /*INSERT INTO ozf_claim_lines_util_all (

2829:
2830: px_line_util_tbl(l_counter) := l_line_util_rec;
2831:
2832: --ninarasi fix for bug 13530939
2833: /*INSERT INTO ozf_claim_lines_util_all (
2834: claim_line_util_id,
2835: object_version_number,
2836: last_update_date,
2837: last_updated_by,

Line 3206: FROM ozf_claim_lines_util lu

3202: , lu.scan_unit
3203: , lu.util_curr_amount
3204: , lu.currency_code
3205: , fu.plan_currency_code
3206: FROM ozf_claim_lines_util lu
3207: , ozf_funds_utilized_all_b fu
3208: WHERE lu.claim_line_util_id = cv_line_util_id
3209: AND fu.utilization_id = lu.utilization_id;
3210:

Line 3213: FROM ozf_claim_lines_util

3209: AND fu.utilization_id = lu.utilization_id;
3210:
3211: CURSOR csr_total_exist_util_amt(cv_claim_line_id IN NUMBER) IS
3212: SELECT nvl(SUM(acctd_amount),0)
3213: FROM ozf_claim_lines_util
3214: WHERE claim_line_id = cv_claim_line_id;
3215:
3216: CURSOR csr_claim_date(cv_claim_line_id IN NUMBER) IS
3217: SELECT cla.creation_date

Line 3399: UPDATE ozf_claim_lines_util_all SET

3395: IF OZF_DEBUG_HIGH_ON THEN
3396: OZF_Utility_PVT.debug_message(l_full_name ||': update lines utilized');
3397: END IF;
3398:
3399: UPDATE ozf_claim_lines_util_all SET
3400: object_version_number = l_line_util_rec.object_version_number,
3401: last_update_date = SYSDATE,
3402: last_updated_by = l_line_util_rec.last_updated_by,
3403: last_update_login = l_line_util_rec.last_update_login,

Line 3529: FROM ozf_claim_lines_util_all

3525: l_currency_rec currency_rec_type := p_currency_rec;
3526:
3527: CURSOR csr_util_obj_ver(cv_line_util_id IN NUMBER) IS
3528: SELECT object_version_number
3529: FROM ozf_claim_lines_util_all
3530: WHERE claim_line_util_id = cv_line_util_id;
3531:
3532: BEGIN
3533: --------------------- initialize -----------------------

Line 3746: FROM ozf_claim_lines_util

3742: WHERE claim_line_id = cv_claim_line_id;
3743:
3744: CURSOR csr_final_lu_acctd_amt(cv_claim_line_id IN NUMBER) IS
3745: SELECT SUM(acctd_amount)
3746: FROM ozf_claim_lines_util
3747: WHERE claim_line_id = cv_claim_line_id;
3748:
3749: BEGIN
3750: --------------------- initialize -----------------------

Line 3957: FROM ozf_claim_lines_util clu

3953: l_access VARCHAR2(1) := 'N';
3954:
3955: CURSOR csr_claim_line_details(cv_line_util_id IN NUMBER) IS
3956: SELECT clu.claim_line_id , clu.currency_code
3957: FROM ozf_claim_lines_util clu
3958: WHERE claim_line_util_id = cv_line_util_id;
3959:
3960: CURSOR csr_claim_id(cv_claim_line_id IN NUMBER) IS
3961: SELECT claim_id

Line 3971: FROM ozf_claim_lines_util lu

3967: SELECT lu.claim_line_id
3968: , lu.utilization_id
3969: , Decode(lu.currency_code,fu.plan_currency_code, lu.plan_curr_amount, lu.acctd_amount)
3970: , lu.scan_unit
3971: FROM ozf_claim_lines_util lu
3972: , ozf_funds_utilized_all_b fu
3973: WHERE claim_line_util_id = cv_line_util_id
3974: AND lu.utilization_id = fu.utilization_id;
3975:

Line 4094: DELETE FROM ozf_claim_lines_util_all

4090: IF OZF_DEBUG_HIGH_ON THEN
4091: OZF_Utility_PVT.debug_message(l_full_name ||': delete');
4092: END IF;
4093:
4094: DELETE FROM ozf_claim_lines_util_all
4095: WHERE claim_line_util_id = p_line_util_id
4096: AND object_version_number = p_object_version;
4097:
4098: IF (SQL%NOTFOUND) THEN

Line 4204: FROM ozf_claim_lines_util

4200: utilized_acctd_amount,
4201: util_curr_amount, --nepanda : fix for bug # 9508390 - issue # 1
4202: univ_curr_amount,
4203: plan_curr_amount
4204: FROM ozf_claim_lines_util
4205: WHERE claim_line_util_id = cv_line_util_id;
4206:
4207: l_line_util_rec csr_line_util%ROWTYPE;
4208:

Line 6660: from ozf_claim_lines_util

6656:
6657: --used to derive old_total_amount
6658: CURSOR csr_sum_util_amounts(cv_claim_line_id IN NUMBER) IS
6659: select sum(amount)
6660: from ozf_claim_lines_util
6661: where claim_line_id = cv_claim_line_id;
6662:
6663: --used to derive old_total_units
6664: CURSOR csr_sum_scan_units(cv_claim_line_id IN NUMBER) IS

Line 6666: from ozf_claim_lines_util

6662:
6663: --used to derive old_total_units
6664: CURSOR csr_sum_scan_units(cv_claim_line_id IN NUMBER) IS
6665: select sum(scan_unit)
6666: from ozf_claim_lines_util
6667: where claim_line_id = cv_claim_line_id;
6668: --end of bugfix 5182452
6669:
6670: BEGIN

Line 7982: FROM ozf_claim_lines_util lu, ams_act_products ap

7978: WHERE activity_product_id = cv_activity_product_id;
7979:
7980: CURSOR csr_count_workflow(cv_claim_line_id IN NUMBER) IS
7981: SELECT count(*)
7982: FROM ozf_claim_lines_util lu, ams_act_products ap
7983: ,ozf_claim_lines cln1, ozf_claim_lines cln2
7984: WHERE cln1.claim_line_id = cv_claim_line_id
7985: AND cln1.claim_id = cln2.claim_id
7986: AND lu.claim_line_id = cln2.claim_line_id

Line 8669: FROM ozf_claim_lines_util lu,

8665: -- Bugfix 4926327
8666: -- Bugfix 5101106
8667: /*CURSOR csr_funds_used_units(cv_activity_product_id IN NUMBER) IS
8668: SELECT NVL(SUM(scan_unit * amp.quantity ), 0)
8669: FROM ozf_claim_lines_util lu,
8670: ozf_claims c,
8671: ozf_claim_lines cl,
8672: ams_act_products amp
8673: WHERE lu.activity_product_id = cv_activity_product_id

Line 10291: DELETE FROM ozf_claim_lines_util_all

10287:
10288: END IF; -- p_line_util_rec.utilization_id > 0
10289:
10290: ------------------------ delete ------------------------
10291: DELETE FROM ozf_claim_lines_util_all
10292: WHERE claim_line_util_id = p_line_util_rec.claim_line_util_id;
10293:
10294: IF (SQL%NOTFOUND) THEN
10295: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 10403: FROM ozf_claim_lines_util

10399: l_upd_fund_util_tbl upd_fund_util_tbl_type; --ninarasi fix for bug 13530939
10400:
10401: CURSOR csr_final_lu_amt(cv_claim_line_id IN NUMBER) IS
10402: SELECT SUM(amount)
10403: FROM ozf_claim_lines_util
10404: WHERE claim_line_id = cv_claim_line_id;
10405:
10406: -- fix for bug 5042046
10407: CURSOR csr_function_currency IS

Line 10425: FROM ozf_claim_lines_util

10421: WHERE qp_list_header_id = cv_plan_id;
10422:
10423: CURSOR csr_over_util(cv_claim_line_id IN NUMBER, cv_act_product_id IN NUMBER) IS
10424: SELECT claim_line_util_id, acctd_amount, scan_unit
10425: FROM ozf_claim_lines_util
10426: WHERE claim_line_id = cv_claim_line_id
10427: AND activity_product_id = cv_act_product_id
10428: AND utilization_id = -1;
10429:

Line 10432: FROM ozf_claim_lines_util util

10428: AND utilization_id = -1;
10429:
10430: CURSOR csr_acc_over_util(cv_claim_line_id IN NUMBER, cv_offer_id IN NUMBER) IS
10431: SELECT claim_line_util_id, acctd_amount
10432: FROM ozf_claim_lines_util util
10433: WHERE claim_line_id = cv_claim_line_id
10434: AND activity_product_id = cv_offer_id
10435: AND utilization_id = -2;
10436:

Line 10450: FROM ozf_claim_lines_util

10446: --Changed cursor csr_utiz_amount currency for Multicurrency ER.
10447: /*
10448: CURSOR csr_utiz_amount(cv_line_util_id IN NUMBER) IS
10449: SELECT util_curr_amount
10450: FROM ozf_claim_lines_util
10451: WHERE claim_line_util_id = cv_line_util_id;
10452: */
10453:
10454: CURSOR csr_utiz_amount(cv_line_util_id IN NUMBER) IS

Line 10456: FROM ozf_claim_lines_util ln

10452: */
10453:
10454: CURSOR csr_utiz_amount(cv_line_util_id IN NUMBER) IS
10455: SELECT DECODE(ln.currency_code,fu.plan_currency_code,ln.plan_curr_amount,ln.acctd_amount)
10456: FROM ozf_claim_lines_util ln
10457: , ozf_funds_utilized_all_b fu
10458: WHERE claim_line_util_id = cv_line_util_id
10459: AND fu.utilization_id = ln.utilization_id;
10460:

Line 10937: FROM ozf_claim_lines_util

10933: ,quantity
10934: ,amount
10935: ,scan_unit
10936: ,utilization_id
10937: FROM ozf_claim_lines_util
10938: WHERE claim_line_util_id = cv_claim_line_util_id;
10939:
10940: CURSOR csr_funds_utilized(cv_activity_product_id IN NUMBER) IS
10941: SELECT utilization_id

Line 11050: DELETE FROM ozf_claim_lines_util_all

11046: */
11047: END IF;
11048:
11049: -- delete dummy utilizations
11050: DELETE FROM ozf_claim_lines_util_all
11051: WHERE claim_line_util_id = p_claim_line_util_id;
11052:
11053: ---------- Create Group Line Utils -------------------
11054: --Need to check

Line 11187: FROM ozf_claim_lines_util lu, ams_act_products ap

11183: ,lu.activity_product_id
11184: ,lu.scan_unit
11185: ,ap.act_product_used_by_id
11186: ,ap.adjustment_flag
11187: FROM ozf_claim_lines_util lu, ams_act_products ap
11188: ,ozf_claim_lines cln
11189: WHERE cln.claim_id = cv_claim_id
11190: AND lu.claim_line_id = cln.claim_line_id
11191: AND lu.activity_product_id = ap.activity_product_id

Line 11200: FROM ozf_claim_lines_util_all lu

11196: -- the coupon count(scan_unit) is independent of the offer and claim uom code
11197: CURSOR csr_line_utils(cv_claim_id IN NUMBER) IS
11198: SELECT SUM(lu.scan_unit * amp.quantity)
11199: ,lu.utilization_id
11200: FROM ozf_claim_lines_util_all lu
11201: ,ozf_claim_lines_all cln
11202: ,ams_act_products amp
11203: WHERE cln.claim_id = cv_claim_id
11204: AND lu.claim_line_id = cln.claim_line_id

Line 11493: FROM ozf_claim_lines_util lu, ozf_funds_utilized_all_b fu, ozf_claim_lines ln

11489: l_cust_setup_id NUMBER;
11490:
11491: CURSOR csr_line_util(cv_claim_id IN NUMBER) IS
11492: SELECT fu.plan_id, fu.cust_account_id, ln.activity_type
11493: FROM ozf_claim_lines_util lu, ozf_funds_utilized_all_b fu, ozf_claim_lines ln
11494: WHERE lu.utilization_id = fu.utilization_id
11495: AND lu.claim_line_id = ln.claim_line_id
11496: AND ln.claim_id = cv_claim_id
11497: GROUP BY fu.plan_id, fu.cust_account_id, ln.activity_type;

Line 11629: FROM ozf_claim_lines_util lu, ozf_funds_utilized_all_b fu

11625: WHERE org_id = l_currOrgId;
11626:
11627: CURSOR csr_line_util(cv_claim_id IN NUMBER) IS
11628: SELECT fu.plan_id, fu.cust_account_id, sum(lu.acctd_amount)
11629: FROM ozf_claim_lines_util lu, ozf_funds_utilized_all_b fu
11630: , ozf_claim_lines ln
11631: WHERE lu.utilization_id = fu.utilization_id
11632: AND lu.claim_line_id = ln.claim_line_id
11633: AND ln.claim_id = cv_claim_id

Line 11745: FROM ozf_claim_lines_util lu, ozf_funds_utilized_all_b fu, ozf_claim_lines ln

11741: l_counter PLS_INTEGER := 0;
11742:
11743: CURSOR csr_line_util(cv_claim_id IN NUMBER) IS
11744: SELECT fu.plan_id, fu.cust_account_id, ln.activity_type
11745: FROM ozf_claim_lines_util lu, ozf_funds_utilized_all_b fu, ozf_claim_lines ln
11746: WHERE lu.utilization_id = fu.utilization_id
11747: AND lu.claim_line_id = ln.claim_line_id
11748: AND ln.claim_id = cv_claim_id
11749: GROUP BY fu.plan_id, fu.cust_account_id, ln.activity_type;

Line 11815: FROM ozf_claim_lines_util lu, ozf_claim_lines ln

11811: l_counter PLS_INTEGER := 0;
11812:
11813: CURSOR csr_pay_over_earn(cv_claim_id IN NUMBER) IS
11814: SELECT lu.activity_product_id, sum(lu.acctd_amount)
11815: FROM ozf_claim_lines_util lu, ozf_claim_lines ln
11816: WHERE lu.claim_line_id = ln.claim_line_id
11817: AND lu.utilization_id = -2
11818: AND ln.claim_id = cv_claim_id
11819: GROUP BY lu.activity_product_id;