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.OKL_AM_AMORTIZE_PVT dependencies on FA_METHODS

Line 242: CURSOR l_methodcode_csr(p_method_id fa_methods.method_id%TYPE) IS

238:
239:
240: --SECHAWLA 19-FEB-04 3439647 : added life_in_months to the select clause
241: -- This cursor will return a method_code corresponding to a unique method_id
242: CURSOR l_methodcode_csr(p_method_id fa_methods.method_id%TYPE) IS
243: SELECT method_code, life_in_months
244: FROM fa_methods
245: WHERE method_id = p_method_id;
246:

Line 244: FROM fa_methods

240: --SECHAWLA 19-FEB-04 3439647 : added life_in_months to the select clause
241: -- This cursor will return a method_code corresponding to a unique method_id
242: CURSOR l_methodcode_csr(p_method_id fa_methods.method_id%TYPE) IS
243: SELECT method_code, life_in_months
244: FROM fa_methods
245: WHERE method_id = p_method_id;
246:
247:
248:

Line 270: l_fa_method_code fa_methods.method_code%TYPE;

266: */
267:
268: l_hold_period_days okl_amort_hold_setups.hold_period_days%TYPE;
269: l_setup_method_id okl_amort_hold_setups.method_id%TYPE;
270: l_fa_method_code fa_methods.method_code%TYPE;
271: l_fa_life_in_months fa_methods.life_in_months%TYPE;
272: lp_thpv_rec thpv_rec_type;
273: lx_thpv_rec thpv_rec_type;
274: lp_tlpv_rec tlpv_rec_type;

Line 271: l_fa_life_in_months fa_methods.life_in_months%TYPE;

267:
268: l_hold_period_days okl_amort_hold_setups.hold_period_days%TYPE;
269: l_setup_method_id okl_amort_hold_setups.method_id%TYPE;
270: l_fa_method_code fa_methods.method_code%TYPE;
271: l_fa_life_in_months fa_methods.life_in_months%TYPE;
272: lp_thpv_rec thpv_rec_type;
273: lx_thpv_rec thpv_rec_type;
274: lp_tlpv_rec tlpv_rec_type;
275: lx_tlpv_rec tlpv_rec_type;

Line 298: -- If there is a method_id in okl_amort_hold_setups then use it to get deprn method from fa_methods.

294: FETCH l_amthld_csr INTO l_hold_period_days,l_setup_method_id, l_setup_deprn_rate; --l_setup_deprn_rate could be null
295: CLOSE l_amthld_csr;
296:
297:
298: -- If there is a method_id in okl_amort_hold_setups then use it to get deprn method from fa_methods.
299:
300: IF l_setup_method_id IS NOT NULL THEN -- either life or rate is defined in the setup. Life is not stored in teh setup table but rate is stores
301: OPEN l_methodcode_csr(l_setup_method_id);
302: -- SECHAWLA 19-FEB-04 3439647 : Added l_fa_life_in_months

Line 545: -- from fa_methods

541: -- SECHAWLA 19-FEB-04 3439647
542: --lp_tlpv_rec.life_in_months := l_life_in_months;
543:
544: -- If there is a method_id in okl_amort_hold_setups then use it. Otherwise get method id
545: -- from fa_methods
546:
547:
548: IF l_setup_method_id IS NOT NULL THEN
549: lp_tlpv_rec.deprn_method := l_fa_method_code;

Line 815: -- from fa_methods

811: lp_tlpv_rec.description := p_book_rec.item_description;
812:
813:
814: -- If there is a method_id in okl_amort_hold_setups then use it. Otherwise get method id
815: -- from fa_methods
816:
817: IF l_setup_method_id IS NOT NULL THEN
818: lp_tlpv_rec.deprn_method := l_fa_method_code;
819:

Line 1138: CURSOR l_methodcode_csr(p_method_id fa_methods.method_id%TYPE) IS

1134:
1135:
1136: --SECHAWLA 19-FEB-04 3439647 : added life_in_months to the select clause
1137: -- This cursor will return a method_code corresponding to a unique method_id
1138: CURSOR l_methodcode_csr(p_method_id fa_methods.method_id%TYPE) IS
1139: SELECT method_code, life_in_months
1140: FROM fa_methods
1141: WHERE method_id = p_method_id;
1142:

Line 1140: FROM fa_methods

1136: --SECHAWLA 19-FEB-04 3439647 : added life_in_months to the select clause
1137: -- This cursor will return a method_code corresponding to a unique method_id
1138: CURSOR l_methodcode_csr(p_method_id fa_methods.method_id%TYPE) IS
1139: SELECT method_code, life_in_months
1140: FROM fa_methods
1141: WHERE method_id = p_method_id;
1142:
1143:
1144: -- This cursor will return the hold period days and the default depreciation method from a hold period setup table

Line 1156: l_fa_method_code fa_methods.method_code%TYPE;

1152: AND book_type_code = p_book_type_code;
1153:
1154: l_hold_period_days okl_amort_hold_setups.hold_period_days%TYPE;
1155: l_setup_method_id okl_amort_hold_setups.method_id%TYPE;
1156: l_fa_method_code fa_methods.method_code%TYPE;
1157: l_fa_life_in_months fa_methods.life_in_months%TYPE;
1158: lp_thpv_rec thpv_rec_type;
1159: lx_thpv_rec thpv_rec_type;
1160: lp_tlpv_rec tlpv_rec_type;

Line 1157: l_fa_life_in_months fa_methods.life_in_months%TYPE;

1153:
1154: l_hold_period_days okl_amort_hold_setups.hold_period_days%TYPE;
1155: l_setup_method_id okl_amort_hold_setups.method_id%TYPE;
1156: l_fa_method_code fa_methods.method_code%TYPE;
1157: l_fa_life_in_months fa_methods.life_in_months%TYPE;
1158: lp_thpv_rec thpv_rec_type;
1159: lx_thpv_rec thpv_rec_type;
1160: lp_tlpv_rec tlpv_rec_type;
1161: lx_tlpv_rec tlpv_rec_type;

Line 1199: -- If there is a method_id in okl_amort_hold_setups then use it to get deprn method from fa_methods.

1195: OPEN l_amthld_csr(p_book_rec.depreciation_category, p_book_rec.book_type_code);
1196: FETCH l_amthld_csr INTO l_hold_period_days,l_setup_method_id, l_setup_deprn_rate; --l_setup_deprn_rate could be null;
1197: CLOSE l_amthld_csr;
1198:
1199: -- If there is a method_id in okl_amort_hold_setups then use it to get deprn method from fa_methods.
1200:
1201: IF l_setup_method_id IS NOT NULL THEN
1202: OPEN l_methodcode_csr(l_setup_method_id);
1203: -- SECHAWLA 19-FEB-04 3439647 : Added l_fa_life_in_months

Line 1637: -- from fa_methods

1633: -- SECHAWLA 19-FEB-04 3439647
1634: --lp_tlpv_rec.life_in_months := l_life_in_months;
1635:
1636: -- If there is a method_id in okl_amort_hold_setups then use it. Otherwise get method id
1637: -- from fa_methods
1638:
1639: IF l_setup_method_id IS NOT NULL THEN
1640: lp_tlpv_rec.deprn_method := l_fa_method_code;
1641:

Line 1951: -- from fa_methods

1947: -- SECHAWLA 19-FEB-04 3439647
1948: --lp_tlpv_rec.life_in_months := l_life_in_months;
1949:
1950: -- If there is a method_id in okl_amort_hold_setups then use it. Otherwise get method id
1951: -- from fa_methods
1952:
1953: IF l_setup_method_id IS NOT NULL THEN
1954: lp_tlpv_rec.deprn_method := l_fa_method_code;
1955:

Line 2304: CURSOR l_methodcode_csr(p_method_id fa_methods.method_id%TYPE) IS

2300:
2301:
2302: --SECHAWLA 19-FEB-04 3439647 : added life_in_months to the select clause
2303: -- This cursor will return a method_code corresponding to a unique method_id
2304: CURSOR l_methodcode_csr(p_method_id fa_methods.method_id%TYPE) IS
2305: SELECT method_code, life_in_months
2306: FROM fa_methods
2307: WHERE method_id = p_method_id;
2308:

Line 2306: FROM fa_methods

2302: --SECHAWLA 19-FEB-04 3439647 : added life_in_months to the select clause
2303: -- This cursor will return a method_code corresponding to a unique method_id
2304: CURSOR l_methodcode_csr(p_method_id fa_methods.method_id%TYPE) IS
2305: SELECT method_code, life_in_months
2306: FROM fa_methods
2307: WHERE method_id = p_method_id;
2308:
2309:
2310:

Line 2323: l_fa_method_code fa_methods.method_code%TYPE;

2319: AND book_type_code = p_book_type_code;
2320:
2321: l_hold_period_days okl_amort_hold_setups.hold_period_days%TYPE;
2322: l_setup_method_id okl_amort_hold_setups.method_id%TYPE;
2323: l_fa_method_code fa_methods.method_code%TYPE;
2324: l_fa_life_in_months fa_methods.life_in_months%TYPE;
2325: lp_thpv_rec thpv_rec_type;
2326: lx_thpv_rec thpv_rec_type;
2327: lp_tlpv_rec tlpv_rec_type;

Line 2324: l_fa_life_in_months fa_methods.life_in_months%TYPE;

2320:
2321: l_hold_period_days okl_amort_hold_setups.hold_period_days%TYPE;
2322: l_setup_method_id okl_amort_hold_setups.method_id%TYPE;
2323: l_fa_method_code fa_methods.method_code%TYPE;
2324: l_fa_life_in_months fa_methods.life_in_months%TYPE;
2325: lp_thpv_rec thpv_rec_type;
2326: lx_thpv_rec thpv_rec_type;
2327: lp_tlpv_rec tlpv_rec_type;
2328: lx_tlpv_rec tlpv_rec_type;

Line 2364: -- If there is a method_id in okl_amort_hold_setups then use it to get deprn method from fa_methods.

2360: CLOSE l_amthld_csr;
2361:
2362:
2363:
2364: -- If there is a method_id in okl_amort_hold_setups then use it to get deprn method from fa_methods.
2365:
2366: IF l_setup_method_id IS NOT NULL THEN
2367: OPEN l_methodcode_csr(l_setup_method_id);
2368: -- SECHAWLA 19-FEB-04 3439647 : Added l_fa_life_in_months

Line 2782: -- from fa_methods

2778: -- SECHAWLA 19-FEB-04 3439647
2779: --lp_tlpv_rec.life_in_months := l_life_in_months;
2780:
2781: -- If there is a method_id in okl_amort_hold_setups then use it. Otherwise get method id
2782: -- from fa_methods
2783:
2784: IF l_setup_method_id IS NOT NULL THEN
2785: lp_tlpv_rec.deprn_method := l_fa_method_code;
2786:

Line 3088: -- from fa_methods

3084: -- SECHAWLA 19-FEB-04 3439647
3085: --lp_tlpv_rec.life_in_months := l_life_in_months;
3086:
3087: -- If there is a method_id in okl_amort_hold_setups then use it. Otherwise get method id
3088: -- from fa_methods
3089:
3090: IF l_setup_method_id IS NOT NULL THEN
3091: lp_tlpv_rec.deprn_method := l_fa_method_code;
3092:

Line 5554: FROM FA_METHODS FAM

5550:
5551: -- Check the Dep Method and Life In months
5552: CURSOR dep_csr (p_dep_method IN VARCHAR2, p_life_in_months IN NUMBER) IS
5553: SELECT FAM.method_code
5554: FROM FA_METHODS FAM
5555: WHERE FAM.method_code = p_dep_method
5556: AND FAM.life_in_months = p_life_in_months;
5557:
5558: -- Get the Line details

Line 5582: FROM fa_methods famet, fa_flat_rates fart

5578:
5579: -- SECHAWLA 28-MAY-04 3645574 : new cursor for validating deprn rate
5580: CURSOR l_flatrates_csr(cp_deprn_method IN VARCHAR2,cp_deprn_rate_percent IN NUMBER) IS
5581: SELECT 'x'
5582: FROM fa_methods famet, fa_flat_rates fart
5583: WHERE famet.method_code = cp_deprn_method
5584: AND famet.method_id = fart.method_id
5585: AND fart.adjusted_rate = cp_deprn_rate_percent / 100 -- sechawla 03-jun-04 3657624 : divide by 100
5586: AND nvl(fart.adjusting_rate,0) = 0 ;

Line 5596: l_val FA_METHODS.method_code%TYPE;

5592: l_id NUMBER;
5593: l_tsu_code OKL_TRX_ASSETS.tsu_code%TYPE;
5594: l_tas_type OKL_TRX_ASSETS.tas_type%TYPE;
5595: l_date_trn OKL_TRX_ASSETS.date_trans_occurred%TYPE;
5596: l_val FA_METHODS.method_code%TYPE;
5597: l_line_id NUMBER;
5598:
5599: lp_header_rec thpv_rec_type;
5600: lp_lines_rec tlpv_rec_type;