[Home] [Help]
PACKAGE: APPS.PSB_WORKSHEET_PVT
Source
1 PACKAGE PSB_WORKSHEET_PVT AS
2 /* $Header: PSBPWCMS.pls 120.6 2005/11/14 11:50:56 viraghun ship $ */
3
4 /* ----------------------------------------------------------------------- */
5
6 -- API name : Create_WS_Line_Items
7 -- Type : Private <Interface>
8 -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WORKSHEET
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_commit IN VARCHAR2 Optional
14 -- Default = FND_API.G_FALSE
15 -- p_validation_level IN NUMBER Optional
16 -- Default = FND_API.G_VALID_LEVEL_NONE
17 -- p_worksheet_id IN NUMBER Required
18 -- .
19 -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
20 -- p_msg_count OUT NOCOPY NUMBER
21 -- p_msg_data OUT NOCOPY VARCHAR2(2000)
22 -- .
23 -- Version : Current version 1.0
24 -- Initial version 1.0
25 -- Created 07/07/1997 by Supriyo Ghosh
26 --
27 -- Notes : Create Worksheet Account and Position Line Items
28 --
29
30 PROCEDURE Create_WS_Line_Items
31 ( p_api_version IN NUMBER,
32 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
33 p_commit IN VARCHAR2 := FND_API.G_FALSE,
34 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
35 p_return_status OUT NOCOPY VARCHAR2,
36 p_msg_count OUT NOCOPY NUMBER,
37 p_msg_data OUT NOCOPY VARCHAR2,
38 p_worksheet_id IN NUMBER
39 );
40
41 /* ----------------------------------------------------------------------- */
42
43 -- API name : Delete_WS_Line_Items
44 -- Type : Private <Interface>
45 -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WORKSHEET
46 -- Parameters :
47 -- IN : p_api_version IN NUMBER Required
48 -- p_init_msg_list IN VARCHAR2 Optional
49 -- Default = FND_API.G_FALSE
50 -- p_commit IN VARCHAR2 Optional
51 -- Default = FND_API.G_FALSE
52 -- p_validation_level IN NUMBER Optional
53 -- Default = FND_API.G_VALID_LEVEL_NONE
54 -- p_worksheet_id IN NUMBER Required
55 -- p_global_worksheet IN VARCHAR2 Optional
56 -- Default = FND_API.G_TRUE
57 -- .
58 -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
59 -- p_msg_count OUT NOCOPY NUMBER
60 -- p_msg_data OUT NOCOPY VARCHAR2(2000)
61 -- .
62 -- Version : Current version 1.0
63 -- Initial version 1.0
64 -- Created 07/07/1997 by Supriyo Ghosh
65 --
66 -- Notes : Delete Worksheet Account and Position Line Items
67 --
68
69 PROCEDURE Delete_WS_Line_Items
70 ( p_api_version IN NUMBER,
71 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
72 p_commit IN VARCHAR2 := FND_API.G_FALSE,
73 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
74 p_return_status OUT NOCOPY VARCHAR2,
75 p_msg_count OUT NOCOPY NUMBER,
76 p_msg_data OUT NOCOPY VARCHAR2,
77 p_worksheet_id IN NUMBER,
78 p_global_worksheet IN VARCHAR2 := FND_API.G_TRUE
79 );
80
81 /* ----------------------------------------------------------------------- */
82
83 -- API name : Create_Worksheet
84 -- Type : Private <Interface>
85 -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WORKSHEET
86 -- Parameters :
87 -- IN : p_api_version IN NUMBER Required
88 -- p_init_msg_list IN VARCHAR2 Optional
89 -- Default = FND_API.G_FALSE
90 -- p_commit IN VARCHAR2 Optional
91 -- Default = FND_API.G_FALSE
92 -- p_validation_level IN NUMBER Optional
93 -- Default = FND_API.G_VALID_LEVEL_NONE
94 -- p_budget_group_id IN NUMBER Required
95 -- p_budget_calendar_id IN NUMBER Required
96 -- p_worksheet_type IN VARCHAR2 Optional
97 -- Default = 'O'
98 -- p_name IN VARCHAR2 Required
99 -- p_description IN VARCHAR2 Required
100 -- p_ws_creation_complete IN VARCHAR2 Optional
101 -- Default = FND_API.G_MISS_CHAR
102 -- p_stage_set_id IN NUMBER Required
103 -- p_current_stage_seq IN NUMBER Optional
104 -- Default = FND_API.G_MISS_NUM
105 -- p_global_worksheet_id IN NUMBER Optional
106 -- Default = FND_API.G_MISS_NUM
107 -- p_global_worksheet_flag IN NUMBER Optional
108 -- Default = FND_API.G_MISS_CHAR
109 -- p_global_worksheet_option IN VARCHAR2 Optional
110 -- Default = FND_API.G_MISS_CHAR
111 -- p_local_copy_flag IN VARCHAR2 Optional
112 -- Default = FND_API.G_MISS_CHAR
113 -- p_copy_of_worksheet_id IN NUMBER Optional
114 -- Default = FND_API.G_MISS_NUM
115 -- p_freeze_flag IN VARCHAR2 Optional
116 -- Default = FND_API.G_MISS_CHAR
117 -- p_budget_by_position IN VARCHAR2 Optional
118 -- Default = FND_API.G_MISS_CHAR
119 -- p_use_revised_element_rates IN VARCHAR2 Optional
120 -- Default = FND_API.G_MISS_CHAR
121 -- p_num_proposed_years IN NUMBER Optional
122 -- Default = FND_API.G_MISS_NUM
123 -- p_num_years_to_allocate IN NUMBER Optional
124 -- Default = FND_API.G_MISS_NUM
125 -- p_rounding_factor IN NUMBER Optional
126 -- Default = FND_API.G_MISS_NUM
127 -- p_gl_cutoff_period IN DATE Optional
128 -- Default = FND_API.G_MISS_DATE
129 -- p_budget_version_id IN NUMBER Optional
130 -- Default = FND_API.G_MISS_NUM
131 -- p_gl_budget_set_id IN NUMBER Optional
132 -- Default = FND_API.G_MISS_NUM
133 -- p_include_stat_balance IN VARCHAR2 Optional
134 -- Default = FND_API.G_MISS_CHAR
135 -- p_include_trans_balance IN VARCHAR2 Optional
136 -- Default = FND_API.G_MISS_CHAR
137 -- p_include_adj_period IN VARCHAR2 Required
138 -- Default = FND_API.G_MISS_CHAR
139 -- p_date_submitted IN DATE Optional
140 -- Default = FND_API.G_MISS_DATE
141 -- p_submitted_by IN NUMBER Required
142 -- Default = FND_API.G_MISS_NUM
143 -- p_data_extract_id IN NUMBER Optional
144 -- Default = FND_API.G_MISS_NUM
145 -- p_parameter_set_id IN NUMBER Optional
146 -- Default = FND_API.G_MISS_NUM
147 -- p_constraint_set_id IN NUMBER Optional
148 -- Default = FND_API.G_MISS_NUM
149 -- p_allocrule_set_id IN NUMBER Optional
150 -- Default = FND_API.G_MISS_NUM
151 -- p_attribute1 IN VARCHAR2 Optional
152 -- Default = FND_API.G_MISS_CHAR
153 -- p_attribute2 IN VARCHAR2 Optional
154 -- Default = FND_API.G_MISS_CHAR
155 -- p_attribute3 IN VARCHAR2 Optional
156 -- Default = FND_API.G_MISS_CHAR
157 -- p_attribute4 IN VARCHAR2 Optional
158 -- Default = FND_API.G_MISS_CHAR
159 -- p_attribute5 IN VARCHAR2 Optional
160 -- Default = FND_API.G_MISS_CHAR
161 -- p_attribute6 IN VARCHAR2 Optional
162 -- Default = FND_API.G_MISS_CHAR
163 -- p_attribute7 IN VARCHAR2 Optional
164 -- Default = FND_API.G_MISS_CHAR
165 -- p_attribute8 IN VARCHAR2 Optional
166 -- Default = FND_API.G_MISS_CHAR
167 -- p_attribute9 IN VARCHAR2 Optional
168 -- Default = FND_API.G_MISS_CHAR
169 -- p_attribute10 IN VARCHAR2 Optional
170 -- Default = FND_API.G_MISS_CHAR
171 -- p_context IN VARCHAR2 Optional
172 -- Default = FND_API.G_MISS_CHAR
173 -- .
174 -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
175 -- p_msg_count OUT NOCOPY NUMBER
176 -- p_msg_data OUT NOCOPY VARCHAR2(2000)
177 -- p_worksheet_id OUT NOCOPY NUMBER
178 -- .
179 -- Notes : Create the Worksheet Header in PSB_WORKSHEETS
180 --
181
182 PROCEDURE Create_Worksheet
183 ( p_api_version IN NUMBER,
184 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
185 p_commit IN VARCHAR2 := FND_API.G_FALSE,
186 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
187 p_return_status OUT NOCOPY VARCHAR2,
188 p_msg_count OUT NOCOPY NUMBER,
189 p_msg_data OUT NOCOPY VARCHAR2,
190 p_budget_group_id IN NUMBER,
191 p_budget_calendar_id IN NUMBER,
192 p_worksheet_type IN VARCHAR2 := 'O',
193 p_name IN VARCHAR2,
194 p_description IN VARCHAR2,
195 p_ws_creation_complete IN VARCHAR2 := FND_API.G_MISS_CHAR,
196 p_stage_set_id IN NUMBER,
197 p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
198 p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
199 p_global_worksheet_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
200 p_global_worksheet_option IN VARCHAR2 := FND_API.G_MISS_CHAR,
201 p_local_copy_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
202 p_copy_of_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
203 p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
204 p_budget_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR,
205 p_use_revised_element_rates IN VARCHAR2 := FND_API.G_MISS_CHAR,
206 p_num_proposed_years IN NUMBER := FND_API.G_MISS_NUM,
207 p_num_years_to_allocate IN NUMBER := FND_API.G_MISS_NUM,
208 p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
209 p_gl_cutoff_period IN DATE := FND_API.G_MISS_DATE,
210 p_budget_version_id IN NUMBER := FND_API.G_MISS_NUM,
211 p_gl_budget_set_id IN NUMBER := FND_API.G_MISS_NUM,
212 p_include_stat_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
213 p_include_trans_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
214 p_include_adj_period IN VARCHAR2 := FND_API.G_MISS_CHAR,
215 p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
216 p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM,
217 p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
218 p_allocrule_set_id IN NUMBER := FND_API.G_MISS_NUM,
219 p_date_submitted IN DATE := FND_API.G_MISS_DATE,
220 p_submitted_by IN NUMBER := FND_API.G_MISS_NUM,
221 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
222 p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
223 p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
227 p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
224 p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
225 p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
226 p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
228 p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
229 p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
230 p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
231 p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
232 p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,
233 p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
234 p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
235 p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,
236 p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,
237 p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,
238 p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
239 p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
240 p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
241 p_include_gl_other_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
242 p_include_cbc_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
243 p_include_cbc_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
244 p_include_cbc_budget_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
245 /* For Bug 3157960, Added the federal_Ws_flag */
246 p_federal_ws_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
247 /* bug no 4725091 */
248 p_include_gl_forwd_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
249 p_worksheet_id OUT NOCOPY NUMBER
250 );
251
252 /* ----------------------------------------------------------------------- */
253
254 -- API name : Update_Worksheet
255 -- Type : Private <Interface>
256 -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WORKSHEET
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_worksheet_type IN VARCHAR2 Optional
267 -- Default = FND_API.G_MISS_CHAR
268 -- p_description IN VARCHAR2 Optional
269 -- Default = FND_API.G_MISS_CHAR
270 -- p_ws_creation_complete IN VARCHAR2 Optional
271 -- Default = FND_API.G_MISS_CHAR
272 -- p_global_worksheet_id IN NUMBER Optional
273 -- Default = FND_API.G_MISS_NUM
274 -- p_current_stage_seq IN NUMBER Optional
275 -- Default = FND_API.G_MISS_NUM
276 -- p_local_copy_flag IN VARCHAR2 Optional
277 -- Default = FND_API.G_MISS_CHAR
278 -- p_copy_of_worksheet_id IN NUMBER Optional
279 -- Default = FND_API.G_MISS_NUM
280 -- p_freeze_flag IN VARCHAR2 Optional
281 -- Default = FND_API.G_MISS_CHAR
282 -- p_use_revised_element_rates IN VARCHAR2 Optional
283 -- Default = FND_API.G_MISS_CHAR
284 -- p_date_submitted IN DATE Optional
285 -- Default = FND_API.G_MISS_DATE
286 -- p_submitted_by IN NUMBER Required
287 -- Default = FND_API.G_MISS_NUM
288 -- p_attribute1 IN VARCHAR2 Optional
289 -- Default = FND_API.G_MISS_CHAR
290 -- p_attribute2 IN VARCHAR2 Optional
291 -- Default = FND_API.G_MISS_CHAR
292 -- p_attribute3 IN VARCHAR2 Optional
293 -- Default = FND_API.G_MISS_CHAR
294 -- p_attribute4 IN VARCHAR2 Optional
295 -- Default = FND_API.G_MISS_CHAR
296 -- p_attribute5 IN VARCHAR2 Optional
297 -- Default = FND_API.G_MISS_CHAR
298 -- p_attribute6 IN VARCHAR2 Optional
299 -- Default = FND_API.G_MISS_CHAR
300 -- p_attribute7 IN VARCHAR2 Optional
301 -- Default = FND_API.G_MISS_CHAR
302 -- p_attribute8 IN VARCHAR2 Optional
303 -- Default = FND_API.G_MISS_CHAR
304 -- p_attribute9 IN VARCHAR2 Optional
305 -- Default = FND_API.G_MISS_CHAR
306 -- p_attribute10 IN VARCHAR2 Optional
310 /* For Bug No. 2312657 : Start */
307 -- Default = FND_API.G_MISS_CHAR
308 -- p_context IN VARCHAR2 Optional
309 -- Default = FND_API.G_MISS_CHAR
311 -- p_gl_cutoff_period IN DATE Optional
312 -- Default = NULL
313 -- p_gl_budget_set_id IN NUMBER Optional
314 -- Default = NULL
315 /* For Bug No. 2312657 : End */
316 -- .
317 -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
318 -- p_msg_count OUT NOCOPY NUMBER
319 -- p_msg_data OUT NOCOPY VARCHAR2(2000)
320 -- .
321 -- Version : Current version 1.0
322 -- Initial version 1.0
323
324 -- Created 06/15/1997 by Supriyo Ghosh
325 -- Changed 06/15/1997 by Supriyo Ghosh
326 -- Added 2 Parameters : p_ws_creation_complete,
327 -- p_budget_version_id
328 --
329 -- Notes : Update Worksheet Header
330 --
331
332 PROCEDURE Update_Worksheet
333 ( p_api_version IN NUMBER,
334 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
335 p_commit IN VARCHAR2 := FND_API.G_FALSE,
336 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
337 p_return_status OUT NOCOPY VARCHAR2,
338 p_msg_count OUT NOCOPY NUMBER,
339 p_msg_data OUT NOCOPY VARCHAR2,
340 p_worksheet_id IN NUMBER,
341 p_worksheet_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
342 p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
343 p_ws_creation_complete IN VARCHAR2 := FND_API.G_MISS_CHAR,
344 p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
345 p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
346 p_local_copy_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
347 p_copy_of_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
348 p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
349 p_use_revised_element_rates IN VARCHAR2 := FND_API.G_MISS_CHAR,
350 /* Bug # 3083970 */
351 p_num_proposed_years IN NUMBER := FND_API.G_MISS_NUM,
352 p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
353 /* End bug # 3083970 */
354 p_date_submitted IN DATE := FND_API.G_MISS_DATE,
355 p_submitted_by IN NUMBER := FND_API.G_MISS_NUM,
356 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
357 p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
358 p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
359 p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
360 p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
361 p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
362 p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
363 p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
364 p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
365 p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
366 p_context IN VARCHAR2 := FND_API.G_MISS_CHAR,
367 p_create_non_pos_line_items IN VARCHAR2 := FND_API.G_MISS_CHAR,
368 p_apply_element_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
369 p_apply_position_parameters IN VARCHAR2 := FND_API.G_MISS_CHAR,
370 p_create_positions IN VARCHAR2 := FND_API.G_MISS_CHAR,
371 p_create_summary_totals IN VARCHAR2 := FND_API.G_MISS_CHAR,
372 p_apply_constraints IN VARCHAR2 := FND_API.G_MISS_CHAR,
373 p_include_gl_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
374 p_include_gl_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
375 p_include_gl_other_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
376 p_include_cbc_commit_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
377 p_include_cbc_oblig_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
378 p_include_cbc_budget_balance IN VARCHAR2 := FND_API.G_MISS_CHAR,
379 /* For Bug No. 2312657 : Start */
380 p_gl_cutoff_period IN DATE := NULL,
381 p_gl_budget_set_id IN NUMBER := NULL,
382 /* For Bug No. 2312657 : End */
383 /* For Bug No. 3157960, added the federal_ws_flag */
384 p_federal_ws_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
385 /* bug no 4725091 */
386 p_include_gl_forwd_balance IN VARCHAR2 := FND_API.G_MISS_CHAR
387
388 );
389
390 /* ----------------------------------------------------------------------- */
391
392 -- API name : Delete_Worksheet
393 -- Type : Private <Interface>
394 -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WORKSHEET
395 -- Parameters :
396 -- IN : p_api_version IN NUMBER Required
397 -- p_init_msg_list IN VARCHAR2 Optional
398 -- Default = FND_API.G_FALSE
399 -- p_commit IN VARCHAR2 Optional
403 -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
400 -- Default = FND_API.G_FALSE
401 -- p_worksheet_id IN NUMBER Required
402 -- .
404 -- p_msg_count OUT NOCOPY NUMBER
405 -- p_msg_data OUT NOCOPY VARCHAR2(2000)
406 -- .
407 -- Version : Current version 1.0
408 -- Initial version 1.0
409 -- Created 07/07/1997 by Supriyo Ghosh
410 --
411 -- Notes : Delete Worksheet Header
412 --
413
414 PROCEDURE Delete_Worksheet
415 ( p_api_version IN NUMBER,
416 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
417 p_commit IN VARCHAR2 := FND_API.G_FALSE,
418 p_return_status OUT NOCOPY VARCHAR2,
419 p_msg_count OUT NOCOPY NUMBER,
420 p_msg_data OUT NOCOPY VARCHAR2,
421 p_worksheet_id IN NUMBER
422 );
423
424 /* ----------------------------------------------------------------------- */
425
426 -- API name : Apply_Constraints
427 -- Type : Public
428 -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WORKSHEET
429 -- Parameters :
430 -- IN : p_api_version IN NUMBER Required
431 -- p_init_msg_list IN VARCHAR2 Optional
432 -- Default = FND_API.G_FALSE
433 -- p_commit IN VARCHAR2 Optional
434 -- Default = FND_API.G_FALSE
435 -- p_validation_level IN NUMBER Optional
436 -- Default = FND_API.G_VALID_LEVEL_NONE
437 -- p_worksheet_id IN NUMBER Required
438 -- p_budget_group_id IN NUMBER Optional
439 -- Default = FND_API.G_MISS_NUM
440 -- p_flex_code IN NUMBER Optional
441 -- Default = FND_API.G_MISS_NUM
442 -- p_func_currency IN VARCHAR2 Optional
443 -- Default = FND_API.G_MISS_CHAR
444 -- p_global_worksheet_id IN NUMBER Optional
445 -- Default = FND_API.G_MISS_NUM
446 -- p_constraint_set_id IN NUMBER Optional
447 -- Default = FND_API.G_MISS_NUM
448 -- p_constraint_set_name IN VARCHAR2 Optional
449 -- Default = FND_API.G_MISS_CHAR
450 -- p_constraint_set_threshold IN NUMBER Optional
451 -- Default = FND_API.G_MISS_NUM
452 -- p_budget_calendar_id IN NUMBER Optional
453 -- Default = FND_API.G_MISS_NUM
454 -- p_data_extract_id IN NUMBER Optional
455 -- Default = FND_API.G_MISS_NUM
456 -- p_business_group_id IN NUMBER Optional
457 -- Default = FND_API.G_MISS_NUM
458 -- p_budget_by_position IN VARCHAR2 Optional
459 -- Default = FND_API.G_MISS_CHAR
460 -- .
461 -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
462 -- p_msg_count OUT NOCOPY NUMBER
463 -- p_msg_data OUT NOCOPY VARCHAR2(2000)
464 -- p_validation_status OUT NOCOPY VARCHAR2(1)
465 -- .
466 -- Version : Current version 1.0
467 -- Initial version 1.0
468 -- Created 01/06/1998 by Supriyo Ghosh
469 --
470 -- Notes : Apply Constraints and log all Constraint
471 -- Validation Errors
472
473 PROCEDURE Apply_Constraints
474 ( p_api_version IN NUMBER,
475 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
476 p_commit IN VARCHAR2 := FND_API.G_FALSE,
477 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
478 p_return_status OUT NOCOPY VARCHAR2,
479 p_msg_count OUT NOCOPY NUMBER,
480 p_msg_data OUT NOCOPY VARCHAR2,
481 p_validation_status OUT NOCOPY VARCHAR2,
482 p_worksheet_id IN NUMBER,
483 p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
484 p_flex_code IN NUMBER := FND_API.G_MISS_NUM,
485 p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
486 p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
487 p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
488 p_constraint_set_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
489 p_constraint_set_threshold IN NUMBER := FND_API.G_MISS_NUM,
490 p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
491 p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
492 p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
493 p_budget_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR
494 );
495
496 /* ----------------------------------------------------------------------- */
497
498 -- API name : Validate_Entity_Set
499 -- Type : Public
500 -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WORKSHEET
504 -- Default = FND_API.G_FALSE
501 -- Parameters :
502 -- IN : p_api_version IN NUMBER Required
503 -- p_init_msg_list IN VARCHAR2 Optional
505 -- p_validation_level IN NUMBER Optional
506 -- Default = FND_API.G_VALID_LEVEL_NONE
507 -- p_data_extract_id IN NUMBER Required
508 -- p_parameter_set_id IN NUMBER Required
509 -- p_constraint_set_id IN NUMBER Required
510 -- .
511 -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
512 -- p_msg_count OUT NOCOPY NUMBER
513 -- p_msg_data OUT NOCOPY VARCHAR2(2000)
514 -- .
515 -- Version : Current version 1.0
516 -- Initial version 1.0
517 -- Created 05/01/1998 by Supriyo Ghosh
518 --
519 -- Notes : Validate Entity Sets for a Data Extract
520
521 PROCEDURE Validate_Entity_Set
522 ( p_api_version IN NUMBER,
523 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
524 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
525 p_return_status OUT NOCOPY VARCHAR2,
526 p_msg_count OUT NOCOPY NUMBER,
527 p_msg_data OUT NOCOPY VARCHAR2,
528 p_data_extract_id IN NUMBER,
529 p_parameter_set_id IN NUMBER,
530 p_constraint_set_id IN NUMBER
531 );
532
533 /* ----------------------------------------------------------------------- */
534
535 -- API name : Delete_WPL
536 -- Type : Private <Implementation>
537 -- Pre-reqs : FND_API, FND_MESSAGE
538 -- .
539 -- Parameters :
540 -- IN : p_api_version IN NUMBER Required
541 -- p_init_msg_list IN VARCHAR2 Optional
542 -- Default = FND_API.G_FALSE
543 -- p_validation_level IN NUMBER Optional
544 -- Default = FND_API.G_VALID_LEVEL_NONE
545 -- p_worksheet_id IN NUMBER Required
546 -- p_position_line_id IN NUMBER Required
547 -- .
548 -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
549 -- p_msg_count OUT NOCOPY NUMBER
550 -- p_msg_data OUT NOCOPY VARCHAR2(2000)
551 -- .
552 -- Version : Current version 1.0
553 -- Initial version 1.0
554 -- Created 10/10/1999 by Supriyo Ghosh
555 --
556 -- Notes : Delete Worksheet Position Line.
557 --
558
559 PROCEDURE Delete_WPL
560 ( p_api_version IN NUMBER,
561 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
562 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
563 p_return_status OUT NOCOPY VARCHAR2,
564 p_msg_count OUT NOCOPY NUMBER,
565 p_msg_data OUT NOCOPY VARCHAR2,
566 p_worksheet_id IN NUMBER,
567 p_position_line_id IN NUMBER
568 );
569
570 /* ----------------------------------------------------------------------- */
571
572 PROCEDURE Create_Worksheet_Line_Items_CP
573 (
574 errbuf OUT NOCOPY VARCHAR2,
575 retcode OUT NOCOPY VARCHAR2,
576 p_worksheet_id IN NUMBER
577 );
578
579 PROCEDURE Validate_Accounts_CP
580 (
581 errbuf OUT NOCOPY VARCHAR2 ,
582 retcode OUT NOCOPY VARCHAR2 ,
583 p_worksheet_id IN NUMBER
584 );
585
586 PROCEDURE Pre_Create_WS_Lines_CP
587 (
588 errbuf OUT NOCOPY VARCHAR2 ,
589 retcode OUT NOCOPY VARCHAR2 ,
590 p_worksheet_id IN NUMBER
591 );
592
593 PROCEDURE Create_Acct_Line_Items_CP
594 (
595 errbuf OUT NOCOPY VARCHAR2 ,
596 retcode OUT NOCOPY VARCHAR2 ,
597 p_create_non_pos_line_items IN VARCHAR2 ,
598 p_worksheet_id IN NUMBER
599 );
600
601 PROCEDURE Create_Pos_Line_Items_CP
602 (
603 errbuf OUT NOCOPY VARCHAR2 ,
604 retcode OUT NOCOPY VARCHAR2 ,
605 p_create_positions IN VARCHAR2 ,
606 p_worksheet_id IN NUMBER
607 );
608
609 PROCEDURE Apply_Acct_Constraints_CP
610 (
611 errbuf OUT NOCOPY VARCHAR2 ,
612 retcode OUT NOCOPY VARCHAR2 ,
613 p_apply_constraints IN VARCHAR2 ,
614 p_worksheet_id IN NUMBER
615 );
616
617 PROCEDURE Apply_Pos_Constraints_CP
618 (
619 errbuf OUT NOCOPY VARCHAR2 ,
620 retcode OUT NOCOPY VARCHAR2 ,
621 p_apply_constraints IN VARCHAR2 ,
622 p_worksheet_id IN NUMBER
623 );
624
625 PROCEDURE Apply_Elem_Constraints_CP
626 (
627 errbuf OUT NOCOPY VARCHAR2 ,
628 retcode OUT NOCOPY VARCHAR2 ,
629 p_apply_constraints IN VARCHAR2 ,
630 p_worksheet_id IN NUMBER
631 );
632
633 PROCEDURE Post_Create_WS_Lines_CP
634 (
635 errbuf OUT NOCOPY VARCHAR2 ,
636 retcode OUT NOCOPY VARCHAR2 ,
637 p_worksheet_id IN NUMBER
638 );
639
640 /* ----------------------------------------------------------------------- */
641
642 END PSB_WORKSHEET_PVT;