[Home] [Help]
PACKAGE: APPS.PA_DELIVERABLE_UTILS
Source
1 PACKAGE PA_DELIVERABLE_UTILS AS
2 /* $Header: PADLUTLS.pls 120.1 2005/08/19 16:21:20 mwasowic noship $ */
3
4 l_err_message Fnd_New_Messages.Message_text%TYPE; -- for AMG message
5
6 FUNCTION IS_DLV_TYPE_NAME_UNIQUE
7 (
8 p_deliverable_type_name IN VARCHAR2
9 ) RETURN VARCHAR2;
10
11 FUNCTION IS_DLV_TYPE_IN_USE
12 (
13 p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
14 ) RETURN VARCHAR2;
15
16 FUNCTION IS_DLV_TYPE_ACTIONS_EXISTS
17 (
18 p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
19 ) RETURN VARCHAR2;
20
21 FUNCTION IS_DLV_ACTIONS_EXISTS
22 (
23 p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
24 ) RETURN VARCHAR2;
25
26 FUNCTION IS_DLV_BASED_ASSCN_EXISTS
27 (
28 p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
29 ) RETURN VARCHAR2;
30
31 FUNCTION IS_EFF_FROM_TO_DATE_VALID
32 (
33 p_start_date_active IN DATE,
34 p_end_date_active IN DATE
35 ) RETURN VARCHAR2;
36
37 FUNCTION GET_ASSOCIATED_TASKS
38 (
39 p_deliverable_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
40 ) RETURN VARCHAR2;
41
42 PROCEDURE GET_OKE_FLAGS
43 ( p_project_id IN pa_projects_all.project_id%TYPE
44 ,p_dlvr_item_id IN pa_proj_elements.proj_element_id%TYPE
45 ,p_dlvr_version_id IN pa_proj_element_versions.element_version_id%TYPE
46 ,p_action_item_id IN pa_proj_elements.proj_element_id%TYPE
47 ,p_action_version_id IN pa_proj_element_versions.element_version_id%TYPE
48 ,p_calling_module IN VARCHAR2
49 ,x_ready_to_ship OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
50 ,x_ready_to_procure OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
51 ,x_planning_initiated OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
52 ,x_proc_initiated OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
53 ,x_shipping_initiated OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
54 ,x_item_exists OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
55 ,x_item_shippable OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
56 ,x_item_billable OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
57 ,x_item_purchasable OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
58 ,x_ship_procure_flag_dlv OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
59 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
60 ,x_msg_count OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
61 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
62 ) ;
63
64 FUNCTION IS_TASK_ASSGMNT_EXISTS
65 ( p_project_id IN pa_projects_all.project_id%TYPE
66 ,p_dlvr_item_id IN pa_proj_elements.proj_element_id%TYPE
67 ,p_dlvr_version_id IN pa_proj_element_versions.element_version_id%TYPE
68 )
69 RETURN VARCHAR2 ;
70
71 PROCEDURE IS_DLV_STATUS_CHANGE_ALLOWED
72 ( p_project_id IN pa_projects_all.project_id%TYPE
73 ,p_dlvr_item_id IN pa_proj_elements.proj_element_id%TYPE
74 ,p_dlvr_version_id IN pa_proj_element_versions.element_version_id%TYPE
75 ,p_dlv_type_id IN pa_task_types.task_type_id%TYPE
76 ,p_dlvr_status_code IN PA_PROJ_ELEMENTS.STATUS_CODE%TYPE
77 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
78 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
79 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
80 );
81
82 FUNCTION GET_FUNCTION_CODE(p_action_element_id IN pa_proj_elements.proj_element_id%TYPE)
83 RETURN VARCHAR2 ;
84
85 FUNCTION GET_DLV_TYPE_CLASS_CODE(p_dlvr_type_id IN pa_task_types.task_type_id%TYPE )
86 RETURN VARCHAR2 ;
87
88 FUNCTION IS_DLV_DOC_DEFINED(p_dlvr_item_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
89 ,p_dlvr_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
90 )
91 RETURN VARCHAR2 ;
92
93 -- dthakker added the below procedures and functions
94
95
96 PROCEDURE GET_STRUCTURE_INFO
97 (
98 p_api_version IN NUMBER := 1.0
99 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
100 ,p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
101 ,p_structure_type IN VARCHAR2 := 'DELIVERABLE'
102 ,x_proj_element_id OUT NOCOPY PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE --File.Sql.39 bug 4440895
103 ,x_element_version_id OUT NOCOPY PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE --File.Sql.39 bug 4440895
104 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
105 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
106 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
107 );
108
109 FUNCTION GET_CARRYING_OUT_ORG
110 (
111 p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
112 ,p_task_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
113 ) RETURN NUMBER ;
114
115 -- 3625019
116
117 FUNCTION GET_PROGRESS_ROLLUP_METHOD
118 (
119 p_task_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
120 ) RETURN VARCHAR2;
121
122 FUNCTION IS_DELIVERABLE_HAS_PROGRESS
123 (
124 p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
125 ,p_proj_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
126 ) RETURN VARCHAR2;
127
128 FUNCTION IS_BILLING_FUNCTION_EXISTS
129 (
130 p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
131 ,p_proj_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
132 ) RETURN VARCHAR2;
133
134 FUNCTION IS_ACTIONS_EXISTS
135 (
136 p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
137 ,p_proj_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
138 ) RETURN VARCHAR2;
139
140 PROCEDURE GET_DLVR_TYPE_INFO
141 (
142 p_dlvr_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
143 ,x_dlvr_prg_enabled OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
144 ,x_dlvr_action_enabled OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
145 ,x_dlvr_default_status_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
146 );
147
148 PROCEDURE GET_DEFAULT_DLVR_OWNER
149 (
150 p_project_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
151 ,p_task_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
152 ,x_owner_id OUT NOCOPY PER_ALL_PEOPLE_F.PERSON_ID%TYPE --File.Sql.39 bug 4440895
153 ,x_owner_name OUT NOCOPY PER_ALL_PEOPLE_F.FULL_NAME%TYPE --File.Sql.39 bug 4440895
154 );
155
156 PROCEDURE GET_DEFAULT_DLVR_DATE
157 (
158 p_project_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
159 ,p_task_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
160 ,x_due_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
161 );
162
163 PROCEDURE GET_DEFAULT_ACTION_OWNER
164 (
165 p_dlvr_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
166 ,x_owner_id OUT NOCOPY PER_ALL_PEOPLE_F.PERSON_ID%TYPE --File.Sql.39 bug 4440895
167 ,x_owner_name OUT NOCOPY PER_ALL_PEOPLE_F.FULL_NAME%TYPE --File.Sql.39 bug 4440895
168 );
169
170 PROCEDURE GET_DEFAULT_ACTION_DATE
171 (
172 p_dlvr_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
173 ,p_task_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
174 ,p_project_mode IN VARCHAR2
175 ,p_function_code IN PA_PROJ_ELEMENTS.FUNCTION_CODE%TYPE
176 ,x_due_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
177 );
178
179 PROCEDURE GET_DEFAULT_ACTN_DATE
180 (
181 p_dlvr_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
182 ,p_task_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
183 ,p_project_mode IN VARCHAR2
184 ,x_due_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
185 ,x_earliest_start_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
186 ,x_earliest_finish_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
187 );
188
189 FUNCTION IS_DLV_BASED_ASSCN_EXISTS
190 (
191 p_dlv_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
192 ,p_dlv_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL
193 ) RETURN VARCHAR2 ;
194
195 FUNCTION GET_READY_TO_SHIP_FLAG
196 (
197 p_dlv_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
198 ,p_dlv_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
199 ) RETURN VARCHAR2;
200
201 FUNCTION GET_READY_TO_PROC_FLAG
202 (
203 p_dlv_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
204 ,p_dlv_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
205 ) RETURN VARCHAR2;
206
207 FUNCTION IS_PROG_ENABLED_DLV_EXISTS
208 (
209 p_proj_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
210 ) RETURN VARCHAR2;
211 FUNCTION IS_PROGRESS_ENABLED
212 (
213 p_proj_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
214 ) RETURN VARCHAR2;
215
216 PROCEDURE GET_PROJECT_DETAILS
217 (
218 p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE
219 ,x_projfunc_currency_code OUT NOCOPY PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE --File.Sql.39 bug 4440895
220 ,x_org_id OUT NOCOPY PA_PLAN_RES_DEFAULTS.item_master_id%TYPE -- 3462360 changed type --File.Sql.39 bug 4440895
221 );
222
223 -- OKEAPI
224 -- This API will return deliverable name and number based on
225 -- deliverable version id
226 PROCEDURE GET_DLVR_DETAIL
227 (
228 p_dlvr_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
229 ,x_name OUT NOCOPY PA_PROJ_ELEMENTS.NAME%TYPE --File.Sql.39 bug 4440895
230 ,x_number OUT NOCOPY PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE --File.Sql.39 bug 4440895
231 );
232
233 -- OKEAPI
234 -- This API will return action name and number based on
235 -- action version id
236 PROCEDURE GET_ACTION_DETAIL
237 (
238 p_dlvr_action_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
239 ,x_name OUT NOCOPY PA_PROJ_ELEMENTS.NAME%TYPE --File.Sql.39 bug 4440895
240 ,x_number OUT NOCOPY PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE --File.Sql.39 bug 4440895
241 );
242
243 -- OKEAPI
244 -- This API will return projfunc currency code
245 -- for given deliverable version id .
246 FUNCTION GET_PROJ_CURRENCY_CODE
247 (
248 p_dlvr_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
249 ) RETURN VARCHAR2;
250
251 -- OKEAPI
252 -- This API will return project id and project name
253 -- based on deliverable version id
254 PROCEDURE GET_DLVR_PROJECT_DETAIL
255 (
256 p_dlvr_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
257 ,x_project_id OUT NOCOPY PA_PROJ_ELEMENTS.PROJECT_ID%TYPE --File.Sql.39 bug 4440895
258 ,x_project_name OUT NOCOPY PA_PROJECTS_ALL.NAME%TYPE --File.Sql.39 bug 4440895
259 );
260
261 -- OKEAPI
262 -- This API will return project id and project name
263 -- based on action version id
264 PROCEDURE GET_ACTION_PROJECT_DETAIL
265 (
266 p_dlvr_action_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
267 ,x_project_id OUT NOCOPY PA_PROJ_ELEMENTS.PROJECT_ID%TYPE --File.Sql.39 bug 4440895
268 ,x_project_name OUT NOCOPY PA_PROJECTS_ALL.NAME%TYPE --File.Sql.39 bug 4440895
269 );
270
271 -- OKEAPI
272 -- This API will return task number based on task version id
273 FUNCTION GET_ACTION_TASK_DETAIL
274 (
275 p_task_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
276 ) RETURN VARCHAR2;
277
278 -- OKEAPI
279 -- This API will return deliverable description
280 -- based on action version id
281 FUNCTION GET_DLV_DESCRIPTION
282 (
283 p_action_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
284 ) RETURN VARCHAR2;
285
286 -- OKEAPI
287 -- This API will return 'Y' if deliverable is itrm based or not
288 -- based on action version id. Else will return 'N'
289 FUNCTION IS_DLV_ITEM_BASED
290 (
291 p_action_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
292 ) RETURN VARCHAR2;
293
294 PROCEDURE CHECK_DLVR_DISABLE_ALLOWED( p_api_version IN NUMBER := 1.0
295 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
296 ,p_debug_mode IN VARCHAR2 := 'N'
297 ,p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
298 ,x_return_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
299 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
303
300 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
301 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
302 );
304 PROCEDURE UPDATE_TSK_STATUS_CANCELLED( p_api_version IN NUMBER := 1.0
305 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
306 ,p_debug_mode IN VARCHAR2 := 'N'
307 ,p_task_id IN NUMBER
308 ,p_status_code IN PA_PROJECT_STATUSES.PROJECT_STATUS_CODE%TYPE
309 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
310 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
311 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
312 );
313
314 PROCEDURE CHECK_CHANGE_MAPPING_OK( p_api_version IN NUMBER := 1.0
315 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
316 ,p_debug_mode IN VARCHAR2 := 'N'
317 ,p_wp_task_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
318 ,p_fp_task_verison_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
319 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
320 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
321 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
322 );
323
324 PROCEDURE CHECK_PROGRESS_MTH_CODE_VALID( p_api_version IN NUMBER := 1.0
325 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
326 ,p_debug_mode IN VARCHAR2 := 'N'
327 ,p_task_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
328 ,p_prog_method_code IN PA_PROJ_ELEMENTS.BASE_PERCENT_COMP_DERIV_CODE%TYPE
329 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
330 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
331 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
332 );
333
334 FUNCTION CHECK_PROJ_DLV_TXN_EXISTS( p_api_version IN NUMBER := 1.0
335 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
336 ,p_debug_mode IN VARCHAR2 := 'N'
337 ,p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
338 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
339 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
340 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
341 )
342 RETURN VARCHAR2;
343
344 FUNCTION GET_ASSOCIATED_DELIVERABLES
345 (
346 p_task_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
347 ) RETURN VARCHAR2;
348
349 FUNCTION GET_ADJUSTED_DATES
350 (
351 p_project_id IN pa_projects_all.project_id%TYPE
352 ,p_dlv_due_date IN DATE
353 ,p_delta IN NUMBER
354 ) RETURN DATE ;
355
356 FUNCTION IS_ITEM_BASED_DLV_EXISTS RETURN VARCHAR2 ;
357
358 FUNCTION IS_BILLING_FUNCTION
359 (
360 p_action_version_id IN pa_proj_element_versions.element_version_id%TYPE
361 )
362 RETURN VARCHAR2 ;
363
364 FUNCTION Get_Project_Type_Class(
365 p_project_id NUMBER ,
366 x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
367 ) RETURN VARCHAR2;
368
369 FUNCTION IS_DLVR_ITEM_BASED
370 (
371 p_deliverable_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
372 )
373 RETURN VARCHAR2;
374
375 -- 3470061 oke needed this api which will take deliverable version id as in parameter
376 -- and return deliverable description
377
378 FUNCTION GET_DELIVERABLE_DESCRIPTION
379 (
380 p_deliverable_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
381 ) RETURN VARCHAR2;
382
383 -- 3470061
384
385 -- 3454572 added function for TM Home Page
386
387 FUNCTION GET_DLVR_NAME_NUMBER
388 (
389 p_deliverable_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
390 ) RETURN VARCHAR2;
391
392 FUNCTION GET_DLVR_NUMBER
393 (
394 p_deliverable_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
395 ) RETURN VARCHAR2;
396
397 -- 3454572 end
398 -- 3442451 added for deliverable security
399 FUNCTION IS_DLVR_OWNER
400 (
401 p_deliverable_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
402 ,p_user_id IN NUMBER
403 ) RETURN VARCHAR2;
404 -- 3442451
405 /* ==============3435905 : FP M : Deliverables Changes For AMG START ========*/
406 Procedure Validate_Deliverable
407 (
408 p_deliverable_id IN NUMBER
409 , p_deliverable_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
410 , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
411 , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
415 , px_actual_finish_date IN OUT NOCOPY DATE --File.Sql.39 bug 4440895
412 , px_dlvr_owner_id IN OUT NOCOPY PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE --File.Sql.39 bug 4440895
413 , p_dlvr_owner_name IN VARCHAR2 := NULL
414 , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
416 , px_progress_weight IN OUT NOCOPY PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE --File.Sql.39 bug 4440895
417 , px_status_code IN OUT NOCOPY Pa_task_types.initial_status_code%TYPE --File.Sql.39 bug 4440895
418 , p_carrying_out_org_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
419 , p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
420 , p_task_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
421 , p_calling_mode IN VARCHAR2 := 'INSERT'
422 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
423 , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
424 , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
425 ) ;
426
427 FUNCTION IS_DLV_TYPE_ID_VALID
428 (
429 p_deliverable_type_id IN NUMBER
430 ) RETURN VARCHAR2 ;
431
432 FUNCTION IS_STATUS_CODE_VALID
433 (
434 p_status_code IN VARCHAR2
435 , p_calling_mode IN VARCHAR2 := 'INSERT'
436 ) RETURN VARCHAR2;
437
438 FUNCTION get_deliverable_version_id
439 (
440 p_deliverable_id IN NUMBER ,
441 p_structure_version_id IN NUMBER ,
442 p_project_id IN NUMBER
443 ) RETURN NUMBER;
444
445 PROCEDURE is_dlvr_reference_unique
446 (
447 p_deliverable_reference IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
448 ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
449 ,x_unique_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
450 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
451 );
452
453 PROCEDURE Convert_pm_dlvrref_to_id
454 (
455 p_deliverable_reference IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
456 ,p_deliverable_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
457 ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
458 ,p_out_deliverable_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
459 ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
460 );
461
462 FUNCTION get_action_version_id
463 (
464 p_action_id IN NUMBER ,
465 p_structure_version_id IN NUMBER ,
466 p_project_id IN NUMBER
467 ) RETURN NUMBER;
468
469 FUNCTION IS_FUNCTION_CODE_VALID
470 (
471 p_function_code IN VARCHAR2
472 ) RETURN VARCHAR2;
473
474 FUNCTION GET_DLVR_TASK_ASSCN_ID
475 (
476 p_deliverable_id IN NUMBER ,
477 p_task_id IN NUMBER
478 ) RETURN NUMBER;
479
480 PROCEDURE is_action_reference_unique
481 (
482 p_action_reference IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
483 ,p_deliverable_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
484 ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
485 ,x_unique_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
486 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
487 );
488
489 PROCEDURE Convert_pm_actionref_to_id
490 (
491 p_action_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
492 ,p_action_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
493 ,p_deliverable_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
494 ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
495 ,p_out_action_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
496 ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
497 );
498
499 PROCEDURE Progress_Enabled_Validation
500 (
501 p_deliverable_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
502 , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
503 , p_dlvr_type_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
504 , px_actual_finish_date IN OUT NOCOPY DATE --File.Sql.39 bug 4440895
505 , px_progress_weight IN OUT NOCOPY PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE --File.Sql.39 bug 4440895
506 , px_status_code IN OUT NOCOPY Pa_task_types.initial_status_code%TYPE --File.Sql.39 bug 4440895
507 , p_calling_Mode IN VARCHAR2 := 'INSERT'
508 ) ;
509
510 Procedure enable_deliverable(
511 p_api_version IN NUMBER := 1.0
512 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
513 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
514 , p_debug_mode IN VARCHAR2 := 'N'
515 , p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
516 , p_project_id IN Pa_Projects_All.project_id%TYPE
517 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
518 , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
519 , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
520 );
521 /* ==============3435905 : FP M : Deliverables Changes For AMG END ========*/
522
523 FUNCTION IS_DLV_PROGRESSABLE
524 (
525 p_project_id IN NUMBER
526 ,p_deliverable_id IN NUMBER
527 ) RETURN VARCHAR2;
528
529 FUNCTION IS_STR_TASK_HAS_DELIVERABLES
530 (
531 p_str_task_id IN NUMBER
532 ) RETURN VARCHAR2;
533
534 -- 3442451
535
536 FUNCTION GET_TASK_DATES
537 (
538 p_project_id IN NUMBER
539 ,p_date_type IN VARCHAR2
540 ,p_task_id IN NUMBER
541 ) RETURN DATE;
542
543 -- 3442451
544
545
546 FUNCTION IS_DLV_BASED_TASK_EXISTS
547 (
548 p_project_id IN NUMBER
549 ) RETURN VARCHAR2;
550
551 FUNCTION IS_DELIVERABLES_DEFINED
552 (
553 p_project_id IN NUMBER
554 ) RETURN VARCHAR2;
555
556 FUNCTION CHECK_USER_VIEW_DLV_PRIVILEGE
557 (
558 p_project_id IN NUMBER
559 ) RETURN VARCHAR2;
560
561 -- 3586196 added two out parameters for task names
562 -- added two out parameters for task numbers
563
564 PROCEDURE GET_DEFAULT_TASK
565 (
566 p_dlv_element_id IN NUMBER
567 ,p_dlv_version_id IN NUMBER
568 ,p_project_id IN NUMBER
569 ,x_oke_task_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
570 ,x_oke_task_name OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
571 ,x_oke_task_number OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
572 ,x_bill_task_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
573 ,x_bill_task_name OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
574 ,x_bill_task_number OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
575 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
576 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
577 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
578 ) ;
579
580 FUNCTION IS_SHIPPING_INITIATED
581 (
582 p_dlv_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
583 ,p_dlv_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
584 ) RETURN VARCHAR2;
585
586 FUNCTION IS_PROCUREMENT_INITIATED
587 (
588 p_dlv_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
589 ,p_dlv_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
590 ) RETURN VARCHAR2;
591
592 FUNCTION IS_BILLING_EVENT_PROCESSED
593 (
594 p_dlv_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
595 ,p_dlv_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
596 ) RETURN VARCHAR2;
597
598 -- 3622126 added for action dates not in synch with billing txn date
599
600 PROCEDURE GET_BILLING_DETAILS
601 (
602 p_action_version_id IN PA_PROJ_ELEM_VER_SCHEDULE.ELEMENT_VERSION_ID%TYPE
603 ,x_bill_completion_date OUT NOCOPY PA_PROJ_ELEM_VER_SCHEDULE.ACTUAL_FINISH_DATE%TYPE --File.Sql.39 bug 4440895
604 ,x_bill_description OUT NOCOPY PA_PROJ_ELEMENTS.DESCRIPTION%TYPE --File.Sql.39 bug 4440895
605 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
606 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
607 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
608 ) ;
609
610 -- 3651340 added for retrieving task version id and parent structure version id
611
612 FUNCTION GET_TASK_INFO
613 (
614 p_project_id IN NUMBER
615 ,p_task_id IN NUMBER
616 ,p_task_or_struct IN VARCHAR2
617 ) RETURN NUMBER;
618
619 -- added for bug# 3911050
620
621 PROCEDURE GET_SHIP_PROC_ACTN_DETAIL
622 (
623 p_dlvr_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
624 ,x_ship_id OUT NOCOPY PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE --File.Sql.39 bug 4440895
625 ,x_ship_name OUT NOCOPY PA_PROJ_ELEMENTS.NAME%TYPE --File.Sql.39 bug 4440895
626 ,x_ship_due_date OUT NOCOPY PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE --File.Sql.39 bug 4440895
627 ,x_proc_id OUT NOCOPY PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE --File.Sql.39 bug 4440895
628 ,x_proc_name OUT NOCOPY PA_PROJ_ELEMENTS.NAME%TYPE --File.Sql.39 bug 4440895
629 ,x_proc_due_date OUT NOCOPY PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE --File.Sql.39 bug 4440895
630 );
631
632 END PA_DELIVERABLE_UTILS;
633