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_PROJ_PKG dependencies on IGI_IAC_PROJ_DETAILS

Line 868: TYPE asset_id_type1 IS TABLE OF igi_iac_proj_details.asset_id%TYPE INDEX BY BINARY_INTEGER;

864: -- variables
865: -- variables for projection detail records
866: TYPE asset_id_type IS TABLE OF fa_books.asset_id%TYPE INDEX BY BINARY_INTEGER;
867:
868: TYPE asset_id_type1 IS TABLE OF igi_iac_proj_details.asset_id%TYPE INDEX BY BINARY_INTEGER;
869: TYPE proj_id_type IS TABLE OF igi_iac_proj_details.projection_id%TYPE INDEX BY BINARY_INTEGER;
870: TYPE period_counter_type IS TABLE OF igi_iac_proj_details.projection_id%TYPE INDEX BY BINARY_INTEGER;
871: TYPE category_id_type IS TABLE OF igi_iac_proj_details.category_id%TYPE INDEX BY BINARY_INTEGER;
872: TYPE fiscal_year_type IS TABLE OF igi_iac_proj_details.fiscal_year%TYPE INDEX BY BINARY_INTEGER;

Line 869: TYPE proj_id_type IS TABLE OF igi_iac_proj_details.projection_id%TYPE INDEX BY BINARY_INTEGER;

865: -- variables for projection detail records
866: TYPE asset_id_type IS TABLE OF fa_books.asset_id%TYPE INDEX BY BINARY_INTEGER;
867:
868: TYPE asset_id_type1 IS TABLE OF igi_iac_proj_details.asset_id%TYPE INDEX BY BINARY_INTEGER;
869: TYPE proj_id_type IS TABLE OF igi_iac_proj_details.projection_id%TYPE INDEX BY BINARY_INTEGER;
870: TYPE period_counter_type IS TABLE OF igi_iac_proj_details.projection_id%TYPE INDEX BY BINARY_INTEGER;
871: TYPE category_id_type IS TABLE OF igi_iac_proj_details.category_id%TYPE INDEX BY BINARY_INTEGER;
872: TYPE fiscal_year_type IS TABLE OF igi_iac_proj_details.fiscal_year%TYPE INDEX BY BINARY_INTEGER;
873: TYPE company_type IS TABLE OF igi_iac_proj_details.company%TYPE INDEX BY BINARY_INTEGER;

Line 870: TYPE period_counter_type IS TABLE OF igi_iac_proj_details.projection_id%TYPE INDEX BY BINARY_INTEGER;

866: TYPE asset_id_type IS TABLE OF fa_books.asset_id%TYPE INDEX BY BINARY_INTEGER;
867:
868: TYPE asset_id_type1 IS TABLE OF igi_iac_proj_details.asset_id%TYPE INDEX BY BINARY_INTEGER;
869: TYPE proj_id_type IS TABLE OF igi_iac_proj_details.projection_id%TYPE INDEX BY BINARY_INTEGER;
870: TYPE period_counter_type IS TABLE OF igi_iac_proj_details.projection_id%TYPE INDEX BY BINARY_INTEGER;
871: TYPE category_id_type IS TABLE OF igi_iac_proj_details.category_id%TYPE INDEX BY BINARY_INTEGER;
872: TYPE fiscal_year_type IS TABLE OF igi_iac_proj_details.fiscal_year%TYPE INDEX BY BINARY_INTEGER;
873: TYPE company_type IS TABLE OF igi_iac_proj_details.company%TYPE INDEX BY BINARY_INTEGER;
874: TYPE cost_center_type IS TABLE OF igi_iac_proj_details.cost_center%TYPE INDEX BY BINARY_INTEGER;

Line 871: TYPE category_id_type IS TABLE OF igi_iac_proj_details.category_id%TYPE INDEX BY BINARY_INTEGER;

867:
868: TYPE asset_id_type1 IS TABLE OF igi_iac_proj_details.asset_id%TYPE INDEX BY BINARY_INTEGER;
869: TYPE proj_id_type IS TABLE OF igi_iac_proj_details.projection_id%TYPE INDEX BY BINARY_INTEGER;
870: TYPE period_counter_type IS TABLE OF igi_iac_proj_details.projection_id%TYPE INDEX BY BINARY_INTEGER;
871: TYPE category_id_type IS TABLE OF igi_iac_proj_details.category_id%TYPE INDEX BY BINARY_INTEGER;
872: TYPE fiscal_year_type IS TABLE OF igi_iac_proj_details.fiscal_year%TYPE INDEX BY BINARY_INTEGER;
873: TYPE company_type IS TABLE OF igi_iac_proj_details.company%TYPE INDEX BY BINARY_INTEGER;
874: TYPE cost_center_type IS TABLE OF igi_iac_proj_details.cost_center%TYPE INDEX BY BINARY_INTEGER;
875: TYPE reval_cost_type IS TABLE OF igi_iac_proj_details.latest_reval_cost%TYPE INDEX BY BINARY_INTEGER;

Line 872: TYPE fiscal_year_type IS TABLE OF igi_iac_proj_details.fiscal_year%TYPE INDEX BY BINARY_INTEGER;

868: TYPE asset_id_type1 IS TABLE OF igi_iac_proj_details.asset_id%TYPE INDEX BY BINARY_INTEGER;
869: TYPE proj_id_type IS TABLE OF igi_iac_proj_details.projection_id%TYPE INDEX BY BINARY_INTEGER;
870: TYPE period_counter_type IS TABLE OF igi_iac_proj_details.projection_id%TYPE INDEX BY BINARY_INTEGER;
871: TYPE category_id_type IS TABLE OF igi_iac_proj_details.category_id%TYPE INDEX BY BINARY_INTEGER;
872: TYPE fiscal_year_type IS TABLE OF igi_iac_proj_details.fiscal_year%TYPE INDEX BY BINARY_INTEGER;
873: TYPE company_type IS TABLE OF igi_iac_proj_details.company%TYPE INDEX BY BINARY_INTEGER;
874: TYPE cost_center_type IS TABLE OF igi_iac_proj_details.cost_center%TYPE INDEX BY BINARY_INTEGER;
875: TYPE reval_cost_type IS TABLE OF igi_iac_proj_details.latest_reval_cost%TYPE INDEX BY BINARY_INTEGER;
876: TYPE deprn_period_type IS TABLE OF igi_iac_proj_details.deprn_period%TYPE INDEX BY BINARY_INTEGER;

Line 873: TYPE company_type IS TABLE OF igi_iac_proj_details.company%TYPE INDEX BY BINARY_INTEGER;

869: TYPE proj_id_type IS TABLE OF igi_iac_proj_details.projection_id%TYPE INDEX BY BINARY_INTEGER;
870: TYPE period_counter_type IS TABLE OF igi_iac_proj_details.projection_id%TYPE INDEX BY BINARY_INTEGER;
871: TYPE category_id_type IS TABLE OF igi_iac_proj_details.category_id%TYPE INDEX BY BINARY_INTEGER;
872: TYPE fiscal_year_type IS TABLE OF igi_iac_proj_details.fiscal_year%TYPE INDEX BY BINARY_INTEGER;
873: TYPE company_type IS TABLE OF igi_iac_proj_details.company%TYPE INDEX BY BINARY_INTEGER;
874: TYPE cost_center_type IS TABLE OF igi_iac_proj_details.cost_center%TYPE INDEX BY BINARY_INTEGER;
875: TYPE reval_cost_type IS TABLE OF igi_iac_proj_details.latest_reval_cost%TYPE INDEX BY BINARY_INTEGER;
876: TYPE deprn_period_type IS TABLE OF igi_iac_proj_details.deprn_period%TYPE INDEX BY BINARY_INTEGER;
877: TYPE deprn_ytd_type IS TABLE OF igi_iac_proj_details.deprn_ytd%TYPE INDEX BY BINARY_INTEGER;

Line 874: TYPE cost_center_type IS TABLE OF igi_iac_proj_details.cost_center%TYPE INDEX BY BINARY_INTEGER;

870: TYPE period_counter_type IS TABLE OF igi_iac_proj_details.projection_id%TYPE INDEX BY BINARY_INTEGER;
871: TYPE category_id_type IS TABLE OF igi_iac_proj_details.category_id%TYPE INDEX BY BINARY_INTEGER;
872: TYPE fiscal_year_type IS TABLE OF igi_iac_proj_details.fiscal_year%TYPE INDEX BY BINARY_INTEGER;
873: TYPE company_type IS TABLE OF igi_iac_proj_details.company%TYPE INDEX BY BINARY_INTEGER;
874: TYPE cost_center_type IS TABLE OF igi_iac_proj_details.cost_center%TYPE INDEX BY BINARY_INTEGER;
875: TYPE reval_cost_type IS TABLE OF igi_iac_proj_details.latest_reval_cost%TYPE INDEX BY BINARY_INTEGER;
876: TYPE deprn_period_type IS TABLE OF igi_iac_proj_details.deprn_period%TYPE INDEX BY BINARY_INTEGER;
877: TYPE deprn_ytd_type IS TABLE OF igi_iac_proj_details.deprn_ytd%TYPE INDEX BY BINARY_INTEGER;
878: TYPE asset_exception_type IS TABLE OF igi_iac_proj_details.asset_exception%TYPE INDEX BY BINARY_INTEGER;

Line 875: TYPE reval_cost_type IS TABLE OF igi_iac_proj_details.latest_reval_cost%TYPE INDEX BY BINARY_INTEGER;

871: TYPE category_id_type IS TABLE OF igi_iac_proj_details.category_id%TYPE INDEX BY BINARY_INTEGER;
872: TYPE fiscal_year_type IS TABLE OF igi_iac_proj_details.fiscal_year%TYPE INDEX BY BINARY_INTEGER;
873: TYPE company_type IS TABLE OF igi_iac_proj_details.company%TYPE INDEX BY BINARY_INTEGER;
874: TYPE cost_center_type IS TABLE OF igi_iac_proj_details.cost_center%TYPE INDEX BY BINARY_INTEGER;
875: TYPE reval_cost_type IS TABLE OF igi_iac_proj_details.latest_reval_cost%TYPE INDEX BY BINARY_INTEGER;
876: TYPE deprn_period_type IS TABLE OF igi_iac_proj_details.deprn_period%TYPE INDEX BY BINARY_INTEGER;
877: TYPE deprn_ytd_type IS TABLE OF igi_iac_proj_details.deprn_ytd%TYPE INDEX BY BINARY_INTEGER;
878: TYPE asset_exception_type IS TABLE OF igi_iac_proj_details.asset_exception%TYPE INDEX BY BINARY_INTEGER;
879: TYPE reccount_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 876: TYPE deprn_period_type IS TABLE OF igi_iac_proj_details.deprn_period%TYPE INDEX BY BINARY_INTEGER;

872: TYPE fiscal_year_type IS TABLE OF igi_iac_proj_details.fiscal_year%TYPE INDEX BY BINARY_INTEGER;
873: TYPE company_type IS TABLE OF igi_iac_proj_details.company%TYPE INDEX BY BINARY_INTEGER;
874: TYPE cost_center_type IS TABLE OF igi_iac_proj_details.cost_center%TYPE INDEX BY BINARY_INTEGER;
875: TYPE reval_cost_type IS TABLE OF igi_iac_proj_details.latest_reval_cost%TYPE INDEX BY BINARY_INTEGER;
876: TYPE deprn_period_type IS TABLE OF igi_iac_proj_details.deprn_period%TYPE INDEX BY BINARY_INTEGER;
877: TYPE deprn_ytd_type IS TABLE OF igi_iac_proj_details.deprn_ytd%TYPE INDEX BY BINARY_INTEGER;
878: TYPE asset_exception_type IS TABLE OF igi_iac_proj_details.asset_exception%TYPE INDEX BY BINARY_INTEGER;
879: TYPE reccount_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
880:

Line 877: TYPE deprn_ytd_type IS TABLE OF igi_iac_proj_details.deprn_ytd%TYPE INDEX BY BINARY_INTEGER;

873: TYPE company_type IS TABLE OF igi_iac_proj_details.company%TYPE INDEX BY BINARY_INTEGER;
874: TYPE cost_center_type IS TABLE OF igi_iac_proj_details.cost_center%TYPE INDEX BY BINARY_INTEGER;
875: TYPE reval_cost_type IS TABLE OF igi_iac_proj_details.latest_reval_cost%TYPE INDEX BY BINARY_INTEGER;
876: TYPE deprn_period_type IS TABLE OF igi_iac_proj_details.deprn_period%TYPE INDEX BY BINARY_INTEGER;
877: TYPE deprn_ytd_type IS TABLE OF igi_iac_proj_details.deprn_ytd%TYPE INDEX BY BINARY_INTEGER;
878: TYPE asset_exception_type IS TABLE OF igi_iac_proj_details.asset_exception%TYPE INDEX BY BINARY_INTEGER;
879: TYPE reccount_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
880:
881: TYPE proj_details IS RECORD (

Line 878: TYPE asset_exception_type IS TABLE OF igi_iac_proj_details.asset_exception%TYPE INDEX BY BINARY_INTEGER;

874: TYPE cost_center_type IS TABLE OF igi_iac_proj_details.cost_center%TYPE INDEX BY BINARY_INTEGER;
875: TYPE reval_cost_type IS TABLE OF igi_iac_proj_details.latest_reval_cost%TYPE INDEX BY BINARY_INTEGER;
876: TYPE deprn_period_type IS TABLE OF igi_iac_proj_details.deprn_period%TYPE INDEX BY BINARY_INTEGER;
877: TYPE deprn_ytd_type IS TABLE OF igi_iac_proj_details.deprn_ytd%TYPE INDEX BY BINARY_INTEGER;
878: TYPE asset_exception_type IS TABLE OF igi_iac_proj_details.asset_exception%TYPE INDEX BY BINARY_INTEGER;
879: TYPE reccount_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
880:
881: TYPE proj_details IS RECORD (
882: record_counter reccount_type,

Line 924: l_hist_deprn_period igi_iac_proj_details.deprn_period%TYPE;

920: l_cc_seg VARCHAR2(30);
921:
922: l_hist_cost fa_books.cost%TYPE;
923: l_iac_cost igi_iac_asset_balances.adjusted_cost%TYPE;
924: l_hist_deprn_period igi_iac_proj_details.deprn_period%TYPE;
925: l_iac_deprn_period igi_iac_proj_details.deprn_period%TYPE;
926: l_hist_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;
927: l_iac_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;
928:

Line 925: l_iac_deprn_period igi_iac_proj_details.deprn_period%TYPE;

921:
922: l_hist_cost fa_books.cost%TYPE;
923: l_iac_cost igi_iac_asset_balances.adjusted_cost%TYPE;
924: l_hist_deprn_period igi_iac_proj_details.deprn_period%TYPE;
925: l_iac_deprn_period igi_iac_proj_details.deprn_period%TYPE;
926: l_hist_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;
927: l_iac_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;
928:
929: l_curr_cost fa_books.cost%TYPE;

Line 926: l_hist_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;

922: l_hist_cost fa_books.cost%TYPE;
923: l_iac_cost igi_iac_asset_balances.adjusted_cost%TYPE;
924: l_hist_deprn_period igi_iac_proj_details.deprn_period%TYPE;
925: l_iac_deprn_period igi_iac_proj_details.deprn_period%TYPE;
926: l_hist_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;
927: l_iac_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;
928:
929: l_curr_cost fa_books.cost%TYPE;
930: l_prev_cost fa_books.cost%TYPE;

Line 927: l_iac_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;

923: l_iac_cost igi_iac_asset_balances.adjusted_cost%TYPE;
924: l_hist_deprn_period igi_iac_proj_details.deprn_period%TYPE;
925: l_iac_deprn_period igi_iac_proj_details.deprn_period%TYPE;
926: l_hist_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;
927: l_iac_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;
928:
929: l_curr_cost fa_books.cost%TYPE;
930: l_prev_cost fa_books.cost%TYPE;
931: l_curr_deprn_period igi_iac_proj_details.deprn_period%TYPE;

Line 931: l_curr_deprn_period igi_iac_proj_details.deprn_period%TYPE;

927: l_iac_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;
928:
929: l_curr_cost fa_books.cost%TYPE;
930: l_prev_cost fa_books.cost%TYPE;
931: l_curr_deprn_period igi_iac_proj_details.deprn_period%TYPE;
932: l_prev_deprn_period igi_iac_proj_details.deprn_period%TYPE;
933: l_curr_deprn_period_catchup igi_iac_proj_details.deprn_period%TYPE;
934: l_curr_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;
935: l_prev_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;

Line 932: l_prev_deprn_period igi_iac_proj_details.deprn_period%TYPE;

928:
929: l_curr_cost fa_books.cost%TYPE;
930: l_prev_cost fa_books.cost%TYPE;
931: l_curr_deprn_period igi_iac_proj_details.deprn_period%TYPE;
932: l_prev_deprn_period igi_iac_proj_details.deprn_period%TYPE;
933: l_curr_deprn_period_catchup igi_iac_proj_details.deprn_period%TYPE;
934: l_curr_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;
935: l_prev_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;
936: l_prior_prd_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;

Line 933: l_curr_deprn_period_catchup igi_iac_proj_details.deprn_period%TYPE;

929: l_curr_cost fa_books.cost%TYPE;
930: l_prev_cost fa_books.cost%TYPE;
931: l_curr_deprn_period igi_iac_proj_details.deprn_period%TYPE;
932: l_prev_deprn_period igi_iac_proj_details.deprn_period%TYPE;
933: l_curr_deprn_period_catchup igi_iac_proj_details.deprn_period%TYPE;
934: l_curr_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;
935: l_prev_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;
936: l_prior_prd_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;
937:

Line 934: l_curr_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;

930: l_prev_cost fa_books.cost%TYPE;
931: l_curr_deprn_period igi_iac_proj_details.deprn_period%TYPE;
932: l_prev_deprn_period igi_iac_proj_details.deprn_period%TYPE;
933: l_curr_deprn_period_catchup igi_iac_proj_details.deprn_period%TYPE;
934: l_curr_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;
935: l_prev_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;
936: l_prior_prd_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;
937:
938:

Line 935: l_prev_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;

931: l_curr_deprn_period igi_iac_proj_details.deprn_period%TYPE;
932: l_prev_deprn_period igi_iac_proj_details.deprn_period%TYPE;
933: l_curr_deprn_period_catchup igi_iac_proj_details.deprn_period%TYPE;
934: l_curr_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;
935: l_prev_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;
936: l_prior_prd_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;
937:
938:
939: l_prior_prd_index_val igi_iac_cal_idx_values.current_price_index_value%TYPE;

Line 936: l_prior_prd_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;

932: l_prev_deprn_period igi_iac_proj_details.deprn_period%TYPE;
933: l_curr_deprn_period_catchup igi_iac_proj_details.deprn_period%TYPE;
934: l_curr_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;
935: l_prev_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;
936: l_prior_prd_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;
937:
938:
939: l_prior_prd_index_val igi_iac_cal_idx_values.current_price_index_value%TYPE;
940: l_curr_price_index_val igi_iac_cal_idx_values.current_price_index_value%TYPE;

Line 1313: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc' ,'Before insertion into igi_iac_proj_details');

1309: END LOOP; -- end for c_get_asset_all loop
1310: END LOOP; -- end for l_asset_id loop
1311:
1312: IF (l_rec_count > 0) THEN
1313: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc' ,'Before insertion into igi_iac_proj_details');
1314: -- insert the projections into igi_iac_proj_details
1315: FORALL l_count IN l_proj_rec.record_counter.FIRST..l_proj_rec.record_counter.LAST
1316: INSERT INTO igi_iac_proj_details(
1317: projection_id,

Line 1314: -- insert the projections into igi_iac_proj_details

1310: END LOOP; -- end for l_asset_id loop
1311:
1312: IF (l_rec_count > 0) THEN
1313: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc' ,'Before insertion into igi_iac_proj_details');
1314: -- insert the projections into igi_iac_proj_details
1315: FORALL l_count IN l_proj_rec.record_counter.FIRST..l_proj_rec.record_counter.LAST
1316: INSERT INTO igi_iac_proj_details(
1317: projection_id,
1318: period_counter,

Line 1316: INSERT INTO igi_iac_proj_details(

1312: IF (l_rec_count > 0) THEN
1313: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc' ,'Before insertion into igi_iac_proj_details');
1314: -- insert the projections into igi_iac_proj_details
1315: FORALL l_count IN l_proj_rec.record_counter.FIRST..l_proj_rec.record_counter.LAST
1316: INSERT INTO igi_iac_proj_details(
1317: projection_id,
1318: period_counter,
1319: category_id,
1320: fiscal_year,

Line 1444: DELETE FROM igi_iac_proj_details

1440: ) IS
1441:
1442: BEGIN
1443:
1444: DELETE FROM igi_iac_proj_details
1445: WHERE projection_id BETWEEN p_from_projection AND p_to_projection;
1446:
1447: DELETE FROM igi_iac_projections
1448: WHERE projection_id BETWEEN p_from_projection AND p_to_projection;