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_DELIVERABLE_UTILS dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 45: ,p_dlvr_version_id IN pa_proj_element_versions.element_version_id%TYPE

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

Line 47: ,p_action_version_id IN pa_proj_element_versions.element_version_id%TYPE

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

Line 67: ,p_dlvr_version_id IN pa_proj_element_versions.element_version_id%TYPE

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

Line 74: ,p_dlvr_version_id IN pa_proj_element_versions.element_version_id%TYPE

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

Line 89: ,p_dlvr_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

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

Line 103: ,x_element_version_id OUT NOCOPY PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE --File.Sql.39 bug 4440895

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

Line 151: ,p_task_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

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:

Line 159: ,p_task_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

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

Line 165: p_dlvr_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

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:

Line 172: p_dlvr_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

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

Line 173: ,p_task_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

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

Line 181: p_dlvr_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

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

Line 182: ,p_task_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

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

Line 192: ,p_dlv_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL

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: (

Line 198: ,p_dlv_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

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: (

Line 204: ,p_dlv_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

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: (

Line 228: p_dlvr_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

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:

Line 238: p_dlvr_action_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

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:

Line 248: p_dlvr_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

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

Line 256: p_dlvr_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

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:

Line 266: p_dlvr_action_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

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:

Line 275: p_task_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

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

Line 283: p_action_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

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

Line 291: p_action_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

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'

Line 317: ,p_wp_task_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

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

Line 318: ,p_fp_task_verison_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

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

Line 360: p_action_version_id IN pa_proj_element_versions.element_version_id%TYPE

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(

Line 371: p_deliverable_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

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

Line 380: p_deliverable_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

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:

Line 389: p_deliverable_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

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: (

Line 394: 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

Line 401: p_deliverable_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

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 ========*/

Line 583: ,p_dlv_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

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: (

Line 589: ,p_dlv_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

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: (

Line 595: ,p_dlv_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

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:

Line 623: p_dlvr_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

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

Line 624: ,x_ship_id OUT NOCOPY PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE --File.Sql.39 bug 4440895

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

Line 627: ,x_proc_id OUT NOCOPY PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE --File.Sql.39 bug 4440895

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: