1 PACKAGE pa_status_pub AUTHID DEFINER AS
2 /* $Header: PAPMSTPS.pls 120.5 2006/07/20 12:39:44 vkadimes noship $*/
3 /*#
4 * This package contains PL/SQL APIs that enable external project
5 * management systems to maintain progress information in Oracle Projects.
6 * @rep:scope public
7 * @rep:product PA
8 * @rep:lifecycle active
9 * @rep:displayname Status Pub
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY PA_PROJECT
12 * @rep:category BUSINESS_ENTITY PA_TASK
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
22 G_LAST_UPDATED_BY NUMBER(15) := FND_GLOBAL.USER_ID;
23 G_LAST_UPDATE_DATE DATE := SYSDATE;
24 G_CREATION_DATE DATE := SYSDATE;
25 G_CREATED_BY NUMBER(15) := FND_GLOBAL.USER_ID;
26 G_LAST_UPDATE_LOGIN NUMBER(15) := FND_GLOBAL.LOGIN_ID;
27
28 -- Local Package Globals
29
30 G_PKG_NAME CONSTANT VARCHAR2(30) := ' PA_STATUS_PUB';
31 G_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
32
33 ROW_ALREADY_LOCKED EXCEPTION;
34 PRAGMA EXCEPTION_INIT(ROW_ALREADY_LOCKED, -54);
35
36 /*
37 TYPE PA_TASK_PROGRESS_IN_REC_TYPE IS RECORD
38 (
39 TASK_ID NUMBER := NULL,
40 TASK_NAME VARCHAR2(20) := NULL,
41 TASK_NUMBER VARCHAR2(25) := NULL,
42 PM_TASK_REFERENCE VARCHAR2(150) := NULL,
43 PERCENT_COMPLETE NUMBER := NULL,
44 DESCRIPTION VARCHAR2(250) := NULL,
45 OBJECT_ID NUMBER := NULL,
46 OBJECT_VERSION_ID NUMBER := NULL,
47 OBJECT_TYPE VARCHAR2(30) := NULL,
48 PROGRESS_STATUS_CODE VARCHAR2(150) := NULL,
49 PROGRESS_COMMENT VARCHAR2(4000) := NULL,
50 ACTUAL_START_DATE Date := NULL,
51 ACTUAL_FINISH_DATE Date := NULL,
52 ESTIMATED_START_DATE Date := NULL,
53 ESTIMATED_FINISH_DATE Date := NULL,
54 SCHEDULED_START_DATE Date := NULL,
55 SCHEDULED_FINISH_DATE Date := NULL,
56 TASK_STATUS VARCHAR2(150) := NULL,
57 EST_REMAINING_EFFORT NUMBER := NULL,
58 ACTUAL_WORK_QUANTITY NUMBER := NULL
59 );
60 TYPE PA_TASK_PROGRESS_IN_TBL_TYPE IS TABLE OF PA_TASK_PROGRESS_IN_REC_TYPE
61 INDEX BY BINARY_INTEGER;
62 */
63
64 G_TASK_PROGRESS_in_tbl PA_PROGRESS_PUB.PA_TASK_PROGRESS_LIST_TBL_TYPE;
65 --G_TASK_PROGRESS_in_tbl PA_TASK_PROGRESS_IN_TBL_TYPE;
66 G_TASK_PROGRESS_tbl_count NUMBER:=0;
67 G_PROJECT_ID NUMBER:=0;
68 G_pm_project_reference VARCHAR2(30);
69 G_PM_PRODUCT_CODE VARCHAR2(30);
70 G_STRUCTURE_TYPE VARCHAR2(30);
71 G_AS_OF_DATE DATE;
72 G_bulk_load_flag VARCHAR2(1) :='N';
73
74 -- -----------------------------------------------------------------------------------------
75 -- Procedures
76 -- -----------------------------------------------------------------------------------------
77
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
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
96 * @param p_pm_task_reference The reference code that uniquely identifies the task in the external system
97 * @param p_as_of_date As of date
98 * @rep:paraminfo {@rep:required}
99 * @param p_percent_complete Percent complete
100 * @rep:paraminfo {@rep:required}
101 * @param p_pm_product_code The reference code that identifies the external product
102 * @rep:paraminfo {@rep:precision 30} {@rep:required}
103 * @param p_description The progress overview or description
104 * @rep:paraminfo {@rep:precision 250}
105 * @param p_object_id The project element identifier of the workplan or financial plan structure, task, or deliverable.
106 * Or the resource list member identifier of the assignment in Oracle Projects.
107 * @rep:paraminfo {@rep:required}
108 * @param p_object_version_id The element version identifier of the task or deliverable
109 * @rep:paraminfo {@rep:required}
110 * @param p_object_type The object type (PA_STRUCTURES for project progress, PA_TASKS for task
111 * progress, PA_ASSIGNMENTS for assignment progress, and PA_DELIVERABLES for deliverable progress)
112 * @rep:paraminfo {@rep:precision 30} {@rep:required}
113 * @param p_progress_status_code Project status code
114 * @rep:paraminfo {@rep:precision 150} {@rep:required}
115 * @param p_progress_comment Progress comments
116 * @rep:paraminfo {@rep:precision 4000} {@rep:required}
117 * @param p_actual_start_date Actual start date
118 * @param p_actual_finish_date Actual finish date
119 * @param p_estimated_start_date Estimated start date
120 * @param p_estimated_finish_date Estimated finish date
121 * @param p_scheduled_start_date Scheduled start date
122 * @param p_scheduled_finish_date Scheduled finish date
123 * @param p_task_status The task status code or deliverable status code
124 * @rep:paraminfo {@rep:precision 150} {@rep:required}
125 * @param p_structure_type Type of structure, such as the workplan structure or financial plan structure
126 * @rep:paraminfo {@rep:precision 30} {@rep:required}
127 * @param p_est_remaining_effort The estimate-to-complete effort (applies to tasks and assignments)
128 * @param p_actual_work_quantity Actual work quantity (applicable only to lowest tasks)
129 * @param p_etc_cost Estimate to complete cost (applies to task assignments)
130 * @param P_PM_DELIVERABLE_REFERENCE Deliverable reference (applies to deliverables)
131 * @rep:paraminfo {@rep:precision 150}
132 * @param P_PM_TASK_ASSGN_REFERENCE Task assignment reference (applies to task assignments)
133 * @rep:paraminfo {@rep:precision 150}
134 * @param P_ACTUAL_COST_TO_DATE The cumulative actual cost in transaction cost in
135 * transaction currency (applies to task assignments)
136 * @param P_ACTUAL_EFFORT_TO_DATE The cumulative actual effort (applies to structures, tasks, and task assignments)
137 * @param p_populate_pji_tables Flag indicating whether to populate PJI tables (default = Y)
138 * @param p_rollup_entire_wbs This is an internal attribute
139 * @param p_txn_currency_code Transaction currency code
140 * @rep:scope public
141 * @rep:lifecycle active
142 * @rep:displayname Update Progress
143 * @rep:category BUSINESS_ENTITY PA_PROJECT
144 * @rep:category BUSINESS_ENTITY PA_TASK
145 * @rep:category BUSINESS_ENTITY PA_PROJ_DELIVERABLE
146 * @rep:category BUSINESS_ENTITY PA_TASK_RESOURCE
147 * @rep:compatibility S
148 */
149 PROCEDURE Update_Progress
150 (p_api_version_number IN NUMBER
151 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
152 , p_commit IN VARCHAR2 := FND_API.G_FALSE
153 , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
154 , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
155 , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
156 , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
157 , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
158 , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
159 , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
160 , p_as_of_date IN DATE
161 , p_percent_complete IN NUMBER
162 , p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
163 , p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
164 , p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
165 , p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
166 , p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
167 , p_progress_status_code IN VARCHAR2 := 'PROGRESS_STAT_ON_TRACK'
168 , p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
169 , p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
170 , p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
171 , p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
172 , p_estimated_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
173 , p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
174 , p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
175 , p_task_status IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
176 , p_structure_type IN VARCHAR2 := 'FINANCIAL'
177 , p_est_remaining_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
178 , p_actual_work_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
179 , p_etc_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM /* FP M Task Progress 3420093*/
180 , p_PM_DELIVERABLE_REFERENCE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 3606627
181 , p_PM_TASK_ASSGN_REFERENCE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 3606627
182 , p_ACTUAL_COST_TO_DATE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3606627
183 , p_ACTUAL_EFFORT_TO_DATE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3606627
184 , p_populate_pji_tables IN VARCHAR2 := 'Y' -- Bug 3606627
185 , p_rollup_entire_wbs IN VARCHAR2 := 'N' -- Bug 3606627
186 , p_txn_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
187 -- Fix for Bug # 3988457.
188 );
189
190
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
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
209 * @rep:paraminfo {@rep:precision 30}
210 * @param p_task_id The reference code that uniquely identifies the task in a project in Oracle Projects
211 * @rep:paraminfo {@rep:required}
212 * @param p_pm_task_reference The reference code that uniquely identifies the task in the external system
213 * @rep:paraminfo {@rep:precision 30}
214 * @param p_resource_list_member_id The identification code of the resource list member
215 * @rep:paraminfo {@rep:required}
216 * @param p_resource_alias The alias of the resource
217 * @rep:paraminfo {@rep:precision 30}
218 * @param p_resource_list_name The name of the resource list
219 * @rep:paraminfo {@rep:precision 60}
220 * @param p_as_of_date As of date
221 * @rep:paraminfo {@rep:required}
222 * @param p_bcws_current Budget cost of work performed
223 * @param p_acwp_current Actual cost of work performed
224 * @param p_bcwp_current Budget cost of work performed
225 * @param p_bac_current Budget cost at completion
226 * @param p_bcws_itd Inception-to-date budget cost of work performed
227 * @rep:paraminfo {@rep:required}
228 * @param p_acwp_itd Inception-to-date actual cost of work performed
229 * @rep:paraminfo {@rep:required}
230 * @param p_bcwp_itd Inception-to-date budget cost of work performed
231 * @rep:paraminfo {@rep:required}
232 * @param p_bac_itd Inception-to-date budget cost at completion
233 * @rep:paraminfo {@rep:required}
234 * @param p_bqws_current Budget quantity of work performed
235 * @param p_aqwp_current Actual quantity of work performed
236 * @param p_bqwp_current Budget quantity of work performed
237 * @param p_baq_current Budget quantity at completion
238 * @param p_bqws_itd Inception-to-date budget quantity of work performed
239 * @rep:paraminfo {@rep:required}
240 * @param p_aqwp_itd Inception-to-date actual quantity of work performed
241 * @rep:paraminfo {@rep:required}
242 * @param p_bqwp_itd Inception-to-date budget quantity of work performed
243 * @rep:paraminfo {@rep:required}
244 * @param p_baq_itd Inception-to-date budget quantity at completion
245 * @rep:paraminfo {@rep:required}
246 * @rep:scope public
247 * @rep:lifecycle active
248 * @rep:displayname Update Earned Value
249 * @rep:category BUSINESS_ENTITY PA_PROJECT
250 * @rep:category BUSINESS_ENTITY PA_TASK
251 * @rep:category BUSINESS_ENTITY PA_TASK_RESOURCE
252 * @rep:compatibility S
253 */
254 PROCEDURE Update_Earned_Value
255 (p_api_version_number IN NUMBER
256 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
257 , p_commit IN VARCHAR2 := FND_API.G_FALSE
258 , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
259 , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
260 , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
261 , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
262 , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
263 , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
264 , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
265 , p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
266 , p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
267 , p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
268 , p_as_of_date IN DATE
269 , p_bcws_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
270 , p_acwp_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
271 , p_bcwp_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
272 , p_bac_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
273 , p_bcws_itd IN NUMBER
274 , p_acwp_itd IN NUMBER
275 , p_bcwp_itd IN NUMBER
276 , p_bac_itd IN NUMBER
277 , p_bqws_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
278 , p_aqwp_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
279 , p_bqwp_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
280 , p_baq_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
281 , p_bqws_itd IN NUMBER
282 , p_aqwp_itd IN NUMBER
283 , p_bqwp_itd IN NUMBER
284 , p_baq_itd IN NUMBER);
285
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
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
304 * @rep:category BUSINESS_ENTITY PA_PROJECT
305 * @rep:category BUSINESS_ENTITY PA_TASK
306 * @rep:compatibility S
307 */
308 PROCEDURE Init_Update_Task_Progress
309 (p_api_version_number IN NUMBER
310 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
311 , p_commit IN VARCHAR2 := FND_API.G_FALSE
312 , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
313 , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
314 , p_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
315
316
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
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
330 * @rep:paraminfo {@rep:precision 30}
331 * @param P_PM_PRODUCT_CODE The reference code that identifies the external product
332 * @rep:paraminfo {@rep:precision 30} {@rep:required}
333 * @param P_STRUCTURE_TYPE tThe type of structure, such as the workplan structure or financial plan structure
334 * @rep:paraminfo {@rep:precision 30} {@rep:required}
335 * @param P_AS_OF_DATE As of date
336 * @rep:paraminfo {@rep:required}
337 * @param P_TASK_ID The reference code that uniquely identifies the task in a project in Oracle Projects
338 * @param P_TASK_NAME Task name
339 * @rep:paraminfo {@rep:precision 20}
340 * @param P_TASK_NUMBER Task number
341 * @rep:paraminfo {@rep:precision 25}
342 * @param P_PM_TASK_REFERENCE The reference code that uniquely identifies the task in the external system
343 * @rep:paraminfo {@rep:precision 30}
344 * @param P_PERCENT_COMPLETE Percent complete
345 * @rep:paraminfo {@rep:required}
346 * @param P_DESCRIPTION The progress overview or description
347 * @rep:paraminfo {@rep:precision 250}
348 * @param P_OBJECT_ID The project element identifier of the structure, task, or deliverable. Or the
349 * resource list member identifier of the assignment in Oracle Projects.
350 * @rep:paraminfo {@rep:required}
351 * @param P_OBJECT_VERSION_ID The element version identifier of the task or deliverable
352 * @rep:paraminfo {@rep:required}
353 * @param P_OBJECT_TYPE The object type (PA_STRUCTURES for project progress, PA_TASKS for task progress,
354 * PA_ASSIGNMENTS for assignment progress, and PA_DELIVERABLES for deliverable progress)
355 * @rep:paraminfo {@rep:precision 30} {@rep:required}
356 * @param P_PROGRESS_STATUS_CODE Project status code
357 * @rep:paraminfo {@rep:precision 150} {@rep:required}
358 * @param P_PROGRESS_COMMENT Progress comments
359 * @rep:paraminfo {@rep:precision 4000}
360 * @param P_ACTUAL_START_DATE Actual start date
361 * @param P_ACTUAL_FINISH_DATE Actual finish date
362 * @param P_ESTIMATED_START_DATE Estimated start date
363 * @param P_ESTIMATED_FINISH_DATE Estimated finish date
364 * @param P_SCHEDULED_START_DATE Scheduled start date
365 * @param P_SCHEDULED_FINISH_DATE Scheduled finish date
366 * @param P_TASK_STATUS The task status code or deliverable status code
367 * @rep:paraminfo {@rep:precision 150} {@rep:required}
368 * @param P_EST_REMAINING_EFFORT The estimate-to-complete effort (applicable to tasks and assignments)
369 * @param P_ACTUAL_WORK_QUANTITY The actual work quantity (applicable only for lowest tasks)
370 * @param P_ETC_COST The estimate-to-complete cost (applicable to task assignments)
371 * @param P_PM_DELIVERABLE_REFERENCE The deliverable reference (applicable to deliverables)
372 * @rep:paraminfo {@rep:precision 150}
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}
382 * @rep:scope public
383 * @rep:lifecycle active
384 * @rep:displayname Load Task Progress
385 * @rep:category BUSINESS_ENTITY PA_PROJECT
386 * @rep:category BUSINESS_ENTITY PA_TASK
387 * @rep:category BUSINESS_ENTITY PA_PROJ_DELIVERABLE
388 * @rep:category BUSINESS_ENTITY PA_TASK_RESOURCE
389 * @rep:compatibility S
390 */
391 PROCEDURE Load_Task_Progress
392 (p_api_version_number IN NUMBER
393 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
394 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
395 ,p_project_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
396 ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
397 ,P_PM_PRODUCT_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
398 ,p_STRUCTURE_TYPE IN VARCHAR2 := 'FINANCIAL'
399 ,P_AS_OF_DATE IN DATE
400 ,P_TASK_ID IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
401 ,P_TASK_NAME IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
402 ,P_TASK_NUMBER IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
403 ,P_PM_TASK_REFERENCE IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
404 ,P_PERCENT_COMPLETE IN PA_NUM_1000_NUM
405 ,P_DESCRIPTION IN PA_VC_1000_2000 := PA_VC_1000_2000(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
406 ,P_OBJECT_ID IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
407 ,P_OBJECT_VERSION_ID IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
408 ,P_OBJECT_TYPE IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
409 ,P_PROGRESS_STATUS_CODE IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
410 ,P_PROGRESS_COMMENT IN PA_VC_1000_4000 := PA_VC_1000_4000(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
411 ,P_ACTUAL_START_DATE IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
412 ,P_ACTUAL_FINISH_DATE IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
413 ,P_ESTIMATED_START_DATE IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
414 ,P_ESTIMATED_FINISH_DATE IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
415 ,P_SCHEDULED_START_DATE IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
416 ,P_SCHEDULED_FINISH_DATE IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
417 ,P_TASK_STATUS IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
418 ,P_EST_REMAINING_EFFORT IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
419 ,P_ACTUAL_WORK_QUANTITY IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
420 ,p_etc_cost IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) /* FP M Task Progress 3420093*/
421 ,p_PM_DELIVERABLE_REFERENCE IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) -- Bug 3606627
422 ,p_PM_TASK_ASSGN_REFERENCE IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) -- Bug 3606627
423 ,p_ACTUAL_COST_TO_DATE IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) -- Bug 3606627
424 ,p_ACTUAL_EFFORT_TO_DATE IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) -- Bug 3606627
425 ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
426 ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
427 ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
428 );
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
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
447 * @rep:category BUSINESS_ENTITY PA_PROJECT
448 * @rep:category BUSINESS_ENTITY PA_TASK
449 * @rep:category BUSINESS_ENTITY PA_PROJ_DELIVERABLE
450 * @rep:category BUSINESS_ENTITY PA_TASK_RESOURCE
451 * @rep:compatibility S
452 */
453 PROCEDURE Execute_Update_Task_Progress
454 (p_api_version_number IN NUMBER
455 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
456 , p_commit IN VARCHAR2 := FND_API.G_FALSE
457 , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
458 , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
459 , p_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
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)
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
477 * @param p_project_id_out Project identifier returned from the API
478 * @rep:paraminfo {@rep:required}
479 * @rep:scope public
480 * @rep:lifecycle active
481 * @rep:displayname Perform Project Level Validations
482 * @rep:compatibility S
483 */
484 PROCEDURE Project_Level_Validations
485 (p_api_version_number IN NUMBER
486 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
487 , p_commit IN VARCHAR2 := FND_API.G_FALSE
488 , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
489 , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
490 , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
491 , p_project_id IN NUMBER
492 , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
493 , p_project_id_out OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
494 );
495
496 /* Progress Management Changes. Bug # 3420093. */
497
498 PROCEDURE update_task_progress_amg
499 ( p_api_version IN NUMBER :=1.0
500 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
501 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
502 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
503 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
504 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
505 ,p_debug_mode IN VARCHAR2 :='N'
506 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
507 ,p_progress_mode IN VARCHAR2 := 'FUTURE'
508 ,p_project_id IN NUMBER
509 ,p_structure_version_id IN NUMBER
510 ,p_structure_type IN VARCHAR2
511 ,p_as_of_date IN DATE
512 ,p_task_progress_list_table IN PA_PROGRESS_PUB.PA_TASK_PROGRESS_LIST_TBL_TYPE
513 ,x_return_status OUT NOCOPY VARCHAR2
514 ,x_msg_count OUT NOCOPY NUMBER
515 ,x_msg_data OUT NOCOPY VARCHAR2
516 );
517
518 /* Progress Management Changes. Bug # 3420093. */
519
520 END pa_status_pub;