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_ELEMENTS

Line 39: p_deliverable_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

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

Line 44: ,p_dlvr_item_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

Line 46: ,p_action_item_id IN pa_proj_elements.proj_element_id%TYPE

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

Line 66: ,p_dlvr_item_id IN pa_proj_elements.proj_element_id%TYPE

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:

Line 73: ,p_dlvr_item_id IN pa_proj_elements.proj_element_id%TYPE

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

Line 76: ,p_dlvr_status_code IN PA_PROJ_ELEMENTS.STATUS_CODE%TYPE

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

Line 82: FUNCTION GET_FUNCTION_CODE(p_action_element_id IN pa_proj_elements.proj_element_id%TYPE)

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 ;

Line 88: FUNCTION IS_DLV_DOC_DEFINED(p_dlvr_item_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

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:

Line 100: ,p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE

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

Line 102: ,x_proj_element_id OUT NOCOPY PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE --File.Sql.39 bug 4440895

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

Line 111: p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE

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

Line 112: ,p_task_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

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:

Line 119: p_task_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

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

Line 124: p_project_id IN PA_PROJ_ELEMENTS.PROJECT_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

Line 125: ,p_proj_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

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

Line 130: p_project_id IN PA_PROJ_ELEMENTS.PROJECT_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

Line 131: ,p_proj_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

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

Line 136: p_project_id IN PA_PROJ_ELEMENTS.PROJECT_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

Line 137: ,p_proj_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

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

Line 150: p_project_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

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

Line 158: p_project_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

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:

Line 175: ,p_function_code IN PA_PROJ_ELEMENTS.FUNCTION_CODE%TYPE

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

Line 191: p_dlv_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

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

Line 197: p_dlv_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

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

Line 203: p_dlv_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_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

Line 209: p_proj_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_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

Line 213: p_proj_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

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

Line 229: ,x_name OUT NOCOPY PA_PROJ_ELEMENTS.NAME%TYPE --File.Sql.39 bug 4440895

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

Line 230: ,x_number OUT NOCOPY PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE --File.Sql.39 bug 4440895

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

Line 239: ,x_name OUT NOCOPY PA_PROJ_ELEMENTS.NAME%TYPE --File.Sql.39 bug 4440895

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

Line 240: ,x_number OUT NOCOPY PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE --File.Sql.39 bug 4440895

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

Line 257: ,x_project_id OUT NOCOPY PA_PROJ_ELEMENTS.PROJECT_ID%TYPE --File.Sql.39 bug 4440895

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

Line 267: ,x_project_id OUT NOCOPY PA_PROJ_ELEMENTS.PROJECT_ID%TYPE --File.Sql.39 bug 4440895

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

Line 297: ,p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE

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
300: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
301: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 327: ,p_task_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

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

Line 328: ,p_prog_method_code IN PA_PROJ_ELEMENTS.BASE_PERCENT_COMP_DERIV_CODE%TYPE

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

Line 337: ,p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE

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

Line 346: p_task_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

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

Line 410: , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

Line 411: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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
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
415: , px_actual_finish_date IN OUT NOCOPY DATE --File.Sql.39 bug 4440895

Line 412: , px_dlvr_owner_id IN OUT NOCOPY PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE --File.Sql.39 bug 4440895

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
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
415: , px_actual_finish_date IN OUT NOCOPY DATE --File.Sql.39 bug 4440895
416: , px_progress_weight IN OUT NOCOPY PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE --File.Sql.39 bug 4440895

Line 414: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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
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
415: , px_actual_finish_date IN OUT NOCOPY DATE --File.Sql.39 bug 4440895
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

Line 416: , px_progress_weight IN OUT NOCOPY PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE --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
415: , px_actual_finish_date IN OUT NOCOPY DATE --File.Sql.39 bug 4440895
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

Line 419: , p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE

415: , px_actual_finish_date IN OUT NOCOPY DATE --File.Sql.39 bug 4440895
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

Line 420: , p_task_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

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

Line 505: , px_progress_weight IN OUT NOCOPY PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE --File.Sql.39 bug 4440895

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:

Line 582: p_dlv_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

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

Line 588: p_dlv_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_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

Line 594: p_dlv_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_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

Line 604: ,x_bill_description OUT NOCOPY PA_PROJ_ELEMENTS.DESCRIPTION%TYPE --File.Sql.39 bug 4440895

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

Line 625: ,x_ship_name OUT NOCOPY PA_PROJ_ELEMENTS.NAME%TYPE --File.Sql.39 bug 4440895

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

Line 628: ,x_proc_name OUT NOCOPY PA_PROJ_ELEMENTS.NAME%TYPE --File.Sql.39 bug 4440895

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;