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_GAINLOSS_UND_PKG dependencies on FA_CACHE_PKG

Line 4: g_release number := fa_cache_pkg.fazarel_release;

1: PACKAGE BODY FA_GAINLOSS_UND_PKG AS
2: /* $Header: fagundb.pls 120.67.12020000.2 2012/07/20 11:52:13 spooyath ship $*/
3:
4: g_release number := fa_cache_pkg.fazarel_release;
5:
6:
7: /* Added types and variables at global level for bug 7396397*/
8:

Line 543: l_orig_book := fa_cache_pkg.fazcbc_record.book_type_code;

539: h_retirement_id := ret.retirement_id;
540:
541: adj_row.asset_invoice_id := 0;
542:
543: l_orig_book := fa_cache_pkg.fazcbc_record.book_type_code;
544: l_orig_cat_book := fa_cache_pkg.fazccb_record.book_type_code;
545:
546: --bug 6129798
547: if RET.wip_asset > 0 then

Line 544: l_orig_cat_book := fa_cache_pkg.fazccb_record.book_type_code;

540:
541: adj_row.asset_invoice_id := 0;
542:
543: l_orig_book := fa_cache_pkg.fazcbc_record.book_type_code;
544: l_orig_cat_book := fa_cache_pkg.fazccb_record.book_type_code;
545:
546: --bug 6129798
547: if RET.wip_asset > 0 then
548: adj_row.source_type_code := 'CIP RETIREMENT';

Line 619: if not fa_cache_pkg.fazcbc (x_book => h_book, p_log_level_rec => p_log_level_rec) then

615: h_tracking_method;
616: EXIT WHEN TAX_BOOKS_DR%NOTFOUND OR TAX_BOOKS_DR%NOTFOUND IS NULL;
617:
618: /* Fix for Bug#2821938 */
619: if not fa_cache_pkg.fazcbc (x_book => h_book, p_log_level_rec => p_log_level_rec) then
620: RAISE fagtax_error;
621: end if;
622:
623:

Line 744: if ( (h_mrc_sob_type_code = 'R') and (h_set_of_books_id <> fa_cache_pkg.fazcbc_record.set_of_books_id) and (l_secondary_sob_id = h_set_of_books_id)) then

740: Secondary Changes Start
741: If primary and secondary sob_id is different then we need to
742: create event for secondary ledger*/
743: l_secondary_sob_id := FA_XLA_EVENTS_PVT.get_secondary_sob_id(l_asset_hdr_rec.book_type_code);
744: if ( (h_mrc_sob_type_code = 'R') and (h_set_of_books_id <> fa_cache_pkg.fazcbc_record.set_of_books_id) and (l_secondary_sob_id = h_set_of_books_id)) then
745: l_secondary_asset_hdr_rec := l_asset_hdr_rec;
746: l_secondary_trans_rec := l_trans_rec;
747:
748: if not FA_UTIL_PVT.get_period_rec

Line 812: if not fa_cache_pkg.fazccb (h_book, h_category_id, p_log_level_rec => p_log_level_rec) then

808: adj_row.set_of_books_id := ret.set_of_books_id;
809:
810: -- Get the various Accts from FA_CATEGORY_BOOKS
811:
812: if not fa_cache_pkg.fazccb (h_book, h_category_id, p_log_level_rec => p_log_level_rec) then
813: RAISE fagtax_error;
814: end if;
815:
816:

Line 818: if not fa_cache_pkg.fazccb (h_book, h_category_id, p_log_level_rec => p_log_level_rec) then

814: end if;
815:
816:
817: if RET.wip_asset > 0 then
818: if not fa_cache_pkg.fazccb (h_book, h_category_id, p_log_level_rec => p_log_level_rec) then
819: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
820: RAISE fagtax_error;
821: end if;
822: end if;

Line 833: fa_cache_pkg.fazccb_record.DEPRN_RESERVE_ACCT;

829: adj_row.adjustment_type := 'RESERVE';
830: adj_row.debit_credit_flag := 'DR';
831: adj_row.account_type := 'DEPRN_RESERVE_ACCT';
832: adj_row.account :=
833: fa_cache_pkg.fazccb_record.DEPRN_RESERVE_ACCT;
834: adj_row.selection_mode := fa_std_types.FA_AJ_CLEAR;
835: adj_row.adjustment_amount := 0;
836: adj_row.source_dest_code := 'SOURCE';
837:

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

880: adj_row.asset_id := h_group_asset_id;
881:
882: l_asset_hdr_rec.asset_id := h_group_asset_id;
883: l_asset_hdr_rec.book_type_code := ret.book;
884: l_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
885:
886: if not FA_UTIL_PVT.get_asset_cat_rec (
887: p_asset_hdr_rec => l_asset_hdr_rec,
888: px_asset_cat_rec => l_asset_cat_rec,

Line 894: if not fa_cache_pkg.fazccb(

890: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
891: return(FALSE);
892: end if;
893:
894: if not fa_cache_pkg.fazccb(
895: X_book => ret.book,
896: X_cat_id => l_asset_cat_rec.category_id, p_log_level_rec => p_log_level_rec) then
897: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
898: return(FALSE);

Line 902: fa_cache_pkg.fazccb_record.DEPRN_RESERVE_ACCT;

898: return(FALSE);
899: end if;
900:
901: adj_row.account :=
902: fa_cache_pkg.fazccb_record.DEPRN_RESERVE_ACCT;
903: adj_row.selection_mode := fa_std_types.FA_AJ_CLEAR;
904: adj_row.adjustment_amount := 0;
905: adj_row.track_member_flag := NULL;
906: adj_row.source_dest_code := 'SOURCE';

Line 942: if not fa_cache_pkg.fazccb (h_book, h_category_id, p_log_level_rec => p_log_level_rec) then

938: end if;
939:
940: adj_row.asset_id := ret.asset_id;
941:
942: if not fa_cache_pkg.fazccb (h_book, h_category_id, p_log_level_rec => p_log_level_rec) then
943: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
944: RAISE fagtax_error;
945: end if;
946:

Line 982: fa_cache_pkg.fazccb_record.BONUS_DEPRN_RESERVE_ACCT;

978: adj_row.adjustment_type := 'BONUS RESERVE';
979: adj_row.debit_credit_flag := 'DR';
980: adj_row.account_type := 'BONUS_DEPRN_RESERVE_ACCT';
981: adj_row.account :=
982: fa_cache_pkg.fazccb_record.BONUS_DEPRN_RESERVE_ACCT;
983: adj_row.selection_mode := fa_std_types.FA_AJ_CLEAR;
984: adj_row.adjustment_amount := 0;
985: adj_row.source_dest_code := 'SOURCE';
986:

Line 1027: fa_cache_pkg.fazccb_record.IMPAIR_RESERVE_ACCT;

1023: adj_row.adjustment_type := 'IMPAIR RESERVE';
1024: adj_row.debit_credit_flag := 'DR';
1025: adj_row.account_type := 'IMPAIR_RESERVE_ACCT';
1026: adj_row.account :=
1027: fa_cache_pkg.fazccb_record.IMPAIR_RESERVE_ACCT;
1028: adj_row.selection_mode := fa_std_types.FA_AJ_CLEAR;
1029: adj_row.adjustment_amount := 0;
1030: adj_row.source_dest_code := 'SOURCE';
1031:

Line 1071: fa_cache_pkg.fazccb_record.REVAL_RESERVE_ACCT;

1067: adj_row.adjustment_type := 'REVAL RESERVE';
1068: adj_row.debit_credit_flag := 'DR';
1069: adj_row.account_type := 'REVAL_RESERVE_ACCT';
1070: adj_row.account :=
1071: fa_cache_pkg.fazccb_record.REVAL_RESERVE_ACCT;
1072: adj_row.selection_mode := fa_std_types.FA_AJ_CLEAR;
1073: adj_row.adjustment_amount := 0;
1074: adj_row.source_dest_code := 'SOURCE';
1075:

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

1134: adj_row.track_member_flag := NULL;
1135:
1136: l_asset_hdr_rec.asset_id := bk.group_asset_id;
1137: l_asset_hdr_rec.book_type_code := ret.book;
1138: l_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
1139:
1140: if not FA_UTIL_PVT.get_asset_cat_rec (
1141: p_asset_hdr_rec => l_asset_hdr_rec,
1142: px_asset_cat_rec => l_asset_cat_rec,

Line 1148: if not fa_cache_pkg.fazccb(

1144: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
1145: return(FALSE);
1146: end if;
1147:
1148: if not fa_cache_pkg.fazccb(
1149: X_book => ret.book,
1150: X_cat_id => l_asset_cat_rec.category_id, p_log_level_rec => p_log_level_rec) then
1151: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
1152: return(FALSE);

Line 1156: fa_cache_pkg.fazccb_record.BONUS_DEPRN_RESERVE_ACCT;

1152: return(FALSE);
1153: end if;
1154:
1155: adj_row.account :=
1156: fa_cache_pkg.fazccb_record.BONUS_DEPRN_RESERVE_ACCT;
1157: adj_row.selection_mode := fa_std_types.FA_AJ_CLEAR;
1158: adj_row.adjustment_amount := 0;
1159: adj_row.source_dest_code := 'SOURCE';
1160:

Line 1193: if not fa_cache_pkg.fazccb (h_book, h_category_id, p_log_level_rec => p_log_level_rec) then

1189: end if;
1190:
1191: adj_row.asset_id := ret.asset_id;
1192:
1193: if not fa_cache_pkg.fazccb (h_book, h_category_id, p_log_level_rec => p_log_level_rec) then
1194: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
1195: RAISE fagtax_error;
1196: end if;
1197:

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

1208: adj_row.track_member_flag := NULL;
1209:
1210: l_asset_hdr_rec.asset_id := bk.group_asset_id;
1211: l_asset_hdr_rec.book_type_code := ret.book;
1212: l_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
1213:
1214: if not FA_UTIL_PVT.get_asset_cat_rec (
1215: p_asset_hdr_rec => l_asset_hdr_rec,
1216: px_asset_cat_rec => l_asset_cat_rec,

Line 1222: if not fa_cache_pkg.fazccb(

1218: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
1219: return(FALSE);
1220: end if;
1221:
1222: if not fa_cache_pkg.fazccb(
1223: X_book => ret.book,
1224: X_cat_id => l_asset_cat_rec.category_id, p_log_level_rec => p_log_level_rec) then
1225: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
1226: return(FALSE);

Line 1230: fa_cache_pkg.fazccb_record.IMPAIR_RESERVE_ACCT;

1226: return(FALSE);
1227: end if;
1228:
1229: adj_row.account :=
1230: fa_cache_pkg.fazccb_record.IMPAIR_RESERVE_ACCT;
1231: adj_row.selection_mode := fa_std_types.FA_AJ_CLEAR;
1232: adj_row.adjustment_amount := 0;
1233: adj_row.source_dest_code := 'SOURCE';
1234:

Line 1267: if not fa_cache_pkg.fazccb (h_book, h_category_id, p_log_level_rec => p_log_level_rec) then

1263: end if;
1264:
1265: adj_row.asset_id := ret.asset_id;
1266:
1267: if not fa_cache_pkg.fazccb (h_book, h_category_id, p_log_level_rec => p_log_level_rec) then
1268: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
1269: RAISE fagtax_error;
1270: end if;
1271:

Line 1287: fa_cache_pkg.fazccb_record.ASSET_COST_ACCT;

1283:
1284: if (RET.wip_asset is null or ret.wip_asset <= 0) then
1285: adj_row.account_type := 'ASSET_COST_ACCT';
1286: adj_row.account :=
1287: fa_cache_pkg.fazccb_record.ASSET_COST_ACCT;
1288: else
1289: adj_row.account_type := 'CIP_COST_ACCT';
1290: adj_row.account :=
1291: fa_cache_pkg.fazccb_record.CIP_COST_ACCT;

Line 1291: fa_cache_pkg.fazccb_record.CIP_COST_ACCT;

1287: fa_cache_pkg.fazccb_record.ASSET_COST_ACCT;
1288: else
1289: adj_row.account_type := 'CIP_COST_ACCT';
1290: adj_row.account :=
1291: fa_cache_pkg.fazccb_record.CIP_COST_ACCT;
1292: end if;
1293:
1294:
1295: if (NOT FA_INS_ADJUST_PKG.faxinaj(adj_row,

Line 1333: if not fa_cache_pkg.fazcbc (x_book => l_orig_book, p_log_level_rec => p_log_level_rec) then

1329:
1330: CLOSE TAX_BOOKS_DR;
1331:
1332: /* Added for bug 9914820 */
1333: if not fa_cache_pkg.fazcbc (x_book => l_orig_book, p_log_level_rec => p_log_level_rec) then
1334: RAISE fagtax_error;
1335: end if;
1336: if l_orig_cat_book is not null then
1337: if not fa_cache_pkg.fazccb ( l_orig_cat_book, h_category_id, p_log_level_rec => p_log_level_rec) then

Line 1337: if not fa_cache_pkg.fazccb ( l_orig_cat_book, h_category_id, p_log_level_rec => p_log_level_rec) then

1333: if not fa_cache_pkg.fazcbc (x_book => l_orig_book, p_log_level_rec => p_log_level_rec) then
1334: RAISE fagtax_error;
1335: end if;
1336: if l_orig_cat_book is not null then
1337: if not fa_cache_pkg.fazccb ( l_orig_cat_book, h_category_id, p_log_level_rec => p_log_level_rec) then
1338: RAISE fagtax_error;
1339: end if;
1340: end if;
1341:

Line 1619: if fa_cache_pkg.fazccmt_record.GUARANTEE_RATE_METHOD_FLAG = 'YES' then

1615: value => h_rethdrout, p_log_level_rec => p_log_level_rec);
1616: end if;
1617:
1618: -- Bug:5930979:Japan Tax Reform Project (Start)
1619: if fa_cache_pkg.fazccmt_record.GUARANTEE_RATE_METHOD_FLAG = 'YES' then
1620: if ret.mrc_sob_type_code <> 'R' then
1621: select nvl(rate_in_use,0)
1622: into l_rate_in_use
1623: from fa_books

Line 1958: if fa_cache_pkg.fazccmt_record.GUARANTEE_RATE_METHOD_FLAG = 'YES' then

1954: value => '', p_log_level_rec => p_log_level_rec);
1955: end if;
1956:
1957: -- Bug:5930979:Japan Tax Reform Project (Start)
1958: if fa_cache_pkg.fazccmt_record.GUARANTEE_RATE_METHOD_FLAG = 'YES' then
1959: if ret.mrc_sob_type_code <> 'R' then
1960: update fa_books
1961: set rate_in_use = l_rate_in_use
1962: where asset_id = ret.asset_id

Line 3869: if not fa_cache_pkg.fazccb(

3865: FROM fa_asset_history
3866: WHERE asset_id = RET.asset_id
3867: AND date_ineffective is null;
3868:
3869: if not fa_cache_pkg.fazccb(
3870: X_book => RET.book,
3871: X_cat_id => h_category_id, p_log_level_rec => p_log_level_rec) then
3872: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
3873: return(FALSE);

Line 3890: fa_cache_pkg.fazccb_record.DEPRN_EXPENSE_ACCT;

3886: -- bridgway
3887: --
3888:
3889: adj_row.account :=
3890: fa_cache_pkg.fazccb_record.DEPRN_EXPENSE_ACCT;
3891: adj_row.account_type := 'DEPRN_EXPENSE_ACCT';
3892: adj_row.gen_ccid_flag := TRUE;
3893:
3894: adj_row.adjustment_type := 'EXPENSE';

Line 3900: fa_cache_pkg.fazccb_record.BONUS_DEPRN_EXPENSE_ACCT;

3896:
3897: elsif adj_type = 'BONUS EXPENSE' then
3898:
3899: adj_row.account:=
3900: fa_cache_pkg.fazccb_record.BONUS_DEPRN_EXPENSE_ACCT;
3901: adj_row.account_type := 'BONUS_DEPRN_EXPENSE_ACCT';
3902: adj_row.adjustment_type := 'BONUS EXPENSE';
3903: adj_row.debit_credit_flag := 'DR';
3904: adj_row.gen_ccid_flag := TRUE;

Line 3909: fa_cache_pkg.fazccb_record.IMPAIR_EXPENSE_ACCT;

3905:
3906: elsif adj_type = 'IMPAIR EXPENSE' then
3907:
3908: adj_row.account:=
3909: fa_cache_pkg.fazccb_record.IMPAIR_EXPENSE_ACCT;
3910: adj_row.account_type := 'IMPAIR_EXPENSE_ACCT';
3911: adj_row.adjustment_type := 'IMPAIR EXPENSE';
3912: adj_row.debit_credit_flag := 'DR';
3913: adj_row.gen_ccid_flag := TRUE;

Line 4004: if FA_CACHE_PKG.fazcbc_record.sorp_enabled_flag = 'Y'

4000: should be inserted for SORP. The previous value from the
4001: adjustment table must not be taken into account as it has
4002: been already reversed due to the code in FAGIAR.
4003: */
4004: if FA_CACHE_PKG.fazcbc_record.sorp_enabled_flag = 'Y'
4005: and adj_row.adjustment_type = 'EXPENSE'
4006: and h_exp_adj_amount_sorp <> 0 then
4007: if not FA_SORP_UTIL_PVT.create_sorp_neutral_acct (
4008: p_amount => h_exp_adj_amount_sorp,

Line 4172: if FA_CACHE_PKG.fazcbc_record.sorp_enabled_flag = 'Y'

4168: should be inserted for SORP. The previous value from the
4169: adjustment table must not be taken into account as it has
4170: been already reversed due to the code in FAGIAR.
4171: */
4172: if FA_CACHE_PKG.fazcbc_record.sorp_enabled_flag = 'Y'
4173: and adj_row.adjustment_type = 'EXPENSE'
4174: and h_exp_adj_amount_sorp <> 0 then
4175: if not FA_SORP_UTIL_PVT.create_sorp_neutral_acct (
4176: p_amount => h_exp_adj_amount_sorp,

Line 4912: adj_row.account := fa_cache_pkg.fazccb_record.CIP_COST_ACCT;

4908: adj_row.source_type_code := 'RETIREMENT';
4909:
4910: if(RET.wip_asset > 0)then
4911: adj_row.account_type := 'CIP_COST_ACCT';
4912: adj_row.account := fa_cache_pkg.fazccb_record.CIP_COST_ACCT;
4913:
4914: else
4915: adj_row.account_type := 'ASSET_COST_ACCT';
4916: adj_row.account := fa_cache_pkg.fazccb_record.ASSET_COST_ACCT;

Line 4916: adj_row.account := fa_cache_pkg.fazccb_record.ASSET_COST_ACCT;

4912: adj_row.account := fa_cache_pkg.fazccb_record.CIP_COST_ACCT;
4913:
4914: else
4915: adj_row.account_type := 'ASSET_COST_ACCT';
4916: adj_row.account := fa_cache_pkg.fazccb_record.ASSET_COST_ACCT;
4917: end if;
4918:
4919: adj_row.selection_mode := fa_std_types.FA_AJ_CLEAR_PARTIAL;
4920: adj_row.adjustment_amount := 0;

Line 4955: adj_row.account := fa_cache_pkg.fazccb_record.CIP_COST_ACCT;

4951: adj_row.source_type_code := 'RETIREMENT';
4952:
4953: if(RET.wip_asset > 0)then
4954: adj_row.account_type := 'CIP_COST_ACCT';
4955: adj_row.account := fa_cache_pkg.fazccb_record.CIP_COST_ACCT;
4956:
4957: else
4958:
4959: adj_row.account_type := 'ASSET_COST_ACCT';

Line 4960: adj_row.account := fa_cache_pkg.fazccb_record.ASSET_COST_ACCT;

4956:
4957: else
4958:
4959: adj_row.account_type := 'ASSET_COST_ACCT';
4960: adj_row.account := fa_cache_pkg.fazccb_record.ASSET_COST_ACCT;
4961: end if;
4962:
4963: adj_row.selection_mode := fa_std_types.FA_AJ_ACTIVE_PARTIAL;
4964:

Line 5010: adj_row.account := fa_cache_pkg.fazccb_record.DEPRN_RESERVE_ACCT;

5006: END if;
5007: adj_row.adjustment_type := 'RESERVE';
5008: adj_row.debit_credit_flag := 'DR';
5009: adj_row.account_type := 'DEPRN_RESERVE_ACCT';
5010: adj_row.account := fa_cache_pkg.fazccb_record.DEPRN_RESERVE_ACCT;
5011:
5012: adj_row.selection_mode := fa_std_types.FA_AJ_CLEAR_PARTIAL;
5013:
5014: adj_row.adjustment_amount := 0;

Line 5200: (ret.wip_asset > 0 and nvl(FA_CACHE_PKG.fazcbc_record.sorp_enabled_flag,'N') = 'N'))) then

5196: end if;
5197: /*Bug#12768930 - Modified following condition to allow call to fagirv for CIP asset and non sorp book */
5198: if (bk.capitalize AND bk.depreciate AND
5199: ((ret.wip_asset is null or ret.wip_asset <= 0) OR
5200: (ret.wip_asset > 0 and nvl(FA_CACHE_PKG.fazcbc_record.sorp_enabled_flag,'N') = 'N'))) then
5201:
5202: if ( NOT l_decision_flag) then
5203:
5204: if ( NOT fagirv(ret, start_pd, deprn_reserve,

Line 5564: (ret.wip_asset > 0 and nvl(FA_CACHE_PKG.fazcbc_record.sorp_enabled_flag,'N') = 'N') ) then

5560: value => '', p_log_level_rec => p_log_level_rec);
5561: end if;
5562: /*Bug#12768930 - modified condition to allow call to fagiav for CIP asset and non sorp book */
5563: if (((ret.wip_asset is null) or (ret.wip_asset <= 0)) or
5564: (ret.wip_asset > 0 and nvl(FA_CACHE_PKG.fazcbc_record.sorp_enabled_flag,'N') = 'N') ) then
5565:
5566: if( NOT fagiav( ret,
5567: bk,
5568: cpd_ctr,

Line 6217: element => 'fa_cache_pkg.fazcbc_record.RETIRE_REVAL_RESERVE_FLAG',

6213:
6214: begin
6215: if (p_log_level_rec.statement_level) then
6216: fa_debug_pkg.add (fname => l_calling_fn,
6217: element => 'fa_cache_pkg.fazcbc_record.RETIRE_REVAL_RESERVE_FLAG',
6218: value => fa_cache_pkg.fazcbc_record.RETIRE_REVAL_RESERVE_FLAG,
6219: p_log_level_rec => p_log_level_rec);
6220: fa_debug_pkg.add (fname => l_calling_fn,
6221: element => 'reval_reserve',

Line 6218: value => fa_cache_pkg.fazcbc_record.RETIRE_REVAL_RESERVE_FLAG,

6214: begin
6215: if (p_log_level_rec.statement_level) then
6216: fa_debug_pkg.add (fname => l_calling_fn,
6217: element => 'fa_cache_pkg.fazcbc_record.RETIRE_REVAL_RESERVE_FLAG',
6218: value => fa_cache_pkg.fazcbc_record.RETIRE_REVAL_RESERVE_FLAG,
6219: p_log_level_rec => p_log_level_rec);
6220: fa_debug_pkg.add (fname => l_calling_fn,
6221: element => 'reval_reserve',
6222: value => reval_reserve,

Line 6234: if ( not (nvl(fa_cache_pkg.fazcbc_record.RETIRE_REVAL_RESERVE_FLAG,'NO') = 'NO'

6230: value => bk.book_class,
6231: p_log_level_rec => p_log_level_rec);
6232: end if;
6233:
6234: if ( not (nvl(fa_cache_pkg.fazcbc_record.RETIRE_REVAL_RESERVE_FLAG,'NO') = 'NO'
6235: and reval_reserve <> 0 and (not bk.book_class))) then
6236: return true;
6237: end if;
6238: begin

Line 6255: h_dist_book := FA_CACHE_PKG.fazcbc_record.distribution_source_book;

6251: if h_th_type_code <> 'FULL RETIREMENT' THEN
6252: return true;
6253: end if;
6254:
6255: h_dist_book := FA_CACHE_PKG.fazcbc_record.distribution_source_book;
6256: --initialize common attributes of adj_row
6257: adj_row.transaction_header_id := h_th_id_out;
6258: if ret.wip_asset > 0 then
6259: adj_row.source_type_code := 'CIP RETIREMENT';

Line 6272: adj_row.account := fa_cache_pkg.fazccb_record.REVAL_RESERVE_ACCT;

6268: adj_row.asset_invoice_id := 0;
6269: adj_row.last_update_date := today;
6270: adj_row.current_units := bk.cur_units;
6271: adj_row.units_retired :=ret.units_retired;
6272: adj_row.account := fa_cache_pkg.fazccb_record.REVAL_RESERVE_ACCT;
6273: adj_row.account_type := 'REVAL_RESERVE_ACCT';
6274: adj_row.mrc_sob_type_code := ret.mrc_sob_type_code;
6275: adj_row.set_of_books_id := ret.set_of_books_id;
6276: adj_row.selection_mode := fa_std_types.FA_AJ_SINGLE;