APPS.FA_GENACCTS_PKG dependencies on FA_CACHE_PKG

Line 235: if not fa_cache_pkg.fazcbc(X_book => p_book_type_code, p_log_level_rec => g_log_level_rec) then

231: -- Initialize server message stack and debug
232: FA_DEBUG_PKG.Initialize;
233:
234: -- get book information
235: if not fa_cache_pkg.fazcbc(X_book => p_book_type_code, p_log_level_rec => g_log_level_rec) then
236: raise error_found;
237: end if;
238:
239: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 1000);

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

235: if not fa_cache_pkg.fazcbc(X_book => p_book_type_code, p_log_level_rec => g_log_level_rec) then
236: raise error_found;
237: end if;
238:
239: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 1000);
240: l_dist_source_book := fa_cache_pkg.fazcbc_record.distribution_source_book;
241:
242: fnd_profile.get('FA_GEN_EXPENSE_ACCOUNT', G_gen_expense);
243: fnd_profile.get('FA_PREGEN_ASSET_ACCOUNT', G_pregen_asset_acct);

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

236: raise error_found;
237: end if;
238:
239: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 1000);
240: l_dist_source_book := fa_cache_pkg.fazcbc_record.distribution_source_book;
241:
242: fnd_profile.get('FA_GEN_EXPENSE_ACCOUNT', G_gen_expense);
243: fnd_profile.get('FA_PREGEN_ASSET_ACCOUNT', G_pregen_asset_acct);
244: fnd_profile.get('FA_PREGEN_CAT_ACCOUNT', G_pregen_cat_acct);

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

261: G_pregen_book_acct:= 'Y';
262: end if;
263:
264: /* Get the first period counter of the current Fiscal Year --BUG# 1339219 */
265: h_default_ccid := fa_cache_pkg.fazcbc_record.flexbuilder_defaults_ccid;
266: h_flex_num := fa_cache_pkg.fazcbc_record.accounting_flex_structure;
267: h_book_class := fa_cache_pkg.fazcbc_record.book_class;
268: h_nbv_gain_acct := fa_cache_pkg.fazcbc_record.nbv_retired_gain_acct;
269: h_nbv_loss_acct := fa_cache_pkg.fazcbc_record.nbv_retired_loss_acct;

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

262: end if;
263:
264: /* Get the first period counter of the current Fiscal Year --BUG# 1339219 */
265: h_default_ccid := fa_cache_pkg.fazcbc_record.flexbuilder_defaults_ccid;
266: h_flex_num := fa_cache_pkg.fazcbc_record.accounting_flex_structure;
267: h_book_class := fa_cache_pkg.fazcbc_record.book_class;
268: h_nbv_gain_acct := fa_cache_pkg.fazcbc_record.nbv_retired_gain_acct;
269: h_nbv_loss_acct := fa_cache_pkg.fazcbc_record.nbv_retired_loss_acct;
270: h_pos_gain_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_gain_acct;

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

263:
264: /* Get the first period counter of the current Fiscal Year --BUG# 1339219 */
265: h_default_ccid := fa_cache_pkg.fazcbc_record.flexbuilder_defaults_ccid;
266: h_flex_num := fa_cache_pkg.fazcbc_record.accounting_flex_structure;
267: h_book_class := fa_cache_pkg.fazcbc_record.book_class;
268: h_nbv_gain_acct := fa_cache_pkg.fazcbc_record.nbv_retired_gain_acct;
269: h_nbv_loss_acct := fa_cache_pkg.fazcbc_record.nbv_retired_loss_acct;
270: h_pos_gain_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_gain_acct;
271: h_pos_loss_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_loss_acct;

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

264: /* Get the first period counter of the current Fiscal Year --BUG# 1339219 */
265: h_default_ccid := fa_cache_pkg.fazcbc_record.flexbuilder_defaults_ccid;
266: h_flex_num := fa_cache_pkg.fazcbc_record.accounting_flex_structure;
267: h_book_class := fa_cache_pkg.fazcbc_record.book_class;
268: h_nbv_gain_acct := fa_cache_pkg.fazcbc_record.nbv_retired_gain_acct;
269: h_nbv_loss_acct := fa_cache_pkg.fazcbc_record.nbv_retired_loss_acct;
270: h_pos_gain_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_gain_acct;
271: h_pos_loss_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_loss_acct;
272: h_pos_clearing_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_clearing_acct;

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

265: h_default_ccid := fa_cache_pkg.fazcbc_record.flexbuilder_defaults_ccid;
266: h_flex_num := fa_cache_pkg.fazcbc_record.accounting_flex_structure;
267: h_book_class := fa_cache_pkg.fazcbc_record.book_class;
268: h_nbv_gain_acct := fa_cache_pkg.fazcbc_record.nbv_retired_gain_acct;
269: h_nbv_loss_acct := fa_cache_pkg.fazcbc_record.nbv_retired_loss_acct;
270: h_pos_gain_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_gain_acct;
271: h_pos_loss_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_loss_acct;
272: h_pos_clearing_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_clearing_acct;
273: h_cor_gain_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_gain_acct;

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

266: h_flex_num := fa_cache_pkg.fazcbc_record.accounting_flex_structure;
267: h_book_class := fa_cache_pkg.fazcbc_record.book_class;
268: h_nbv_gain_acct := fa_cache_pkg.fazcbc_record.nbv_retired_gain_acct;
269: h_nbv_loss_acct := fa_cache_pkg.fazcbc_record.nbv_retired_loss_acct;
270: h_pos_gain_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_gain_acct;
271: h_pos_loss_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_loss_acct;
272: h_pos_clearing_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_clearing_acct;
273: h_cor_gain_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_gain_acct;
274: h_cor_loss_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_loss_acct;

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

267: h_book_class := fa_cache_pkg.fazcbc_record.book_class;
268: h_nbv_gain_acct := fa_cache_pkg.fazcbc_record.nbv_retired_gain_acct;
269: h_nbv_loss_acct := fa_cache_pkg.fazcbc_record.nbv_retired_loss_acct;
270: h_pos_gain_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_gain_acct;
271: h_pos_loss_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_loss_acct;
272: h_pos_clearing_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_clearing_acct;
273: h_cor_gain_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_gain_acct;
274: h_cor_loss_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_loss_acct;
275: h_cor_clearing_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_clearing_acct;

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

268: h_nbv_gain_acct := fa_cache_pkg.fazcbc_record.nbv_retired_gain_acct;
269: h_nbv_loss_acct := fa_cache_pkg.fazcbc_record.nbv_retired_loss_acct;
270: h_pos_gain_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_gain_acct;
271: h_pos_loss_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_loss_acct;
272: h_pos_clearing_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_clearing_acct;
273: h_cor_gain_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_gain_acct;
274: h_cor_loss_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_loss_acct;
275: h_cor_clearing_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_clearing_acct;
276: h_reval_rsv_gain_acct := fa_cache_pkg.fazcbc_record.reval_rsv_retired_gain_acct;

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

269: h_nbv_loss_acct := fa_cache_pkg.fazcbc_record.nbv_retired_loss_acct;
270: h_pos_gain_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_gain_acct;
271: h_pos_loss_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_loss_acct;
272: h_pos_clearing_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_clearing_acct;
273: h_cor_gain_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_gain_acct;
274: h_cor_loss_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_loss_acct;
275: h_cor_clearing_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_clearing_acct;
276: h_reval_rsv_gain_acct := fa_cache_pkg.fazcbc_record.reval_rsv_retired_gain_acct;
277: h_reval_rsv_loss_acct := fa_cache_pkg.fazcbc_record.reval_rsv_retired_loss_acct;

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

270: h_pos_gain_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_gain_acct;
271: h_pos_loss_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_loss_acct;
272: h_pos_clearing_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_clearing_acct;
273: h_cor_gain_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_gain_acct;
274: h_cor_loss_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_loss_acct;
275: h_cor_clearing_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_clearing_acct;
276: h_reval_rsv_gain_acct := fa_cache_pkg.fazcbc_record.reval_rsv_retired_gain_acct;
277: h_reval_rsv_loss_acct := fa_cache_pkg.fazcbc_record.reval_rsv_retired_loss_acct;
278: h_deferred_exp_acct := fa_cache_pkg.fazcbc_record.deferred_deprn_expense_acct;

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

271: h_pos_loss_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_loss_acct;
272: h_pos_clearing_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_clearing_acct;
273: h_cor_gain_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_gain_acct;
274: h_cor_loss_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_loss_acct;
275: h_cor_clearing_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_clearing_acct;
276: h_reval_rsv_gain_acct := fa_cache_pkg.fazcbc_record.reval_rsv_retired_gain_acct;
277: h_reval_rsv_loss_acct := fa_cache_pkg.fazcbc_record.reval_rsv_retired_loss_acct;
278: h_deferred_exp_acct := fa_cache_pkg.fazcbc_record.deferred_deprn_expense_acct;
279: h_deferred_rsv_acct := fa_cache_pkg.fazcbc_record.deferred_deprn_reserve_acct;

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

272: h_pos_clearing_acct := fa_cache_pkg.fazcbc_record.proceeds_of_sale_clearing_acct;
273: h_cor_gain_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_gain_acct;
274: h_cor_loss_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_loss_acct;
275: h_cor_clearing_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_clearing_acct;
276: h_reval_rsv_gain_acct := fa_cache_pkg.fazcbc_record.reval_rsv_retired_gain_acct;
277: h_reval_rsv_loss_acct := fa_cache_pkg.fazcbc_record.reval_rsv_retired_loss_acct;
278: h_deferred_exp_acct := fa_cache_pkg.fazcbc_record.deferred_deprn_expense_acct;
279: h_deferred_rsv_acct := fa_cache_pkg.fazcbc_record.deferred_deprn_reserve_acct;
280: h_deprn_adj_acct := fa_cache_pkg.fazcbc_record.deprn_adjustment_acct;

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

273: h_cor_gain_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_gain_acct;
274: h_cor_loss_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_loss_acct;
275: h_cor_clearing_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_clearing_acct;
276: h_reval_rsv_gain_acct := fa_cache_pkg.fazcbc_record.reval_rsv_retired_gain_acct;
277: h_reval_rsv_loss_acct := fa_cache_pkg.fazcbc_record.reval_rsv_retired_loss_acct;
278: h_deferred_exp_acct := fa_cache_pkg.fazcbc_record.deferred_deprn_expense_acct;
279: h_deferred_rsv_acct := fa_cache_pkg.fazcbc_record.deferred_deprn_reserve_acct;
280: h_deprn_adj_acct := fa_cache_pkg.fazcbc_record.deprn_adjustment_acct;
281: h_allow_reval_flag := fa_cache_pkg.fazcbc_record.allow_reval_flag;

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

274: h_cor_loss_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_loss_acct;
275: h_cor_clearing_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_clearing_acct;
276: h_reval_rsv_gain_acct := fa_cache_pkg.fazcbc_record.reval_rsv_retired_gain_acct;
277: h_reval_rsv_loss_acct := fa_cache_pkg.fazcbc_record.reval_rsv_retired_loss_acct;
278: h_deferred_exp_acct := fa_cache_pkg.fazcbc_record.deferred_deprn_expense_acct;
279: h_deferred_rsv_acct := fa_cache_pkg.fazcbc_record.deferred_deprn_reserve_acct;
280: h_deprn_adj_acct := fa_cache_pkg.fazcbc_record.deprn_adjustment_acct;
281: h_allow_reval_flag := fa_cache_pkg.fazcbc_record.allow_reval_flag;
282: h_allow_deprn_adjust := fa_cache_pkg.fazcbc_record.allow_deprn_adjustments;

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

275: h_cor_clearing_acct := fa_cache_pkg.fazcbc_record.cost_of_removal_clearing_acct;
276: h_reval_rsv_gain_acct := fa_cache_pkg.fazcbc_record.reval_rsv_retired_gain_acct;
277: h_reval_rsv_loss_acct := fa_cache_pkg.fazcbc_record.reval_rsv_retired_loss_acct;
278: h_deferred_exp_acct := fa_cache_pkg.fazcbc_record.deferred_deprn_expense_acct;
279: h_deferred_rsv_acct := fa_cache_pkg.fazcbc_record.deferred_deprn_reserve_acct;
280: h_deprn_adj_acct := fa_cache_pkg.fazcbc_record.deprn_adjustment_acct;
281: h_allow_reval_flag := fa_cache_pkg.fazcbc_record.allow_reval_flag;
282: h_allow_deprn_adjust := fa_cache_pkg.fazcbc_record.allow_deprn_adjustments;
283: h_gl_posting_allowed := fa_cache_pkg.fazcbc_record.gl_posting_allowed_flag;

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

276: h_reval_rsv_gain_acct := fa_cache_pkg.fazcbc_record.reval_rsv_retired_gain_acct;
277: h_reval_rsv_loss_acct := fa_cache_pkg.fazcbc_record.reval_rsv_retired_loss_acct;
278: h_deferred_exp_acct := fa_cache_pkg.fazcbc_record.deferred_deprn_expense_acct;
279: h_deferred_rsv_acct := fa_cache_pkg.fazcbc_record.deferred_deprn_reserve_acct;
280: h_deprn_adj_acct := fa_cache_pkg.fazcbc_record.deprn_adjustment_acct;
281: h_allow_reval_flag := fa_cache_pkg.fazcbc_record.allow_reval_flag;
282: h_allow_deprn_adjust := fa_cache_pkg.fazcbc_record.allow_deprn_adjustments;
283: h_gl_posting_allowed := fa_cache_pkg.fazcbc_record.gl_posting_allowed_flag;
284: h_allow_impairment_flag := nvl(fa_cache_pkg.fazcbc_record.allow_impairment_flag, 'N');

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

277: h_reval_rsv_loss_acct := fa_cache_pkg.fazcbc_record.reval_rsv_retired_loss_acct;
278: h_deferred_exp_acct := fa_cache_pkg.fazcbc_record.deferred_deprn_expense_acct;
279: h_deferred_rsv_acct := fa_cache_pkg.fazcbc_record.deferred_deprn_reserve_acct;
280: h_deprn_adj_acct := fa_cache_pkg.fazcbc_record.deprn_adjustment_acct;
281: h_allow_reval_flag := fa_cache_pkg.fazcbc_record.allow_reval_flag;
282: h_allow_deprn_adjust := fa_cache_pkg.fazcbc_record.allow_deprn_adjustments;
283: h_gl_posting_allowed := fa_cache_pkg.fazcbc_record.gl_posting_allowed_flag;
284: h_allow_impairment_flag := nvl(fa_cache_pkg.fazcbc_record.allow_impairment_flag, 'N');
285: h_allow_sorp_flag := nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag, 'N'); -- Bug 6666666

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

278: h_deferred_exp_acct := fa_cache_pkg.fazcbc_record.deferred_deprn_expense_acct;
279: h_deferred_rsv_acct := fa_cache_pkg.fazcbc_record.deferred_deprn_reserve_acct;
280: h_deprn_adj_acct := fa_cache_pkg.fazcbc_record.deprn_adjustment_acct;
281: h_allow_reval_flag := fa_cache_pkg.fazcbc_record.allow_reval_flag;
282: h_allow_deprn_adjust := fa_cache_pkg.fazcbc_record.allow_deprn_adjustments;
283: h_gl_posting_allowed := fa_cache_pkg.fazcbc_record.gl_posting_allowed_flag;
284: h_allow_impairment_flag := nvl(fa_cache_pkg.fazcbc_record.allow_impairment_flag, 'N');
285: h_allow_sorp_flag := nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag, 'N'); -- Bug 6666666
286:

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

279: h_deferred_rsv_acct := fa_cache_pkg.fazcbc_record.deferred_deprn_reserve_acct;
280: h_deprn_adj_acct := fa_cache_pkg.fazcbc_record.deprn_adjustment_acct;
281: h_allow_reval_flag := fa_cache_pkg.fazcbc_record.allow_reval_flag;
282: h_allow_deprn_adjust := fa_cache_pkg.fazcbc_record.allow_deprn_adjustments;
283: h_gl_posting_allowed := fa_cache_pkg.fazcbc_record.gl_posting_allowed_flag;
284: h_allow_impairment_flag := nvl(fa_cache_pkg.fazcbc_record.allow_impairment_flag, 'N');
285: h_allow_sorp_flag := nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag, 'N'); -- Bug 6666666
286:
287: if g_log_level_rec.statement_level then

Line 284: h_allow_impairment_flag := nvl(fa_cache_pkg.fazcbc_record.allow_impairment_flag, 'N');

280: h_deprn_adj_acct := fa_cache_pkg.fazcbc_record.deprn_adjustment_acct;
281: h_allow_reval_flag := fa_cache_pkg.fazcbc_record.allow_reval_flag;
282: h_allow_deprn_adjust := fa_cache_pkg.fazcbc_record.allow_deprn_adjustments;
283: h_gl_posting_allowed := fa_cache_pkg.fazcbc_record.gl_posting_allowed_flag;
284: h_allow_impairment_flag := nvl(fa_cache_pkg.fazcbc_record.allow_impairment_flag, 'N');
285: h_allow_sorp_flag := nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag, 'N'); -- Bug 6666666
286:
287: if g_log_level_rec.statement_level then
288: fa_debug_pkg.add(l_calling_fn,'Sorp Enabled Flag',h_allow_sorp_flag, p_log_level_rec => g_log_level_rec);

Line 285: h_allow_sorp_flag := nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag, 'N'); -- Bug 6666666

281: h_allow_reval_flag := fa_cache_pkg.fazcbc_record.allow_reval_flag;
282: h_allow_deprn_adjust := fa_cache_pkg.fazcbc_record.allow_deprn_adjustments;
283: h_gl_posting_allowed := fa_cache_pkg.fazcbc_record.gl_posting_allowed_flag;
284: h_allow_impairment_flag := nvl(fa_cache_pkg.fazcbc_record.allow_impairment_flag, 'N');
285: h_allow_sorp_flag := nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag, 'N'); -- Bug 6666666
286:
287: if g_log_level_rec.statement_level then
288: fa_debug_pkg.add(l_calling_fn,'Sorp Enabled Flag',h_allow_sorp_flag, p_log_level_rec => g_log_level_rec);
289: end if;

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

291: select dp.period_counter
292: into G_FY_first_pc
293: from fa_deprn_periods dp
294: where dp.book_type_code = p_book_type_code
295: and dp.fiscal_year = fa_cache_pkg.fazcbc_record.current_fiscal_year
296: and dp.period_num =
297: (select min(period_num)
298: from fa_deprn_periods dp2
299: where dp2.book_type_code = p_book_type_code

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

296: and dp.period_num =
297: (select min(period_num)
298: from fa_deprn_periods dp2
299: where dp2.book_type_code = p_book_type_code
300: and dp2.fiscal_year = fa_cache_pkg.fazcbc_record.current_fiscal_year);
301:
302: if not fa_cache_pkg.fazcdp
303: (x_book_type_code => p_book_type_code,
304: x_period_counter => null,

Line 302: if not fa_cache_pkg.fazcdp

298: from fa_deprn_periods dp2
299: where dp2.book_type_code = p_book_type_code
300: and dp2.fiscal_year = fa_cache_pkg.fazcbc_record.current_fiscal_year);
301:
302: if not fa_cache_pkg.fazcdp
303: (x_book_type_code => p_book_type_code,
304: x_period_counter => null,
305: x_effective_date => null, p_log_level_rec => g_log_level_rec) then
306: raise error_found;

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

305: x_effective_date => null, p_log_level_rec => g_log_level_rec) then
306: raise error_found;
307: end if;
308:
309: G_validation_date := fa_cache_pkg.fazcdp_record.calendar_period_close_date;
310:
311: -- ------------------------------------------
312: -- Loop thru job list
313: -- -----------------------------------------

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

405: end if;
406:
407: OPEN dist
408: (p_book_type_code => p_book_type_code,
409: p_dist_source_book => fa_cache_pkg.fazcbc_record.distribution_source_book,
410: p_fy_first_pc => G_fy_first_pc,
411: p_pregen_asset_acct => G_pregen_asset_acct,
412: p_pregen_cat_acct => G_pregen_cat_acct,
413: p_pregen_book_acct => G_pregen_book_acct,

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

455: end if;
456:
457: for i in 1..l_dist_id.count loop
458:
459: if not (fa_cache_pkg.fazccb(X_book => p_book_type_code,
460: X_cat_id => l_asset_category_id(i),
461: p_log_level_rec => g_log_level_rec)) then
462: raise error_found;
463: end if;

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

461: p_log_level_rec => g_log_level_rec)) then
462: raise error_found;
463: end if;
464:
465: l_cost_acct(i) := fa_cache_pkg.fazccb_record.asset_cost_acct;
466: l_clearing_acct(i) := fa_cache_pkg.fazccb_record.asset_clearing_acct;
467: l_cost_ccid(i) := fa_cache_pkg.fazccb_record.asset_cost_account_ccid;
468: l_clearing_ccid(i) := fa_cache_pkg.fazccb_record.asset_clearing_account_ccid;
469: l_reserve_acct(i) := fa_cache_pkg.fazccb_record.deprn_reserve_acct;

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

462: raise error_found;
463: end if;
464:
465: l_cost_acct(i) := fa_cache_pkg.fazccb_record.asset_cost_acct;
466: l_clearing_acct(i) := fa_cache_pkg.fazccb_record.asset_clearing_acct;
467: l_cost_ccid(i) := fa_cache_pkg.fazccb_record.asset_cost_account_ccid;
468: l_clearing_ccid(i) := fa_cache_pkg.fazccb_record.asset_clearing_account_ccid;
469: l_reserve_acct(i) := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
470: l_reserve_ccid(i) := fa_cache_pkg.fazccb_record.reserve_account_ccid;

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

463: end if;
464:
465: l_cost_acct(i) := fa_cache_pkg.fazccb_record.asset_cost_acct;
466: l_clearing_acct(i) := fa_cache_pkg.fazccb_record.asset_clearing_acct;
467: l_cost_ccid(i) := fa_cache_pkg.fazccb_record.asset_cost_account_ccid;
468: l_clearing_ccid(i) := fa_cache_pkg.fazccb_record.asset_clearing_account_ccid;
469: l_reserve_acct(i) := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
470: l_reserve_ccid(i) := fa_cache_pkg.fazccb_record.reserve_account_ccid;
471: l_expense_acct(i) := fa_cache_pkg.fazccb_record.deprn_expense_acct;

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

464:
465: l_cost_acct(i) := fa_cache_pkg.fazccb_record.asset_cost_acct;
466: l_clearing_acct(i) := fa_cache_pkg.fazccb_record.asset_clearing_acct;
467: l_cost_ccid(i) := fa_cache_pkg.fazccb_record.asset_cost_account_ccid;
468: l_clearing_ccid(i) := fa_cache_pkg.fazccb_record.asset_clearing_account_ccid;
469: l_reserve_acct(i) := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
470: l_reserve_ccid(i) := fa_cache_pkg.fazccb_record.reserve_account_ccid;
471: l_expense_acct(i) := fa_cache_pkg.fazccb_record.deprn_expense_acct;
472: l_cip_cost_acct(i) := fa_cache_pkg.fazccb_record.cip_cost_acct;

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

465: l_cost_acct(i) := fa_cache_pkg.fazccb_record.asset_cost_acct;
466: l_clearing_acct(i) := fa_cache_pkg.fazccb_record.asset_clearing_acct;
467: l_cost_ccid(i) := fa_cache_pkg.fazccb_record.asset_cost_account_ccid;
468: l_clearing_ccid(i) := fa_cache_pkg.fazccb_record.asset_clearing_account_ccid;
469: l_reserve_acct(i) := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
470: l_reserve_ccid(i) := fa_cache_pkg.fazccb_record.reserve_account_ccid;
471: l_expense_acct(i) := fa_cache_pkg.fazccb_record.deprn_expense_acct;
472: l_cip_cost_acct(i) := fa_cache_pkg.fazccb_record.cip_cost_acct;
473: l_cip_clearing_acct(i) := fa_cache_pkg.fazccb_record.cip_clearing_acct;

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

466: l_clearing_acct(i) := fa_cache_pkg.fazccb_record.asset_clearing_acct;
467: l_cost_ccid(i) := fa_cache_pkg.fazccb_record.asset_cost_account_ccid;
468: l_clearing_ccid(i) := fa_cache_pkg.fazccb_record.asset_clearing_account_ccid;
469: l_reserve_acct(i) := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
470: l_reserve_ccid(i) := fa_cache_pkg.fazccb_record.reserve_account_ccid;
471: l_expense_acct(i) := fa_cache_pkg.fazccb_record.deprn_expense_acct;
472: l_cip_cost_acct(i) := fa_cache_pkg.fazccb_record.cip_cost_acct;
473: l_cip_clearing_acct(i) := fa_cache_pkg.fazccb_record.cip_clearing_acct;
474: l_cip_cost_ccid(i) := fa_cache_pkg.fazccb_record.wip_cost_account_ccid;

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

467: l_cost_ccid(i) := fa_cache_pkg.fazccb_record.asset_cost_account_ccid;
468: l_clearing_ccid(i) := fa_cache_pkg.fazccb_record.asset_clearing_account_ccid;
469: l_reserve_acct(i) := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
470: l_reserve_ccid(i) := fa_cache_pkg.fazccb_record.reserve_account_ccid;
471: l_expense_acct(i) := fa_cache_pkg.fazccb_record.deprn_expense_acct;
472: l_cip_cost_acct(i) := fa_cache_pkg.fazccb_record.cip_cost_acct;
473: l_cip_clearing_acct(i) := fa_cache_pkg.fazccb_record.cip_clearing_acct;
474: l_cip_cost_ccid(i) := fa_cache_pkg.fazccb_record.wip_cost_account_ccid;
475: l_cip_clearing_ccid(i) := fa_cache_pkg.fazccb_record.wip_clearing_account_ccid;

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

468: l_clearing_ccid(i) := fa_cache_pkg.fazccb_record.asset_clearing_account_ccid;
469: l_reserve_acct(i) := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
470: l_reserve_ccid(i) := fa_cache_pkg.fazccb_record.reserve_account_ccid;
471: l_expense_acct(i) := fa_cache_pkg.fazccb_record.deprn_expense_acct;
472: l_cip_cost_acct(i) := fa_cache_pkg.fazccb_record.cip_cost_acct;
473: l_cip_clearing_acct(i) := fa_cache_pkg.fazccb_record.cip_clearing_acct;
474: l_cip_cost_ccid(i) := fa_cache_pkg.fazccb_record.wip_cost_account_ccid;
475: l_cip_clearing_ccid(i) := fa_cache_pkg.fazccb_record.wip_clearing_account_ccid;
476: l_reval_amort_acct(i) := fa_cache_pkg.fazccb_record.reval_amortization_acct;

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

469: l_reserve_acct(i) := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
470: l_reserve_ccid(i) := fa_cache_pkg.fazccb_record.reserve_account_ccid;
471: l_expense_acct(i) := fa_cache_pkg.fazccb_record.deprn_expense_acct;
472: l_cip_cost_acct(i) := fa_cache_pkg.fazccb_record.cip_cost_acct;
473: l_cip_clearing_acct(i) := fa_cache_pkg.fazccb_record.cip_clearing_acct;
474: l_cip_cost_ccid(i) := fa_cache_pkg.fazccb_record.wip_cost_account_ccid;
475: l_cip_clearing_ccid(i) := fa_cache_pkg.fazccb_record.wip_clearing_account_ccid;
476: l_reval_amort_acct(i) := fa_cache_pkg.fazccb_record.reval_amortization_acct;
477: l_reval_amort_ccid(i) := fa_cache_pkg.fazccb_record.reval_amort_account_ccid;

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

470: l_reserve_ccid(i) := fa_cache_pkg.fazccb_record.reserve_account_ccid;
471: l_expense_acct(i) := fa_cache_pkg.fazccb_record.deprn_expense_acct;
472: l_cip_cost_acct(i) := fa_cache_pkg.fazccb_record.cip_cost_acct;
473: l_cip_clearing_acct(i) := fa_cache_pkg.fazccb_record.cip_clearing_acct;
474: l_cip_cost_ccid(i) := fa_cache_pkg.fazccb_record.wip_cost_account_ccid;
475: l_cip_clearing_ccid(i) := fa_cache_pkg.fazccb_record.wip_clearing_account_ccid;
476: l_reval_amort_acct(i) := fa_cache_pkg.fazccb_record.reval_amortization_acct;
477: l_reval_amort_ccid(i) := fa_cache_pkg.fazccb_record.reval_amort_account_ccid;
478: l_reval_rsv_acct(i) := fa_cache_pkg.fazccb_record.reval_reserve_acct;

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

471: l_expense_acct(i) := fa_cache_pkg.fazccb_record.deprn_expense_acct;
472: l_cip_cost_acct(i) := fa_cache_pkg.fazccb_record.cip_cost_acct;
473: l_cip_clearing_acct(i) := fa_cache_pkg.fazccb_record.cip_clearing_acct;
474: l_cip_cost_ccid(i) := fa_cache_pkg.fazccb_record.wip_cost_account_ccid;
475: l_cip_clearing_ccid(i) := fa_cache_pkg.fazccb_record.wip_clearing_account_ccid;
476: l_reval_amort_acct(i) := fa_cache_pkg.fazccb_record.reval_amortization_acct;
477: l_reval_amort_ccid(i) := fa_cache_pkg.fazccb_record.reval_amort_account_ccid;
478: l_reval_rsv_acct(i) := fa_cache_pkg.fazccb_record.reval_reserve_acct;
479: l_reval_rsv_ccid(i) := fa_cache_pkg.fazccb_record.reval_reserve_account_ccid;

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

472: l_cip_cost_acct(i) := fa_cache_pkg.fazccb_record.cip_cost_acct;
473: l_cip_clearing_acct(i) := fa_cache_pkg.fazccb_record.cip_clearing_acct;
474: l_cip_cost_ccid(i) := fa_cache_pkg.fazccb_record.wip_cost_account_ccid;
475: l_cip_clearing_ccid(i) := fa_cache_pkg.fazccb_record.wip_clearing_account_ccid;
476: l_reval_amort_acct(i) := fa_cache_pkg.fazccb_record.reval_amortization_acct;
477: l_reval_amort_ccid(i) := fa_cache_pkg.fazccb_record.reval_amort_account_ccid;
478: l_reval_rsv_acct(i) := fa_cache_pkg.fazccb_record.reval_reserve_acct;
479: l_reval_rsv_ccid(i) := fa_cache_pkg.fazccb_record.reval_reserve_account_ccid;
480: l_bonus_exp_acct(i) := fa_cache_pkg.fazccb_record.bonus_deprn_expense_acct;

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

473: l_cip_clearing_acct(i) := fa_cache_pkg.fazccb_record.cip_clearing_acct;
474: l_cip_cost_ccid(i) := fa_cache_pkg.fazccb_record.wip_cost_account_ccid;
475: l_cip_clearing_ccid(i) := fa_cache_pkg.fazccb_record.wip_clearing_account_ccid;
476: l_reval_amort_acct(i) := fa_cache_pkg.fazccb_record.reval_amortization_acct;
477: l_reval_amort_ccid(i) := fa_cache_pkg.fazccb_record.reval_amort_account_ccid;
478: l_reval_rsv_acct(i) := fa_cache_pkg.fazccb_record.reval_reserve_acct;
479: l_reval_rsv_ccid(i) := fa_cache_pkg.fazccb_record.reval_reserve_account_ccid;
480: l_bonus_exp_acct(i) := fa_cache_pkg.fazccb_record.bonus_deprn_expense_acct;
481: l_bonus_rsv_acct(i) := fa_cache_pkg.fazccb_record.bonus_deprn_reserve_acct;

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

474: l_cip_cost_ccid(i) := fa_cache_pkg.fazccb_record.wip_cost_account_ccid;
475: l_cip_clearing_ccid(i) := fa_cache_pkg.fazccb_record.wip_clearing_account_ccid;
476: l_reval_amort_acct(i) := fa_cache_pkg.fazccb_record.reval_amortization_acct;
477: l_reval_amort_ccid(i) := fa_cache_pkg.fazccb_record.reval_amort_account_ccid;
478: l_reval_rsv_acct(i) := fa_cache_pkg.fazccb_record.reval_reserve_acct;
479: l_reval_rsv_ccid(i) := fa_cache_pkg.fazccb_record.reval_reserve_account_ccid;
480: l_bonus_exp_acct(i) := fa_cache_pkg.fazccb_record.bonus_deprn_expense_acct;
481: l_bonus_rsv_acct(i) := fa_cache_pkg.fazccb_record.bonus_deprn_reserve_acct;
482: l_bonus_rsv_ccid(i) := fa_cache_pkg.fazccb_record.bonus_reserve_acct_ccid;

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

475: l_cip_clearing_ccid(i) := fa_cache_pkg.fazccb_record.wip_clearing_account_ccid;
476: l_reval_amort_acct(i) := fa_cache_pkg.fazccb_record.reval_amortization_acct;
477: l_reval_amort_ccid(i) := fa_cache_pkg.fazccb_record.reval_amort_account_ccid;
478: l_reval_rsv_acct(i) := fa_cache_pkg.fazccb_record.reval_reserve_acct;
479: l_reval_rsv_ccid(i) := fa_cache_pkg.fazccb_record.reval_reserve_account_ccid;
480: l_bonus_exp_acct(i) := fa_cache_pkg.fazccb_record.bonus_deprn_expense_acct;
481: l_bonus_rsv_acct(i) := fa_cache_pkg.fazccb_record.bonus_deprn_reserve_acct;
482: l_bonus_rsv_ccid(i) := fa_cache_pkg.fazccb_record.bonus_reserve_acct_ccid;
483: l_impair_exp_acct(i) := fa_cache_pkg.fazccb_record.impair_expense_acct;

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

476: l_reval_amort_acct(i) := fa_cache_pkg.fazccb_record.reval_amortization_acct;
477: l_reval_amort_ccid(i) := fa_cache_pkg.fazccb_record.reval_amort_account_ccid;
478: l_reval_rsv_acct(i) := fa_cache_pkg.fazccb_record.reval_reserve_acct;
479: l_reval_rsv_ccid(i) := fa_cache_pkg.fazccb_record.reval_reserve_account_ccid;
480: l_bonus_exp_acct(i) := fa_cache_pkg.fazccb_record.bonus_deprn_expense_acct;
481: l_bonus_rsv_acct(i) := fa_cache_pkg.fazccb_record.bonus_deprn_reserve_acct;
482: l_bonus_rsv_ccid(i) := fa_cache_pkg.fazccb_record.bonus_reserve_acct_ccid;
483: l_impair_exp_acct(i) := fa_cache_pkg.fazccb_record.impair_expense_acct;
484: l_impair_exp_ccid(i) := fa_cache_pkg.fazccb_record.impair_expense_account_ccid;

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

477: l_reval_amort_ccid(i) := fa_cache_pkg.fazccb_record.reval_amort_account_ccid;
478: l_reval_rsv_acct(i) := fa_cache_pkg.fazccb_record.reval_reserve_acct;
479: l_reval_rsv_ccid(i) := fa_cache_pkg.fazccb_record.reval_reserve_account_ccid;
480: l_bonus_exp_acct(i) := fa_cache_pkg.fazccb_record.bonus_deprn_expense_acct;
481: l_bonus_rsv_acct(i) := fa_cache_pkg.fazccb_record.bonus_deprn_reserve_acct;
482: l_bonus_rsv_ccid(i) := fa_cache_pkg.fazccb_record.bonus_reserve_acct_ccid;
483: l_impair_exp_acct(i) := fa_cache_pkg.fazccb_record.impair_expense_acct;
484: l_impair_exp_ccid(i) := fa_cache_pkg.fazccb_record.impair_expense_account_ccid;
485: l_impair_rsv_acct(i) := fa_cache_pkg.fazccb_record.impair_reserve_acct;

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

478: l_reval_rsv_acct(i) := fa_cache_pkg.fazccb_record.reval_reserve_acct;
479: l_reval_rsv_ccid(i) := fa_cache_pkg.fazccb_record.reval_reserve_account_ccid;
480: l_bonus_exp_acct(i) := fa_cache_pkg.fazccb_record.bonus_deprn_expense_acct;
481: l_bonus_rsv_acct(i) := fa_cache_pkg.fazccb_record.bonus_deprn_reserve_acct;
482: l_bonus_rsv_ccid(i) := fa_cache_pkg.fazccb_record.bonus_reserve_acct_ccid;
483: l_impair_exp_acct(i) := fa_cache_pkg.fazccb_record.impair_expense_acct;
484: l_impair_exp_ccid(i) := fa_cache_pkg.fazccb_record.impair_expense_account_ccid;
485: l_impair_rsv_acct(i) := fa_cache_pkg.fazccb_record.impair_reserve_acct;
486: l_impair_rsv_ccid(i) := fa_cache_pkg.fazccb_record.impair_reserve_account_ccid;

Line 483: l_impair_exp_acct(i) := fa_cache_pkg.fazccb_record.impair_expense_acct;

479: l_reval_rsv_ccid(i) := fa_cache_pkg.fazccb_record.reval_reserve_account_ccid;
480: l_bonus_exp_acct(i) := fa_cache_pkg.fazccb_record.bonus_deprn_expense_acct;
481: l_bonus_rsv_acct(i) := fa_cache_pkg.fazccb_record.bonus_deprn_reserve_acct;
482: l_bonus_rsv_ccid(i) := fa_cache_pkg.fazccb_record.bonus_reserve_acct_ccid;
483: l_impair_exp_acct(i) := fa_cache_pkg.fazccb_record.impair_expense_acct;
484: l_impair_exp_ccid(i) := fa_cache_pkg.fazccb_record.impair_expense_account_ccid;
485: l_impair_rsv_acct(i) := fa_cache_pkg.fazccb_record.impair_reserve_acct;
486: l_impair_rsv_ccid(i) := fa_cache_pkg.fazccb_record.impair_reserve_account_ccid;
487: -- Bug 6666666 : Start of SORP Code

Line 484: l_impair_exp_ccid(i) := fa_cache_pkg.fazccb_record.impair_expense_account_ccid;

480: l_bonus_exp_acct(i) := fa_cache_pkg.fazccb_record.bonus_deprn_expense_acct;
481: l_bonus_rsv_acct(i) := fa_cache_pkg.fazccb_record.bonus_deprn_reserve_acct;
482: l_bonus_rsv_ccid(i) := fa_cache_pkg.fazccb_record.bonus_reserve_acct_ccid;
483: l_impair_exp_acct(i) := fa_cache_pkg.fazccb_record.impair_expense_acct;
484: l_impair_exp_ccid(i) := fa_cache_pkg.fazccb_record.impair_expense_account_ccid;
485: l_impair_rsv_acct(i) := fa_cache_pkg.fazccb_record.impair_reserve_acct;
486: l_impair_rsv_ccid(i) := fa_cache_pkg.fazccb_record.impair_reserve_account_ccid;
487: -- Bug 6666666 : Start of SORP Code
488: l_capital_adj_acct(i) := fa_cache_pkg.fazccb_record.capital_adj_acct;

Line 485: l_impair_rsv_acct(i) := fa_cache_pkg.fazccb_record.impair_reserve_acct;

481: l_bonus_rsv_acct(i) := fa_cache_pkg.fazccb_record.bonus_deprn_reserve_acct;
482: l_bonus_rsv_ccid(i) := fa_cache_pkg.fazccb_record.bonus_reserve_acct_ccid;
483: l_impair_exp_acct(i) := fa_cache_pkg.fazccb_record.impair_expense_acct;
484: l_impair_exp_ccid(i) := fa_cache_pkg.fazccb_record.impair_expense_account_ccid;
485: l_impair_rsv_acct(i) := fa_cache_pkg.fazccb_record.impair_reserve_acct;
486: l_impair_rsv_ccid(i) := fa_cache_pkg.fazccb_record.impair_reserve_account_ccid;
487: -- Bug 6666666 : Start of SORP Code
488: l_capital_adj_acct(i) := fa_cache_pkg.fazccb_record.capital_adj_acct;
489: l_capital_adj_ccid(i) := fa_cache_pkg.fazccb_record.capital_adj_account_ccid;

Line 486: l_impair_rsv_ccid(i) := fa_cache_pkg.fazccb_record.impair_reserve_account_ccid;

482: l_bonus_rsv_ccid(i) := fa_cache_pkg.fazccb_record.bonus_reserve_acct_ccid;
483: l_impair_exp_acct(i) := fa_cache_pkg.fazccb_record.impair_expense_acct;
484: l_impair_exp_ccid(i) := fa_cache_pkg.fazccb_record.impair_expense_account_ccid;
485: l_impair_rsv_acct(i) := fa_cache_pkg.fazccb_record.impair_reserve_acct;
486: l_impair_rsv_ccid(i) := fa_cache_pkg.fazccb_record.impair_reserve_account_ccid;
487: -- Bug 6666666 : Start of SORP Code
488: l_capital_adj_acct(i) := fa_cache_pkg.fazccb_record.capital_adj_acct;
489: l_capital_adj_ccid(i) := fa_cache_pkg.fazccb_record.capital_adj_account_ccid;
490: l_general_fund_acct(i) := fa_cache_pkg.fazccb_record.general_fund_acct;

Line 488: l_capital_adj_acct(i) := fa_cache_pkg.fazccb_record.capital_adj_acct;

484: l_impair_exp_ccid(i) := fa_cache_pkg.fazccb_record.impair_expense_account_ccid;
485: l_impair_rsv_acct(i) := fa_cache_pkg.fazccb_record.impair_reserve_acct;
486: l_impair_rsv_ccid(i) := fa_cache_pkg.fazccb_record.impair_reserve_account_ccid;
487: -- Bug 6666666 : Start of SORP Code
488: l_capital_adj_acct(i) := fa_cache_pkg.fazccb_record.capital_adj_acct;
489: l_capital_adj_ccid(i) := fa_cache_pkg.fazccb_record.capital_adj_account_ccid;
490: l_general_fund_acct(i) := fa_cache_pkg.fazccb_record.general_fund_acct;
491: l_general_fund_ccid(i) := fa_cache_pkg.fazccb_record.general_fund_account_ccid;
492: -- Bug 6666666 : End of SORP Code

Line 489: l_capital_adj_ccid(i) := fa_cache_pkg.fazccb_record.capital_adj_account_ccid;

485: l_impair_rsv_acct(i) := fa_cache_pkg.fazccb_record.impair_reserve_acct;
486: l_impair_rsv_ccid(i) := fa_cache_pkg.fazccb_record.impair_reserve_account_ccid;
487: -- Bug 6666666 : Start of SORP Code
488: l_capital_adj_acct(i) := fa_cache_pkg.fazccb_record.capital_adj_acct;
489: l_capital_adj_ccid(i) := fa_cache_pkg.fazccb_record.capital_adj_account_ccid;
490: l_general_fund_acct(i) := fa_cache_pkg.fazccb_record.general_fund_acct;
491: l_general_fund_ccid(i) := fa_cache_pkg.fazccb_record.general_fund_account_ccid;
492: -- Bug 6666666 : End of SORP Code
493: l_reval_loss_acct(i) := fa_cache_pkg.fazccb_record.reval_loss_acct;

Line 490: l_general_fund_acct(i) := fa_cache_pkg.fazccb_record.general_fund_acct;

486: l_impair_rsv_ccid(i) := fa_cache_pkg.fazccb_record.impair_reserve_account_ccid;
487: -- Bug 6666666 : Start of SORP Code
488: l_capital_adj_acct(i) := fa_cache_pkg.fazccb_record.capital_adj_acct;
489: l_capital_adj_ccid(i) := fa_cache_pkg.fazccb_record.capital_adj_account_ccid;
490: l_general_fund_acct(i) := fa_cache_pkg.fazccb_record.general_fund_acct;
491: l_general_fund_ccid(i) := fa_cache_pkg.fazccb_record.general_fund_account_ccid;
492: -- Bug 6666666 : End of SORP Code
493: l_reval_loss_acct(i) := fa_cache_pkg.fazccb_record.reval_loss_acct;
494: l_reval_loss_ccid(i) := fa_cache_pkg.fazccb_record.reval_loss_account_ccid;

Line 491: l_general_fund_ccid(i) := fa_cache_pkg.fazccb_record.general_fund_account_ccid;

487: -- Bug 6666666 : Start of SORP Code
488: l_capital_adj_acct(i) := fa_cache_pkg.fazccb_record.capital_adj_acct;
489: l_capital_adj_ccid(i) := fa_cache_pkg.fazccb_record.capital_adj_account_ccid;
490: l_general_fund_acct(i) := fa_cache_pkg.fazccb_record.general_fund_acct;
491: l_general_fund_ccid(i) := fa_cache_pkg.fazccb_record.general_fund_account_ccid;
492: -- Bug 6666666 : End of SORP Code
493: l_reval_loss_acct(i) := fa_cache_pkg.fazccb_record.reval_loss_acct;
494: l_reval_loss_ccid(i) := fa_cache_pkg.fazccb_record.reval_loss_account_ccid;
495: end loop;

Line 493: l_reval_loss_acct(i) := fa_cache_pkg.fazccb_record.reval_loss_acct;

489: l_capital_adj_ccid(i) := fa_cache_pkg.fazccb_record.capital_adj_account_ccid;
490: l_general_fund_acct(i) := fa_cache_pkg.fazccb_record.general_fund_acct;
491: l_general_fund_ccid(i) := fa_cache_pkg.fazccb_record.general_fund_account_ccid;
492: -- Bug 6666666 : End of SORP Code
493: l_reval_loss_acct(i) := fa_cache_pkg.fazccb_record.reval_loss_acct;
494: l_reval_loss_ccid(i) := fa_cache_pkg.fazccb_record.reval_loss_account_ccid;
495: end loop;
496:
497: else

Line 494: l_reval_loss_ccid(i) := fa_cache_pkg.fazccb_record.reval_loss_account_ccid;

490: l_general_fund_acct(i) := fa_cache_pkg.fazccb_record.general_fund_acct;
491: l_general_fund_ccid(i) := fa_cache_pkg.fazccb_record.general_fund_account_ccid;
492: -- Bug 6666666 : End of SORP Code
493: l_reval_loss_acct(i) := fa_cache_pkg.fazccb_record.reval_loss_acct;
494: l_reval_loss_ccid(i) := fa_cache_pkg.fazccb_record.reval_loss_account_ccid;
495: end loop;
496:
497: else
498:

Line 2081: if not (fa_cache_pkg.fazcbc(x_book => p_book_type_code, p_log_level_rec => g_log_level_rec)) then

2077: raise FND_API.G_EXC_ERROR;
2078: end if;
2079: end if;
2080:
2081: if not (fa_cache_pkg.fazcbc(x_book => p_book_type_code, p_log_level_rec => g_log_level_rec)) then
2082: raise error_found;
2083: end if;
2084:
2085: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 1000);

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

2081: if not (fa_cache_pkg.fazcbc(x_book => p_book_type_code, p_log_level_rec => g_log_level_rec)) then
2082: raise error_found;
2083: end if;
2084:
2085: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 1000);
2086: l_dist_source_book := fa_cache_pkg.fazcbc_record.distribution_source_book;
2087:
2088: INSERT INTO FA_WORKER_JOBS
2089: (START_RANGE, END_RANGE, WORKER_NUM, STATUS,REQUEST_ID)

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

2082: raise error_found;
2083: end if;
2084:
2085: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 1000);
2086: l_dist_source_book := fa_cache_pkg.fazcbc_record.distribution_source_book;
2087:
2088: INSERT INTO FA_WORKER_JOBS
2089: (START_RANGE, END_RANGE, WORKER_NUM, STATUS,REQUEST_ID)
2090: SELECT MIN(DISTRIBUTION_ID), MAX(DISTRIBUTION_ID), 0,