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
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
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
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)
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
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
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
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
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
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)
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
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}
211: * @param p_pm_agreement_reference The reference code that uniquely identifies the agreement in the external system
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
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
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
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)
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
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
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
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
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
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)
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
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
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
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
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
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)
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
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
425: );
426:
427: /*#
428: * This API updates a fund for an agreement
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
432: * @rep:paraminfo {@rep:precision 1} {@rep:required}
433: * @param p_init_msg_list API standard (default = F) indicates if message stack will be initialized
427: /*#
428: * This API updates a fund for an agreement
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
432: * @rep:paraminfo {@rep:precision 1} {@rep:required}
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
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
432: * @rep:paraminfo {@rep:precision 1} {@rep:required}
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
431: * @param p_commit API standard (default = F) indicates if transcation will be committed
432: * @rep:paraminfo {@rep:precision 1} {@rep:required}
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)
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
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
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)
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
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
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)
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
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
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
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
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
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)
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
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
868: * The API should be executed in the following order:
869: * INIT_AGREEMENT, LOAD_AGREEMENT, LOAD_FUNDING, EXECUTE_CREATE_AGREEMENT/EXECUTE_UPDATE_
870: AGREEMENT, FETCH_FUNDING
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
870: AGREEMENT, FETCH_FUNDING
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
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
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)
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
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
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)
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
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
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
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
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
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)
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
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
982: );
983:
984: /*#
985: * This API is used to determine if a fund can be added.
986: * @param p_api_version_number API standard: version number
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
984: /*#
985: * This API is used to determine if a fund can be added.
986: * @param p_api_version_number API standard: version number
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
986: * @param p_api_version_number API standard: version number
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
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)
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
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
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
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
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
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)
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
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
1087: );
1088:
1089: /*#
1090: * This API is used to determine if a fund can be updated.
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
1094: * @rep:paraminfo {@rep:precision 1} {@rep:required}
1095: * @param p_init_msg_list API standard (default = F) indicates if message stack will be initialized
1089: /*#
1090: * This API is used to determine if a fund can be updated.
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
1094: * @rep:paraminfo {@rep:precision 1} {@rep:required}
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
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
1094: * @rep:paraminfo {@rep:precision 1} {@rep:required}
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
1093: * @param p_commit API standard (default = F) indicates if transcation will be committed
1094: * @rep:paraminfo {@rep:precision 1} {@rep:required}
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)
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
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
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
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
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
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)
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
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