DBA Data[Home] [Help]

APPS.IGI_IAC_ADJ_EXPENSED_PKG dependencies on IGI_IAC_FA_DEPRN

Line 482: FROM igi_iac_fa_deprn

478: P_distribution_id igi_iac_det_balances.distribution_id%TYPE
479: , p_prev_adjustment_id igi_iac_det_balances.adjustment_id%TYPE) IS
480:
481: SELECT *
482: FROM igi_iac_fa_deprn
483: WHERE book_type_code =P_book_type_code
484: AND asset_id =p_asset_id
485: AND adjustment_id =p_prev_adjustment_id
486: AND distribution_id = P_distribution_id;

Line 557: l_total_db_fa igi_iac_fa_deprn%ROWTYPE;

553: l_reserve_blog NUMBER ;
554: l_deprn_blog NUMBER ;
555: l_reserve_cost NUMBER ;
556: l_operatg_ytd NUMBER ;
557: l_total_db_fa igi_iac_fa_deprn%ROWTYPE;
558: l_remaining_db_fa igi_iac_fa_deprn%ROWTYPE;
559: l_current_db_fa igi_iac_fa_deprn%ROWTYPE;
560: l_ytd_prorate_dists_tab igi_iac_types.prorate_dists_tab;
561: l_ytd_prorate_dists_idx binary_integer;

Line 558: l_remaining_db_fa igi_iac_fa_deprn%ROWTYPE;

554: l_deprn_blog NUMBER ;
555: l_reserve_cost NUMBER ;
556: l_operatg_ytd NUMBER ;
557: l_total_db_fa igi_iac_fa_deprn%ROWTYPE;
558: l_remaining_db_fa igi_iac_fa_deprn%ROWTYPE;
559: l_current_db_fa igi_iac_fa_deprn%ROWTYPE;
560: l_ytd_prorate_dists_tab igi_iac_types.prorate_dists_tab;
561: l_ytd_prorate_dists_idx binary_integer;
562: l_path_name VARCHAR2(150);

Line 559: l_current_db_fa igi_iac_fa_deprn%ROWTYPE;

555: l_reserve_cost NUMBER ;
556: l_operatg_ytd NUMBER ;
557: l_total_db_fa igi_iac_fa_deprn%ROWTYPE;
558: l_remaining_db_fa igi_iac_fa_deprn%ROWTYPE;
559: l_current_db_fa igi_iac_fa_deprn%ROWTYPE;
560: l_ytd_prorate_dists_tab igi_iac_types.prorate_dists_tab;
561: l_ytd_prorate_dists_idx binary_integer;
562: l_path_name VARCHAR2(150);
563: l_dist_ytd_factor NUMBER;

Line 873: igi_iac_fa_deprn_pkg.insert_row(

869: );
870: FETCH c_get_iac_fa_deprn INTO l_get_iac_fa_deprn;
871: IF C_get_iac_fa_deprn%FOUND THEN
872: l_rowid := NULL;
873: igi_iac_fa_deprn_pkg.insert_row(
874: x_rowid => l_rowid,
875: x_book_type_code => l_det_balances.book_type_code,
876: x_asset_id => l_det_balances.asset_id,
877: x_distribution_id => l_det_balances.distribution_id,

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

1654: x_mode => 'R' );
1655:
1656: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1657: p_full_path => l_path_name,
1658: p_string => 'Before igi_iac_fa_deprn_pkg.insert_row');
1659: l_rowid := NULL;
1660: igi_iac_fa_deprn_pkg.insert_row(
1661: x_rowid => l_rowid,
1662: x_book_type_code => l_det_balances.book_type_code,

Line 1660: igi_iac_fa_deprn_pkg.insert_row(

1656: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1657: p_full_path => l_path_name,
1658: p_string => 'Before igi_iac_fa_deprn_pkg.insert_row');
1659: l_rowid := NULL;
1660: igi_iac_fa_deprn_pkg.insert_row(
1661: x_rowid => l_rowid,
1662: x_book_type_code => l_det_balances.book_type_code,
1663: x_asset_id => l_det_balances.asset_id,
1664: x_distribution_id => l_det_balances.distribution_id,

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

1670: x_active_flag => l_det_balances.active_flag,
1671: x_mode => 'R');
1672: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1673: p_full_path => l_path_name,
1674: p_string => 'After igi_iac_fa_deprn_pkg.insert_row');
1675: END LOOP;
1676:
1677: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1678: p_full_path => l_path_name,