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