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_LINE_PVT dependencies on OZF_CLAIM_LINES

Line 50: WHERE db_table_name = 'OZF_CLAIM_LINES_ALL'

46: CURSOR csr_user_hist_cols(cv_object_attribute IN VARCHAR2) IS
47: SELECT db_column_name
48: --, ak_attribute_code
49: FROM ams_column_rules
50: WHERE db_table_name = 'OZF_CLAIM_LINES_ALL'
51: AND rule_type = 'HISTORY'
52: AND object_type = 'CLAM'
53: AND object_attribute = cv_object_attribute;
54:

Line 239: FROM ozf_claim_lines_hist

235: , item_description
236: , comments
237: , tax_code
238: , credit_to
239: FROM ozf_claim_lines_hist
240: WHERE claim_line_id = cv_claim_line_id
241: order by claim_line_history_id desc;
242:
243: BEGIN

Line 655: FROM ozf_claim_lines

651: , object_version_number
652: , claim_currency_amount
653: , tax_code
654: , earnings_associated_flag --Bug:2781186
655: FROM ozf_claim_lines
656: WHERE claim_id = cv_claim_id;
657:
658:
659: --Start:Bug:2781186

Line 664: FROM ozf_claim_lines

660: -- get how many claim lines for the given claim. If count is greate than 1 means
661: -- user has modified the line amount and he must be investigating this claim.
662: CURSOR csr_claim_line_count(cv_claim_id IN NUMBER) IS
663: SELECT count(*)
664: FROM ozf_claim_lines
665: WHERE claim_id = cv_claim_id;
666:
667: CURSOR csr_get_line_amount(cv_claim_id IN NUMBER) IS
668: SELECT claim_currency_amount

Line 669: FROM ozf_claim_lines

665: WHERE claim_id = cv_claim_id;
666:
667: CURSOR csr_get_line_amount(cv_claim_id IN NUMBER) IS
668: SELECT claim_currency_amount
669: FROM ozf_claim_lines
670: WHERE claim_id = cv_claim_id;
671: --End:Bug:2781186
672:
673:

Line 1013: FROM ozf_claim_lines_all

1009: , object_version_number
1010: , claim_currency_amount
1011: , tax_code
1012: , earnings_associated_flag
1013: FROM ozf_claim_lines_all
1014: WHERE claim_id = p_claim_id;
1015:
1016: BEGIN
1017: --------------------- initialize -----------------------

Line 1250: FROM ozf_claim_lines

1246:
1247: -- Cursor to get claim amount
1248: CURSOR c_exist_total_line_amt(cv_claim_id IN NUMBER) IS
1249: SELECT NVL(SUM(claim_currency_amount), 0)
1250: FROM ozf_claim_lines
1251: WHERE claim_id = cv_claim_id;
1252:
1253: CURSOR c_claim(cv_claim_id IN NUMBER) IS
1254: SELECT currency_code

Line 1265: select NVL(sum(quantity),0) from ozf_claim_lines_all

1261: FROM ra_customer_trx_lines_all
1262: WHERE customer_trx_line_id = cv_src_obj_line_id;
1263:
1264: CURSOR c_tot_qty(cv_claim_id IN NUMBER, cv_source_object_line_id IN NUMBER) IS
1265: select NVL(sum(quantity),0) from ozf_claim_lines_all
1266: WHERE claim_id = cv_claim_id
1267: and source_object_line_id = cv_source_object_line_id;
1268:
1269: -- Bug#9957893 (-)

Line 1592: SELECT ozf_claim_lines_all_s.NEXTVAL

1588: )
1589: IS
1590: -- Cursor to get the sequence for claim_line_id
1591: CURSOR c_claim_line_seq IS
1592: SELECT ozf_claim_lines_all_s.NEXTVAL
1593: FROM DUAL;
1594:
1595: -- Cursor to validate the uniqueness of the claim_line_id
1596: CURSOR c_claim_line_count(cv_claim_line_id IN NUMBER) IS

Line 1598: FROM ozf_claim_lines

1594:
1595: -- Cursor to validate the uniqueness of the claim_line_id
1596: CURSOR c_claim_line_count(cv_claim_line_id IN NUMBER) IS
1597: SELECT COUNT(claim_line_id)
1598: FROM ozf_claim_lines
1599: WHERE claim_line_id = cv_claim_line_id;
1600:
1601: -- Cursor to check the maximum of line_number in order to set line_number value
1602: CURSOR c_line_number(cv_claim_id IN NUMBER) IS

Line 1604: FROM ozf_claim_lines

1600:
1601: -- Cursor to check the maximum of line_number in order to set line_number value
1602: CURSOR c_line_number(cv_claim_id IN NUMBER) IS
1603: SELECT MAX(line_number)
1604: FROM ozf_claim_lines
1605: WHERE claim_id = cv_claim_id;
1606:
1607: -- Cursor to get set_of_books_id, and tax_code from Claim
1608: CURSOR csr_default_fm_claim(cv_claim_id IN NUMBER) IS

Line 1623: FROM ozf_claim_lines

1619:
1620: -- Cursor to sum of claim line amount
1621: CURSOR c_line_sum_amt(cv_claim_id IN NUMBER) IS
1622: SELECT SUM(claim_currency_amount)
1623: FROM ozf_claim_lines
1624: WHERE claim_id = cv_claim_id;
1625:
1626: -- Cursor to get default exchange_rate data from claim
1627: CURSOR c_claim_default_exc(cv_claim_id IN NUMBER) IS

Line 2055: INSERT INTO ozf_claim_lines_all (

2051: OZF_Utility_PVT.debug_message('l_claim_line_rec.claim_line_id before insert :' || l_claim_line_rec.claim_line_id);
2052: END IF;
2053:
2054:
2055: INSERT INTO ozf_claim_lines_all (
2056: claim_line_id,
2057: object_version_number,
2058: last_update_date,
2059: last_updated_by,

Line 2333: FROM ozf_claim_lines

2329: l_access VARCHAR2(1) := 'N';
2330:
2331: CURSOR csr_line_obj_ver(cv_claim_line_id IN NUMBER) IS
2332: SELECT object_version_number
2333: FROM ozf_claim_lines
2334: WHERE claim_line_id = cv_claim_line_id;
2335:
2336:
2337: --(Addded by Uday) For Amount check

Line 2352: FROM ozf_claim_lines

2348: WHERE claim_id = cv_claim_id;
2349:
2350: CURSOR csr_exist_total_line_amt(cv_claim_id IN NUMBER) IS
2351: SELECT nvl(sum(claim_currency_amount), 0)
2352: FROM ozf_claim_lines
2353: WHERE claim_id = cv_claim_id;
2354:
2355: --End of Amount check declarations
2356:

Line 2585: FROM ozf_claim_lines

2581:
2582: -- Cursor to get claim_id
2583: CURSOR csr_claim_id(cv_claim_line_id IN NUMBER) IS
2584: SELECT claim_id
2585: FROM ozf_claim_lines
2586: WHERE claim_line_id = cv_claim_line_id;
2587:
2588: -- Cursor to get claim amount
2589: CURSOR c_claim_amount(cv_claim_id IN NUMBER) IS

Line 2597: FROM ozf_claim_lines

2593:
2594: -- Cursor to sum of claim line amount
2595: CURSOR c_line_sum_amt(cv_claim_id IN NUMBER, cv_line_id IN NUMBER) IS
2596: SELECT SUM(claim_currency_amount)
2597: FROM ozf_claim_lines
2598: WHERE claim_id = cv_claim_id
2599: AND claim_line_id <> cv_line_id;
2600:
2601: -- Cursor to get earnings associated with this line

Line 2606: FROM ozf_claim_lines_util

2602: CURSOR csr_get_lines_util(cv_claim_line_id IN NUMBER) IS
2603: SELECT claim_line_util_id
2604: , object_version_number
2605: , currency_code
2606: FROM ozf_claim_lines_util
2607: WHERE claim_line_id = cv_claim_line_id;
2608:
2609: l_claim_id NUMBER;
2610: l_claim_amount NUMBER;

Line 2728: DELETE FROM ozf_claim_lines_all

2724: OZF_Utility_PVT.debug_message(p_claim_line_id ||': delete : p_claim_line_id');
2725: OZF_Utility_PVT.debug_message(p_object_version ||': delete : p_object_version');
2726: END IF;
2727:
2728: DELETE FROM ozf_claim_lines_all
2729: WHERE claim_line_id = p_claim_line_id
2730: AND object_version_number = p_object_version;
2731:
2732: IF (SQL%NOTFOUND) THEN

Line 2816: FROM ozf_claim_lines_all

2812: l_claim_line_id NUMBER;
2813:
2814: CURSOR c_claim_line IS
2815: SELECT claim_line_id
2816: FROM ozf_claim_lines_all
2817: WHERE claim_line_id = p_claim_line_id
2818: AND object_version_number = p_object_version
2819: FOR UPDATE OF claim_line_id NOWAIT;
2820:

Line 2947: FROM ozf_claim_lines

2943: , NVL(item_description, FND_API.g_miss_char)
2944: , NVL(activity_type, FND_API.g_miss_char)
2945: , NVL(activity_id, FND_API.g_miss_num)
2946: , earnings_associated_flag
2947: FROM ozf_claim_lines
2948: WHERE claim_line_id = cv_claim_line_id;
2949: BEGIN
2950: x_return_status := FND_API.g_ret_sts_success;
2951:

Line 3100: FROM ozf_claim_lines

3096: l_inv_quantity NUMBER := 0;
3097:
3098: CURSOR csr_line_obj_ver(cv_claim_line_id IN NUMBER) IS
3099: SELECT object_version_number
3100: FROM ozf_claim_lines
3101: WHERE claim_line_id = cv_claim_line_id;
3102:
3103: --ER#9453443
3104: CURSOR c_claim(cv_claim_id IN NUMBER) IS

Line 3126: FROM ozf_claim_lines

3122:
3123:
3124: CURSOR c_old_line_amt(cv_claim_line_id IN NUMBER) IS
3125: SELECT claim_currency_amount, currency_code
3126: FROM ozf_claim_lines
3127: WHERE claim_line_id = cv_claim_line_id;
3128:
3129: CURSOR c_exist_total_line_amt(cv_claim_id IN NUMBER) IS
3130: SELECT NVL(SUM(claim_currency_amount), 0)

Line 3131: FROM ozf_claim_lines

3127: WHERE claim_line_id = cv_claim_line_id;
3128:
3129: CURSOR c_exist_total_line_amt(cv_claim_id IN NUMBER) IS
3130: SELECT NVL(SUM(claim_currency_amount), 0)
3131: FROM ozf_claim_lines
3132: WHERE claim_id = cv_claim_id;
3133:
3134: BEGIN
3135: --------------------- initialize -----------------------

Line 3476: FROM ozf_claim_lines_util

3472: -- Cursor to sum of line util associations
3473: -- Chage the cursor for bug 7658894
3474: CURSOR csr_claim_line_util_amt(cv_claim_line_id IN NUMBER) IS
3475: SELECT nvl(SUM(acctd_amount),0), nvl(SUM(amount),0)
3476: FROM ozf_claim_lines_util
3477: WHERE claim_line_id = cv_claim_line_id;
3478:
3479: -- Cursor to sum of claim line amount
3480: CURSOR c_line_sum_amt(cv_claim_id IN NUMBER, cv_line_id IN NUMBER) IS

Line 3482: FROM ozf_claim_lines

3478:
3479: -- Cursor to sum of claim line amount
3480: CURSOR c_line_sum_amt(cv_claim_id IN NUMBER, cv_line_id IN NUMBER) IS
3481: SELECT SUM(claim_currency_amount)
3482: FROM ozf_claim_lines
3483: WHERE claim_id = cv_claim_id
3484: AND claim_line_id <> cv_line_id;
3485:
3486: -- Cursor to get default exchange_rate data from claim

Line 3509: FROM ozf_claim_lines_util

3505: CURSOR csr_get_lines_util(cv_claim_line_id IN NUMBER) IS
3506: SELECT claim_line_util_id
3507: , object_version_number
3508: , currency_code
3509: FROM ozf_claim_lines_util
3510: WHERE claim_line_id = cv_claim_line_id;
3511:
3512: -- Fix for bug 7658894
3513: l_line_util_sum NUMBER :=0;

Line 4015: UPDATE ozf_claim_lines_all SET

4011: IF OZF_DEBUG_HIGH_ON THEN
4012: OZF_Utility_PVT.debug_message(l_full_name ||': update');
4013: END IF;
4014:
4015: UPDATE ozf_claim_lines_all SET
4016: object_version_number = l_object_version_number,
4017: last_update_date = SYSDATE,
4018: last_updated_by = l_last_updated_by,
4019: last_update_login = l_last_update_login,

Line 4368: 'ozf_claim_lines',

4364: -- check if this claim_line_id is unique.
4365: IF p_validation_mode = JTF_PLSQL_API.g_create AND
4366: p_claim_line_rec.claim_line_id IS NOT NULL THEN
4367: IF OZF_Utility_PVT.check_uniqueness(
4368: 'ozf_claim_lines',
4369: 'claim_line_id = ' || p_claim_line_rec.claim_line_id
4370: ) = FND_API.g_false THEN
4371: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4372: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_DUPLICATE_VALUE');

Line 4805: FROM ozf_claim_lines

4801: prorate_earnings_flag,
4802: earnings_end_date,
4803: buy_group_party_id,
4804: dpp_cust_account_id --12.1 Enhancement : Price Protection
4805: FROM ozf_claim_lines
4806: WHERE claim_line_id = cv_claim_line_id;
4807:
4808: l_claim_line_rec c_claim_line%ROWTYPE;
4809:

Line 5478: FROM ozf_claim_lines

5474: prorate_earnings_flag,
5475: earnings_end_date,
5476: buy_group_party_id,
5477: org_id
5478: FROM ozf_claim_lines
5479: WHERE claim_line_id = cv_line_id;
5480:
5481:
5482: -- Cursor modified for Bug4997509

Line 5500: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util utl

5496: fu.product_id product_id,
5497: utl.amount amount,
5498: utl.acctd_amount acctd_amount,
5499: utl.util_curr_amount util_curr_amount
5500: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util utl
5501: WHERE utl.utilization_id = fu.utilization_id
5502: AND utl.claim_line_id = cv_line_id
5503: AND utl.utilization_id <> -1
5504: UNION ALL

Line 5512: FROM ams_act_products act, ozf_claim_lines_util utl

5508: NVL(act.inventory_item_id, act.category_id) product_id,
5509: utl.amount amount,
5510: utl.acctd_amount acctd_amount,
5511: NVL(utl.util_curr_amount,utl.amount) util_curr_amount
5512: FROM ams_act_products act, ozf_claim_lines_util utl
5513: WHERE utl.activity_product_id = act.activity_product_id
5514: AND utl.claim_line_id = cv_line_id
5515: AND utl.utilization_id = -1)
5516: GROUP BY offer_id,activity_type, product_level_type, product_id;

Line 5527: FROM ozf_claim_lines

5523:
5524: -- added for bugfix 5075837 to get max line number
5525: CURSOR c_line_number(cv_claim_id IN NUMBER) IS
5526: SELECT MAX(line_number)
5527: FROM ozf_claim_lines
5528: WHERE claim_id = cv_claim_id;
5529:
5530: -- Fix for bug 7658894
5531: CURSOR csr_claim_line_util_sum(cv_claim_line_id IN NUMBER) IS

Line 5533: FROM ozf_claim_lines_util_all

5529:
5530: -- Fix for bug 7658894
5531: CURSOR csr_claim_line_util_sum(cv_claim_line_id IN NUMBER) IS
5532: SELECT sum(amount), sum(acctd_amount)
5533: FROM ozf_claim_lines_util_all
5534: WHERE claim_line_id = cv_claim_line_id;
5535:
5536: CURSOR csr_claim_line_sum(cv_claim_line_id IN NUMBER) IS
5537: SELECT nvl(amount,0), nvl(acctd_amount,0)

Line 5538: FROM ozf_claim_lines_all

5534: WHERE claim_line_id = cv_claim_line_id;
5535:
5536: CURSOR csr_claim_line_sum(cv_claim_line_id IN NUMBER) IS
5537: SELECT nvl(amount,0), nvl(acctd_amount,0)
5538: FROM ozf_claim_lines_all
5539: WHERE claim_line_id = cv_claim_line_id;
5540:
5541: l_sum_util_amount NUMBER :=0;
5542: l_sum_util_acctd_amount NUMBER :=0;

Line 5631: UPDATE ozf_claim_lines

5627: IF csr_line_utils%ROWCOUNT = 1 THEN -- bugfix 4953092
5628:
5629: -- Update original line with offer-product information
5630: -- Leave the utilizations with the original line
5631: UPDATE ozf_claim_lines
5632: SET item_id = l_util_product_id,
5633: item_type = l_util_product_level,
5634: activity_id = NVL(l_old_line_rec.activity_id,l_offer_id),
5635: activity_type = NVL(l_old_line_rec.activity_type,l_activity_type),

Line 5647: UPDATE ozf_claim_lines

5643:
5644: ELSE
5645: --Create a new claim line and move the earnings
5646: -- Modified: reduce claim currency amount by l_claim_line_amount
5647: UPDATE ozf_claim_lines
5648: SET amount = amount - l_claim_line_amount,
5649: acctd_amount = acctd_amount - l_acctd_amount,
5650: claim_currency_amount= claim_currency_amount - l_claim_line_amount
5651: WHERE claim_line_id = p_claim_line_id;

Line 5750: UPDATE ozf_claim_lines_util_all

5746:
5747: -- Point the utilizations to the new claim line
5748: IF l_util_product_id IS NULL AND l_util_product_level IS NULL THEN
5749: -- These are adjustment records without product info
5750: UPDATE ozf_claim_lines_util_all
5751: SET claim_line_id = l_claim_line_id
5752: WHERE claim_line_util_id IN ( SELECT util.claim_line_util_id
5753: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util_all util
5754: WHERE fu.utilization_id = util.utilization_id

Line 5753: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util_all util

5749: -- These are adjustment records without product info
5750: UPDATE ozf_claim_lines_util_all
5751: SET claim_line_id = l_claim_line_id
5752: WHERE claim_line_util_id IN ( SELECT util.claim_line_util_id
5753: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util_all util
5754: WHERE fu.utilization_id = util.utilization_id
5755: AND fu.product_id IS NULL
5756: AND util.claim_line_id = p_claim_line_id
5757: AND fu.product_level_type IS NULL

Line 5761: UPDATE ozf_claim_lines_util_all

5757: AND fu.product_level_type IS NULL
5758: AND fu.plan_id = l_offer_id
5759: AND util.utilization_id > -1);
5760: ELSE
5761: UPDATE ozf_claim_lines_util_all
5762: SET claim_line_id = l_claim_line_id
5763: WHERE claim_line_util_id in ( SELECT util.claim_line_util_id
5764: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util_all util
5765: WHERE fu.utilization_id = util.utilization_id

Line 5764: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util_all util

5760: ELSE
5761: UPDATE ozf_claim_lines_util_all
5762: SET claim_line_id = l_claim_line_id
5763: WHERE claim_line_util_id in ( SELECT util.claim_line_util_id
5764: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util_all util
5765: WHERE fu.utilization_id = util.utilization_id
5766: AND fu.product_id = l_util_product_id
5767: AND util.claim_line_id = p_claim_line_id
5768: AND fu.product_level_type = l_util_product_level

Line 5772: UPDATE ozf_claim_lines_util_all

5768: AND fu.product_level_type = l_util_product_level
5769: AND fu.plan_id = l_offer_id
5770: AND util.utilization_id > -1);
5771:
5772: UPDATE ozf_claim_lines_util_all
5773: SET claim_line_id = l_claim_line_id
5774: WHERE claim_line_util_id IN ( SELECT utl.claim_line_util_id
5775: FROM ams_act_products act, ozf_claim_lines_util_all utl
5776: WHERE utl.activity_product_id = act.activity_product_id

Line 5775: FROM ams_act_products act, ozf_claim_lines_util_all utl

5771:
5772: UPDATE ozf_claim_lines_util_all
5773: SET claim_line_id = l_claim_line_id
5774: WHERE claim_line_util_id IN ( SELECT utl.claim_line_util_id
5775: FROM ams_act_products act, ozf_claim_lines_util_all utl
5776: WHERE utl.activity_product_id = act.activity_product_id
5777: AND utl.claim_line_id = p_claim_line_id
5778: AND act.level_type_code = l_util_product_level
5779: AND NVL(act.inventory_item_id, act.category_id) = l_util_product_id

Line 5808: update ozf_claim_lines_all

5804: OZF_Utility_PVT.debug_message('l_sum_util_amount'||l_sum_util_amount);
5805: END IF;
5806:
5807: IF (l_line_amount = l_sum_util_amount) THEN
5808: update ozf_claim_lines_all
5809: set acctd_amount = l_sum_util_acctd_amount
5810: where claim_line_id = l_claim_line_id;
5811: END IF;
5812: END IF; -- update/create claim line

Line 5909: FROM ozf_claim_lines_all cln, ozf_claim_lines_util_all clu

5905:
5906: --Cursor to fetch the claim line detail
5907: CURSOR claim_line_id_csr(p_id in number) IS
5908: SELECT distinct cln.claim_line_id, cln.object_version_number
5909: FROM ozf_claim_lines_all cln, ozf_claim_lines_util_all clu
5910: WHERE clu.claim_line_id = cln.claim_line_id
5911: AND claim_id = p_id;
5912:
5913: