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_ADJ_PKG dependencies on FA_DEPRN_DETAIL

Line 911: FROM fa_deprn_detail

907: ) IS
908: SELECT SUM(nvl(deprn_amount,0)) depreciation_amount,
909: SUM(nvl(deprn_adjustment_amount,0)) depreciation_adjustment_amount,
910: SUM(nvl(deprn_reserve,0)) depreciation_reserve
911: FROM fa_deprn_detail
912: WHERE book_type_code = p_book_type_code
913: AND asset_id = p_asset_id
914: AND period_counter = p_period_counter;
915:

Line 917: CURSOR c_get_fa_deprn_detail

913: AND asset_id = p_asset_id
914: AND period_counter = p_period_counter;
915:
916:
917: CURSOR c_get_fa_deprn_detail
918: IS
919: SELECT *
920: FROM fa_deprn_detail
921: WHERE book_type_code = p_book_type_code

Line 920: FROM fa_deprn_detail

916:
917: CURSOR c_get_fa_deprn_detail
918: IS
919: SELECT *
920: FROM fa_deprn_detail
921: WHERE book_type_code = p_book_type_code
922: AND asset_id = p_asset_id
923: AND period_counter = p_period_counter;
924:

Line 929: l_get_fa_deprn_detail c_get_fa_deprn_detail%ROWTYPE;

925:
926: l_get_fa_book_info c_get_fa_book_info%ROWTYPE;
927: l_get_fa_deprn_summary c_get_fa_deprn_summary%ROWTYPE;
928: -- p_asset_iac_adj_info igi_iac_types.iac_adj_hist_asset_info;
929: l_get_fa_deprn_detail c_get_fa_deprn_detail%ROWTYPE;
930: l_get_fa_headers_info c_get_fa_headers_info%ROWTYPE;
931: l_adj_prd_rec igi_iac_types.prd_rec;
932: l_get_sum_fa_deprn c_get_sum_fa_deprn%ROWTYPE;
933:

Line 1160: --- get the distributions and for the asset from fa_deprn_detail

1156:
1157: debug_adj_asset( p_asset_iac_adj_info);
1158:
1159:
1160: --- get the distributions and for the asset from fa_deprn_detail
1161:
1162: FOR l_get_fa_deprn_detail IN c_get_fa_deprn_detail
1163: LOOP
1164: -- increment the index and copy the details into pl/sql table

Line 1162: FOR l_get_fa_deprn_detail IN c_get_fa_deprn_detail

1158:
1159:
1160: --- get the distributions and for the asset from fa_deprn_detail
1161:
1162: FOR l_get_fa_deprn_detail IN c_get_fa_deprn_detail
1163: LOOP
1164: -- increment the index and copy the details into pl/sql table
1165: g_dist_idx2:=g_dist_idx2 + 1;
1166:

Line 1167: p_asset_dist_iac_adj_info(g_dist_idx2).asset_id:=l_get_fa_deprn_detail.asset_id;

1163: LOOP
1164: -- increment the index and copy the details into pl/sql table
1165: g_dist_idx2:=g_dist_idx2 + 1;
1166:
1167: p_asset_dist_iac_adj_info(g_dist_idx2).asset_id:=l_get_fa_deprn_detail.asset_id;
1168: p_asset_dist_iac_adj_info(g_dist_idx2).book_type_code:=l_get_fa_deprn_detail.book_type_code;
1169: p_asset_dist_iac_adj_info(g_dist_idx2).distribution_id:=l_get_fa_deprn_detail.distribution_id;
1170: p_asset_dist_iac_adj_info(g_dist_idx2).period_counter :=l_get_fa_deprn_detail.period_counter;
1171:

Line 1168: p_asset_dist_iac_adj_info(g_dist_idx2).book_type_code:=l_get_fa_deprn_detail.book_type_code;

1164: -- increment the index and copy the details into pl/sql table
1165: g_dist_idx2:=g_dist_idx2 + 1;
1166:
1167: p_asset_dist_iac_adj_info(g_dist_idx2).asset_id:=l_get_fa_deprn_detail.asset_id;
1168: p_asset_dist_iac_adj_info(g_dist_idx2).book_type_code:=l_get_fa_deprn_detail.book_type_code;
1169: p_asset_dist_iac_adj_info(g_dist_idx2).distribution_id:=l_get_fa_deprn_detail.distribution_id;
1170: p_asset_dist_iac_adj_info(g_dist_idx2).period_counter :=l_get_fa_deprn_detail.period_counter;
1171:
1172: p_asset_dist_iac_adj_info(g_dist_idx2).deprn_amount :=l_get_fa_deprn_detail.deprn_amount;

Line 1169: p_asset_dist_iac_adj_info(g_dist_idx2).distribution_id:=l_get_fa_deprn_detail.distribution_id;

1165: g_dist_idx2:=g_dist_idx2 + 1;
1166:
1167: p_asset_dist_iac_adj_info(g_dist_idx2).asset_id:=l_get_fa_deprn_detail.asset_id;
1168: p_asset_dist_iac_adj_info(g_dist_idx2).book_type_code:=l_get_fa_deprn_detail.book_type_code;
1169: p_asset_dist_iac_adj_info(g_dist_idx2).distribution_id:=l_get_fa_deprn_detail.distribution_id;
1170: p_asset_dist_iac_adj_info(g_dist_idx2).period_counter :=l_get_fa_deprn_detail.period_counter;
1171:
1172: p_asset_dist_iac_adj_info(g_dist_idx2).deprn_amount :=l_get_fa_deprn_detail.deprn_amount;
1173: p_asset_dist_iac_adj_info(g_dist_idx2).ytd_deprn :=l_get_fa_deprn_detail.ytd_deprn;

Line 1170: p_asset_dist_iac_adj_info(g_dist_idx2).period_counter :=l_get_fa_deprn_detail.period_counter;

1166:
1167: p_asset_dist_iac_adj_info(g_dist_idx2).asset_id:=l_get_fa_deprn_detail.asset_id;
1168: p_asset_dist_iac_adj_info(g_dist_idx2).book_type_code:=l_get_fa_deprn_detail.book_type_code;
1169: p_asset_dist_iac_adj_info(g_dist_idx2).distribution_id:=l_get_fa_deprn_detail.distribution_id;
1170: p_asset_dist_iac_adj_info(g_dist_idx2).period_counter :=l_get_fa_deprn_detail.period_counter;
1171:
1172: p_asset_dist_iac_adj_info(g_dist_idx2).deprn_amount :=l_get_fa_deprn_detail.deprn_amount;
1173: p_asset_dist_iac_adj_info(g_dist_idx2).ytd_deprn :=l_get_fa_deprn_detail.ytd_deprn;
1174: p_asset_dist_iac_adj_info(g_dist_idx2).deprn_reserve :=l_get_fa_deprn_detail.deprn_reserve;

Line 1172: p_asset_dist_iac_adj_info(g_dist_idx2).deprn_amount :=l_get_fa_deprn_detail.deprn_amount;

1168: p_asset_dist_iac_adj_info(g_dist_idx2).book_type_code:=l_get_fa_deprn_detail.book_type_code;
1169: p_asset_dist_iac_adj_info(g_dist_idx2).distribution_id:=l_get_fa_deprn_detail.distribution_id;
1170: p_asset_dist_iac_adj_info(g_dist_idx2).period_counter :=l_get_fa_deprn_detail.period_counter;
1171:
1172: p_asset_dist_iac_adj_info(g_dist_idx2).deprn_amount :=l_get_fa_deprn_detail.deprn_amount;
1173: p_asset_dist_iac_adj_info(g_dist_idx2).ytd_deprn :=l_get_fa_deprn_detail.ytd_deprn;
1174: p_asset_dist_iac_adj_info(g_dist_idx2).deprn_reserve :=l_get_fa_deprn_detail.deprn_reserve;
1175: p_asset_dist_iac_adj_info(g_dist_idx2).deprn_adjustment_amount :=l_get_fa_deprn_detail.deprn_adjustment_amount;
1176:

Line 1173: p_asset_dist_iac_adj_info(g_dist_idx2).ytd_deprn :=l_get_fa_deprn_detail.ytd_deprn;

1169: p_asset_dist_iac_adj_info(g_dist_idx2).distribution_id:=l_get_fa_deprn_detail.distribution_id;
1170: p_asset_dist_iac_adj_info(g_dist_idx2).period_counter :=l_get_fa_deprn_detail.period_counter;
1171:
1172: p_asset_dist_iac_adj_info(g_dist_idx2).deprn_amount :=l_get_fa_deprn_detail.deprn_amount;
1173: p_asset_dist_iac_adj_info(g_dist_idx2).ytd_deprn :=l_get_fa_deprn_detail.ytd_deprn;
1174: p_asset_dist_iac_adj_info(g_dist_idx2).deprn_reserve :=l_get_fa_deprn_detail.deprn_reserve;
1175: p_asset_dist_iac_adj_info(g_dist_idx2).deprn_adjustment_amount :=l_get_fa_deprn_detail.deprn_adjustment_amount;
1176:
1177: p_asset_dist_iac_adj_info(g_dist_idx2).deprn_periods_elapsed :=0;

Line 1174: p_asset_dist_iac_adj_info(g_dist_idx2).deprn_reserve :=l_get_fa_deprn_detail.deprn_reserve;

1170: p_asset_dist_iac_adj_info(g_dist_idx2).period_counter :=l_get_fa_deprn_detail.period_counter;
1171:
1172: p_asset_dist_iac_adj_info(g_dist_idx2).deprn_amount :=l_get_fa_deprn_detail.deprn_amount;
1173: p_asset_dist_iac_adj_info(g_dist_idx2).ytd_deprn :=l_get_fa_deprn_detail.ytd_deprn;
1174: p_asset_dist_iac_adj_info(g_dist_idx2).deprn_reserve :=l_get_fa_deprn_detail.deprn_reserve;
1175: p_asset_dist_iac_adj_info(g_dist_idx2).deprn_adjustment_amount :=l_get_fa_deprn_detail.deprn_adjustment_amount;
1176:
1177: p_asset_dist_iac_adj_info(g_dist_idx2).deprn_periods_elapsed :=0;
1178: p_asset_dist_iac_adj_info(g_dist_idx2).deprn_periods_current_year :=0;

Line 1175: p_asset_dist_iac_adj_info(g_dist_idx2).deprn_adjustment_amount :=l_get_fa_deprn_detail.deprn_adjustment_amount;

1171:
1172: p_asset_dist_iac_adj_info(g_dist_idx2).deprn_amount :=l_get_fa_deprn_detail.deprn_amount;
1173: p_asset_dist_iac_adj_info(g_dist_idx2).ytd_deprn :=l_get_fa_deprn_detail.ytd_deprn;
1174: p_asset_dist_iac_adj_info(g_dist_idx2).deprn_reserve :=l_get_fa_deprn_detail.deprn_reserve;
1175: p_asset_dist_iac_adj_info(g_dist_idx2).deprn_adjustment_amount :=l_get_fa_deprn_detail.deprn_adjustment_amount;
1176:
1177: p_asset_dist_iac_adj_info(g_dist_idx2).deprn_periods_elapsed :=0;
1178: p_asset_dist_iac_adj_info(g_dist_idx2).deprn_periods_current_year :=0;
1179: p_asset_dist_iac_adj_info(g_dist_idx2).deprn_periods_prior_year :=0;