1 PACKAGE IGI_IAC_COMMON_UTILS AS
2 -- $Header: igiiacus.pls 120.6.12000000.1 2007/08/01 16:14:00 npandya ship $
3
4 debug_on_test boolean;
5 -- DMahajan Start
6 Function Get_Period_Info_for_Counter( P_book_type_Code IN VARCHAR2 ,
7 P_period_Counter IN NUMBER ,
8 P_prd_rec OUT NOCOPY igi_iac_types.prd_rec
9 )
10 RETURN BOOLEAN ;
11
12
13
14
15 Function Get_Period_Info_for_Date( P_book_type_Code IN VARCHAR2 ,
16 P_date IN DATE ,
17 p_prd_rec OUT NOCOPY igi_iac_types.prd_rec
18 )
19 RETURN BOOLEAN ;
20
21
22
23 Function Get_Period_Info_for_Name( P_book_type_Code IN VARCHAR2 ,
24 P_Prd_Name IN VARCHAR2 ,
25 p_prd_rec OUT NOCOPY igi_iac_types.prd_rec
26 )
27 RETURN BOOLEAN ;
28
29
30
31 Function Get_Open_Period_Info ( P_book_type_Code IN VARCHAR2 ,
32 p_prd_rec OUT NOCOPY igi_iac_types.prd_rec
33 )
34 RETURN BOOLEAN ;
35
36
37
38
39 Function Get_Retirement_Info ( P_Retirement_Id IN NUMBER ,
40 P_Retire_Info OUT NOCOPY fa_retirements%ROWTYPE
41 )
42 RETURN BOOLEAN ;
43
44
45
46 Function Get_Units_Info_for_Gain_Loss (P_asset_id IN NUMBER ,
47 P_Book_type_code IN VARCHAR2 ,
48 P_Retirement_Id IN NUMBER ,
49 -- P_Calling_txn IN NUMBER ,
50 P_Calling_txn IN VARCHAR2,
51 P_Units_Before OUT NOCOPY NUMBER ,
52 P_Units_After OUT NOCOPY NUMBER
53 )
54 RETURN BOOLEAN ;
55
56
57
58 Function Get_Cost_Retirement_Factor ( P_Book_Type_code IN VARCHAR2 ,
59 P_Asset_id IN NUMBER ,
60 -- P_Transaction_header_id IN NUMBER ,
61 P_Retirement_Id IN NUMBER ,
62 P_Factor OUT NOCOPY NUMBER
63 )
64 RETURN BOOLEAN ;
65
66
67 -- Function Is_Part_Ret_Unit_or_Cost( P_book_type_Code IN VARCHAR2 ,
68 Function Get_Retirement_Type( P_book_type_Code IN VARCHAR2 ,
69 P_Asset_id IN NUMBER ,
70 -- P_Transaction_header_id IN NUMBER ,
71 P_Retirement_Id IN NUMBER ,
72 P_Type OUT NOCOPY VARCHAR2
73 )
74 RETURN BOOLEAN ;
75
76
77
78 Function Prorate_Amt_to_Active_Dists( P_book_type_Code IN VARCHAR2 ,
79 P_Asset_id IN NUMBER ,
80 P_Amount IN NUMBER ,
81 P_out_tab OUT NOCOPY igi_iac_types.dist_amt_tab
82 )
83 RETURN BOOLEAN ;
84
85
86
87 Function Get_Active_Distributions ( P_book_type_Code IN VARCHAR2 ,
88 P_Asset_id IN NUMBER ,
89 P_dh_tab OUT NOCOPY igi_iac_types.dh_tab
90 )
91 RETURN BOOLEAN ;
92
93
94
95 Function Get_CY_PY_Factors( P_book_type_Code IN VARCHAR2 ,
96 P_Asset_id IN NUMBER ,
97 P_Period_Name IN VARCHAR2 ,
98 P_PY_Ratio OUT NOCOPY NUMBER ,
99 P_CY_Ratio OUT NOCOPY NUMBER
100 )
101 RETURN BOOLEAN ;
102
103
104
105 Function Is_Asset_Rvl_in_curr_Period( P_book_type_Code IN VARCHAR2 ,
106 P_Asset_id IN NUMBER
107 )
108 RETURN BOOLEAN ;
109
110
111
112 Function Any_Txns_In_Open_Period( P_book_type_Code IN VARCHAR2 ,
113 P_Asset_id IN NUMBER
114 )
115 RETURN BOOLEAN ;
116
117
118
119 Function Any_Adj_In_Book( P_book_type_Code IN VARCHAR2 ,
120 P_Asset_id IN NUMBER
121 )
122 RETURN BOOLEAN ;
123
124
125
126 Function Any_Reval_in_Corp_Book( P_book_type_Code IN VARCHAR2 ,
127 P_Asset_id IN NUMBER
128 )
129 RETURN BOOLEAN ;
130
131
132
133 Function Any_Ret_In_Curr_Yr ( P_book_type_Code IN VARCHAR2 ,
134 P_Asset_id IN NUMBER ,
135 P_retirements OUT NOCOPY VARCHAR2
136 )
137 RETURN BOOLEAN ;
138
139 --DMahajan End
140
141
142 -- Niyer Start
143
144 FUNCTION Is_Asset_Proc (
145 X_book_type_code IN VARCHAR2,
146 X_asset_id IN VARCHAR2 )
147 RETURN BOOLEAN ;
148
149 FUNCTION Get_Dpis_Period_Counter (
150 X_book_type_code IN Varchar2,
151 X_asset_id IN Varchar2,
152 X_Period_Counter OUT NOCOPY Varchar2 )
153 RETURN BOOLEAN;
154
155 FUNCTION Get_Price_Index (
156 X_book_type_code IN VARCHAR2,
157 X_asset_id IN Varchar2,
158 X_Price_Index_Id OUT NOCOPY NUMBER,
159 X_Price_Index_Name OUT NOCOPY VARCHAR2 )
160 RETURN BOOLEAN;
161
162 FUNCTION Get_Price_Index_Value (
163 X_book_type_code IN VARCHAR2,
164 X_asset_id IN Varchar2,
165 X_Period_Name IN VARCHAR2,
166 X_Price_Index_Value OUT NOCOPY NUMBER )
167 RETURN BOOLEAN;
168
169 -- Niyer End
170
171 -- Shekar Start
172
173 FUNCTION Is_IAC_Book ( X_book_type_code IN VARCHAR2 )
174 RETURN BOOLEAN ;
175
176 FUNCTION Get_Latest_Transaction (
177 X_book_type_code IN Varchar2,
178 X_asset_id IN Number,
179 X_Transaction_Type_Code IN OUT NOCOPY Varchar2,
180 X_Transaction_Id IN OUT NOCOPY Number,
181 X_Mass_Reference_ID IN OUT NOCOPY Number,
182 X_Adjustment_Id OUT NOCOPY Number,
183 X_Prev_Adjustment_Id OUT NOCOPY Number,
184 X_Adjustment_Status OUT NOCOPY Varchar2)
185 RETURN BOOLEAN;
186
187 FUNCTION Get_Book_GL_Info (
188 X_book_type_code IN VARCHAR2,
189 Set_Of_Books_Id IN OUT NOCOPY NUMBER,
190 Chart_Of_Accounts_Id IN OUT NOCOPY NUMBER,
191 Currency IN OUT NOCOPY VARCHAR2,
192 Precision IN OUT NOCOPY NUMBER )
193 RETURN BOOLEAN;
194
195 FUNCTION Get_Account_Segment_Value (
196 X_sob_id IN gl_sets_of_books.set_of_books_id%TYPE,
197 X_code_combination_id IN fa_distribution_history.code_combination_id%TYPE,
198 X_segment_type IN VARCHAR2 ,
199 X_segment_value IN OUT NOCOPY VARCHAR2 )
200 RETURN BOOLEAN;
201
202 FUNCTION Get_Distribution_Ccid (
203 X_book_type_code IN VARCHAR2,
204 X_asset_id IN NUMBER,
205 X_Distribution_Id IN NUMBER,
206 Dist_CCID IN OUT NOCOPY NUMBER )
207 RETURN BOOLEAN;
208
209
210
211 FUNCTION Get_Default_Account (
212 X_book_type_code IN VARCHAR2,
213 Default_Account IN OUT NOCOPY NUMBER )
214 RETURN BOOLEAN;
215
216 FUNCTION Get_Account_CCID (
217 X_book_type_code IN VARCHAR2,
218 X_asset_id IN NUMBER,
219 X_Distribution_ID IN NUMBER,
220 X_Account_Type IN VARCHAR2,
221 Account_CCID IN OUT NOCOPY NUMBER )
222 RETURN BOOLEAN;
223
224 FUNCTION Get_Account_CCID (
225 X_book_type_code IN VARCHAR2,
226 X_asset_id IN NUMBER,
227 X_Distribution_ID IN NUMBER,
228 X_Account_Type IN VARCHAR2,
229 X_Transaction_Header_ID IN NUMBER,
230 X_Calling_function IN VARCHAR2,
231 Account_CCID IN OUT NOCOPY NUMBER )
232 RETURN BOOLEAN;
233
234 Procedure debug_on;
235
236 Procedure debug_off;
237 procedure debug_write(stmt varchar2);
238
239 -- Shekar End
240
241 -- M Hazarika, 07-05-2002, start
242
243 FUNCTION Iac_Round(
244 X_Amount IN OUT NOCOPY NUMBER,
245 X_book IN VARCHAR2)
246 RETURN BOOLEAN;
247
248 -- M Hazarika, 07-05-2002, end
249
250 FUNCTION Populate_iac_fa_deprn_data(
251 X_book_type_code IN VARCHAR2
252 ,X_calling_mode IN VARCHAR2)
253 RETURN BOOLEAN;
254
255
256 /* Added for Bug 5846861 by Venkataramanan S on 02-Feb-2007
257 FUNCTION NAME: Is_Asset_Adjustment_Done
258 PARAMETERS: Book Type Code and Asset Id
259 RETURN TYPE: BOOLEAN
260 DESCRIPTION: This function checks whether adjustments have been made in the
261 open period for the given Asset and Book combination. A "BOOLEAN TRUE" is
262 returned if adjustments have been done. A "BOOLEAN FALSE" is returned otherwise
263 */
264 FUNCTION Is_Asset_Adjustment_Done(
265 X_book_type_code IN VARCHAR2,
266 X_asset_id IN NUMBER)
267 RETURN BOOLEAN;
268
269
270 END; --package spec