[Home] [Help]
PACKAGE: APPS.PSB_BUDGET_REVISIONS_PVT
Source
1 PACKAGE PSB_BUDGET_REVISIONS_PVT AS
2 /* $Header: PSBVBRVS.pls 120.9 2006/04/07 11:19:01 shtripat ship $ */
3
4 g_root_budget_group_id NUMBER;
5 g_set_of_books_id NUMBER;
6 g_set_of_books_name VARCHAR2(30);
7 g_business_group_id NUMBER;
8 g_flex_code NUMBER;
9 g_flex_delimiter VARCHAR2(1);
10 g_func_currency VARCHAR2(15);
11 g_currency_code VARCHAR2(15);
12 g_budgetary_control VARCHAR2(1);
13 g_gl_journal_source VARCHAR2(25) ;
14 g_gl_journal_category VARCHAR2(25) ;
15 g_gl_budget_set_id NUMBER;
16 g_create_zero_bal VARCHAR2(1);
17
18 g_budget_group_name VARCHAR2(80);
19
20 g_budget_group_id NUMBER;
21 g_from_gl_period_name VARCHAR2(15);
22 g_to_gl_period_name VARCHAR2(15);
23 g_from_date DATE; -- Start date of the from gl period
24 g_to_date DATE; -- End date of the to gl period
25 g_effective_start_date DATE;
26 g_effective_end_date DATE;
27 g_budget_revision_type VARCHAR2(1);
28 g_permanent_revision VARCHAR2(1);
29 g_revise_by_position VARCHAR2(1);
30 g_balance_type VARCHAR2(4);
31 g_transaction_type VARCHAR2(4);
32 g_freeze_flag VARCHAR2(1);
33
34 g_global_revision VARCHAR2(1);
35 g_global_budget_revision_id NUMBER;
36 g_data_extract_id NUMBER;
37 g_position_exists BOOLEAN := FALSE;
38 g_position_mass_revision BOOLEAN := FALSE;
39 g_hr_budget_id NUMBER;
40
41 g_parameter_set_id NUMBER;
42 g_constraint_set_id NUMBER;
43 g_constraint_set_name VARCHAR2(30);
44 /* ForBug No : 1321519 Start */
45 g_constraint_start_date DATE;
46 g_constraint_end_date DATE;
47 /* ForBug No : 1321519 End */
48 g_constraint_threshold NUMBER;
49 g_base_line_revision VARCHAR2(1);
50 g_approval_orig_system VARCHAR2(30);
51 g_approval_override_by NUMBER;
52
53 -- Bug#4571412
54 -- Introduced global variable to handle the CP
55 -- completion status conditionally.
56 g_soft_error_flag VARCHAR2(1) := 'N';
57
58 PROCEDURE Delete_Row
59 ( p_api_version IN NUMBER,
60 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
61 p_commit IN VARCHAR2 := FND_API.G_FALSE,
62 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
63 p_return_status OUT NOCOPY VARCHAR2,
64 p_msg_count OUT NOCOPY NUMBER,
65 p_msg_data OUT NOCOPY VARCHAR2,
66 p_budget_revision_id IN NUMBER);
67
68 PROCEDURE Update_Baseline_Values
69 ( p_api_version IN NUMBER,
70 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
71 p_commit IN VARCHAR2 := FND_API.G_FALSE,
72 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
73 p_return_status OUT NOCOPY VARCHAR2,
74 p_msg_count OUT NOCOPY NUMBER,
75 p_msg_data OUT NOCOPY VARCHAR2,
76 p_budget_revision_id IN NUMBER);
77
78 PROCEDURE Create_Budget_Revision
79 ( p_api_version IN NUMBER,
80 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
81 p_commit IN VARCHAR2 := FND_API.G_FALSE,
82 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
83 p_return_status OUT NOCOPY VARCHAR2,
84 p_msg_count OUT NOCOPY NUMBER,
85 p_msg_data OUT NOCOPY VARCHAR2,
86 p_budget_revision_id IN OUT NOCOPY NUMBER,
87 p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
88 p_gl_budget_set_id IN NUMBER := FND_API.G_MISS_NUM,
89 p_hr_budget_id IN NUMBER := FND_API.G_MISS_NUM,
90 p_justification IN VARCHAR2 := FND_API.G_MISS_CHAR,
91 p_from_gl_period_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
92 p_to_gl_period_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
93 p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
94 p_effective_start_date IN DATE := FND_API.G_MISS_DATE,
95 p_effective_end_date IN DATE := FND_API.G_MISS_DATE,
96 p_budget_revision_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
97 p_transaction_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
98 p_permanent_revision IN VARCHAR2 := FND_API.G_MISS_CHAR,
99 p_revise_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR,
100 p_balance_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
101 p_global_budget_revision IN VARCHAR2 := FND_API.G_MISS_CHAR,
102 p_global_budget_revision_id IN NUMBER := FND_API.G_MISS_NUM,
103 p_requestor IN NUMBER := FND_API.G_MISS_NUM,
104 p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM,
105 p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
106 p_submission_date IN DATE := FND_API.G_MISS_DATE,
107 p_submission_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
108 p_approval_orig_system IN VARCHAR2 := FND_API.G_MISS_CHAR,
109 p_approval_override_by IN NUMBER := FND_API.G_MISS_NUM,
110 p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
111 p_request_id IN NUMBER := FND_API.G_MISS_NUM,
112 p_base_line_revision IN VARCHAR2 := FND_API.G_MISS_CHAR,
113 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114 p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115 p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116 p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117 p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118 p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119 p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120 p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121 p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122 p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123 p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124 p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125 p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126 p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127 p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128 p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
129 p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
130 p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
131 p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132 p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133 p_attribute21 IN VARCHAR2 := FND_API.G_MISS_CHAR,
134 p_attribute22 IN VARCHAR2 := FND_API.G_MISS_CHAR,
135 p_attribute23 IN VARCHAR2 := FND_API.G_MISS_CHAR,
136 p_attribute24 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137 p_attribute25 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138 p_attribute26 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139 p_attribute27 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140 p_attribute28 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141 p_attribute29 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142 p_attribute30 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143 p_context IN VARCHAR2 := FND_API.G_MISS_CHAR);
144
145 PROCEDURE Cache_Revision_Variables
146 (p_return_status OUT NOCOPY VARCHAR2,
147 p_budget_revision_id IN NUMBER);
148
149 PROCEDURE Create_Mass_Revision_Entries
150 ( p_api_version IN NUMBER,
151 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
152 p_commit IN VARCHAR2 := FND_API.G_FALSE,
153 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
154 p_return_status OUT NOCOPY VARCHAR2,
155 p_msg_count OUT NOCOPY NUMBER,
156 p_msg_data OUT NOCOPY VARCHAR2,
157 p_data_extract_id IN NUMBER,
158 p_budget_revision_id IN NUMBER,
159 p_parameter_id IN NUMBER := FND_API.G_MISS_NUM);
160
161 PROCEDURE Create_Revision_Accounts
162 ( p_api_version IN NUMBER,
163 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
164 p_commit IN VARCHAR2 := FND_API.G_FALSE,
165 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
166 p_return_status OUT NOCOPY VARCHAR2,
167 p_msg_count OUT NOCOPY NUMBER,
168 p_msg_data OUT NOCOPY VARCHAR2,
169 p_budget_revision_id IN NUMBER := FND_API.G_MISS_NUM,
170 p_budget_revision_acct_line_id IN OUT NOCOPY NUMBER,
171 p_code_combination_id IN NUMBER,
172 p_budget_group_id IN NUMBER,
173 p_position_id IN NUMBER := FND_API.G_MISS_NUM,
174 p_gl_period_name IN VARCHAR2,
175 p_gl_budget_version_id IN NUMBER := FND_API.G_MISS_NUM,
176 p_currency_code IN VARCHAR2,
177 p_budget_balance IN NUMBER,
178 p_revision_type IN VARCHAR2,
179 p_revision_value_type IN VARCHAR2,
180 p_revision_amount IN NUMBER,
181 p_funds_status_code IN VARCHAR2,
182 p_funds_result_code IN VARCHAR2,
183 p_funds_control_timestamp IN DATE,
184 p_note_id IN NUMBER,
185 p_freeze_flag IN VARCHAR2,
186 p_view_line_flag IN VARCHAR2,
187 p_functional_transaction IN VARCHAR2 := NULL);
188
189 PROCEDURE Create_Revision_Positions
190 ( p_api_version IN NUMBER,
191 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
192 p_commit IN VARCHAR2 := FND_API.G_FALSE,
193 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
194 p_return_status OUT NOCOPY VARCHAR2,
195 p_msg_count OUT NOCOPY NUMBER,
196 p_msg_data OUT NOCOPY VARCHAR2,
197 p_budget_revision_id IN NUMBER ,
198 p_budget_revision_pos_line_id IN OUT NOCOPY NUMBER,
199 p_position_id IN NUMBER,
200 p_budget_group_id IN NUMBER,
201 p_effective_start_date IN DATE,
202 p_effective_end_date IN DATE,
203 p_revision_type IN VARCHAR2,
204 p_revision_value_type IN VARCHAR2,
205 p_revision_value IN NUMBER,
206 p_note_id IN NUMBER,
207 p_freeze_flag IN VARCHAR2,
208 p_view_line_flag IN VARCHAR2);
209
210 PROCEDURE Budget_Revision_Funds_Check
211 ( p_api_version IN NUMBER,
212 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
213 p_commit IN VARCHAR2 := FND_API.G_FALSE,
214 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
215 p_return_status OUT NOCOPY VARCHAR2,
216 p_msg_count OUT NOCOPY NUMBER,
217 p_msg_data OUT NOCOPY VARCHAR2,
218 p_budget_revision_id IN NUMBER,
219 p_funds_reserve_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
220 p_fund_check_failures OUT NOCOPY NUMBER, -- bug#4341619
221 --Bug#4310411
222 p_called_from IN VARCHAR2 := 'PSBBGRVS');
223
224 PROCEDURE Apply_Revision_Acct_Parameters
225 ( p_api_version IN NUMBER,
226 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
227 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
228 p_return_status OUT NOCOPY VARCHAR2,
229 p_parameter_id IN NUMBER,
230 p_parameter_name IN VARCHAR2,
231 p_compound_annually IN VARCHAR2,
232 p_compound_factor IN NUMBER,
233 p_original_budget IN NUMBER,
234 p_current_budget IN NUMBER,
235 p_revision_amount OUT NOCOPY NUMBER);
236
237 Function Find_System_Data_Extract
238 ( p_budget_group_id IN NUMBER) RETURN NUMBER;
239
240 -- Bug 3029168 added p_currency_code
241 Function Find_Original_Budget_Balance
242 (p_code_combination_id IN NUMBER,
243 p_budget_group_id IN NUMBER,
244 p_gl_period IN VARCHAR2,
245 p_gl_budget_version_id IN NUMBER,
246 p_set_of_books_id IN NUMBER := FND_API.G_MISS_NUM,
247 p_end_gl_period IN VARCHAR2 := FND_API.G_MISS_CHAR,
248 p_currency_code IN VARCHAR2 DEFAULT NULL) RETURN NUMBER;
249
250 PROCEDURE Find_FTE
251 ( p_api_version IN NUMBER,
252 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
253 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
254 p_return_status OUT NOCOPY VARCHAR2,
255 p_msg_count OUT NOCOPY NUMBER,
256 p_msg_data OUT NOCOPY VARCHAR2,
257 p_position_id IN NUMBER,
258 p_hr_budget_id IN NUMBER,
259 p_budget_revision_id IN NUMBER,
260 p_revision_type IN VARCHAR2,
261 p_revision_value_type IN VARCHAR2,
262 p_revision_value IN NUMBER,
263 p_effective_start_date IN DATE,
264 p_effective_end_date IN DATE,
265 p_original_fte OUT NOCOPY NUMBER,
266 p_current_fte OUT NOCOPY NUMBER,
270 ( p_api_version IN NUMBER,
267 p_revised_fte OUT NOCOPY NUMBER);
268
269 PROCEDURE Calculate_Position_Cost
271 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
272 p_commit IN VARCHAR2 := FND_API.G_FALSE,
273 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
274 p_msg_count OUT NOCOPY NUMBER,
275 p_msg_data OUT NOCOPY VARCHAR2,
276 p_return_status OUT NOCOPY VARCHAR2,
277 p_mass_revision IN BOOLEAN := FALSE,
278 p_budget_revision_id IN NUMBER,
279 p_position_id IN NUMBER,
280 p_revision_start_date IN DATE,
281 p_revision_end_date IN DATE,
282 p_parameter_id IN NUMBER DEFAULT NULL -- Bug#4675858
283 ) ;
284
285 -- Bug 3029168 added p_event_type
286 PROCEDURE CREATE_BASE_BUDGET_REVISION
287 ( p_api_version IN NUMBER,
288 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
289 p_commit IN VARCHAR2 := FND_API.G_FALSE,
290 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
291 p_return_status OUT NOCOPY VARCHAR2,
292 p_msg_count OUT NOCOPY NUMBER,
293 p_msg_data OUT NOCOPY VARCHAR2,
294 p_worksheet_id IN NUMBER,
295 p_event_type IN VARCHAR2 DEFAULT 'BP');
296
297 PROCEDURE Apply_Constraints
298 ( p_api_version IN NUMBER,
299 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
300 p_return_status OUT NOCOPY VARCHAR2,
301 p_validation_status OUT NOCOPY VARCHAR2,
302 p_budget_revision_id IN NUMBER,
303 p_constraint_set_id IN NUMBER);
304
305 PROCEDURE Delete_Revision_Accounts
306 ( p_api_version IN NUMBER,
307 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
308 p_commit IN VARCHAR2 := FND_API.G_FALSE,
309 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
310 p_return_status OUT NOCOPY VARCHAR2,
311 p_msg_count OUT NOCOPY NUMBER,
312 p_msg_data OUT NOCOPY VARCHAR2,
313 p_budget_revision_id IN NUMBER,
314 p_budget_revision_acct_line_id IN NUMBER);
315
316 PROCEDURE Delete_Revision_Positions
317 ( p_api_version IN NUMBER,
318 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
319 p_commit IN VARCHAR2 := FND_API.G_FALSE,
320 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
321 p_return_status OUT NOCOPY VARCHAR2,
322 p_msg_count OUT NOCOPY NUMBER,
323 p_msg_data OUT NOCOPY VARCHAR2,
324 p_budget_revision_id IN NUMBER,
325 p_budget_revision_pos_line_id IN NUMBER);
326
327 Function Get_GL_Balance
328 (p_revision_type IN VARCHAR2,
329 p_balance_type IN VARCHAR2,
330 p_set_of_books_id IN NUMBER,
331 p_xbc_enabled_flag IN VARCHAR2,
332 p_gl_period_name IN VARCHAR2,
333 p_gl_budget_version_id IN NUMBER,
334 p_currency_code IN VARCHAR2,
335 p_code_combination_id IN NUMBER) RETURN NUMBER;
336
337 FUNCTION Get_Rounded_Amount
338 ( p_currency_code IN VARCHAR2,
339 p_amount IN NUMBER
340 ) RETURN NUMBER;
341
342 PROCEDURE Mass_Budget_Revision_CP
343 ( errbuf OUT NOCOPY VARCHAR2,
344 retcode OUT NOCOPY VARCHAR2,
345 p_budget_revision_id IN NUMBER);
346
347 PROCEDURE Revision_Funds_Check_CP
348 ( errbuf OUT NOCOPY VARCHAR2,
349 retcode OUT NOCOPY VARCHAR2,
350 p_budget_revision_id IN NUMBER);
351
352 PROCEDURE Revise_Projections_CP
353 ( errbuf OUT NOCOPY VARCHAR2,
354 retcode OUT NOCOPY VARCHAR2,
355 p_budget_revision_id IN NUMBER,
356 p_parameter_id IN NUMBER);
357
358 PROCEDURE Delete_Budget_Revision_CP
359 ( errbuf OUT NOCOPY VARCHAR2,
360 retcode OUT NOCOPY VARCHAR2,
361 p_from_budget_revision_id IN NUMBER,
362 p_to_budget_revision_id IN NUMBER,
363 p_submission_status IN VARCHAR2);
364
365
366 /* Budget Revison Rules Enhancement Start */
367
368 PROCEDURE Apply_Revision_Rules
369 ( p_api_version IN NUMBER,
370 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
371 p_return_status OUT NOCOPY VARCHAR2,
372 p_validation_status OUT NOCOPY VARCHAR2,
373 p_budget_revision_id IN NUMBER
374 );
375
376 PROCEDURE Apply_Detail_Revision_Rules
377 (
378 p_return_status OUT NOCOPY VARCHAR2,
379 p_rule_validation_status OUT NOCOPY VARCHAR2,
380 p_budget_revision_id IN NUMBER,
381 p_rule_id IN NUMBER,
382 p_rule_type IN VARCHAR2,
383 p_apply_account_set_flag IN VARCHAR2,
384 p_balance_account_set_flag IN VARCHAR2,
385 p_segment_name IN VARCHAR2,
386 p_application_column_name IN VARCHAR2,
390 PROCEDURE Process_Balance_Rule
387 p_chart_of_accounts_id IN NUMBER
388 );
389
391 (
392 p_return_status OUT NOCOPY VARCHAR2,
393 p_apply_cr IN OUT NOCOPY NUMBER,
394 p_apply_dr IN OUT NOCOPY NUMBER,
395 p_balance_cr IN OUT NOCOPY NUMBER,
396 p_balance_dr IN OUT NOCOPY NUMBER,
397 p_seg_apply_cr IN OUT NOCOPY fnd_flex_ext.SegmentArray,
398 p_seg_apply_dr IN OUT NOCOPY fnd_flex_ext.SegmentArray,
399 p_seg_balance_cr IN OUT NOCOPY fnd_flex_ext.SegmentArray,
400 p_seg_balance_dr IN OUT NOCOPY fnd_flex_ext.SegmentArray,
401 p_budget_revision_id IN NUMBER,
402 p_rule_id IN NUMBER,
403 p_apply_account_set_flag IN VARCHAR2,
404 p_balance_account_set_flag IN VARCHAR2,
405 p_segment_name IN VARCHAR2,
406 p_application_column_name IN VARCHAR2,
407 p_ccid IN NUMBER,
408 p_apply_balance_flag IN VARCHAR2
409 );
410
411 PROCEDURE Process_Perm_Temp_Rule
412 (
413 p_return_status OUT NOCOPY VARCHAR2,
414 p_rule_validation_status OUT NOCOPY VARCHAR2,
415 p_budget_revision_id IN NUMBER,
416 p_rule_id IN NUMBER,
417 p_rule_type IN VARCHAR2,
418 p_apply_account_set_flag IN VARCHAR2,
419 p_ccid IN VARCHAR2,
420 p_apply_balance_flag IN VARCHAR2
421 );
422
423 /* Budget Revison Rules Enhancement End */
424
425 /* Bug No 1808330 Start */
426
427 PROCEDURE Create_Note
428 ( p_return_status OUT NOCOPY VARCHAR2,
429 p_account_line_id IN NUMBER,
430 p_position_line_id IN NUMBER,
431 p_note IN VARCHAR2,
432 p_flex_code IN NUMBER, -- Bug#4571412
433 p_cc_id IN NUMBER DEFAULT NULL -- Bug#4675858
434 );
435
436 /* Bug No 1808330 End */
437
438 /* bug no 3439168 */
439 PROCEDURE set_position_update_flag
440 (
441 x_return_status OUT NOCOPY VARCHAR2, -- Bug#4460150
442 p_position_id IN NUMBER
443 );
444 /* bug no 3439168 */
445
446 END PSB_BUDGET_REVISIONS_PVT;