[Home] [Help]
PACKAGE: APPS.PA_ACTION_SETS_PUB
Source
1 PACKAGE pa_action_sets_pub AS
2 /*$Header: PARASPUS.pls 120.1 2005/08/19 16:48:17 mwasowic noship $*/
3 --
4 PROCEDURE create_action_set
5 (p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE
6 ,p_action_set_name IN pa_action_sets.action_set_name%TYPE
7 ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
8 ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
9 ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := NULL
10 ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := NULL
11 ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := NULL
12 ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := NULL
13 ,p_status_code IN pa_action_sets.status_code%TYPE := NULL
14 ,p_description IN pa_action_sets.description%TYPE := NULL
15 ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := NULL
16 ,p_attribute1 IN pa_action_sets.attribute1%TYPE := NULL
17 ,p_attribute2 IN pa_action_sets.attribute2%TYPE := NULL
18 ,p_attribute3 IN pa_action_sets.attribute3%TYPE := NULL
19 ,p_attribute4 IN pa_action_sets.attribute4%TYPE := NULL
20 ,p_attribute5 IN pa_action_sets.attribute5%TYPE := NULL
21 ,p_attribute6 IN pa_action_sets.attribute6%TYPE := NULL
22 ,p_attribute7 IN pa_action_sets.attribute7%TYPE := NULL
23 ,p_attribute8 IN pa_action_sets.attribute8%TYPE := NULL
24 ,p_attribute9 IN pa_action_sets.attribute9%TYPE := NULL
25 ,p_attribute10 IN pa_action_sets.attribute10%TYPE := NULL
26 ,p_attribute11 IN pa_action_sets.attribute11%TYPE := NULL
27 ,p_attribute12 IN pa_action_sets.attribute12%TYPE := NULL
28 ,p_attribute13 IN pa_action_sets.attribute13%TYPE := NULL
29 ,p_attribute14 IN pa_action_sets.attribute14%TYPE := NULL
30 ,p_attribute15 IN pa_action_sets.attribute15%TYPE := NULL
31 ,p_api_version IN NUMBER := 1.0
32 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
33 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
34 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
35 ,x_action_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
36 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
37 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
38 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
39 );
40
41 PROCEDURE update_action_set
42 (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
43 ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
44 ,p_object_type IN pa_action_sets.object_type%TYPE := FND_API.G_MISS_CHAR
45 ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
46 ,p_object_id IN pa_action_sets.object_id%TYPE := FND_API.G_MISS_NUM
47 ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
48 ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
49 ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
50 ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
51 ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
52 ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
53 ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
54 ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
55 ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
56 ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
57 ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
58 ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
59 ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
60 ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
61 ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
62 ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
63 ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
64 ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
65 ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
66 ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
67 ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
68 ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
69 ,p_api_version IN NUMBER := 1.0
70 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
71 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
72 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
73 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
74 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
75 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
76 );
77
78 PROCEDURE delete_action_set
79 (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
80 ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := NULL
81 ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
82 ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
83 ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
84 ,p_api_version IN NUMBER := 1.0
85 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
86 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
87 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
88 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
89 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
90 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
91 );
92
93 PROCEDURE create_action_set_line
94 (p_action_set_id IN pa_action_sets.action_set_id%TYPE
95 ,p_use_def_description_flag IN VARCHAR2 := 'Y'
96 ,p_description IN pa_action_set_lines.description%TYPE := NULL
97 ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := NULL
98 ,p_action_code IN pa_action_set_lines.action_code%TYPE
99 ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := NULL
100 ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL
101 ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL
102 ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL
103 ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL
104 ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL
105 ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := NULL
106 ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := NULL
107 ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := NULL
108 ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := NULL
109 ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
110 ,p_api_version IN NUMBER := 1.0
111 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
112 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
113 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
114 ,x_action_set_line_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
115 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
116 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
117 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
118 );
119
120 PROCEDURE update_action_set_line
121 (p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
122 ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE
123 ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
124 ,p_use_def_description_flag IN VARCHAR2 := 'Y'
125 ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
126 ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
127 ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
128 ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
129 ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
130 ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
131 ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
132 ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
133 ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
134 ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
135 ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
136 ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
137 ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
138 ,p_api_version IN NUMBER := 1.0
139 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
140 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
141 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
142 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
143 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
144 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
145 );
146
147
148 PROCEDURE delete_action_set_line
149 (p_action_set_line_id IN pa_action_sets.action_set_id%TYPE := NULL
150 ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE := NULL
151 ,p_api_version IN NUMBER := 1.0
152 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
153 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
154 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
155 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
156 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
157 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
158 );
159
160 PROCEDURE apply_action_set
161 (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
162 ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
163 ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
164 ,p_perform_action_set_flag IN VARCHAR2 := 'N'
165 ,p_api_version IN NUMBER := 1.0
166 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
167 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
168 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
169 ,x_new_action_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
170 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
171 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
172 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
173 );
174
175 PROCEDURE replace_action_set
176 (p_current_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
177 ,p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE := NULL
178 ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
179 ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
180 ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
181 ,p_new_action_set_id IN pa_action_sets.action_set_id%TYPE
182 ,p_api_version IN NUMBER := 1.0
183 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
184 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
185 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
186 ,x_new_action_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
187 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
188 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
189 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
190 );
191
192 PROCEDURE perform_single_action_set
193 (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
194 ,p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE := NULL
195 ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
196 ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
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 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
202 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
203 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
204 );
205
206 PROCEDURE Perform_Action_Sets( p_action_set_type_code IN VARCHAR2,
207 p_project_number_from IN VARCHAR2,
208 p_project_number_to IN VARCHAR2,
209 p_debug_mode IN VARCHAR2,
210 x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
211
212
213 PROCEDURE create_line_single_cond
214 (p_action_set_id IN pa_action_sets.action_set_id%TYPE
215 ,p_use_def_description_flag IN VARCHAR2 := 'Y'
216 ,p_action_description IN pa_action_set_lines.description%TYPE := NULL
217 ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := NULL
218 ,p_action_code IN pa_action_set_lines.action_code%TYPE
219 ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := NULL
220 ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL
221 ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL
222 ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL
223 ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL
224 ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL
225 ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := NULL
226 ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := NULL
227 ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := NULL
228 ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := NULL
232 ,p_condition_attribute2 IN pa_action_set_line_cond.condition_attribute2%TYPE := NULL
229 ,p_condition_description IN pa_action_set_line_cond.description%TYPE := NULL
230 ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE
231 ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := NULL
233 ,p_condition_attribute3 IN pa_action_set_line_cond.condition_attribute3%TYPE := NULL
234 ,p_condition_attribute4 IN pa_action_set_line_cond.condition_attribute4%TYPE := NULL
235 ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := NULL
236 ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := NULL
237 ,p_condition_attribute7 IN pa_action_set_line_cond.condition_attribute7%TYPE := NULL
238 ,p_condition_attribute8 IN pa_action_set_line_cond.condition_attribute8%TYPE := NULL
239 ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := NULL
240 ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := NULL
241 ,p_api_version IN NUMBER := 1.0
242 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
243 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
244 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
245 ,x_action_set_line_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
246 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
247 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
248 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
249 );
250
251 PROCEDURE update_line_single_cond
252 (p_action_set_line_id IN pa_action_sets.action_set_id%TYPE
253 ,p_record_version_number IN NUMBER := NULL
254 ,p_action_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
255 ,p_action_code IN pa_action_set_lines.action_code%TYPE
256 ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
257 ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
258 ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
259 ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
260 ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
261 ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
262 ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
263 ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
264 ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
265 ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
266 ,p_condition_description IN pa_action_set_line_cond.description%TYPE := FND_API.G_MISS_CHAR
267 ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE
268 ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := FND_API.G_MISS_CHAR
269 ,p_condition_attribute2 IN pa_action_set_line_cond.condition_attribute2%TYPE := FND_API.G_MISS_CHAR
270 ,p_condition_attribute3 IN pa_action_set_line_cond.condition_attribute3%TYPE := FND_API.G_MISS_CHAR
271 ,p_condition_attribute4 IN pa_action_set_line_cond.condition_attribute4%TYPE := FND_API.G_MISS_CHAR
272 ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR
273 ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR
274 ,p_condition_attribute7 IN pa_action_set_line_cond.condition_attribute7%TYPE := FND_API.G_MISS_CHAR
275 ,p_condition_attribute8 IN pa_action_set_line_cond.condition_attribute8%TYPE := FND_API.G_MISS_CHAR
276 ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := FND_API.G_MISS_CHAR
277 ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := FND_API.G_MISS_CHAR
278 ,p_api_version IN NUMBER := 1.0
279 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
280 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
281 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
282 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
283 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
284 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
285 );
286
287
288
289 PROCEDURE process_action_set(p_action_set_id IN NUMBER,
290 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
291 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
292 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
293
294 END;