DBA Data[Home] [Help]

APPS.IGI_IAC_ADJ_EXPENSED_PKG dependencies on IGI_IAC_FA_DEPRN

Line 511: FROM igi_iac_fa_deprn

507: P_distribution_id igi_iac_det_balances.distribution_id%TYPE
508: , p_prev_adjustment_id igi_iac_det_balances.adjustment_id%TYPE) IS
509:
510: SELECT *
511: FROM igi_iac_fa_deprn
512: WHERE book_type_code =P_book_type_code
513: AND asset_id =p_asset_id
514: AND adjustment_id =p_prev_adjustment_id
515: AND distribution_id = P_distribution_id;

Line 586: l_total_db_fa igi_iac_fa_deprn%ROWTYPE;

582: l_reserve_blog NUMBER ;
583: l_deprn_blog NUMBER ;
584: l_reserve_cost NUMBER ;
585: l_operatg_ytd NUMBER ;
586: l_total_db_fa igi_iac_fa_deprn%ROWTYPE;
587: l_remaining_db_fa igi_iac_fa_deprn%ROWTYPE;
588: l_current_db_fa igi_iac_fa_deprn%ROWTYPE;
589: l_ytd_prorate_dists_tab igi_iac_types.prorate_dists_tab;
590: l_ytd_prorate_dists_idx binary_integer;

Line 587: l_remaining_db_fa igi_iac_fa_deprn%ROWTYPE;

583: l_deprn_blog NUMBER ;
584: l_reserve_cost NUMBER ;
585: l_operatg_ytd NUMBER ;
586: l_total_db_fa igi_iac_fa_deprn%ROWTYPE;
587: l_remaining_db_fa igi_iac_fa_deprn%ROWTYPE;
588: l_current_db_fa igi_iac_fa_deprn%ROWTYPE;
589: l_ytd_prorate_dists_tab igi_iac_types.prorate_dists_tab;
590: l_ytd_prorate_dists_idx binary_integer;
591: l_path_name VARCHAR2(150);

Line 588: l_current_db_fa igi_iac_fa_deprn%ROWTYPE;

584: l_reserve_cost NUMBER ;
585: l_operatg_ytd NUMBER ;
586: l_total_db_fa igi_iac_fa_deprn%ROWTYPE;
587: l_remaining_db_fa igi_iac_fa_deprn%ROWTYPE;
588: l_current_db_fa igi_iac_fa_deprn%ROWTYPE;
589: l_ytd_prorate_dists_tab igi_iac_types.prorate_dists_tab;
590: l_ytd_prorate_dists_idx binary_integer;
591: l_path_name VARCHAR2(150);
592: l_dist_ytd_factor NUMBER;

Line 904: igi_iac_fa_deprn_pkg.insert_row(

900: );
901: FETCH c_get_iac_fa_deprn INTO l_get_iac_fa_deprn;
902: IF C_get_iac_fa_deprn%FOUND THEN
903: l_rowid := NULL;
904: igi_iac_fa_deprn_pkg.insert_row(
905: x_rowid => l_rowid,
906: x_book_type_code => l_det_balances.book_type_code,
907: x_asset_id => l_det_balances.asset_id,
908: x_distribution_id => l_det_balances.distribution_id,

Line 1709: p_string => 'Before igi_iac_fa_deprn_pkg.insert_row');

1705: x_mode => 'R' );
1706:
1707: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1708: p_full_path => l_path_name,
1709: p_string => 'Before igi_iac_fa_deprn_pkg.insert_row');
1710: l_rowid := NULL;
1711: igi_iac_fa_deprn_pkg.insert_row(
1712: x_rowid => l_rowid,
1713: x_book_type_code => l_det_balances.book_type_code,

Line 1711: igi_iac_fa_deprn_pkg.insert_row(

1707: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1708: p_full_path => l_path_name,
1709: p_string => 'Before igi_iac_fa_deprn_pkg.insert_row');
1710: l_rowid := NULL;
1711: igi_iac_fa_deprn_pkg.insert_row(
1712: x_rowid => l_rowid,
1713: x_book_type_code => l_det_balances.book_type_code,
1714: x_asset_id => l_det_balances.asset_id,
1715: x_distribution_id => l_det_balances.distribution_id,

Line 1725: p_string => 'After igi_iac_fa_deprn_pkg.insert_row');

1721: x_active_flag => l_det_balances.active_flag,
1722: x_mode => 'R');
1723: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1724: p_full_path => l_path_name,
1725: p_string => 'After igi_iac_fa_deprn_pkg.insert_row');
1726: END LOOP;
1727:
1728: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1729: p_full_path => l_path_name,