1 package GMS_BUDGET_PUB AUTHID CURRENT_USER as
2 /*$Header: gmsmbups.pls 120.12 2006/07/29 12:51:44 smaroju ship $*/
3 /*#
4 * This API provides a set of procedures to create, modify, delete, and submit a draft award budget
5 * and to designate a draft award budget as the baseline budget.
6 * @rep:scope public
7 * @rep:product GMS
8 * @rep:lifecycle active
9 * @rep:displayname Budget API
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY GMS_AWARD
12 * @rep:doccd 120gmsug.pdf See the Oracle Oracle Grants Accounting User's Guide
13 */
14 -- Global constants to be used by GMS AMG procedures
15 G_MISS_NUM CONSTANT NUMBER := 1.7E20;
16 G_MISS_DATE CONSTANT DATE := TO_DATE('01/01/4712','DD/MM/YYYY');
17 G_MISS_CHAR CONSTANT VARCHAR2(3) := '^';
18 G_FALSE CONSTANT VARCHAR2(1) := 'F';
19 G_TRUE CONSTANT VARCHAR2(1) := 'T';
20
21 --Global constants to be used in error messages
22 G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMS_BUDGET_PUB';
23 G_BUDGET_CODE CONSTANT VARCHAR2(6) := 'BUDGET';
24 G_PROJECT_CODE CONSTANT VARCHAR2(7) := 'PROJECT';
25 G_TASK_CODE CONSTANT VARCHAR2(4) := 'TASK';
26 G_RESOURCE_CODE CONSTANT VARCHAR2(8) := 'RESOURCE';
27 G_AWARD_CODE CONSTANT VARCHAR2(5) := 'AWARD';
28
29 --Locking exception
30 ROW_ALREADY_LOCKED EXCEPTION;
31 PRAGMA EXCEPTION_INIT(ROW_ALREADY_LOCKED, -54);
32
33 --Package constant used for package version validation
34
35 G_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
36
37 -- Added since Forms cannot call a global variable directly
38
39 FUNCTION G_PA_MISS_NUM RETURN NUMBER;
40 FUNCTION G_PA_MISS_CHAR RETURN VARCHAR2;
41 FUNCTION G_PA_MISS_DATE RETURN DATE;
42
43 FUNCTION G_GMS_TRUE RETURN VARCHAR2;
44 FUNCTION G_GMS_FALSE RETURN VARCHAR2;
45
46 /*
47 TYPE calc_budget_line_out_rec_type IS RECORD
48 (pa_task_id NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
49 ,pm_task_reference VARCHAR2(30) := GMS_BUDGET_PUB.G_PA_MISS_CHAR
50 ,resource_alias VARCHAR2(30) := GMS_BUDGET_PUB.G_PA_MISS_CHAR
51 ,resource_list_member_id NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
52 ,budget_start_date DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
53 ,budget_end_date DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
54 ,period_name VARCHAR2(30) := GMS_BUDGET_PUB.G_PA_MISS_CHAR
55 ,calculated_raw_cost NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
56 ,calculated_burdened_cost NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
57 ,quantity NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
58 ,return_status VARCHAR2(1) := GMS_BUDGET_PUB.G_PA_MISS_CHAR
59 );
60
61 TYPE calc_budget_line_out_tbl_type IS TABLE OF calc_budget_line_out_rec_type
62 INDEX BY BINARY_INTEGER;
63
64 --Counters
65 G_budget_lines_tbl_count NUMBER:=0;
66 G_calc_budget_lines_tbl_count NUMBER:=0;
67 */
68 /*#
69 * This procedure creates a draft project budget from baseline award budgets.
70 * @param x_budget_version_id The reference code that uniquely identifies the budget version
71 * @rep:paraminfo {@rep:required}
72 * @param x_err_code The reference code which identifies the SQL error code returned by the API
73 * @rep:paraminfo {@rep:required}
74 * @param x_err_stage The reference code which identifies the stage where error has occurred
75 * @rep:paraminfo {@rep:required}
76 * @param x_err_stack The reference code which identifies the error message returned by the API
77 * @rep:paraminfo {@rep:required}
78 * @rep:scope public
79 * @rep:lifecycle active
80 * @rep:displayname Summarize Project Totals
81 * @rep:compatibility S
82 */
83 PROCEDURE summerize_project_totals
84 (x_budget_version_id IN NUMBER,
85 x_err_code IN OUT NOCOPY NUMBER,
86 x_err_stage IN OUT NOCOPY VARCHAR2,
87 x_err_stack IN OUT NOCOPY VARCHAR2);
88 /*#
89 * This procedure creates a draft budget version for an award and project.
90 * @param p_api_version_number API standard: version number
91 * @rep:paraminfo {@rep:required}
92 * @param x_err_code The reference code which identifies the SQL error code returned by the API
93 * @rep:paraminfo {@rep:required}
94 * @param x_err_stage The reference code which identifies the stage where error has occurred
95 * @rep:paraminfo {@rep:required}
96 * @param x_err_stack The reference code which identifies the error message returned by the API
97 * @rep:paraminfo {@rep:required}
98 * @param p_commit API standard (default = F): indicates if the transaction will be committed
99 * @rep:paraminfo {@rep:required}
100 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
101 * @rep:paraminfo {@rep:required}
102 * @param p_pm_product_code Identifier of the external systems from which the project was imported
103 * @rep:paraminfo {@rep:required}
104 * @param p_pm_budget_reference Identifier of the external systems from which the project was imported
105 * @rep:paraminfo {@rep:required}
106 * @param p_budget_version_name The reference code that identifies versionnumber of the budget
107 * @rep:paraminfo {@rep:required}
108 * @param p_project_id The reference code that uniquely identifies the project in Oracle Projects
109 * @rep:paraminfo {@rep:required}
110 * @param p_project_number Identifier of the project number
111 * @rep:paraminfo {@rep:required}
112 * @param p_award_id The reference code that uniquely identifies the award in Oracle Grants Accounting
113 * @rep:paraminfo {@rep:required}
114 * @param p_award_number Identifier of the award number
115 * @rep:paraminfo {@rep:required}
116 * @param p_budget_type_code The reference code that identifies budget type code "AC" for approved cost budget
117 * @rep:paraminfo {@rep:required}
118 * @param p_change_reason_code Identifier of the change reason for the budget
119 * @rep:paraminfo {@rep:required}
120 * @param p_description Description of the budget
121 * @rep:paraminfo {@rep:required}
122 * @param p_entry_method_code The reference code that identifies budget entry method
123 * @rep:paraminfo {@rep:required}
124 * @param p_resource_list_name The reference code that identifies resource list name of the budget
125 * @rep:paraminfo {@rep:required}
126 * @param p_resource_list_id The reference code that identifies resource list id of the budget
127 * @rep:paraminfo {@rep:required}
128 * @param p_attribute_category Descriptive flexfield category
129 * @rep:paraminfo {@rep:required}
130 * @param p_attribute1 Descriptive flexfield segment
131 * @rep:paraminfo {@rep:required}
132 * @param p_attribute2 Descriptive flexfield segment
133 * @rep:paraminfo {@rep:required}
134 * @param p_attribute3 Descriptive flexfield segment
135 * @rep:paraminfo {@rep:required}
136 * @param p_attribute4 Descriptive flexfield segment
137 * @rep:paraminfo {@rep:required}
138 * @param p_attribute5 Descriptive flexfield segment
139 * @rep:paraminfo {@rep:required}
140 * @param p_attribute6 Descriptive flexfield segment
141 * @rep:paraminfo {@rep:required}
142 * @param p_attribute7 Descriptive flexfield segment
143 * @rep:paraminfo {@rep:required}
144 * @param p_attribute8 Descriptive flexfield segment
145 * @rep:paraminfo {@rep:required}
146 * @param p_attribute9 Descriptive flexfield segment
147 * @rep:paraminfo {@rep:required}
148 * @param p_attribute10 Descriptive flexfield segment
149 * @rep:paraminfo {@rep:required}
150 * @param p_attribute11 Descriptive flexfield segment
151 * @rep:paraminfo {@rep:required}
152 * @param p_attribute12 Descriptive flexfield segment
153 * @rep:paraminfo {@rep:required}
154 * @param p_attribute13 Descriptive flexfield segment
155 * @rep:paraminfo {@rep:required}
156 * @param p_attribute14 Descriptive flexfield segment
157 * @rep:paraminfo {@rep:required}
158 * @param p_attribute15 Descriptive flexfield segment
159 * @rep:paraminfo {@rep:required}
160 * @param p_first_budget_period The reference code that identifies the first budget period
161 * @rep:paraminfo {@rep:required}
162 * @rep:scope public
163 * @rep:lifecycle active
164 * @rep:displayname Create Draft Budget
165 * @rep:compatibility S
166 */
167 PROCEDURE create_draft_budget
168 ( p_api_version_number IN NUMBER
169 ,x_err_code IN OUT NOCOPY NUMBER
170 ,x_err_stage IN OUT NOCOPY VARCHAR2
171 ,x_err_stack IN OUT NOCOPY VARCHAR2
172 ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
173 ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
174 ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
175 ,p_pm_budget_reference IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
176 ,p_budget_version_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
177 ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
178 ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
179 ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
180 ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
181 ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
182 ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
183 ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
184 ,p_entry_method_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
185 ,p_resource_list_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
186 ,p_resource_list_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
187 ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
188 ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
189 ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
190 ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
191 ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
192 ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
193 ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
194 ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
195 ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
196 ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
197 ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
198 ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
199 ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
200 ,p_attribute13 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
201 ,p_attribute14 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
202 ,p_attribute15 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
203 ,p_first_budget_period IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR -- Bug 3104308
204 );
205 /*#
206 * This procedure submits the budget baseline concurrent process, which calls the BASELINE_BUDGET procedure.
207 * @param p_reqid Request id
208 * @rep:paraminfo {@rep:required}
209 * @param p_project_id The reference code that uniquely identifies the project in Oracle Projects
210 * @rep:paraminfo {@rep:required}
211 * @param p_award_id The reference code that uniquely identifies the award in Oracle Grants Accounting
212 * @rep:paraminfo {@rep:required}
213 * @param p_mark_as_original The reference code which will mark the budget version as original.Y for yes
214 * N for No
215 * @rep:paraminfo {@rep:required}
216 * @rep:scope public
217 * @rep:lifecycle active
218 * @rep:displayname Submit Budget
219 * @rep:compatibility S
220 */
221 PROCEDURE submit_budg_conc_process
222 ( p_reqid OUT NOCOPY NUMBER,
223 p_project_id IN NUMBER,
224 p_award_id IN NUMBER,
225 p_mark_as_original IN VARCHAR
226 );
227 /*#
228 * This procedure submits an award budget or sets an award budget as the baseline budget.
229 * @param ERRBUFF Error message returned if any
230 * @rep:paraminfo {@rep:required}
231 * @param RETCODE Return Code; S for Success, E for Error
232 * @rep:paraminfo {@rep:required}
233 * @param p_project_id The reference code that uniquely identifies the project in Oracle Projects
234 * @rep:paraminfo {@rep:required}
235 * @param p_award_number Identifier of the award number
236 * @rep:paraminfo {@rep:required}
237 * @param p_mark_as_original The reference code which will mark the budget version as original. The values are Y for yes
238 * N for No
239 * @rep:paraminfo {@rep:required}
240 * @rep:scope public
241 * @rep:lifecycle active
242 * @rep:displayname Submit Or Baseline Budget
243 * @rep:compatibility S
244 */
245 PROCEDURE submit_baseline_budget
246 ( ERRBUFF IN OUT NOCOPY VARCHAR2
247 ,RETCODE IN OUT NOCOPY VARCHAR2
248 ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
249 ,p_award_number IN VARCHAR2 /* bug 3651888 := GMS_BUDGET_PUB.G_PA_MISS_NUM*/
250 ,p_mark_as_original IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
251 );
252 /*#
253 * This procedure sets a draft budget as the baseline budget.
254 * @param p_api_version_number API standard: version number
255 * @rep:paraminfo {@rep:required}
256 * @param x_err_code The reference code which identifies the SQL error code returned by the API
257 * @rep:paraminfo {@rep:required}
258 * @param x_err_stage The reference code which identifies the stage where error has occurred
259 * @rep:paraminfo {@rep:required}
260 * @param x_err_stack The reference code which identifies the error message returned by the API
261 * @rep:paraminfo {@rep:required}
262 * @param p_commit API standard (default = F): indicates if the transaction will be committed
263 * @rep:paraminfo {@rep:required}
264 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
265 * @rep:paraminfo {@rep:required}
269 * for yes, N for no
266 * @param p_pm_product_code Identifier of the external systems from which the project was imported
267 * @rep:paraminfo {@rep:required}
268 * @param p_workflow_started Indicates whether workflow has been started to baseline the budget; Y
270 * @rep:paraminfo {@rep:required}
271 * @param p_project_id The reference code that uniquely identifies the project in Oracle Projects
272 * @rep:paraminfo {@rep:required}
273 * @param p_project_number Identifier of the project number
274 * @rep:paraminfo {@rep:required}
275 * @param p_award_id The reference code that uniquely identifies the award in Oracle Grants Accounting
276 * @rep:paraminfo {@rep:required}
277 * @param p_award_number Identifier of the award number
278 * @rep:paraminfo {@rep:required}
279 * @param p_budget_type_code The reference code that identifies budget type code "AC" for approved cost budget
280 * @rep:paraminfo {@rep:required}
281 * @param p_mark_as_original The reference code which will mark the budget version as original.The values are Y for yes
282 * N for No
283 * @rep:scope public
284 * @rep:lifecycle active
285 * @rep:displayname Baseline Budget
286 * @rep:compatibility S
287 */
288 PROCEDURE baseline_budget
289 ( p_api_version_number IN NUMBER
290 ,x_err_code IN OUT NOCOPY NUMBER
291 ,x_err_stage IN OUT NOCOPY VARCHAR2
292 ,x_err_stack IN OUT NOCOPY VARCHAR2
293 ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
294 ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
295 ,p_workflow_started OUT NOCOPY VARCHAR2
296 ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
297 ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
298 ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
299 ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
300 ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
301 ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
302 ,p_mark_as_original IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR );
303
304 /*#
305 * This procedure adds a line to a draft or working budget.
306 * @param p_api_version_number API standard: version number
307 * @rep:paraminfo {@rep:required}
308 * @param x_err_code The reference code which identifies the SQL error code returned by the API
309 * @rep:paraminfo {@rep:required}
310 * @param x_err_stage The reference code which identifies the stage where error has occurred
311 * @rep:paraminfo {@rep:required}
312 * @param x_err_stack The reference code which identifies the error message returned by the API
313 * @rep:paraminfo {@rep:required}
314 * @param p_commit API standard (default = F): indicates if the transaction will be committed
315 * @rep:paraminfo {@rep:required}
316 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
317 * @rep:paraminfo {@rep:required}
318 * @param p_pm_product_code Identifier of the external systems from which the project was imported
319 * @rep:paraminfo {@rep:required}
320 * @param p_project_id The reference code that uniquely identifies the project in Oracle Projects
321 * @rep:paraminfo {@rep:required}
322 * @param p_project_number Identifier of the project number
323 * @rep:paraminfo {@rep:required}
324 * @param p_award_id The reference code that uniquely identifies the award in Oracle Grants Accounting
325 * @rep:paraminfo {@rep:required}
326 * @param p_award_number Identifier of the award number
327 * @rep:paraminfo {@rep:required}
328 * @param p_budget_type_code The reference code that identifies budget type code; "AC" for approved cost budget
329 * @rep:paraminfo {@rep:required}
330 * @param p_task_id The reference code that uniquely identifies the task within a project in Oracle Projects
331 * @rep:paraminfo {@rep:required}
332 * @param p_task_number Identifier of the task number
333 * @rep:paraminfo {@rep:required}
334 * @param p_resource_alias The reference code that identifies the budget resource
335 * @rep:paraminfo {@rep:required}
336 * @param p_resource_list_member_id The reference code that identifies the resource list member
337 * @rep:paraminfo {@rep:required}
338 * @param p_budget_start_date The reference code that identifies the budget start date
339 * @rep:paraminfo {@rep:required}
340 * @param p_budget_end_date The reference code that identifies the budget end date
341 * @rep:paraminfo {@rep:required}
342 * @param p_period_name The reference code that identifies the period of the budget
343 * @rep:paraminfo {@rep:required}
344 * @param p_description Description of the budget
345 * @rep:paraminfo {@rep:required}
346 * @param p_change_reason_code Identifier of the change reason for the budget
347 * @rep:paraminfo {@rep:required}
348 * @param p_raw_cost Identifier of the raw cost
349 * @rep:paraminfo {@rep:required}
350 * @param p_burdened_cost Identifier of the burdened cost
351 * @rep:paraminfo {@rep:required}
352 * @param p_quantity Identifier of the quantity
353 * @rep:paraminfo {@rep:required}
354 * @param p_unit_of_measure Identifier of the unit of measure
355 * @rep:paraminfo {@rep:required}
356 * @param p_track_as_labor_flag The reference code that identifies if the is labor
357 * @rep:paraminfo {@rep:required}
358 * @param p_pm_budget_line_reference The reference code that identifies if external budget line reference
359 * @rep:paraminfo {@rep:required}
360 * @param p_attribute_category Descriptive flexfield category
361 * @rep:paraminfo {@rep:required}
362 * @param p_attribute1 Descriptive flexfield segment
363 * @rep:paraminfo {@rep:required}
367 * @rep:paraminfo {@rep:required}
364 * @param p_attribute2 Descriptive flexfield segment
365 * @rep:paraminfo {@rep:required}
366 * @param p_attribute3 Descriptive flexfield segment
368 * @param p_attribute4 Descriptive flexfield segment
369 * @rep:paraminfo {@rep:required}
370 * @param p_attribute5 Descriptive flexfield segment
371 * @rep:paraminfo {@rep:required}
372 * @param p_attribute6 Descriptive flexfield segment
373 * @rep:paraminfo {@rep:required}
374 * @param p_attribute7 Descriptive flexfield segment
375 * @rep:paraminfo {@rep:required}
376 * @param p_attribute8 Descriptive flexfield segment
377 * @rep:paraminfo {@rep:required}
378 * @param p_attribute9 Descriptive flexfield segment
379 * @rep:paraminfo {@rep:required}
380 * @param p_attribute10 Descriptive flexfield segment
381 * @rep:paraminfo {@rep:required}
382 * @param p_attribute11 Descriptive flexfield segment
383 * @rep:paraminfo {@rep:required}
384 * @param p_attribute12 Descriptive flexfield segment
385 * @rep:paraminfo {@rep:required}
386 * @param p_attribute13 Descriptive flexfield segment
387 * @rep:paraminfo {@rep:required}
388 * @param p_attribute14 Descriptive flexfield segment
389 * @rep:paraminfo {@rep:required}
390 * @param p_attribute15 Descriptive flexfield segment
391 * @rep:paraminfo {@rep:required}
392 * @param p_raw_cost_source The reference code that identifies the raw cost source
393 * @rep:paraminfo {@rep:required}
394 * @param p_burdened_cost_source The reference code that identifies the burdenend cost source
395 * @rep:paraminfo {@rep:required}
396 * @param p_quantity_source The reference code that identifies the quantity
397 * @rep:paraminfo {@rep:required}
398 * @rep:scope public
399 * @rep:lifecycle active
400 * @rep:displayname Add Budget Line
401 * @rep:compatibility S
402 */
403 PROCEDURE add_budget_line
404 ( p_api_version_number IN NUMBER
405 ,x_err_code IN OUT NOCOPY NUMBER
406 ,x_err_stage IN OUT NOCOPY VARCHAR2
407 ,x_err_stack IN OUT NOCOPY VARCHAR2
408 ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
409 ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
410 ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
411 ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
412 ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
413 ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
414 ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
415 ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
416 ,p_task_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
417 ,p_task_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
418 ,p_resource_alias IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
419 ,p_resource_list_member_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
420 ,p_budget_start_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
421 ,p_budget_end_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
422 ,p_period_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
423 ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
424 ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
425 ,p_raw_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
426 ,p_burdened_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
427 ,p_quantity IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
428 ,p_unit_of_measure IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
429 ,p_track_as_labor_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
430 ,p_pm_budget_line_reference IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
431 ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
432 ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
433 ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
434 ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
435 ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
436 ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
437 ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
438 ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
439 ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
440 ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
441 ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
442 ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
443 ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
444 ,p_attribute13 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
445 ,p_attribute14 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
446 ,p_attribute15 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
447 ,p_raw_cost_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
448 ,p_burdened_cost_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
449 ,p_quantity_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
450 );
451 /*#
452 * This procedure deletes a draft budget.
453 * @param p_api_version_number API standard: version number
454 * @rep:paraminfo {@rep:required}
455 * @param x_err_code The reference code which identifies the SQL error code returned by the API
456 * @rep:paraminfo {@rep:required}
457 * @param x_err_stage The reference code which identifies the stage where error has occurred
458 * @rep:paraminfo {@rep:required}
459 * @param x_err_stack The reference code which identifies the error message returned by the API
460 * @rep:paraminfo {@rep:required}
461 * @param p_commit API standard (default = F): indicates if the transaction will be committed
462 * @rep:paraminfo {@rep:required}
463 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
467 * @param p_project_id The reference code that uniquely identifies the project in Oracle Projects
464 * @rep:paraminfo {@rep:required}
465 * @param p_pm_product_code Identifier of the external systems from which the project was imported
466 * @rep:paraminfo {@rep:required}
468 * @rep:paraminfo {@rep:required}
469 * @param p_project_number Identifier of the project number
470 * @rep:paraminfo {@rep:required}
471 * @param p_award_id The reference code that uniquely identifies the award in Oracle Grants Accounting
472 * @rep:paraminfo {@rep:required}
473 * @param p_award_number Identifier of the award number
474 * @rep:paraminfo {@rep:required}
475 * @param p_budget_type_code The reference code that identifies budget type code; "AC" for approved cost budget
476 * @rep:paraminfo {@rep:required}
477 * @rep:scope public
478 * @rep:lifecycle active
479 * @rep:displayname Delete Draft Budget
480 * @rep:compatibility S
481 */
482 PROCEDURE delete_draft_budget
483 ( p_api_version_number IN NUMBER
484 ,x_err_code IN OUT NOCOPY NUMBER
485 ,x_err_stage IN OUT NOCOPY VARCHAR2
486 ,x_err_stack IN OUT NOCOPY VARCHAR2
487 ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
488 ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
489 ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
490 ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
491 ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
492 ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
493 ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
494 ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR );
495 /*#
496 * This procedure deletes a budget line of a draft budget.
497 * @param p_api_version_number API standard: version number
498 * @rep:paraminfo {@rep:required}
499 * @param x_err_code The reference code which identifies the SQL error code returned by the API
500 * @rep:paraminfo {@rep:required}
501 * @param x_err_stage The reference code which identifies the stage where error has occurred
502 * @rep:paraminfo {@rep:required}
503 * @param x_err_stack The reference code which identifies the error message returned by the API
504 * @rep:paraminfo {@rep:required}
505 * @param p_commit API standard (default = F): indicates if the transaction will be committed
506 * @rep:paraminfo {@rep:required}
507 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
508 * @rep:paraminfo {@rep:required}
509 * @param p_pm_product_code Identifier of the external systems from which the project was imported
510 * @rep:paraminfo {@rep:required}
511 * @param p_project_id The reference code that uniquely identifies the project in Oracle Projects
512 * @rep:paraminfo {@rep:required}
513 * @param p_project_number Identifier of the project number
514 * @rep:paraminfo {@rep:required}
515 * @param p_award_id The reference code that uniquely identifies the award in Oracle Grants Accounting
516 * @rep:paraminfo {@rep:required}
517 * @param p_award_number Identifier of the award number
518 * @rep:paraminfo {@rep:required}
519 * @param p_budget_type_code The reference code that identifies budget type code; "AC" for approved cost budget
520 * @rep:paraminfo {@rep:required}
521 * @param p_task_id The reference code that uniquely identifies the task within a project in Oracle Projects
522 * @rep:paraminfo {@rep:required}
523 * @param p_task_number Identifier of the task number
524 * @rep:paraminfo {@rep:required}
525 * @param p_resource_alias The reference code that identifies the budget resource
526 * @rep:paraminfo {@rep:required}
527 * @param p_resource_list_member_id The reference code that identifies the resource list member
528 * @rep:paraminfo {@rep:required}
529 * @param p_start_date The reference code that identifies the budget start date
530 * @rep:paraminfo {@rep:required}
531 * @param p_period_name The reference code that identifies the period of the budget
532 * @rep:paraminfo {@rep:required}
533 * @rep:scope public
534 * @rep:lifecycle active
535 * @rep:displayname Delete Budget Line
536 * @rep:compatibility S
537 */
538 PROCEDURE delete_budget_line
539 ( p_api_version_number IN NUMBER
540 ,x_err_code IN OUT NOCOPY NUMBER
541 ,x_err_stage IN OUT NOCOPY VARCHAR2
542 ,x_err_stack IN OUT NOCOPY VARCHAR2
543 ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
544 ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
545 ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
546 ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
547 ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
548 ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
549 ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
550 ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
551 ,p_task_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
552 ,p_task_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
553 ,p_resource_alias IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
554 ,p_resource_list_member_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
555 ,p_start_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
556 ,p_period_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR );
557 /*#
558 * This procedure updates the attributes of a budget version.
559 * @param p_api_version_number API standard: version number
560 * @rep:paraminfo {@rep:required}
561 * @param x_err_code The reference code which identifies the SQL error code returned by the API
562 * @rep:paraminfo {@rep:required}
563 * @param x_err_stage The reference code which identifies the stage where error has occurred
567 * @param p_commit API standard (default = F): indicates if the transaction will be committed
564 * @rep:paraminfo {@rep:required}
565 * @param x_err_stack The reference code which identifies the error message returned by the API
566 * @rep:paraminfo {@rep:required}
568 * @rep:paraminfo {@rep:required}
569 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
570 * @rep:paraminfo {@rep:required}
571 * @param p_pm_product_code Identifier of the external systems from which the project was imported
572 * @rep:paraminfo {@rep:required}
573 * @param p_project_id The reference code that uniquely identifies the project in Oracle Projects
574 * @rep:paraminfo {@rep:required}
575 * @param p_project_number Identifier of the project number
576 * @rep:paraminfo {@rep:required}
577 * @param p_award_id The reference code that uniquely identifies the award in Oracle Grants Accounting
578 * @rep:paraminfo {@rep:required}
579 * @param p_award_number Identifier of the award number
580 * @rep:paraminfo {@rep:required}
581 * @param p_budget_type_code The reference code that identifies budget type code; "AC" for approved cost budget
582 * @rep:paraminfo {@rep:required}
583 * @param p_change_reason_code Identifier of the change reason for the budget
584 * @rep:paraminfo {@rep:required}
585 * @param p_description Description of the budget
586 * @rep:paraminfo {@rep:required}
587 * @param p_budget_status_code The reference code that identifies budget status
588 * @rep:paraminfo {@rep:required}
589 * @param p_version_number The reference code that identifies versionnumber of the budget
590 * @rep:paraminfo {@rep:required}
591 * @param p_current_flag The reference code that identifies whether the budget version is the
592 * current baselined budget; yes or no
593 * @rep:paraminfo {@rep:required}
594 * @param p_original_flag The reference code that identifies whether the budget version was
595 * an original budget at any time; yes or no
596 * @rep:paraminfo {@rep:required}
597 * @param p_current_original_flag The reference code that identifies whether the budget version is the
598 * current original budget; yes or no
599 * @rep:paraminfo {@rep:required}
600 * @param p_resource_accumulated_flag The reference code that identifies versionnumber of the budget
601 * @rep:paraminfo {@rep:required}
602 * @param p_resource_list_id The reference code that identifies resource list id of the budget
603 * @rep:paraminfo {@rep:required}
604 * @param p_version_name The reference code that identifies versionnumber of the budget
605 * @rep:paraminfo {@rep:required}
606 * @param p_budget_entry_method_code The reference code that identifies budget entry method
607 * @rep:paraminfo {@rep:required}
608 * @param p_baselined_by_person_id The reference code that identifies the person who has done the baseline
609 * @rep:paraminfo {@rep:required}
610 * @param p_baselined_date The reference code that identifies date on which budget has been baselined
611 * @rep:paraminfo {@rep:required}
612 * @param p_quantity Identifier of the quantity
613 * @rep:paraminfo {@rep:required}
614 * @param p_unit_of_measure Identifier of the unit of measure
615 * @rep:paraminfo {@rep:required}
616 * @param p_raw_cost Identifier of the raw cost
617 * @rep:paraminfo {@rep:required}
618 * @param p_burdened_cost Identifier of the burdened cost
619 * @rep:paraminfo {@rep:required}
620 * @param p_attribute_category Descriptive flexfield category
621 * @rep:paraminfo {@rep:required}
622 * @param p_attribute1 Descriptive flexfield segment
623 * @rep:paraminfo {@rep:required}
624 * @param p_attribute2 Descriptive flexfield segment
625 * @rep:paraminfo {@rep:required}
626 * @param p_attribute3 Descriptive flexfield segment
627 * @rep:paraminfo {@rep:required}
628 * @param p_attribute4 Descriptive flexfield segment
629 * @rep:paraminfo {@rep:required}
630 * @param p_attribute5 Descriptive flexfield segment
631 * @rep:paraminfo {@rep:required}
632 * @param p_attribute6 Descriptive flexfield segment
633 * @rep:paraminfo {@rep:required}
634 * @param p_attribute7 Descriptive flexfield segment
635 * @rep:paraminfo {@rep:required}
636 * @param p_attribute8 Descriptive flexfield segment
637 * @rep:paraminfo {@rep:required}
638 * @param p_attribute9 Descriptive flexfield segment
642 * @param p_attribute11 Descriptive flexfield segment
639 * @rep:paraminfo {@rep:required}
640 * @param p_attribute10 Descriptive flexfield segment
641 * @rep:paraminfo {@rep:required}
643 * @rep:paraminfo {@rep:required}
644 * @param p_attribute12 Descriptive flexfield segment
645 * @rep:paraminfo {@rep:required}
646 * @param p_attribute13 Descriptive flexfield segment
647 * @rep:paraminfo {@rep:required}
648 * @param p_attribute14 Descriptive flexfield segment
649 * @rep:paraminfo {@rep:required}
650 * @param p_attribute15 Descriptive flexfield segment
651 * @rep:paraminfo {@rep:required}
652 * @param p_first_budget_period The reference code that identifies the first budget period
653 * @rep:paraminfo {@rep:required}
654 * @param p_wf_status_code The reference code that identifies the workflow status for the budget
655 * @rep:paraminfo {@rep:required}
656 * @rep:scope public
657 * @rep:lifecycle active
658 * @rep:displayname Update Budget
659 * @rep:compatibility S
660 */
661 PROCEDURE update_budget
662 ( p_api_version_number IN NUMBER
663 ,x_err_code IN OUT NOCOPY NUMBER
664 ,x_err_stage IN OUT NOCOPY VARCHAR2
665 ,x_err_stack IN OUT NOCOPY VARCHAR2
666 ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
667 ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
668 ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
669 ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
670 ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
671 ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
672 ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
673 ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
674 ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
675 ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
676 ,p_budget_status_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
677 ,p_version_number IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
678 ,p_current_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
679 ,p_original_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
680 ,p_current_original_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
681 ,p_resource_accumulated_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
682 ,p_resource_list_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
683 ,p_version_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
684 ,p_budget_entry_method_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
685 ,p_baselined_by_person_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
686 ,p_baselined_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
687 ,p_quantity IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
688 ,p_unit_of_measure IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
689 ,p_raw_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
690 ,p_burdened_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
691 ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
692 ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
693 ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
694 ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
695 ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
696 ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
697 ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
698 ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
699 ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
700 ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
701 ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
702 ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
703 ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
704 ,p_attribute13 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
705 ,p_attribute14 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
706 ,p_attribute15 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
707 ,p_first_budget_period IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
708 ,p_wf_status_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR);
709 /*#
710 * This procedure updates a budget line of draft budget.
711 * @param p_api_version_number API standard: version number
712 * @rep:paraminfo {@rep:required}
713 * @param x_err_code The reference code which identifies the SQL error code returned by the API
714 * @rep:paraminfo {@rep:required}
715 * @param x_err_stage The reference code which identifies the stage where error has occurred
716 * @rep:paraminfo {@rep:required}
717 * @param x_err_stack The reference code which identifies the error message returned by the API
718 * @rep:paraminfo {@rep:required}
719 * @param p_commit API standard (default = F): indicates if the transaction will be committed
720 * @rep:paraminfo {@rep:required}
721 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
722 * @rep:paraminfo {@rep:required}
723 * @param p_pm_product_code Identifier of the external systems from which the project was imported
724 * @rep:paraminfo {@rep:required}
725 * @param p_project_id The reference code that uniquely identifies the project in Oracle Projects
726 * @rep:paraminfo {@rep:required}
727 * @param p_project_number Identifier of the project number
728 * @rep:paraminfo {@rep:required}
729 * @param p_budget_type_code The reference code that identifies budget type code; "AC" for approved cost budget
730 * @rep:paraminfo {@rep:required}
731 * @param p_task_id The reference code that uniquely identifies the task within a project in Oracle Projects
732 * @rep:paraminfo {@rep:required}
733 * @param p_task_number Identifier of the task number
737 * @param p_award_number Identifier of the award number
734 * @rep:paraminfo {@rep:required}
735 * @param p_award_id The reference code that uniquely identifies the award in Oracle Grants Accounting
736 * @rep:paraminfo {@rep:required}
738 * @rep:paraminfo {@rep:required}
739 * @param p_resource_alias The reference code that identifies the budget resource
740 * @rep:paraminfo {@rep:required}
741 * @param p_resource_list_member_id The reference code that identifies the resource list member
742 * @rep:paraminfo {@rep:required}
743 * @param p_budget_start_date The reference code that identifies the budget start date
744 * @rep:paraminfo {@rep:required}
745 * @param p_budget_end_date The reference code that identifies the budget end date
746 * @rep:paraminfo {@rep:required}
747 * @param p_period_name The reference code that identifies the period of the budget
748 * @rep:paraminfo {@rep:required}
749 * @param p_description Description of the budget
750 * @rep:paraminfo {@rep:required}
751 * @param p_change_reason_code Identifier of the change reason for the budget
752 * @rep:paraminfo {@rep:required}
753 * @param p_raw_cost Identifier of the raw cost
754 * @rep:paraminfo {@rep:required}
755 * @param p_burdened_cost Identifier of the burdened cost
756 * @rep:paraminfo {@rep:required}
757 * @param p_quantity Identifier of the quantity
758 * @rep:paraminfo {@rep:required}
759 * @param p_unit_of_measure Identifier of the unit of measure
760 * @rep:paraminfo {@rep:required}
761 * @param p_track_as_labor_flag The reference code that identifies if the is labor
762 * @rep:paraminfo {@rep:required}
763 * @param p_attribute_category Descriptive flexfield category
764 * @rep:paraminfo {@rep:required}
765 * @param p_attribute1 Descriptive flexfield segment
766 * @rep:paraminfo {@rep:required}
767 * @param p_attribute2 Descriptive flexfield segment
768 * @rep:paraminfo {@rep:required}
769 * @param p_attribute3 Descriptive flexfield segment
770 * @rep:paraminfo {@rep:required}
771 * @param p_attribute4 Descriptive flexfield segment
772 * @rep:paraminfo {@rep:required}
773 * @param p_attribute5 Descriptive flexfield segment
774 * @rep:paraminfo {@rep:required}
775 * @param p_attribute6 Descriptive flexfield segment
776 * @rep:paraminfo {@rep:required}
777 * @param p_attribute7 Descriptive flexfield segment
778 * @rep:paraminfo {@rep:required}
779 * @param p_attribute8 Descriptive flexfield segment
780 * @rep:paraminfo {@rep:required}
781 * @param p_attribute9 Descriptive flexfield segment
782 * @rep:paraminfo {@rep:required}
783 * @param p_attribute10 Descriptive flexfield segment
784 * @rep:paraminfo {@rep:required}
785 * @param p_attribute11 Descriptive flexfield segment
786 * @rep:paraminfo {@rep:required}
787 * @param p_attribute12 Descriptive flexfield segment
788 * @rep:paraminfo {@rep:required}
789 * @param p_attribute13 Descriptive flexfield segment
790 * @rep:paraminfo {@rep:required}
791 * @param p_attribute14 Descriptive flexfield segment
792 * @rep:paraminfo {@rep:required}
793 * @param p_attribute15 Descriptive flexfield segment
794 * @rep:paraminfo {@rep:required}
795 * @param p_raw_cost_source The reference code that identifies the raw cost source
796 * @rep:paraminfo {@rep:required}
797 * @param p_burdened_cost_source The reference code that identifies the burdenend cost source
798 * @rep:paraminfo {@rep:required}
799 * @param p_quantity_source The reference code that identifies the quantity
800 * @rep:paraminfo {@rep:required}
801 * @rep:scope public
802 * @rep:lifecycle active
803 * @rep:displayname Update Budget Line
804 * @rep:compatibility S
805 */
806 PROCEDURE update_budget_line
807 ( p_api_version_number IN NUMBER
808 ,x_err_code IN OUT NOCOPY NUMBER
809 ,x_err_stage IN OUT NOCOPY VARCHAR2
810 ,x_err_stack IN OUT NOCOPY VARCHAR2
811 ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
812 ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
813 ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
814 ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
815 ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
816 ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
817 ,p_task_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
818 ,p_task_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
819 ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
820 ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
821 ,p_resource_alias IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
822 ,p_resource_list_member_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
823 ,p_budget_start_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
824 ,p_budget_end_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
825 ,p_period_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
826 ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
827 ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
828 ,p_raw_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
829 ,p_burdened_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
830 ,p_quantity IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
831 ,p_unit_of_measure IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
832 ,p_track_as_labor_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
833 ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
834 ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
835 ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
836 ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
837 ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
841 ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
838 ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
839 ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
840 ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
842 ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
843 ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
844 ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
845 ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
846 ,p_attribute13 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
847 ,p_attribute14 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
848 ,p_attribute15 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
849 ,p_raw_cost_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
850 ,p_burdened_cost_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
851 ,p_quantity_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR );
852
853 /*#
854 * This procedure validates the award budget.
855 * @param x_budget_version_id The reference code that uniquely identifies the budget version
856 * @rep:paraminfo {@rep:required}
857 * @param x_project_id The reference code that uniquely identifies the project
858 * @rep:paraminfo {@rep:required}
859 * @param x_task_id The reference code that uniquely identifies the task within a project
860 * @rep:paraminfo {@rep:required}
861 * @param x_award_id The reference code that uniquely identifies the award in Oracle Grants Accounting
862 * @rep:paraminfo {@rep:required}
863 * @param x_resource_list_member_id The reference code that identifies the resource list member
864 * @rep:paraminfo {@rep:required}
865 * @param x_start_date The reference code that identifies the budget start date
866 * @rep:paraminfo {@rep:required}
867 * @param x_end_date The reference code that identifies the budget end date
868 * @rep:paraminfo {@rep:required}
869 * @param x_return_status The return status which indicates whether budget is valid or not
870 * @rep:paraminfo {@rep:required}
871 * @param x_calling_form The reference code which identifies from where this procedure is
872 * called
873 * @rep:paraminfo {@rep:required}
874 * @rep:scope public
875 * @rep:lifecycle active
876 * @rep:displayname Validate Budget
877 * @rep:compatibility S
878 */
879 PROCEDURE validate_budget( x_budget_version_id in NUMBER,
880 x_award_id in NUMBER,
881 x_project_id in NUMBER,
882 x_task_id in NUMBER default NULL,
883 x_resource_list_member_id in NUMBER default NULL,
884 x_start_date in DATE,
885 x_end_date in DATE,
886 x_return_status in out NOCOPY NUMBER,
887 x_calling_form IN VARCHAR2 default NULL); /* For Bug 4965360 */
888
889 /*
890 PROCEDURE Calculate_Amounts
891 ( p_api_version_number IN NUMBER
892 ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
893 ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
894 ,p_msg_count OUT NOCOPY NUMBER
895 ,p_msg_data OUT NOCOPY VARCHAR2
896 ,p_return_status OUT NOCOPY VARCHAR2
897 ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
898 ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
899 ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
900 ,p_pm_project_reference IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
901 ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
902 ,p_calc_raw_cost_yn IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
903 ,p_calc_burdened_cost_yn IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
904 ,p_update_db_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
905 ,p_calc_budget_lines_out OUT NOCOPY calc_budget_line_out_tbl_type );
906
907 */
908 end GMS_BUDGET_PUB;
[Home] [Help]