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

1003:
1004: -- Cursor to get claim amount
1005: CURSOR c_exist_total_line_amt(cv_claim_id IN NUMBER) IS
1006: SELECT NVL(SUM(claim_currency_amount), 0)
1007: FROM ozf_claim_lines
1008: WHERE claim_id = cv_claim_id;
1009:
1010: CURSOR c_claim(cv_claim_id IN NUMBER) IS
1011: SELECT currency_code

Line 1290: SELECT ozf_claim_lines_all_s.NEXTVAL

1286: )
1287: IS
1288: -- Cursor to get the sequence for claim_line_id
1289: CURSOR c_claim_line_seq IS
1290: SELECT ozf_claim_lines_all_s.NEXTVAL
1291: FROM DUAL;
1292:
1293: -- Cursor to validate the uniqueness of the claim_line_id
1294: CURSOR c_claim_line_count(cv_claim_line_id IN NUMBER) IS

Line 1296: FROM ozf_claim_lines

1292:
1293: -- Cursor to validate the uniqueness of the claim_line_id
1294: CURSOR c_claim_line_count(cv_claim_line_id IN NUMBER) IS
1295: SELECT COUNT(claim_line_id)
1296: FROM ozf_claim_lines
1297: WHERE claim_line_id = cv_claim_line_id;
1298:
1299: -- Cursor to check the maximum of line_number in order to set line_number value
1300: CURSOR c_line_number(cv_claim_id IN NUMBER) IS

Line 1302: FROM ozf_claim_lines

1298:
1299: -- Cursor to check the maximum of line_number in order to set line_number value
1300: CURSOR c_line_number(cv_claim_id IN NUMBER) IS
1301: SELECT MAX(line_number)
1302: FROM ozf_claim_lines
1303: WHERE claim_id = cv_claim_id;
1304:
1305: -- Cursor to get set_of_books_id, and tax_code from Claim
1306: CURSOR csr_default_fm_claim(cv_claim_id IN NUMBER) IS

Line 1321: FROM ozf_claim_lines

1317:
1318: -- Cursor to sum of claim line amount
1319: CURSOR c_line_sum_amt(cv_claim_id IN NUMBER) IS
1320: SELECT SUM(claim_currency_amount)
1321: FROM ozf_claim_lines
1322: WHERE claim_id = cv_claim_id;
1323:
1324: -- Cursor to get default exchange_rate data from claim
1325: CURSOR c_claim_default_exc(cv_claim_id IN NUMBER) IS

Line 1718: INSERT INTO ozf_claim_lines_all (

1714: OZF_Utility_PVT.debug_message(l_full_name ||': insert');
1715: END IF;
1716:
1717:
1718: INSERT INTO ozf_claim_lines_all (
1719: claim_line_id,
1720: object_version_number,
1721: last_update_date,
1722: last_updated_by,

Line 1993: FROM ozf_claim_lines

1989: l_access VARCHAR2(1) := 'N';
1990:
1991: CURSOR csr_line_obj_ver(cv_claim_line_id IN NUMBER) IS
1992: SELECT object_version_number
1993: FROM ozf_claim_lines
1994: WHERE claim_line_id = cv_claim_line_id;
1995:
1996:
1997: --(Addded by Uday) For Amount check

Line 2012: FROM ozf_claim_lines

2008: WHERE claim_id = cv_claim_id;
2009:
2010: CURSOR csr_exist_total_line_amt(cv_claim_id IN NUMBER) IS
2011: SELECT nvl(sum(claim_currency_amount), 0)
2012: FROM ozf_claim_lines
2013: WHERE claim_id = cv_claim_id;
2014:
2015: --End of Amount check declarations
2016:

Line 2235: FROM ozf_claim_lines

2231:
2232: -- Cursor to get claim_id
2233: CURSOR csr_claim_id(cv_claim_line_id IN NUMBER) IS
2234: SELECT claim_id
2235: FROM ozf_claim_lines
2236: WHERE claim_line_id = cv_claim_line_id;
2237:
2238: -- Cursor to get claim amount
2239: CURSOR c_claim_amount(cv_claim_id IN NUMBER) IS

Line 2247: FROM ozf_claim_lines

2243:
2244: -- Cursor to sum of claim line amount
2245: CURSOR c_line_sum_amt(cv_claim_id IN NUMBER, cv_line_id IN NUMBER) IS
2246: SELECT SUM(claim_currency_amount)
2247: FROM ozf_claim_lines
2248: WHERE claim_id = cv_claim_id
2249: AND claim_line_id <> cv_line_id;
2250:
2251: -- Cursor to get earnings associated with this line

Line 2256: FROM ozf_claim_lines_util

2252: CURSOR csr_get_lines_util(cv_claim_line_id IN NUMBER) IS
2253: SELECT claim_line_util_id
2254: , object_version_number
2255: , currency_code
2256: FROM ozf_claim_lines_util
2257: WHERE claim_line_id = cv_claim_line_id;
2258:
2259: l_claim_id NUMBER;
2260: l_claim_amount NUMBER;

Line 2376: DELETE FROM ozf_claim_lines_all

2372: IF OZF_DEBUG_HIGH_ON THEN
2373: OZF_Utility_PVT.debug_message(l_full_name ||': delete');
2374: END IF;
2375:
2376: DELETE FROM ozf_claim_lines_all
2377: WHERE claim_line_id = p_claim_line_id
2378: AND object_version_number = p_object_version;
2379:
2380: IF (SQL%NOTFOUND) THEN

Line 2464: FROM ozf_claim_lines_all

2460: l_claim_line_id NUMBER;
2461:
2462: CURSOR c_claim_line IS
2463: SELECT claim_line_id
2464: FROM ozf_claim_lines_all
2465: WHERE claim_line_id = p_claim_line_id
2466: AND object_version_number = p_object_version
2467: FOR UPDATE OF claim_line_id NOWAIT;
2468:

Line 2595: FROM ozf_claim_lines

2591: , NVL(item_description, FND_API.g_miss_char)
2592: , NVL(activity_type, FND_API.g_miss_char)
2593: , NVL(activity_id, FND_API.g_miss_num)
2594: , earnings_associated_flag
2595: FROM ozf_claim_lines
2596: WHERE claim_line_id = cv_claim_line_id;
2597: BEGIN
2598: x_return_status := FND_API.g_ret_sts_success;
2599:

Line 2744: FROM ozf_claim_lines

2740: l_access VARCHAR2(1) := 'N';
2741:
2742: CURSOR csr_line_obj_ver(cv_claim_line_id IN NUMBER) IS
2743: SELECT object_version_number
2744: FROM ozf_claim_lines
2745: WHERE claim_line_id = cv_claim_line_id;
2746:
2747: CURSOR c_claim(cv_claim_id IN NUMBER) IS
2748: SELECT amount_remaining

Line 2760: FROM ozf_claim_lines

2756: WHERE claim_id = cv_claim_id;
2757:
2758: CURSOR c_old_line_amt(cv_claim_line_id IN NUMBER) IS
2759: SELECT claim_currency_amount, currency_code
2760: FROM ozf_claim_lines
2761: WHERE claim_line_id = cv_claim_line_id;
2762:
2763: CURSOR c_exist_total_line_amt(cv_claim_id IN NUMBER) IS
2764: SELECT NVL(SUM(claim_currency_amount), 0)

Line 2765: FROM ozf_claim_lines

2761: WHERE claim_line_id = cv_claim_line_id;
2762:
2763: CURSOR c_exist_total_line_amt(cv_claim_id IN NUMBER) IS
2764: SELECT NVL(SUM(claim_currency_amount), 0)
2765: FROM ozf_claim_lines
2766: WHERE claim_id = cv_claim_id;
2767:
2768: BEGIN
2769: --------------------- initialize -----------------------

Line 3062: FROM ozf_claim_lines_util

3058: -- Cursor to sum of line util associations
3059: -- Chage the cursor for bug 7658894
3060: CURSOR csr_claim_line_util_amt(cv_claim_line_id IN NUMBER) IS
3061: SELECT nvl(SUM(acctd_amount),0), nvl(SUM(amount),0)
3062: FROM ozf_claim_lines_util
3063: WHERE claim_line_id = cv_claim_line_id;
3064:
3065: -- Cursor to sum of claim line amount
3066: CURSOR c_line_sum_amt(cv_claim_id IN NUMBER, cv_line_id IN NUMBER) IS

Line 3068: FROM ozf_claim_lines

3064:
3065: -- Cursor to sum of claim line amount
3066: CURSOR c_line_sum_amt(cv_claim_id IN NUMBER, cv_line_id IN NUMBER) IS
3067: SELECT SUM(claim_currency_amount)
3068: FROM ozf_claim_lines
3069: WHERE claim_id = cv_claim_id
3070: AND claim_line_id <> cv_line_id;
3071:
3072: -- Cursor to get default exchange_rate data from claim

Line 3095: FROM ozf_claim_lines_util

3091: CURSOR csr_get_lines_util(cv_claim_line_id IN NUMBER) IS
3092: SELECT claim_line_util_id
3093: , object_version_number
3094: , currency_code
3095: FROM ozf_claim_lines_util
3096: WHERE claim_line_id = cv_claim_line_id;
3097:
3098: -- Fix for bug 7658894
3099: l_line_util_sum NUMBER :=0;

Line 3583: UPDATE ozf_claim_lines_all SET

3579: IF OZF_DEBUG_HIGH_ON THEN
3580: OZF_Utility_PVT.debug_message(l_full_name ||': update');
3581: END IF;
3582:
3583: UPDATE ozf_claim_lines_all SET
3584: object_version_number = l_object_version_number,
3585: last_update_date = SYSDATE,
3586: last_updated_by = l_last_updated_by,
3587: last_update_login = l_last_update_login,

Line 3935: 'ozf_claim_lines',

3931: -- check if this claim_line_id is unique.
3932: IF p_validation_mode = JTF_PLSQL_API.g_create AND
3933: p_claim_line_rec.claim_line_id IS NOT NULL THEN
3934: IF OZF_Utility_PVT.check_uniqueness(
3935: 'ozf_claim_lines',
3936: 'claim_line_id = ' || p_claim_line_rec.claim_line_id
3937: ) = FND_API.g_false THEN
3938: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3939: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_DUPLICATE_VALUE');

Line 4372: FROM ozf_claim_lines

4368: prorate_earnings_flag,
4369: earnings_end_date,
4370: buy_group_party_id,
4371: dpp_cust_account_id --12.1 Enhancement : Price Protection
4372: FROM ozf_claim_lines
4373: WHERE claim_line_id = cv_claim_line_id;
4374:
4375: l_claim_line_rec c_claim_line%ROWTYPE;
4376:

Line 5045: FROM ozf_claim_lines

5041: prorate_earnings_flag,
5042: earnings_end_date,
5043: buy_group_party_id,
5044: org_id
5045: FROM ozf_claim_lines
5046: WHERE claim_line_id = cv_line_id;
5047:
5048:
5049: -- Cursor modified for Bug4997509

Line 5067: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util utl

5063: fu.product_id product_id,
5064: utl.amount amount,
5065: utl.acctd_amount acctd_amount,
5066: utl.util_curr_amount util_curr_amount
5067: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util utl
5068: WHERE utl.utilization_id = fu.utilization_id
5069: AND utl.claim_line_id = cv_line_id
5070: AND utl.utilization_id <> -1
5071: UNION ALL

Line 5079: FROM ams_act_products act, ozf_claim_lines_util utl

5075: NVL(act.inventory_item_id, act.category_id) product_id,
5076: utl.amount amount,
5077: utl.acctd_amount acctd_amount,
5078: NVL(utl.util_curr_amount,utl.amount) util_curr_amount
5079: FROM ams_act_products act, ozf_claim_lines_util utl
5080: WHERE utl.activity_product_id = act.activity_product_id
5081: AND utl.claim_line_id = cv_line_id
5082: AND utl.utilization_id = -1)
5083: GROUP BY offer_id,activity_type, product_level_type, product_id;

Line 5094: FROM ozf_claim_lines

5090:
5091: -- added for bugfix 5075837 to get max line number
5092: CURSOR c_line_number(cv_claim_id IN NUMBER) IS
5093: SELECT MAX(line_number)
5094: FROM ozf_claim_lines
5095: WHERE claim_id = cv_claim_id;
5096:
5097: -- Fix for bug 7658894
5098: CURSOR csr_claim_line_util_sum(cv_claim_line_id IN NUMBER) IS

Line 5100: FROM ozf_claim_lines_util_all

5096:
5097: -- Fix for bug 7658894
5098: CURSOR csr_claim_line_util_sum(cv_claim_line_id IN NUMBER) IS
5099: SELECT sum(amount), sum(acctd_amount)
5100: FROM ozf_claim_lines_util_all
5101: WHERE claim_line_id = cv_claim_line_id;
5102:
5103: CURSOR csr_claim_line_sum(cv_claim_line_id IN NUMBER) IS
5104: SELECT nvl(amount,0), nvl(acctd_amount,0)

Line 5105: FROM ozf_claim_lines_all

5101: WHERE claim_line_id = cv_claim_line_id;
5102:
5103: CURSOR csr_claim_line_sum(cv_claim_line_id IN NUMBER) IS
5104: SELECT nvl(amount,0), nvl(acctd_amount,0)
5105: FROM ozf_claim_lines_all
5106: WHERE claim_line_id = cv_claim_line_id;
5107:
5108: l_sum_util_amount NUMBER :=0;
5109: l_sum_util_acctd_amount NUMBER :=0;

Line 5198: UPDATE ozf_claim_lines

5194: IF csr_line_utils%ROWCOUNT = 1 THEN -- bugfix 4953092
5195:
5196: -- Update original line with offer-product information
5197: -- Leave the utilizations with the original line
5198: UPDATE ozf_claim_lines
5199: SET item_id = l_util_product_id,
5200: item_type = l_util_product_level,
5201: activity_id = NVL(l_old_line_rec.activity_id,l_offer_id),
5202: activity_type = NVL(l_old_line_rec.activity_type,l_activity_type),

Line 5214: UPDATE ozf_claim_lines

5210:
5211: ELSE
5212: --Create a new claim line and move the earnings
5213: -- Modified: reduce claim currency amount by l_claim_line_amount
5214: UPDATE ozf_claim_lines
5215: SET amount = amount - l_claim_line_amount,
5216: acctd_amount = acctd_amount - l_acctd_amount,
5217: claim_currency_amount= claim_currency_amount - l_claim_line_amount
5218: WHERE claim_line_id = p_claim_line_id;

Line 5317: UPDATE ozf_claim_lines_util_all

5313:
5314: -- Point the utilizations to the new claim line
5315: IF l_util_product_id IS NULL AND l_util_product_level IS NULL THEN
5316: -- These are adjustment records without product info
5317: UPDATE ozf_claim_lines_util_all
5318: SET claim_line_id = l_claim_line_id
5319: WHERE claim_line_util_id IN ( SELECT util.claim_line_util_id
5320: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util_all util
5321: WHERE fu.utilization_id = util.utilization_id

Line 5320: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util_all util

5316: -- These are adjustment records without product info
5317: UPDATE ozf_claim_lines_util_all
5318: SET claim_line_id = l_claim_line_id
5319: WHERE claim_line_util_id IN ( SELECT util.claim_line_util_id
5320: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util_all util
5321: WHERE fu.utilization_id = util.utilization_id
5322: AND fu.product_id IS NULL
5323: AND util.claim_line_id = p_claim_line_id
5324: AND fu.product_level_type IS NULL

Line 5328: UPDATE ozf_claim_lines_util_all

5324: AND fu.product_level_type IS NULL
5325: AND fu.plan_id = l_offer_id
5326: AND util.utilization_id > -1);
5327: ELSE
5328: UPDATE ozf_claim_lines_util_all
5329: SET claim_line_id = l_claim_line_id
5330: WHERE claim_line_util_id in ( SELECT util.claim_line_util_id
5331: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util_all util
5332: WHERE fu.utilization_id = util.utilization_id

Line 5331: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util_all util

5327: ELSE
5328: UPDATE ozf_claim_lines_util_all
5329: SET claim_line_id = l_claim_line_id
5330: WHERE claim_line_util_id in ( SELECT util.claim_line_util_id
5331: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util_all util
5332: WHERE fu.utilization_id = util.utilization_id
5333: AND fu.product_id = l_util_product_id
5334: AND util.claim_line_id = p_claim_line_id
5335: AND fu.product_level_type = l_util_product_level

Line 5339: UPDATE ozf_claim_lines_util_all

5335: AND fu.product_level_type = l_util_product_level
5336: AND fu.plan_id = l_offer_id
5337: AND util.utilization_id > -1);
5338:
5339: UPDATE ozf_claim_lines_util_all
5340: SET claim_line_id = l_claim_line_id
5341: WHERE claim_line_util_id IN ( SELECT utl.claim_line_util_id
5342: FROM ams_act_products act, ozf_claim_lines_util_all utl
5343: WHERE utl.activity_product_id = act.activity_product_id

Line 5342: FROM ams_act_products act, ozf_claim_lines_util_all utl

5338:
5339: UPDATE ozf_claim_lines_util_all
5340: SET claim_line_id = l_claim_line_id
5341: WHERE claim_line_util_id IN ( SELECT utl.claim_line_util_id
5342: FROM ams_act_products act, ozf_claim_lines_util_all utl
5343: WHERE utl.activity_product_id = act.activity_product_id
5344: AND utl.claim_line_id = p_claim_line_id
5345: AND act.level_type_code = l_util_product_level
5346: AND NVL(act.inventory_item_id, act.category_id) = l_util_product_id

Line 5375: update ozf_claim_lines_all

5371: OZF_Utility_PVT.debug_message('l_sum_util_amount'||l_sum_util_amount);
5372: END IF;
5373:
5374: IF (l_line_amount = l_sum_util_amount) THEN
5375: update ozf_claim_lines_all
5376: set acctd_amount = l_sum_util_acctd_amount
5377: where claim_line_id = l_claim_line_id;
5378: END IF;
5379: END IF; -- update/create claim line