APPS.IGI_IAC_YTD_PRE_PROCESS_PKG dependencies on IGI_IAC_FA_DEPRN

Line 72: FROM igi_iac_fa_deprn

68: AND distribution_id = cp_distribution_id;
69:
70: CURSOR c_get_iac_fa_deprn_rec IS
71: SELECT 'X'
72: FROM igi_iac_fa_deprn
73: WHERE book_type_code = p_book_type_code
74: AND rownum = 1;
75:
76: cursor c_check_igi_fa_deprn (cp_asset_id number,

Line 81: From igi_iac_fa_deprn

77: cp_distribution_id number,
78: cp_adjustment_id number,
79: cp_period_counter number) is
80: Select *
81: From igi_iac_fa_deprn
82: Where book_type_code = p_book_type_code
83: and asset_id = cp_asset_id
84: and distribution_id = cp_distribution_id
85: and adjustment_id = cp_adjustment_id

Line 240: IGI_IAC_FA_DEPRN_PKG.insert_row (

236: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve =>'|| l_deprn_reserve);
237: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag =>'|| l_dist.active_flag);
238:
239: l_rowid := NULL;
240: IGI_IAC_FA_DEPRN_PKG.insert_row (
241: x_rowid => l_rowid,
242: x_adjustment_id => l_adjustment_id,
243: x_asset_id => l_asset.asset_id,
244: x_distribution_id => l_dist.distribution_id,

Line 269: IGI_IAC_FA_DEPRN_PKG.insert_row (

265: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve =>'|| l_deprn_reserve);
266: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag =>'|| l_dist.active_flag);
267:
268: l_rowid := NULL;
269: IGI_IAC_FA_DEPRN_PKG.insert_row (
270: x_rowid => l_rowid,
271: x_adjustment_id => l_adjustment_id,
272: x_asset_id => l_asset.asset_id,
273: x_distribution_id => l_dist.distribution_id,

Line 304: IGI_IAC_FA_DEPRN_PKG.insert_row (

300: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve =>'|| l_deprn_reserve);
301: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag =>'|| l_dist.active_flag);
302:
303: l_rowid := NULL;
304: IGI_IAC_FA_DEPRN_PKG.insert_row (
305: x_rowid => l_rowid,
306: x_adjustment_id => l_prev_adjustment_id,
307: x_asset_id => l_asset.asset_id,
308: x_distribution_id => l_dist.distribution_id,

Line 333: IGI_IAC_FA_DEPRN_PKG.insert_row (

329: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve =>'|| l_deprn_reserve);
330: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag =>'|| l_dist.active_flag);
331:
332: l_rowid := NULL;
333: IGI_IAC_FA_DEPRN_PKG.insert_row (
334: x_rowid => l_rowid,
335: x_adjustment_id => l_prev_adjustment_id,
336: x_asset_id => l_asset.asset_id,
337: x_distribution_id => l_dist.distribution_id,