1 PACKAGE IGI_IAC_REVAL_UTILITIES AS
2 -- $Header: igiiarus.pls 120.9.12000000.1 2007/08/01 16:18:21 npandya ship $
3 l_rec igi_iac_revaluation_rates%rowtype; -- create this for quicker access via sql navigator
4
5 function latest_adjustment ( fp_asset_id IN number
6 , fp_book_type_code in varchar2
7 )
8 return number;
9
10 function Populate_Depreciation ( fp_asset_id IN number
11 , fp_book_type_code IN varchar2
12 , fp_period_counter IN number
13 , fp_hist_info IN OUT NOCOPY IGI_IAC_TYPES.fa_hist_asset_info
14 )
15 return boolean;
16
17
18 function split_rates ( fp_asset_id IN number
19 , fp_book_type_code IN varchar2
20 , fp_revaluation_id IN number
21 , fp_period_counter IN number
22 , fp_current_factor IN number
23 , fp_reval_type IN varchar2
24 , fp_first_time_flag IN boolean default false
25 , fp_mixed_scenario OUT NOCOPY BOOLEAN
26 , fp_reval_prev_rate_info IN IGI_IAC_TYPES.iac_reval_rate_params
27 , fp_reval_curr_rate_info_first OUT NOCOPY IGI_IAC_TYPES.iac_reval_rate_params
28 , fp_reval_curr_rate_info_next OUT NOCOPY IGI_IAC_TYPES.iac_reval_rate_params
29 )
30 return boolean
31 ;
32 procedure log ( p_calling_code in varchar2 , p_mesg in varchar2 );
33
34 function debug return boolean;
35
36 function sqlplus_mode return boolean;
37 function logfile_mode return boolean;
38 function set_logfile_mode_on return boolean;
39 function set_logfile_mode_off return boolean;
40
41 function prorate_dists ( fp_asset_id in number
42 , fp_book_type_code in varchar2
43 , fp_current_period_counter in number
44 , fp_prorate_dists_tab out NOCOPY igi_iac_types.prorate_dists_tab
45 , fp_prorate_dists_idx out NOCOPY binary_integer
46 )
47 return boolean ;
48
49 FUNCTION prorate_active_dists_YTD ( fp_asset_id in number
50 , fp_book_type_code in varchar2
51 , fp_current_period_counter in number
52 , fp_prorate_dists_tab out NOCOPY igi_iac_types.prorate_dists_tab
53 , fp_prorate_dists_idx out NOCOPY binary_integer
54 )
55 RETURN BOOLEAN ;
56
57 FUNCTION prorate_all_dists_YTD ( fp_asset_id in number
58 , fp_book_type_code in varchar2
59 , fp_current_period_counter in number
60 , fp_prorate_dists_tab out NOCOPY igi_iac_types.prorate_dists_tab
61 , fp_prorate_dists_idx out NOCOPY binary_integer
62 )
63 RETURN BOOLEAN ;
64
65 procedure get_coa_info (x_chart_of_accounts_id IN NUMBER,
66 x_segment_delimiter IN OUT NOCOPY VARCHAR2,
67 x_enabled_segment_count IN OUT NOCOPY NUMBER,
68 x_segment_order_by IN OUT NOCOPY VARCHAR2,
69 x_accseg_segment_num IN OUT NOCOPY NUMBER,
70 x_accseg_app_col_name IN OUT NOCOPY VARCHAR2,
71 x_accseg_left_prompt IN OUT NOCOPY VARCHAR2,
72 x_balseg_segment_num IN OUT NOCOPY NUMBER,
73 x_balseg_app_col_name IN OUT NOCOPY VARCHAR2,
74 x_balseg_left_prompt IN OUT NOCOPY VARCHAR2,
75 x_ieaseg_segment_num IN OUT NOCOPY NUMBER,
76 x_ieaseg_app_col_name IN OUT NOCOPY VARCHAR2,
77 x_ieaseg_left_prompt IN OUT NOCOPY VARCHAR2);
78
79 FUNCTION Synchronize_Accounts(
80 p_book_type_code IN VARCHAR2,
81 p_period_counter IN NUMBER,
82 p_calling_function IN VARCHAR2
83 )
84 return BOOLEAN;
85
86 END;