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_UTILITIES dependencies on IGI_IAC_TYPES

Line 127: , fp_hist_info IN OUT NOCOPY IGI_IAC_TYPES.fa_hist_asset_info

123:
124: function Populate_Depreciation ( fp_asset_id IN number
125: , fp_book_type_code IN varchar2
126: , fp_period_counter IN number
127: , fp_hist_info IN OUT NOCOPY IGI_IAC_TYPES.fa_hist_asset_info
128: )
129: return boolean is
130:
131: /* Bug 2763328 sekhar */

Line 143: l_dpis_prd_rec IGI_IAC_TYPES.prd_rec;

139: SELECT number_per_fiscal_year
140: FROM fa_calendar_types
141: WHERE calendar_type = p_calendar_type;
142:
143: l_dpis_prd_rec IGI_IAC_TYPES.prd_rec;
144: l_curr_prd_rec IGI_IAC_TYPES.prd_rec;
145: l_num_of_periods_elapsed number;
146: l_num_of_periods_in_pyr number;
147: l_num_of_periods_in_cyr number;

Line 144: l_curr_prd_rec IGI_IAC_TYPES.prd_rec;

140: FROM fa_calendar_types
141: WHERE calendar_type = p_calendar_type;
142:
143: l_dpis_prd_rec IGI_IAC_TYPES.prd_rec;
144: l_curr_prd_rec IGI_IAC_TYPES.prd_rec;
145: l_num_of_periods_elapsed number;
146: l_num_of_periods_in_pyr number;
147: l_num_of_periods_in_cyr number;
148: l_last_period_counter number;

Line 150: fp_hist_info_old IGI_IAC_TYPES.fa_hist_asset_info;

146: l_num_of_periods_in_pyr number;
147: l_num_of_periods_in_cyr number;
148: l_last_period_counter number;
149: l_num_of_periods_total number;
150: fp_hist_info_old IGI_IAC_TYPES.fa_hist_asset_info;
151: l_deprn_calendar fa_calendar_types.calendar_type%TYPE;
152: l_periods_in_year fa_calendar_types.number_per_fiscal_year%TYPE;
153: l_path_name VARCHAR2(150);
154:

Line 231: l_prd_rec IGI_IAC_TYPES.prd_rec;

227: /* here we assume that if the asset is fully reserved */
228:
229: if l_last_period_counter < l_curr_prd_rec.period_counter then
230: declare
231: l_prd_rec IGI_IAC_TYPES.prd_rec;
232: begin
233: if not IGI_IAC_COMMON_UTILS.get_period_info_for_counter
234: ( p_book_type_code => fp_book_type_code
235: , p_period_counter => l_last_period_counter

Line 313: , fp_reval_prev_rate_info IN IGI_IAC_TYPES.iac_reval_rate_params

309: , fp_current_factor IN number
310: , fp_reval_type IN varchar2
311: , fp_first_time_flag IN boolean
312: , fp_mixed_scenario OUT NOCOPY BOOLEAN
313: , fp_reval_prev_rate_info IN IGI_IAC_TYPES.iac_reval_rate_params
314: , fp_reval_curr_rate_info_first OUT NOCOPY IGI_IAC_TYPES.iac_reval_rate_params
315: , fp_reval_curr_rate_info_next OUT NOCOPY IGI_IAC_TYPES.iac_reval_rate_params
316: )
317: return boolean is

Line 314: , fp_reval_curr_rate_info_first OUT NOCOPY IGI_IAC_TYPES.iac_reval_rate_params

310: , fp_reval_type IN varchar2
311: , fp_first_time_flag IN boolean
312: , fp_mixed_scenario OUT NOCOPY BOOLEAN
313: , fp_reval_prev_rate_info IN IGI_IAC_TYPES.iac_reval_rate_params
314: , fp_reval_curr_rate_info_first OUT NOCOPY IGI_IAC_TYPES.iac_reval_rate_params
315: , fp_reval_curr_rate_info_next OUT NOCOPY IGI_IAC_TYPES.iac_reval_rate_params
316: )
317: return boolean is
318: l_reval_type igi_iac_reval_asset_rules.revaluation_type%type;

Line 315: , fp_reval_curr_rate_info_next OUT NOCOPY IGI_IAC_TYPES.iac_reval_rate_params

311: , fp_first_time_flag IN boolean
312: , fp_mixed_scenario OUT NOCOPY BOOLEAN
313: , fp_reval_prev_rate_info IN IGI_IAC_TYPES.iac_reval_rate_params
314: , fp_reval_curr_rate_info_first OUT NOCOPY IGI_IAC_TYPES.iac_reval_rate_params
315: , fp_reval_curr_rate_info_next OUT NOCOPY IGI_IAC_TYPES.iac_reval_rate_params
316: )
317: return boolean is
318: l_reval_type igi_iac_reval_asset_rules.revaluation_type%type;
319: l_current_rate number;

Line 321: fp_reval_curr_first_old IGI_IAC_TYPES.iac_reval_rate_params;

317: return boolean is
318: l_reval_type igi_iac_reval_asset_rules.revaluation_type%type;
319: l_current_rate number;
320: l_cumulative_rate number;
321: fp_reval_curr_first_old IGI_IAC_TYPES.iac_reval_rate_params;
322: fp_reval_curr_next_old IGI_IAC_TYPES.iac_reval_rate_params;
323: l_path_name VARCHAR2(150);
324:
325: begin

Line 322: fp_reval_curr_next_old IGI_IAC_TYPES.iac_reval_rate_params;

318: l_reval_type igi_iac_reval_asset_rules.revaluation_type%type;
319: l_current_rate number;
320: l_cumulative_rate number;
321: fp_reval_curr_first_old IGI_IAC_TYPES.iac_reval_rate_params;
322: fp_reval_curr_next_old IGI_IAC_TYPES.iac_reval_rate_params;
323: l_path_name VARCHAR2(150);
324:
325: begin
326: l_path_name := g_path||'split_rates';

Line 437: procedure display_prorate_dists ( fp_prorate_dists igi_iac_types.prorate_dists ) is

433: fp_mixed_scenario := FALSE;
434: return false;
435: end;
436:
437: procedure display_prorate_dists ( fp_prorate_dists igi_iac_types.prorate_dists ) is
438: l_path_name VARCHAR2(150);
439: begin
440: l_path_name := g_path||'display_prorate_dists';
441: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

Line 470: , fp_prorate_dists_tab out NOCOPY igi_iac_types.prorate_dists_tab

466:
467: function prorate_dists ( fp_asset_id in number
468: , fp_book_type_code in varchar2
469: , fp_current_period_counter in number
470: , fp_prorate_dists_tab out NOCOPY igi_iac_types.prorate_dists_tab
471: , fp_prorate_dists_idx out NOCOPY binary_integer
472: )
473: return boolean is
474:

Line 476: l_prorate_dists_tab igi_iac_types.prorate_dists_tab;

472: )
473: return boolean is
474:
475: l_prorate_dists_idx binary_integer ;
476: l_prorate_dists_tab igi_iac_types.prorate_dists_tab;
477: l_path_name VARCHAR2(150);
478:
479: cursor c_deprn_asset is
480: select fds.asset_id, fds.book_type_code, fds.period_counter + 1, abs(fds.ytd_deprn) ytd_deprn, fdp.fiscal_year

Line 638: , fp_prorate_dists_tab out NOCOPY igi_iac_types.prorate_dists_tab

634:
635: FUNCTION prorate_active_dists_YTD ( fp_asset_id in number
636: , fp_book_type_code in varchar2
637: , fp_current_period_counter in number
638: , fp_prorate_dists_tab out NOCOPY igi_iac_types.prorate_dists_tab
639: , fp_prorate_dists_idx out NOCOPY binary_integer
640: ) RETURN BOOLEAN IS
641: CURSOR c_active_dists IS
642: SELECT fdh.distribution_id distribution_id,

Line 679: l_prorate_dists_tab igi_iac_types.prorate_dists_tab;

675: WHERE ct.calendar_type = bc.deprn_calendar
676: AND bc.book_type_code = fp_book_type_code;
677:
678: l_prorate_dists_idx binary_integer ;
679: l_prorate_dists_tab igi_iac_types.prorate_dists_tab;
680: l_path_name VARCHAR2(150);
681: l_fully_reserved NUMBER;
682: l_dpis DATE;
683: l_dpis_period igi_iac_types.prd_rec;

Line 683: l_dpis_period igi_iac_types.prd_rec;

679: l_prorate_dists_tab igi_iac_types.prorate_dists_tab;
680: l_path_name VARCHAR2(150);
681: l_fully_reserved NUMBER;
682: l_dpis DATE;
683: l_dpis_period igi_iac_types.prd_rec;
684: l_current_period igi_iac_types.prd_rec;
685: l_first_deprn_period NUMBER;
686: l_dist_first_period NUMBER;
687: l_dist_last_period NUMBER;

Line 684: l_current_period igi_iac_types.prd_rec;

680: l_path_name VARCHAR2(150);
681: l_fully_reserved NUMBER;
682: l_dpis DATE;
683: l_dpis_period igi_iac_types.prd_rec;
684: l_current_period igi_iac_types.prd_rec;
685: l_first_deprn_period NUMBER;
686: l_dist_first_period NUMBER;
687: l_dist_last_period NUMBER;
688: l_dist_active_periods NUMBER;

Line 690: l_fully_reserved_period igi_iac_types.prd_rec;

686: l_dist_first_period NUMBER;
687: l_dist_last_period NUMBER;
688: l_dist_active_periods NUMBER;
689: l_fully_reserved_counter NUMBER;
690: l_fully_reserved_period igi_iac_types.prd_rec;
691: l_periods_per_FY fa_calendar_types.number_per_fiscal_year%TYPE;
692: l_total_periods NUMBER;
693: l_last_period igi_iac_types.prd_rec;
694: l_asset_prorate_units NUMBER;

Line 693: l_last_period igi_iac_types.prd_rec;

689: l_fully_reserved_counter NUMBER;
690: l_fully_reserved_period igi_iac_types.prd_rec;
691: l_periods_per_FY fa_calendar_types.number_per_fiscal_year%TYPE;
692: l_total_periods NUMBER;
693: l_last_period igi_iac_types.prd_rec;
694: l_asset_prorate_units NUMBER;
695: l_life_in_months NUMBER;
696: l_depreciate_flag VARCHAR2(3);
697:

Line 831: , fp_prorate_dists_tab out NOCOPY igi_iac_types.prorate_dists_tab

827:
828: FUNCTION prorate_all_dists_YTD ( fp_asset_id in number
829: , fp_book_type_code in varchar2
830: , fp_current_period_counter in number
831: , fp_prorate_dists_tab out NOCOPY igi_iac_types.prorate_dists_tab
832: , fp_prorate_dists_idx out NOCOPY binary_integer
833: ) RETURN BOOLEAN IS
834:
835: CURSOR c_all_dists (cp_fiscal_year number) IS

Line 897: l_prorate_dists_tab igi_iac_types.prorate_dists_tab;

893: WHERE ct.calendar_type = bc.deprn_calendar
894: AND bc.book_type_code = fp_book_type_code;
895:
896: l_prorate_dists_idx binary_integer ;
897: l_prorate_dists_tab igi_iac_types.prorate_dists_tab;
898: l_path_name VARCHAR2(150);
899: l_fully_reserved NUMBER;
900: l_dpis DATE;
901: l_dpis_period igi_iac_types.prd_rec;

Line 901: l_dpis_period igi_iac_types.prd_rec;

897: l_prorate_dists_tab igi_iac_types.prorate_dists_tab;
898: l_path_name VARCHAR2(150);
899: l_fully_reserved NUMBER;
900: l_dpis DATE;
901: l_dpis_period igi_iac_types.prd_rec;
902: l_current_period igi_iac_types.prd_rec;
903: l_first_deprn_period NUMBER;
904: l_dist_first_period NUMBER;
905: l_dist_last_period NUMBER;

Line 902: l_current_period igi_iac_types.prd_rec;

898: l_path_name VARCHAR2(150);
899: l_fully_reserved NUMBER;
900: l_dpis DATE;
901: l_dpis_period igi_iac_types.prd_rec;
902: l_current_period igi_iac_types.prd_rec;
903: l_first_deprn_period NUMBER;
904: l_dist_first_period NUMBER;
905: l_dist_last_period NUMBER;
906: l_dist_active_periods NUMBER;

Line 908: l_fully_reserved_period igi_iac_types.prd_rec;

904: l_dist_first_period NUMBER;
905: l_dist_last_period NUMBER;
906: l_dist_active_periods NUMBER;
907: l_fully_reserved_counter NUMBER;
908: l_fully_reserved_period igi_iac_types.prd_rec;
909: l_periods_per_FY fa_calendar_types.number_per_fiscal_year%TYPE;
910: l_total_periods NUMBER;
911: l_last_period igi_iac_types.prd_rec;
912: l_asset_prorate_units NUMBER;

Line 911: l_last_period igi_iac_types.prd_rec;

907: l_fully_reserved_counter NUMBER;
908: l_fully_reserved_period igi_iac_types.prd_rec;
909: l_periods_per_FY fa_calendar_types.number_per_fiscal_year%TYPE;
910: l_total_periods NUMBER;
911: l_last_period igi_iac_types.prd_rec;
912: l_asset_prorate_units NUMBER;
913: l_life_in_months NUMBER;
914: l_depreciate_flag VARCHAR2(3);
915: l_last_dist_period igi_iac_types.prd_rec;

Line 915: l_last_dist_period igi_iac_types.prd_rec;

911: l_last_period igi_iac_types.prd_rec;
912: l_asset_prorate_units NUMBER;
913: l_life_in_months NUMBER;
914: l_depreciate_flag VARCHAR2(3);
915: l_last_dist_period igi_iac_types.prd_rec;
916: l_first_dist_period igi_iac_types.prd_rec;
917:
918: BEGIN
919:

Line 916: l_first_dist_period igi_iac_types.prd_rec;

912: l_asset_prorate_units NUMBER;
913: l_life_in_months NUMBER;
914: l_depreciate_flag VARCHAR2(3);
915: l_last_dist_period igi_iac_types.prd_rec;
916: l_first_dist_period igi_iac_types.prd_rec;
917:
918: BEGIN
919:
920: l_path_name := g_path||'prorate_all_dists_YTD';