DBA Data[Home] [Help]

APPS.FA_IMPAIRMENT_POST_PVT dependencies on FA_CACHE_PKG

Line 4: g_print_debug boolean := fa_cache_pkg.fa_print_debug;

1: PACKAGE BODY FA_IMPAIRMENT_POST_PVT AS
2: /* $Header: FAVIMPTB.pls 120.25.12020000.3 2013/03/29 11:34:22 saalampa ship $ */
3:
4: g_print_debug boolean := fa_cache_pkg.fa_print_debug;
5: g_release number := fa_cache_pkg.fazarel_release;
6:
7: --
8: -- Datatypes for pl/sql tables below

Line 5: g_release number := fa_cache_pkg.fazarel_release;

1: PACKAGE BODY FA_IMPAIRMENT_POST_PVT AS
2: /* $Header: FAVIMPTB.pls 120.25.12020000.3 2013/03/29 11:34:22 saalampa ship $ */
3:
4: g_print_debug boolean := fa_cache_pkg.fa_print_debug;
5: g_release number := fa_cache_pkg.fazarel_release;
6:
7: --
8: -- Datatypes for pl/sql tables below
9: --

Line 862: if not fa_cache_pkg.fazccb(p_book_type_code,

858: p_date_effective => null, p_log_level_rec => p_log_level_rec) then
859: raise pos_err;
860: end if;
861:
862: if not fa_cache_pkg.fazccb(p_book_type_code,
863: t_category_id(i),
864: p_log_level_rec) then
865: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
866: raise pos_err;

Line 901: l_adj.account := fa_cache_pkg.fazccb_record.deprn_expense_acct;

897: /*Bug#7685879 - replaced t_impairment_amount with t_deprn_adjustment_amount */
898: l_adj.adjustment_amount := t_deprn_adjustment_amount(i);
899: l_adj.source_type_code := 'DEPRECIATION';
900: l_adj.adjustment_type := 'EXPENSE';
901: l_adj.account := fa_cache_pkg.fazccb_record.deprn_expense_acct;
902: l_adj.account_type := 'DEPRN_EXPENSE_ACCT';
903: l_adj.debit_credit_flag := 'DR';
904:
905: if (p_log_level_rec.statement_level) then

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

949: fa_debug_pkg.add(l_calling_fn,'Calling function ', 'Deprn Basis', p_log_level_rec => p_log_level_rec);
950: end if;
951:
952: if (p_log_level_rec.statement_level) then
953: fa_debug_pkg.add(l_calling_fn, 'Before Calling', 'fa_cache_pkg.fazccmt', p_log_level_rec => p_log_level_rec);
954: fa_debug_pkg.add(l_calling_fn, 'deprn_method_code', l_asset_fin_rec.deprn_method_code, p_log_level_rec => p_log_level_rec);
955: fa_debug_pkg.add(l_calling_fn, 'life_in_months', l_asset_fin_rec.life_in_months, p_log_level_rec => p_log_level_rec);
956: end if;
957:

Line 958: if (not fa_cache_pkg.fazccmt(l_asset_fin_rec.deprn_method_code,

954: fa_debug_pkg.add(l_calling_fn, 'deprn_method_code', l_asset_fin_rec.deprn_method_code, p_log_level_rec => p_log_level_rec);
955: fa_debug_pkg.add(l_calling_fn, 'life_in_months', l_asset_fin_rec.life_in_months, p_log_level_rec => p_log_level_rec);
956: end if;
957:
958: if (not fa_cache_pkg.fazccmt(l_asset_fin_rec.deprn_method_code,
959: l_asset_fin_rec.life_in_months, p_log_level_rec => p_log_level_rec)) then
960: if (p_log_level_rec.statement_level) then
961: fa_debug_pkg.add(l_calling_fn, 'Error calling', 'fa_cache_pkg.fazccmt', p_log_level_rec => p_log_level_rec);
962: end if;

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

957:
958: if (not fa_cache_pkg.fazccmt(l_asset_fin_rec.deprn_method_code,
959: l_asset_fin_rec.life_in_months, p_log_level_rec => p_log_level_rec)) then
960: if (p_log_level_rec.statement_level) then
961: fa_debug_pkg.add(l_calling_fn, 'Error calling', 'fa_cache_pkg.fazccmt', p_log_level_rec => p_log_level_rec);
962: end if;
963:
964: raise pos_err;
965: end if;

Line 968: 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);

964: raise pos_err;
965: end if;
966:
967: if (p_log_level_rec.statement_level) then
968: 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);
969: 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);
970: 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);
971: end if;
972:

Line 969: 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);

965: end if;
966:
967: if (p_log_level_rec.statement_level) then
968: 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);
969: 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);
970: 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);
971: end if;
972:
973: if (fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FLAT) and

Line 970: 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);

966:
967: if (p_log_level_rec.statement_level) then
968: 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);
969: 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);
970: 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);
971: end if;
972:
973: if (fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FLAT) and
974: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_COST) and

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

969: 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);
970: 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);
971: end if;
972:
973: if (fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FLAT) and
974: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_COST) and
975: (nvl(fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, 'Y') = 'Y') and
976: NVL(fa_cache_pkg.fazccmt_record.JP_IMP_CALC_BASIS_FLAG, 'XX') <> 'YES' then
977: l_asset_deprn_rec.impairment_reserve := l_asset_deprn_rec.deprn_reserve +

Line 974: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_COST) and

970: 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);
971: end if;
972:
973: if (fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FLAT) and
974: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_COST) and
975: (nvl(fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, 'Y') = 'Y') and
976: NVL(fa_cache_pkg.fazccmt_record.JP_IMP_CALC_BASIS_FLAG, 'XX') <> 'YES' then
977: l_asset_deprn_rec.impairment_reserve := l_asset_deprn_rec.deprn_reserve +
978: l_asset_deprn_rec.impairment_reserve;

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

971: end if;
972:
973: if (fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FLAT) and
974: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_COST) and
975: (nvl(fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, 'Y') = 'Y') and
976: NVL(fa_cache_pkg.fazccmt_record.JP_IMP_CALC_BASIS_FLAG, 'XX') <> 'YES' then
977: l_asset_deprn_rec.impairment_reserve := l_asset_deprn_rec.deprn_reserve +
978: l_asset_deprn_rec.impairment_reserve;
979: elsif (nvl(fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, 'N') = 'Y') and

Line 976: NVL(fa_cache_pkg.fazccmt_record.JP_IMP_CALC_BASIS_FLAG, 'XX') <> 'YES' then

972:
973: if (fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FLAT) and
974: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_COST) and
975: (nvl(fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, 'Y') = 'Y') and
976: NVL(fa_cache_pkg.fazccmt_record.JP_IMP_CALC_BASIS_FLAG, 'XX') <> 'YES' then
977: l_asset_deprn_rec.impairment_reserve := l_asset_deprn_rec.deprn_reserve +
978: l_asset_deprn_rec.impairment_reserve;
979: elsif (nvl(fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, 'N') = 'Y') and
980: (fa_cache_pkg.fazcdbr_record.rule_name = 'FLAT RATE EXTENSION') then

Line 979: elsif (nvl(fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, 'N') = 'Y') and

975: (nvl(fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, 'Y') = 'Y') and
976: NVL(fa_cache_pkg.fazccmt_record.JP_IMP_CALC_BASIS_FLAG, 'XX') <> 'YES' then
977: l_asset_deprn_rec.impairment_reserve := l_asset_deprn_rec.deprn_reserve +
978: l_asset_deprn_rec.impairment_reserve;
979: elsif (nvl(fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, 'N') = 'Y') and
980: (fa_cache_pkg.fazcdbr_record.rule_name = 'FLAT RATE EXTENSION') then
981: l_asset_fin_rec.eofy_reserve := l_asset_deprn_rec.deprn_reserve;
982: end if;
983:

Line 980: (fa_cache_pkg.fazcdbr_record.rule_name = 'FLAT RATE EXTENSION') then

976: NVL(fa_cache_pkg.fazccmt_record.JP_IMP_CALC_BASIS_FLAG, 'XX') <> 'YES' then
977: l_asset_deprn_rec.impairment_reserve := l_asset_deprn_rec.deprn_reserve +
978: l_asset_deprn_rec.impairment_reserve;
979: elsif (nvl(fa_cache_pkg.fazcdrd_record.use_rsv_after_imp_flag, 'N') = 'Y') and
980: (fa_cache_pkg.fazcdbr_record.rule_name = 'FLAT RATE EXTENSION') then
981: l_asset_fin_rec.eofy_reserve := l_asset_deprn_rec.deprn_reserve;
982: end if;
983:
984: /*phase5 need to set transaction key = 'JI' for deprn methods using JP NBV based calculations for impairment*/

Line 985: if (NVL(fa_cache_pkg.fazccmt_record.JP_IMP_CALC_BASIS_FLAG, 'NO') = 'YES') then

981: l_asset_fin_rec.eofy_reserve := l_asset_deprn_rec.deprn_reserve;
982: end if;
983:
984: /*phase5 need to set transaction key = 'JI' for deprn methods using JP NBV based calculations for impairment*/
985: if (NVL(fa_cache_pkg.fazccmt_record.JP_IMP_CALC_BASIS_FLAG, 'NO') = 'YES') then
986: l_trans_rec.transaction_key := 'JI';
987: /*12844989 - to set correct old_adj_cost of asset in extended deprn period.*/
988: if l_asset_fin_rec.deprn_method_code = 'JP-STL-EXTND' then
989: if (p_mrc_sob_type_code = 'R') then

Line 1024: if (NVL(fa_cache_pkg.fazccmt_record.EXCLUDE_SALVAGE_VALUE_FLAG, 'NO') = 'YES') then

1020: t_new_raf(i) := t_raf(i);
1021: t_new_formula_factor(i) := t_formula_factor(i);
1022: end if; -- (p_period_rec.period_counter = t_period_counter(i))
1023: /* Bug 9577878 need to set period counter fully reserved correctly*/
1024: if (NVL(fa_cache_pkg.fazccmt_record.EXCLUDE_SALVAGE_VALUE_FLAG, 'NO') = 'YES') then
1025: if ((t_new_adj_cost(i) + l_asset_fin_rec.salvage_value) <= t_allowed_deprn_limit_amount(i)) then
1026: t_period_counter_fully_rsv(i) := p_period_rec.period_counter;
1027: t_period_counter_life_complete(i) := p_period_rec.period_counter;
1028: else

Line 1065: if (NVL(fa_cache_pkg.fazccmt_record.JP_IMP_CALC_BASIS_FLAG, 'NO') = 'YES') then

1061: /*Bug 9818289 Initialized below variables so that they have values in case of Non-Japanese methods*/
1062: t_rate_in_use(i) := null;
1063: t_nbv_at_switch(i) := null;
1064: /*Phase5 Calculations around switching and rate in use for assets using JP-250DB methods*/
1065: if (NVL(fa_cache_pkg.fazccmt_record.JP_IMP_CALC_BASIS_FLAG, 'NO') = 'YES') then
1066: t_rate_in_use(i) := l_asset_fin_rec.rate_in_use;
1067: t_nbv_at_switch(i) := l_asset_fin_rec.nbv_at_switch;
1068:
1069: if ((fa_cache_pkg.fazcct_record.number_per_fiscal_year = p_period_rec.period_num) and

Line 1069: if ((fa_cache_pkg.fazcct_record.number_per_fiscal_year = p_period_rec.period_num) and

1065: if (NVL(fa_cache_pkg.fazccmt_record.JP_IMP_CALC_BASIS_FLAG, 'NO') = 'YES') then
1066: t_rate_in_use(i) := l_asset_fin_rec.rate_in_use;
1067: t_nbv_at_switch(i) := l_asset_fin_rec.nbv_at_switch;
1068:
1069: if ((fa_cache_pkg.fazcct_record.number_per_fiscal_year = p_period_rec.period_num) and
1070: (nvl(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag,'NO') = 'YES') and
1071: (l_asset_fin_rec.rate_in_use = fa_cache_pkg.fazcfor_record.original_rate ))then
1072:
1073: if (((t_new_adj_cost(i) + l_asset_fin_rec.salvage_value) * fa_cache_pkg.fazcfor_record.original_rate) <= (t_cost(i) * fa_cache_pkg.fazcfor_record.guarantee_rate )) then

Line 1070: (nvl(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag,'NO') = 'YES') and

1066: t_rate_in_use(i) := l_asset_fin_rec.rate_in_use;
1067: t_nbv_at_switch(i) := l_asset_fin_rec.nbv_at_switch;
1068:
1069: if ((fa_cache_pkg.fazcct_record.number_per_fiscal_year = p_period_rec.period_num) and
1070: (nvl(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag,'NO') = 'YES') and
1071: (l_asset_fin_rec.rate_in_use = fa_cache_pkg.fazcfor_record.original_rate ))then
1072:
1073: if (((t_new_adj_cost(i) + l_asset_fin_rec.salvage_value) * fa_cache_pkg.fazcfor_record.original_rate) <= (t_cost(i) * fa_cache_pkg.fazcfor_record.guarantee_rate )) then
1074: t_rate_in_use(i) := fa_cache_pkg.fazcfor_record.revised_rate;

Line 1071: (l_asset_fin_rec.rate_in_use = fa_cache_pkg.fazcfor_record.original_rate ))then

1067: t_nbv_at_switch(i) := l_asset_fin_rec.nbv_at_switch;
1068:
1069: if ((fa_cache_pkg.fazcct_record.number_per_fiscal_year = p_period_rec.period_num) and
1070: (nvl(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag,'NO') = 'YES') and
1071: (l_asset_fin_rec.rate_in_use = fa_cache_pkg.fazcfor_record.original_rate ))then
1072:
1073: if (((t_new_adj_cost(i) + l_asset_fin_rec.salvage_value) * fa_cache_pkg.fazcfor_record.original_rate) <= (t_cost(i) * fa_cache_pkg.fazcfor_record.guarantee_rate )) then
1074: t_rate_in_use(i) := fa_cache_pkg.fazcfor_record.revised_rate;
1075: t_nbv_at_switch(i) := t_new_adj_cost(i) + l_asset_fin_rec.salvage_value;

Line 1073: if (((t_new_adj_cost(i) + l_asset_fin_rec.salvage_value) * fa_cache_pkg.fazcfor_record.original_rate) <= (t_cost(i) * fa_cache_pkg.fazcfor_record.guarantee_rate )) then

1069: if ((fa_cache_pkg.fazcct_record.number_per_fiscal_year = p_period_rec.period_num) and
1070: (nvl(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag,'NO') = 'YES') and
1071: (l_asset_fin_rec.rate_in_use = fa_cache_pkg.fazcfor_record.original_rate ))then
1072:
1073: if (((t_new_adj_cost(i) + l_asset_fin_rec.salvage_value) * fa_cache_pkg.fazcfor_record.original_rate) <= (t_cost(i) * fa_cache_pkg.fazcfor_record.guarantee_rate )) then
1074: t_rate_in_use(i) := fa_cache_pkg.fazcfor_record.revised_rate;
1075: t_nbv_at_switch(i) := t_new_adj_cost(i) + l_asset_fin_rec.salvage_value;
1076:
1077: if (p_log_level_rec.statement_level) then

Line 1074: t_rate_in_use(i) := fa_cache_pkg.fazcfor_record.revised_rate;

1070: (nvl(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag,'NO') = 'YES') and
1071: (l_asset_fin_rec.rate_in_use = fa_cache_pkg.fazcfor_record.original_rate ))then
1072:
1073: if (((t_new_adj_cost(i) + l_asset_fin_rec.salvage_value) * fa_cache_pkg.fazcfor_record.original_rate) <= (t_cost(i) * fa_cache_pkg.fazcfor_record.guarantee_rate )) then
1074: t_rate_in_use(i) := fa_cache_pkg.fazcfor_record.revised_rate;
1075: t_nbv_at_switch(i) := t_new_adj_cost(i) + l_asset_fin_rec.salvage_value;
1076:
1077: if (p_log_level_rec.statement_level) then
1078: fa_debug_pkg.add(l_calling_fn,'ASSET WILL SWITCH AFTER', 'CURRENT IMPAIRMENT', p_log_level_rec => p_log_level_rec);

Line 1083: t_rate_in_use(i) := fa_cache_pkg.fazcfor_record.original_rate;

1079: fa_debug_pkg.add(l_calling_fn,'t_rate_in_use(i)', t_rate_in_use(i), p_log_level_rec => p_log_level_rec);
1080: fa_debug_pkg.add(l_calling_fn,'t_nbv_at_switch(i)', t_nbv_at_switch(i), p_log_level_rec => p_log_level_rec);
1081: end if;
1082: else
1083: t_rate_in_use(i) := fa_cache_pkg.fazcfor_record.original_rate;
1084: t_nbv_at_switch(i) := NULL;
1085: end if;
1086: end if;
1087: if (p_log_level_rec.statement_level) then

Line 1101: fa_debug_pkg.add(l_calling_fn,'fa_cache_pkg.fazcbc_record.sorp_enabled_flag', fa_cache_pkg.fazcbc_record.sorp_enabled_flag, p_log_level_rec => p_log_level_rec);

1097:
1098: l_adj.source_type_code := 'ADJUSTMENT';
1099:
1100: if (p_log_level_rec.statement_level) then
1101: fa_debug_pkg.add(l_calling_fn,'fa_cache_pkg.fazcbc_record.sorp_enabled_flag', fa_cache_pkg.fazcbc_record.sorp_enabled_flag, p_log_level_rec => p_log_level_rec);
1102: end if;
1103:
1104: -- Bug 6666666 : Added for the SORP Compliance Project
1105: -- The following code snippet is used to create the impairment accounting

Line 1108: if fa_cache_pkg.fazcbc_record.sorp_enabled_flag = 'Y' then

1104: -- Bug 6666666 : Added for the SORP Compliance Project
1105: -- The following code snippet is used to create the impairment accounting
1106: -- entries. This functionality is documented in
1107: -- section 16.2 in the SORP Functional Design Document
1108: if fa_cache_pkg.fazcbc_record.sorp_enabled_flag = 'Y' then
1109:
1110: if not FA_SORP_IMPAIRMENT_PVT.create_sorp_imp_acct (
1111: px_adj => l_adj
1112: , p_impairment_amount => t_impairment_amount(i)

Line 1153: l_adj.account := fa_cache_pkg.fazccb_record.deprn_expense_acct;

1149:
1150: l_adj.adjustment_amount := t_deprn_adjustment_amount(i);
1151: l_adj.source_type_code := 'DEPRECIATION';
1152: l_adj.adjustment_type := 'EXPENSE';
1153: l_adj.account := fa_cache_pkg.fazccb_record.deprn_expense_acct;
1154: l_adj.account_type := 'DEPRN_EXPENSE_ACCT';
1155: l_adj.debit_credit_flag := 'DR';
1156:
1157: if (p_log_level_rec.statement_level) then

Line 1193: l_adj.account := fa_cache_pkg.fazccb_record.impair_reserve_acct;

1189: --******************************************************
1190: l_adj.adjustment_amount := t_impairment_amount(i) + t_reval_reserve_adj_amount(i); /*Bug# 8602103*/
1191: l_adj.adjustment_type := 'IMPAIR RESERVE';
1192: l_adj.account_type := 'IMPAIR_RESERVE_ACCT';
1193: l_adj.account := fa_cache_pkg.fazccb_record.impair_reserve_acct;
1194:
1195: l_adj.debit_credit_flag := 'CR';
1196:
1197: if (p_log_level_rec.statement_level) then

Line 1215: l_adj.account := fa_cache_pkg.fazccb_record.impair_expense_acct;

1211: --******************************************************
1212: l_adj.adjustment_amount := t_impairment_amount(i);
1213: l_adj.adjustment_type := 'IMPAIR EXPENSE';
1214: l_adj.account_type := 'IMPAIR_EXPENSE_ACCT';
1215: l_adj.account := fa_cache_pkg.fazccb_record.impair_expense_acct;
1216: l_adj.debit_credit_flag := 'DR';
1217:
1218: if (p_log_level_rec.statement_level) then
1219: fa_debug_pkg.add(l_calling_fn,'Calling faxinaj for ', 'Impairments Expense', p_log_level_rec => p_log_level_rec);

Line 1241: l_adj.account := fa_cache_pkg.fazccb_record.deprn_expense_acct;

1237:
1238: l_adj.adjustment_amount := t_deprn_adjustment_amount(i);
1239: l_adj.source_type_code := 'DEPRECIATION';
1240: l_adj.adjustment_type := 'EXPENSE';
1241: l_adj.account := fa_cache_pkg.fazccb_record.deprn_expense_acct;
1242: l_adj.account_type := 'DEPRN_EXPENSE_ACCT';
1243: l_adj.debit_credit_flag := 'DR';
1244:
1245: if (p_log_level_rec.statement_level) then

Line 1270: l_adj.account := fa_cache_pkg.fazccb_record.reval_reserve_acct;

1266:
1267: l_adj.adjustment_amount := t_reval_reserve_adj_amount(i) - t_reval_reserve(i);
1268: l_adj.adjustment_type := 'REVAL RESERVE';
1269: l_adj.account_type := 'REVAL_RESERVE_ACCT';
1270: l_adj.account := fa_cache_pkg.fazccb_record.reval_reserve_acct;
1271: l_adj.debit_credit_flag := 'DR';
1272:
1273: if (p_log_level_rec.statement_level) then
1274: fa_debug_pkg.add(l_calling_fn,'Calling faxinaj for ', 'Reval Reserve', p_log_level_rec => p_log_level_rec);

Line 1312: if fa_cache_pkg.fazcbc_record.sorp_enabled_flag = 'Y' then

1308:
1309: -- Bug 6666666 : Added for the SORP Compliance Project
1310: -- If SORP is enabled the value of general fund and
1311: -- capital adjustment are set.
1312: if fa_cache_pkg.fazcbc_record.sorp_enabled_flag = 'Y' then
1313: if not FA_INS_DETAIL_PKG.FAXINDD
1314: (X_book_type_code => p_book_type_code,
1315: X_asset_id => t_asset_id(i),
1316: X_period_counter => p_period_rec.period_counter,

Line 1394: if fa_cache_pkg.fazcbc_record.sorp_enabled_flag = 'Y' then

1390: end if;
1391:
1392: -- Bug 6666666 : If SORP is enabled, insert values for capital adj
1393: -- and general fund
1394: if fa_cache_pkg.fazcbc_record.sorp_enabled_flag = 'Y' then
1395: FORALL i in 1..t_request_id.count
1396: INSERT INTO FA_MC_DEPRN_SUMMARY( SET_OF_BOOKS_ID
1397: , BOOK_TYPE_CODE
1398: , ASSET_ID

Line 1555: if fa_cache_pkg.fazcbc_record.sorp_enabled_flag = 'Y' then

1551: end if;
1552:
1553: -- Bug 6666666 : If SORP is enabled, insert values for capital adj
1554: -- and general fund
1555: if fa_cache_pkg.fazcbc_record.sorp_enabled_flag = 'Y' then
1556: FORALL i in 1..t_request_id.count
1557: INSERT INTO FA_DEPRN_SUMMARY( BOOK_TYPE_CODE
1558: , ASSET_ID
1559: , PERIOD_COUNTER

Line 2308: AND cp.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar

2304: fa_deprn_periods dp,
2305: fa_fiscal_year fy
2306: WHERE dp.book_type_code = p_asset_hdr_rec.book_type_code
2307: AND dp.period_counter = p_period_rec.period_counter
2308: AND cp.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
2309: AND cp.start_date = dp.calendar_period_close_date + 1
2310: AND fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
2311: AND cp.start_date between fy.start_date and fy.end_date;
2312:

Line 2310: AND fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name

2306: WHERE dp.book_type_code = p_asset_hdr_rec.book_type_code
2307: AND dp.period_counter = p_period_rec.period_counter
2308: AND cp.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
2309: AND cp.start_date = dp.calendar_period_close_date + 1
2310: AND fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
2311: AND cp.start_date between fy.start_date and fy.end_date;
2312:
2313:
2314: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;

Line 2371: if (not FA_CACHE_PKG.fazccmt

2367: l_asset_fin_rec_new := p_asset_fin_rec;
2368:
2369: -- populate period rec for next period
2370:
2371: if (not FA_CACHE_PKG.fazccmt
2372: (l_asset_fin_rec_new.deprn_method_code,
2373: l_asset_fin_rec_new.life_in_months, p_log_level_rec => p_log_level_rec)) then
2374: FA_SRVR_MSG.ADD_MESSAGE(CALLING_FN => 'FA_AMORT_PKG.faxraf', p_log_level_rec => p_log_level_rec);
2375: return FALSE;

Line 2378: if (not fa_cache_pkg.fazccmt

2374: FA_SRVR_MSG.ADD_MESSAGE(CALLING_FN => 'FA_AMORT_PKG.faxraf', p_log_level_rec => p_log_level_rec);
2375: return FALSE;
2376: end if;
2377:
2378: if (not fa_cache_pkg.fazccmt
2379: (l_asset_fin_rec_new.deprn_method_code,
2380: l_asset_fin_rec_new.life_in_months, p_log_level_rec => p_log_level_rec)) then
2381: FA_SRVR_MSG.ADD_MESSAGE(CALLING_FN => 'FA_AMORT_PKG.faxraf', p_log_level_rec => p_log_level_rec);
2382: return FALSE;

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

2384:
2385: -- Skipping call to faxcde because it is unnecessary for flat-cost with period end balance,
2386: -- use recoverable cost, period average, and beginning balance basis rules
2387: -- There are more cases which calling this function unnecessary but not include for this time.
2388: if (not(((fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FLAT) and
2389: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_COST) and
2390: (fa_cache_pkg.fazcdbr_record.rule_name in ('PERIOD END BALANCE', 'PERIOD END AVERAGE',
2391: 'USE RECOVERABLE COST', 'BEGINNING PERIOD')) or
2392: fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_PROD))) then

Line 2389: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_COST) and

2385: -- Skipping call to faxcde because it is unnecessary for flat-cost with period end balance,
2386: -- use recoverable cost, period average, and beginning balance basis rules
2387: -- There are more cases which calling this function unnecessary but not include for this time.
2388: if (not(((fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FLAT) and
2389: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_COST) and
2390: (fa_cache_pkg.fazcdbr_record.rule_name in ('PERIOD END BALANCE', 'PERIOD END AVERAGE',
2391: 'USE RECOVERABLE COST', 'BEGINNING PERIOD')) or
2392: fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_PROD))) then
2393:

Line 2390: (fa_cache_pkg.fazcdbr_record.rule_name in ('PERIOD END BALANCE', 'PERIOD END AVERAGE',

2386: -- use recoverable cost, period average, and beginning balance basis rules
2387: -- There are more cases which calling this function unnecessary but not include for this time.
2388: if (not(((fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FLAT) and
2389: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_COST) and
2390: (fa_cache_pkg.fazcdbr_record.rule_name in ('PERIOD END BALANCE', 'PERIOD END AVERAGE',
2391: 'USE RECOVERABLE COST', 'BEGINNING PERIOD')) or
2392: fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_PROD))) then
2393:
2394: l_dpr_in.asset_num := p_asset_desc_rec.asset_number;

Line 2392: fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_PROD))) then

2388: if (not(((fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_FLAT) and
2389: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = fa_std_types.FAD_DBR_COST) and
2390: (fa_cache_pkg.fazcdbr_record.rule_name in ('PERIOD END BALANCE', 'PERIOD END AVERAGE',
2391: 'USE RECOVERABLE COST', 'BEGINNING PERIOD')) or
2392: fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_PROD))) then
2393:
2394: l_dpr_in.asset_num := p_asset_desc_rec.asset_number;
2395: l_dpr_in.calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;
2396: l_dpr_in.book := p_asset_hdr_rec.book_type_code;

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

2391: 'USE RECOVERABLE COST', 'BEGINNING PERIOD')) or
2392: fa_cache_pkg.fazccmt_record.rate_source_rule = fa_std_types.FAD_RSR_PROD))) then
2393:
2394: l_dpr_in.asset_num := p_asset_desc_rec.asset_number;
2395: l_dpr_in.calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;
2396: l_dpr_in.book := p_asset_hdr_rec.book_type_code;
2397: l_dpr_in.asset_id := p_asset_hdr_rec.asset_id;
2398: l_dpr_in.adj_cost := l_asset_fin_rec_new.recoverable_cost;
2399: l_dpr_in.rec_cost := l_asset_fin_rec_new.recoverable_cost;

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

2451: -- Not for what-if yet
2452: --
2453: l_running_mode := fa_std_types.FA_DPR_NORMAL;
2454:
2455: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar, p_log_level_rec => p_log_level_rec) then
2456: if (p_log_level_rec.statement_level) then
2457: fa_debug_pkg.add(l_calling_fn, 'Error calling', 'fa_cache_pkg.fazcct', p_log_level_rec => p_log_level_rec);
2458: end if;
2459:

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

2453: l_running_mode := fa_std_types.FA_DPR_NORMAL;
2454:
2455: if not fa_cache_pkg.fazcct(fa_cache_pkg.fazcbc_record.deprn_calendar, p_log_level_rec => p_log_level_rec) then
2456: if (p_log_level_rec.statement_level) then
2457: fa_debug_pkg.add(l_calling_fn, 'Error calling', 'fa_cache_pkg.fazcct', p_log_level_rec => p_log_level_rec);
2458: end if;
2459:
2460: raise db_err;
2461: end if;

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

2459:
2460: raise db_err;
2461: end if;
2462:
2463: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.prorate_calendar,
2464: fa_cache_pkg.fazcbc_record.fiscal_year_name,
2465: l_dpr_in.prorate_jdate,
2466: l_temp_number,
2467: l_dpr_in.y_begin,

Line 2464: fa_cache_pkg.fazcbc_record.fiscal_year_name,

2460: raise db_err;
2461: end if;
2462:
2463: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.prorate_calendar,
2464: fa_cache_pkg.fazcbc_record.fiscal_year_name,
2465: l_dpr_in.prorate_jdate,
2466: l_temp_number,
2467: l_dpr_in.y_begin,
2468: l_temp_integer, p_log_level_rec => p_log_level_rec) then

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

2467: l_dpr_in.y_begin,
2468: l_temp_integer, p_log_level_rec => p_log_level_rec) then
2469: if (p_log_level_rec.statement_level) then
2470: fa_debug_pkg.add(l_calling_fn, 'Error calling',
2471: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
2472: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
2473: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);
2474: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
2475: fa_cache_pkg.fazcbc_record.fiscal_year_name, p_log_level_rec => p_log_level_rec);

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

2468: l_temp_integer, p_log_level_rec => p_log_level_rec) then
2469: if (p_log_level_rec.statement_level) then
2470: fa_debug_pkg.add(l_calling_fn, 'Error calling',
2471: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
2472: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
2473: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);
2474: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
2475: fa_cache_pkg.fazcbc_record.fiscal_year_name, p_log_level_rec => p_log_level_rec);
2476: end if;

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

2469: if (p_log_level_rec.statement_level) then
2470: fa_debug_pkg.add(l_calling_fn, 'Error calling',
2471: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
2472: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
2473: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);
2474: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
2475: fa_cache_pkg.fazcbc_record.fiscal_year_name, p_log_level_rec => p_log_level_rec);
2476: end if;
2477:

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

2470: fa_debug_pkg.add(l_calling_fn, 'Error calling',
2471: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
2472: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
2473: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);
2474: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
2475: fa_cache_pkg.fazcbc_record.fiscal_year_name, p_log_level_rec => p_log_level_rec);
2476: end if;
2477:
2478: raise db_err;

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

2471: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
2472: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
2473: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);
2474: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
2475: fa_cache_pkg.fazcbc_record.fiscal_year_name, p_log_level_rec => p_log_level_rec);
2476: end if;
2477:
2478: raise db_err;
2479: end if;

Line 2485: fa_cache_pkg.fazcct_record.number_per_fiscal_year, p_log_level_rec => p_log_level_rec);

2481: l_dpr_in.p_cl_begin := 1;
2482:
2483: if (p_log_level_rec.statement_level) then
2484: fa_debug_pkg.add(l_calling_fn, 'number_per_fiscal_year',
2485: fa_cache_pkg.fazcct_record.number_per_fiscal_year, p_log_level_rec => p_log_level_rec);
2486: fa_debug_pkg.add(l_calling_fn, 'l_period_rec.period_num', l_period_rec.period_num, p_log_level_rec => p_log_level_rec);
2487: end if;
2488:
2489: if (l_period_rec.period_num = 1) then

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

2487: end if;
2488:
2489: if (l_period_rec.period_num = 1) then
2490: l_dpr_in.y_end := l_period_rec.fiscal_year - 1;
2491: l_dpr_in.p_cl_end := fa_cache_pkg.fazcct_record.number_per_fiscal_year;
2492: else
2493: l_dpr_in.y_end := l_period_rec.fiscal_year;
2494: l_dpr_in.p_cl_end := l_period_rec.period_num - 1;
2495: end if;

Line 2504: if fa_cache_pkg.fa_deprn_override_enabled then

2500:
2501: l_dpr_in.rate_adj_factor := 1;
2502:
2503: -- manual override
2504: if fa_cache_pkg.fa_deprn_override_enabled then
2505: if (not fa_cache_pkg.fazccmt(
2506: l_asset_fin_rec_new.deprn_method_code,
2507: l_asset_fin_rec_new.life_in_months, p_log_level_rec => p_log_level_rec)) then
2508: if (p_log_level_rec.statement_level) then

Line 2505: if (not fa_cache_pkg.fazccmt(

2501: l_dpr_in.rate_adj_factor := 1;
2502:
2503: -- manual override
2504: if fa_cache_pkg.fa_deprn_override_enabled then
2505: if (not fa_cache_pkg.fazccmt(
2506: l_asset_fin_rec_new.deprn_method_code,
2507: l_asset_fin_rec_new.life_in_months, p_log_level_rec => p_log_level_rec)) then
2508: if (p_log_level_rec.statement_level) then
2509: fa_debug_pkg.add(l_calling_fn, 'Error calling',

Line 2510: 'fa_cache_pkg.fazccmt', p_log_level_rec => p_log_level_rec);

2506: l_asset_fin_rec_new.deprn_method_code,
2507: l_asset_fin_rec_new.life_in_months, p_log_level_rec => p_log_level_rec)) then
2508: if (p_log_level_rec.statement_level) then
2509: fa_debug_pkg.add(l_calling_fn, 'Error calling',
2510: 'fa_cache_pkg.fazccmt', p_log_level_rec => p_log_level_rec);
2511: end if;
2512:
2513: raise db_err;
2514: end if;

Line 2516: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;

2512:
2513: raise db_err;
2514: end if;
2515:
2516: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
2517: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
2518:
2519: -- update override status only if satisfies condintion,
2520: -- otherwise do not update status when calculating RAF

Line 2517: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;

2513: raise db_err;
2514: end if;
2515:
2516: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
2517: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
2518:
2519: -- update override status only if satisfies condintion,
2520: -- otherwise do not update status when calculating RAF
2521: -- 1. formula; or

Line 2546: if ((fa_cache_pkg.fazcbc_record.AMORTIZE_REVAL_RESERVE_FLAG='YES') and

2542: end if;
2543:
2544: -- Bug 4129984.
2545:
2546: if ((fa_cache_pkg.fazcbc_record.AMORTIZE_REVAL_RESERVE_FLAG='YES') and
2547: (l_asset_fin_rec_new.Reval_Amortization_Basis is not null) and
2548: (p_asset_type_rec.asset_type = 'CAPITALIZED') and
2549: (l_asset_fin_rec_new.group_asset_id is null)) then
2550:

Line 2564: (fa_cache_pkg.fazcdrd_record.rule_name = 'ENERGY PERIOD END BALANCE') then -- ENERGY

2560:
2561:
2562: -- code fix for bug no.3630495. added the following line to calculate the adjusted capacity
2563: if (nvl(l_asset_fin_rec_new.tracking_method, 'NO TRACK') = 'ALLOCATE') and -- ENERGY
2564: (fa_cache_pkg.fazcdrd_record.rule_name = 'ENERGY PERIOD END BALANCE') then -- ENERGY
2565: null;
2566: else
2567: l_asset_fin_rec_new.adjusted_capacity:=l_asset_fin_rec_new.production_capacity- nvl(l_dpr_out.new_ltd_prod, 0);
2568: end if;

Line 2681: l_adj.account := fa_cache_pkg.fazccb_record.CIP_COST_ACCT;

2677: if p_asset_type_rec.asset_type = 'CIP' then
2678: l_adj.source_type_code := 'CIP ADDITION';
2679: l_adj.adjustment_type := 'CIP COST';
2680: l_adj.account_type := 'CIP_COST_ACCT';
2681: l_adj.account := fa_cache_pkg.fazccb_record.CIP_COST_ACCT;
2682: else
2683: l_adj.source_type_code := 'ADDITION';
2684: l_adj.adjustment_type := 'COST';
2685: l_adj.account_type := 'ASSET_COST_ACCT';

Line 2686: l_adj.account := fa_cache_pkg.fazccb_record.ASSET_COST_ACCT;

2682: else
2683: l_adj.source_type_code := 'ADDITION';
2684: l_adj.adjustment_type := 'COST';
2685: l_adj.account_type := 'ASSET_COST_ACCT';
2686: l_adj.account := fa_cache_pkg.fazccb_record.ASSET_COST_ACCT;
2687: end if;
2688:
2689: if p_cost > 0 then
2690: l_adj.debit_credit_flag := 'DR';

Line 2717: l_adj.account := fa_cache_pkg.fazccb_record.CIP_CLEARING_ACCT;

2713: l_adj.adjustment_type := 'COST CLEARING';
2714:
2715: if p_asset_type_rec.asset_type = 'CIP' then
2716: l_adj.account_type := 'CIP_CLEARING_ACCT';
2717: l_adj.account := fa_cache_pkg.fazccb_record.CIP_CLEARING_ACCT;
2718: else
2719: l_adj.account_type := 'ASSET_CLEARING_ACCT';
2720: l_adj.account := fa_cache_pkg.fazccb_record.ASSET_CLEARING_ACCT;
2721: end if;

Line 2720: l_adj.account := fa_cache_pkg.fazccb_record.ASSET_CLEARING_ACCT;

2716: l_adj.account_type := 'CIP_CLEARING_ACCT';
2717: l_adj.account := fa_cache_pkg.fazccb_record.CIP_CLEARING_ACCT;
2718: else
2719: l_adj.account_type := 'ASSET_CLEARING_ACCT';
2720: l_adj.account := fa_cache_pkg.fazccb_record.ASSET_CLEARING_ACCT;
2721: end if;
2722:
2723: if p_cost > 0 then
2724: l_adj.debit_credit_flag := 'CR';