1 PACKAGE PSB_WS_ACCT_PVT AS
2 /* $Header: PSBPWCAS.pls 120.5 2006/04/07 11:17:54 shtripat ship $ */
3
4 -- Bug#4571412
5 -- Introduced global variable to handle the CP
6 -- completion status conditionally.
7
8 -- Bug#4675858
9 -- No need of this packaged variable. The same will be done through
10 -- PSB_WS_ACCT1.g_soft_error_flag.
11 -- g_soft_error_flag VARCHAR2(1) := 'N';
12
13
14 /* ----------------------------------------------------------------------- */
15
16 -- API name : Check_CCID_Type
17 -- Type : Private <Interface>
18 -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_ACCT1
19 -- Parameters :
20 -- IN : p_api_version IN NUMBER Required
21 -- p_init_msg_list IN VARCHAR2 Optional
22 -- Default = FND_API.G_FALSE
23 -- p_validation_level IN NUMBER Optional
24 -- Default = FND_API.G_VALID_LEVEL_NONE
25 -- p_flex_code IN NUMBER Required
26 -- p_ccid IN NUMBER Required
27 -- p_budget_group_id IN NUMBER Required
28 -- .
29 -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
30 -- p_msg_count OUT NOCOPY NUMBER
31 -- p_msg_data OUT NOCOPY VARCHAR2(2000)
32 -- p_ccid_type OUT NOCOPY VARCHAR2(30)
33 -- .
34 -- Version : Current version 1.0
35 -- Initial version 1.0
36 -- Created 03/09/1998 by Supriyo Ghosh
37 --
38 -- Notes : Return the CCID Type for an Account; return values
39 -- are 'PERSONNEL_SERVICES', 'NON_PERSONNEL_SERVICES'
40 --
41 -- 16-NOV-1998 Elvirtuc moved call to concurrent manager here
42 -- Update balances and Create rollup
43
44
45
46 PROCEDURE Check_CCID_Type
47 ( p_api_version IN NUMBER,
48 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
49 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
50 p_return_status OUT NOCOPY VARCHAR2,
51 p_msg_count OUT NOCOPY NUMBER,
52 p_msg_data OUT NOCOPY VARCHAR2,
53 p_ccid_type OUT NOCOPY VARCHAR2,
54 p_flex_code IN NUMBER,
55 p_ccid IN NUMBER,
56 p_budget_group_id IN NUMBER
57 );
58
59 /* ----------------------------------------------------------------------- */
60
61 -- API name : Create_Account_Dist
62 -- Type : Private <Interface>
63 -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_ACCT1
64 -- Parameters :
65 -- IN : p_api_version IN NUMBER Required
66 -- p_init_msg_list IN VARCHAR2 Optional
67 -- Default = FND_API.G_FALSE
68 -- p_commit IN VARCHAR2 Optional
69 -- Default = FND_API.G_FALSE
70 -- p_validation_level IN NUMBER Optional
71 -- Default = FND_API.G_VALID_LEVEL_NONE
72 -- p_worksheet_id IN NUMBER Required
73 -- p_check_spal_exists IN VARCHAR2 Optional
74 -- Default = FND_API.G_TRUE
75 -- p_gl_cutoff_period IN DATE Optional
76 -- Default = FND_API.G_MISS_DATE
77 -- p_allocrule_set_id IN NUMBER Optional
78 -- Default = FND_API.G_MISS_NUM
79 -- p_budget_calendar_id IN NUMBER Optional
80 -- Default = FND_API.G_MISS_NUM
81 -- p_rounding_factor IN NUMBER Optional
82 -- Default = FND_API.G_MISS_NUM
83 -- p_stage_set_id IN NUMBER Optional
84 -- Default = FND_API.G_MISS_NUM
85 -- p_budget_year_id IN NUMBER Required
86 -- p_budget_group_id IN NUMBER Required
87 -- p_ccid IN NUMBER Optional
88 -- Default = FND_API.G_MISS_NUM
89 -- p_flex_mapping_set_id IN NUMBER Optional
90 -- Default = FND_API.G_MISS_NUM
91 -- p_map_accounts IN BOOLEAN Optional
92 -- Default = FALSE
93 -- p_flex_code IN NUMBER Optional
94 -- Default = FND_API.G_MISS_NUM
95 -- p_concatenated_segments IN VARCHAR2 Optional
96 -- Default = FND_API.G_MISS_CHAR
97 -- p_startdate_pp IN DATE Optional
98 -- Default = FND_API.G_MISS_DATE
99 -- p_template_id IN NUMBER Optional
100 -- Default = FND_API.G_MISS_NUM
101 -- p_currency_code IN VARCHAR2 Required
102 -- p_balance_type IN VARCHAR2 Required
103 -- p_ytd_amount IN NUMBER Required
104 -- p_distribute_flag IN VARCHAR2 Optional
105 -- Default = FND_API.G_MISS_CHAR
106 -- p_annual_fte IN NUMBER Optional
107 -- Default = FND_API.G_MISS_NUM
108 -- p_period_amount IN TABLE Required
109 -- p_position_line_id IN NUMBER Optional
110 -- Default = FND_API.G_MISS_NUM
111 -- p_element_set_id IN NUMBER Optional
112 -- Default = FND_API.G_MISS_NUM
113 -- p_salary_account_line IN VARCHAR2 Optional
114 -- Default = FND_API.G_FALSE
115 -- p_service_package_id IN NUMBER Optional
116 -- Default = FND_API.G_MISS_NUM
117 -- p_start_stage_seq IN NUMBER Optional
118 -- Default = FND_API.G_MISS_NUM
119 -- p_current_stage_seq IN NUMBER Optional
120 -- Default = FND_API.G_MISS_NUM
121 -- p_end_stage_seq IN NUMBER Optional
122 -- Default = FND_API.G_MISS_NUM
123 -- p_copy_of_account_line_id IN NUMBER Optional
124 -- Default = FND_API.G_MISS_NUM
125 -- .
126 -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
127 -- p_account_line_id OUT NOCOPY NUMBER
128 -- p_msg_count OUT NOCOPY NUMBER
129 -- p_msg_data OUT NOCOPY VARCHAR2(2000)
130 -- .
131 -- Version : Current version 1.0
132 -- Initial version 1.0
133 -- Created 06/15/1997 by Supriyo Ghosh
134 -- Changed 10/27/1997 by Supriyo Ghosh
135 -- Changed 01/07/1998 by Supriyo Ghosh
136 -- (Renamed p_position_id to p_position_line_id)
137 --
138 -- Notes : Insert Worksheet Account Distributions for Account
139 -- and Position Lines
140 --
141
142 PROCEDURE Create_Account_Dist
143 ( p_api_version IN NUMBER,
144 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145 p_commit IN VARCHAR2 := FND_API.G_FALSE,
146 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
147 p_return_status OUT NOCOPY VARCHAR2,
148 p_account_line_id OUT NOCOPY NUMBER,
149 p_msg_count OUT NOCOPY NUMBER,
150 p_msg_data OUT NOCOPY VARCHAR2,
151 p_worksheet_id IN NUMBER,
152 p_check_spal_exists IN VARCHAR2 := FND_API.G_TRUE,
153 p_gl_cutoff_period IN DATE := FND_API.G_MISS_DATE,
154 p_allocrule_set_id IN NUMBER := FND_API.G_MISS_NUM,
155 p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
156 p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
157 p_stage_set_id IN NUMBER := FND_API.G_MISS_NUM,
158 p_budget_year_id IN NUMBER,
159 p_budget_group_id IN NUMBER,
160 p_ccid IN NUMBER := FND_API.G_MISS_NUM,
161 p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
162 p_map_accounts IN BOOLEAN := FALSE,
163 p_flex_code IN NUMBER := FND_API.G_MISS_NUM,
164 p_concatenated_segments IN VARCHAR2 := FND_API.G_MISS_CHAR,
165 p_startdate_pp IN DATE := FND_API.G_MISS_DATE,
166 p_template_id IN NUMBER := FND_API.G_MISS_NUM,
167 p_currency_code IN VARCHAR2,
168 p_balance_type IN VARCHAR2,
169 p_ytd_amount IN NUMBER,
170 p_distribute_flag IN VARCHAR2 := FND_API.G_FALSE,
171 p_annual_fte IN NUMBER := FND_API.G_MISS_NUM,
172 p_period_amount IN PSB_WS_ACCT1.g_prdamt_tbl_type,
173 p_position_line_id IN NUMBER := FND_API.G_MISS_NUM,
174 p_element_set_id IN NUMBER := FND_API.G_MISS_NUM,
175 p_salary_account_line IN VARCHAR2 := FND_API.G_FALSE,
176 p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
177 p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
178 p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
179 p_end_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
180 p_copy_of_account_line_id IN NUMBER := FND_API.G_MISS_NUM
181 /*For Bug No : 2440100 Start*/
182 -- Bug#4502045
183 --p_create_mrc_transaction IN BOOLEAN := TRUE
184 /*For Bug No : 2440100 End*/
185 );
186
187 /* ----------------------------------------------------------------------- */
188
189 -- API name : Create_Account_Dist
190 -- Type : Private <Interface>
191 -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_ACCT1
192 -- Parameters :
193 -- IN : p_api_version IN NUMBER Required
194 -- p_init_msg_list IN VARCHAR2 Optional
195 -- Default = FND_API.G_FALSE
196 -- p_commit IN VARCHAR2 Optional
197 -- Default = FND_API.G_FALSE
198 -- p_validation_level IN NUMBER Optional
199 -- Default = FND_API.G_VALID_LEVEL_NONE
200 -- p_worksheet_id IN NUMBER Required
201 -- p_distribute_flag IN VARCHAR2 Optional
202 -- Default = FND_API.G_FALSE
203 -- p_account_line_id IN NUMBER Required
204 -- p_check_stages IN VARCHAR2 Optional
205 -- Default = FND_API.G_TRUE
206 -- p_ytd_amount IN NUMBER Required
207 -- p_annual_fte IN NUMBER Optional
208 -- Default = FND_API.G_MISS_NUM
209 -- p_period_amount IN TABLE Required
210 -- p_budget_group_id IN NUMBER Optional
211 -- Default = FND_API.G_MISS_NUM
212 -- p_service_package_id IN NUMBER Optional
213 -- Default = FND_API.G_MISS_NUM
214 -- p_current_stage_seq IN NUMBER Optional
215 -- Default = FND_API.G_MISS_NUM
216 -- p_copy_of_account_line_id IN NUMBER Optional
217 -- Default = FND_API.G_MISS_NUM
218 -- .
219 -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
220 -- p_msg_count OUT NOCOPY NUMBER
221 -- p_msg_data OUT NOCOPY VARCHAR2(2000)
222 -- .
223 -- Version : Current version 1.0
224 -- Initial version 1.0
225 -- Created 06/15/1997 by Supriyo Ghosh
226 --
227 -- Notes : Modify Worksheet Account Distributions for Account
228 -- and Position Lines
229 --
230
231 PROCEDURE Create_Account_Dist
232 ( p_api_version IN NUMBER,
233 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
234 p_commit IN VARCHAR2 := FND_API.G_FALSE,
235 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
236 p_return_status OUT NOCOPY VARCHAR2,
237 p_msg_count OUT NOCOPY NUMBER,
238 p_msg_data OUT NOCOPY VARCHAR2,
239 p_worksheet_id IN NUMBER,
240 p_distribute_flag IN VARCHAR2 := FND_API.G_FALSE,
241 p_account_line_id IN NUMBER,
242 p_check_stages IN VARCHAR2 := FND_API.G_TRUE,
243 p_ytd_amount IN NUMBER,
244 p_annual_fte IN NUMBER := FND_API.G_MISS_NUM,
245 p_period_amount IN PSB_WS_ACCT1.g_prdamt_tbl_type,
246 p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
247 p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
248 p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
249 p_copy_of_account_line_id IN NUMBER := FND_API.G_MISS_NUM
250 );
251
252 /* ----------------------------------------------------------------------- */
253
254 -- API name : Revise_Account_Projections
255 -- Type : Private <Interface>
256 -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_ACCT2
257 -- Parameters :
258 -- IN : p_api_version IN NUMBER Required
259 -- p_init_msg_list IN VARCHAR2 Optional
260 -- Default = FND_API.G_FALSE
261 -- p_commit IN VARCHAR2 Optional
262 -- Default = FND_API.G_FALSE
263 -- p_validation_level IN NUMBER Optional
264 -- Default = FND_API.G_VALID_LEVEL_NONE
265 -- p_worksheet_id IN NUMBER Required
266 -- p_parameter_id IN NUMBER Required
267 -- .
268 -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
269 -- p_msg_count OUT NOCOPY NUMBER
270 -- p_msg_data OUT NOCOPY VARCHAR2(2000)
271 -- .
272 -- Version : Current version 1.0
273 -- Initial version 1.0
274 -- Created 02/12/2000 by Supriyo Ghosh
275 --
276
277 PROCEDURE Revise_Account_Projections
278 ( p_api_version IN NUMBER,
279 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
280 p_commit IN VARCHAR2 := FND_API.G_FALSE,
281 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
282 p_return_status OUT NOCOPY VARCHAR2,
283 p_msg_count OUT NOCOPY NUMBER,
284 p_msg_data OUT NOCOPY VARCHAR2,
285 p_worksheet_id IN NUMBER,
286 p_parameter_id IN NUMBER
287 );
288
289 /* ----------------------------------------------------------------------- */
290
291 -- API name : Update_GL_Balances
292 -- Type : Private <Interface>
293 -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_ACCT2
294 -- Parameters :
295 -- IN : p_api_version IN NUMBER Required
296 -- p_init_msg_list IN VARCHAR2 Optional
297 -- Default = FND_API.G_FALSE
298 -- p_commit IN VARCHAR2 Optional
299 -- Default = FND_API.G_FALSE
300 -- p_validation_level IN NUMBER Optional
301 -- Default = FND_API.G_VALID_LEVEL_NONE
302 -- p_worksheet_id IN NUMBER Required
303 -- .
304 -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
305 -- p_msg_count OUT NOCOPY NUMBER
306 -- p_msg_data OUT NOCOPY VARCHAR2(2000)
307 -- .
308 -- Version : Current version 1.0
309 -- Initial version 1.0
310 -- Created 01/20/1998 by Supriyo Ghosh
311 --
312 -- Notes : Update CY GL Balances
313 --
314
315 PROCEDURE Update_GL_Balances
316 ( p_api_version IN NUMBER,
317 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
318 p_commit IN VARCHAR2 := FND_API.G_FALSE,
319 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
320 p_return_status OUT NOCOPY VARCHAR2,
321 p_msg_count OUT NOCOPY NUMBER,
322 p_msg_data OUT NOCOPY VARCHAR2,
323 p_worksheet_id IN NUMBER
324 );
325
326 /* ----------------------------------------------------------------------- */
327
328 -- API name : Create_Rollup_Totals
329 -- Type : Private <Interface>
330 -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_ACCT2
331 -- Parameters :
332 -- IN : p_api_version IN NUMBER Required
333 -- p_init_msg_list IN VARCHAR2 Optional
334 -- Default = FND_API.G_FALSE
335 -- p_commit IN VARCHAR2 Optional
336 -- Default = FND_API.G_FALSE
337 -- p_validation_level IN NUMBER Optional
338 -- Default = FND_API.G_VALID_LEVEL_NONE
339 -- p_worksheet_id IN NUMBER Required
340 -- p_rounding_factor IN NUMBER Optional
341 -- Default = FND_API.G_MISS_NUM
342 -- p_stage_set_id IN NUMBER Optional
343 -- Default = FND_API.G_MISS_NUM
344 -- p_current_stage_seq IN NUMBER Optional
345 -- Default = FND_API.G_MISS_NUM
346 -- p_set_of_books_id IN NUMBER Optional
347 -- Default = FND_API.G_MISS_NUM
348 -- p_flex_code IN NUMBER Optional
349 -- Default = FND_API.G_MISS_NUM
350 -- p_budget_group_id IN NUMBER Optional
351 -- Default = FND_API.G_MISS_NUM
352 -- p_budget_calendar_id IN NUMBER Optional
353 -- Default = FND_API.G_MISS_NUM
354 -- .
355 -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
356 -- p_msg_count OUT NOCOPY NUMBER
357 -- p_msg_data OUT NOCOPY VARCHAR2(2000)
358 -- .
359 -- Version : Current version 1.0
360 -- Initial version 1.0
361 -- Created 06/15/1997 by Supriyo Ghosh
362 --
363 -- Notes : Create Summary Rollups for Worksheet Accounts
364 --
365
366 PROCEDURE Create_Rollup_Totals
367 ( p_api_version IN NUMBER,
368 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
369 p_commit IN VARCHAR2 := FND_API.G_FALSE,
370 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
371 p_return_status OUT NOCOPY VARCHAR2,
372 p_msg_count OUT NOCOPY NUMBER,
373 p_msg_data OUT NOCOPY VARCHAR2,
374 p_worksheet_id IN NUMBER,
375 p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
376 p_stage_set_id IN NUMBER := FND_API.G_MISS_NUM,
377 p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
378 p_set_of_books_id IN NUMBER := FND_API.G_MISS_NUM,
379 p_flex_code IN NUMBER := FND_API.G_MISS_NUM,
380 p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
381 p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM
382 );
383
384 /* ----------------------------------------------------------------------- */
385
386 PROCEDURE Update_GL_Balances_CP
387 (
388 errbuf OUT NOCOPY VARCHAR2,
389 retcode OUT NOCOPY VARCHAR2,
390 p_worksheet_id IN NUMBER := FND_API.G_MISS_NUM
391 );
392
393 PROCEDURE Create_Rollup_Totals_CP
394 (
395 errbuf OUT NOCOPY VARCHAR2,
396 retcode OUT NOCOPY VARCHAR2,
397 p_create_summary_totals IN VARCHAR2,
398 p_worksheet_id IN NUMBER := FND_API.G_MISS_NUM
399 );
400
401 PROCEDURE Revise_Account_Projections_CP
402 (
403 errbuf OUT NOCOPY VARCHAR2,
404 retcode OUT NOCOPY VARCHAR2,
405 p_worksheet_id IN NUMBER,
406 p_parameter_id IN NUMBER
407 );
408
409
410 END PSB_WS_ACCT_PVT;