1 PACKAGE PA_EVENT_PUB AUTHID DEFINER AS
2 /* $Header: PAEVAPBS.pls 120.9 2007/02/07 10:41:55 rgandhi noship $ */
3 /*#
4 * This package contains the public APIs, which provide an open interface for the external systems to insert,
5 * update, and delete events.
6 * @rep:scope public
7 * @rep:product PA
8 * @rep:lifecycle active
9 * @rep:displayname Project Billing Events
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY PA_BILLING_EVENT
12 * @rep:category BUSINESS_ENTITY PA_REVENUE
13 * @rep:category BUSINESS_ENTITY PA_INVOICE
14 * @rep:doccd 120pjapi.pdf See the Oracle Projects API's, Client Extensions, and Open Interfaces Reference
15 */
16
17 /* Global Constants */
18 PACKAGE_NAME VARCHAR2(200) :=NULL;
19 PROCEDURE_NAME VARCHAR2(200) :=NULL;
20
21 g_api_version_number NUMBER := 1.0;
22
23 Type Event_Rec_In_Type is RECORD
24 (p_pm_event_reference VARCHAR2(25)
25 ,P_task_number VARCHAR2(25) Default NULL
26 ,p_event_number NUMBER Default NULL
27 ,P_event_type VARCHAR2(30)
28 ,P_agreement_number VARCHAR2(50) Default NULL -- Federal Uptake
29 ,P_agreement_type VARCHAR2(30) Default NULL -- Federal Uptake
30 ,P_customer_number VARCHAR2(30) Default NULL -- federal Uptake
31 ,P_description VARCHAR2(250) Default NULL
32 ,P_bill_hold_flag VARCHAR2(1) Default NULL
33 ,P_completion_date DATE
34 ,P_desc_flex_name VARCHAR2(240) Default NULL
35 ,P_attribute_category VARCHAR2(30) Default NULL
36 ,P_attribute1 VARCHAR2(150) Default NULL
37 ,P_attribute2 VARCHAR2(150) Default NULL
38 ,P_attribute3 VARCHAR2(150) Default NULL
39 ,P_attribute4 VARCHAR2(150) Default NULL
40 ,P_attribute5 VARCHAR2(150) Default NULL
41 ,P_attribute6 VARCHAR2(150) Default NULL
42 ,P_attribute7 VARCHAR2(150) Default NULL
43 ,P_attribute8 VARCHAR2(150) Default NULL
44 ,P_attribute9 VARCHAR2(150) Default NULL
45 ,P_attribute10 VARCHAR2(150) Default NULL
46 ,P_project_number VARCHAR2(25)
47 ,P_organization_name VARCHAR2(240)
48 ,P_inventory_org_name VARCHAR2(240) Default NULL
49 ,P_inventory_item_id NUMBER Default NULL
50 ,P_quantity_billed NUMBER Default NULL
51 ,P_uom_code VARCHAR2(3) Default NULL
52 ,P_unit_price NUMBER Default NULL
53 ,P_reference1 VARCHAR2(240) Default NULL
54 ,P_reference2 VARCHAR2(240) Default NULL
55 ,P_reference3 VARCHAR2(240) Default NULL
56 ,P_reference4 VARCHAR2(240) Default NULL
57 ,P_reference5 VARCHAR2(240) Default NULL
58 ,P_reference6 VARCHAR2(240) Default NULL
59 ,P_reference7 VARCHAR2(240) Default NULL
60 ,P_reference8 VARCHAR2(240) Default NULL
61 ,P_reference9 VARCHAR2(240) Default NULL
62 ,P_reference10 VARCHAR2(240) Default NULL
63 ,P_bill_trans_currency_code VARCHAR2(15) Default NULL
64 ,P_bill_trans_bill_amount NUMBER Default NULL
65 ,P_bill_trans_rev_amount NUMBER Default NULL
66 ,P_project_rate_type VARCHAR2(30) Default NULL
67 ,P_project_rate_date DATE Default NULL
68 ,P_project_exchange_rate NUMBER Default NULL
69 ,P_projfunc_rate_type VARCHAR2(30) Default NULL
70 ,P_projfunc_rate_date DATE Default NULL
71 ,P_projfunc_exchange_rate NUMBER Default NULL
72 ,P_funding_rate_type VARCHAR2(30) Default NULL
73 ,P_funding_rate_date DATE Default NULL
74 ,P_funding_exchange_rate NUMBER Default NULL
75 ,P_adjusting_revenue_flag VARCHAR2(1) Default NULL
76 ,P_event_id NUMBER Default NULL
77 ,P_deliverable_id NUMBER Default NULL
78 ,P_action_id NUMBER Default NULL
79 ,P_context VARCHAR2(1) Default NULL
80 ,P_record_version_number NUMBER Default NULL
81 );
82
83 Type Event_Rec_Out_Type is RECORD
84 ( pm_event_reference Varchar2(25)
85 ,Event_Id Number(15)
86 ,Return_status Varchar2(1)
87 );
88
89
90 TYPE event_in_tbl_type is TABLE of Event_Rec_In_Type
91 Index by binary_integer;
92
93 TYPE event_out_tbl_type is TABLE of Event_Rec_Out_Type
94 Index by binary_integer;
95
96 --If the event data is input in scalar form these will put into these
97 --global PL/SQL tables before events can be created or updated.
98 G_event_in_tbl Event_In_Tbl_Type;
99 G_event_out_tbl Event_Out_Tbl_Type;
100 G_event_tbl_count NUMBER :=0;
101
102 /*#
103 * This API creates an event or a set of events.
104 * @param p_api_version_number API standard: version number
105 * @rep:paraminfo {@rep:required}
106 * @param p_commit API standard (default = F) indicates if transcation will be commited
107 * @rep:paraminfo {@rep:precision 1} {@rep:required}
108 * @param p_init_msg_list API standard (default = F) indicates if message stack will be initialized
109 * @rep:paraminfo {@rep:required}
110 * @param p_pm_product_code Identifier of the external project management system from which the project was imported
111 * @rep:paraminfo {@rep:required}
112 * @param p_event_in_tbl The reference code that uniquely identifies the event input record in Oracle projects
113 * @rep:paraminfo {@rep:required}
114 * @param p_event_out_tbl The reference code that uniquely identifies the event output record in Oracle Projects
115 * @rep:paraminfo {@rep:required}
116 * @param p_msg_count API standard: number of error messages
117 * @rep:paraminfo {@rep:required}
118 * @param p_msg_data API standard: error message
119 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
120 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
121 * @rep:paraminfo {@rep:required}
122 * @rep:scope public
123 * @rep:lifecycle active
124 * @rep:displayname Create Billing Event
125 * @rep:compatibility S
126 */
127 PROCEDURE create_event
128 ( p_api_version_number IN NUMBER
129 ,p_commit IN VARCHAR2
130 ,p_init_msg_list IN VARCHAR2
131 ,p_pm_product_code IN VARCHAR2
132 ,p_event_in_tbl IN Event_In_Tbl_Type
133 ,p_event_out_tbl OUT NOCOPY Event_Out_Tbl_Type --File.Sql.39 bug 4440895
134 ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
135 ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
136 ,p_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
137
138 /*#
139 * This API updates an event or set of events.
140 * @param p_api_version_number API standard: version number
141 * @rep:paraminfo {@rep:required}
142 * @param p_commit API standard (default = F) indicates if transcation will be commited
143 * @rep:paraminfo {@rep:precision 1} {@rep:required}
144 * @param p_init_msg_list API standard (default = F) indicates if message stack will be initialized
145 * @rep:paraminfo {@rep:required}
146 * @param p_pm_product_code Identifier of the external project management system from which the project was imported
147 * @rep:paraminfo {@rep:required}
148 * @param p_event_in_tbl The reference code that uniquely identifies the event input record in Oracle projects
149 * @rep:paraminfo {@rep:required}
150 * @param p_event_out_tbl The reference code that uniquely identifies the event output record in Oracle Projects
151 * @rep:paraminfo {@rep:required}
152 * @param p_msg_count API standard: number of error messages
153 * @rep:paraminfo {@rep:required}
154 * @param p_msg_data API standard: error message
155 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
156 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
157 * @rep:paraminfo {@rep:required}
158 * @rep:scope public
159 * @rep:lifecycle active
160 * @rep:displayname Update Billing Event
161 * @rep:compatibility S
162 */
163 PROCEDURE UPDATE_EVENT
164 ( p_api_version_number IN NUMBER
165 ,p_commit IN VARCHAR2
166 ,p_init_msg_list IN VARCHAR2
167 ,p_pm_product_code IN VARCHAR2
168 ,p_event_in_tbl IN Event_In_Tbl_Type
169 ,p_event_out_tbl OUT NOCOPY Event_Out_Tbl_Type --File.Sql.39 bug 4440895
170 ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
171 ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
172 ,p_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
173
174 /*#
175 * This API deletes an event.
176 * @param p_api_version_number API standard: version number
177 * @rep:paraminfo {@rep:required}
178 * @param p_commit API standard (default = F) indicates if transcation will be commited
179 * @rep:paraminfo {@rep:precision 1} {@rep:required}
180 * @param p_init_msg_list API standard (default = F) indicates if message stack will be initialized
181 * @rep:paraminfo {@rep:required}
182 * @param p_pm_product_code Identifier of the external project management system from which the project was imported
183 * @rep:paraminfo {@rep:required}
184 * @param p_pm_event_reference The reference code that uniquely identifies the event in the external system
185 * @rep:paraminfo {@rep:required}
186 * @param p_event_id The reference code that uniquely identifies the event in Oracle Projects
187 * @rep:paraminfo {@rep:required}
188 * @param p_msg_count API standard: number of error messages
189 * @rep:paraminfo {@rep:required}
190 * @param p_msg_data API standard: error message
191 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
192 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
193 * @rep:paraminfo {@rep:required}
194 * @rep:scope public
195 * @rep:lifecycle active
196 * @rep:displayname Delete Billing Event
197 * @rep:compatibility S
198 */
199 PROCEDURE DELETE_EVENT
200 (p_api_version_number IN NUMBER
201 ,p_commit IN VARCHAR2
202 ,p_init_msg_list IN VARCHAR2
203 ,p_pm_product_code IN VARCHAR2
204 ,p_pm_event_reference IN VARCHAR2
205 ,p_event_id IN NUMBER
206 ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
207 ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
208 ,p_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
209
210 /*#
211 * This API sets the global tables used by the Load Execute Fetch procedures that create a new event or
212 * update an existing event.
213 * In order to execute this API the following list of API's should be executed in the order of sequence.
214 * INIT_EVENT
215 * LOAD_EVENT
216 * EXECUTE_CREATE_EVENT/EXECUTE_UPDATE_EVENT
217 * FETCH_EVENT
218 * CLEAR_EVENT
219 * @rep:scope public
220 * @rep:lifecycle active
221 * @rep:displayname Create Multiple Billing Events-Initialize
222 * @rep:compatibility S
223 */
224 PROCEDURE INIT_EVENT;
225
226 /*#
227 * This API loads an event to a PL/SQL record.
228 * In order to execute this API the following list of API's should be executed in the order of sequence.
229 * INIT_EVENT
230 * LOAD_EVENT
231 * EXECUTE_CREATE_EVENT/EXECUTE_UPDATE_EVENT
232 * FETCH_EVENT
233 * CLEAR_EVENT
234 * @param p_pm_product_code Identifier of the external project management system from which the project was imported
235 * @rep:paraminfo {@rep:required}
236 * @param p_api_version_number API standard: version number
237 * @rep:paraminfo {@rep:required}
238 * @param p_init_msg_list API standard (default = F) indicates if message stack will be initialized
239 * @rep:paraminfo {@rep:required}
240 * @param p_pm_event_reference The reference code that uniquely identifies the event in the external system
241 * @rep:paraminfo {@rep:required}
242 * @param p_task_number The number that identifies the task in Oracle Projects
243 * @rep:paraminfo {@rep:required}
244 * @param p_event_number The number that identifies the event
245 * @rep:paraminfo {@rep:required}
246 * @param p_event_type The event type that classifies the event
247 * @rep:paraminfo {@rep:required}
248 * @param p_description Description of the event
249 * @rep:paraminfo {@rep:required}
250 * @param p_bill_hold_flag Flag indicating that the event is held from invoicing
251 * @rep:paraminfo {@rep:required}
252 * @param p_completion_date The date on which the event is complete and after which the event is processed
253 * for revenue accrual and/or invoicing
254 * @rep:paraminfo {@rep:required}
255 * @param p_desc_flex_name Descriptive flexfield name
256 * @rep:paraminfo {@rep:required}
257 * @param p_attribute_category Descriptive flexfield category
258 * @rep:paraminfo {@rep:required}
259 * @param p_attribute1 Descriptive flexfield segment
260 * @rep:paraminfo {@rep:required}
261 * @param p_attribute2 Descriptive flexfield segment
262 * @rep:paraminfo {@rep:required}
263 * @param p_attribute3 Descriptive flexfield segment
264 * @rep:paraminfo {@rep:required}
265 * @param p_attribute4 Descriptive flexfield segment
266 * @rep:paraminfo {@rep:required}
267 * @param p_attribute5 Descriptive flexfield segment
268 * @rep:paraminfo {@rep:required}
269 * @param p_attribute6 Descriptive flexfield segment
270 * @rep:paraminfo {@rep:required}
271 * @param p_attribute7 Descriptive flexfield segment
272 * @rep:paraminfo {@rep:required}
273 * @param p_attribute8 Descriptive flexfield segment
274 * @rep:paraminfo {@rep:required}
275 * @param p_attribute9 Descriptive flexfield segment
276 * @rep:paraminfo {@rep:required}
277 * @param p_attribute10 Descriptive flexfield segment
278 * @rep:paraminfo {@rep:required}
279 * @param p_project_number The project number associated with the event
280 * @rep:paraminfo {@rep:required}
281 * @param p_organization_name The organization associated with the event
282 * @rep:paraminfo {@rep:required}
283 * @param p_inventory_org_name The inventory organization associated with the event
284 * @rep:paraminfo {@rep:required}
285 * @param p_inventory_item_id The inventory item identifier associated with the event
286 * @rep:paraminfo {@rep:required}
287 * @param p_quantity_billed The quantity billed for the event
288 * @rep:paraminfo {@rep:required}
289 * @param p_uom_code The unit of measure for the event
290 * @rep:paraminfo {@rep:required}
291 * @param p_unit_price The unit price for the event
292 * @rep:paraminfo {@rep:required}
293 * @param p_reference1 Reference column
294 * @rep:paraminfo {@rep:required}
295 * @param p_reference2 Reference column
299 * @param p_reference4 Reference column
296 * @rep:paraminfo {@rep:required}
297 * @param p_reference3 Reference column
298 * @rep:paraminfo {@rep:required}
300 * @rep:paraminfo {@rep:required}
301 * @param p_reference5 Reference column
302 * @rep:paraminfo {@rep:required}
303 * @param p_reference6 Reference column
304 * @rep:paraminfo {@rep:required}
305 * @param p_reference7 Reference column
306 * @rep:paraminfo {@rep:required}
307 * @param p_reference8 Reference column
308 * @rep:paraminfo {@rep:required}
309 * @param p_reference9 Reference column
310 * @rep:paraminfo {@rep:required}
311 * @param p_reference10 Reference column
312 * @rep:paraminfo {@rep:required}
313 * @param p_bill_trans_currency_code Billing transaction currency code
314 * @rep:paraminfo {@rep:required}
315 * @param p_bill_trans_bill_amount Billing transaction billing amount
316 * @rep:paraminfo {@rep:required}
317 * @param p_bill_trans_rev_amount Billing transaction revenue amount
318 * @rep:paraminfo {@rep:required}
319 * @param p_project_rate_type Exchange rate type to use for conversion from event currency to project currency
320 * @rep:paraminfo {@rep:required}
321 * @param p_project_rate_date Exchange rate date to use for conversion from event currency to project currency
322 * @rep:paraminfo {@rep:required}
323 * @param p_project_exchange_rate Exchange rate to use for conversion from event currency to project currency
324 * @rep:paraminfo {@rep:required}
325 * @param p_projfunc_rate_type Exchange rate type to use for conversion from event currency to project functional currency
326 * @rep:paraminfo {@rep:required}
327 * @param p_projfunc_rate_date Exchange rate date to use for conversion from event currency to project functional currency
328 * @rep:paraminfo {@rep:required}
329 * @param p_projfunc_exchange_rate Exchange rate to use for conversion from event currency to project functional currency
330 * @rep:paraminfo {@rep:required}
331 * @param p_funding_rate_type Exchange rate type to use for conversion from event currency to funding currency
332 * @rep:paraminfo {@rep:required}
333 * @param p_funding_rate_date Exchange rate date to use for conversion from event currency to funding currency
334 * @rep:paraminfo {@rep:required}
335 * @param p_funding_exchange_rate Exchange rate to use for conversion from event currency to funding currency
336 * @rep:paraminfo {@rep:required}
337 * @param p_adjusting_revenue_flag Flag indicating revenue adjustment
338 * @rep:paraminfo {@rep:required}
339 * @param p_event_id The reference code that uniquely identifies the event in Oracle Projects
340 * @rep:paraminfo {@rep:required}
341 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
342 * @rep:paraminfo {@rep:required}
343 * @rep:scope public
344 * @rep:lifecycle active
345 * @rep:displayname Create Multiple Billing Events - Load
346 * @rep:compatibility S
347 */
348 PROCEDURE LOAD_EVENT
349 (p_pm_product_code IN VARCHAR2
350 ,P_api_version_number IN NUMBER
351 ,P_init_msg_list IN VARCHAR2
352 ,P_pm_event_reference IN VARCHAR2
353 ,P_task_number IN VARCHAR2
354 ,P_event_number IN NUMBER
355 ,P_event_type IN VARCHAR2
356 ,P_agreement_number IN VARCHAR2 -- Federal Uptake
357 ,P_agreement_type IN VARCHAR2 -- Federal Uptake
358 ,P_customer_number IN VARCHAR2 -- Federal Uptake
359 ,P_description IN VARCHAR2
360 ,P_bill_hold_flag IN VARCHAR2
361 ,P_completion_date IN DATE
362 ,P_desc_flex_name IN VARCHAR2
363 ,P_attribute_category IN VARCHAR2
364 ,P_attribute1 IN VARCHAR2
365 ,P_attribute2 IN VARCHAR2
366 ,P_attribute3 IN VARCHAR2
367 ,P_attribute4 IN VARCHAR2
368 ,P_attribute5 IN VARCHAR2
369 ,P_attribute6 IN VARCHAR2
370 ,P_attribute7 IN VARCHAR2
371 ,P_attribute8 IN VARCHAR2
372 ,P_attribute9 IN VARCHAR2
373 ,P_attribute10 IN VARCHAR2
374 ,P_project_number IN VARCHAR2
375 ,P_organization_name IN VARCHAR2
376 ,P_inventory_org_name IN VARCHAR2
377 ,P_inventory_item_id IN NUMBER
378 ,P_quantity_billed IN NUMBER
379 ,P_uom_code IN VARCHAR2
380 ,P_unit_price IN NUMBER
381 ,P_reference1 IN VARCHAR2
382 ,P_reference2 IN VARCHAR2
383 ,P_reference3 IN VARCHAR2
384 ,P_reference4 IN VARCHAR2
385 ,P_reference5 IN VARCHAR2
386 ,P_reference6 IN VARCHAR2
387 ,P_reference7 IN VARCHAR2
388 ,P_reference8 IN VARCHAR2
389 ,P_reference9 IN VARCHAR2
390 ,P_reference10 IN VARCHAR2
391 ,P_bill_trans_currency_code IN VARCHAR2
392 ,P_bill_trans_bill_amount IN NUMBER
393 ,P_bill_trans_rev_amount IN NUMBER
394 ,P_project_rate_type IN VARCHAR2
395 ,P_project_rate_date IN DATE
396 ,P_project_exchange_rate IN NUMBER
397 ,P_projfunc_rate_type IN VARCHAR2
401 ,P_funding_rate_date IN DATE
398 ,P_projfunc_rate_date IN DATE
399 ,P_projfunc_exchange_rate IN NUMBER
400 ,P_funding_rate_type IN VARCHAR2
402 ,P_funding_exchange_rate IN NUMBER
403 ,P_adjusting_revenue_flag IN VARCHAR2
404 ,P_event_id IN NUMBER
405 ,P_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
406
407 /*#
408 * This API creates an event using the information, which is stored in the global tables during the Load phase.
409 * In order to execute this API the following list of API's should be executed in the order of sequence.
410 * INIT_EVENT
411 * LOAD_EVENT
412 * EXECUTE_CREATE_EVENT/EXECUTE_UPDATE_EVENT
413 * FETCH_EVENT
414 * CLEAR_EVENT
415 * @param p_api_version_number API standard: version number
416 * @rep:paraminfo {@rep:required}
417 * @param p_commit API standard (default = F) indicates if transcation will be commited
418 * @rep:paraminfo {@rep:precision 1} {@rep:required}
419 * @param p_init_msg_list API standard (default = F) indicates if message stack will be initialized
420 * @rep:paraminfo {@rep:required}
421 * @param p_pm_product_code Identifier of the external project management system from which the project was imported
422 * @rep:paraminfo {@rep:required}
423 * @param p_event_id_out The reference code that uniquely identifies the event in Oracle Projects
424 * @rep:paraminfo {@rep:required}
425 * @param p_msg_count API standard: number of error messages
426 * @rep:paraminfo {@rep:required}
427 * @param p_msg_data API standard: error message
428 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
429 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
430 * @rep:paraminfo {@rep:required}
431 * @rep:scope public
432 * @rep:lifecycle active
433 * @rep:displayname Create Multiple Billing Events - Execute Create
434 * @rep:compatibility S
435 */
436 PROCEDURE EXECUTE_CREATE_EVENT
437 (p_api_version_number IN NUMBER
438 ,p_commit IN VARCHAR2
439 ,p_init_msg_list IN VARCHAR2
440 ,p_pm_product_code IN VARCHAR2
441 ,p_event_id_out OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
442 ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
443 ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
444 ,p_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
445
446 /*#
447 * This API updates event data using the information stored in the global tables during the load phase.
448 * In order to execute this API the following list of API's should be executed in the order of sequence.
449 * INIT_EVENT
450 * LOAD_EVENT
451 * EXECUTE_CREATE_EVENT/EXECUTE_UPDATE_EVENT
452 * FETCH_EVENT
453 * CLEAR_EVENT
454 * @param p_api_version_number API standard: version number
455 * @rep:paraminfo {@rep:required}
456 * @param p_commit API standard (default = F) indicates if transcation will be commited
457 * @rep:paraminfo {@rep:precision 1} {@rep:required}
458 * @param p_init_msg_list API standard (default = F) indicates if message stack will be initialized
459 * @rep:paraminfo {@rep:required}
460 * @param p_pm_product_code Identifier of the external project management system from which the project was imported
461 * @rep:paraminfo {@rep:required}
462 * @param p_msg_count API standard: number of error messages
463 * @rep:paraminfo {@rep:required}
464 * @param p_msg_data API standard: error message
465 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
466 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
467 * @rep:paraminfo {@rep:required}
468 * @rep:scope public
469 * @rep:lifecycle active
470 * @rep:displayname Update Multiple Billing Events-Update
471 * @rep:compatibility S
472 */
473 PROCEDURE EXECUTE_UPDATE_EVENT
474 (p_api_version_number IN NUMBER
475 ,p_commit IN VARCHAR2
476 ,p_init_msg_list IN VARCHAR2
477 ,p_pm_product_code IN VARCHAR2
478 ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
479 ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
480 ,p_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
481
482 /*#
483 * This API gets the return status during creation of an event and stores the value in a global PL/SQL table.
484 * @param p_api_version_number API standard: version number
485 * @rep:paraminfo {@rep:required}
486 * @param p_pm_product_code Identifier of the external project management system from which the project was imported
487 * @rep:paraminfo {@rep:required}
488 * @param p_pm_event_reference The reference code that uniquely identifies the event in the external system
489 * @rep:paraminfo {@rep:required}
490 * @param p_event_id_out The reference code that uniquely identifies the event in Oracle Projects
491 * @rep:paraminfo {@rep:required}
492 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
493 * @rep:paraminfo {@rep:required}
494 * @rep:scope public
495 * @rep:lifecycle active
496 * @rep:displayname Create Multiple Billing Events - Fetch
497 * @rep:compatibility S
498 */
499 PROCEDURE FETCH_EVENT
500 (p_api_version_number IN NUMBER
501 ,P_pm_product_code IN VARCHAR2
502 ,P_pm_event_reference IN VARCHAR2
506 /*#
503 ,P_event_id_out OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
504 ,p_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
505
507 * This API clears the global values that were created during initialization.
508 * In order to execute this API the following list of API's should be executed in the order of sequence.
509 * INIT_EVENT
510 * LOAD_EVENT
511 * EXECUTE_CREATE_EVENT/EXECUTE_UPDATE_EVENT
512 * FETCH_EVENT
513 * CLEAR_EVENT
514 * @rep:scope public
515 * @rep:lifecycle active
516 * @rep:displayname Create Multiple Billing Events - Clear
517 * @rep:compatibility S
518 */
519 PROCEDURE CLEAR_EVENT;
520
521 /*#
522 * This API checks whether an event can be deleted.
523 * @param p_api_version_number API standard: version number
524 * @rep:paraminfo {@rep:required}
525 * @param p_commit API standard (default = F) indicates if transcation will be commited
526 * @rep:paraminfo {@rep:precision 1} {@rep:required}
527 * @param p_init_msg_list API standard (default = F) indicates if message stack will be initialized
528 * @rep:paraminfo {@rep:required}
529 * @param p_pm_product_code Identifier of the external project management system from which the project was imported
530 * @rep:paraminfo {@rep:required}
531 * @param p_pm_event_reference The reference code that uniquely identifies the event in the external system
532 * @rep:paraminfo {@rep:required}
533 * @param p_event_id The reference code that uniquely identifies the event in Oracle Projects
534 * @rep:paraminfo {@rep:required}
535 * @param p_del_event_ok_flag Boolean flag for deleting an event
536 * @rep:paraminfo {@rep:required}
537 * @param p_msg_count API standard: number of error messages
538 * @rep:paraminfo {@rep:required}
539 * @param p_msg_data API standard: error message
540 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
541 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
542 * @rep:paraminfo {@rep:required}
543 * @rep:scope public
544 * @rep:lifecycle active
545 * @rep:displayname Validate Billing Event Deletion
546 * @rep:compatibility S
547 */
548 PROCEDURE CHECK_DELETE_EVENT_OK
549 (P_api_version_number IN NUMBER
550 ,P_commit IN VARCHAR2
551 ,P_init_msg_list IN VARCHAR2
552 ,P_pm_product_code IN VARCHAR2
553 ,P_pm_event_reference IN VARCHAR2
554 ,P_event_id IN NUMBER
555 ,P_del_event_ok_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
556 ,P_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
557 ,P_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
558 ,P_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
559
560
561 END PA_EVENT_PUB;