APPS.IGI_IAC_CATCHUP_PKG dependencies on IGI_IAC_FA_DEPRN

Line 470: l_iac_fa_deprn_rec igi_iac_fa_deprn%ROWTYPE;

466: l_reval_general_fund igi_iac_det_balances.reval_reserve_gen_fund%TYPE;
467: l_general_fund_acc igi_iac_det_balances.general_fund_acc%TYPE;
468: l_fa_deprn_acc NUMBER;
469: l_fa_deprn_catchup_amount NUMBER;
470: l_iac_fa_deprn_rec igi_iac_fa_deprn%ROWTYPE;
471: l_last_deprn_catchup_period NUMBER;
472: l_periods_in_year NUMBER;
473: l_deprn_calendar fa_calendar_types.calendar_type%TYPE;
474: /* Bug 2961656 vgadde 08-jul-2003 Start(3) */

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

525: WHERE book_type_code = p_asset_balance.book_type_code
526: AND asset_id = p_asset_balance.asset_id
527: AND period_counter = p_period_counter;
528:
529: CURSOR c_get_iac_fa_deprn_rec(cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE
530: ,cp_distribution_id igi_iac_fa_deprn.distribution_id%TYPE) IS
531: SELECT *
532: FROM igi_iac_fa_deprn
533: WHERE book_type_code = p_asset_balance.book_type_code

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

526: AND asset_id = p_asset_balance.asset_id
527: AND period_counter = p_period_counter;
528:
529: CURSOR c_get_iac_fa_deprn_rec(cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE
530: ,cp_distribution_id igi_iac_fa_deprn.distribution_id%TYPE) IS
531: SELECT *
532: FROM igi_iac_fa_deprn
533: WHERE book_type_code = p_asset_balance.book_type_code
534: AND asset_id = p_asset_balance.asset_id

Line 532: FROM igi_iac_fa_deprn

528:
529: CURSOR c_get_iac_fa_deprn_rec(cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE
530: ,cp_distribution_id igi_iac_fa_deprn.distribution_id%TYPE) IS
531: SELECT *
532: FROM igi_iac_fa_deprn
533: WHERE book_type_code = p_asset_balance.book_type_code
534: AND asset_id = p_asset_balance.asset_id
535: AND adjustment_id = cp_adjustment_id
536: AND distribution_id = cp_distribution_id;

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

534: AND asset_id = p_asset_balance.asset_id
535: AND adjustment_id = cp_adjustment_id
536: AND distribution_id = cp_distribution_id;
537:
538: CURSOR c_get_iac_fa_inactive_dists(cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE) IS
539: SELECT *
540: FROM igi_iac_fa_deprn
541: WHERE adjustment_id = cp_adjustment_id
542: AND book_type_code = p_asset_balance.book_type_code

Line 540: FROM igi_iac_fa_deprn

536: AND distribution_id = cp_distribution_id;
537:
538: CURSOR c_get_iac_fa_inactive_dists(cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE) IS
539: SELECT *
540: FROM igi_iac_fa_deprn
541: WHERE adjustment_id = cp_adjustment_id
542: AND book_type_code = p_asset_balance.book_type_code
543: AND asset_id = p_asset_balance.asset_id
544: AND nvl(active_flag,'Y') = 'N';

Line 952: igi_iac_fa_deprn_pkg.insert_row(

948: END LOOP; /* inactive distributions of igi_iac_det_balances */
949:
950: FOR l_iac_fa_inactive_dist IN c_get_iac_fa_inactive_dists(l_transaction.adjustment_id) LOOP
951: l_rowid := NULL;
952: igi_iac_fa_deprn_pkg.insert_row(
953: x_rowid => l_rowid,
954: x_book_type_code => l_iac_fa_inactive_dist.book_type_code,
955: x_asset_id => l_iac_fa_inactive_dist.asset_id,
956: x_distribution_id => l_iac_fa_inactive_dist.distribution_id,

Line 1322: igi_iac_fa_deprn_pkg.insert_row(

1318: return FALSE;
1319: END IF;
1320:
1321: l_rowid := NULL;
1322: igi_iac_fa_deprn_pkg.insert_row(
1323: x_rowid => l_rowid,
1324: x_book_type_code => l_iac_fa_deprn_rec.book_type_code,
1325: x_asset_id => l_iac_fa_deprn_rec.asset_id,
1326: x_distribution_id => l_iac_fa_deprn_rec.distribution_id,

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

1334: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1335: p_full_path => l_path_name,
1336: p_string => ' distribution FA YTD:'||to_char(l_deprn_ytd));
1337:
1338: END LOOP; /* processing distributions for igi_iac_fa_deprn */
1339:
1340:
1341: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1342: p_full_path => l_path_name,