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.FA_IMPAIRMENT_PREV_PVT dependencies on FA_CACHE_PKG

Line 4: g_print_debug boolean := fa_cache_pkg.fa_print_debug;

1: PACKAGE BODY FA_IMPAIRMENT_PREV_PVT AS
2: /* $Header: FAVIMPWB.pls 120.22.12020000.3 2013/03/29 11:32:34 saalampa ship $ */
3:
4: g_print_debug boolean := fa_cache_pkg.fa_print_debug;
5:
6: --
7: -- Datatypes for pl/sql tables below
8: --

Line 263: where cp.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar

259: select cp.period_num
260: , fy.fiscal_year
261: from fa_fiscal_year fy
262: , fa_calendar_periods cp
263: where cp.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
264: and fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
265: and cp.start_date between fy.start_date and fy.end_date
266: and c_start_date between cp.start_date and cp.end_date;
267:

Line 264: and fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name

260: , fy.fiscal_year
261: from fa_fiscal_year fy
262: , fa_calendar_periods cp
263: where cp.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
264: and fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
265: and cp.start_date between fy.start_date and fy.end_date
266: and c_start_date between cp.start_date and cp.end_date;
267:
268:

Line 629: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);

625: , p_calling_fn => l_calling_fn
626: , p_log_level_rec => p_log_level_rec) then
627: if (p_log_level_rec.statement_level) then
628: fa_debug_pkg.add(l_calling_fn, 'Error calling',
629: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
630: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
631: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);
632: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
633: fa_cache_pkg.fazcbc_record.fiscal_year_name, p_log_level_rec => p_log_level_rec);

Line 630: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',

626: , p_log_level_rec => p_log_level_rec) then
627: if (p_log_level_rec.statement_level) then
628: fa_debug_pkg.add(l_calling_fn, 'Error calling',
629: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
630: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
631: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);
632: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
633: fa_cache_pkg.fazcbc_record.fiscal_year_name, p_log_level_rec => p_log_level_rec);
634:

Line 631: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);

627: if (p_log_level_rec.statement_level) then
628: fa_debug_pkg.add(l_calling_fn, 'Error calling',
629: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
630: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
631: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);
632: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
633: fa_cache_pkg.fazcbc_record.fiscal_year_name, p_log_level_rec => p_log_level_rec);
634:
635: end if;

Line 632: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',

628: fa_debug_pkg.add(l_calling_fn, 'Error calling',
629: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
630: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
631: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);
632: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
633: fa_cache_pkg.fazcbc_record.fiscal_year_name, p_log_level_rec => p_log_level_rec);
634:
635: end if;
636:

Line 633: fa_cache_pkg.fazcbc_record.fiscal_year_name, p_log_level_rec => p_log_level_rec);

629: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
630: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
631: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);
632: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
633: fa_cache_pkg.fazcbc_record.fiscal_year_name, p_log_level_rec => p_log_level_rec);
634:
635: end if;
636:
637: raise dpr_err;

Line 653: l_dpr_in.calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;

649: -- Process periodic depreciation
650:
651: --+++++++ Populating l_dpr_in to call faxcde ++++++++++
652: l_dpr_in.asset_num := t_asset_number(i);
653: l_dpr_in.calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;
654: l_dpr_in.book := p_book_type_code;
655: l_dpr_in.asset_id := t_asset_id(i);
656:
657: l_dpr_row.asset_id := t_asset_id(i);

Line 776: if fa_cache_pkg.fa_deprn_override_enabled then

772: l_dpr_in.mrc_sob_type_code := p_mrc_sob_type_code; -- Bug 9700559
773: l_running_mode := fa_std_types.FA_DPR_NORMAL;
774:
775: -- manual override
776: if fa_cache_pkg.fa_deprn_override_enabled then
777: l_dpr_in.update_override_status := TRUE;
778: end if;
779:
780: if (p_log_level_rec.statement_level) then

Line 781: fa_debug_pkg.add(l_calling_fn, 'Calling', 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);

777: l_dpr_in.update_override_status := TRUE;
778: end if;
779:
780: if (p_log_level_rec.statement_level) then
781: fa_debug_pkg.add(l_calling_fn, 'Calling', 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
782: end if;
783:
784: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.prorate_calendar,
785: fa_cache_pkg.fazcbc_record.fiscal_year_name,

Line 784: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.prorate_calendar,

780: if (p_log_level_rec.statement_level) then
781: fa_debug_pkg.add(l_calling_fn, 'Calling', 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
782: end if;
783:
784: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.prorate_calendar,
785: fa_cache_pkg.fazcbc_record.fiscal_year_name,
786: l_dpr_in.prorate_jdate,
787: g_temp_number,
788: l_dpr_in.y_begin,

Line 785: fa_cache_pkg.fazcbc_record.fiscal_year_name,

781: fa_debug_pkg.add(l_calling_fn, 'Calling', 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
782: end if;
783:
784: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.prorate_calendar,
785: fa_cache_pkg.fazcbc_record.fiscal_year_name,
786: l_dpr_in.prorate_jdate,
787: g_temp_number,
788: l_dpr_in.y_begin,
789: g_temp_integer, p_log_level_rec => p_log_level_rec) then

Line 792: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);

788: l_dpr_in.y_begin,
789: g_temp_integer, p_log_level_rec => p_log_level_rec) then
790: if (p_log_level_rec.statement_level) then
791: fa_debug_pkg.add(l_calling_fn, 'Error calling',
792: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
793: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
794: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);
795: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
796: fa_cache_pkg.fazcbc_record.fiscal_year_name, p_log_level_rec => p_log_level_rec);

Line 793: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',

789: g_temp_integer, p_log_level_rec => p_log_level_rec) then
790: if (p_log_level_rec.statement_level) then
791: fa_debug_pkg.add(l_calling_fn, 'Error calling',
792: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
793: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
794: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);
795: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
796: fa_cache_pkg.fazcbc_record.fiscal_year_name, p_log_level_rec => p_log_level_rec);
797: end if;

Line 794: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);

790: if (p_log_level_rec.statement_level) then
791: fa_debug_pkg.add(l_calling_fn, 'Error calling',
792: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
793: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
794: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);
795: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
796: fa_cache_pkg.fazcbc_record.fiscal_year_name, p_log_level_rec => p_log_level_rec);
797: end if;
798:

Line 795: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',

791: fa_debug_pkg.add(l_calling_fn, 'Error calling',
792: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
793: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
794: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);
795: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
796: fa_cache_pkg.fazcbc_record.fiscal_year_name, p_log_level_rec => p_log_level_rec);
797: end if;
798:
799: raise dpr_err;

Line 796: fa_cache_pkg.fazcbc_record.fiscal_year_name, p_log_level_rec => p_log_level_rec);

792: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
793: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
794: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);
795: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
796: fa_cache_pkg.fazcbc_record.fiscal_year_name, p_log_level_rec => p_log_level_rec);
797: end if;
798:
799: raise dpr_err;
800: end if;

Line 802: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar, p_log_level_rec => p_log_level_rec) then

798:
799: raise dpr_err;
800: end if;
801:
802: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar, p_log_level_rec => p_log_level_rec) then
803: raise dpr_err;
804: end if;
805:
806: if (p_log_level_rec.statement_level) then

Line 831: l_pa_dpr_in.p_cl_end := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;

827: CLOSE c_get_period_rec;
828:
829: if (p_period_rec.period_num = 1) then
830: l_pa_dpr_in.y_end := p_period_rec.fiscal_year - 1;
831: l_pa_dpr_in.p_cl_end := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
832: else
833: l_pa_dpr_in.y_end := p_period_rec.fiscal_year;
834: l_pa_dpr_in.p_cl_end := p_period_rec.period_num - 1;
835: end if;

Line 981: fa_debug_pkg.add(l_calling_fn, 'Before Calling', 'fa_cache_pkg.fazccmt', p_log_level_rec => p_log_level_rec);

977: --
978: -- Store appropriate amount in eofy_reserve
979: --
980: if (p_log_level_rec.statement_level) then
981: fa_debug_pkg.add(l_calling_fn, 'Before Calling', 'fa_cache_pkg.fazccmt', p_log_level_rec => p_log_level_rec);
982: fa_debug_pkg.add(l_calling_fn, 'deprn_method_code', t_deprn_method_code(i));
983: fa_debug_pkg.add(l_calling_fn, 'life_in_months', t_life_in_months(i));
984: end if;
985:

Line 986: if (not fa_cache_pkg.fazccmt(

982: fa_debug_pkg.add(l_calling_fn, 'deprn_method_code', t_deprn_method_code(i));
983: fa_debug_pkg.add(l_calling_fn, 'life_in_months', t_life_in_months(i));
984: end if;
985:
986: if (not fa_cache_pkg.fazccmt(
987: t_deprn_method_code(i),
988: t_life_in_months(i),
989: p_log_level_rec)) then
990: if (p_log_level_rec.statement_level) then

Line 991: fa_debug_pkg.add(l_calling_fn, 'Error calling', 'fa_cache_pkg.fazccmt', p_log_level_rec => p_log_level_rec);

987: t_deprn_method_code(i),
988: t_life_in_months(i),
989: p_log_level_rec)) then
990: if (p_log_level_rec.statement_level) then
991: fa_debug_pkg.add(l_calling_fn, 'Error calling', 'fa_cache_pkg.fazccmt', p_log_level_rec => p_log_level_rec);
992: end if;
993:
994: raise dpr_err;
995: end if;

Line 998: fa_debug_pkg.add(l_calling_fn, 'rate_source_rule', fa_cache_pkg.fazccmt_record.rate_source_rule, p_log_level_rec => p_log_level_rec);

994: raise dpr_err;
995: end if;
996:
997: if (p_log_level_rec.statement_level) then
998: fa_debug_pkg.add(l_calling_fn, 'rate_source_rule', fa_cache_pkg.fazccmt_record.rate_source_rule, p_log_level_rec => p_log_level_rec);
999: fa_debug_pkg.add(l_calling_fn, 'deprn_basis_rule', fa_cache_pkg.fazccmt_record.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
1000: fa_debug_pkg.add(l_calling_fn, 'use_rsv_after_imp_flag', fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, p_log_level_rec => p_log_level_rec);
1001: end if;
1002:

Line 999: fa_debug_pkg.add(l_calling_fn, 'deprn_basis_rule', fa_cache_pkg.fazccmt_record.deprn_basis_rule, p_log_level_rec => p_log_level_rec);

995: end if;
996:
997: if (p_log_level_rec.statement_level) then
998: fa_debug_pkg.add(l_calling_fn, 'rate_source_rule', fa_cache_pkg.fazccmt_record.rate_source_rule, p_log_level_rec => p_log_level_rec);
999: fa_debug_pkg.add(l_calling_fn, 'deprn_basis_rule', fa_cache_pkg.fazccmt_record.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
1000: fa_debug_pkg.add(l_calling_fn, 'use_rsv_after_imp_flag', fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, p_log_level_rec => p_log_level_rec);
1001: end if;
1002:
1003: if (fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FLAT) and

Line 1000: fa_debug_pkg.add(l_calling_fn, 'use_rsv_after_imp_flag', fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, p_log_level_rec => p_log_level_rec);

996:
997: if (p_log_level_rec.statement_level) then
998: fa_debug_pkg.add(l_calling_fn, 'rate_source_rule', fa_cache_pkg.fazccmt_record.rate_source_rule, p_log_level_rec => p_log_level_rec);
999: fa_debug_pkg.add(l_calling_fn, 'deprn_basis_rule', fa_cache_pkg.fazccmt_record.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
1000: fa_debug_pkg.add(l_calling_fn, 'use_rsv_after_imp_flag', fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, p_log_level_rec => p_log_level_rec);
1001: end if;
1002:
1003: if (fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FLAT) and
1004: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_NBV) and

Line 1003: if (fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FLAT) and

999: fa_debug_pkg.add(l_calling_fn, 'deprn_basis_rule', fa_cache_pkg.fazccmt_record.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
1000: fa_debug_pkg.add(l_calling_fn, 'use_rsv_after_imp_flag', fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, p_log_level_rec => p_log_level_rec);
1001: end if;
1002:
1003: if (fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FLAT) and
1004: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_NBV) and
1005: (fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag = 'Y') then
1006: t_eofy_reserve(i) := nvl(l_dpr_out.new_deprn_rsv, 0);
1007: else

Line 1004: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_NBV) and

1000: fa_debug_pkg.add(l_calling_fn, 'use_rsv_after_imp_flag', fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, p_log_level_rec => p_log_level_rec);
1001: end if;
1002:
1003: if (fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FLAT) and
1004: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_NBV) and
1005: (fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag = 'Y') then
1006: t_eofy_reserve(i) := nvl(l_dpr_out.new_deprn_rsv, 0);
1007: else
1008: t_eofy_reserve(i) := nvl(l_dpr_out.new_eofy_reserve, 0);

Line 1005: (fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag = 'Y') then

1001: end if;
1002:
1003: if (fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FLAT) and
1004: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_NBV) and
1005: (fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag = 'Y') then
1006: t_eofy_reserve(i) := nvl(l_dpr_out.new_deprn_rsv, 0);
1007: else
1008: t_eofy_reserve(i) := nvl(l_dpr_out.new_eofy_reserve, 0);
1009: end if;

Line 1059: if not (fa_cache_pkg.fazccb (X_Book => p_book_type_code,

1055: --Bug#8614268 start
1056: if (p_log_level_rec.statement_level) then
1057: fa_debug_pkg.add(l_calling_fn,'Before checking impairments accts for category id',t_category_id(i), p_log_level_rec => p_log_level_rec);
1058: end if;
1059: if not (fa_cache_pkg.fazccb (X_Book => p_book_type_code,
1060: X_Cat_Id => t_category_id(i),
1061: p_log_level_rec => p_log_level_rec)) then
1062: if (p_log_level_rec.statement_level) then
1063: fa_debug_pkg.add(l_calling_fn,'Error Calling','fa_cache_pkg.fazccb', p_log_level_rec => p_log_level_rec);

Line 1063: fa_debug_pkg.add(l_calling_fn,'Error Calling','fa_cache_pkg.fazccb', p_log_level_rec => p_log_level_rec);

1059: if not (fa_cache_pkg.fazccb (X_Book => p_book_type_code,
1060: X_Cat_Id => t_category_id(i),
1061: p_log_level_rec => p_log_level_rec)) then
1062: if (p_log_level_rec.statement_level) then
1063: fa_debug_pkg.add(l_calling_fn,'Error Calling','fa_cache_pkg.fazccb', p_log_level_rec => p_log_level_rec);
1064: end if;
1065: raise dpr_err;
1066: end if;
1067: if ((fa_cache_pkg.fazccb_record.IMPAIR_EXPENSE_ACCT is null) OR

Line 1067: if ((fa_cache_pkg.fazccb_record.IMPAIR_EXPENSE_ACCT is null) OR

1063: fa_debug_pkg.add(l_calling_fn,'Error Calling','fa_cache_pkg.fazccb', p_log_level_rec => p_log_level_rec);
1064: end if;
1065: raise dpr_err;
1066: end if;
1067: if ((fa_cache_pkg.fazccb_record.IMPAIR_EXPENSE_ACCT is null) OR
1068: (fa_cache_pkg.fazccb_record.IMPAIR_RESERVE_ACCT is null)) then
1069: g_error_flag(i) := 1;
1070: else
1071: g_error_flag(i) := 0;

Line 1068: (fa_cache_pkg.fazccb_record.IMPAIR_RESERVE_ACCT is null)) then

1064: end if;
1065: raise dpr_err;
1066: end if;
1067: if ((fa_cache_pkg.fazccb_record.IMPAIR_EXPENSE_ACCT is null) OR
1068: (fa_cache_pkg.fazccb_record.IMPAIR_RESERVE_ACCT is null)) then
1069: g_error_flag(i) := 1;
1070: else
1071: g_error_flag(i) := 0;
1072: end if;

Line 1923: and fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name

1919: and inbk.asset_id = outbk.asset_id(+)
1920: and inbk.book_type_code = outbk.book_type_code(+)
1921: and inbk.transaction_header_id_in = th.transaction_header_id
1922: and inbk.transaction_header_id_in = outbk.transaction_header_id_out(+)
1923: and fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
1924: and ct.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
1925: and ct.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
1926: and cp.calendar_type = ct.calendar_type
1927: and cp.start_date between fy.start_date and fy.end_date

Line 1924: and ct.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name

1920: and inbk.book_type_code = outbk.book_type_code(+)
1921: and inbk.transaction_header_id_in = th.transaction_header_id
1922: and inbk.transaction_header_id_in = outbk.transaction_header_id_out(+)
1923: and fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
1924: and ct.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
1925: and ct.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
1926: and cp.calendar_type = ct.calendar_type
1927: and cp.start_date between fy.start_date and fy.end_date
1928: and fa_cache_pkg.fazcbc_record.last_period_counter + 1 >=

Line 1925: and ct.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar

1921: and inbk.transaction_header_id_in = th.transaction_header_id
1922: and inbk.transaction_header_id_in = outbk.transaction_header_id_out(+)
1923: and fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
1924: and ct.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
1925: and ct.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
1926: and cp.calendar_type = ct.calendar_type
1927: and cp.start_date between fy.start_date and fy.end_date
1928: and fa_cache_pkg.fazcbc_record.last_period_counter + 1 >=
1929: fy.fiscal_year * ct.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM

Line 1928: and fa_cache_pkg.fazcbc_record.last_period_counter + 1 >=

1924: and ct.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
1925: and ct.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
1926: and cp.calendar_type = ct.calendar_type
1927: and cp.start_date between fy.start_date and fy.end_date
1928: and fa_cache_pkg.fazcbc_record.last_period_counter + 1 >=
1929: fy.fiscal_year * ct.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM
1930: and (
1931: (
1932: th.transaction_type_code not in ('TRANSFER OUT', 'TRANSFER IN',

Line 2064: where ct.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar

2060: , 0 bonus_rate
2061: from fa_fiscal_year fy
2062: , fa_calendar_types ct
2063: , fa_calendar_periods cp
2064: where ct.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
2065: and fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
2066: and ct.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
2067: and ct.calendar_type = cp.calendar_type
2068: and cp.start_date between fy.start_date and fy.end_date

Line 2065: and fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name

2061: from fa_fiscal_year fy
2062: , fa_calendar_types ct
2063: , fa_calendar_periods cp
2064: where ct.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
2065: and fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
2066: and ct.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
2067: and ct.calendar_type = cp.calendar_type
2068: and cp.start_date between fy.start_date and fy.end_date
2069: and fa_cache_pkg.fazcbc_record.last_period_counter + 1 >=

Line 2066: and ct.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name

2062: , fa_calendar_types ct
2063: , fa_calendar_periods cp
2064: where ct.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
2065: and fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
2066: and ct.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
2067: and ct.calendar_type = cp.calendar_type
2068: and cp.start_date between fy.start_date and fy.end_date
2069: and fa_cache_pkg.fazcbc_record.last_period_counter + 1 >=
2070: fy.fiscal_year * ct.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM

Line 2069: and fa_cache_pkg.fazcbc_record.last_period_counter + 1 >=

2065: and fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
2066: and ct.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
2067: and ct.calendar_type = cp.calendar_type
2068: and cp.start_date between fy.start_date and fy.end_date
2069: and fa_cache_pkg.fazcbc_record.last_period_counter + 1 >=
2070: fy.fiscal_year * ct.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM
2071: and cp.end_date >= p_date_placed_in_service
2072: order by period_counter;
2073:

Line 2455: l_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;

2451:
2452: l_asset_hdr_rec.asset_id := p_asset_id;
2453: l_asset_hdr_rec.period_of_addition := null;
2454: l_asset_hdr_rec.book_type_code := p_book_type_code;
2455: l_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
2456:
2457: l_dpr_in.calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;
2458: l_dpr_in.book := l_asset_hdr_rec.book_type_code;
2459: l_dpr_in.asset_id := l_asset_hdr_rec.asset_id;

Line 2457: l_dpr_in.calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;

2453: l_asset_hdr_rec.period_of_addition := null;
2454: l_asset_hdr_rec.book_type_code := p_book_type_code;
2455: l_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
2456:
2457: l_dpr_in.calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;
2458: l_dpr_in.book := l_asset_hdr_rec.book_type_code;
2459: l_dpr_in.asset_id := l_asset_hdr_rec.asset_id;
2460:
2461: if (p_log_level_rec.statement_level) then

Line 2745: fa_debug_pkg.add(l_calling_fn, 'Before Calling', 'fa_cache_pkg.fazccmt', p_log_level_rec => p_log_level_rec);

2741: l_dpr_in.deprn_start_jdate := to_number(to_char(l_asset_fin_rec_old.deprn_start_date, 'J'));
2742: l_dpr_in.prorate_jdate := to_number(to_char(l_asset_fin_rec_old.prorate_date, 'J'));
2743:
2744: if (p_log_level_rec.statement_level) then
2745: fa_debug_pkg.add(l_calling_fn, 'Before Calling', 'fa_cache_pkg.fazccmt', p_log_level_rec => p_log_level_rec);
2746: end if;
2747:
2748: if (not fa_cache_pkg.fazccmt(
2749: fa_amort_pvt.t_deprn_method_code(i),

Line 2748: if (not fa_cache_pkg.fazccmt(

2744: if (p_log_level_rec.statement_level) then
2745: fa_debug_pkg.add(l_calling_fn, 'Before Calling', 'fa_cache_pkg.fazccmt', p_log_level_rec => p_log_level_rec);
2746: end if;
2747:
2748: if (not fa_cache_pkg.fazccmt(
2749: fa_amort_pvt.t_deprn_method_code(i),
2750: fa_amort_pvt.t_life_in_months(i),
2751: p_log_level_rec)) then
2752: if (p_log_level_rec.statement_level) then

Line 2753: fa_debug_pkg.add(l_calling_fn, 'Error calling', 'fa_cache_pkg.fazccmt', p_log_level_rec => p_log_level_rec);

2749: fa_amort_pvt.t_deprn_method_code(i),
2750: fa_amort_pvt.t_life_in_months(i),
2751: p_log_level_rec)) then
2752: if (p_log_level_rec.statement_level) then
2753: fa_debug_pkg.add(l_calling_fn, 'Error calling', 'fa_cache_pkg.fazccmt', p_log_level_rec => p_log_level_rec);
2754: end if;
2755:
2756: raise pro_err;
2757: end if;

Line 2761: fa_debug_pkg.add(l_calling_fn, 'Before Calling', 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);

2757: end if;
2758:
2759: if i = 1 then
2760: if (p_log_level_rec.statement_level) then
2761: fa_debug_pkg.add(l_calling_fn, 'Before Calling', 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
2762: end if;
2763:
2764: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.prorate_calendar,
2765: fa_cache_pkg.fazcbc_record.fiscal_year_name,

Line 2764: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.prorate_calendar,

2760: if (p_log_level_rec.statement_level) then
2761: fa_debug_pkg.add(l_calling_fn, 'Before Calling', 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
2762: end if;
2763:
2764: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.prorate_calendar,
2765: fa_cache_pkg.fazcbc_record.fiscal_year_name,
2766: l_dpr_in.prorate_jdate,
2767: g_temp_number,
2768: l_dpr_in.y_begin,

Line 2765: fa_cache_pkg.fazcbc_record.fiscal_year_name,

2761: fa_debug_pkg.add(l_calling_fn, 'Before Calling', 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
2762: end if;
2763:
2764: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.prorate_calendar,
2765: fa_cache_pkg.fazcbc_record.fiscal_year_name,
2766: l_dpr_in.prorate_jdate,
2767: g_temp_number,
2768: l_dpr_in.y_begin,
2769: g_temp_integer, p_log_level_rec => p_log_level_rec) then

Line 2772: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);

2768: l_dpr_in.y_begin,
2769: g_temp_integer, p_log_level_rec => p_log_level_rec) then
2770: if (p_log_level_rec.statement_level) then
2771: fa_debug_pkg.add(l_calling_fn, 'Error calling',
2772: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
2773: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
2774: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);
2775: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
2776: fa_cache_pkg.fazcbc_record.fiscal_year_name, p_log_level_rec => p_log_level_rec);

Line 2773: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',

2769: g_temp_integer, p_log_level_rec => p_log_level_rec) then
2770: if (p_log_level_rec.statement_level) then
2771: fa_debug_pkg.add(l_calling_fn, 'Error calling',
2772: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
2773: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
2774: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);
2775: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
2776: fa_cache_pkg.fazcbc_record.fiscal_year_name, p_log_level_rec => p_log_level_rec);
2777: fa_debug_pkg.add(l_calling_fn, 'l_dpr_in.prorate_jdate',

Line 2774: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);

2770: if (p_log_level_rec.statement_level) then
2771: fa_debug_pkg.add(l_calling_fn, 'Error calling',
2772: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
2773: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
2774: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);
2775: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
2776: fa_cache_pkg.fazcbc_record.fiscal_year_name, p_log_level_rec => p_log_level_rec);
2777: fa_debug_pkg.add(l_calling_fn, 'l_dpr_in.prorate_jdate',
2778: l_dpr_in.prorate_jdate, p_log_level_rec => p_log_level_rec);

Line 2775: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',

2771: fa_debug_pkg.add(l_calling_fn, 'Error calling',
2772: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
2773: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
2774: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);
2775: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
2776: fa_cache_pkg.fazcbc_record.fiscal_year_name, p_log_level_rec => p_log_level_rec);
2777: fa_debug_pkg.add(l_calling_fn, 'l_dpr_in.prorate_jdate',
2778: l_dpr_in.prorate_jdate, p_log_level_rec => p_log_level_rec);
2779:

Line 2776: fa_cache_pkg.fazcbc_record.fiscal_year_name, p_log_level_rec => p_log_level_rec);

2772: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
2773: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
2774: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);
2775: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
2776: fa_cache_pkg.fazcbc_record.fiscal_year_name, p_log_level_rec => p_log_level_rec);
2777: fa_debug_pkg.add(l_calling_fn, 'l_dpr_in.prorate_jdate',
2778: l_dpr_in.prorate_jdate, p_log_level_rec => p_log_level_rec);
2779:
2780: end if;

Line 2792: if (((nvl(fa_cache_pkg.fazccmt_record.rate_source_rule, ' ') not in(fa_std_types.FAD_RSR_FLAT,

2788: fa_debug_pkg.add(l_calling_fn, 'Before Calling', 'faxcde for hype reserve', p_log_level_rec => p_log_level_rec);
2789: end if;
2790:
2791: -- Skip faxcde call to find hyp rsv if method type is not (FLAT or PROD) and basis is COST
2792: if (((nvl(fa_cache_pkg.fazccmt_record.rate_source_rule, ' ') not in(fa_std_types.FAD_RSR_FLAT,
2793: fa_std_types.FAD_RSR_PROD)) and
2794: (nvl(fa_cache_pkg.fazccmt_record.deprn_basis_rule,' ') = fa_std_types.FAD_DBR_COST))) then
2795:
2796: -- bug5894464

Line 2794: (nvl(fa_cache_pkg.fazccmt_record.deprn_basis_rule,' ') = fa_std_types.FAD_DBR_COST))) then

2790:
2791: -- Skip faxcde call to find hyp rsv if method type is not (FLAT or PROD) and basis is COST
2792: if (((nvl(fa_cache_pkg.fazccmt_record.rate_source_rule, ' ') not in(fa_std_types.FAD_RSR_FLAT,
2793: fa_std_types.FAD_RSR_PROD)) and
2794: (nvl(fa_cache_pkg.fazccmt_record.deprn_basis_rule,' ') = fa_std_types.FAD_DBR_COST))) then
2795:
2796: -- bug5894464
2797: l_dpr_in.p_cl_begin := 1;
2798:

Line 2801: l_dpr_in.p_cl_end := fa_cache_pkg.fazcct_record.number_per_fiscal_year;

2797: l_dpr_in.p_cl_begin := 1;
2798:
2799: if (fa_amort_pvt.t_period_num(i) = 1) then
2800: l_dpr_in.y_end := fa_amort_pvt.t_fiscal_year(i) - 1;
2801: l_dpr_in.p_cl_end := fa_cache_pkg.fazcct_record.number_per_fiscal_year;
2802: else
2803: l_dpr_in.y_end := fa_amort_pvt.t_fiscal_year(i);
2804: l_dpr_in.p_cl_end := fa_amort_pvt.t_period_num(i) - 1;
2805: end if;

Line 2820: end if; -- (((nvl(fa_cache_pkg.fazccmt_record.rate_source_rule, ' ') not in(fa_std_types.FAD_RSR_FLAT,

2816: end if;
2817:
2818: raise pro_err;
2819: end if;
2820: end if; -- (((nvl(fa_cache_pkg.fazccmt_record.rate_source_rule, ' ') not in(fa_std_types.FAD_RSR_FLAT,
2821:
2822: l_period_rec.period_counter := fa_amort_pvt.t_period_counter(i);
2823: l_period_rec.period_num := fa_amort_pvt.t_period_num(i);
2824: l_period_rec.fiscal_year := fa_amort_pvt.t_fiscal_year(i);

Line 2838: fa_debug_pkg.add(l_calling_fn, 'rule_name', fa_cache_pkg.fazcdbr_record.rule_name, p_log_level_rec => p_log_level_rec);

2834: -- depreciable basis will not use actual eofy_reserve
2835:
2836: if (p_log_level_rec.statement_level) then
2837: fa_debug_pkg.add(l_calling_fn, 'fa_amort_pvt.t_impairment_amount(i)', fa_amort_pvt.t_impairment_amount(i));
2838: fa_debug_pkg.add(l_calling_fn, 'rule_name', fa_cache_pkg.fazcdbr_record.rule_name, p_log_level_rec => p_log_level_rec);
2839: fa_debug_pkg.add(l_calling_fn, 'deprn_basis_rule', fa_cache_pkg.fazccmt_record.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
2840: fa_debug_pkg.add(l_calling_fn, 'use_rsv_after_imp_flag', fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, p_log_level_rec => p_log_level_rec);
2841: end if;
2842:

Line 2839: fa_debug_pkg.add(l_calling_fn, 'deprn_basis_rule', fa_cache_pkg.fazccmt_record.deprn_basis_rule, p_log_level_rec => p_log_level_rec);

2835:
2836: if (p_log_level_rec.statement_level) then
2837: fa_debug_pkg.add(l_calling_fn, 'fa_amort_pvt.t_impairment_amount(i)', fa_amort_pvt.t_impairment_amount(i));
2838: fa_debug_pkg.add(l_calling_fn, 'rule_name', fa_cache_pkg.fazcdbr_record.rule_name, p_log_level_rec => p_log_level_rec);
2839: fa_debug_pkg.add(l_calling_fn, 'deprn_basis_rule', fa_cache_pkg.fazccmt_record.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
2840: fa_debug_pkg.add(l_calling_fn, 'use_rsv_after_imp_flag', fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, p_log_level_rec => p_log_level_rec);
2841: end if;
2842:
2843: if (i > 1) and (fa_amort_pvt.t_impairment_amount(i-1) <> 0) and

Line 2840: fa_debug_pkg.add(l_calling_fn, 'use_rsv_after_imp_flag', fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, p_log_level_rec => p_log_level_rec);

2836: if (p_log_level_rec.statement_level) then
2837: fa_debug_pkg.add(l_calling_fn, 'fa_amort_pvt.t_impairment_amount(i)', fa_amort_pvt.t_impairment_amount(i));
2838: fa_debug_pkg.add(l_calling_fn, 'rule_name', fa_cache_pkg.fazcdbr_record.rule_name, p_log_level_rec => p_log_level_rec);
2839: fa_debug_pkg.add(l_calling_fn, 'deprn_basis_rule', fa_cache_pkg.fazccmt_record.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
2840: fa_debug_pkg.add(l_calling_fn, 'use_rsv_after_imp_flag', fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, p_log_level_rec => p_log_level_rec);
2841: end if;
2842:
2843: if (i > 1) and (fa_amort_pvt.t_impairment_amount(i-1) <> 0) and
2844: (fa_cache_pkg.fazcdbr_record.rule_name = 'FLAT RATE EXTENSION') and

Line 2844: (fa_cache_pkg.fazcdbr_record.rule_name = 'FLAT RATE EXTENSION') and

2840: fa_debug_pkg.add(l_calling_fn, 'use_rsv_after_imp_flag', fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, p_log_level_rec => p_log_level_rec);
2841: end if;
2842:
2843: if (i > 1) and (fa_amort_pvt.t_impairment_amount(i-1) <> 0) and
2844: (fa_cache_pkg.fazcdbr_record.rule_name = 'FLAT RATE EXTENSION') and
2845: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_NBV) and
2846: (nvl(fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, 'N') = 'Y') then
2847:
2848: l_asset_fin_rec_new.eofy_reserve := fa_amort_pvt.t_deprn_reserve(i-1) +

Line 2845: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_NBV) and

2841: end if;
2842:
2843: if (i > 1) and (fa_amort_pvt.t_impairment_amount(i-1) <> 0) and
2844: (fa_cache_pkg.fazcdbr_record.rule_name = 'FLAT RATE EXTENSION') and
2845: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_NBV) and
2846: (nvl(fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, 'N') = 'Y') then
2847:
2848: l_asset_fin_rec_new.eofy_reserve := fa_amort_pvt.t_deprn_reserve(i-1) +
2849: nvl(fa_amort_pvt.t_change_in_eofy_reserve(i), 0);

Line 2846: (nvl(fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, 'N') = 'Y') then

2842:
2843: if (i > 1) and (fa_amort_pvt.t_impairment_amount(i-1) <> 0) and
2844: (fa_cache_pkg.fazcdbr_record.rule_name = 'FLAT RATE EXTENSION') and
2845: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_NBV) and
2846: (nvl(fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, 'N') = 'Y') then
2847:
2848: l_asset_fin_rec_new.eofy_reserve := fa_amort_pvt.t_deprn_reserve(i-1) +
2849: nvl(fa_amort_pvt.t_change_in_eofy_reserve(i), 0);
2850: fa_amort_pvt.t_eofy_reserve(i-1) := l_asset_fin_rec_new.eofy_reserve;

Line 3526: l_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;

3522:
3523: l_asset_hdr_rec.asset_id := t_asset_id(j);
3524: l_asset_hdr_rec.period_of_addition := null;
3525: l_asset_hdr_rec.book_type_code := p_book_type_code;
3526: l_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
3527:
3528: l_dpr_in.calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;
3529: l_dpr_in.book := l_asset_hdr_rec.book_type_code;
3530: l_dpr_in.asset_id := l_asset_hdr_rec.asset_id;

Line 3528: l_dpr_in.calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;

3524: l_asset_hdr_rec.period_of_addition := null;
3525: l_asset_hdr_rec.book_type_code := p_book_type_code;
3526: l_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
3527:
3528: l_dpr_in.calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;
3529: l_dpr_in.book := l_asset_hdr_rec.book_type_code;
3530: l_dpr_in.asset_id := l_asset_hdr_rec.asset_id;
3531:
3532: if (p_log_level_rec.statement_level) then

Line 3685: fa_debug_pkg.add(l_calling_fn, 'Before Calling', 'fa_cache_pkg.fazccmt', p_log_level_rec => p_log_level_rec);

3681: l_dpr_in.deprn_start_jdate := to_number(to_char(l_asset_fin_rec_old.deprn_start_date, 'J'));
3682: l_dpr_in.prorate_jdate := to_number(to_char(l_asset_fin_rec_old.prorate_date, 'J'));
3683:
3684: if (p_log_level_rec.statement_level) then
3685: fa_debug_pkg.add(l_calling_fn, 'Before Calling', 'fa_cache_pkg.fazccmt', p_log_level_rec => p_log_level_rec);
3686: end if;
3687:
3688: if (not fa_cache_pkg.fazccmt(
3689: fa_amort_pvt.t_deprn_method_code(i),

Line 3688: if (not fa_cache_pkg.fazccmt(

3684: if (p_log_level_rec.statement_level) then
3685: fa_debug_pkg.add(l_calling_fn, 'Before Calling', 'fa_cache_pkg.fazccmt', p_log_level_rec => p_log_level_rec);
3686: end if;
3687:
3688: if (not fa_cache_pkg.fazccmt(
3689: fa_amort_pvt.t_deprn_method_code(i),
3690: fa_amort_pvt.t_life_in_months(i),
3691: p_log_level_rec)) then
3692: if (p_log_level_rec.statement_level) then

Line 3693: fa_debug_pkg.add(l_calling_fn, 'Error calling', 'fa_cache_pkg.fazccmt', p_log_level_rec => p_log_level_rec);

3689: fa_amort_pvt.t_deprn_method_code(i),
3690: fa_amort_pvt.t_life_in_months(i),
3691: p_log_level_rec)) then
3692: if (p_log_level_rec.statement_level) then
3693: fa_debug_pkg.add(l_calling_fn, 'Error calling', 'fa_cache_pkg.fazccmt', p_log_level_rec => p_log_level_rec);
3694: end if;
3695:
3696: raise calc_err;
3697: end if;

Line 3700: fa_debug_pkg.add(l_calling_fn, 'Before Calling', 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);

3696: raise calc_err;
3697: end if;
3698:
3699: if (p_log_level_rec.statement_level) then
3700: fa_debug_pkg.add(l_calling_fn, 'Before Calling', 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
3701: end if;
3702:
3703: -- bug5894464: removed if (i = 1) condition
3704: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.prorate_calendar,

Line 3704: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.prorate_calendar,

3700: fa_debug_pkg.add(l_calling_fn, 'Before Calling', 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
3701: end if;
3702:
3703: -- bug5894464: removed if (i = 1) condition
3704: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.prorate_calendar,
3705: fa_cache_pkg.fazcbc_record.fiscal_year_name,
3706: l_dpr_in.prorate_jdate,
3707: g_temp_number,
3708: l_dpr_in.y_begin,

Line 3705: fa_cache_pkg.fazcbc_record.fiscal_year_name,

3701: end if;
3702:
3703: -- bug5894464: removed if (i = 1) condition
3704: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.prorate_calendar,
3705: fa_cache_pkg.fazcbc_record.fiscal_year_name,
3706: l_dpr_in.prorate_jdate,
3707: g_temp_number,
3708: l_dpr_in.y_begin,
3709: g_temp_integer, p_log_level_rec => p_log_level_rec) then

Line 3712: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);

3708: l_dpr_in.y_begin,
3709: g_temp_integer, p_log_level_rec => p_log_level_rec) then
3710: if (p_log_level_rec.statement_level) then
3711: fa_debug_pkg.add(l_calling_fn, 'Error calling',
3712: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
3713: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
3714: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);
3715: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
3716: fa_cache_pkg.fazcbc_record.fiscal_year_name, p_log_level_rec => p_log_level_rec);

Line 3713: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',

3709: g_temp_integer, p_log_level_rec => p_log_level_rec) then
3710: if (p_log_level_rec.statement_level) then
3711: fa_debug_pkg.add(l_calling_fn, 'Error calling',
3712: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
3713: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
3714: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);
3715: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
3716: fa_cache_pkg.fazcbc_record.fiscal_year_name, p_log_level_rec => p_log_level_rec);
3717: fa_debug_pkg.add(l_calling_fn, 'l_dpr_in.prorate_jdate',

Line 3714: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);

3710: if (p_log_level_rec.statement_level) then
3711: fa_debug_pkg.add(l_calling_fn, 'Error calling',
3712: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
3713: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
3714: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);
3715: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
3716: fa_cache_pkg.fazcbc_record.fiscal_year_name, p_log_level_rec => p_log_level_rec);
3717: fa_debug_pkg.add(l_calling_fn, 'l_dpr_in.prorate_jdate',
3718: l_dpr_in.prorate_jdate, p_log_level_rec => p_log_level_rec);

Line 3715: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',

3711: fa_debug_pkg.add(l_calling_fn, 'Error calling',
3712: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
3713: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
3714: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);
3715: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
3716: fa_cache_pkg.fazcbc_record.fiscal_year_name, p_log_level_rec => p_log_level_rec);
3717: fa_debug_pkg.add(l_calling_fn, 'l_dpr_in.prorate_jdate',
3718: l_dpr_in.prorate_jdate, p_log_level_rec => p_log_level_rec);
3719:

Line 3716: fa_cache_pkg.fazcbc_record.fiscal_year_name, p_log_level_rec => p_log_level_rec);

3712: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
3713: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
3714: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);
3715: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
3716: fa_cache_pkg.fazcbc_record.fiscal_year_name, p_log_level_rec => p_log_level_rec);
3717: fa_debug_pkg.add(l_calling_fn, 'l_dpr_in.prorate_jdate',
3718: l_dpr_in.prorate_jdate, p_log_level_rec => p_log_level_rec);
3719:
3720: end if;

Line 3732: if (((nvl(fa_cache_pkg.fazccmt_record.rate_source_rule, ' ') not in(fa_std_types.FAD_RSR_FLAT,

3728: fa_debug_pkg.add(l_calling_fn, 'Before Calling', 'faxcde for hype reserve', p_log_level_rec => p_log_level_rec);
3729: end if;
3730:
3731: -- Skip faxcde call to find hyp rsv if method type is not (FLAT or PROD) and basis is COST
3732: if (((nvl(fa_cache_pkg.fazccmt_record.rate_source_rule, ' ') not in(fa_std_types.FAD_RSR_FLAT,
3733: fa_std_types.FAD_RSR_PROD)) and
3734: (nvl(fa_cache_pkg.fazccmt_record.deprn_basis_rule,' ') = fa_std_types.FAD_DBR_COST))) then
3735:
3736: -- bug5894464

Line 3734: (nvl(fa_cache_pkg.fazccmt_record.deprn_basis_rule,' ') = fa_std_types.FAD_DBR_COST))) then

3730:
3731: -- Skip faxcde call to find hyp rsv if method type is not (FLAT or PROD) and basis is COST
3732: if (((nvl(fa_cache_pkg.fazccmt_record.rate_source_rule, ' ') not in(fa_std_types.FAD_RSR_FLAT,
3733: fa_std_types.FAD_RSR_PROD)) and
3734: (nvl(fa_cache_pkg.fazccmt_record.deprn_basis_rule,' ') = fa_std_types.FAD_DBR_COST))) then
3735:
3736: -- bug5894464
3737: l_dpr_in.p_cl_begin := 1;
3738:

Line 3741: l_dpr_in.p_cl_end := fa_cache_pkg.fazcct_record.number_per_fiscal_year;

3737: l_dpr_in.p_cl_begin := 1;
3738:
3739: if (fa_amort_pvt.t_period_num(i) = 1) then
3740: l_dpr_in.y_end := fa_amort_pvt.t_fiscal_year(i) - 1;
3741: l_dpr_in.p_cl_end := fa_cache_pkg.fazcct_record.number_per_fiscal_year;
3742: else
3743: l_dpr_in.y_end := fa_amort_pvt.t_fiscal_year(i);
3744: l_dpr_in.p_cl_end := fa_amort_pvt.t_period_num(i) - 1;
3745: end if;

Line 3760: end if; -- (((nvl(fa_cache_pkg.fazccmt_record.rate_source_rule, ' ') not in(fa_std_types.FAD_RSR_FLAT,

3756: end if;
3757:
3758: raise calc_err;
3759: end if;
3760: end if; -- (((nvl(fa_cache_pkg.fazccmt_record.rate_source_rule, ' ') not in(fa_std_types.FAD_RSR_FLAT,
3761:
3762: if (p_log_level_rec.statement_level) then
3763: fa_debug_pkg.add(l_calling_fn, 'setting', 'deprn_rec for basis rule', p_log_level_rec => p_log_level_rec);
3764: end if;

Line 3790: if (nvl(fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, 'Y') = 'Y') and

3786: l_asset_deprn_rec.ytd_impairment := fa_amort_pvt.t_ytd_impairment(i);
3787:
3788: l_asset_deprn_rec.impairment_reserve := fa_amort_pvt.t_impairment_reserve(i);
3789:
3790: if (nvl(fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, 'Y') = 'Y') and
3791: (nvl(fa_cache_pkg.fazccmt_record.rate_source_rule, ' ') = fa_std_types.FAD_RSR_FLAT) and
3792: (nvl(fa_cache_pkg.fazccmt_record.deprn_basis_rule,' ') = fa_std_types.FAD_DBR_COST) then
3793: l_asset_deprn_rec.impairment_reserve := fa_amort_pvt.t_impairment_reserve(i) + fa_amort_pvt.t_deprn_reserve(1);
3794: end if;

Line 3791: (nvl(fa_cache_pkg.fazccmt_record.rate_source_rule, ' ') = fa_std_types.FAD_RSR_FLAT) and

3787:
3788: l_asset_deprn_rec.impairment_reserve := fa_amort_pvt.t_impairment_reserve(i);
3789:
3790: if (nvl(fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, 'Y') = 'Y') and
3791: (nvl(fa_cache_pkg.fazccmt_record.rate_source_rule, ' ') = fa_std_types.FAD_RSR_FLAT) and
3792: (nvl(fa_cache_pkg.fazccmt_record.deprn_basis_rule,' ') = fa_std_types.FAD_DBR_COST) then
3793: l_asset_deprn_rec.impairment_reserve := fa_amort_pvt.t_impairment_reserve(i) + fa_amort_pvt.t_deprn_reserve(1);
3794: end if;
3795:

Line 3792: (nvl(fa_cache_pkg.fazccmt_record.deprn_basis_rule,' ') = fa_std_types.FAD_DBR_COST) then

3788: l_asset_deprn_rec.impairment_reserve := fa_amort_pvt.t_impairment_reserve(i);
3789:
3790: if (nvl(fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, 'Y') = 'Y') and
3791: (nvl(fa_cache_pkg.fazccmt_record.rate_source_rule, ' ') = fa_std_types.FAD_RSR_FLAT) and
3792: (nvl(fa_cache_pkg.fazccmt_record.deprn_basis_rule,' ') = fa_std_types.FAD_DBR_COST) then
3793: l_asset_deprn_rec.impairment_reserve := fa_amort_pvt.t_impairment_reserve(i) + fa_amort_pvt.t_deprn_reserve(1);
3794: end if;
3795:
3796:

Line 3808: fa_debug_pkg.add(l_calling_fn, 'rule_name', fa_cache_pkg.fazcdbr_record.rule_name, p_log_level_rec => p_log_level_rec);

3804: end if;
3805:
3806: if (p_log_level_rec.statement_level) then
3807: fa_debug_pkg.add(l_calling_fn, 'fa_amort_pvt.t_impairment_amount(i)', fa_amort_pvt.t_impairment_amount(i));
3808: fa_debug_pkg.add(l_calling_fn, 'rule_name', fa_cache_pkg.fazcdbr_record.rule_name, p_log_level_rec => p_log_level_rec);
3809: fa_debug_pkg.add(l_calling_fn, 'deprn_basis_rule', fa_cache_pkg.fazccmt_record.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
3810: fa_debug_pkg.add(l_calling_fn, 'use_rsv_after_imp_flag', fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, p_log_level_rec => p_log_level_rec);
3811: end if;
3812:

Line 3809: fa_debug_pkg.add(l_calling_fn, 'deprn_basis_rule', fa_cache_pkg.fazccmt_record.deprn_basis_rule, p_log_level_rec => p_log_level_rec);

3805:
3806: if (p_log_level_rec.statement_level) then
3807: fa_debug_pkg.add(l_calling_fn, 'fa_amort_pvt.t_impairment_amount(i)', fa_amort_pvt.t_impairment_amount(i));
3808: fa_debug_pkg.add(l_calling_fn, 'rule_name', fa_cache_pkg.fazcdbr_record.rule_name, p_log_level_rec => p_log_level_rec);
3809: fa_debug_pkg.add(l_calling_fn, 'deprn_basis_rule', fa_cache_pkg.fazccmt_record.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
3810: fa_debug_pkg.add(l_calling_fn, 'use_rsv_after_imp_flag', fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, p_log_level_rec => p_log_level_rec);
3811: end if;
3812:
3813: if (i > 1) and (fa_amort_pvt.t_impairment_amount(i-1) <> 0) and

Line 3810: fa_debug_pkg.add(l_calling_fn, 'use_rsv_after_imp_flag', fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, p_log_level_rec => p_log_level_rec);

3806: if (p_log_level_rec.statement_level) then
3807: fa_debug_pkg.add(l_calling_fn, 'fa_amort_pvt.t_impairment_amount(i)', fa_amort_pvt.t_impairment_amount(i));
3808: fa_debug_pkg.add(l_calling_fn, 'rule_name', fa_cache_pkg.fazcdbr_record.rule_name, p_log_level_rec => p_log_level_rec);
3809: fa_debug_pkg.add(l_calling_fn, 'deprn_basis_rule', fa_cache_pkg.fazccmt_record.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
3810: fa_debug_pkg.add(l_calling_fn, 'use_rsv_after_imp_flag', fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, p_log_level_rec => p_log_level_rec);
3811: end if;
3812:
3813: if (i > 1) and (fa_amort_pvt.t_impairment_amount(i-1) <> 0) and
3814: (fa_cache_pkg.fazcdbr_record.rule_name = 'FLAT RATE EXTENSION') and

Line 3814: (fa_cache_pkg.fazcdbr_record.rule_name = 'FLAT RATE EXTENSION') and

3810: fa_debug_pkg.add(l_calling_fn, 'use_rsv_after_imp_flag', fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, p_log_level_rec => p_log_level_rec);
3811: end if;
3812:
3813: if (i > 1) and (fa_amort_pvt.t_impairment_amount(i-1) <> 0) and
3814: (fa_cache_pkg.fazcdbr_record.rule_name = 'FLAT RATE EXTENSION') and
3815: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_NBV) and
3816: (nvl(fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, 'N') = 'Y') then
3817:
3818: l_asset_fin_rec_new.eofy_reserve := fa_amort_pvt.t_deprn_reserve(i-1) +

Line 3815: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_NBV) and

3811: end if;
3812:
3813: if (i > 1) and (fa_amort_pvt.t_impairment_amount(i-1) <> 0) and
3814: (fa_cache_pkg.fazcdbr_record.rule_name = 'FLAT RATE EXTENSION') and
3815: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_NBV) and
3816: (nvl(fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, 'N') = 'Y') then
3817:
3818: l_asset_fin_rec_new.eofy_reserve := fa_amort_pvt.t_deprn_reserve(i-1) +
3819: nvl(fa_amort_pvt.t_change_in_eofy_reserve(i), 0);

Line 3816: (nvl(fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, 'N') = 'Y') then

3812:
3813: if (i > 1) and (fa_amort_pvt.t_impairment_amount(i-1) <> 0) and
3814: (fa_cache_pkg.fazcdbr_record.rule_name = 'FLAT RATE EXTENSION') and
3815: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_NBV) and
3816: (nvl(fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, 'N') = 'Y') then
3817:
3818: l_asset_fin_rec_new.eofy_reserve := fa_amort_pvt.t_deprn_reserve(i-1) +
3819: nvl(fa_amort_pvt.t_change_in_eofy_reserve(i), 0);
3820: fa_amort_pvt.t_eofy_reserve(i-1) := l_asset_fin_rec_new.eofy_reserve;