APPS.IGI_IAC_DEPRN_PKG dependencies on IGI_IAC_FA_DEPRN

Line 304: CURSOR c_get_iac_fa_deprn_dists(cp_asset_id igi_iac_fa_deprn.asset_id%TYPE

300: AND distribution_id = cp_distribution_id
301: AND period_counter = p_period_counter - 1
302: AND nvl(active_flag,'Y') = 'N';
303:
304: CURSOR c_get_iac_fa_deprn_dists(cp_asset_id igi_iac_fa_deprn.asset_id%TYPE
305: ,cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE) IS
306: SELECT *
307: FROM igi_iac_fa_deprn
308: WHERE book_type_code = p_book_type_code

Line 305: ,cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE) IS

301: AND period_counter = p_period_counter - 1
302: AND nvl(active_flag,'Y') = 'N';
303:
304: CURSOR c_get_iac_fa_deprn_dists(cp_asset_id igi_iac_fa_deprn.asset_id%TYPE
305: ,cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE) IS
306: SELECT *
307: FROM igi_iac_fa_deprn
308: WHERE book_type_code = p_book_type_code
309: AND asset_id = cp_asset_id

Line 307: FROM igi_iac_fa_deprn

303:
304: CURSOR c_get_iac_fa_deprn_dists(cp_asset_id igi_iac_fa_deprn.asset_id%TYPE
305: ,cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE) IS
306: SELECT *
307: FROM igi_iac_fa_deprn
308: WHERE book_type_code = p_book_type_code
309: AND asset_id = cp_asset_id
310: AND adjustment_id = cp_adjustment_id;
311:

Line 312: CURSOR c_get_prev_year_fa_inactive(cp_asset_id igi_iac_fa_deprn.asset_id%TYPE

308: WHERE book_type_code = p_book_type_code
309: AND asset_id = cp_asset_id
310: AND adjustment_id = cp_adjustment_id;
311:
312: CURSOR c_get_prev_year_fa_inactive(cp_asset_id igi_iac_fa_deprn.asset_id%TYPE
313: ,cp_distribution_id igi_iac_fa_deprn.distribution_id%TYPE) IS
314: SELECT 'X'
315: FROM igi_iac_fa_deprn
316: WHERE book_type_code = p_book_type_code

Line 313: ,cp_distribution_id igi_iac_fa_deprn.distribution_id%TYPE) IS

309: AND asset_id = cp_asset_id
310: AND adjustment_id = cp_adjustment_id;
311:
312: CURSOR c_get_prev_year_fa_inactive(cp_asset_id igi_iac_fa_deprn.asset_id%TYPE
313: ,cp_distribution_id igi_iac_fa_deprn.distribution_id%TYPE) IS
314: SELECT 'X'
315: FROM igi_iac_fa_deprn
316: WHERE book_type_code = p_book_type_code
317: AND asset_id = cp_asset_id

Line 315: FROM igi_iac_fa_deprn

311:
312: CURSOR c_get_prev_year_fa_inactive(cp_asset_id igi_iac_fa_deprn.asset_id%TYPE
313: ,cp_distribution_id igi_iac_fa_deprn.distribution_id%TYPE) IS
314: SELECT 'X'
315: FROM igi_iac_fa_deprn
316: WHERE book_type_code = p_book_type_code
317: AND asset_id = cp_asset_id
318: AND distribution_id = cp_distribution_id
319: AND period_counter = p_period_counter - 1

Line 940: igi_iac_fa_deprn_pkg.insert_row(

936: IF (nvl(l_iac_fa_deprn_dist.active_flag,'Y') <> 'N') THEN
937:
938: FOR l_fa_dist_amounts IN c_get_dist_deprn_amount(l_asset_balance.asset_id,l_iac_fa_deprn_dist.distribution_id) LOOP
939: l_rowid := NULL;
940: igi_iac_fa_deprn_pkg.insert_row(
941: x_rowid => l_rowid,
942: x_book_type_code => p_book_type_code,
943: x_asset_id => l_asset_balance.asset_id,
944: x_distribution_id => l_iac_fa_deprn_dist.distribution_id,

Line 959: igi_iac_fa_deprn_pkg.insert_row(

955: END IF;
956:
957: IF ((nvl(l_iac_fa_deprn_dist.active_flag,'Y') = 'N') AND (NOT l_is_first_period)) THEN
958: l_rowid := NULL;
959: igi_iac_fa_deprn_pkg.insert_row(
960: x_rowid => l_rowid,
961: x_book_type_code => l_iac_fa_deprn_dist.book_type_code,
962: x_asset_id => l_iac_fa_deprn_dist.asset_id,
963: x_distribution_id => l_iac_fa_deprn_dist.distribution_id,

Line 983: igi_iac_fa_deprn_pkg.insert_row(

979: CLOSE c_get_prev_year_fa_inactive;
980:
981: IF l_prev_year_inactive_dist IS NULL THEN
982: l_rowid := NULL;
983: igi_iac_fa_deprn_pkg.insert_row(
984: x_rowid => l_rowid,
985: x_book_type_code => l_iac_fa_deprn_dist.book_type_code,
986: x_asset_id => l_iac_fa_deprn_dist.asset_id,
987: x_distribution_id => l_iac_fa_deprn_dist.distribution_id,