[Home] [Help]
PACKAGE: APPS.PA_DELIVERABLE_PVT
Source
1 PACKAGE PA_DELIVERABLE_PVT AS
2 /* $Header: PADLVPVS.pls 120.1 2005/08/19 16:21:39 mwasowic noship $ */
3
4 PROCEDURE Create_Deliverable
5 (
6 p_api_version IN NUMBER := 1.0
7 , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
8 , p_commit IN VARCHAR2 := FND_API.G_FALSE
9 , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
10 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
11 , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
12 , p_debug_mode IN VARCHAR2 := 'N'
13 , p_max_msg_count IN NUMBER := NULL
14 , p_record_version_number IN NUMBER := 1
15 , p_object_type IN PA_PROJ_ELEMENTS.OBJECT_TYPE%TYPE := 'PA_DELIVERABLES'
16 , p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
17 , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE
18 , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE
19 , p_dlvr_description IN PA_PROJ_ELEMENTS.DESCRIPTION%TYPE := NULL
20 , p_dlvr_owner_id IN PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE := NULL
21 , p_dlvr_owner_name IN VARCHAR2 := NULL
22 , p_carrying_out_org_id IN PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE := NULL
23 , p_carrying_out_org_name IN VARCHAR2 := NULL
24 , p_dlvr_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL
25 , p_status_code IN PA_PROJ_ELEMENTS.STATUS_CODE%TYPE := NULL
26 , p_parent_structure_id IN PA_PROJ_ELEMENTS.PARENT_STRUCTURE_ID%TYPE
27 , p_parent_struct_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
28 , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := NULL
29 , p_dlvr_type_name IN VARCHAR2 := NULL
30 , p_dlvr_reference IN VARCHAR2 := NULL
31 , p_progress_weight IN PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE := NULL
32 , p_scheduled_finish_date IN PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE := NULL
33 , p_actual_finish_date IN PA_PROJ_ELEM_VER_SCHEDULE.ACTUAL_FINISH_DATE%TYPE := NULL
34 , p_task_id IN NUMBER := NULL
35 , p_task_version_id IN NUMBER := NULL
36 , p_task_name IN VARCHAR2 := NULL
37 , p_attribute_category IN PA_PROJ_ELEMENTS.ATTRIBUTE_CATEGORY%TYPE := NULL
38 , p_attribute1 IN PA_PROJ_ELEMENTS.ATTRIBUTE1%TYPE := NULL
39 , p_attribute2 IN PA_PROJ_ELEMENTS.ATTRIBUTE2%TYPE := NULL
40 , p_attribute3 IN PA_PROJ_ELEMENTS.ATTRIBUTE3%TYPE := NULL
41 , p_attribute4 IN PA_PROJ_ELEMENTS.ATTRIBUTE4%TYPE := NULL
42 , p_attribute5 IN PA_PROJ_ELEMENTS.ATTRIBUTE5%TYPE := NULL
43 , p_attribute6 IN PA_PROJ_ELEMENTS.ATTRIBUTE6%TYPE := NULL
44 , p_attribute7 IN PA_PROJ_ELEMENTS.ATTRIBUTE7%TYPE := NULL
45 , p_attribute8 IN PA_PROJ_ELEMENTS.ATTRIBUTE8%TYPE := NULL
46 , p_attribute9 IN PA_PROJ_ELEMENTS.ATTRIBUTE9%TYPE := NULL
47 , p_attribute10 IN PA_PROJ_ELEMENTS.ATTRIBUTE10%TYPE := NULL
48 , p_attribute11 IN PA_PROJ_ELEMENTS.ATTRIBUTE11%TYPE := NULL
49 , p_attribute12 IN PA_PROJ_ELEMENTS.ATTRIBUTE12%TYPE := NULL
50 , p_attribute13 IN PA_PROJ_ELEMENTS.ATTRIBUTE13%TYPE := NULL
51 , p_attribute14 IN PA_PROJ_ELEMENTS.ATTRIBUTE14%TYPE := NULL
52 , p_attribute15 IN PA_PROJ_ELEMENTS.ATTRIBUTE15%TYPE := NULL
53 , p_dlvr_item_id OUT NOCOPY PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE --File.Sql.39 bug 4440895
54 , p_pm_source_code IN VARCHAR2 := NULL /* Bug no. 3651113 */
55 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
56 , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
57 , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
58 );
59
60 PROCEDURE Update_Deliverable
61 (
62 p_api_version IN NUMBER := 1.0
63 , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
64 , p_commit IN VARCHAR2 := FND_API.G_FALSE
65 , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
66 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
67 , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
68 , p_debug_mode IN VARCHAR2 := 'N'
69 , p_max_msg_count IN NUMBER := NULL
70 , p_record_version_number IN NUMBER := 1
71 , p_object_type IN PA_PROJ_ELEMENTS.OBJECT_TYPE%TYPE := 'PA_DELIVERABLES'
72 , p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
73 , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE
74 , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE
75 , p_dlvr_description IN PA_PROJ_ELEMENTS.DESCRIPTION%TYPE := NULL
76 , p_dlvr_owner_id IN PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE := NULL
77 , p_dlvr_owner_name IN VARCHAR2 := NULL
78 , p_carrying_out_org_id IN PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE := NULL
79 , p_carrying_out_org_name IN VARCHAR2 := NULL
80 , p_dlvr_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL
81 , p_status_code IN PA_PROJ_ELEMENTS.STATUS_CODE%TYPE := NULL
82 , p_parent_structure_id IN PA_PROJ_ELEMENTS.PARENT_STRUCTURE_ID%TYPE := NULL
83 , p_parent_struct_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
84 , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := NULL
85 , p_dlvr_type_name IN VARCHAR2 := NULL
86 , p_progress_weight IN PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE := NULL
87 , p_scheduled_finish_date IN PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE := NULL
88 , p_actual_finish_date IN PA_PROJ_ELEM_VER_SCHEDULE.ACTUAL_FINISH_DATE%TYPE := NULL
89 , p_task_id IN NUMBER := NULL
90 , p_task_version_id IN NUMBER := NULL
91 , p_task_name IN VARCHAR2 := NULL
92 , p_attribute_category IN PA_PROJ_ELEMENTS.ATTRIBUTE_CATEGORY%TYPE := NULL
93 , p_attribute1 IN PA_PROJ_ELEMENTS.ATTRIBUTE1%TYPE := NULL
94 , p_attribute2 IN PA_PROJ_ELEMENTS.ATTRIBUTE2%TYPE := NULL
95 , p_attribute3 IN PA_PROJ_ELEMENTS.ATTRIBUTE3%TYPE := NULL
96 , p_attribute4 IN PA_PROJ_ELEMENTS.ATTRIBUTE4%TYPE := NULL
97 , p_attribute5 IN PA_PROJ_ELEMENTS.ATTRIBUTE5%TYPE := NULL
98 , p_attribute6 IN PA_PROJ_ELEMENTS.ATTRIBUTE6%TYPE := NULL
99 , p_attribute7 IN PA_PROJ_ELEMENTS.ATTRIBUTE7%TYPE := NULL
100 , p_attribute8 IN PA_PROJ_ELEMENTS.ATTRIBUTE8%TYPE := NULL
101 , p_attribute9 IN PA_PROJ_ELEMENTS.ATTRIBUTE9%TYPE := NULL
102 , p_attribute10 IN PA_PROJ_ELEMENTS.ATTRIBUTE10%TYPE := NULL
103 , p_attribute11 IN PA_PROJ_ELEMENTS.ATTRIBUTE11%TYPE := NULL
104 , p_attribute12 IN PA_PROJ_ELEMENTS.ATTRIBUTE12%TYPE := NULL
105 , p_attribute13 IN PA_PROJ_ELEMENTS.ATTRIBUTE13%TYPE := NULL
106 , p_attribute14 IN PA_PROJ_ELEMENTS.ATTRIBUTE14%TYPE := NULL
107 , p_attribute15 IN PA_PROJ_ELEMENTS.ATTRIBUTE15%TYPE := NULL
108 , p_dlvr_item_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
109 , p_pm_source_code IN VARCHAR2 := NULL /* Bug no. 3651113 */
110 , p_deliverable_reference IN VARCHAR2 := NULL -- added for bug# 3749447
111 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
112 , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
113 , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
114 );
115
116 PROCEDURE DELETE_DELIVERABLE
117 (p_api_version IN NUMBER :=1.0
118 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
119 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
120 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
121 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
122 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
123 ,p_debug_mode IN VARCHAR2 :='N'
124 ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
125 ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
126 ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
127 ,p_rec_ver_number IN pa_proj_elements.record_version_number%TYPE
128 ,p_project_id IN pa_projects_all.project_id%TYPE
129 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
130 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
131 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
132 ) ;
133
134 PROCEDURE DELETE_DLV_TASK_ASSOCIATION
135 (p_api_version IN NUMBER :=1.0
136 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
137 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
138 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
139 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
140 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
141 ,p_debug_mode IN VARCHAR2 :='N'
142 ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
143 ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
144 ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE
145 ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
146 ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
147 ,p_object_relationship_id IN pa_object_relationships.object_relationship_id%TYPE
148 ,p_obj_rec_ver_number IN pa_object_relationships.record_version_number%TYPE
149 ,p_project_id IN pa_projects_all.project_id%TYPE
150 ,p_calling_context IN VARCHAR2
151 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
152 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
153 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
154 ) ;
155
156
157 PROCEDURE IS_DISASSOCIATION_ALLOWED
158 (p_api_version IN NUMBER :=1.0
159 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
160 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
161 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
162 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
163 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
164 ,p_debug_mode IN VARCHAR2 :='N'
165 ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
166 ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
167 ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE
168 ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
169 ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
170 ,p_project_id IN pa_projects_all.project_id%TYPE
171 ,p_calling_context IN VARCHAR2
172 ,x_disassociation_allowed OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
173 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
174 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
175 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
176 ) ;
177
178 PROCEDURE CREATE_ASSOCIATIONS_IN_BULK
179 (p_api_version IN NUMBER :=1.0
180 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
181 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
182 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
183 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
184 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
185 ,p_debug_mode IN VARCHAR2 :='N'
186 ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
187 ,p_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
188 ,p_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
189 ,p_element_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
190 ,p_element_number_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
191 ,p_task_or_dlv_elt_id IN NUMBER
192 ,p_task_or_dlv_ver_id IN NUMBER
193 ,p_project_id IN pa_projects_all.project_id%TYPE
194 ,p_task_or_dlv IN VARCHAR2 := 'PA_TASKS'
195 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
196 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
197 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
198 );
199
200 PROCEDURE CREATE_DLV_TASK_ASSOCIATION
201 (p_api_version IN NUMBER :=1.0
202 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
203 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
204 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
205 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
206 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
207 ,p_debug_mode IN VARCHAR2 :='N'
208 ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
209 ,p_calling_context IN VARCHAR2 := 'PA_TASKS'
210 ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
211 ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE
212 ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
213 ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
214 ,p_project_id IN pa_projects_all.project_id%TYPE
215 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
216 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
217 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
218 ) ;
219
220 PROCEDURE DELETE_DELIVERABLE_STRUCTURE
221 (p_api_version IN NUMBER :=1.0
222 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
223 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
224 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
225 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
226 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
227 ,p_debug_mode IN VARCHAR2 :='N'
228 ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
229 ,p_project_id IN pa_projects_all.project_id%TYPE
230 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
231 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
232 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
233 ) ;
234
235 PROCEDURE DELETE_DLV_TASK_ASSCN_IN_BULK
236 (p_api_version IN NUMBER :=1.0
237 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
238 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
239 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
240 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
241 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
242 ,p_debug_mode IN VARCHAR2 :='N'
243 ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
244 ,p_calling_context IN VARCHAR2 := 'PA_TASKS'
245 ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
246 ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE
247 ,p_project_id IN pa_projects_all.project_id%TYPE
251 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
248 ,p_delete_or_validate IN VARCHAR2 := 'B' -- 3955848 V- Validate , D - Delete, B - Validate and Delete
249 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
250 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
252 ) ;
253
254 PROCEDURE DELETE_DLV_ASSOCIATIONS
255 (p_api_version IN NUMBER :=1.0
256 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
257 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
258 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
259 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
260 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
261 ,p_debug_mode IN VARCHAR2 :='N'
262 ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
263 ,p_project_id IN NUMBER
264 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
265 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
266 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
267 ) ;
268
269 PROCEDURE COPY_DELIVERABLES
270 (p_api_version IN NUMBER :=1.0
271 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
272 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
273 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
274 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
275 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
276 ,p_debug_mode IN VARCHAR2 :='N'
277 ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
278 ,p_source_project_id IN NUMBER
279 ,p_target_project_id IN NUMBER
280 ,p_dlv_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
281 ,p_dlv_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
282 ,p_item_details_flag IN VARCHAR2 := 'N'
283 ,p_dlv_actions_flag IN VARCHAR2 := 'N'
284 ,p_dlv_attachments_flag IN VARCHAR2 := 'N'
285 ,p_association_flag IN VARCHAR2 := 'N'
286 ,p_prefix IN VARCHAR2 := null
287 ,p_delta IN NUMBER := null
288 ,p_calling_context IN VARCHAR2
289 ,p_task_id IN NUMBER :=null --Bug 3429393
290 ,p_task_version_id IN NUMBER :=null --Bug 3429393
291 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
292 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
293 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
294 ) ;
295
296 END PA_DELIVERABLE_PVT;