1 PACKAGE PSB_WS_POS_PVT AS
2 /* $Header: PSBPWCPS.pls 120.4 2005/07/28 16:50:51 shtripat ship $ */
3
4 /* ----------------------------------------------------------------------- */
5
6 -- API name : Check_Allowed
7 -- Type : Private <Interface>
8 -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1
9 -- Parameters :
10 -- IN : p_api_version IN NUMBER Required
11 -- p_init_msg_list IN VARCHAR2 Optional
12 -- Default = FND_API.G_FALSE
13 -- p_validation_level IN NUMBER Optional
14 -- Default = FND_API.G_VALID_LEVEL_NONE
15 -- p_worksheet_id IN NUMBER Required
16 -- p_position_budget_group_id IN NUMBER Required
17 -- .
18 -- OUT NOCOPY : p_msg_count OUT NOCOPY NUMBER
19 -- p_msg_data OUT NOCOPY VARCHAR2(2000)
20 -- .
21 -- Version : Current version 1.0
22 -- Initial version 1.0
23 -- Created 01/04/1998 by Supriyo Ghosh
24 -- .
25 -- Notes : Check if Position Budget Group is within the Budget
26 -- Group Hierarchy for the Worksheet. This function
27 -- returns values FND_API.G_TRUE or FND_API.G_FALSE.
28 --
29
30 FUNCTION Check_Allowed
31 ( p_api_version IN NUMBER,
32 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
33 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
34 p_msg_count OUT NOCOPY NUMBER,
35 p_msg_data OUT NOCOPY VARCHAR2,
36 p_worksheet_id IN NUMBER,
37 p_position_budget_group_id IN NUMBER
38 ) RETURN VARCHAR2;
39
40 /* ----------------------------------------------------------------------- */
41
42 -- API name : Create_Position_Lines
43 -- Type : Private <Interface>
44 -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1
45 -- Parameters :
46 -- IN : p_api_version IN NUMBER Required
47 -- p_init_msg_list IN VARCHAR2 Optional
48 -- Default = FND_API.G_FALSE
49 -- p_commit IN VARCHAR2 Optional
50 -- Default = FND_API.G_FALSE
51 -- p_validation_level IN NUMBER Optional
52 -- Default = FND_API.G_VALID_LEVEL_NONE
53 -- p_worksheet_id IN NUMBER Required
54 -- p_position_id IN NUMBER Required
55 -- p_budget_group_id IN NUMBER Required
56 -- p_copy_of_position_line_id IN NUMBER Optional
57 -- Default = FND_API.G_MISS_NUM
58 -- .
59 -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
60 -- p_msg_count OUT NOCOPY NUMBER
61 -- p_msg_data OUT NOCOPY VARCHAR2(2000)
62 -- p_position_line_id OUT NOCOPY NUMBER
63 -- .
64 -- Version : Current version 1.0
65 -- Initial version 1.0
66 -- Created 01/04/1998 by Supriyo Ghosh
67 -- .
68 -- Notes : Create Position Instance for Global Worksheet and
69 -- also create the matrix between the Position instance
70 -- and the Global Worksheet
71 --
72
73 PROCEDURE Create_Position_Lines
74 ( p_api_version IN NUMBER,
75 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
76 p_commit IN VARCHAR2 := FND_API.G_FALSE,
77 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
78 p_return_status OUT NOCOPY VARCHAR2,
79 p_msg_count OUT NOCOPY NUMBER,
80 p_msg_data OUT NOCOPY VARCHAR2,
81 p_position_line_id OUT NOCOPY NUMBER,
82 p_worksheet_id IN NUMBER,
83 p_position_id IN NUMBER,
84 p_budget_group_id IN NUMBER,
85 p_copy_of_position_line_id IN NUMBER := FND_API.G_MISS_NUM
86 );
87
88 /* ----------------------------------------------------------------------- */
89
90 -- API name : Create_Position_Matrix
91 -- Type : Private <Interface>
92 -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1
93 -- Parameters :
94 -- IN : p_api_version IN NUMBER Required
95 -- p_init_msg_list IN VARCHAR2 Optional
96 -- Default = FND_API.G_FALSE
97 -- p_commit IN VARCHAR2 Optional
98 -- Default = FND_API.G_FALSE
99 -- p_validation_level IN NUMBER Optional
100 -- Default = FND_API.G_VALID_LEVEL_NONE
101 -- p_worksheet_id IN NUMBER Required
102 -- p_position_line_id IN NUMBER Required
103 -- p_freeze_flag IN VARCHAR2 Optional
104 -- Default = FND_API.G_FALSE
105 -- p_view_line_flag IN VARCHAR2 Optional
106 -- Default = FND_API.G_TRUE
107 -- .
108 -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
109 -- p_msg_count OUT NOCOPY NUMBER
110 -- p_msg_data OUT NOCOPY VARCHAR2(2000)
111 -- .
112 -- Version : Current version 1.0
113 -- Initial version 1.0
114 -- Created 01/04/1998 by Supriyo Ghosh
115 -- .
116 -- Notes : Create Position Matrix relationship between the
117 -- Position instance and the Global Worksheet
118 --
119
120 PROCEDURE Create_Position_Matrix
121 ( p_api_version IN NUMBER,
122 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123 p_commit IN VARCHAR2 := FND_API.G_FALSE,
124 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
125 p_return_status OUT NOCOPY VARCHAR2,
126 p_msg_count OUT NOCOPY NUMBER,
127 p_msg_data OUT NOCOPY VARCHAR2,
128 p_worksheet_id IN NUMBER,
129 p_position_line_id IN NUMBER,
130 p_freeze_flag IN VARCHAR2 := FND_API.G_FALSE,
131 p_view_line_flag IN VARCHAR2 := FND_API.G_TRUE
132 );
133
134 /* ----------------------------------------------------------------------- */
135
136 -- API name : Create_FTE_Lines
137 -- Type : Private <Interface>
138 -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1
139 -- Parameters :
140 -- IN : p_api_version IN NUMBER Required
141 -- p_init_msg_list IN VARCHAR2 Optional
142 -- Default = FND_API.G_FALSE
143 -- p_commit IN VARCHAR2 Optional
144 -- Default = FND_API.G_FALSE
145 -- p_validation_level IN NUMBER Optional
146 -- Default = FND_API.G_VALID_LEVEL_NONE
147 -- p_check_spfl_exists IN VARCHAR2 Optional
148 -- Default = FND_API.G_TRUE
149 -- p_recalculate_flag IN VARCHAR2 Optional
150 -- Default = FND_API.G_FALSE
151 -- p_worksheet_id IN NUMBER Required
152 -- p_flex_mapping_set_id IN NUMBER Optional
153 -- Default = FND_API.G_MISS_NUM
154 -- p_position_line_id IN NUMBER Required
155 -- p_budget_year_id IN NUMBER Required
156 -- p_budget_group_id IN NUMBER Optional
157 -- Default = FND_API.G_MISS_NUM
158 -- p_annual_fte IN NUMBER Optional
159 -- Default = FND_API.G_MISS_NUM
160 -- p_service_package_id IN NUMBER Required
161 -- p_stage_set_id IN NUMBER Required
162 -- p_start_stage_seq IN NUMBER Optional
163 -- Default = FND_API.G_MISS_NUM
164 -- p_current_stage_seq IN NUMBER Required
165 -- p_end_stage_seq IN NUMBER Optional
166 -- Default = FND_API.G_MISS_NUM
167 -- p_period_fte IN TABLE Required
168 -- .
169 -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
170 -- p_msg_count OUT NOCOPY NUMBER
171 -- p_msg_data OUT NOCOPY VARCHAR2(2000)
172 -- p_fte_line_id OUT NOCOPY NUMBER
173 -- .
174 -- Version : Current version 1.0
175 -- Initial version 1.0
176 -- Created 01/04/1998 by Supriyo Ghosh
177 -- .
178 -- Notes : Create Worksheet Position FTE Line
179 --
180
181 PROCEDURE Create_FTE_Lines
182 ( p_api_version IN NUMBER,
183 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
184 p_commit IN VARCHAR2 := FND_API.G_FALSE,
185 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
186 p_return_status OUT NOCOPY VARCHAR2,
187 p_msg_count OUT NOCOPY NUMBER,
188 p_msg_data OUT NOCOPY VARCHAR2,
189 p_fte_line_id OUT NOCOPY NUMBER,
190 p_check_spfl_exists IN VARCHAR2 := FND_API.G_TRUE,
191 p_recalculate_flag IN VARCHAR2 := FND_API.G_FALSE,
192 p_worksheet_id IN NUMBER,
193 p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
194 p_position_line_id IN NUMBER,
195 p_budget_year_id IN NUMBER,
196 p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
197 p_annual_fte IN NUMBER := FND_API.G_MISS_NUM,
198 p_service_package_id IN NUMBER,
199 p_stage_set_id IN NUMBER,
200 p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
201 p_current_stage_seq IN NUMBER,
202 p_end_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
203 p_period_fte IN PSB_WS_ACCT1.g_prdamt_tbl_type
204 );
205
206 /* ----------------------------------------------------------------------- */
207
208 -- API name : Create_FTE_Lines
209 -- Type : Private <Interface>
210 -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1
211 -- Parameters :
212 -- IN : p_api_version IN NUMBER Required
213 -- p_init_msg_list IN VARCHAR2 Optional
214 -- Default = FND_API.G_FALSE
215 -- p_commit IN VARCHAR2 Optional
216 -- Default = FND_API.G_FALSE
217 -- p_validation_level IN NUMBER Optional
218 -- Default = FND_API.G_VALID_LEVEL_NONE
219 -- p_check_stages IN VARCHAR2 Optional
220 -- Default = FND_API.G_TRUE
221 -- p_worksheet_id IN NUMBER Required
222 -- p_fte_line_id IN NUMBER Required
223 -- p_service_package_id IN NUMBER Optional
224 -- Default = FND_API.G_MISS_NUM
225 -- p_current_stage_seq IN NUMBER Optional
226 -- Default = FND_API.G_MISS_NUM
227 -- p_period_fte IN TABLE Required
228 -- p_budget_group_id IN NUMBER Optional
229 -- Default = FND_API.G_MISS_NUM
230 -- .
231 -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
232 -- p_msg_count OUT NOCOPY NUMBER
233 -- p_msg_data OUT NOCOPY VARCHAR2(2000)
234 -- .
235 -- Version : Current version 1.0
236 -- Initial version 1.0
237 -- Created 01/04/1998 by Supriyo Ghosh
238 --
239 -- Notes : Update Worksheet Position FTE Line
240 --
241
242 PROCEDURE Create_FTE_Lines
243 ( p_api_version IN NUMBER,
244 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
245 p_commit IN VARCHAR2 := FND_API.G_FALSE,
246 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
247 p_return_status OUT NOCOPY VARCHAR2,
248 p_msg_count OUT NOCOPY NUMBER,
249 p_msg_data OUT NOCOPY VARCHAR2,
250 p_check_stages IN VARCHAR2 := FND_API.G_TRUE,
251 p_worksheet_id IN NUMBER,
252 p_fte_line_id IN NUMBER,
253 p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
254 p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
255 p_period_fte IN PSB_WS_ACCT1.g_prdamt_tbl_type,
256 p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM
257 );
258
259 /* ----------------------------------------------------------------------- */
260
261 -- API name : Create_Element_Lines
262 -- Type : Private <Interface>
263 -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1
264 -- Parameters :
265 -- IN : p_api_version IN NUMBER Required
266 -- p_init_msg_list IN VARCHAR2 Optional
267 -- Default = FND_API.G_FALSE
268 -- p_commit IN VARCHAR2 Optional
269 -- Default = FND_API.G_FALSE
270 -- p_validation_level IN NUMBER Optional
271 -- Default = FND_API.G_VALID_LEVEL_NONE
272 -- p_check_spel_exists IN VARCHAR2 Optional
273 -- Default = FND_API.G_TRUE
274 -- p_position_line_id IN NUMBER Required
275 -- p_budget_year_id IN NUMBER Required
276 -- p_pay_element_id IN NUMBER Required
277 -- p_currency_code IN VARCHAR2 Required
278 -- p_element_cost IN NUMBER Required
279 -- p_element_set_id IN NUMBER Required
280 -- p_service_package_id IN NUMBER Required
281 -- p_stage_set_id IN NUMBER Required
282 -- p_start_stage_seq IN NUMBER Optional
283 -- Default = FND_API.G_MISS_NUM
284 -- p_current_stage_seq IN NUMBER Required
285 -- p_end_stage_seq IN NUMBER Optional
286 -- Default = FND_API.G_MISS_NUM
287 -- .
288 -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
289 -- p_msg_count OUT NOCOPY NUMBER
290 -- p_msg_data OUT NOCOPY VARCHAR2(2000)
291 -- p_element_line_id OUT NOCOPY NUMBER
292 -- .
293 -- Version : Current version 1.0
294 -- Initial version 1.0
295 -- Created 01/04/1998 by Supriyo Ghosh
296 --
297 -- Notes : Create Position Element Cost Line
298 --
299
300 PROCEDURE Create_Element_Lines
301 ( p_api_version IN NUMBER,
302 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
306 p_msg_count OUT NOCOPY NUMBER,
303 p_commit IN VARCHAR2 := FND_API.G_FALSE,
304 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
305 p_return_status OUT NOCOPY VARCHAR2,
307 p_msg_data OUT NOCOPY VARCHAR2,
308 p_element_line_id OUT NOCOPY NUMBER,
309 p_check_spel_exists IN VARCHAR2 := FND_API.G_TRUE,
310 p_position_line_id IN NUMBER,
311 p_budget_year_id IN NUMBER,
312 p_pay_element_id IN NUMBER,
313 p_currency_code IN VARCHAR2,
314 p_element_cost IN NUMBER,
315 p_element_set_id IN NUMBER,
316 p_service_package_id IN NUMBER,
317 p_stage_set_id IN NUMBER,
318 p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
319 p_current_stage_seq IN NUMBER,
320 p_end_stage_seq IN NUMBER := FND_API.G_MISS_NUM);
321
322 /* ----------------------------------------------------------------------- */
323
324 -- API name : Create_Element_Lines
325 -- Type : Private <Interface>
326 -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1
327 -- Parameters :
328 -- IN : p_api_version IN NUMBER Required
329 -- p_init_msg_list IN VARCHAR2 Optional
330 -- Default = FND_API.G_FALSE
331 -- p_commit IN VARCHAR2 Optional
332 -- Default = FND_API.G_FALSE
333 -- p_validation_level IN NUMBER Optional
334 -- Default = FND_API.G_VALID_LEVEL_NONE
335 -- p_check_stages IN VARCHAR2 Optional
336 -- Default = FND_API.G_TRUE
337 -- p_element_line_id IN NUMBER Required
338 -- p_service_package_id IN NUMBER Optional
339 -- Default = FND_API.G_MISS_NUM
340 -- p_current_stage_seq IN NUMBER Optional
341 -- Default = FND_API.G_MISS_NUM
342 -- p_element_cost IN NUMBER Optional
343 -- Default = FND_API.G_MISS_NUM
344 -- .
345 -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
346 -- p_msg_count OUT NOCOPY NUMBER
347 -- p_msg_data OUT NOCOPY VARCHAR2(2000)
348 -- .
349 -- Version : Current version 1.0
350 -- Initial version 1.0
351 -- Created 08/12/1998 by Supriyo Ghosh
352 --
353 -- Notes : Update Worksheet Position Element Line
354 --
355
356 PROCEDURE Create_Element_Lines
357 ( p_api_version IN NUMBER,
358 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
359 p_commit IN VARCHAR2 := FND_API.G_FALSE,
360 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
361 p_return_status OUT NOCOPY VARCHAR2,
362 p_msg_count OUT NOCOPY NUMBER,
363 p_msg_data OUT NOCOPY VARCHAR2,
364 p_check_stages IN VARCHAR2 := FND_API.G_TRUE,
365 p_element_line_id IN NUMBER,
366 p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
367 p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
368 p_element_cost IN NUMBER := FND_API.G_MISS_NUM
369 );
370
371 /* ----------------------------------------------------------------------- */
372
373 -- API name : Update_Annual_FTE
374 -- Type : Private <Interface>
375 -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1
376 -- Parameters :
377 -- IN : p_api_version IN NUMBER Required
378 -- p_init_msg_list IN VARCHAR2 Optional
379 -- Default = FND_API.G_FALSE
380 -- p_commit IN VARCHAR2 Optional
381 -- Default = FND_API.G_FALSE
382 -- p_validation_level IN NUMBER Optional
383 -- Default = FND_API.G_VALID_LEVEL_NONE
384 -- p_worksheet_id IN NUMBER Required
385 -- p_position_line_id IN NUMBER Required
386 -- p_budget_year_id IN NUMBER Required
387 -- p_service_package_id IN NUMBER Required
388 -- p_stage_set_id IN NUMBER Required
389 -- p_current_stage_seq IN NUMBER Required
390 -- p_budget_group_id IN NUMBER Optional
391 -- Default = FND_API.G_MISS_NUM
392 -- .
393 -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
394 -- p_msg_count OUT NOCOPY NUMBER
395 -- p_msg_data OUT NOCOPY VARCHAR2(2000)
396 -- .
397 -- Version : Current version 1.0
398 -- Initial version 1.0
399 -- Created 03/09/1998 by Supriyo Ghosh
400 --
401 -- Notes : Update Annual FTE for a position instance
402 --
403
404 PROCEDURE Update_Annual_FTE
408 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
405 ( p_api_version IN NUMBER,
406 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
407 p_commit IN VARCHAR2 := FND_API.G_FALSE,
409 p_return_status OUT NOCOPY VARCHAR2,
410 p_msg_count OUT NOCOPY NUMBER,
411 p_msg_data OUT NOCOPY VARCHAR2,
412 p_worksheet_id IN NUMBER,
413 p_position_line_id IN NUMBER,
414 p_budget_year_id IN NUMBER,
415 p_service_package_id IN NUMBER,
416 p_stage_set_id IN NUMBER,
417 p_current_stage_seq IN NUMBER,
418 p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM
419 );
420
421 /* ----------------------------------------------------------------------- */
422
423 -- API name : Redistribute_Follow_Salary
424 -- Type : Private <Interface>
425 -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1
426 -- Parameters :
427 -- IN : p_api_version IN NUMBER Required
428 -- p_init_msg_list IN VARCHAR2 Optional
429 -- Default = FND_API.G_FALSE
430 -- p_commit IN VARCHAR2 Optional
431 -- Default = FND_API.G_FALSE
432 -- p_validation_level IN NUMBER Optional
433 -- Default = FND_API.G_VALID_LEVEL_NONE
434 -- p_worksheet_id IN NUMBER Required
435 -- p_position_line_id IN NUMBER Required
436 -- p_budget_year_id IN NUMBER Optional
437 -- Default = FND_API.G_MISS_NUM
438 -- p_service_package_id IN NUMBER Required
439 -- p_stage_set_id IN NUMBER Required
440 -- p_func_currency IN VARCHAR2 Optional
441 -- Default = FND_API.G_MISS_CHAR
442 -- .
443 -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
444 -- p_msg_count OUT NOCOPY NUMBER
445 -- p_msg_data OUT NOCOPY VARCHAR2(2000)
446 -- .
447 -- Version : Current version 1.0
448 -- Initial version 1.0
449 -- Created 01/04/1998 by Supriyo Ghosh
450 --
451 -- Notes : Redistribute Follow Salary
452 --
453
454 PROCEDURE Redistribute_Follow_Salary
455 ( p_api_version IN NUMBER,
456 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
457 p_commit IN VARCHAR2 := FND_API.G_FALSE,
458 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
459 p_return_status OUT NOCOPY VARCHAR2,
460 p_msg_count OUT NOCOPY NUMBER,
461 p_msg_data OUT NOCOPY VARCHAR2,
462 p_worksheet_id IN NUMBER,
463 p_position_line_id IN NUMBER,
464 p_budget_year_id IN NUMBER := FND_API.G_MISS_NUM,
465 p_service_package_id IN NUMBER,
466 p_stage_set_id IN NUMBER,
467 p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR
468 );
469
470 /* ----------------------------------------------------------------------- */
471
472 -- API name : Apply_Element_Parameters
473 -- Type : Private <Interface>
474 -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1
475 -- Parameters :
476 -- IN : p_api_version IN NUMBER Required
477 -- p_init_msg_list IN VARCHAR2 Optional
478 -- Default = FND_API.G_FALSE
479 -- p_commit IN VARCHAR2 Optional
480 -- Default = FND_API.G_FALSE
481 -- p_validation_level IN NUMBER Optional
482 -- Default = FND_API.G_VALID_LEVEL_NONE
483 -- p_worksheet_id IN NUMBER Required
484 -- p_global_worksheet IN VARCHAR2 Optional
485 -- Default = FND_API.G_MISS_CHAR
486 -- p_budget_group_id IN NUMBER Optional
487 -- Default = FND_API.G_MISS_NUM
488 -- p_data_extract_id IN NUMBER Optional
489 -- Default = FND_API.G_MISS_NUM
490 -- p_business_group_id IN NUMBER Optional
491 -- Default = FND_API.G_MISS_NUM
492 -- p_func_currency IN VARCHAR2 Optional
493 -- Default = FND_API.G_MISS_CHAR
494 -- p_budget_calendar_id IN NUMBER Optional
495 -- Default = FND_API.G_MISS_NUM
496 -- p_parameter_set_id IN NUMBER Optional
497 -- Default = FND_API.G_MISS_NUM
498 -- .
499 -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
500 -- p_msg_count OUT NOCOPY NUMBER
501 -- p_msg_data OUT NOCOPY VARCHAR2(2000)
502 -- .
503 -- Version : Current version 1.0
504 -- Initial version 1.0
508 -- and non-AutoIncrement)
505 -- Created 01/04/1998 by Supriyo Ghosh
506 --
507 -- Notes : Apply Element Parameters (AutoIncrement
509 --
510
511 PROCEDURE Apply_Element_Parameters
512 ( p_api_version IN NUMBER,
513 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
514 p_commit IN VARCHAR2 := FND_API.G_FALSE,
515 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
516 p_return_status OUT NOCOPY VARCHAR2,
517 p_msg_count OUT NOCOPY NUMBER,
518 p_msg_data OUT NOCOPY VARCHAR2,
519 p_worksheet_id IN NUMBER,
520 p_global_worksheet IN VARCHAR2 := FND_API.G_MISS_CHAR,
521 p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
522 p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
523 p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
524 p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
525 p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
526 p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM
527 );
528
529 /* ----------------------------------------------------------------------- */
530
531 -- API name : Apply_Position_Parameters
532 -- Type : Private <Interface>
533 -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1
534 -- Parameters :
535 -- IN : p_api_version IN NUMBER Required
536 -- p_init_msg_list IN VARCHAR2 Optional
537 -- Default = FND_API.G_FALSE
538 -- p_commit IN VARCHAR2 Optional
539 -- Default = FND_API.G_FALSE
540 -- p_validation_level IN NUMBER Optional
541 -- Default = FND_API.G_VALID_LEVEL_NONE
542 -- p_worksheet_id IN NUMBER Required
543 -- p_global_worksheet IN VARCHAR2 Optional
544 -- Default = FND_API.G_MISS_CHAR
545 -- p_budget_group_id IN NUMBER Optional
546 -- Default = FND_API.G_MISS_NUM
547 -- p_data_extract_id IN NUMBER Optional
548 -- Default = FND_API.G_MISS_NUM
549 -- p_business_group_id IN NUMBER Optional
550 -- Default = FND_API.G_MISS_NUM
551 -- p_func_currency IN VARCHAR2 Optional
552 -- Default = FND_API.G_MISS_CHAR
553 -- p_budget_calendar_id IN NUMBER Optional
554 -- Default = FND_API.G_MISS_NUM
555 -- p_parameter_set_id IN NUMBER Optional
556 -- Default = FND_API.G_MISS_NUM
557 -- .
558 -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
559 -- p_msg_count OUT NOCOPY NUMBER
560 -- p_msg_data OUT NOCOPY VARCHAR2(2000)
561 -- .
562 -- Version : Current version 1.0
563 -- Initial version 1.0
564 -- Created 01/04/1998 by Supriyo Ghosh
565 --
566 -- Notes : Apply Position Parameters (AutoIncrement
567 -- and non-AutoIncrement)
568 --
569
570 PROCEDURE Apply_Position_Parameters
571 ( p_api_version IN NUMBER,
572 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
573 p_commit IN VARCHAR2 := FND_API.G_FALSE,
574 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
575 p_return_status OUT NOCOPY VARCHAR2,
576 p_msg_count OUT NOCOPY NUMBER,
577 p_msg_data OUT NOCOPY VARCHAR2,
578 p_worksheet_id IN NUMBER,
579 p_global_worksheet IN VARCHAR2 := FND_API.G_MISS_CHAR,
580 p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
581 p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
582 p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
583 p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
584 p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
585 p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM
586 );
587
588 /* ----------------------------------------------------------------------- */
589
590 -- API name : Calculate_Position_Cost
591 -- Type : Private <Interface>
592 -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS2
593 -- Parameters :
594 -- IN : p_api_version IN NUMBER Required
595 -- p_init_msg_list IN VARCHAR2 Optional
596 -- Default = FND_API.G_FALSE
597 -- p_commit IN VARCHAR2 Optional
598 -- Default = FND_API.G_FALSE
599 -- p_validation_level IN NUMBER Optional
600 -- Default = FND_API.G_VALID_LEVEL_NONE
601 -- p_worksheet_id IN NUMBER Required
602 -- p_position_line_id IN NUMBER Required
603 -- p_recalculate_flag IN VARCHAR2 Optional
604 -- Default = FND_API.G_MISS_TRUE
605 -- p_root_budget_group_id IN NUMBER Optional
609 -- p_assign_worksheet_id IN NUMBER Optional
606 -- Default = FND_API.G_MISS_NUM
607 -- p_global_worksheet_id IN NUMBER Optional
608 -- Default = FND_API.G_MISS_NUM
610 -- Default = FND_API.G_MISS_NUM
611 -- p_worksheet_numyrs IN NUMBER Optional
612 -- Default = FND_API.G_MISS_NUM
613 -- p_rounding_factor IN NUMBER Optional
614 -- Default = FND_API.G_MISS_NUM
615 -- p_service_package_id IN NUMBER Optional
616 -- Default = FND_API.G_MISS_NUM
617 -- p_stage_set_id IN NUMBER Optional
618 -- Default = FND_API.G_MISS_NUM
619 -- p_start_stage_seq IN NUMBER Optional
620 -- Default = FND_API.G_MISS_NUM
621 -- p_current_stage_seq IN NUMBER Optional
622 -- Default = FND_API.G_MISS_NUM
623 -- p_data_extract_id IN NUMBER Optional
624 -- Default = FND_API.G_MISS_NUM
625 -- p_business_group_id IN NUMBER Optional
626 -- Default = FND_API.G_MISS_NUM
627 -- p_budget_calendar_id IN NUMBER Optional
628 -- Default = FND_API.G_MISS_NUM
629 -- p_func_currency IN VARCHAR2 Optional
630 -- Default = FND_API.G_MISS_CHAR
631 -- p_flex_code IN NUMBER Optional
632 -- Default = FND_API.G_MISS_NUM
633 -- p_position_id IN NUMBER Optional
634 -- Default = FND_API.G_MISS_NUM
635 -- p_position_name IN NUMBER Optional
636 -- Default = FND_API.G_MISS_CHAR
637 -- p_position_start_date IN DATE Optional
638 -- Default = FND_API.G_MISS_DATE
639 -- p_position_end_date IN DATE Optional
640 -- Default = FND_API.G_MISS_DATE
641 -- .
642 -- OUT NOCOPY :p_return_status OUT NOCOPY VARCHAR2(1)
643 -- p_msg_count OUT NOCOPY NUMBER
644 -- p_msg_data OUT NOCOPY VARCHAR2(2000)
645 -- .
646 -- Version : Current version 1.0
647 -- Initial version 1.0
648 -- Created 01/04/1998 by Supriyo Ghosh
649 --
650 -- Notes : Calculate Position Cost for a Position Instance.
651 -- If p_recalculate_flag is set to FND_API.G_TRUE,
652 -- this process recalculates the Position Costs for the
653 -- Position Instance
654 --
655
656 PROCEDURE Calculate_Position_Cost
657 ( p_api_version IN NUMBER,
658 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
659 p_commit IN VARCHAR2 := FND_API.G_FALSE,
660 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
661 p_return_status OUT NOCOPY VARCHAR2,
662 p_msg_count OUT NOCOPY NUMBER,
663 p_msg_data OUT NOCOPY VARCHAR2,
664 p_worksheet_id IN NUMBER,
665 p_position_line_id IN NUMBER,
666 p_recalculate_flag IN VARCHAR2 := FND_API.G_TRUE,
667 p_root_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
668 p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
669 p_assign_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
670 p_worksheet_numyrs IN NUMBER := FND_API.G_MISS_NUM,
671 p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
672 p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
673 p_stage_set_id IN NUMBER := FND_API.G_MISS_NUM,
674 p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
675 p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
676 p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
677 p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
678 p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
679 p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
680 p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
681 p_flex_code IN NUMBER := FND_API.G_MISS_NUM,
682 p_position_id IN NUMBER := FND_API.G_MISS_NUM,
683 p_position_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
684 p_position_start_date IN DATE := FND_API.G_MISS_DATE,
685 p_position_end_date IN DATE := FND_API.G_MISS_DATE
686 );
687
688 /* ----------------------------------------------------------------------- */
689
690 -- API name : Revise_Position_Projections
691 -- Type : Private <Interface>
692 -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_ACCT2
693 -- Parameters :
694 -- IN : p_api_version IN NUMBER Required
695 -- p_init_msg_list IN VARCHAR2 Optional
696 -- Default = FND_API.G_FALSE
697 -- p_commit IN VARCHAR2 Optional
698 -- Default = FND_API.G_FALSE
702 -- p_parameter_id IN NUMBER Required
699 -- p_validation_level IN NUMBER Optional
700 -- Default = FND_API.G_VALID_LEVEL_NONE
701 -- p_worksheet_id IN NUMBER Required
703 -- .
704 -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
705 -- p_msg_count OUT NOCOPY NUMBER
706 -- p_msg_data OUT NOCOPY VARCHAR2(2000)
707 -- .
708 -- Version : Current version 1.0
709 -- Initial version 1.0
710 -- Created 04/10/2000 by Supriyo Ghosh
711 --
712
713 PROCEDURE Revise_Position_Projections
714 ( p_api_version IN NUMBER,
715 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
716 p_commit IN VARCHAR2 := FND_API.G_FALSE,
717 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
718 p_return_status OUT NOCOPY VARCHAR2,
719 p_msg_count OUT NOCOPY NUMBER,
720 p_msg_data OUT NOCOPY VARCHAR2,
721 p_worksheet_id IN NUMBER,
722 p_parameter_id IN NUMBER
723 );
724
725 /* ----------------------------------------------------------------------- */
726
727 PROCEDURE Apply_Element_Parameters_CP
728 (
729 errbuf OUT NOCOPY VARCHAR2,
730 retcode OUT NOCOPY VARCHAR2,
731 --
732 p_worksheet_id IN NUMBER
733 );
734
735 PROCEDURE Validate_Positions_CP
736 (
737 errbuf OUT NOCOPY VARCHAR2,
738 retcode OUT NOCOPY VARCHAR2,
739 --
740 p_worksheet_id IN NUMBER
741 );
742
743 PROCEDURE Revise_Position_Projections_CP
744 (
745 errbuf OUT NOCOPY VARCHAR2,
746 retcode OUT NOCOPY VARCHAR2,
747 p_worksheet_id IN NUMBER,
748 p_parameter_id IN NUMBER
749 );
750
751 /* ----------------------------------------------------------------------- */
752 /* Bug No 2482305 Start */
753
754 PROCEDURE Revise_Element_Projections_CP
755 (
756 errbuf OUT NOCOPY VARCHAR2,
757 retcode OUT NOCOPY VARCHAR2,
758 p_worksheet_id IN NUMBER,
759 p_parameter_id IN NUMBER
760 );
761
762 PROCEDURE Revise_Element_Projections
763 ( p_api_version IN NUMBER,
764 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
765 p_commit IN VARCHAR2 := FND_API.G_FALSE,
766 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
767 p_return_status OUT NOCOPY VARCHAR2,
768 p_msg_count OUT NOCOPY NUMBER,
769 p_msg_data OUT NOCOPY VARCHAR2,
770 p_worksheet_id IN NUMBER,
771 p_parameter_id IN NUMBER
772 );
773
774 /* Bug No 2482305 End */
775 /* ----------------------------------------------------------------------- */
776
777 END PSB_WS_POS_PVT;