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
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
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
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)
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
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
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
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
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
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)
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
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
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
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
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
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)
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
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
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
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
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
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
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
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
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)
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
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
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
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
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
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)
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
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
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
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
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
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
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
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)
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
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