815: *
816: ***********************************************************************/
817: IS
818: SELECT user_profile_option_name
819: FROM fnd_profile_options_vl
820: WHERE profile_option_name = p_option_name;
821:
822: CURSOR lcr_books (
823: p_book_type_code IN fa_books.book_type_code%TYPE
1133: ln_acc_deprn NUMBER;
1134: ln_first_elg_period NUMBER;
1135: ln_first_beg_period NUMBER;
1136: l_period fa_deprn_periods.period_name%TYPE;
1137: l_profile_option fnd_profile_options_vl.user_profile_option_name%TYPE;
1138: l_period_counter fa_deprn_periods.period_counter%TYPE;
1139: l_period_full_counter fa_deprn_periods.period_counter%TYPE;
1140: l_period_apr07_counter fa_deprn_periods.period_counter%TYPE;
1141: l_period_name fa_deprn_periods.period_name%TYPE;
1148: BEGIN
1149: --*****Check Profile Option*****************
1150: -- Get the Profile Option
1151: l_profile_tax_reform :=
1152: fnd_profile.VALUE ('FA_JAPAN_TAX_REFORMS');
1153:
1154: --Accumulated Depreciation
1155: BEGIN
1156: /* bug 8991192
1420: *
1421: ***********************************************************************/
1422: IS
1423: SELECT user_profile_option_name
1424: FROM fnd_profile_options_vl
1425: WHERE profile_option_name = p_option_name;
1426:
1427: CURSOR lcr_books (
1428: p_book_type_code IN fa_books.book_type_code%TYPE
1851: l_end_date_check DATE;
1852: l_extd_period_name VARCHAR2 (10);
1853: l_extended_date DATE;
1854: l_period fa_deprn_periods.period_name%TYPE;
1855: l_profile_option fnd_profile_options_vl.user_profile_option_name%TYPE;
1856: l_period_counter fa_deprn_periods.period_counter%TYPE;
1857: l_period_full_counter fa_deprn_periods.period_counter%TYPE;
1858: l_period_apr07_counter fa_deprn_periods.period_counter%TYPE;
1859: l_period_name fa_deprn_periods.period_name%TYPE;
1890: --*****Check Profile Option*****************
1891:
1892: -- Get the Profile Option
1893: l_profile_tax_reform :=
1894: fnd_profile.VALUE ('FA_JAPAN_TAX_REFORMS');
1895:
1896: SELECT period_name
1897: INTO lc_period
1898: FROM fa_deprn_periods
2634: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
2635: adj_err EXCEPTION;
2636: BEGIN
2637: IF x_book IS NOT NULL
2638: AND fnd_profile.VALUE ('FA_JAPAN_TAX_REFORMS') = 'Y'
2639: THEN
2640: h_cache :=
2641: fa_cache_pkg.fazccmt (x_method, x_life);
2642: lt_whatitf.DELETE;