1 package PA_AGREEMENT_PUB AUTHID DEFINER as
2 /*$Header: PAAFAPBS.pls 120.8 2010/07/16 21:25:51 mumohan ship $*/
3 /*#
4 * This package contains the public APIs for agreement and funding
5 * procedures that are used by the external system.
6 * @rep:scope public
7 * @rep:product PA
8 * @rep:lifecycle active
9 * @rep:displayname Create Agreement
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY PA_AGREEMENT
12 * @rep:category BUSINESS_ENTITY PA_INVOICE
13 * @rep:category BUSINESS_ENTITY PA_REVENUE
14 * @rep:category BUSINESS_ENTITY PA_PROJECT
15 * @rep:doccd 120pjapi.pdf See the Oracle Projects API's, Client Extensions, and Open Interfaces Reference
16 */
17 --Package constant used for package version validation
18 G_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
19
20 --Locking exception
21 ROW_ALREADY_LOCKED EXCEPTION;
22 PRAGMA EXCEPTION_INIT(ROW_ALREADY_LOCKED, -54);
23
24
25 -- Agreement_Rec_In_Type
26 TYPE agreement_rec_in_type is RECORD
27 (pm_agreement_reference VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
28 agreement_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
29 customer_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
30 customer_num VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
31 /* Commented out for enhancement 1593520
32 agreement_num VARCHAR2(20) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, */
33 /* Added the new sized agreement_num variable for enhancement 1593520 */
34 agreement_num PA_AGREEMENTS_ALL.agreement_num%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
35 /* Till here */
36 agreement_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
37 amount NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
38 term_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
39 revenue_limit_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
40 expiration_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
41 description VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
42 owned_by_person_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
43 desc_flex_name VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
44 attribute_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
45 attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
46 attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
47 attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
48 attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
49 attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
50 attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
51 attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
52 attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
53 attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
54 attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
55 template_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
56 owning_organization_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
57 agreement_currency_code VARCHAR2(15) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
58 invoice_limit_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
59 /*Federal*/
60 customer_order_number VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
61 advance_required VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
62 start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
63 Billing_sequence NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
64 line_of_account VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
65 attribute11 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
66 attribute12 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
67 attribute13 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
68 attribute14 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
69 attribute15 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
70 attribute16 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
71 attribute17 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
72 attribute18 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
73 attribute19 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
74 attribute20 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
75 attribute21 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
76 attribute22 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
77 attribute23 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
78 attribute24 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
79 attribute25 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
80
81 );
82 -- Agreement_Rec_Out_Type
83 TYPE agreement_rec_out_type is RECORD
84 (
85 agreement_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
86 customer_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
87 return_status VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
88 );
89
90
91 -- Funding_Rec_In_Type
92 TYPE funding_rec_in_type is RECORD
93 (
94 pm_funding_reference VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
95 project_funding_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
96 agreement_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
97 project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
98 task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
99 allocated_amount NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
100 date_allocated DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
104 attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
101 desc_flex_name VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
102 attribute_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
103 attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
105 attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
106 attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
107 attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
108 attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
109 attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
110 attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
111 attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
112 attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
113 project_rate_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
114 project_rate_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
115 project_exchange_rate NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
116 projfunc_rate_type VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
117 projfunc_rate_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
118 projfunc_exchange_rate NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
119 funding_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR /* For Bug2244796 */
120 );
121
122
123 -- Funding_Rec_Out_Type
124 TYPE funding_rec_out_type IS RECORD
125 (
126 project_funding_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
127 return_status VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
128 );
129
130 -- Funding_In_Tbl_Type
131 TYPE funding_in_tbl_type is TABLE of funding_rec_in_type
132 index by binary_integer;
133
134 -- Funding_Out_Tbl_Type
135 TYPE funding_out_tbl_type is TABLE of funding_rec_out_type
136 index by binary_integer;
137
138
139 --Globals to be used by the LOAD/EXECUTE/FETCH process
140
141 --IN types
142 G_agreement_in_null_rec agreement_rec_in_type;
143 G_agreement_in_rec agreement_rec_in_type;
144 G_funding_in_tbl funding_in_tbl_type;
145 G_funding_tbl_count NUMBER := 0;
146
147 --OUT types
148 G_agreement_out_null_rec agreement_rec_out_type;
149 G_agreement_out_rec agreement_rec_out_type;
150 G_funding_out_tbl funding_out_tbl_type;
151
152 /*#
153 * This API creates an agreement with associated funds from the external system.
154 * @param p_api_version_number API standard: version number
155 * @rep:paraminfo {@rep:required}
156 * @param p_commit API standard (default = F) indicates if transcation will be committed
157 * @rep:paraminfo {@rep:precision 1} {@rep:required}
158 * @param p_init_msg_list API standard (default = F) indicates if message stack will be initialized
159 * @rep:paraminfo {@rep:precision 1} {@rep:required}
160 * @param p_msg_count API standard: number of error messages
161 * @rep:paraminfo {@rep:required}
162 * @param p_msg_data API standard: error message
163 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
164 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
165 * @rep:paraminfo {@rep:precision 1} {@rep:required}
166 * @param p_pm_product_code Identifier of the external system from which the project was imported
167 * @rep:paraminfo {@rep:precision 25} {@rep:required}
168 * @param p_agreement_in_rec The agreement input record for Oracle Projects
169 * @rep:paraminfo {@rep:required}
170 * @param p_agreement_out_rec The agreement output record from Oracle Projects
171 * @rep:paraminfo {@rep:required}
172 * @param p_funding_in_tbl The funding input table of records for Oracle Projects
173 * @rep:paraminfo {@rep:required}
174 * @param p_funding_out_tbl The funding output table of records from Oracle Projects
175 * @rep:paraminfo {@rep:required}
176 * @rep:scope public
177 * @rep:lifecycle active
178 * @rep:displayname Create Project Agreement
179 * @rep:compatibility S
180 */
181 PROCEDURE create_agreement
182 (p_api_version_number IN NUMBER -- :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
183 ,p_commit IN VARCHAR2 -- := FND_API.G_FALSE
184 ,p_init_msg_list IN VARCHAR2 -- := FND_API.G_FALSE
185 ,P_msg_count OUT NOCOPY NUMBER /*file.sql.39*/
186 ,P_msg_data OUT NOCOPY VARCHAR2 /*file.sql.39*/
187 ,P_return_status OUT NOCOPY VARCHAR2 /*file.sql.39*/
188 ,p_pm_product_code IN VARCHAR2 -- := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
189 ,p_agreement_in_rec IN Agreement_Rec_In_Type
190 ,p_agreement_out_rec OUT NOCOPY Agreement_Rec_Out_Type /*file.sql.39*/
191 ,p_funding_in_tbl IN funding_in_tbl_type
192 ,p_funding_out_tbl OUT NOCOPY funding_out_tbl_type /*file.sql.39*/
193 );
194
195 /*#
196 * This API deletes an agreement with associated funds from the external system.
197 * @param p_api_version_number API standard: version number
198 * @rep:paraminfo {@rep:required}
199 * @param p_commit API standard (default = F) indicates if transcation will be committed
200 * @rep:paraminfo {@rep:precision 1} {@rep:required}
201 * @param p_init_msg_list API standard (default = F) indicates if message stack will be initialized
202 * @rep:paraminfo {@rep:precision 1} {@rep:required}
203 * @param p_msg_count API standard: number of error messages
204 * @rep:paraminfo {@rep:required}
205 * @param p_msg_data API standard: error message
206 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
207 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
208 * @rep:paraminfo {@rep:precision 1} {@rep:required}
209 * @param p_pm_product_code Identifier of the external system from which the project was imported
210 * @rep:paraminfo {@rep:precision 25} {@rep:required}
214 * @rep:paraminfo {@rep:required}
211 * @param p_pm_agreement_reference The reference code that uniquely identifies the agreement in the external system
212 * @rep:paraminfo {@rep:required}
213 * @param p_agreement_id The reference code that uniquely identifies the agreement in Oracle Projects
215 * @rep:scope public
216 * @rep:lifecycle active
217 * @rep:displayname Delete Project Agreement
218 * @rep:compatibility S
219 */
220 PROCEDURE delete_agreement
221 (p_api_version_number IN NUMBER
222 ,p_commit IN VARCHAR2
223 ,p_init_msg_list IN VARCHAR2
224 ,p_msg_count OUT NOCOPY NUMBER /*file.sql.39*/
225 ,p_msg_data OUT NOCOPY VARCHAR2 /*file.sql.39*/
226 ,p_return_status OUT NOCOPY VARCHAR2 /*file.sql.39*/
227 ,p_pm_product_code IN VARCHAR2
228 ,p_pm_agreement_reference IN VARCHAR2
229 ,p_agreement_id IN NUMBER
230 );
231
232 /*#
233 * This API updates an agreement and associated funds.
234 * @param p_api_version_number API standard: version number
235 * @rep:paraminfo {@rep:required}
236 * @param p_commit API standard (default = F) indicates if transcation will be committed
237 * @rep:paraminfo {@rep:precision 1} {@rep:required}
238 * @param p_init_msg_list API standard (default = F) indicates if message stack will be initialized
239 * @rep:paraminfo {@rep:precision 1} {@rep:required}
240 * @param p_msg_count API standard: number of error messages
241 * @rep:paraminfo {@rep:required}
242 * @param p_msg_data API standard: error message
243 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
244 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
245 * @rep:paraminfo {@rep:precision 1} {@rep:required}
246 * @param p_pm_product_code Identifier of the external system from which the project was imported
247 * @rep:paraminfo {@rep:precision 25} {@rep:required}
248 * @param p_agreement_in_rec The reference code that uniquely identifies the agreement input record in Oracle Projects
249 * @rep:paraminfo {@rep:required}
250 * @param p_agreement_out_rec The reference code that uniquely identifies the agreement output record in Oracle Projects
251 * @rep:paraminfo {@rep:required}
252 * @param p_funding_in_tbl The reference code that uniquely identifies the funding input record for Oracle Projects
253 * @rep:paraminfo {@rep:required}
254 * @param p_funding_out_tbl The reference code that uniquely identifies the funding output record for Oracle Projects
255 * @rep:paraminfo {@rep:required}
256 * @rep:scope public
257 * @rep:lifecycle active
258 * @rep:displayname Update Project Agreement
259 * @rep:compatibility S
260 */
261 PROCEDURE update_agreement
262 (p_api_version_number IN NUMBER
263 ,p_commit IN VARCHAR2
264 ,p_init_msg_list IN VARCHAR2
265 ,p_msg_count OUT NOCOPY NUMBER /*file.sql.39*/
266 ,p_msg_data OUT NOCOPY VARCHAR2 /*file.sql.39*/
267 ,p_return_status OUT NOCOPY VARCHAR2 /*file.sql.39*/
268 ,p_pm_product_code IN VARCHAR2
269 ,p_agreement_in_rec IN Agreement_Rec_In_Type
270 ,p_agreement_out_rec OUT NOCOPY Agreement_Rec_Out_Type /*file.sql.39*/
271 ,p_funding_in_tbl IN funding_in_tbl_type
272 ,p_funding_out_tbl OUT NOCOPY funding_out_tbl_type /*file.sql.39*/
273 );
274
275 /*#
276 * This API adds funding to an agreement.
277 * @param p_api_version_number API standard: version number
278 * @rep:paraminfo {@rep:required}
279 * @param p_commit API standard (default = F) indicates if transcation will be committed
280 * @rep:paraminfo {@rep:precision 1} {@rep:required}
281 * @param p_init_msg_list API standard (default = F) indicates if message stack will be initialized
282 * @rep:paraminfo {@rep:precision 1} {@rep:required}
283 * @param p_msg_count API standard: number of error messages
284 * @rep:paraminfo {@rep:required}
285 * @param p_msg_data API standard: error message
286 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
287 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
288 * @rep:paraminfo {@rep:precision 1} {@rep:required}
289 * @param p_pm_product_code Identifier of the external system from which the project was imported
290 * @rep:paraminfo {@rep:precision 25} {@rep:required}
291 * @param p_pm_funding_reference Unique reference code that identifies the project/agreement funding in the external system
292 * @rep:paraminfo {@rep:required}
293 * @param p_funding_id The reference code that uniquely identifies the funding in Oracle Projects
294 * @rep:paraminfo {@rep:required}
295 * @param p_pa_project_id The reference code that uniquely identifies the project in Oracle Projects
296 * @rep:paraminfo {@rep:required}
297 * @param p_pa_task_id The reference code that uniquely identifies the task in a project in Oracle Projects
298 * @rep:paraminfo {@rep:required}
299 * @param p_agreement_id The reference code that uniquely identifies the agreement in Oracle Projects
300 * @rep:paraminfo {@rep:required}
301 * @param p_allocated_amount The reference code that uniquely identifies the allocated funding amount in a project in Oracle Projects
302 * @rep:paraminfo {@rep:required}
303 * @param p_date_allocated The reference code that uniquely identifies the date allocated in a project in Oracle Projects
304 * @rep:paraminfo {@rep:required}
305 * @param p_desc_flex_name Descriptive flexfield name
306 * @rep:paraminfo {@rep:required}
307 * @param p_attribute_category Descriptive flexfield category
308 * @rep:paraminfo {@rep:required}
309 * @param p_attribute1 Descriptive flexfield segment
310 * @rep:paraminfo {@rep:required}
311 * @param p_attribute2 Descriptive flexfield segment
312 * @rep:paraminfo {@rep:required}
313 * @param p_attribute3 Descriptive flexfield segment
314 * @rep:paraminfo {@rep:required}
315 * @param p_attribute4 Descriptive flexfield segment
316 * @rep:paraminfo {@rep:required}
320 * @rep:paraminfo {@rep:required}
317 * @param p_attribute5 Descriptive flexfield segment
318 * @rep:paraminfo {@rep:required}
319 * @param p_attribute6 Descriptive flexfield segment
321 * @param p_attribute7 Descriptive flexfield segment
322 * @rep:paraminfo {@rep:required}
323 * @param p_attribute8 Descriptive flexfield segment
324 * @rep:paraminfo {@rep:required}
325 * @param p_attribute9 Descriptive flexfield segment
326 * @rep:paraminfo {@rep:required}
327 * @param p_attribute10 Descriptive flexfield segment
328 * @rep:paraminfo {@rep:required}
329 * @param p_funding_id_out The reference code that uniquely identifies the funding in a project in Oracle Projects
330 * @rep:paraminfo {@rep:required}
331 * @param p_project_rate_type Exchange rate type to use for conversion from funding currency to project currency
332 * @rep:paraminfo {@rep:required}
333 * @param p_project_rate_date Exchange rate date to use for conversion from funding currency to project currency
334 * @rep:paraminfo {@rep:required}
335 * @param p_project_exchange_rate Exchange rate to use for conversion from funding currency to project currency
336 * @rep:paraminfo {@rep:required}
337 * @param p_projfunc_rate_type Exchange rate type to use for conversion from funding currency to project functional currency
338 * @rep:paraminfo {@rep:required}
339 * @param p_projfunc_rate_date Exchange rate date to use for conversion from funding currency to project functional currency
340 * @rep:paraminfo {@rep:required}
341 * @param p_projfunc_exchange_rate Exchange rate to use for conversion from funding currency to project functional currency
342 * @rep:paraminfo {@rep:required}
343 * @param p_funding_category Identifier of the funding line
344 * @rep:paraminfo {@rep:required}
345 * @rep:scope public
346 * @rep:lifecycle active
347 * @rep:displayname Create Project Funding
348 * @rep:compatibility S
349 */
350 /* Added MCB2 Columns */
351 PROCEDURE add_funding
352 (p_api_version_number IN NUMBER
353 ,p_commit IN VARCHAR2
354 ,p_init_msg_list IN VARCHAR2
355 ,p_msg_count OUT NOCOPY NUMBER /*file.sql.39*/
356 ,p_msg_data OUT NOCOPY VARCHAR2 /*file.sql.39*/
357 ,p_return_status OUT NOCOPY VARCHAR2 /*file.sql.39*/
358 ,p_pm_product_code IN VARCHAR2
359 ,p_pm_funding_reference IN VARCHAR2
360 ,p_funding_id IN OUT NOCOPY NUMBER /*file.sql.39*/
361 ,p_pa_project_id IN NUMBER
362 ,p_pa_task_id IN NUMBER
363 ,p_agreement_id IN NUMBER
364 ,p_allocated_amount IN NUMBER
365 ,p_date_allocated IN DATE
366 ,p_desc_flex_name IN VARCHAR2
367 ,p_attribute_category IN VARCHAR2
368 ,p_attribute1 IN VARCHAR2
369 ,p_attribute2 IN VARCHAR2
370 ,p_attribute3 IN VARCHAR2
371 ,p_attribute4 IN VARCHAR2
372 ,p_attribute5 IN VARCHAR2
373 ,p_attribute6 IN VARCHAR2
374 ,p_attribute7 IN VARCHAR2
375 ,p_attribute8 IN VARCHAR2
376 ,p_attribute9 IN VARCHAR2
377 ,p_attribute10 IN VARCHAR2
378 ,p_funding_id_out OUT NOCOPY NUMBER /*file.sql.39*/
379 ,p_project_rate_type IN VARCHAR2 DEFAULT NULL
380 ,p_project_rate_date IN DATE DEFAULT NULL
381 ,p_project_exchange_rate IN NUMBER DEFAULT NULL
382 ,p_projfunc_rate_type IN VARCHAR2 DEFAULT NULL
383 ,p_projfunc_rate_date IN DATE DEFAULT NULL
384 ,p_projfunc_exchange_rate IN NUMBER DEFAULT NULL
385 ,p_funding_category IN VARCHAR2 DEFAULT 'ADDITIONAL' /* Added default for bug 2483081- For Bug2244796 */
386 );
387
388 /*#
389 * This API deletes a fund from an agreement.
390 * @param p_api_version_number API standard: version number
391 * @rep:paraminfo {@rep:required}
392 * @param p_commit API standard (default = F) indicates if transcation will be committed
393 * @rep:paraminfo {@rep:precision 1} {@rep:required}
394 * @param p_init_msg_list API standard (default = F) indicates if message stack will be initialized
395 * @rep:paraminfo {@rep:precision 1} {@rep:required}
396 * @param p_msg_count API standard: number of error messages
397 * @rep:paraminfo {@rep:required}
398 * @param p_msg_data API standard: error message
399 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
400 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
401 * @rep:paraminfo {@rep:precision 1} {@rep:required}
402 * @param p_pm_product_code Identifier of the external system from which the project was imported
403 * @rep:paraminfo {@rep:precision 25} {@rep:required}
404 * @param p_pm_funding_reference Unique reference code that identifies funding in the external system
405 * @rep:paraminfo {@rep:required}
406 * @param p_funding_id The reference code that uniquely identifies the funding in a project in Oracle Projects
407 * @rep:paraminfo {@rep:required}
408 * @param p_check_y_n Flag indicating if funding should be validated before deletion
409 * @rep:scope public
410 * @rep:lifecycle active
411 * @rep:displayname Delete Project Funding
412 * @rep:compatibility S
413 */
414 PROCEDURE delete_funding
415 (p_api_version_number IN NUMBER
416 ,p_commit IN VARCHAR2
417 ,p_init_msg_list IN VARCHAR2
418 ,p_msg_count OUT NOCOPY NUMBER /*file.sql.39*/
419 ,p_msg_data OUT NOCOPY VARCHAR2 /*file.sql.39*/
420 ,p_return_status OUT NOCOPY VARCHAR2 /*file.sql.39*/
421 ,p_pm_product_code IN VARCHAR2
422 ,p_pm_funding_reference IN VARCHAR2
423 ,p_funding_id IN NUMBER
424 ,p_check_y_n IN VARCHAR2 DEFAULT 'Y'
425 );
426
427 /*#
428 * This API updates a fund for an agreement
432 * @rep:paraminfo {@rep:precision 1} {@rep:required}
429 * @param p_api_version_number API standard: version number
430 * @rep:paraminfo {@rep:required}
431 * @param p_commit API standard (default = F) indicates if transcation will be committed
433 * @param p_init_msg_list API standard (default = F) indicates if message stack will be initialized
434 * @rep:paraminfo {@rep:precision 1} {@rep:required}
435 * @param p_msg_count API standard: number of error messages
436 * @rep:paraminfo {@rep:required}
437 * @param p_msg_data API standard: error message
438 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
439 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
440 * @rep:paraminfo {@rep:precision 1} {@rep:required}
441 * @param p_pm_product_code Identifier of the external system from which the project was imported
442 * @rep:paraminfo {@rep:precision 25} {@rep:required}
443 * @param p_pm_funding_reference The reference code that uniquely identifies the funding in the external system
444 * @rep:paraminfo {@rep:required}
445 * @param p_funding_id The reference code that uniquely identifies the funding in Oracle Projects
446 * @rep:paraminfo {@rep:required}
447 * @param p_project_id The reference code that uniquely identifies the project in Oracle Projects
448 * @rep:paraminfo {@rep:required}
449 * @param p_task_id The reference code that uniquely identifies the task within a project in Oracle Projects
450 * @rep:paraminfo {@rep:required}
451 * @param p_agreement_id The reference code that uniquely identifies the agreement in Oracle Projects
452 * @rep:paraminfo {@rep:required}
453 * @param p_allocated_amount The reference code that uniquely identifies the allocated funding amount in a project in Oracle Projects
454 * @rep:paraminfo {@rep:required}
455 * @param p_date_allocated The reference code that uniquely identifies the date allocated in a project in Oracle Projects
456 * @rep:paraminfo {@rep:required}
457 * @param p_desc_flex_name Descriptive flexfield name
458 * @rep:paraminfo {@rep:required}
459 * @param p_attribute_category Descriptive flexfield category
460 * @rep:paraminfo {@rep:required}
461 * @param p_attribute1 Descriptive flexfield segment
462 * @rep:paraminfo {@rep:required}
463 * @param p_attribute2 Descriptive flexfield segment
464 * @rep:paraminfo {@rep:required}
465 * @param p_attribute3 Descriptive flexfield segment
466 * @rep:paraminfo {@rep:required}
467 * @param p_attribute4 Descriptive flexfield segment
468 * @rep:paraminfo {@rep:required}
469 * @param p_attribute5 Descriptive flexfield segment
470 * @rep:paraminfo {@rep:required}
471 * @param p_attribute6 Descriptive flexfield segment
472 * @rep:paraminfo {@rep:required}
473 * @param p_attribute7 Descriptive flexfield segment
474 * @rep:paraminfo {@rep:required}
475 * @param p_attribute8 Descriptive flexfield segment
476 * @rep:paraminfo {@rep:required}
477 * @param p_attribute9 Descriptive flexfield segment
478 * @rep:paraminfo {@rep:required}
479 * @param p_attribute10 Descriptive flexfield segment
480 * @rep:paraminfo {@rep:required}
481 * @param p_funding_id_out The reference code that uniquely identifies the funding in a project in Oracle Projects
482 * @rep:paraminfo {@rep:required}
483 * @param p_project_rate_type Exchange rate type to use for conversion from funding currency to project currency
484 * @rep:paraminfo {@rep:required}
485 * @param p_project_rate_date Exchange rate date to use for conversion from funding currency to project currency
486 * @rep:paraminfo {@rep:required}
487 * @param p_project_exchange_rate Exchange rate to use for conversion from funding currency to project currency
488 * @rep:paraminfo {@rep:required}
489 * @param p_projfunc_rate_type Exchange rate type to use for conversion from funding currency to project functional currency
490 * @rep:paraminfo {@rep:required}
491 * @param p_projfunc_rate_date Exchange rate date to use for conversion from funding currency to project functional currency
492 * @rep:paraminfo {@rep:required}
493 * @param p_projfunc_exchange_rate Exchange rate to use for conversion from funding currency to project functional currency
494 * @rep:paraminfo {@rep:required}
495 * @param p_funding_category Identifier of the funding line
496 * @rep:scope public
497 * @rep:lifecycle active
498 * @rep:displayname Update Project Funding
499 * @rep:compatibility S
500 */
501 /* Added MCB2 Columns */
502 PROCEDURE update_funding
503 (p_api_version_number IN NUMBER
504 ,p_commit IN VARCHAR2
505 ,p_init_msg_list IN VARCHAR2
506 ,p_msg_count OUT NOCOPY NUMBER /*file.sql.39*/
507 ,p_msg_data OUT NOCOPY VARCHAR2 /*file.sql.39*/
508 ,p_return_status OUT NOCOPY VARCHAR2 /*file.sql.39*/
509 ,p_pm_product_code IN VARCHAR2
510 ,p_pm_funding_reference IN VARCHAR2
511 ,p_funding_id IN NUMBER
512 ,p_project_id IN NUMBER
513 ,p_task_id IN NUMBER
514 ,p_agreement_id IN NUMBER
515 ,p_allocated_amount IN NUMBER
516 ,p_date_allocated IN DATE
517 ,p_desc_flex_name IN VARCHAR2
518 ,p_attribute_category IN VARCHAR2
519 ,p_attribute1 IN VARCHAR2
520 ,p_attribute2 IN VARCHAR2
521 ,p_attribute3 IN VARCHAR2
522 ,p_attribute4 IN VARCHAR2
523 ,p_attribute5 IN VARCHAR2
524 ,p_attribute6 IN VARCHAR2
525 ,p_attribute7 IN VARCHAR2
526 ,p_attribute8 IN VARCHAR2
527 ,p_attribute9 IN VARCHAR2
528 ,p_attribute10 IN VARCHAR2
529 ,p_funding_id_out OUT NOCOPY NUMBER /*file.sql.39*/
530 ,p_project_rate_type IN VARCHAR2 DEFAULT NULL
531 ,p_project_rate_date IN DATE DEFAULT NULL
532 ,p_project_exchange_rate IN NUMBER DEFAULT NULL
533 ,p_projfunc_rate_type IN VARCHAR2 DEFAULT NULL
534 ,p_projfunc_rate_date IN DATE DEFAULT NULL
535 ,p_projfunc_exchange_rate IN NUMBER DEFAULT NULL
539
536 ,p_funding_category IN VARCHAR2 DEFAULT 'ADDITIONAL' /* Added default for bug 2512483-
537 For Bug2244796 */
538 );
540 /*#
541 * This API creates a new agreement or updates an existing agreement.
542 * The API should be executed in the following order:
543 * INIT_AGREEMENT, LOAD_AGREEMENT, LOAD_FUNDING, EXECUTE_CREATE_AGREEMENT/EXECUTE_UPDATE_AGREEMENT, FETCH_FUNDING
544 * and CLEAR_AGREEMENT
545 * @rep:scope public
546 * @rep:lifecycle active
547 * @rep:displayname Create Multiple Project Agreements-Initialize
548 * @rep:compatibility S
549 */
550 PROCEDURE init_agreement;
551
552 /*#
553 * This API loads an agreement to a PL/SQL record
554 * The API should be executed in the following order:
555 * INIT_AGREEMENT, LOAD_AGREEMENT, LOAD_FUNDING, EXECUTE_CREATE_AGREEMENT/EXECUTE_UPDATE_AGREEMENT, FETCH_FUNDING
556 * and CLEAR_AGREEMENT
557 * @param p_api_version_number API standard: version number
558 * @rep:paraminfo {@rep:required}
559 * @param p_init_msg_list API standard (default = F) indicates if message stack will be initialized
560 * @rep:paraminfo {@rep:precision 1} {@rep:required}
561 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
562 * @rep:paraminfo {@rep:precision 1} {@rep:required}
563 * @param p_pm_agreement_reference The reference code that uniquely identifies the agreement in the external system
564 * @rep:paraminfo {@rep:required}
565 * @param p_agreement_id The reference code that uniquely identifies the agreement in a project in Oracle Projects
566 * @rep:paraminfo {@rep:required}
567 * @param p_customer_id The identification code of the project customer in Oracle Projects
568 * @rep:paraminfo {@rep:required}
569 * @param p_customer_name Name identifying the project customer in Oracle Projects
570 * @rep:paraminfo {@rep:required}
571 * @param p_customer_num Number identifying the project customer in Oracle Projects
572 * @rep:paraminfo {@rep:required}
573 * @param p_agreement_num The reference code that uniquely identifies the agreement number in a project in Oracle Projects
574 * @rep:paraminfo {@rep:required}
575 * @param p_agreement_type The reference code that uniquely identifies the agreement type in a project in Oracle Projects
576 * @rep:paraminfo {@rep:required}
577 * @param p_amount The reference code that uniquely identifies the amount of the agreement in a project in Oracle Projects
578 * @rep:paraminfo {@rep:required}
579 * @param p_term_id The reference code that uniquely identifies the terms of the agreement in a project in Oracle Projects
580 * @rep:paraminfo {@rep:required}
581 * @param p_term_name The name that uniquely identifies the term of the agreement in a project in Oracle Projects
582 * @rep:paraminfo {@rep:required}
583 * @param p_revenue_limit_flag Flag indicating whether or not the revenue limit has been exceeded
584 * @rep:paraminfo {@rep:precision 1} {@rep:required}
585 * @param p_expiration_date The expiration date of the agreement for a project in Oracle Projects
586 * @rep:paraminfo {@rep:required}
587 * @param p_description Description of the agreement in a project in Oracle Projects
588 * @rep:paraminfo {@rep:required}
589 * @param p_owned_by_person_id The reference code that uniquely identifies the person who owns the agreement in a project in Oracle Projects
590 * @rep:paraminfo {@rep:required}
591 * @param p_owned_by_person_name The name that uniquely identifies the person who owns the agreement in a project in Oracle Projects
592 * @rep:paraminfo {@rep:required}
593 * @param p_attribute_category Descriptive flexfield category
594 * @rep:paraminfo {@rep:required}
595 * @param p_attribute1 Descriptive flexfield segment
596 * @rep:paraminfo {@rep:required}
597 * @param p_attribute2 Descriptive flexfield segment
598 * @rep:paraminfo {@rep:required}
599 * @param p_attribute3 Descriptive flexfield segment
600 * @rep:paraminfo {@rep:required}
601 * @param p_attribute4 Descriptive flexfield segment
602 * @rep:paraminfo {@rep:required}
603 * @param p_attribute5 Descriptive flexfield segment
604 * @rep:paraminfo {@rep:required}
605 * @param p_attribute6 Descriptive flexfield segment
606 * @rep:paraminfo {@rep:required}
607 * @param p_attribute7 Descriptive flexfield segment
608 * @rep:paraminfo {@rep:required}
609 * @param p_attribute8 Descriptive flexfield segment
610 * @rep:paraminfo {@rep:required}
611 * @param p_attribute9 Descriptive flexfield segment
612 * @rep:paraminfo {@rep:required}
613 * @param p_attribute10 Descriptive flexfield segment
614 * @rep:paraminfo {@rep:required}
615 * @param p_template_flag Indicates whether or not the project is a template
616 * @rep:paraminfo {@rep:precision 1} {@rep:required}
617 * @param p_desc_flex_name Descriptive flexfield name
618 * @rep:paraminfo {@rep:required}
619 * @param p_owning_organization_id Identifier of the organization that is responsible for the project work
620 * @rep:paraminfo {@rep:required}
621 * @param p_agreement_currency_code Specifies agreement currency code of the agreement
622 * @rep:paraminfo {@rep:required}
623 * @param p_invoice_limit_flag Flag indicating whether invoices for projects funded by this agreement can exceed the allocated
624 * funding amount
625 * @rep:paraminfo {@rep:required}
626 * @param p_customer_order_number Represents the Customer Order Number for the reimbursable Agreement
627 * @rep:paraminfo {@rep:required}
628 * @param p_advance_required Indicates whether agreement amount or receipt amount from AR to be used.
629 * @rep:paraminfo {@rep:required}
630 * @param p_start_date The Start date of the agreement for a project in Oracle Projects
631 * @rep:paraminfo {@rep:required}
632 * @param p_billing_sequence Indicates in which order agreement to be consumed
633 * @rep:paraminfo {@rep:required}
634 * @param p_line_of_account Represents the accounting string that the customer agency is using to fund the agreement
635 * @rep:paraminfo {@rep:required}
639 * @rep:paraminfo {@rep:required}
636 * @param p_attribute11 Descriptive flexfield segment
637 * @rep:paraminfo {@rep:required}
638 * @param p_attribute12 Descriptive flexfield segment
640 * @param p_attribute13 Descriptive flexfield segment
641 * @rep:paraminfo {@rep:required}
642 * @param p_attribute14 Descriptive flexfield segment
643 * @rep:paraminfo {@rep:required}
644 * @param p_attribute15 Descriptive flexfield segment
645 * @rep:paraminfo {@rep:required}
646 * @param p_attribute16 Descriptive flexfield segment
647 * @rep:paraminfo {@rep:required}
648 * @param p_attribute17 Descriptive flexfield segment
649 * @rep:paraminfo {@rep:required}
650 * @param p_attribute18 Descriptive flexfield segment
651 * @rep:paraminfo {@rep:required}
652 * @param p_attribute19 Descriptive flexfield segment
653 * @rep:paraminfo {@rep:required}
654 * @param p_attribute20 Descriptive flexfield segment
655 * @rep:paraminfo {@rep:required}
656 * @param p_attribute21 Descriptive flexfield segment
657 * @rep:paraminfo {@rep:required}
658 * @param p_attribute22 Descriptive flexfield segment
659 * @rep:paraminfo {@rep:required}
660 * @param p_attribute23 Descriptive flexfield segment
661 * @rep:paraminfo {@rep:required}
662 * @param p_attribute24 Descriptive flexfield segment
663 * @rep:paraminfo {@rep:required}
664 * @param p_attribute25 Descriptive flexfield segment
665 * @rep:paraminfo {@rep:required}
666 * @rep:scope public
667 * @rep:lifecycle active
668 * @rep:displayname Create Multiple Project Agreements-Load
669 * @rep:compatibility S
670 */
671 PROCEDURE load_agreement
672 (p_api_version_number IN NUMBER
673 ,p_init_msg_list IN VARCHAR2
674 ,p_return_status OUT NOCOPY VARCHAR2 /*file.sql.39*/
675 ,p_pm_agreement_reference IN VARCHAR2
676 ,p_agreement_id IN NUMBER
677 ,p_customer_id IN NUMBER
678 ,p_customer_name IN VARCHAR2
679 ,p_customer_num IN VARCHAR2
680 ,p_agreement_num IN VARCHAR2
681 ,p_agreement_type IN VARCHAR2
682 ,p_amount IN NUMBER
683 ,p_term_id IN NUMBER
684 ,p_term_name IN VARCHAR2
685 ,p_revenue_limit_flag IN VARCHAR2
686 ,p_expiration_date IN DATE
687 ,p_description IN VARCHAR2
688 ,p_owned_by_person_id IN NUMBER
689 ,p_owned_by_person_name IN VARCHAR2
690 ,p_attribute_category IN VARCHAR2
691 ,p_attribute1 IN VARCHAR2
692 ,p_attribute2 IN VARCHAR2
693 ,p_attribute3 IN VARCHAR2
694 ,p_attribute4 IN VARCHAR2
695 ,p_attribute5 IN VARCHAR2
696 ,p_attribute6 IN VARCHAR2
697 ,p_attribute7 IN VARCHAR2
698 ,p_attribute8 IN VARCHAR2
699 ,p_attribute9 IN VARCHAR2
700 ,p_attribute10 IN VARCHAR2
701 ,p_template_flag IN VARCHAR2
702 ,p_desc_flex_name IN VARCHAR2
703 ,p_owning_organization_id IN NUMBER
704 ,p_agreement_currency_code IN VARCHAR2
705 ,p_invoice_limit_flag IN VARCHAR2
706 /*Federal*/
707 ,p_customer_order_number IN VARCHAR2
708 ,p_advance_required IN VARCHAR2
709 ,p_start_date IN DATE
710 ,p_billing_sequence IN NUMBER
711 ,p_line_of_account IN VARCHAR2
712 ,p_attribute11 IN VARCHAR2
713 ,p_attribute12 IN VARCHAR2
714 ,p_attribute13 IN VARCHAR2
715 ,p_attribute14 IN VARCHAR2
716 ,p_attribute15 IN VARCHAR2
717 ,p_attribute16 IN VARCHAR2
718 ,p_attribute17 IN VARCHAR2
719 ,p_attribute18 IN VARCHAR2
720 ,p_attribute19 IN VARCHAR2
721 ,p_attribute20 IN VARCHAR2
722 ,p_attribute21 IN VARCHAR2
723 ,p_attribute22 IN VARCHAR2
724 ,p_attribute23 IN VARCHAR2
725 ,p_attribute24 IN VARCHAR2
726 ,p_attribute25 IN VARCHAR2
727 );
728
729 /*#
730 * This API loads funding to a PL/SQL table
731 * The API should be executed in the following order:
732 * INIT_AGREEMENT, LOAD_AGREEMENT, LOAD_FUNDING, EXECUTE_CREATE_AGREEMENT/EXECUTE_UPDATE_AGREEMENT, FETCH_FUNDING
733 * and CLEAR_AGREEMENT
734 * @param p_api_version_number API standard: version number
735 * @rep:paraminfo {@rep:required}
736 * @param p_init_msg_list API standard (default = F) indicates if message stack will be initialized
737 * @rep:paraminfo {@rep:precision 1} {@rep:required}
738 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
739 * @rep:paraminfo {@rep:precision 1} {@rep:required}
740 * @param p_pm_funding_reference Unique reference code that identifies the funding in the external system
741 * @rep:paraminfo {@rep:required}
742 * @param p_funding_id The reference code that uniquely identifies the funding in Oracle Projects
743 * @rep:paraminfo {@rep:required}
744 * @param p_agreement_id The reference code that uniquely identifies the agreement in Oracle Projects
745 * @rep:paraminfo {@rep:required}
746 * @param p_project_id The reference code that uniquely identifies the project in Oracle Projects
747 * @rep:paraminfo {@rep:required}
748 * @param p_task_id The reference code that uniquely identifies the task in a project in Oracle Projects
749 * @rep:paraminfo {@rep:required}
750 * @param p_allocated_amount The reference code that uniquely identifies the allocated funding amount in a project in Oracle Projects
751 * @rep:paraminfo {@rep:required}
752 * @param p_date_allocated The reference code that uniquely identifies the date allocated in a project in Oracle Projects
753 * @rep:paraminfo {@rep:required}
754 * @param p_attribute_category Descriptive flexfield category
758 * @param p_attribute2 Descriptive flexfield segment
755 * @rep:paraminfo {@rep:required}
756 * @param p_attribute1 Descriptive flexfield segment
757 * @rep:paraminfo {@rep:required}
759 * @rep:paraminfo {@rep:required}
760 * @param p_attribute3 Descriptive flexfield segment
761 * @rep:paraminfo {@rep:required}
762 * @param p_attribute4 Descriptive flexfield segment
763 * @rep:paraminfo {@rep:required}
764 * @param p_attribute5 Descriptive flexfield segment
765 * @rep:paraminfo {@rep:required}
766 * @param p_attribute6 Descriptive flexfield segment
767 * @rep:paraminfo {@rep:required}
768 * @param p_attribute7 Descriptive flexfield segment
769 * @rep:paraminfo {@rep:required}
770 * @param p_attribute8 Descriptive flexfield segment
771 * @rep:paraminfo {@rep:required}
772 * @param p_attribute9 Descriptive flexfield segment
773 * @rep:paraminfo {@rep:required}
774 * @param p_attribute10 Descriptive flexfield segment
775 * @rep:paraminfo {@rep:required}
776 * @param p_project_rate_type Exchange rate type to use for conversion from funding currency to project currency
777 * @rep:paraminfo {@rep:required}
778 * @param p_project_rate_date Exchange rate date to use for conversion from funding currency to project currency
779 * @rep:paraminfo {@rep:required}
780 * @param p_project_exchange_rate Exchange rate to use for conversion from funding currency to project currency
781 * @rep:paraminfo {@rep:required}
782 * @param p_projfunc_rate_type Exchange rate type to use for conversion from funding currency to project functional currency
783 * @rep:paraminfo {@rep:required}
784 * @param p_projfunc_rate_date Exchange rate date to use for conversion from funding currency to project functional currency
785 * @rep:paraminfo {@rep:required}
786 * @param p_projfunc_exchange_rate Exchange rate to use for conversion from funding currency to project functional currency
787 * @rep:paraminfo {@rep:required}
788 * @param p_funding_category Identifier of the funding line
789 * @rep:scope public
790 * @rep:lifecycle active
791 * @rep:displayname Create Multiple Project Fundings-load
792 * @rep:compatibility S
793 */
794 /* MCB2 columns added */
795 PROCEDURE load_funding
796 (p_api_version_number IN NUMBER
797 ,p_init_msg_list IN VARCHAR2
798 ,p_return_status OUT NOCOPY VARCHAR2 /*file.sql.39*/
799 ,p_pm_funding_reference IN VARCHAR2
800 ,p_funding_id IN NUMBER
801 ,p_agreement_id IN NUMBER
802 ,p_project_id IN NUMBER
803 ,p_task_id IN NUMBER
804 ,p_allocated_amount IN NUMBER
805 ,p_date_allocated IN DATE
806 ,p_attribute_category IN VARCHAR2
807 ,p_attribute1 IN VARCHAR2
808 ,p_attribute2 IN VARCHAR2
809 ,p_attribute3 IN VARCHAR2
810 ,p_attribute4 IN VARCHAR2
811 ,p_attribute5 IN VARCHAR2
812 ,p_attribute6 IN VARCHAR2
813 ,p_attribute7 IN VARCHAR2
814 ,p_attribute8 IN VARCHAR2
815 ,p_attribute9 IN VARCHAR2
816 ,p_attribute10 IN VARCHAR2
817 ,p_project_rate_type IN VARCHAR2 DEFAULT NULL
818 ,p_project_rate_date IN DATE DEFAULT NULL
819 ,p_project_exchange_rate IN NUMBER DEFAULT NULL
820 ,p_projfunc_rate_type IN VARCHAR2 DEFAULT NULL
821 ,p_projfunc_rate_date IN DATE DEFAULT NULL
822 ,p_projfunc_exchange_rate IN NUMBER DEFAULT NULL
823 ,p_funding_category IN VARCHAR2 DEFAULT 'ADDITIONAL' /* Added default for bug 2483081- For Bug2244796 */
824 );
825
826 /*#
827 * This API creates an agreement with funding using information that is stored in the global tables during the load phase.
828 * The API should be executed in the following order:
829 * INIT_AGREEMENT, LOAD_AGREEMENT, LOAD_FUNDING, EXECUTE_CREATE_AGREEMENT/EXECUTE_UPDATE_AGREEMENT, FETCH_FUNDING
830 * and CLEAR_AGREEMENT
831 * @param p_api_version_number API standard: version number
832 * @rep:paraminfo {@rep:required}
833 * @param p_commit API standard (default = F) indicates if transcation will be committed
834 * @rep:paraminfo {@rep:precision 1} {@rep:required}
835 * @param p_init_msg_list API standard (default = F) indicates if message stack will be initialized
836 * @rep:paraminfo {@rep:precision 1} {@rep:required}
837 * @param p_msg_count API standard: number of error messages
838 * @rep:paraminfo {@rep:required}
839 * @param p_msg_data API standard: error message
840 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
841 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
842 * @rep:paraminfo {@rep:precision 1} {@rep:required}
843 * @param p_pm_product_code Identifier of the external system from which the project was imported
844 * @rep:paraminfo {@rep:precision 25} {@rep:required}
845 * @param p_agreement_id_out The reference code that uniquely identifies the agreement in Oracle Projects
846 * @rep:paraminfo {@rep:required}
847 * @param p_customer_id_out The reference code that uniquely identifies the customer in Oracle Projects
848 * @rep:paraminfo {@rep:required}
849 * @rep:scope public
850 * @rep:lifecycle active
851 * @rep:displayname Create Multiple Project Agreements - Execute Create
852 * @rep:compatibility S
853 */
854 PROCEDURE execute_create_agreement
855 (p_api_version_number IN NUMBER
856 ,p_commit IN VARCHAR2
857 ,p_init_msg_list IN VARCHAR2
858 ,p_msg_count OUT NOCOPY NUMBER
859 ,p_msg_data OUT NOCOPY VARCHAR2
860 ,p_return_status OUT NOCOPY VARCHAR2
861 ,p_pm_product_code IN VARCHAR2
862 ,p_agreement_id_out OUT NOCOPY NUMBER
863 ,p_customer_id_out OUT NOCOPY NUMBER
864 );
865
866 /*#
870 AGREEMENT, FETCH_FUNDING
867 * This API updates an agreement with funding using the information that is stored in the global tables during the load phase.
868 * The API should be executed in the following order:
869 * INIT_AGREEMENT, LOAD_AGREEMENT, LOAD_FUNDING, EXECUTE_CREATE_AGREEMENT/EXECUTE_UPDATE_
871 * and CLEAR_AGREEMENT
872 * @param p_api_version_number API standard: version number
873 * @rep:paraminfo {@rep:required}
874 * @param p_commit API standard (default = F) indicates if transcation will be committed
875 * @rep:paraminfo {@rep:precision 1} {@rep:required}
876 * @param p_init_msg_list API standard (default = F) indicates if message stack will be initialized
877 * @rep:paraminfo {@rep:precision 1} {@rep:required}
878 * @param p_msg_count API standard: number of error messages
879 * @rep:paraminfo {@rep:required}
880 * @param p_msg_data API standard: error message
881 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
882 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
883 * @rep:paraminfo {@rep:precision 1} {@rep:required}
884 * @param p_pm_product_code Identifier of the external system from which the project was imported
885 * @rep:paraminfo {@rep:precision 25} {@rep:required}
886 * @rep:scope public
887 * @rep:lifecycle active
888 * @rep:displayname Update Multiple Project Agreements
889 * @rep:compatibility S
890 */
891 PROCEDURE execute_update_agreement
892 (p_api_version_number IN NUMBER
893 ,p_commit IN VARCHAR2
894 ,p_init_msg_list IN VARCHAR2
895 ,p_msg_count OUT NOCOPY NUMBER /*file.sql.39*/
896 ,p_msg_data OUT NOCOPY VARCHAR2 /*file.sql.39*/
897 ,p_return_status OUT NOCOPY VARCHAR2 /*file.sql.39*/
898 ,p_pm_product_code IN VARCHAR2
899 );
900
901 /*#
902 * This API gets the return status during creation of funds and stores this value in a global PL/SQL table.
903 * The API should be executed in the following order: INIT_AGREEMENT, LOAD_AGREEMENT, LOAD_FUNDING,
904 * EXECUTE_CREATE_AGREEMENT/EXECUTE_UPDATE_AGREEMENT, FETCH_FUNDING and CLEAR_AGREEMENT
905 * @param p_api_version_number API standard: version number
906 * @rep:paraminfo {@rep:required}
907 * @param p_init_msg_list API standard (default = F) indicates if message stack will be initialized
908 * @rep:paraminfo {@rep:precision 1} {@rep:required}
909 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
910 * @rep:paraminfo {@rep:precision 1} {@rep:required}
911 * @param p_funding_index Pointer to specific funding amount
912 * @rep:paraminfo {@rep:required}
913 * @param p_funding_id The reference code that uniquely identifies the funding in Oracle Projects
914 * @rep:paraminfo {@rep:required}
915 * @param p_pm_funding_reference The reference code that uniquely identifies the funding in the external system
916 * @rep:paraminfo {@rep:required}
917 * @rep:scope public
918 * @rep:lifecycle active
919 * @rep:displayname Create Multiple Project Fundings - Fetch
920 * @rep:compatibility S
921 */
922 PROCEDURE fetch_funding
923 (p_api_version_number IN NUMBER
924 ,p_init_msg_list IN VARCHAR2
925 ,p_return_status OUT NOCOPY VARCHAR2 /*file.sql.39*/
926 ,p_funding_index IN NUMBER
927 ,p_funding_id OUT NOCOPY NUMBER /*file.sql.39*/
928 ,p_pm_funding_reference OUT NOCOPY VARCHAR2 /*file.sql.39*/
929 );
930
931 /*#
932 * This API clears the global variables that were created during initialization.
933 * In order to execute this API the following list of API's should be executed in the order of sequence.
934 * INIT_AGREEMENT
935 * LOAD_AGREEMENT
936 * LOAD_FUNDING
937 * EXECUTE_CREATE_AGREEMENT/EXECUTE_UPDATE_AGREEMENT
938 * FETCH_FUNDING
939 * CLEAR_AGREEMENT
940 * @rep:scope public
941 * @rep:lifecycle active
942 * @rep:displayname Create Multiple Project Agreements - Clear
943 * @rep:compatibility S
944 */
945 PROCEDURE clear_agreement;
946
947 /*#
948 * This API is used to determine if an agreement can be deleted.
949 * @param p_api_version_number API standard: version number
950 * @rep:paraminfo {@rep:required}
951 * @param p_commit API standard (default = F) indicates if transcation will be committed
952 * @rep:paraminfo {@rep:precision 1} {@rep:required}
953 * @param p_init_msg_list API standard (default = F) indicates if message stack will be initialized
954 * @rep:paraminfo {@rep:precision 1} {@rep:required}
955 * @param p_msg_count API standard: number of error messages
956 * @rep:paraminfo {@rep:required}
957 * @param p_msg_data API standard: error message
958 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
959 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
960 * @rep:paraminfo {@rep:precision 1} {@rep:required}
961 * @param p_pm_agreement_reference The reference code that uniquely identifies the agreement in the external system
962 * @rep:paraminfo {@rep:required}
963 * @param p_agreement_id The reference code that uniquely identifies the agreement in a project in Oracle Projects
964 * @rep:paraminfo {@rep:required}
965 * @param p_del_agree_ok_flag Boolean flag for deleting an agreement
966 * @rep:paraminfo {@rep:precision 1} {@rep:required}
967 * @rep:scope public
968 * @rep:lifecycle active
969 * @rep:displayname Validate Project Agreement Deletion
970 * @rep:compatibility S
971 */
972 PROCEDURE check_delete_agreement_ok
973 (p_api_version_number IN NUMBER
974 ,p_commit IN VARCHAR2
975 ,p_init_msg_list IN VARCHAR2
976 ,p_msg_count OUT NOCOPY NUMBER /*file.sql.39*/
977 ,p_msg_data OUT NOCOPY VARCHAR2 /*file.sql.39*/
978 ,p_return_status OUT NOCOPY VARCHAR2 /*file.sql.39*/
979 ,p_pm_agreement_reference IN VARCHAR2
980 ,p_agreement_id IN NUMBER
981 ,p_del_agree_ok_flag OUT NOCOPY VARCHAR2 /*file.sql.39*/
982 );
986 * @param p_api_version_number API standard: version number
983
984 /*#
985 * This API is used to determine if a fund can be added.
987 * @rep:paraminfo {@rep:required}
988 * @param p_commit API standard (default = F) indicates if transcation will be committed
989 * @rep:paraminfo {@rep:precision 1} {@rep:required}
990 * @param p_init_msg_list API standard (default = F) indicates if message stack will be initialized
991 * @rep:paraminfo {@rep:precision 1} {@rep:required}
992 * @param p_msg_count API standard: number of error messages
993 * @rep:paraminfo {@rep:required}
994 * @param p_msg_data API standard: error message
995 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
996 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
997 * @rep:paraminfo {@rep:precision 1} {@rep:required}
998 * @param p_pm_agreement_reference The reference code that uniquely identifies the agreement in the external system
999 * @rep:paraminfo {@rep:required}
1000 * @param p_agreement_id The reference code that uniquely identifies the agreement in Oracle Projects
1001 * @rep:paraminfo {@rep:required}
1002 * @param p_pm_funding_reference The reference code that uniquely identifies the funding in the external system
1003 * @rep:paraminfo {@rep:required}
1004 * @param p_task_id The reference code that uniquely identifies the task in a project in Oracle Projects
1005 * @rep:paraminfo {@rep:required}
1006 * @param p_project_id The reference code that uniquely identifies the project in Oracle Projects
1007 * @rep:paraminfo {@rep:required}
1008 * @param p_add_funding_ok_flag Boolean flag for adding funding
1009 * @rep:paraminfo {@rep:precision 1} {@rep:required}
1010 * @param p_funding_amt The reference code that uniquely identifies the allocated funding amount in a project in Oracle Projects
1011 * @rep:paraminfo {@rep:precision 1} {@rep:required}
1012 * @param p_project_rate_type Exchange rate type to use for conversion from funding currency to project currency
1013 * @rep:paraminfo {@rep:required}
1014 * @param p_project_rate_date Exchange rate date to use for conversion from funding currency to project currency
1015 * @rep:paraminfo {@rep:required}
1016 * @param p_project_exchange_rate Exchange rate to use for conversion from funding currency to project currency
1017 * @rep:paraminfo {@rep:required}
1018 * @param p_projfunc_rate_type Exchange rate type to use for conversion from funding currency to project functional currency
1019 * @rep:paraminfo {@rep:required}
1020 * @param p_projfunc_rate_date Exchange rate date to use for conversion from funding currency to project functional currency
1021 * @rep:paraminfo {@rep:required}
1022 * @param p_projfunc_exchange_rate Exchange rate to use for conversion from funding currency to project functional currency
1023 * @rep:paraminfo {@rep:required}
1024 * @rep:scope public
1025 * @rep:lifecycle active
1026 * @rep:displayname Validate Project Funding Creation
1027 * @rep:compatibility S
1028 */
1029 /* MCB2 columns added */
1030 PROCEDURE check_add_funding_ok
1031 (p_api_version_number IN NUMBER
1032 ,p_commit IN VARCHAR2
1033 ,p_init_msg_list IN VARCHAR2
1034 ,p_msg_count OUT NOCOPY NUMBER /*file.sql.39*/
1035 ,p_msg_data OUT NOCOPY VARCHAR2 /*file.sql.39*/
1036 ,p_return_status OUT NOCOPY VARCHAR2 /*file.sql.39*/
1037 ,p_pm_agreement_reference IN VARCHAR2
1038 ,p_agreement_id IN NUMBER
1039 ,p_pm_funding_reference IN VARCHAR2
1040 ,p_task_id IN NUMBER
1041 ,p_project_id IN NUMBER
1042 ,p_add_funding_ok_flag OUT NOCOPY VARCHAR2 /*file.sql.39*/
1043 ,p_funding_amt IN NUMBER
1044 ,p_project_rate_type IN VARCHAR2 DEFAULT NULL
1045 ,p_project_rate_date IN DATE DEFAULT NULL
1046 ,p_project_exchange_rate IN NUMBER DEFAULT NULL
1047 ,p_projfunc_rate_type IN VARCHAR2 DEFAULT NULL
1048 ,p_projfunc_rate_date IN DATE DEFAULT NULL
1049 ,p_projfunc_exchange_rate IN NUMBER DEFAULT NULL
1050 );
1051
1052 /*#
1053 * This API is used to determine if a fund can be deleted.
1054 * @param p_api_version_number API standard: version number
1055 * @rep:paraminfo {@rep:required}
1056 * @param p_commit API standard (default = F) indicates if transcation will be committed
1057 * @rep:paraminfo {@rep:precision 1} {@rep:required}
1058 * @param p_init_msg_list API standard (default = F) indicates if message stack will be initialized
1059 * @rep:paraminfo {@rep:precision 1} {@rep:required}
1060 * @param p_msg_count API standard: number of error messages
1061 * @rep:paraminfo {@rep:required}
1062 * @param p_msg_data API standard: error message
1063 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
1064 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
1065 * @rep:paraminfo {@rep:precision 1} {@rep:required}
1066 * @param p_pm_funding_reference The reference code that uniquely identifies the funding in the external system
1067 * @rep:paraminfo {@rep:required}
1068 * @param p_funding_id The reference code that uniquely identifies the funding in Oracle Projects
1069 * @rep:paraminfo {@rep:required}
1070 * @param p_del_funding_ok_flag Boolean flag for deleting funding
1071 * @rep:paraminfo {@rep:precision 1} {@rep:required}
1072 * @rep:scope public
1073 * @rep:lifecycle active
1074 * @rep:displayname Validate Project Funding Deletion
1075 * @rep:compatibility S
1076 */
1077 PROCEDURE check_delete_funding_ok
1078 (p_api_version_number IN NUMBER
1079 ,p_commit IN VARCHAR2
1080 ,p_init_msg_list IN VARCHAR2
1081 ,p_msg_count OUT NOCOPY NUMBER /*file.sql.39*/
1082 ,p_msg_data OUT NOCOPY VARCHAR2 /*file.sql.39*/
1083 ,p_return_status OUT NOCOPY VARCHAR2 /*file.sql.39*/
1084 ,p_pm_funding_reference IN VARCHAR2
1085 ,p_funding_id IN NUMBER
1086 ,p_del_funding_ok_flag OUT NOCOPY VARCHAR2 /*file.sql.39*/
1087 );
1088
1089 /*#
1090 * This API is used to determine if a fund can be updated.
1094 * @rep:paraminfo {@rep:precision 1} {@rep:required}
1091 * @param p_api_version_number API standard: version number
1092 * @rep:paraminfo {@rep:required}
1093 * @param p_commit API standard (default = F) indicates if transcation will be committed
1095 * @param p_init_msg_list API standard (default = F) indicates if message stack will be initialized
1096 * @rep:paraminfo {@rep:precision 1} {@rep:required}
1097 * @param p_msg_count API standard: number of error messages
1098 * @rep:paraminfo {@rep:required}
1099 * @param p_msg_data API standard: error message
1100 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
1101 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
1102 * @rep:paraminfo {@rep:precision 1} {@rep:required}
1103 * @param p_pm_product_code Identifier of the external system from which the project was imported
1104 * @rep:paraminfo {@rep:precision 25} {@rep:required}
1105 * @param p_pm_funding_reference The reference code that uniquely identifies the funding in the external system
1106 * @rep:paraminfo {@rep:required}
1107 * @param p_funding_id The reference code that uniquely identifies the funding in Oracle Projects
1108 * @rep:paraminfo {@rep:required}
1109 * @param p_pm_project_reference The reference code that uniquely identifies the project in the external system
1110 * @rep:paraminfo {@rep:required}
1111 * @param p_project_id The reference code that uniquely identifies the project in Oracle Projects
1112 * @rep:paraminfo {@rep:required}
1113 * @param p_pm_task_reference The reference code that uniquely identifies the task in the external system
1114 * @rep:paraminfo {@rep:required}
1115 * @param p_task_id The reference code that uniquely identifies the task in a project in Oracle Projects
1116 * @rep:paraminfo {@rep:required}
1117 * @param p_pm_agreement_reference The reference code that uniquely identifies the agreement in the external system
1118 * @rep:paraminfo {@rep:required}
1119 * @param p_agreement_id The reference code that uniquely identifies the agreement in Oracle Projects
1120 * @rep:paraminfo {@rep:required}
1121 * @param p_allocated_amount The reference code that uniquely identifies the allocated funding amount in a project in Oracle Projects
1122 * @rep:paraminfo {@rep:required}
1123 * @param p_date_allocated The reference code that uniquely identifies the date allocated in a project in Oracle Projects
1124 * @rep:paraminfo {@rep:required}
1125 * @param p_desc_flex_name Descriptive flexfield name
1126 * @rep:paraminfo {@rep:required}
1127 * @param p_attribute_category Descriptive flexfield category
1128 * @rep:paraminfo {@rep:required}
1129 * @param p_attribute1 Descriptive flexfield segment
1130 * @rep:paraminfo {@rep:required}
1131 * @param p_attribute2 Descriptive flexfield segment
1132 * @rep:paraminfo {@rep:required}
1133 * @param p_attribute3 Descriptive flexfield segment
1134 * @rep:paraminfo {@rep:required}
1135 * @param p_attribute4 Descriptive flexfield segment
1136 * @rep:paraminfo {@rep:required}
1137 * @param p_attribute5 Descriptive flexfield segment
1138 * @rep:paraminfo {@rep:required}
1139 * @param p_attribute6 Descriptive flexfield segment
1140 * @rep:paraminfo {@rep:required}
1141 * @param p_attribute7 Descriptive flexfield segment
1142 * @rep:paraminfo {@rep:required}
1143 * @param p_attribute8 Descriptive flexfield segment
1144 * @rep:paraminfo {@rep:required}
1145 * @param p_attribute9 Descriptive flexfield segment
1146 * @rep:paraminfo {@rep:required}
1147 * @param p_attribute10 Descriptive flexfield segment
1148 * @rep:paraminfo {@rep:required}
1149 * @param p_update_funding_ok_flag Boolean flag for deleting funding
1150 * @rep:paraminfo {@rep:precision 1} {@rep:required}
1151 * @param p_project_rate_type Exchange rate type to use for conversion from funding currency to project currency
1152 * @rep:paraminfo {@rep:required}
1153 * @param p_project_rate_date Exchange rate date to use for conversion from funding currency to project currency
1154 * @rep:paraminfo {@rep:required}
1155 * @param p_project_exchange_rate Exchange rate to use for conversion from funding currency to project currency
1156 * @rep:paraminfo {@rep:required}
1157 * @param p_projfunc_rate_type Exchange rate type to use for conversion from funding currency to project functional currency
1158 * @rep:paraminfo {@rep:required}
1159 * @param p_projfunc_rate_date Exchange rate date to use for conversion from funding currency to project functional currency
1160 * @rep:paraminfo {@rep:required}
1161 * @param p_projfunc_exchange_rate Exchange rate to use for conversion from funding currency to project functional currency
1162 * @rep:paraminfo {@rep:required}
1163 * @param p_funding_category Identifier of the funding line
1164 * @rep:scope public
1165 * @rep:lifecycle active
1166 * @rep:displayname Validate Project Funding Update
1167 * @rep:compatibility S
1168 */
1169 /* MCB2 columns added */
1170 PROCEDURE check_update_funding_ok
1171 (p_api_version_number IN NUMBER
1172 ,p_commit IN VARCHAR2
1173 ,p_init_msg_list IN VARCHAR2
1174 ,p_msg_count OUT NOCOPY NUMBER /*file.sql.39*/
1175 ,p_msg_data OUT NOCOPY VARCHAR2 /*file.sql.39*/
1176 ,p_return_status OUT NOCOPY VARCHAR2 /*file.sql.39*/
1177 ,p_pm_product_code IN VARCHAR2
1178 ,p_pm_funding_reference IN VARCHAR2
1179 ,p_funding_id IN NUMBER
1180 ,p_pm_project_reference IN VARCHAR2
1181 ,p_project_id IN NUMBER
1182 ,p_pm_task_reference IN VARCHAR2
1183 ,p_task_id IN NUMBER
1184 ,p_pm_agreement_reference IN VARCHAR2
1185 ,p_agreement_id IN NUMBER
1186 ,p_allocated_amount IN NUMBER
1187 ,p_date_allocated IN DATE
1188 ,p_desc_flex_name IN VARCHAR2
1189 ,p_attribute_category IN VARCHAR2
1190 ,p_attribute1 IN VARCHAR2
1191 ,p_attribute2 IN VARCHAR2
1192 ,p_attribute3 IN VARCHAR2
1193 ,p_attribute4 IN VARCHAR2
1194 ,p_attribute5 IN VARCHAR2
1195 ,p_attribute6 IN VARCHAR2
1196 ,p_attribute7 IN VARCHAR2
1197 ,p_attribute8 IN VARCHAR2
1201 ,p_project_rate_type IN VARCHAR2 DEFAULT NULL
1198 ,p_attribute9 IN VARCHAR2
1199 ,p_attribute10 IN VARCHAR2
1200 ,p_update_funding_ok_flag OUT NOCOPY VARCHAR2 /*file.sql.39*/
1202 ,p_project_rate_date IN DATE DEFAULT NULL
1203 ,p_project_exchange_rate IN NUMBER DEFAULT NULL
1204 ,p_projfunc_rate_type IN VARCHAR2 DEFAULT NULL
1205 ,p_projfunc_rate_date IN DATE DEFAULT NULL
1206 ,p_projfunc_exchange_rate IN NUMBER DEFAULT NULL
1207 ,p_funding_category IN VARCHAR2 DEFAULT 'ADDITIONAL'
1208 /* Added default for bug 2512483-For Bug2244796 */
1209
1210 );
1211 /* MCB 2 Added to create baselined budget */
1212 /*#
1213 * This API creates a budget baseline
1214 * @param p_api_version_number API standard: version number
1215 * @rep:paraminfo {@rep:required}
1216 * @param p_commit API standard (default = F) indicates if transcation will be committed
1217 * @rep:paraminfo {@rep:precision 1} {@rep:required}
1218 * @param p_init_msg_list API standard (default = F) indicates if message stack will be initialized
1219 * @rep:paraminfo {@rep:precision 1} {@rep:required}
1220 * @param p_msg_count API standard: number of error messages
1221 * @rep:paraminfo {@rep:required}
1222 * @param p_msg_data API standard: error message
1223 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
1224 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
1225 * @rep:paraminfo {@rep:precision 1} {@rep:required}
1226 * @param p_pm_product_code Identifier of the external system from which the project was imported
1227 * @rep:paraminfo {@rep:precision 25} {@rep:required}
1228 * @param p_pm_budget_reference The reference code that uniquely identifies the budget in the external system
1229 * @rep:paraminfo {@rep:required}
1230 * @param p_pa_project_id The reference code that uniquely identifies the project in Oracle Projects
1231 * @rep:paraminfo {@rep:required}
1232 * @param p_pm_project_reference The reference code that uniquely identifies the project in the external system
1233 * @rep:paraminfo {@rep:required}
1234 * @param p_change_reason_code Describes the change reason
1235 * @rep:paraminfo {@rep:required}
1236 * @param p_attribute_category Descriptive flexfield category
1237 * @rep:paraminfo {@rep:required}
1238 * @param p_attribute1 Descriptive flexfield segment
1239 * @rep:paraminfo {@rep:required}
1240 * @param p_attribute2 Descriptive flexfield segment
1241 * @rep:paraminfo {@rep:required}
1242 * @param p_attribute3 Descriptive flexfield segment
1243 * @rep:paraminfo {@rep:required}
1244 * @param p_attribute4 Descriptive flexfield segment
1245 * @rep:paraminfo {@rep:required}
1246 * @param p_attribute5 Descriptive flexfield segment
1247 * @rep:paraminfo {@rep:required}
1248 * @param p_attribute6 Descriptive flexfield segment
1249 * @rep:paraminfo {@rep:required}
1250 * @param p_attribute7 Descriptive flexfield segment
1251 * @rep:paraminfo {@rep:required}
1252 * @param p_attribute8 Descriptive flexfield segment
1253 * @rep:paraminfo {@rep:required}
1254 * @param p_attribute9 Descriptive flexfield segment
1255 * @rep:paraminfo {@rep:required}
1256 * @param p_attribute10 Descriptive flexfield segment
1257 * @rep:paraminfo {@rep:required}
1258 * @param p_attribute11 Descriptive flexfield segment
1259 * @rep:paraminfo {@rep:required}
1260 * @param p_attribute12 Descriptive flexfield segment
1261 * @rep:paraminfo {@rep:required}
1262 * @param p_attribute13 Descriptive flexfield segment
1263 * @rep:paraminfo {@rep:required}
1264 * @param p_attribute14 Descriptive flexfield segment
1265 * @rep:paraminfo {@rep:required}
1266 * @param p_attribute15 Descriptive flexfield segment
1267 * @rep:paraminfo {@rep:required}
1268 * @rep:scope public
1269 * @rep:lifecycle active
1270 * @rep:displayname Create Baseline Budget
1271 * @rep:compatibility S
1272 */
1273 PROCEDURE create_baseline_budget
1274 ( p_api_version_number IN NUMBER
1275 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1276 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1277 ,p_msg_count OUT NOCOPY NUMBER /*file.sql.39*/
1278 ,p_msg_data OUT NOCOPY VARCHAR2 /*file.sql.39*/
1279 ,p_return_status OUT NOCOPY VARCHAR2 /*file.sql.39*/
1280 ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1281 ,p_pm_budget_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1282 ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1283 ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1284 ,p_change_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1285 ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1286 ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1287 ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1288 ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1289 ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1290 ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1291 ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1292 ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1293 ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1294 ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1295 ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1296 ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1297 ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1298 ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1299 ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1300 ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1301 ,p_create_new_curr_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR /* Added for bug#9892202 */
1302 ,p_replace_current_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR /* Added for bug#9892202 */
1303 );
1304
1305 end PA_AGREEMENT_PUB;
[Home] [Help]