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

Line 288: , ozf_claim_lines line

284: /*
285: CURSOR csr_object_class (cv_request_id IN NUMBER) IS
286: SELECT cla.source_object_class
287: FROM ozf_claims cla
288: , ozf_claim_lines line
289: WHERE cla.claim_id = line.claim_id
290: AND line.activity_id = cv_request_id;
291: */
292: CURSOR csr_object_class (cv_claim_line_id IN NUMBER) IS

Line 295: , ozf_claim_lines_all line

291: */
292: CURSOR csr_object_class (cv_claim_line_id IN NUMBER) IS
293: SELECT cla.source_object_class
294: FROM ozf_claims_all cla
295: , ozf_claim_lines_all line
296: WHERE cla.claim_id = line.claim_id
297: AND line.claim_line_id = cv_claim_line_id;
298: --Bug# 8513457 fixed by ateotia (-)
299:

Line 302: FROM ozf_claim_lines

298: --Bug# 8513457 fixed by ateotia (-)
299:
300: CURSOR csr_claim_currency(cv_claim_line_id NUMBER) IS
301: SELECT currency_code
302: FROM ozf_claim_lines
303: WHERE claim_line_id = cv_claim_line_id;
304: BEGIN
305: --------------------- initialize -----------------------
306: SAVEPOINT Update_Fund_Utils;

Line 799: FROM ozf_claim_lines ln

795: , ln.earnings_end_date
796: , ln.claim_currency_amount
797: , cla.source_object_class
798: , cla.source_object_id
799: FROM ozf_claim_lines ln
800: , ozf_claims cla
801: WHERE ln.claim_id = cla.claim_id
802: AND ln.claim_line_id = cv_claim_line_id;
803:

Line 984: FROM ozf_claim_lines

980: l_currency_rec currency_rec_type := px_currency_rec;
981:
982: CURSOR csr_claim_currency(cv_claim_line_id IN NUMBER) IS
983: SELECT currency_code
984: FROM ozf_claim_lines
985: where claim_line_id = cv_claim_line_id;
986:
987:
988: BEGIN

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 1952: FROM ozf_claim_lines

1948: l_prorate_earnings_flag VARCHAR2(1);
1949:
1950: CURSOR csr_line_flag(cv_claim_line_id IN NUMBER) IS
1951: SELECT prorate_earnings_flag
1952: FROM ozf_claim_lines
1953: WHERE claim_line_id = cv_claim_line_id;
1954:
1955: -- fix for bug 5042046
1956: CURSOR csr_system_flag IS

Line 2245: , ozf_claim_lines ln

2241: , cla.exchange_rate_type
2242: , cla.exchange_rate_date
2243: , cla.exchange_rate
2244: FROM ozf_claims cla
2245: , ozf_claim_lines ln
2246: WHERE ln.claim_id = cla.claim_id
2247: AND ln.claim_line_id = cv_claim_line_id;
2248:
2249: CURSOR csr_claim_id(cv_claim_line_id IN NUMBER) IS

Line 2251: FROM ozf_claim_lines

2247: AND ln.claim_line_id = cv_claim_line_id;
2248:
2249: CURSOR csr_claim_id(cv_claim_line_id IN NUMBER) IS
2250: SELECT claim_id
2251: FROM ozf_claim_lines
2252: WHERE claim_line_id = cv_claim_line_id;
2253:
2254: -- Bug fix 7463302
2255: CURSOR csr_claim_line_util_amount(cv_claim_line_util_id IN NUMBER) IS

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 2560: UPDATE ozf_claim_lines_all

2556: --End of fix for Bug 12369487
2557:
2558:
2559: -- Update Claim Line: set earnings_associated_flag to TRUE
2560: UPDATE ozf_claim_lines_all
2561: SET earnings_associated_flag = 'T'
2562: WHERE claim_line_id = l_line_util_rec.claim_line_id;
2563: END IF;
2564:

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 2981: FROM ozf_claim_lines

2977:
2978: -- Cursor to get claim_id
2979: CURSOR csr_claim_id(cv_claim_line_id IN NUMBER) IS
2980: SELECT claim_id
2981: FROM ozf_claim_lines
2982: WHERE claim_line_id = cv_claim_line_id;
2983:
2984: BEGIN
2985: --------------------- initialize -----------------------

Line 3196: FROM ozf_claim_lines

3192: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
3193:
3194: CURSOR csr_claim_id(cv_claim_line_id IN NUMBER) IS
3195: SELECT claim_id, acctd_amount
3196: FROM ozf_claim_lines
3197: WHERE claim_line_id = cv_claim_line_id;
3198:
3199: --Cursor changed for Claims-Multicurrency ER
3200: CURSOR csr_lu_old_amt(cv_line_util_id IN NUMBER) IS

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 3218: FROM ozf_claims cla, ozf_claim_lines cl

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
3218: FROM ozf_claims cla, ozf_claim_lines cl
3219: WHERE cla.claim_id = cl.claim_id
3220: AND cl.claim_line_id = cv_claim_line_id;
3221:
3222: BEGIN

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 3741: FROM ozf_claim_lines

3737:
3738: -- Cursor to get claim_id
3739: CURSOR csr_claim_id(cv_claim_line_id IN NUMBER) IS
3740: SELECT claim_id
3741: FROM ozf_claim_lines
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)

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 3859: UPDATE ozf_claim_lines_all

3855: FETCH csr_final_lu_acctd_amt INTO l_final_lu_acctd_amt;
3856: CLOSE csr_final_lu_acctd_amt;
3857:
3858: IF l_final_lu_acctd_amt = 0 OR l_final_lu_acctd_amt IS NULL THEN
3859: UPDATE ozf_claim_lines_all
3860: SET earnings_associated_flag = 'F'
3861: WHERE claim_line_id = p_line_util_tbl(1).claim_line_id;
3862: END IF;
3863:

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 3962: FROM ozf_claim_lines

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
3962: FROM ozf_claim_lines
3963: WHERE claim_line_id = cv_claim_line_id;
3964:
3965: --Cursor changed for Claims-Multicurrency ER / Pranay
3966: CURSOR csr_old_line_util_amt(cv_line_util_id IN NUMBER) IS

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 4891: FROM ozf_claim_lines

4887: , item_type
4888: , item_id
4889: -- , acctd_amount
4890: , claim_currency_amount
4891: FROM ozf_claim_lines
4892: WHERE claim_id = cv_claim_id;
4893:
4894: CURSOR csr_uom_code(cv_item_id IN NUMBER) IS
4895: SELECT primary_uom_code

Line 5507: FROM ozf_claim_lines

5503: , activity_id
5504: , item_type
5505: , item_id
5506: , acctd_amount
5507: FROM ozf_claim_lines
5508: WHERE claim_id = cv_claim_id;
5509:
5510: CURSOR csr_uom_code(cv_item_id IN NUMBER) IS
5511: SELECT primary_uom_code

Line 6251: FROM ozf_claim_lines

6247: l_currency_rec currency_rec_type;
6248: -- Added For Bug 7611966
6249: CURSOR csr_claim_line(cv_claim_id IN NUMBER) IS
6250: SELECT claim_line_id
6251: FROM ozf_claim_lines
6252: WHERE claim_id = cv_claim_id;
6253:
6254: CURSOR csr_uom_code(cv_item_id IN NUMBER) IS
6255: SELECT primary_uom_code

Line 6274: FROM ozf_claim_lines

6270: , activity_type
6271: , activity_id
6272: , item_id
6273: , claim_currency_amount
6274: FROM ozf_claim_lines
6275: WHERE claim_line_id = cv_claim_line_id
6276: AND claim_id = cv_claim_id;
6277: CURSOR csr_function_currency IS
6278: SELECT gs.currency_code

Line 6654: from ozf_claim_lines_all

6650: , buy_group_party_id
6651: , select_cust_children_flag
6652: , prorate_earnings_flag
6653: , utilization_id -- Added For Bug 8402328
6654: from ozf_claim_lines_all
6655: WHERE claim_line_id = cv_claim_line_id;
6656:
6657: --used to derive old_total_amount
6658: CURSOR csr_sum_util_amounts(cv_claim_line_id IN NUMBER) IS

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 6953: FROM ozf_claim_lines

6949: AND INVENTORY_ITEM_ID = cv_product_id;
6950:
6951: CURSOR csr_claim_line(cv_claim_id IN NUMBER) IS
6952: SELECT claim_line_id
6953: FROM ozf_claim_lines
6954: WHERE claim_id = cv_claim_id;
6955:
6956: CURSOR csr_party_name(cv_cust_account_id IN NUMBER) IS
6957: SELECT p.party_name

Line 7442: FROM ozf_claim_lines

7438: AND INVENTORY_ITEM_ID = cv_product_id;
7439:
7440: CURSOR csr_claim_line(cv_claim_id IN NUMBER) IS
7441: SELECT claim_line_id
7442: FROM ozf_claim_lines
7443: WHERE claim_id = cv_claim_id;
7444:
7445: CURSOR csr_party_name(cv_cust_account_id IN NUMBER) IS
7446: SELECT p.party_name

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 7983: ,ozf_claim_lines cln1, ozf_claim_lines cln2

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
7987: AND lu.activity_product_id = ap.activity_product_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 8671: ozf_claim_lines cl,

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
8674: AND cl.claim_line_id = lu.claim_line_id
8675: AND cl.claim_id = c.claim_id

Line 9653: FROM ozf_claims cla, ozf_claim_lines cln

9649: , cln.activity_id
9650: , cln.batch_line_id
9651: , cla.created_from
9652: , cla.org_id
9653: FROM ozf_claims cla, ozf_claim_lines cln
9654: WHERE cla.claim_id = cln.claim_id
9655: AND cln.claim_line_id = cv_claim_line_id;
9656:
9657: BEGIN

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 10415: SELECT currency_code from ozf_claim_lines

10411: WHERE org.set_of_books_id = gs.set_of_books_id
10412: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
10413:
10414: CURSOR csr_claim_currency(cv_claim_line_id IN NUMBER) IS
10415: SELECT currency_code from ozf_claim_lines
10416: where claim_line_id = cv_claim_line_id;
10417:
10418: CURSOR csr_offer_currency(cv_plan_id IN NUMBER) IS
10419: SELECT transaction_currency_code

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 10831: UPDATE ozf_claim_lines_all

10827: CLOSE csr_final_lu_amt;
10828:
10829: IF l_final_lu_amt = 0 OR
10830: l_final_lu_amt IS NULL THEN
10831: UPDATE ozf_claim_lines_all
10832: SET earnings_associated_flag = 'F'
10833: WHERE claim_line_id = p_funds_util_flt.claim_line_id;
10834: END IF;
10835:

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 11188: ,ozf_claim_lines cln

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
11192: AND lu.utilization_id = -1

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 11201: ,ozf_claim_lines_all cln

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
11205: AND lu.activity_product_id = amp.activity_product_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 11630: , ozf_claim_lines ln

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
11634: GROUP BY fu.plan_id, fu.cust_account_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;

Line 11982: FROM ozf_claim_lines_all lines

11978: , item_id
11979: -- , acctd_amount
11980: , amount --7169388
11981: , fund.approved_in_currency --7231613 --//SD MC
11982: FROM ozf_claim_lines_all lines
11983: , ozf_offers offr
11984: , ozf_act_budgets fund
11985: , ozf_sd_request_headers_all_b req
11986: WHERE claim_id = cv_claim_id

Line 12002: FROM ozf_claim_lines_all lines

11998: , lines.item_type
11999: , lines.item_id
12000: , lines.amount
12001: , offr.transaction_currency_code
12002: FROM ozf_claim_lines_all lines
12003: , ozf_offers offr
12004: , ozf_sd_request_headers_all_b req
12005: WHERE claim_id = cv_claim_id
12006: AND lines.activity_id = req.request_header_id

Line 12130: , ozf_claim_lines line

12126:
12127: CURSOR csr_access(cv_claim_id IN NUMBER) IS
12128: SELECT resource_id
12129: FROM ozf_sd_request_access req
12130: , ozf_claim_lines line
12131: , ozf_claims cla
12132: WHERE cla.claim_id = cv_claim_id
12133: AND cla.claim_id = line.claim_id
12134: AND line.activity_id = req.request_header_id

Line 12936: FROM ozf_claim_lines_all

12932: WHERE claim_id = cv_claim_id;
12933:
12934: CURSOR claim_line_id_csr(p_id in number) IS
12935: SELECT claim_line_id, object_version_number
12936: FROM ozf_claim_lines_all
12937: WHERE claim_id = p_id
12938: AND (earnings_associated_flag IS NULL
12939: OR earnings_associated_flag ='F');
12940: