eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGI_IAC_REVAL_CRUD dependencies on IGI_IAC_FA_DEPRN

Line 888: IGI_IAC_FA_DEPRN_PKG.insert_row (

884: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve => '||l_fa_balances.deprn_reserve);
885: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_ytd_deprn => '||l_fa_balances.ytd_deprn);
886: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag => '||l_det_balances.active_flag);
887:
888: IGI_IAC_FA_DEPRN_PKG.insert_row (
889: x_rowid => l_rowid,
890: x_adjustment_id => l_det_balances.adjustment_id,
891: x_asset_id => l_det_balances.asset_id,
892: x_distribution_id => l_det_balances.distribution_id,

Line 912: p_fa_inactive_dists_ytd IN OUT NOCOPY igi_iac_fa_deprn.deprn_ytd%TYPE)

908: p_book_type_code igi_iac_det_balances.book_type_code%TYPE,
909: p_adjustment_id igi_iac_det_balances.adjustment_id%TYPE,
910: p_period_counter igi_iac_det_balances.period_counter%TYPE,
911: p_iac_inactive_dists_ytd IN OUT NOCOPY igi_iac_det_balances.deprn_ytd%TYPE,
912: p_fa_inactive_dists_ytd IN OUT NOCOPY igi_iac_fa_deprn.deprn_ytd%TYPE)
913: RETURN BOOLEAN IS
914:
915: CURSOR c_get_prev_adjustment IS
916: SELECT max(adjustment_id)

Line 954: -- igi_iac_fa_deprn for inactive distributions

950: AND iidb.book_type_code = p_book_type_code
951: AND nvl(iidb.active_flag,'Y') = 'N';
952:
953: -- Cursor to fetch depreciation balances from
954: -- igi_iac_fa_deprn for inactive distributions
955: CURSOR c_get_fa_inactive_dists(cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE)
956: IS
957: SELECT iifd.distribution_id,
958: iifd.deprn_period,

Line 955: CURSOR c_get_fa_inactive_dists(cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE)

951: AND nvl(iidb.active_flag,'Y') = 'N';
952:
953: -- Cursor to fetch depreciation balances from
954: -- igi_iac_fa_deprn for inactive distributions
955: CURSOR c_get_fa_inactive_dists(cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE)
956: IS
957: SELECT iifd.distribution_id,
958: iifd.deprn_period,
959: iifd.deprn_ytd,

Line 962: FROM igi_iac_fa_deprn iifd

958: iifd.deprn_period,
959: iifd.deprn_ytd,
960: iifd.deprn_reserve,
961: iifd.active_flag
962: FROM igi_iac_fa_deprn iifd
963: WHERE iifd.adjustment_id = cp_adjustment_id
964: AND iifd.book_type_code = p_book_type_code
965: AND iifd.asset_id = p_asset_id
966: AND nvl(iifd.active_flag,'Y') = 'N';

Line 1025: -- insert into igi_iac_fa_deprn with the new adjustment_id

1021: l_iac_inactive_dists_ytd := l_iac_inactive_dists_ytd + l_iac_inactive_dist.deprn_ytd;
1022: END LOOP;
1023:
1024: FOR l_fa_inactive_dist IN c_get_fa_inactive_dists(l_prev_adjustment_id) LOOP
1025: -- insert into igi_iac_fa_deprn with the new adjustment_id
1026: l_rowid := NULL;
1027: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1028: x_rowid => l_rowid,
1029: x_book_type_code => p_book_type_code,

Line 1027: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

1023:
1024: FOR l_fa_inactive_dist IN c_get_fa_inactive_dists(l_prev_adjustment_id) LOOP
1025: -- insert into igi_iac_fa_deprn with the new adjustment_id
1026: l_rowid := NULL;
1027: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1028: x_rowid => l_rowid,
1029: x_book_type_code => p_book_type_code,
1030: x_asset_id => p_asset_id,
1031: x_period_counter => p_period_counter,

Line 1057: p_asset_fa_ytd IN OUT NOCOPY igi_iac_fa_deprn.deprn_ytd%TYPE,

1053: p_book_type_code igi_iac_det_balances.book_type_code%TYPE,
1054: p_adjustment_id igi_iac_det_balances.adjustment_id%TYPE,
1055: p_period_counter igi_iac_det_balances.period_counter%TYPE,
1056: p_asset_iac_ytd IN OUT NOCOPY igi_iac_det_balances.deprn_ytd%TYPE,
1057: p_asset_fa_ytd IN OUT NOCOPY igi_iac_fa_deprn.deprn_ytd%TYPE,
1058: p_YTD_prorate_dists_tab igi_iac_types.prorate_dists_tab,
1059: p_YTD_prorate_dists_idx binary_integer)
1060: RETURN BOOLEAN IS
1061:

Line 1117: -- insert into igi_iac_fa_deprn with the new adjustment_id

1113: x_cumulative_reval_factor => 0,
1114: x_active_flag => 'N',
1115: x_mode => 'R' );
1116:
1117: -- insert into igi_iac_fa_deprn with the new adjustment_id
1118: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Inserting into igi_iac_fa_deprn');
1119: l_rowid := NULL;
1120: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1121: x_rowid => l_rowid,

Line 1118: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Inserting into igi_iac_fa_deprn');

1114: x_active_flag => 'N',
1115: x_mode => 'R' );
1116:
1117: -- insert into igi_iac_fa_deprn with the new adjustment_id
1118: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Inserting into igi_iac_fa_deprn');
1119: l_rowid := NULL;
1120: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1121: x_rowid => l_rowid,
1122: x_book_type_code => p_book_type_code,

Line 1120: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

1116:
1117: -- insert into igi_iac_fa_deprn with the new adjustment_id
1118: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Inserting into igi_iac_fa_deprn');
1119: l_rowid := NULL;
1120: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1121: x_rowid => l_rowid,
1122: x_book_type_code => p_book_type_code,
1123: x_asset_id => p_asset_id,
1124: x_period_counter => p_period_counter,

Line 1175: cursor c_get_prev_fa_deprn(cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE,

1171: where period_close_date is NULL
1172: and book_type_code = fp_reval_params.reval_asset_params.book_type_code))
1173: group by fdd.asset_id,fdd.distribution_id;
1174:
1175: cursor c_get_prev_fa_deprn(cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE,
1176: cp_distribution_id igi_iac_fa_deprn.distribution_id%TYPE) is
1177: select iifd.deprn_period, iifd.deprn_ytd, iifd.deprn_reserve
1178: from igi_iac_fa_deprn iifd
1179: where iifd.asset_id = fp_reval_params.reval_asset_params.asset_id

Line 1176: cp_distribution_id igi_iac_fa_deprn.distribution_id%TYPE) is

1172: and book_type_code = fp_reval_params.reval_asset_params.book_type_code))
1173: group by fdd.asset_id,fdd.distribution_id;
1174:
1175: cursor c_get_prev_fa_deprn(cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE,
1176: cp_distribution_id igi_iac_fa_deprn.distribution_id%TYPE) is
1177: select iifd.deprn_period, iifd.deprn_ytd, iifd.deprn_reserve
1178: from igi_iac_fa_deprn iifd
1179: where iifd.asset_id = fp_reval_params.reval_asset_params.asset_id
1180: and iifd.book_type_code = fp_reval_params.reval_asset_params.book_type_code

Line 1178: from igi_iac_fa_deprn iifd

1174:
1175: cursor c_get_prev_fa_deprn(cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE,
1176: cp_distribution_id igi_iac_fa_deprn.distribution_id%TYPE) is
1177: select iifd.deprn_period, iifd.deprn_ytd, iifd.deprn_reserve
1178: from igi_iac_fa_deprn iifd
1179: where iifd.asset_id = fp_reval_params.reval_asset_params.asset_id
1180: and iifd.book_type_code = fp_reval_params.reval_asset_params.book_type_code
1181: and iifd.adjustment_id = cp_adjustment_id
1182: and iifd.distribution_id = cp_distribution_id;

Line 1462: l_total_fa.ytd_deprn := l_total_fa.ytd_deprn - l_fa_inactive_dists_ytd; /* YTD for igi_iac_fa_deprn */

1458: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+forward inactive detail balances Failed');
1459: return false;
1460: ELSE
1461: l_deprn_ytd_total := l_deprn_ytd_total - l_iac_inactive_dists_ytd; /* YTD for igi_iac_det_balances */
1462: l_total_fa.ytd_deprn := l_total_fa.ytd_deprn - l_fa_inactive_dists_ytd; /* YTD for igi_iac_fa_deprn */
1463: END IF;
1464:
1465: IF (fp_reval_params.reval_control.transaction_type_code = 'REVALUATION' AND
1466: fp_reval_params.reval_control.first_time_flag) THEN

Line 1618: l_db_fa.ytd_deprn := l_total_fa.ytd_deprn * l_ytd_factor; /* YTD for igi_iac_fa_deprn */

1614: end if;
1615:
1616: l_db_fa := l_total_fa; /* initalize */
1617:
1618: l_db_fa.ytd_deprn := l_total_fa.ytd_deprn * l_ytd_factor; /* YTD for igi_iac_fa_deprn */
1619: do_round(l_db_fa.ytd_deprn,fp_reval_params.reval_output_asset_mvmt.book_type_code);
1620: l_db_fa.deprn_amount := l_total_fa.deprn_amount * l_factor;
1621: do_round(l_db_fa.deprn_amount,fp_reval_params.reval_output_asset_mvmt.book_type_code);
1622: l_db_fa.deprn_reserve := l_total_fa.deprn_reserve * l_factor;

Line 1678: l_db_fa.ytd_deprn := l_total_fa.ytd_deprn * l_ytd_factor; /* YTD for igi_iac_fa_deprn */

1674:
1675:
1676: l_db_fa := l_total_fa; /* initalize */
1677:
1678: l_db_fa.ytd_deprn := l_total_fa.ytd_deprn * l_ytd_factor; /* YTD for igi_iac_fa_deprn */
1679: do_round(l_db_fa.ytd_deprn,fp_reval_params.reval_output_asset_mvmt.book_type_code);
1680: l_db_fa.deprn_amount := l_remaining_fa.deprn_amount;
1681: l_db_fa.deprn_reserve := l_remaining_fa.deprn_reserve;
1682: