eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_STATUS_PUB dependencies on STANDARD

Line 17: -- Standard Globals

13: * @rep:doccd 120pjapi.pdf See the Oracle Projects API's, Client Extensions, and Open Interfaces Reference
14: */
15:
16: -- ----------------------------------------------------------------------------------------
17: -- Standard Globals
18: -- ----------------------------------------------------------------------------------------
19:
20: -- WHO Globals
21:

Line 82: * @param p_api_version_number API standard: version number

78: /*#
79: * This is a PL/SQL procedure that updates progress information in the
80: * PA_PERCENT_COMPLETES table as of a given date for all levels of the work
81: * breakdown structure.
82: * @param p_api_version_number API standard: version number
83: * @rep:paraminfo {@rep:required}
84: * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
85: * @rep:paraminfo {@rep:precision 1}
86: * @param p_commit API standard (default = F): indicates if the transaction will be committed

Line 84: * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized

80: * PA_PERCENT_COMPLETES table as of a given date for all levels of the work
81: * breakdown structure.
82: * @param p_api_version_number API standard: version number
83: * @rep:paraminfo {@rep:required}
84: * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
85: * @rep:paraminfo {@rep:precision 1}
86: * @param p_commit API standard (default = F): indicates if the transaction will be committed
87: * @rep:paraminfo {@rep:precision 1}
88: * @param p_return_status API standard: return status of the API (success/failure/unexpected error)

Line 86: * @param p_commit API standard (default = F): indicates if the transaction will be committed

82: * @param p_api_version_number API standard: version number
83: * @rep:paraminfo {@rep:required}
84: * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
85: * @rep:paraminfo {@rep:precision 1}
86: * @param p_commit API standard (default = F): indicates if the transaction will be committed
87: * @rep:paraminfo {@rep:precision 1}
88: * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
89: * @rep:paraminfo {@rep:precision 1}
90: * @param p_msg_count API standard: number of error messages

Line 88: * @param p_return_status API standard: return status of the API (success/failure/unexpected error)

84: * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
85: * @rep:paraminfo {@rep:precision 1}
86: * @param p_commit API standard (default = F): indicates if the transaction will be committed
87: * @rep:paraminfo {@rep:precision 1}
88: * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
89: * @rep:paraminfo {@rep:precision 1}
90: * @param p_msg_count API standard: number of error messages
91: * @param p_msg_data API standard: error message
92: * @rep:paraminfo {@rep:precision 2000}

Line 90: * @param p_msg_count API standard: number of error messages

86: * @param p_commit API standard (default = F): indicates if the transaction will be committed
87: * @rep:paraminfo {@rep:precision 1}
88: * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
89: * @rep:paraminfo {@rep:precision 1}
90: * @param p_msg_count API standard: number of error messages
91: * @param p_msg_data API standard: error message
92: * @rep:paraminfo {@rep:precision 2000}
93: * @param p_project_id The reference code that uniquely identifies the project in Oracle Projects
94: * @param p_pm_project_reference The reference code that uniquely identifies the project in the external system

Line 91: * @param p_msg_data API standard: error message

87: * @rep:paraminfo {@rep:precision 1}
88: * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
89: * @rep:paraminfo {@rep:precision 1}
90: * @param p_msg_count API standard: number of error messages
91: * @param p_msg_data API standard: error message
92: * @rep:paraminfo {@rep:precision 2000}
93: * @param p_project_id The reference code that uniquely identifies the project in Oracle Projects
94: * @param p_pm_project_reference The reference code that uniquely identifies the project in the external system
95: * @param p_task_id The reference code that uniquely identifies the task within a project in Oracle Projects

Line 195: * @param p_api_version_number API standard: version number

191: /*#
192: * This API is a PL/SQL procedure that updates earned value
193: * information in the PA_EARNED_VALUES table for lowest task resource combinations.
194: * You can also use this procedure to update project-task rows.
195: * @param p_api_version_number API standard: version number
196: * @rep:paraminfo {@rep:required}
197: * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
198: * @rep:paraminfo {@rep:precision 1}
199: * @param p_commit API standard (default = F): indicates if the transaction will be committed

Line 197: * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized

193: * information in the PA_EARNED_VALUES table for lowest task resource combinations.
194: * You can also use this procedure to update project-task rows.
195: * @param p_api_version_number API standard: version number
196: * @rep:paraminfo {@rep:required}
197: * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
198: * @rep:paraminfo {@rep:precision 1}
199: * @param p_commit API standard (default = F): indicates if the transaction will be committed
200: * @rep:paraminfo {@rep:precision 1}
201: * @param p_return_status API standard: return status of the API (success/failure/unexpected error)

Line 199: * @param p_commit API standard (default = F): indicates if the transaction will be committed

195: * @param p_api_version_number API standard: version number
196: * @rep:paraminfo {@rep:required}
197: * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
198: * @rep:paraminfo {@rep:precision 1}
199: * @param p_commit API standard (default = F): indicates if the transaction will be committed
200: * @rep:paraminfo {@rep:precision 1}
201: * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
202: * @rep:paraminfo {@rep:precision 1}
203: * @param p_msg_count API standard: number of error messages

Line 201: * @param p_return_status API standard: return status of the API (success/failure/unexpected error)

197: * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
198: * @rep:paraminfo {@rep:precision 1}
199: * @param p_commit API standard (default = F): indicates if the transaction will be committed
200: * @rep:paraminfo {@rep:precision 1}
201: * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
202: * @rep:paraminfo {@rep:precision 1}
203: * @param p_msg_count API standard: number of error messages
204: * @param p_msg_data API standard: error message
205: * @rep:paraminfo {@rep:precision 2000}

Line 203: * @param p_msg_count API standard: number of error messages

199: * @param p_commit API standard (default = F): indicates if the transaction will be committed
200: * @rep:paraminfo {@rep:precision 1}
201: * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
202: * @rep:paraminfo {@rep:precision 1}
203: * @param p_msg_count API standard: number of error messages
204: * @param p_msg_data API standard: error message
205: * @rep:paraminfo {@rep:precision 2000}
206: * @param p_project_id The reference code that uniquely identifies the project in Oracle Projects
207: * @rep:paraminfo {@rep:required}

Line 204: * @param p_msg_data API standard: error message

200: * @rep:paraminfo {@rep:precision 1}
201: * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
202: * @rep:paraminfo {@rep:precision 1}
203: * @param p_msg_count API standard: number of error messages
204: * @param p_msg_data API standard: error message
205: * @rep:paraminfo {@rep:precision 2000}
206: * @param p_project_id The reference code that uniquely identifies the project in Oracle Projects
207: * @rep:paraminfo {@rep:required}
208: * @param p_pm_project_reference The reference code that uniquely identifies the project in the external system

Line 290: * @param p_api_version_number API standard: version number

286: /*#
287: * This API is used to initialize internal PL/SQL tables.
288: * It is recommended to call this API before every call to the
289: * EXECUTE_UPDATE_TASK_PROGRESS API.
290: * @param p_api_version_number API standard: version number
291: * @rep:paraminfo {@rep:required}
292: * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
293: * @rep:paraminfo {@rep:precision 1}
294: * @param p_commit API standard (default = F): indicates if the transaction will be committed

Line 292: * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized

288: * It is recommended to call this API before every call to the
289: * EXECUTE_UPDATE_TASK_PROGRESS API.
290: * @param p_api_version_number API standard: version number
291: * @rep:paraminfo {@rep:required}
292: * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
293: * @rep:paraminfo {@rep:precision 1}
294: * @param p_commit API standard (default = F): indicates if the transaction will be committed
295: * @rep:paraminfo {@rep:precision 1}
296: * @param p_return_status API standard: return status of the API (success/failure/unexpected error)

Line 294: * @param p_commit API standard (default = F): indicates if the transaction will be committed

290: * @param p_api_version_number API standard: version number
291: * @rep:paraminfo {@rep:required}
292: * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
293: * @rep:paraminfo {@rep:precision 1}
294: * @param p_commit API standard (default = F): indicates if the transaction will be committed
295: * @rep:paraminfo {@rep:precision 1}
296: * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
297: * @rep:paraminfo {@rep:precision 1}
298: * @param p_msg_count API standard: number of error messages

Line 296: * @param p_return_status API standard: return status of the API (success/failure/unexpected error)

292: * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
293: * @rep:paraminfo {@rep:precision 1}
294: * @param p_commit API standard (default = F): indicates if the transaction will be committed
295: * @rep:paraminfo {@rep:precision 1}
296: * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
297: * @rep:paraminfo {@rep:precision 1}
298: * @param p_msg_count API standard: number of error messages
299: * @param p_msg_data API standard: error message
300: * @rep:paraminfo {@rep:precision 2000}

Line 298: * @param p_msg_count API standard: number of error messages

294: * @param p_commit API standard (default = F): indicates if the transaction will be committed
295: * @rep:paraminfo {@rep:precision 1}
296: * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
297: * @rep:paraminfo {@rep:precision 1}
298: * @param p_msg_count API standard: number of error messages
299: * @param p_msg_data API standard: error message
300: * @rep:paraminfo {@rep:precision 2000}
301: * @rep:scope public
302: * @rep:lifecycle active

Line 299: * @param p_msg_data API standard: error message

295: * @rep:paraminfo {@rep:precision 1}
296: * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
297: * @rep:paraminfo {@rep:precision 1}
298: * @param p_msg_count API standard: number of error messages
299: * @param p_msg_data API standard: error message
300: * @rep:paraminfo {@rep:precision 2000}
301: * @rep:scope public
302: * @rep:lifecycle active
303: * @rep:displayname Initialize Update Task Progress

Line 321: * @param p_api_version_number API standard: version number

317:
318: /*#
319: * This API is a Load-Execute-Fetch PL/SQL procedure used to load
320: * progress information in the PL/SQL data structures.
321: * @param p_api_version_number API standard: version number
322: * @rep:paraminfo {@rep:required}
323: * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
324: * @rep:paraminfo {@rep:precision 1}
325: * @param p_commit API standard (default = F): indicates if the transaction will be committed

Line 323: * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized

319: * This API is a Load-Execute-Fetch PL/SQL procedure used to load
320: * progress information in the PL/SQL data structures.
321: * @param p_api_version_number API standard: version number
322: * @rep:paraminfo {@rep:required}
323: * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
324: * @rep:paraminfo {@rep:precision 1}
325: * @param p_commit API standard (default = F): indicates if the transaction will be committed
326: * @rep:paraminfo {@rep:precision 1}
327: * @param p_project_id The reference code that uniquely identifies the project in Oracle Projects

Line 325: * @param p_commit API standard (default = F): indicates if the transaction will be committed

321: * @param p_api_version_number API standard: version number
322: * @rep:paraminfo {@rep:required}
323: * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
324: * @rep:paraminfo {@rep:precision 1}
325: * @param p_commit API standard (default = F): indicates if the transaction will be committed
326: * @rep:paraminfo {@rep:precision 1}
327: * @param p_project_id The reference code that uniquely identifies the project in Oracle Projects
328: * @rep:paraminfo {@rep:required}
329: * @param p_pm_project_reference The reference code that uniquely identifies the project in the external system

Line 377: * @param p_return_status API standard: return status of the API (success/failure/unexpected error)

373: * @param P_PM_TASK_ASSGN_REFERENCE The task assignment reference (applicable to task assignments)
374: * @rep:paraminfo {@rep:precision 150}
375: * @param P_ACTUAL_COST_TO_DATE The cumulative actual cost in the transaction currency (applicable to task assignments)
376: * @param p_ACTUAL_EFFORT_TO_DATE The cumulative actual effort (applicable to workplan or financial plan structures, tasks, and task assignments)
377: * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
378: * @rep:paraminfo {@rep:precision 1}
379: * @param p_msg_count API standard: number of error messages
380: * @param p_msg_data API standard: error message
381: * @rep:paraminfo {@rep:precision 2000}

Line 379: * @param p_msg_count API standard: number of error messages

375: * @param P_ACTUAL_COST_TO_DATE The cumulative actual cost in the transaction currency (applicable to task assignments)
376: * @param p_ACTUAL_EFFORT_TO_DATE The cumulative actual effort (applicable to workplan or financial plan structures, tasks, and task assignments)
377: * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
378: * @rep:paraminfo {@rep:precision 1}
379: * @param p_msg_count API standard: number of error messages
380: * @param p_msg_data API standard: error message
381: * @rep:paraminfo {@rep:precision 2000}
382: * @rep:scope public
383: * @rep:lifecycle active

Line 380: * @param p_msg_data API standard: error message

376: * @param p_ACTUAL_EFFORT_TO_DATE The cumulative actual effort (applicable to workplan or financial plan structures, tasks, and task assignments)
377: * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
378: * @rep:paraminfo {@rep:precision 1}
379: * @param p_msg_count API standard: number of error messages
380: * @param p_msg_data API standard: error message
381: * @rep:paraminfo {@rep:precision 2000}
382: * @rep:scope public
383: * @rep:lifecycle active
384: * @rep:displayname Load Task Progress

Line 433: * @param p_api_version_number API standard: version number

429:
430: /*#
431: * This API is a Load-Execute-Fetch PL/SQL procedure
432: * used to update progress information in Oracle Projects.
433: * @param p_api_version_number API standard: version number
434: * @rep:paraminfo {@rep:required}
435: * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
436: * @rep:paraminfo {@rep:precision 1}
437: * @param p_commit API standard (default = F): indicates if the transaction will be committed

Line 435: * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized

431: * This API is a Load-Execute-Fetch PL/SQL procedure
432: * used to update progress information in Oracle Projects.
433: * @param p_api_version_number API standard: version number
434: * @rep:paraminfo {@rep:required}
435: * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
436: * @rep:paraminfo {@rep:precision 1}
437: * @param p_commit API standard (default = F): indicates if the transaction will be committed
438: * @rep:paraminfo {@rep:precision 1}
439: * @param p_return_status API standard: return status of the API (success/failure/unexpected error)

Line 437: * @param p_commit API standard (default = F): indicates if the transaction will be committed

433: * @param p_api_version_number API standard: version number
434: * @rep:paraminfo {@rep:required}
435: * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
436: * @rep:paraminfo {@rep:precision 1}
437: * @param p_commit API standard (default = F): indicates if the transaction will be committed
438: * @rep:paraminfo {@rep:precision 1}
439: * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
440: * @rep:paraminfo {@rep:precision 1}
441: * @param p_msg_count API standard: number of error messages

Line 439: * @param p_return_status API standard: return status of the API (success/failure/unexpected error)

435: * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
436: * @rep:paraminfo {@rep:precision 1}
437: * @param p_commit API standard (default = F): indicates if the transaction will be committed
438: * @rep:paraminfo {@rep:precision 1}
439: * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
440: * @rep:paraminfo {@rep:precision 1}
441: * @param p_msg_count API standard: number of error messages
442: * @param p_msg_data API standard: error message
443: * @rep:paraminfo {@rep:precision 2000}

Line 441: * @param p_msg_count API standard: number of error messages

437: * @param p_commit API standard (default = F): indicates if the transaction will be committed
438: * @rep:paraminfo {@rep:precision 1}
439: * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
440: * @rep:paraminfo {@rep:precision 1}
441: * @param p_msg_count API standard: number of error messages
442: * @param p_msg_data API standard: error message
443: * @rep:paraminfo {@rep:precision 2000}
444: * @rep:scope public
445: * @rep:lifecycle active

Line 442: * @param p_msg_data API standard: error message

438: * @rep:paraminfo {@rep:precision 1}
439: * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
440: * @rep:paraminfo {@rep:precision 1}
441: * @param p_msg_count API standard: number of error messages
442: * @param p_msg_data API standard: error message
443: * @rep:paraminfo {@rep:precision 2000}
444: * @rep:scope public
445: * @rep:lifecycle active
446: * @rep:displayname Execute Update Task Progress

Line 464: * @param p_api_version_number API standard: version number

460:
461:
462: /*#
463: * This API is used to perform project level validations by validating various privileges.
464: * @param p_api_version_number API standard: version number
465: * @rep:paraminfo {@rep:required}
466: * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
467: * @param p_commit API standard (default = F): indicates if the transaction will be committed
468: * @param p_return_status API standard: return status of the API (success/failure/unexpected error)

Line 466: * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized

462: /*#
463: * This API is used to perform project level validations by validating various privileges.
464: * @param p_api_version_number API standard: version number
465: * @rep:paraminfo {@rep:required}
466: * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
467: * @param p_commit API standard (default = F): indicates if the transaction will be committed
468: * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
469: * @rep:paraminfo {@rep:required}
470: * @param p_msg_count API standard: number of error messages

Line 467: * @param p_commit API standard (default = F): indicates if the transaction will be committed

463: * This API is used to perform project level validations by validating various privileges.
464: * @param p_api_version_number API standard: version number
465: * @rep:paraminfo {@rep:required}
466: * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
467: * @param p_commit API standard (default = F): indicates if the transaction will be committed
468: * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
469: * @rep:paraminfo {@rep:required}
470: * @param p_msg_count API standard: number of error messages
471: * @rep:paraminfo {@rep:required}

Line 468: * @param p_return_status API standard: return status of the API (success/failure/unexpected error)

464: * @param p_api_version_number API standard: version number
465: * @rep:paraminfo {@rep:required}
466: * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
467: * @param p_commit API standard (default = F): indicates if the transaction will be committed
468: * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
469: * @rep:paraminfo {@rep:required}
470: * @param p_msg_count API standard: number of error messages
471: * @rep:paraminfo {@rep:required}
472: * @param p_msg_data API standard: error message

Line 470: * @param p_msg_count API standard: number of error messages

466: * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
467: * @param p_commit API standard (default = F): indicates if the transaction will be committed
468: * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
469: * @rep:paraminfo {@rep:required}
470: * @param p_msg_count API standard: number of error messages
471: * @rep:paraminfo {@rep:required}
472: * @param p_msg_data API standard: error message
473: * @rep:paraminfo {@rep:required}
474: * @param p_project_id The unique identifier of the project in Oracle Projects

Line 472: * @param p_msg_data API standard: error message

468: * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
469: * @rep:paraminfo {@rep:required}
470: * @param p_msg_count API standard: number of error messages
471: * @rep:paraminfo {@rep:required}
472: * @param p_msg_data API standard: error message
473: * @rep:paraminfo {@rep:required}
474: * @param p_project_id The unique identifier of the project in Oracle Projects
475: * @rep:paraminfo {@rep:required}
476: * @param p_pm_project_reference The reference code that uniquely identifies the project in the external system