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

Line 18: g_print_debug boolean := fa_cache_pkg.fa_print_debug;

14:
15: TYPE t_number is table of number index by binary_integer;
16: TYPE t_varchar is table of varchar2(150) index by binary_integer;
17:
18: g_print_debug boolean := fa_cache_pkg.fa_print_debug;
19:
20: g_log_level_rec fa_api_types.log_level_rec_type;
21:
22:

Line 216: if not fa_cache_pkg.fazcbc(X_book => p_book_type_code

212: -- Initialize server message stack and debug
213: FA_DEBUG_PKG.Initialize;
214:
215: -- get book information
216: if not fa_cache_pkg.fazcbc(X_book => p_book_type_code
217: ,p_log_level_rec => g_log_level_rec) then
218: raise error_found;
219: end if;
220:

Line 221: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 1000);

217: ,p_log_level_rec => g_log_level_rec) then
218: raise error_found;
219: end if;
220:
221: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 1000);
222: l_dist_source_book := fa_cache_pkg.fazcbc_record.distribution_source_book;
223:
224: fnd_profile.get('FA_GEN_EXPENSE_ACCOUNT', G_gen_expense);
225: fnd_profile.get('FA_PREGEN_ASSET_ACCOUNT', G_pregen_asset_acct);

Line 222: l_dist_source_book := fa_cache_pkg.fazcbc_record.distribution_source_book;

218: raise error_found;
219: end if;
220:
221: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 1000);
222: l_dist_source_book := fa_cache_pkg.fazcbc_record.distribution_source_book;
223:
224: fnd_profile.get('FA_GEN_EXPENSE_ACCOUNT', G_gen_expense);
225: fnd_profile.get('FA_PREGEN_ASSET_ACCOUNT', G_pregen_asset_acct);
226: fnd_profile.get('FA_PREGEN_CAT_ACCOUNT', G_pregen_cat_acct);

Line 247: h_default_ccid := fa_cache_pkg.fazcbc_record.flexbuilder_defaults_ccid;

243: G_pregen_book_acct:= 'Y';
244: end if;
245:
246: /* Get the first period counter of the current Fiscal Year --BUG# 1339219 */
247: h_default_ccid := fa_cache_pkg.fazcbc_record.flexbuilder_defaults_ccid;
248: h_flex_num := fa_cache_pkg.fazcbc_record.accounting_flex_structure;
249: h_book_class := fa_cache_pkg.fazcbc_record.book_class;
250: h_nbv_gain_acct := fa_cache_pkg.fazcbc_record.nbv_retired_gain_acct;
251: h_nbv_loss_acct := fa_cache_pkg.fazcbc_record.nbv_retired_loss_acct;

Line 248: h_flex_num := fa_cache_pkg.fazcbc_record.accounting_flex_structure;

244: end if;
245:
246: /* Get the first period counter of the current Fiscal Year --BUG# 1339219 */
247: h_default_ccid := fa_cache_pkg.fazcbc_record.flexbuilder_defaults_ccid;
248: h_flex_num := fa_cache_pkg.fazcbc_record.accounting_flex_structure;
249: h_book_class := fa_cache_pkg.fazcbc_record.book_class;
250: h_nbv_gain_acct := fa_cache_pkg.fazcbc_record.nbv_retired_gain_acct;
251: h_nbv_loss_acct := fa_cache_pkg.fazcbc_record.nbv_retired_loss_acct;
252: h_pos_gain_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_gain_acct;

Line 249: h_book_class := fa_cache_pkg.fazcbc_record.book_class;

245:
246: /* Get the first period counter of the current Fiscal Year --BUG# 1339219 */
247: h_default_ccid := fa_cache_pkg.fazcbc_record.flexbuilder_defaults_ccid;
248: h_flex_num := fa_cache_pkg.fazcbc_record.accounting_flex_structure;
249: h_book_class := fa_cache_pkg.fazcbc_record.book_class;
250: h_nbv_gain_acct := fa_cache_pkg.fazcbc_record.nbv_retired_gain_acct;
251: h_nbv_loss_acct := fa_cache_pkg.fazcbc_record.nbv_retired_loss_acct;
252: h_pos_gain_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_gain_acct;
253: h_pos_loss_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_loss_acct;

Line 250: h_nbv_gain_acct := fa_cache_pkg.fazcbc_record.nbv_retired_gain_acct;

246: /* Get the first period counter of the current Fiscal Year --BUG# 1339219 */
247: h_default_ccid := fa_cache_pkg.fazcbc_record.flexbuilder_defaults_ccid;
248: h_flex_num := fa_cache_pkg.fazcbc_record.accounting_flex_structure;
249: h_book_class := fa_cache_pkg.fazcbc_record.book_class;
250: h_nbv_gain_acct := fa_cache_pkg.fazcbc_record.nbv_retired_gain_acct;
251: h_nbv_loss_acct := fa_cache_pkg.fazcbc_record.nbv_retired_loss_acct;
252: h_pos_gain_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_gain_acct;
253: h_pos_loss_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_loss_acct;
254: h_pos_clearing_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_clearing_acct;

Line 251: h_nbv_loss_acct := fa_cache_pkg.fazcbc_record.nbv_retired_loss_acct;

247: h_default_ccid := fa_cache_pkg.fazcbc_record.flexbuilder_defaults_ccid;
248: h_flex_num := fa_cache_pkg.fazcbc_record.accounting_flex_structure;
249: h_book_class := fa_cache_pkg.fazcbc_record.book_class;
250: h_nbv_gain_acct := fa_cache_pkg.fazcbc_record.nbv_retired_gain_acct;
251: h_nbv_loss_acct := fa_cache_pkg.fazcbc_record.nbv_retired_loss_acct;
252: h_pos_gain_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_gain_acct;
253: h_pos_loss_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_loss_acct;
254: h_pos_clearing_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_clearing_acct;
255: h_cor_gain_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_gain_acct;

Line 252: h_pos_gain_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_gain_acct;

248: h_flex_num := fa_cache_pkg.fazcbc_record.accounting_flex_structure;
249: h_book_class := fa_cache_pkg.fazcbc_record.book_class;
250: h_nbv_gain_acct := fa_cache_pkg.fazcbc_record.nbv_retired_gain_acct;
251: h_nbv_loss_acct := fa_cache_pkg.fazcbc_record.nbv_retired_loss_acct;
252: h_pos_gain_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_gain_acct;
253: h_pos_loss_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_loss_acct;
254: h_pos_clearing_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_clearing_acct;
255: h_cor_gain_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_gain_acct;
256: h_cor_loss_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_loss_acct;

Line 253: h_pos_loss_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_loss_acct;

249: h_book_class := fa_cache_pkg.fazcbc_record.book_class;
250: h_nbv_gain_acct := fa_cache_pkg.fazcbc_record.nbv_retired_gain_acct;
251: h_nbv_loss_acct := fa_cache_pkg.fazcbc_record.nbv_retired_loss_acct;
252: h_pos_gain_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_gain_acct;
253: h_pos_loss_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_loss_acct;
254: h_pos_clearing_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_clearing_acct;
255: h_cor_gain_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_gain_acct;
256: h_cor_loss_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_loss_acct;
257: h_cor_clearing_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_clearing_acct;

Line 254: h_pos_clearing_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_clearing_acct;

250: h_nbv_gain_acct := fa_cache_pkg.fazcbc_record.nbv_retired_gain_acct;
251: h_nbv_loss_acct := fa_cache_pkg.fazcbc_record.nbv_retired_loss_acct;
252: h_pos_gain_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_gain_acct;
253: h_pos_loss_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_loss_acct;
254: h_pos_clearing_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_clearing_acct;
255: h_cor_gain_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_gain_acct;
256: h_cor_loss_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_loss_acct;
257: h_cor_clearing_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_clearing_acct;
258: h_reval_rsv_gain_acct := fa_cache_pkg.fazcbc_record.reval_rsv_retired_gain_acct;

Line 255: h_cor_gain_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_gain_acct;

251: h_nbv_loss_acct := fa_cache_pkg.fazcbc_record.nbv_retired_loss_acct;
252: h_pos_gain_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_gain_acct;
253: h_pos_loss_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_loss_acct;
254: h_pos_clearing_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_clearing_acct;
255: h_cor_gain_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_gain_acct;
256: h_cor_loss_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_loss_acct;
257: h_cor_clearing_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_clearing_acct;
258: h_reval_rsv_gain_acct := fa_cache_pkg.fazcbc_record.reval_rsv_retired_gain_acct;
259: h_reval_rsv_loss_acct := fa_cache_pkg.fazcbc_record.reval_rsv_retired_loss_acct;

Line 256: h_cor_loss_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_loss_acct;

252: h_pos_gain_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_gain_acct;
253: h_pos_loss_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_loss_acct;
254: h_pos_clearing_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_clearing_acct;
255: h_cor_gain_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_gain_acct;
256: h_cor_loss_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_loss_acct;
257: h_cor_clearing_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_clearing_acct;
258: h_reval_rsv_gain_acct := fa_cache_pkg.fazcbc_record.reval_rsv_retired_gain_acct;
259: h_reval_rsv_loss_acct := fa_cache_pkg.fazcbc_record.reval_rsv_retired_loss_acct;
260: h_deferred_exp_acct := fa_cache_pkg.fazcbc_record.deferred_deprn_expense_acct;

Line 257: h_cor_clearing_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_clearing_acct;

253: h_pos_loss_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_loss_acct;
254: h_pos_clearing_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_clearing_acct;
255: h_cor_gain_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_gain_acct;
256: h_cor_loss_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_loss_acct;
257: h_cor_clearing_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_clearing_acct;
258: h_reval_rsv_gain_acct := fa_cache_pkg.fazcbc_record.reval_rsv_retired_gain_acct;
259: h_reval_rsv_loss_acct := fa_cache_pkg.fazcbc_record.reval_rsv_retired_loss_acct;
260: h_deferred_exp_acct := fa_cache_pkg.fazcbc_record.deferred_deprn_expense_acct;
261: h_deferred_rsv_acct := fa_cache_pkg.fazcbc_record.deferred_deprn_reserve_acct;

Line 258: h_reval_rsv_gain_acct := fa_cache_pkg.fazcbc_record.reval_rsv_retired_gain_acct;

254: h_pos_clearing_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_clearing_acct;
255: h_cor_gain_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_gain_acct;
256: h_cor_loss_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_loss_acct;
257: h_cor_clearing_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_clearing_acct;
258: h_reval_rsv_gain_acct := fa_cache_pkg.fazcbc_record.reval_rsv_retired_gain_acct;
259: h_reval_rsv_loss_acct := fa_cache_pkg.fazcbc_record.reval_rsv_retired_loss_acct;
260: h_deferred_exp_acct := fa_cache_pkg.fazcbc_record.deferred_deprn_expense_acct;
261: h_deferred_rsv_acct := fa_cache_pkg.fazcbc_record.deferred_deprn_reserve_acct;
262: h_deprn_adj_acct := fa_cache_pkg.fazcbc_record.deprn_adjustment_acct;

Line 259: h_reval_rsv_loss_acct := fa_cache_pkg.fazcbc_record.reval_rsv_retired_loss_acct;

255: h_cor_gain_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_gain_acct;
256: h_cor_loss_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_loss_acct;
257: h_cor_clearing_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_clearing_acct;
258: h_reval_rsv_gain_acct := fa_cache_pkg.fazcbc_record.reval_rsv_retired_gain_acct;
259: h_reval_rsv_loss_acct := fa_cache_pkg.fazcbc_record.reval_rsv_retired_loss_acct;
260: h_deferred_exp_acct := fa_cache_pkg.fazcbc_record.deferred_deprn_expense_acct;
261: h_deferred_rsv_acct := fa_cache_pkg.fazcbc_record.deferred_deprn_reserve_acct;
262: h_deprn_adj_acct := fa_cache_pkg.fazcbc_record.deprn_adjustment_acct;
263: h_allow_reval_flag := fa_cache_pkg.fazcbc_record.allow_reval_flag;

Line 260: h_deferred_exp_acct := fa_cache_pkg.fazcbc_record.deferred_deprn_expense_acct;

256: h_cor_loss_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_loss_acct;
257: h_cor_clearing_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_clearing_acct;
258: h_reval_rsv_gain_acct := fa_cache_pkg.fazcbc_record.reval_rsv_retired_gain_acct;
259: h_reval_rsv_loss_acct := fa_cache_pkg.fazcbc_record.reval_rsv_retired_loss_acct;
260: h_deferred_exp_acct := fa_cache_pkg.fazcbc_record.deferred_deprn_expense_acct;
261: h_deferred_rsv_acct := fa_cache_pkg.fazcbc_record.deferred_deprn_reserve_acct;
262: h_deprn_adj_acct := fa_cache_pkg.fazcbc_record.deprn_adjustment_acct;
263: h_allow_reval_flag := fa_cache_pkg.fazcbc_record.allow_reval_flag;
264: h_allow_deprn_adjust := fa_cache_pkg.fazcbc_record.allow_deprn_adjustments;

Line 261: h_deferred_rsv_acct := fa_cache_pkg.fazcbc_record.deferred_deprn_reserve_acct;

257: h_cor_clearing_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_clearing_acct;
258: h_reval_rsv_gain_acct := fa_cache_pkg.fazcbc_record.reval_rsv_retired_gain_acct;
259: h_reval_rsv_loss_acct := fa_cache_pkg.fazcbc_record.reval_rsv_retired_loss_acct;
260: h_deferred_exp_acct := fa_cache_pkg.fazcbc_record.deferred_deprn_expense_acct;
261: h_deferred_rsv_acct := fa_cache_pkg.fazcbc_record.deferred_deprn_reserve_acct;
262: h_deprn_adj_acct := fa_cache_pkg.fazcbc_record.deprn_adjustment_acct;
263: h_allow_reval_flag := fa_cache_pkg.fazcbc_record.allow_reval_flag;
264: h_allow_deprn_adjust := fa_cache_pkg.fazcbc_record.allow_deprn_adjustments;
265: h_gl_posting_allowed := fa_cache_pkg.fazcbc_record.gl_posting_allowed_flag;

Line 262: h_deprn_adj_acct := fa_cache_pkg.fazcbc_record.deprn_adjustment_acct;

258: h_reval_rsv_gain_acct := fa_cache_pkg.fazcbc_record.reval_rsv_retired_gain_acct;
259: h_reval_rsv_loss_acct := fa_cache_pkg.fazcbc_record.reval_rsv_retired_loss_acct;
260: h_deferred_exp_acct := fa_cache_pkg.fazcbc_record.deferred_deprn_expense_acct;
261: h_deferred_rsv_acct := fa_cache_pkg.fazcbc_record.deferred_deprn_reserve_acct;
262: h_deprn_adj_acct := fa_cache_pkg.fazcbc_record.deprn_adjustment_acct;
263: h_allow_reval_flag := fa_cache_pkg.fazcbc_record.allow_reval_flag;
264: h_allow_deprn_adjust := fa_cache_pkg.fazcbc_record.allow_deprn_adjustments;
265: h_gl_posting_allowed := fa_cache_pkg.fazcbc_record.gl_posting_allowed_flag;
266:

Line 263: h_allow_reval_flag := fa_cache_pkg.fazcbc_record.allow_reval_flag;

259: h_reval_rsv_loss_acct := fa_cache_pkg.fazcbc_record.reval_rsv_retired_loss_acct;
260: h_deferred_exp_acct := fa_cache_pkg.fazcbc_record.deferred_deprn_expense_acct;
261: h_deferred_rsv_acct := fa_cache_pkg.fazcbc_record.deferred_deprn_reserve_acct;
262: h_deprn_adj_acct := fa_cache_pkg.fazcbc_record.deprn_adjustment_acct;
263: h_allow_reval_flag := fa_cache_pkg.fazcbc_record.allow_reval_flag;
264: h_allow_deprn_adjust := fa_cache_pkg.fazcbc_record.allow_deprn_adjustments;
265: h_gl_posting_allowed := fa_cache_pkg.fazcbc_record.gl_posting_allowed_flag;
266:
267: select dp.period_counter

Line 264: h_allow_deprn_adjust := fa_cache_pkg.fazcbc_record.allow_deprn_adjustments;

260: h_deferred_exp_acct := fa_cache_pkg.fazcbc_record.deferred_deprn_expense_acct;
261: h_deferred_rsv_acct := fa_cache_pkg.fazcbc_record.deferred_deprn_reserve_acct;
262: h_deprn_adj_acct := fa_cache_pkg.fazcbc_record.deprn_adjustment_acct;
263: h_allow_reval_flag := fa_cache_pkg.fazcbc_record.allow_reval_flag;
264: h_allow_deprn_adjust := fa_cache_pkg.fazcbc_record.allow_deprn_adjustments;
265: h_gl_posting_allowed := fa_cache_pkg.fazcbc_record.gl_posting_allowed_flag;
266:
267: select dp.period_counter
268: into G_FY_first_pc

Line 265: h_gl_posting_allowed := fa_cache_pkg.fazcbc_record.gl_posting_allowed_flag;

261: h_deferred_rsv_acct := fa_cache_pkg.fazcbc_record.deferred_deprn_reserve_acct;
262: h_deprn_adj_acct := fa_cache_pkg.fazcbc_record.deprn_adjustment_acct;
263: h_allow_reval_flag := fa_cache_pkg.fazcbc_record.allow_reval_flag;
264: h_allow_deprn_adjust := fa_cache_pkg.fazcbc_record.allow_deprn_adjustments;
265: h_gl_posting_allowed := fa_cache_pkg.fazcbc_record.gl_posting_allowed_flag;
266:
267: select dp.period_counter
268: into G_FY_first_pc
269: from fa_deprn_periods dp

Line 271: and dp.fiscal_year = fa_cache_pkg.fazcbc_record.current_fiscal_year

267: select dp.period_counter
268: into G_FY_first_pc
269: from fa_deprn_periods dp
270: where dp.book_type_code = p_book_type_code
271: and dp.fiscal_year = fa_cache_pkg.fazcbc_record.current_fiscal_year
272: and dp.period_num =
273: (select min(period_num)
274: from fa_deprn_periods dp2
275: where dp2.book_type_code = p_book_type_code

Line 276: and dp2.fiscal_year = fa_cache_pkg.fazcbc_record.current_fiscal_year);

272: and dp.period_num =
273: (select min(period_num)
274: from fa_deprn_periods dp2
275: where dp2.book_type_code = p_book_type_code
276: and dp2.fiscal_year = fa_cache_pkg.fazcbc_record.current_fiscal_year);
277:
278: if not fa_cache_pkg.fazcdp
279: (x_book_type_code => p_book_type_code,
280: x_period_counter => null,

Line 278: if not fa_cache_pkg.fazcdp

274: from fa_deprn_periods dp2
275: where dp2.book_type_code = p_book_type_code
276: and dp2.fiscal_year = fa_cache_pkg.fazcbc_record.current_fiscal_year);
277:
278: if not fa_cache_pkg.fazcdp
279: (x_book_type_code => p_book_type_code,
280: x_period_counter => null,
281: x_effective_date => null
282: ,p_log_level_rec => g_log_level_rec) then

Line 286: G_validation_date := fa_cache_pkg.fazcdp_record.calendar_period_close_date;

282: ,p_log_level_rec => g_log_level_rec) then
283: raise error_found;
284: end if;
285:
286: G_validation_date := fa_cache_pkg.fazcdp_record.calendar_period_close_date;
287:
288: -- ------------------------------------------
289: -- Loop thru job list
290: -- -----------------------------------------

Line 417: p_dist_source_book => fa_cache_pkg.fazcbc_record.distribution_source_book,

413: end if;
414:
415: OPEN dist
416: (p_book_type_code => p_book_type_code,
417: p_dist_source_book => fa_cache_pkg.fazcbc_record.distribution_source_book,
418: p_fy_first_pc => G_fy_first_pc,
419: p_pregen_asset_acct => G_pregen_asset_acct,
420: p_pregen_cat_acct => G_pregen_cat_acct,
421: p_pregen_book_acct => G_pregen_book_acct,

Line 468: if not (fa_cache_pkg.fazccb(X_book => p_book_type_code,

464: end if;
465:
466: for i in 1..l_dist_id.count loop
467:
468: if not (fa_cache_pkg.fazccb(X_book => p_book_type_code,
469: X_cat_id => l_asset_category_id(i))) then
470: raise error_found;
471: end if;
472:

Line 473: l_cost_acct(i) := fa_cache_pkg.fazccb_record.asset_cost_acct;

469: X_cat_id => l_asset_category_id(i))) then
470: raise error_found;
471: end if;
472:
473: l_cost_acct(i) := fa_cache_pkg.fazccb_record.asset_cost_acct;
474: l_clearing_acct(i) := fa_cache_pkg.fazccb_record.asset_clearing_acct;
475: l_cost_ccid(i) := fa_cache_pkg.fazccb_record.asset_cost_account_ccid;
476: l_clearing_ccid(i) := fa_cache_pkg.fazccb_record.asset_clearing_account_ccid;
477: l_reserve_acct(i) := fa_cache_pkg.fazccb_record.deprn_reserve_acct;

Line 474: l_clearing_acct(i) := fa_cache_pkg.fazccb_record.asset_clearing_acct;

470: raise error_found;
471: end if;
472:
473: l_cost_acct(i) := fa_cache_pkg.fazccb_record.asset_cost_acct;
474: l_clearing_acct(i) := fa_cache_pkg.fazccb_record.asset_clearing_acct;
475: l_cost_ccid(i) := fa_cache_pkg.fazccb_record.asset_cost_account_ccid;
476: l_clearing_ccid(i) := fa_cache_pkg.fazccb_record.asset_clearing_account_ccid;
477: l_reserve_acct(i) := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
478: l_reserve_ccid(i) := fa_cache_pkg.fazccb_record.reserve_account_ccid;

Line 475: l_cost_ccid(i) := fa_cache_pkg.fazccb_record.asset_cost_account_ccid;

471: end if;
472:
473: l_cost_acct(i) := fa_cache_pkg.fazccb_record.asset_cost_acct;
474: l_clearing_acct(i) := fa_cache_pkg.fazccb_record.asset_clearing_acct;
475: l_cost_ccid(i) := fa_cache_pkg.fazccb_record.asset_cost_account_ccid;
476: l_clearing_ccid(i) := fa_cache_pkg.fazccb_record.asset_clearing_account_ccid;
477: l_reserve_acct(i) := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
478: l_reserve_ccid(i) := fa_cache_pkg.fazccb_record.reserve_account_ccid;
479: l_expense_acct(i) := fa_cache_pkg.fazccb_record.deprn_expense_acct;

Line 476: l_clearing_ccid(i) := fa_cache_pkg.fazccb_record.asset_clearing_account_ccid;

472:
473: l_cost_acct(i) := fa_cache_pkg.fazccb_record.asset_cost_acct;
474: l_clearing_acct(i) := fa_cache_pkg.fazccb_record.asset_clearing_acct;
475: l_cost_ccid(i) := fa_cache_pkg.fazccb_record.asset_cost_account_ccid;
476: l_clearing_ccid(i) := fa_cache_pkg.fazccb_record.asset_clearing_account_ccid;
477: l_reserve_acct(i) := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
478: l_reserve_ccid(i) := fa_cache_pkg.fazccb_record.reserve_account_ccid;
479: l_expense_acct(i) := fa_cache_pkg.fazccb_record.deprn_expense_acct;
480: l_cip_cost_acct(i) := fa_cache_pkg.fazccb_record.cip_cost_acct;

Line 477: l_reserve_acct(i) := fa_cache_pkg.fazccb_record.deprn_reserve_acct;

473: l_cost_acct(i) := fa_cache_pkg.fazccb_record.asset_cost_acct;
474: l_clearing_acct(i) := fa_cache_pkg.fazccb_record.asset_clearing_acct;
475: l_cost_ccid(i) := fa_cache_pkg.fazccb_record.asset_cost_account_ccid;
476: l_clearing_ccid(i) := fa_cache_pkg.fazccb_record.asset_clearing_account_ccid;
477: l_reserve_acct(i) := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
478: l_reserve_ccid(i) := fa_cache_pkg.fazccb_record.reserve_account_ccid;
479: l_expense_acct(i) := fa_cache_pkg.fazccb_record.deprn_expense_acct;
480: l_cip_cost_acct(i) := fa_cache_pkg.fazccb_record.cip_cost_acct;
481: l_cip_clearing_acct(i) := fa_cache_pkg.fazccb_record.cip_clearing_acct;

Line 478: l_reserve_ccid(i) := fa_cache_pkg.fazccb_record.reserve_account_ccid;

474: l_clearing_acct(i) := fa_cache_pkg.fazccb_record.asset_clearing_acct;
475: l_cost_ccid(i) := fa_cache_pkg.fazccb_record.asset_cost_account_ccid;
476: l_clearing_ccid(i) := fa_cache_pkg.fazccb_record.asset_clearing_account_ccid;
477: l_reserve_acct(i) := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
478: l_reserve_ccid(i) := fa_cache_pkg.fazccb_record.reserve_account_ccid;
479: l_expense_acct(i) := fa_cache_pkg.fazccb_record.deprn_expense_acct;
480: l_cip_cost_acct(i) := fa_cache_pkg.fazccb_record.cip_cost_acct;
481: l_cip_clearing_acct(i) := fa_cache_pkg.fazccb_record.cip_clearing_acct;
482: l_cip_cost_ccid(i) := fa_cache_pkg.fazccb_record.wip_cost_account_ccid;

Line 479: l_expense_acct(i) := fa_cache_pkg.fazccb_record.deprn_expense_acct;

475: l_cost_ccid(i) := fa_cache_pkg.fazccb_record.asset_cost_account_ccid;
476: l_clearing_ccid(i) := fa_cache_pkg.fazccb_record.asset_clearing_account_ccid;
477: l_reserve_acct(i) := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
478: l_reserve_ccid(i) := fa_cache_pkg.fazccb_record.reserve_account_ccid;
479: l_expense_acct(i) := fa_cache_pkg.fazccb_record.deprn_expense_acct;
480: l_cip_cost_acct(i) := fa_cache_pkg.fazccb_record.cip_cost_acct;
481: l_cip_clearing_acct(i) := fa_cache_pkg.fazccb_record.cip_clearing_acct;
482: l_cip_cost_ccid(i) := fa_cache_pkg.fazccb_record.wip_cost_account_ccid;
483: l_cip_clearing_ccid(i) := fa_cache_pkg.fazccb_record.wip_clearing_account_ccid;

Line 480: l_cip_cost_acct(i) := fa_cache_pkg.fazccb_record.cip_cost_acct;

476: l_clearing_ccid(i) := fa_cache_pkg.fazccb_record.asset_clearing_account_ccid;
477: l_reserve_acct(i) := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
478: l_reserve_ccid(i) := fa_cache_pkg.fazccb_record.reserve_account_ccid;
479: l_expense_acct(i) := fa_cache_pkg.fazccb_record.deprn_expense_acct;
480: l_cip_cost_acct(i) := fa_cache_pkg.fazccb_record.cip_cost_acct;
481: l_cip_clearing_acct(i) := fa_cache_pkg.fazccb_record.cip_clearing_acct;
482: l_cip_cost_ccid(i) := fa_cache_pkg.fazccb_record.wip_cost_account_ccid;
483: l_cip_clearing_ccid(i) := fa_cache_pkg.fazccb_record.wip_clearing_account_ccid;
484: l_reval_amort_acct(i) := fa_cache_pkg.fazccb_record.reval_amortization_acct;

Line 481: l_cip_clearing_acct(i) := fa_cache_pkg.fazccb_record.cip_clearing_acct;

477: l_reserve_acct(i) := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
478: l_reserve_ccid(i) := fa_cache_pkg.fazccb_record.reserve_account_ccid;
479: l_expense_acct(i) := fa_cache_pkg.fazccb_record.deprn_expense_acct;
480: l_cip_cost_acct(i) := fa_cache_pkg.fazccb_record.cip_cost_acct;
481: l_cip_clearing_acct(i) := fa_cache_pkg.fazccb_record.cip_clearing_acct;
482: l_cip_cost_ccid(i) := fa_cache_pkg.fazccb_record.wip_cost_account_ccid;
483: l_cip_clearing_ccid(i) := fa_cache_pkg.fazccb_record.wip_clearing_account_ccid;
484: l_reval_amort_acct(i) := fa_cache_pkg.fazccb_record.reval_amortization_acct;
485: l_reval_amort_ccid(i) := fa_cache_pkg.fazccb_record.reval_amort_account_ccid;

Line 482: l_cip_cost_ccid(i) := fa_cache_pkg.fazccb_record.wip_cost_account_ccid;

478: l_reserve_ccid(i) := fa_cache_pkg.fazccb_record.reserve_account_ccid;
479: l_expense_acct(i) := fa_cache_pkg.fazccb_record.deprn_expense_acct;
480: l_cip_cost_acct(i) := fa_cache_pkg.fazccb_record.cip_cost_acct;
481: l_cip_clearing_acct(i) := fa_cache_pkg.fazccb_record.cip_clearing_acct;
482: l_cip_cost_ccid(i) := fa_cache_pkg.fazccb_record.wip_cost_account_ccid;
483: l_cip_clearing_ccid(i) := fa_cache_pkg.fazccb_record.wip_clearing_account_ccid;
484: l_reval_amort_acct(i) := fa_cache_pkg.fazccb_record.reval_amortization_acct;
485: l_reval_amort_ccid(i) := fa_cache_pkg.fazccb_record.reval_amort_account_ccid;
486: l_reval_rsv_acct(i) := fa_cache_pkg.fazccb_record.reval_reserve_acct;

Line 483: l_cip_clearing_ccid(i) := fa_cache_pkg.fazccb_record.wip_clearing_account_ccid;

479: l_expense_acct(i) := fa_cache_pkg.fazccb_record.deprn_expense_acct;
480: l_cip_cost_acct(i) := fa_cache_pkg.fazccb_record.cip_cost_acct;
481: l_cip_clearing_acct(i) := fa_cache_pkg.fazccb_record.cip_clearing_acct;
482: l_cip_cost_ccid(i) := fa_cache_pkg.fazccb_record.wip_cost_account_ccid;
483: l_cip_clearing_ccid(i) := fa_cache_pkg.fazccb_record.wip_clearing_account_ccid;
484: l_reval_amort_acct(i) := fa_cache_pkg.fazccb_record.reval_amortization_acct;
485: l_reval_amort_ccid(i) := fa_cache_pkg.fazccb_record.reval_amort_account_ccid;
486: l_reval_rsv_acct(i) := fa_cache_pkg.fazccb_record.reval_reserve_acct;
487: l_reval_rsv_ccid(i) := fa_cache_pkg.fazccb_record.reval_reserve_account_ccid;

Line 484: l_reval_amort_acct(i) := fa_cache_pkg.fazccb_record.reval_amortization_acct;

480: l_cip_cost_acct(i) := fa_cache_pkg.fazccb_record.cip_cost_acct;
481: l_cip_clearing_acct(i) := fa_cache_pkg.fazccb_record.cip_clearing_acct;
482: l_cip_cost_ccid(i) := fa_cache_pkg.fazccb_record.wip_cost_account_ccid;
483: l_cip_clearing_ccid(i) := fa_cache_pkg.fazccb_record.wip_clearing_account_ccid;
484: l_reval_amort_acct(i) := fa_cache_pkg.fazccb_record.reval_amortization_acct;
485: l_reval_amort_ccid(i) := fa_cache_pkg.fazccb_record.reval_amort_account_ccid;
486: l_reval_rsv_acct(i) := fa_cache_pkg.fazccb_record.reval_reserve_acct;
487: l_reval_rsv_ccid(i) := fa_cache_pkg.fazccb_record.reval_reserve_account_ccid;
488: l_bonus_exp_acct(i) := fa_cache_pkg.fazccb_record.bonus_deprn_expense_acct;

Line 485: l_reval_amort_ccid(i) := fa_cache_pkg.fazccb_record.reval_amort_account_ccid;

481: l_cip_clearing_acct(i) := fa_cache_pkg.fazccb_record.cip_clearing_acct;
482: l_cip_cost_ccid(i) := fa_cache_pkg.fazccb_record.wip_cost_account_ccid;
483: l_cip_clearing_ccid(i) := fa_cache_pkg.fazccb_record.wip_clearing_account_ccid;
484: l_reval_amort_acct(i) := fa_cache_pkg.fazccb_record.reval_amortization_acct;
485: l_reval_amort_ccid(i) := fa_cache_pkg.fazccb_record.reval_amort_account_ccid;
486: l_reval_rsv_acct(i) := fa_cache_pkg.fazccb_record.reval_reserve_acct;
487: l_reval_rsv_ccid(i) := fa_cache_pkg.fazccb_record.reval_reserve_account_ccid;
488: l_bonus_exp_acct(i) := fa_cache_pkg.fazccb_record.bonus_deprn_expense_acct;
489: l_bonus_rsv_acct(i) := fa_cache_pkg.fazccb_record.bonus_deprn_reserve_acct;

Line 486: l_reval_rsv_acct(i) := fa_cache_pkg.fazccb_record.reval_reserve_acct;

482: l_cip_cost_ccid(i) := fa_cache_pkg.fazccb_record.wip_cost_account_ccid;
483: l_cip_clearing_ccid(i) := fa_cache_pkg.fazccb_record.wip_clearing_account_ccid;
484: l_reval_amort_acct(i) := fa_cache_pkg.fazccb_record.reval_amortization_acct;
485: l_reval_amort_ccid(i) := fa_cache_pkg.fazccb_record.reval_amort_account_ccid;
486: l_reval_rsv_acct(i) := fa_cache_pkg.fazccb_record.reval_reserve_acct;
487: l_reval_rsv_ccid(i) := fa_cache_pkg.fazccb_record.reval_reserve_account_ccid;
488: l_bonus_exp_acct(i) := fa_cache_pkg.fazccb_record.bonus_deprn_expense_acct;
489: l_bonus_rsv_acct(i) := fa_cache_pkg.fazccb_record.bonus_deprn_reserve_acct;
490: l_bonus_rsv_ccid(i) := fa_cache_pkg.fazccb_record.bonus_reserve_acct_ccid;

Line 487: l_reval_rsv_ccid(i) := fa_cache_pkg.fazccb_record.reval_reserve_account_ccid;

483: l_cip_clearing_ccid(i) := fa_cache_pkg.fazccb_record.wip_clearing_account_ccid;
484: l_reval_amort_acct(i) := fa_cache_pkg.fazccb_record.reval_amortization_acct;
485: l_reval_amort_ccid(i) := fa_cache_pkg.fazccb_record.reval_amort_account_ccid;
486: l_reval_rsv_acct(i) := fa_cache_pkg.fazccb_record.reval_reserve_acct;
487: l_reval_rsv_ccid(i) := fa_cache_pkg.fazccb_record.reval_reserve_account_ccid;
488: l_bonus_exp_acct(i) := fa_cache_pkg.fazccb_record.bonus_deprn_expense_acct;
489: l_bonus_rsv_acct(i) := fa_cache_pkg.fazccb_record.bonus_deprn_reserve_acct;
490: l_bonus_rsv_ccid(i) := fa_cache_pkg.fazccb_record.bonus_reserve_acct_ccid;
491:

Line 488: l_bonus_exp_acct(i) := fa_cache_pkg.fazccb_record.bonus_deprn_expense_acct;

484: l_reval_amort_acct(i) := fa_cache_pkg.fazccb_record.reval_amortization_acct;
485: l_reval_amort_ccid(i) := fa_cache_pkg.fazccb_record.reval_amort_account_ccid;
486: l_reval_rsv_acct(i) := fa_cache_pkg.fazccb_record.reval_reserve_acct;
487: l_reval_rsv_ccid(i) := fa_cache_pkg.fazccb_record.reval_reserve_account_ccid;
488: l_bonus_exp_acct(i) := fa_cache_pkg.fazccb_record.bonus_deprn_expense_acct;
489: l_bonus_rsv_acct(i) := fa_cache_pkg.fazccb_record.bonus_deprn_reserve_acct;
490: l_bonus_rsv_ccid(i) := fa_cache_pkg.fazccb_record.bonus_reserve_acct_ccid;
491:
492: end loop;

Line 489: l_bonus_rsv_acct(i) := fa_cache_pkg.fazccb_record.bonus_deprn_reserve_acct;

485: l_reval_amort_ccid(i) := fa_cache_pkg.fazccb_record.reval_amort_account_ccid;
486: l_reval_rsv_acct(i) := fa_cache_pkg.fazccb_record.reval_reserve_acct;
487: l_reval_rsv_ccid(i) := fa_cache_pkg.fazccb_record.reval_reserve_account_ccid;
488: l_bonus_exp_acct(i) := fa_cache_pkg.fazccb_record.bonus_deprn_expense_acct;
489: l_bonus_rsv_acct(i) := fa_cache_pkg.fazccb_record.bonus_deprn_reserve_acct;
490: l_bonus_rsv_ccid(i) := fa_cache_pkg.fazccb_record.bonus_reserve_acct_ccid;
491:
492: end loop;
493:

Line 490: l_bonus_rsv_ccid(i) := fa_cache_pkg.fazccb_record.bonus_reserve_acct_ccid;

486: l_reval_rsv_acct(i) := fa_cache_pkg.fazccb_record.reval_reserve_acct;
487: l_reval_rsv_ccid(i) := fa_cache_pkg.fazccb_record.reval_reserve_account_ccid;
488: l_bonus_exp_acct(i) := fa_cache_pkg.fazccb_record.bonus_deprn_expense_acct;
489: l_bonus_rsv_acct(i) := fa_cache_pkg.fazccb_record.bonus_deprn_reserve_acct;
490: l_bonus_rsv_ccid(i) := fa_cache_pkg.fazccb_record.bonus_reserve_acct_ccid;
491:
492: end loop;
493:
494: else

Line 1885: if not (fa_cache_pkg.fazcbc(x_book => p_book_type_code

1881: raise error_found;
1882: end if;
1883: end if;
1884:
1885: if not (fa_cache_pkg.fazcbc(x_book => p_book_type_code
1886: ,p_log_level_rec => g_log_level_rec)) then
1887: raise error_found;
1888: end if;
1889:

Line 1890: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 1000);

1886: ,p_log_level_rec => g_log_level_rec)) then
1887: raise error_found;
1888: end if;
1889:
1890: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 1000);
1891: l_dist_source_book := fa_cache_pkg.fazcbc_record.distribution_source_book;
1892:
1893: INSERT INTO FA_WORKER_JOBS
1894: (START_RANGE, END_RANGE, WORKER_NUM, STATUS,REQUEST_ID)

Line 1891: l_dist_source_book := fa_cache_pkg.fazcbc_record.distribution_source_book;

1887: raise error_found;
1888: end if;
1889:
1890: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 1000);
1891: l_dist_source_book := fa_cache_pkg.fazcbc_record.distribution_source_book;
1892:
1893: INSERT INTO FA_WORKER_JOBS
1894: (START_RANGE, END_RANGE, WORKER_NUM, STATUS,REQUEST_ID)
1895: SELECT MIN(DISTRIBUTION_ID), MAX(DISTRIBUTION_ID), 0,