APPS.IGI_IAC_CATCHUP_PKG dependencies on IGI_IAC_FA_DEPRN

Line 512: l_iac_fa_deprn_rec igi_iac_fa_deprn%ROWTYPE;

508: l_reval_general_fund igi_iac_det_balances.reval_reserve_gen_fund%TYPE;
509: l_general_fund_acc igi_iac_det_balances.general_fund_acc%TYPE;
510: l_fa_deprn_acc NUMBER;
511: l_fa_deprn_catchup_amount NUMBER;
512: l_iac_fa_deprn_rec igi_iac_fa_deprn%ROWTYPE;
513: l_last_deprn_catchup_period NUMBER;
514: l_periods_in_year NUMBER;
515: l_deprn_calendar fa_calendar_types.calendar_type%TYPE;
516: /* Bug 2961656 vgadde 08-jul-2003 Start(3) */

Line 571: CURSOR c_get_iac_fa_deprn_rec(cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE

567: WHERE book_type_code = p_asset_balance.book_type_code
568: AND asset_id = p_asset_balance.asset_id
569: AND period_counter = p_period_counter;
570:
571: CURSOR c_get_iac_fa_deprn_rec(cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE
572: ,cp_distribution_id igi_iac_fa_deprn.distribution_id%TYPE) IS
573: SELECT *
574: FROM igi_iac_fa_deprn
575: WHERE book_type_code = p_asset_balance.book_type_code

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

568: AND asset_id = p_asset_balance.asset_id
569: AND period_counter = p_period_counter;
570:
571: CURSOR c_get_iac_fa_deprn_rec(cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE
572: ,cp_distribution_id igi_iac_fa_deprn.distribution_id%TYPE) IS
573: SELECT *
574: FROM igi_iac_fa_deprn
575: WHERE book_type_code = p_asset_balance.book_type_code
576: AND asset_id = p_asset_balance.asset_id

Line 574: FROM igi_iac_fa_deprn

570:
571: CURSOR c_get_iac_fa_deprn_rec(cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE
572: ,cp_distribution_id igi_iac_fa_deprn.distribution_id%TYPE) IS
573: SELECT *
574: FROM igi_iac_fa_deprn
575: WHERE book_type_code = p_asset_balance.book_type_code
576: AND asset_id = p_asset_balance.asset_id
577: AND adjustment_id = cp_adjustment_id
578: AND distribution_id = cp_distribution_id;

Line 580: CURSOR c_get_iac_fa_inactive_dists(cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE) IS

576: AND asset_id = p_asset_balance.asset_id
577: AND adjustment_id = cp_adjustment_id
578: AND distribution_id = cp_distribution_id;
579:
580: CURSOR c_get_iac_fa_inactive_dists(cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE) IS
581: SELECT *
582: FROM igi_iac_fa_deprn
583: WHERE adjustment_id = cp_adjustment_id
584: AND book_type_code = p_asset_balance.book_type_code

Line 582: FROM igi_iac_fa_deprn

578: AND distribution_id = cp_distribution_id;
579:
580: CURSOR c_get_iac_fa_inactive_dists(cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE) IS
581: SELECT *
582: FROM igi_iac_fa_deprn
583: WHERE adjustment_id = cp_adjustment_id
584: AND book_type_code = p_asset_balance.book_type_code
585: AND asset_id = p_asset_balance.asset_id
586: AND nvl(active_flag,'Y') = 'N';

Line 1023: igi_iac_fa_deprn_pkg.insert_row(

1019: END LOOP; /* inactive distributions of igi_iac_det_balances */
1020:
1021: FOR l_iac_fa_inactive_dist IN c_get_iac_fa_inactive_dists(l_transaction.adjustment_id) LOOP
1022: l_rowid := NULL;
1023: igi_iac_fa_deprn_pkg.insert_row(
1024: x_rowid => l_rowid,
1025: x_book_type_code => l_iac_fa_inactive_dist.book_type_code,
1026: x_asset_id => l_iac_fa_inactive_dist.asset_id,
1027: x_distribution_id => l_iac_fa_inactive_dist.distribution_id,

Line 1404: igi_iac_fa_deprn_pkg.insert_row(

1400: return FALSE;
1401: END IF;
1402:
1403: l_rowid := NULL;
1404: igi_iac_fa_deprn_pkg.insert_row(
1405: x_rowid => l_rowid,
1406: x_book_type_code => l_iac_fa_deprn_rec.book_type_code,
1407: x_asset_id => l_iac_fa_deprn_rec.asset_id,
1408: x_distribution_id => l_iac_fa_deprn_rec.distribution_id,

Line 1420: END LOOP; /* processing distributions for igi_iac_fa_deprn */

1416: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1417: p_full_path => l_path_name,
1418: p_string => ' distribution FA YTD:'||to_char(l_deprn_ytd));
1419:
1420: END LOOP; /* processing distributions for igi_iac_fa_deprn */
1421:
1422:
1423: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1424: p_full_path => l_path_name,