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 OKL_AMORT_HOLD_SETUPS

Line 251: CURSOR l_amthld_csr(p_category_id okl_amort_hold_setups.category_id%TYPE,

247:
248:
249: -- This cursor will return the hold period days and the default depreciation method from a hold period setup table
250: -- using category_id and book_type_code.
251: CURSOR l_amthld_csr(p_category_id okl_amort_hold_setups.category_id%TYPE,
252: p_book_type_code okl_amort_hold_setups.book_type_code%TYPE) IS
253: -- SECHAWLA 28-MAY-04 3645574 : Added deprn_rate
254: SELECT hold_period_days, method_id, deprn_rate
255: FROM okl_amort_hold_setups

Line 252: p_book_type_code okl_amort_hold_setups.book_type_code%TYPE) IS

248:
249: -- This cursor will return the hold period days and the default depreciation method from a hold period setup table
250: -- using category_id and book_type_code.
251: CURSOR l_amthld_csr(p_category_id okl_amort_hold_setups.category_id%TYPE,
252: p_book_type_code okl_amort_hold_setups.book_type_code%TYPE) IS
253: -- SECHAWLA 28-MAY-04 3645574 : Added deprn_rate
254: SELECT hold_period_days, method_id, deprn_rate
255: FROM okl_amort_hold_setups
256: WHERE category_id = p_category_id

Line 255: FROM okl_amort_hold_setups

251: CURSOR l_amthld_csr(p_category_id okl_amort_hold_setups.category_id%TYPE,
252: p_book_type_code okl_amort_hold_setups.book_type_code%TYPE) IS
253: -- SECHAWLA 28-MAY-04 3645574 : Added deprn_rate
254: SELECT hold_period_days, method_id, deprn_rate
255: FROM okl_amort_hold_setups
256: WHERE category_id = p_category_id
257: AND book_type_code = p_book_type_code;
258:
259: /*

Line 268: l_hold_period_days okl_amort_hold_setups.hold_period_days%TYPE;

264: WHERE asset_id = p_id
265: AND book_type_code = p_btc;
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;

Line 269: l_setup_method_id okl_amort_hold_setups.method_id%TYPE;

265: AND book_type_code = p_btc;
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;

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 544: -- If there is a method_id in okl_amort_hold_setups then use it. Otherwise get method id

540:
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

Line 814: -- If there is a method_id in okl_amort_hold_setups then use it. Otherwise get method id

810: lp_tlpv_rec.asset_number := p_book_rec.asset_number;
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;

Line 1146: CURSOR l_amthld_csr(p_category_id okl_amort_hold_setups.category_id%TYPE,

1142:
1143:
1144: -- This cursor will return the hold period days and the default depreciation method from a hold period setup table
1145: -- using category_id and book_type_code.
1146: CURSOR l_amthld_csr(p_category_id okl_amort_hold_setups.category_id%TYPE,
1147: p_book_type_code okl_amort_hold_setups.book_type_code%TYPE) IS
1148: -- SECHAWLA 28-MAY-04 3645574 : Added deprn_rate
1149: SELECT hold_period_days, method_id, deprn_rate
1150: FROM okl_amort_hold_setups

Line 1147: p_book_type_code okl_amort_hold_setups.book_type_code%TYPE) IS

1143:
1144: -- This cursor will return the hold period days and the default depreciation method from a hold period setup table
1145: -- using category_id and book_type_code.
1146: CURSOR l_amthld_csr(p_category_id okl_amort_hold_setups.category_id%TYPE,
1147: p_book_type_code okl_amort_hold_setups.book_type_code%TYPE) IS
1148: -- SECHAWLA 28-MAY-04 3645574 : Added deprn_rate
1149: SELECT hold_period_days, method_id, deprn_rate
1150: FROM okl_amort_hold_setups
1151: WHERE category_id = p_category_id

Line 1150: FROM okl_amort_hold_setups

1146: CURSOR l_amthld_csr(p_category_id okl_amort_hold_setups.category_id%TYPE,
1147: p_book_type_code okl_amort_hold_setups.book_type_code%TYPE) IS
1148: -- SECHAWLA 28-MAY-04 3645574 : Added deprn_rate
1149: SELECT hold_period_days, method_id, deprn_rate
1150: FROM okl_amort_hold_setups
1151: WHERE category_id = p_category_id
1152: AND book_type_code = p_book_type_code;
1153:
1154: l_hold_period_days okl_amort_hold_setups.hold_period_days%TYPE;

Line 1154: l_hold_period_days okl_amort_hold_setups.hold_period_days%TYPE;

1150: FROM okl_amort_hold_setups
1151: WHERE category_id = p_category_id
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;

Line 1155: l_setup_method_id okl_amort_hold_setups.method_id%TYPE;

1151: WHERE category_id = p_category_id
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;

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 1636: -- If there is a method_id in okl_amort_hold_setups then use it. Otherwise get method id

1632:
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;

Line 1950: -- If there is a method_id in okl_amort_hold_setups then use it. Otherwise get method id

1946:
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;

Line 2313: CURSOR l_amthld_csr(p_category_id okl_amort_hold_setups.category_id%TYPE,

2309:
2310:
2311: -- This cursor will return the hold period days and the default depreciation method from a hold period setup table
2312: -- using category_id and book_type_code.
2313: CURSOR l_amthld_csr(p_category_id okl_amort_hold_setups.category_id%TYPE,
2314: p_book_type_code okl_amort_hold_setups.book_type_code%TYPE) IS
2315: -- SECHAWLA 28-MAY-04 3645574 : Added deprn_rate
2316: SELECT hold_period_days, method_id, deprn_rate
2317: FROM okl_amort_hold_setups

Line 2314: p_book_type_code okl_amort_hold_setups.book_type_code%TYPE) IS

2310:
2311: -- This cursor will return the hold period days and the default depreciation method from a hold period setup table
2312: -- using category_id and book_type_code.
2313: CURSOR l_amthld_csr(p_category_id okl_amort_hold_setups.category_id%TYPE,
2314: p_book_type_code okl_amort_hold_setups.book_type_code%TYPE) IS
2315: -- SECHAWLA 28-MAY-04 3645574 : Added deprn_rate
2316: SELECT hold_period_days, method_id, deprn_rate
2317: FROM okl_amort_hold_setups
2318: WHERE category_id = p_category_id

Line 2317: FROM okl_amort_hold_setups

2313: CURSOR l_amthld_csr(p_category_id okl_amort_hold_setups.category_id%TYPE,
2314: p_book_type_code okl_amort_hold_setups.book_type_code%TYPE) IS
2315: -- SECHAWLA 28-MAY-04 3645574 : Added deprn_rate
2316: SELECT hold_period_days, method_id, deprn_rate
2317: FROM okl_amort_hold_setups
2318: WHERE category_id = p_category_id
2319: AND book_type_code = p_book_type_code;
2320:
2321: l_hold_period_days okl_amort_hold_setups.hold_period_days%TYPE;

Line 2321: l_hold_period_days okl_amort_hold_setups.hold_period_days%TYPE;

2317: FROM okl_amort_hold_setups
2318: WHERE category_id = p_category_id
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;

Line 2322: l_setup_method_id okl_amort_hold_setups.method_id%TYPE;

2318: WHERE category_id = p_category_id
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;

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 2781: -- If there is a method_id in okl_amort_hold_setups then use it. Otherwise get method id

2777:
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;

Line 3087: -- If there is a method_id in okl_amort_hold_setups then use it. Otherwise get method id

3083:
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;