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 865: IGI_IAC_FA_DEPRN_PKG.insert_row (

861: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve => '||l_fa_balances.deprn_reserve);
862: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_ytd_deprn => '||l_fa_balances.ytd_deprn);
863: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag => '||l_det_balances.active_flag);
864:
865: IGI_IAC_FA_DEPRN_PKG.insert_row (
866: x_rowid => l_rowid,
867: x_adjustment_id => l_det_balances.adjustment_id,
868: x_asset_id => l_det_balances.asset_id,
869: x_distribution_id => l_det_balances.distribution_id,

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

885: p_book_type_code igi_iac_det_balances.book_type_code%TYPE,
886: p_adjustment_id igi_iac_det_balances.adjustment_id%TYPE,
887: p_period_counter igi_iac_det_balances.period_counter%TYPE,
888: p_iac_inactive_dists_ytd IN OUT NOCOPY igi_iac_det_balances.deprn_ytd%TYPE,
889: p_fa_inactive_dists_ytd IN OUT NOCOPY igi_iac_fa_deprn.deprn_ytd%TYPE)
890: RETURN BOOLEAN IS
891:
892: CURSOR c_get_prev_adjustment IS
893: SELECT max(adjustment_id)

Line 931: -- igi_iac_fa_deprn for inactive distributions

927: AND iidb.book_type_code = p_book_type_code
928: AND nvl(iidb.active_flag,'Y') = 'N';
929:
930: -- Cursor to fetch depreciation balances from
931: -- igi_iac_fa_deprn for inactive distributions
932: CURSOR c_get_fa_inactive_dists(cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE)
933: IS
934: SELECT iifd.distribution_id,
935: iifd.deprn_period,

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

928: AND nvl(iidb.active_flag,'Y') = 'N';
929:
930: -- Cursor to fetch depreciation balances from
931: -- igi_iac_fa_deprn for inactive distributions
932: CURSOR c_get_fa_inactive_dists(cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE)
933: IS
934: SELECT iifd.distribution_id,
935: iifd.deprn_period,
936: iifd.deprn_ytd,

Line 939: FROM igi_iac_fa_deprn iifd

935: iifd.deprn_period,
936: iifd.deprn_ytd,
937: iifd.deprn_reserve,
938: iifd.active_flag
939: FROM igi_iac_fa_deprn iifd
940: WHERE iifd.adjustment_id = cp_adjustment_id
941: AND iifd.book_type_code = p_book_type_code
942: AND iifd.asset_id = p_asset_id
943: AND nvl(iifd.active_flag,'Y') = 'N';

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

998: l_iac_inactive_dists_ytd := l_iac_inactive_dists_ytd + l_iac_inactive_dist.deprn_ytd;
999: END LOOP;
1000:
1001: FOR l_fa_inactive_dist IN c_get_fa_inactive_dists(l_prev_adjustment_id) LOOP
1002: -- insert into igi_iac_fa_deprn with the new adjustment_id
1003: l_rowid := NULL;
1004: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1005: x_rowid => l_rowid,
1006: x_book_type_code => p_book_type_code,

Line 1004: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

1000:
1001: FOR l_fa_inactive_dist IN c_get_fa_inactive_dists(l_prev_adjustment_id) LOOP
1002: -- insert into igi_iac_fa_deprn with the new adjustment_id
1003: l_rowid := NULL;
1004: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1005: x_rowid => l_rowid,
1006: x_book_type_code => p_book_type_code,
1007: x_asset_id => p_asset_id,
1008: x_period_counter => p_period_counter,

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

1030: p_book_type_code igi_iac_det_balances.book_type_code%TYPE,
1031: p_adjustment_id igi_iac_det_balances.adjustment_id%TYPE,
1032: p_period_counter igi_iac_det_balances.period_counter%TYPE,
1033: p_asset_iac_ytd IN OUT NOCOPY igi_iac_det_balances.deprn_ytd%TYPE,
1034: p_asset_fa_ytd IN OUT NOCOPY igi_iac_fa_deprn.deprn_ytd%TYPE,
1035: p_YTD_prorate_dists_tab igi_iac_types.prorate_dists_tab,
1036: p_YTD_prorate_dists_idx binary_integer)
1037: RETURN BOOLEAN IS
1038:

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

1097: x_cumulative_reval_factor => 0,
1098: x_active_flag => 'N',
1099: x_mode => 'R' );
1100:
1101: -- insert into igi_iac_fa_deprn with the new adjustment_id
1102: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Inserting into igi_iac_fa_deprn');
1103: l_rowid := NULL;
1104: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1105: x_rowid => l_rowid,

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

1098: x_active_flag => 'N',
1099: x_mode => 'R' );
1100:
1101: -- insert into igi_iac_fa_deprn with the new adjustment_id
1102: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Inserting into igi_iac_fa_deprn');
1103: l_rowid := NULL;
1104: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1105: x_rowid => l_rowid,
1106: x_book_type_code => p_book_type_code,

Line 1104: IGI_IAC_FA_DEPRN_PKG.Insert_Row(

1100:
1101: -- insert into igi_iac_fa_deprn with the new adjustment_id
1102: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Inserting into igi_iac_fa_deprn');
1103: l_rowid := NULL;
1104: IGI_IAC_FA_DEPRN_PKG.Insert_Row(
1105: x_rowid => l_rowid,
1106: x_book_type_code => p_book_type_code,
1107: x_asset_id => p_asset_id,
1108: x_period_counter => p_period_counter,

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

1155: where period_close_date is NULL
1156: and book_type_code = fp_reval_params.reval_asset_params.book_type_code))
1157: group by fdd.asset_id,fdd.distribution_id;
1158:
1159: cursor c_get_prev_fa_deprn(cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE,
1160: cp_distribution_id igi_iac_fa_deprn.distribution_id%TYPE) is
1161: select iifd.deprn_period, iifd.deprn_ytd, iifd.deprn_reserve
1162: from igi_iac_fa_deprn iifd
1163: where iifd.asset_id = fp_reval_params.reval_asset_params.asset_id

Line 1160: cp_distribution_id igi_iac_fa_deprn.distribution_id%TYPE) is

1156: and book_type_code = fp_reval_params.reval_asset_params.book_type_code))
1157: group by fdd.asset_id,fdd.distribution_id;
1158:
1159: cursor c_get_prev_fa_deprn(cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE,
1160: cp_distribution_id igi_iac_fa_deprn.distribution_id%TYPE) is
1161: select iifd.deprn_period, iifd.deprn_ytd, iifd.deprn_reserve
1162: from igi_iac_fa_deprn iifd
1163: where iifd.asset_id = fp_reval_params.reval_asset_params.asset_id
1164: and iifd.book_type_code = fp_reval_params.reval_asset_params.book_type_code

Line 1162: from igi_iac_fa_deprn iifd

1158:
1159: cursor c_get_prev_fa_deprn(cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE,
1160: cp_distribution_id igi_iac_fa_deprn.distribution_id%TYPE) is
1161: select iifd.deprn_period, iifd.deprn_ytd, iifd.deprn_reserve
1162: from igi_iac_fa_deprn iifd
1163: where iifd.asset_id = fp_reval_params.reval_asset_params.asset_id
1164: and iifd.book_type_code = fp_reval_params.reval_asset_params.book_type_code
1165: and iifd.adjustment_id = cp_adjustment_id
1166: and iifd.distribution_id = cp_distribution_id;

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

1442: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+forward inactive detail balances Failed');
1443: return false;
1444: ELSE
1445: l_deprn_ytd_total := l_deprn_ytd_total - l_iac_inactive_dists_ytd; /* YTD for igi_iac_det_balances */
1446: l_total_fa.ytd_deprn := l_total_fa.ytd_deprn - l_fa_inactive_dists_ytd; /* YTD for igi_iac_fa_deprn */
1447: END IF;
1448:
1449: IF (fp_reval_params.reval_control.transaction_type_code = 'REVALUATION' AND
1450: fp_reval_params.reval_control.first_time_flag) THEN

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

1574: end if;
1575:
1576: l_db_fa := l_total_fa; /* initalize */
1577:
1578: l_db_fa.ytd_deprn := l_total_fa.ytd_deprn * l_ytd_factor; /* YTD for igi_iac_fa_deprn */
1579: l_db_fa.deprn_amount := l_total_fa.deprn_amount * l_factor;
1580: l_db_fa.deprn_reserve := l_total_fa.deprn_reserve * l_factor;
1581:
1582: round_fa_figures ( fp_fa_hist => l_db_fa , fp_det_balances => l_db );

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

1628: round_det_balances ( l_db ) ;
1629:
1630: l_db_fa := l_total_fa; /* initalize */
1631:
1632: l_db_fa.ytd_deprn := l_total_fa.ytd_deprn * l_ytd_factor; /* YTD for igi_iac_fa_deprn */
1633: l_db_fa.deprn_amount := l_remaining_fa.deprn_amount;
1634: l_db_fa.deprn_reserve := l_remaining_fa.deprn_reserve;
1635:
1636: if not igi_iac_common_utils.iac_round ( x_amount => l_dist_deprn_ytd