DBA Data[Home] [Help]

PACKAGE BODY: APPS.PQH_COPY_ENTITY_RESULTS_BK1

Source


1 package body PQH_COPY_ENTITY_RESULTS_BK1 as
2 /* $Header: pqcerapi.pkb 115.5 2002/11/27 04:43:10 generated ship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2007/10/22 07:23:41 (YYYY/MM/DD HH24:MI:SS)
5 procedure CREATE_COPY_ENTITY_RESULT_A
6 (P_COPY_ENTITY_RESULT_ID in NUMBER
7 ,P_COPY_ENTITY_TXN_ID in NUMBER
8 ,P_RESULT_TYPE_CD in VARCHAR2
9 ,P_NUMBER_OF_COPIES in NUMBER
10 ,P_STATUS in VARCHAR2
11 ,P_SRC_COPY_ENTITY_RESULT_ID in NUMBER
12 ,P_INFORMATION_CATEGORY in VARCHAR2
13 ,P_INFORMATION1 in VARCHAR2
14 ,P_INFORMATION2 in VARCHAR2
15 ,P_INFORMATION3 in VARCHAR2
16 ,P_INFORMATION4 in VARCHAR2
17 ,P_INFORMATION5 in VARCHAR2
18 ,P_INFORMATION6 in VARCHAR2
19 ,P_INFORMATION7 in VARCHAR2
20 ,P_INFORMATION8 in VARCHAR2
21 ,P_INFORMATION9 in VARCHAR2
22 ,P_INFORMATION10 in VARCHAR2
23 ,P_INFORMATION11 in VARCHAR2
24 ,P_INFORMATION12 in VARCHAR2
25 ,P_INFORMATION13 in VARCHAR2
26 ,P_INFORMATION14 in VARCHAR2
27 ,P_INFORMATION15 in VARCHAR2
28 ,P_INFORMATION16 in VARCHAR2
29 ,P_INFORMATION17 in VARCHAR2
30 ,P_INFORMATION18 in VARCHAR2
31 ,P_INFORMATION19 in VARCHAR2
32 ,P_INFORMATION20 in VARCHAR2
33 ,P_INFORMATION21 in VARCHAR2
34 ,P_INFORMATION22 in VARCHAR2
35 ,P_INFORMATION23 in VARCHAR2
36 ,P_INFORMATION24 in VARCHAR2
37 ,P_INFORMATION25 in VARCHAR2
38 ,P_INFORMATION26 in VARCHAR2
39 ,P_INFORMATION27 in VARCHAR2
40 ,P_INFORMATION28 in VARCHAR2
41 ,P_INFORMATION29 in VARCHAR2
42 ,P_INFORMATION30 in VARCHAR2
43 ,P_INFORMATION31 in VARCHAR2
44 ,P_INFORMATION32 in VARCHAR2
45 ,P_INFORMATION33 in VARCHAR2
46 ,P_INFORMATION34 in VARCHAR2
47 ,P_INFORMATION35 in VARCHAR2
48 ,P_INFORMATION36 in VARCHAR2
49 ,P_INFORMATION37 in VARCHAR2
50 ,P_INFORMATION38 in VARCHAR2
51 ,P_INFORMATION39 in VARCHAR2
52 ,P_INFORMATION40 in VARCHAR2
53 ,P_INFORMATION41 in VARCHAR2
54 ,P_INFORMATION42 in VARCHAR2
55 ,P_INFORMATION43 in VARCHAR2
56 ,P_INFORMATION44 in VARCHAR2
57 ,P_INFORMATION45 in VARCHAR2
58 ,P_INFORMATION46 in VARCHAR2
59 ,P_INFORMATION47 in VARCHAR2
60 ,P_INFORMATION48 in VARCHAR2
61 ,P_INFORMATION49 in VARCHAR2
62 ,P_INFORMATION50 in VARCHAR2
63 ,P_INFORMATION51 in VARCHAR2
64 ,P_INFORMATION52 in VARCHAR2
65 ,P_INFORMATION53 in VARCHAR2
66 ,P_INFORMATION54 in VARCHAR2
67 ,P_INFORMATION55 in VARCHAR2
68 ,P_INFORMATION56 in VARCHAR2
69 ,P_INFORMATION57 in VARCHAR2
70 ,P_INFORMATION58 in VARCHAR2
71 ,P_INFORMATION59 in VARCHAR2
72 ,P_INFORMATION60 in VARCHAR2
73 ,P_INFORMATION61 in VARCHAR2
74 ,P_INFORMATION62 in VARCHAR2
75 ,P_INFORMATION63 in VARCHAR2
76 ,P_INFORMATION64 in VARCHAR2
77 ,P_INFORMATION65 in VARCHAR2
78 ,P_INFORMATION66 in VARCHAR2
79 ,P_INFORMATION67 in VARCHAR2
80 ,P_INFORMATION68 in VARCHAR2
81 ,P_INFORMATION69 in VARCHAR2
82 ,P_INFORMATION70 in VARCHAR2
83 ,P_INFORMATION71 in VARCHAR2
84 ,P_INFORMATION72 in VARCHAR2
85 ,P_INFORMATION73 in VARCHAR2
86 ,P_INFORMATION74 in VARCHAR2
87 ,P_INFORMATION75 in VARCHAR2
88 ,P_INFORMATION76 in VARCHAR2
89 ,P_INFORMATION77 in VARCHAR2
90 ,P_INFORMATION78 in VARCHAR2
91 ,P_INFORMATION79 in VARCHAR2
92 ,P_INFORMATION80 in VARCHAR2
93 ,P_INFORMATION81 in VARCHAR2
94 ,P_INFORMATION82 in VARCHAR2
95 ,P_INFORMATION83 in VARCHAR2
96 ,P_INFORMATION84 in VARCHAR2
97 ,P_INFORMATION85 in VARCHAR2
98 ,P_INFORMATION86 in VARCHAR2
99 ,P_INFORMATION87 in VARCHAR2
100 ,P_INFORMATION88 in VARCHAR2
101 ,P_INFORMATION89 in VARCHAR2
102 ,P_INFORMATION90 in VARCHAR2
103 ,P_INFORMATION91 in VARCHAR2
104 ,P_INFORMATION92 in VARCHAR2
105 ,P_INFORMATION93 in VARCHAR2
106 ,P_INFORMATION94 in VARCHAR2
107 ,P_INFORMATION95 in VARCHAR2
108 ,P_INFORMATION96 in VARCHAR2
109 ,P_INFORMATION97 in VARCHAR2
110 ,P_INFORMATION98 in VARCHAR2
111 ,P_INFORMATION99 in VARCHAR2
112 ,P_INFORMATION100 in VARCHAR2
113 ,P_INFORMATION101 in VARCHAR2
114 ,P_INFORMATION102 in VARCHAR2
115 ,P_INFORMATION103 in VARCHAR2
116 ,P_INFORMATION104 in VARCHAR2
117 ,P_INFORMATION105 in VARCHAR2
118 ,P_INFORMATION106 in VARCHAR2
119 ,P_INFORMATION107 in VARCHAR2
120 ,P_INFORMATION108 in VARCHAR2
121 ,P_INFORMATION109 in VARCHAR2
122 ,P_INFORMATION110 in VARCHAR2
123 ,P_INFORMATION111 in VARCHAR2
124 ,P_INFORMATION112 in VARCHAR2
125 ,P_INFORMATION113 in VARCHAR2
126 ,P_INFORMATION114 in VARCHAR2
127 ,P_INFORMATION115 in VARCHAR2
128 ,P_INFORMATION116 in VARCHAR2
129 ,P_INFORMATION117 in VARCHAR2
130 ,P_INFORMATION118 in VARCHAR2
131 ,P_INFORMATION119 in VARCHAR2
132 ,P_INFORMATION120 in VARCHAR2
133 ,P_INFORMATION121 in VARCHAR2
134 ,P_INFORMATION122 in VARCHAR2
135 ,P_INFORMATION123 in VARCHAR2
136 ,P_INFORMATION124 in VARCHAR2
137 ,P_INFORMATION125 in VARCHAR2
138 ,P_INFORMATION126 in VARCHAR2
139 ,P_INFORMATION127 in VARCHAR2
140 ,P_INFORMATION128 in VARCHAR2
141 ,P_INFORMATION129 in VARCHAR2
142 ,P_INFORMATION130 in VARCHAR2
143 ,P_INFORMATION131 in VARCHAR2
144 ,P_INFORMATION132 in VARCHAR2
145 ,P_INFORMATION133 in VARCHAR2
146 ,P_INFORMATION134 in VARCHAR2
147 ,P_INFORMATION135 in VARCHAR2
148 ,P_INFORMATION136 in VARCHAR2
149 ,P_INFORMATION137 in VARCHAR2
150 ,P_INFORMATION138 in VARCHAR2
151 ,P_INFORMATION139 in VARCHAR2
152 ,P_INFORMATION140 in VARCHAR2
153 ,P_INFORMATION141 in VARCHAR2
154 ,P_INFORMATION142 in VARCHAR2
155 ,P_INFORMATION143 in VARCHAR2
156 ,P_INFORMATION144 in VARCHAR2
157 ,P_INFORMATION145 in VARCHAR2
158 ,P_INFORMATION146 in VARCHAR2
159 ,P_INFORMATION147 in VARCHAR2
160 ,P_INFORMATION148 in VARCHAR2
161 ,P_INFORMATION149 in VARCHAR2
162 ,P_INFORMATION150 in VARCHAR2
163 ,P_INFORMATION151 in VARCHAR2
164 ,P_INFORMATION152 in VARCHAR2
165 ,P_INFORMATION153 in VARCHAR2
166 ,P_INFORMATION154 in VARCHAR2
167 ,P_INFORMATION155 in VARCHAR2
168 ,P_INFORMATION156 in VARCHAR2
169 ,P_INFORMATION157 in VARCHAR2
170 ,P_INFORMATION158 in VARCHAR2
171 ,P_INFORMATION159 in VARCHAR2
172 ,P_INFORMATION160 in VARCHAR2
173 ,P_INFORMATION161 in VARCHAR2
174 ,P_INFORMATION162 in VARCHAR2
175 ,P_INFORMATION163 in VARCHAR2
176 ,P_INFORMATION164 in VARCHAR2
177 ,P_INFORMATION165 in VARCHAR2
178 ,P_INFORMATION166 in VARCHAR2
179 ,P_INFORMATION167 in VARCHAR2
180 ,P_INFORMATION168 in VARCHAR2
181 ,P_INFORMATION169 in VARCHAR2
182 ,P_INFORMATION170 in VARCHAR2
183 ,P_INFORMATION171 in VARCHAR2
184 ,P_INFORMATION172 in VARCHAR2
185 ,P_INFORMATION173 in VARCHAR2
186 ,P_INFORMATION174 in VARCHAR2
187 ,P_INFORMATION175 in VARCHAR2
188 ,P_INFORMATION176 in VARCHAR2
189 ,P_INFORMATION177 in VARCHAR2
190 ,P_INFORMATION178 in VARCHAR2
191 ,P_INFORMATION179 in VARCHAR2
192 ,P_INFORMATION180 in VARCHAR2
193 ,P_INFORMATION181 in VARCHAR2
194 ,P_INFORMATION182 in VARCHAR2
195 ,P_INFORMATION183 in VARCHAR2
196 ,P_INFORMATION184 in VARCHAR2
197 ,P_INFORMATION185 in VARCHAR2
198 ,P_INFORMATION186 in VARCHAR2
199 ,P_INFORMATION187 in VARCHAR2
200 ,P_INFORMATION188 in VARCHAR2
201 ,P_INFORMATION189 in VARCHAR2
202 ,P_INFORMATION190 in VARCHAR2
203 ,P_MIRROR_ENTITY_RESULT_ID in NUMBER
204 ,P_MIRROR_SRC_ENTITY_RESULT_ID in NUMBER
205 ,P_PARENT_ENTITY_RESULT_ID in NUMBER
206 ,P_TABLE_ROUTE_ID in NUMBER
207 ,P_LONG_ATTRIBUTE1 in LONG
208 ,P_OBJECT_VERSION_NUMBER in NUMBER
209 ,P_EFFECTIVE_DATE in DATE
210 )is
211 l_commit_unit_number number;
212 l_legislation_code   varchar2(30);
213 begin
214 hr_utility.set_location('Entering: PQH_COPY_ENTITY_RESULTS_BK1.CREATE_COPY_ENTITY_RESULT_A', 10);
215 l_commit_unit_number := hr_api.return_commit_unit;
216 if hr_api.call_leg_hooks then
217 -- Note: All legislation hook calls will be executed regardless of the
218 -- legislation code because the data for this API module is not held within
219 -- the context of a business_group_id.
220 PQH_FR_UTILITY.DELETE_DUPLICATE_ASG_RECORDS
221 (P_COPY_ENTITY_RESULT_ID => P_COPY_ENTITY_RESULT_ID
222 ,P_COPY_ENTITY_TXN_ID => P_COPY_ENTITY_TXN_ID
223 ,P_RESULT_TYPE_CD => P_RESULT_TYPE_CD
224 ,P_INFORMATION2 => P_INFORMATION2
225 ,P_INFORMATION67 => P_INFORMATION67
226 );
227 end if;
228 hr_multi_message.end_validation_set;
229 hr_api.validate_commit_unit(l_commit_unit_number, 'CREATE_COPY_ENTITY_RESULT', 'AP');
230 hr_utility.set_location(' Leaving: PQH_COPY_ENTITY_RESULTS_BK1.CREATE_COPY_ENTITY_RESULT_A', 20);
231 end CREATE_COPY_ENTITY_RESULT_A;
232 procedure CREATE_COPY_ENTITY_RESULT_B
233 (P_COPY_ENTITY_TXN_ID in NUMBER
234 ,P_RESULT_TYPE_CD in VARCHAR2
235 ,P_NUMBER_OF_COPIES in NUMBER
236 ,P_STATUS in VARCHAR2
237 ,P_SRC_COPY_ENTITY_RESULT_ID in NUMBER
238 ,P_INFORMATION_CATEGORY in VARCHAR2
239 ,P_INFORMATION1 in VARCHAR2
240 ,P_INFORMATION2 in VARCHAR2
241 ,P_INFORMATION3 in VARCHAR2
242 ,P_INFORMATION4 in VARCHAR2
243 ,P_INFORMATION5 in VARCHAR2
244 ,P_INFORMATION6 in VARCHAR2
245 ,P_INFORMATION7 in VARCHAR2
246 ,P_INFORMATION8 in VARCHAR2
247 ,P_INFORMATION9 in VARCHAR2
248 ,P_INFORMATION10 in VARCHAR2
249 ,P_INFORMATION11 in VARCHAR2
250 ,P_INFORMATION12 in VARCHAR2
251 ,P_INFORMATION13 in VARCHAR2
252 ,P_INFORMATION14 in VARCHAR2
253 ,P_INFORMATION15 in VARCHAR2
254 ,P_INFORMATION16 in VARCHAR2
255 ,P_INFORMATION17 in VARCHAR2
256 ,P_INFORMATION18 in VARCHAR2
257 ,P_INFORMATION19 in VARCHAR2
258 ,P_INFORMATION20 in VARCHAR2
259 ,P_INFORMATION21 in VARCHAR2
260 ,P_INFORMATION22 in VARCHAR2
261 ,P_INFORMATION23 in VARCHAR2
262 ,P_INFORMATION24 in VARCHAR2
263 ,P_INFORMATION25 in VARCHAR2
264 ,P_INFORMATION26 in VARCHAR2
265 ,P_INFORMATION27 in VARCHAR2
266 ,P_INFORMATION28 in VARCHAR2
267 ,P_INFORMATION29 in VARCHAR2
268 ,P_INFORMATION30 in VARCHAR2
269 ,P_INFORMATION31 in VARCHAR2
270 ,P_INFORMATION32 in VARCHAR2
271 ,P_INFORMATION33 in VARCHAR2
272 ,P_INFORMATION34 in VARCHAR2
273 ,P_INFORMATION35 in VARCHAR2
274 ,P_INFORMATION36 in VARCHAR2
275 ,P_INFORMATION37 in VARCHAR2
276 ,P_INFORMATION38 in VARCHAR2
277 ,P_INFORMATION39 in VARCHAR2
278 ,P_INFORMATION40 in VARCHAR2
279 ,P_INFORMATION41 in VARCHAR2
280 ,P_INFORMATION42 in VARCHAR2
281 ,P_INFORMATION43 in VARCHAR2
282 ,P_INFORMATION44 in VARCHAR2
283 ,P_INFORMATION45 in VARCHAR2
284 ,P_INFORMATION46 in VARCHAR2
285 ,P_INFORMATION47 in VARCHAR2
286 ,P_INFORMATION48 in VARCHAR2
287 ,P_INFORMATION49 in VARCHAR2
288 ,P_INFORMATION50 in VARCHAR2
289 ,P_INFORMATION51 in VARCHAR2
290 ,P_INFORMATION52 in VARCHAR2
291 ,P_INFORMATION53 in VARCHAR2
292 ,P_INFORMATION54 in VARCHAR2
293 ,P_INFORMATION55 in VARCHAR2
294 ,P_INFORMATION56 in VARCHAR2
295 ,P_INFORMATION57 in VARCHAR2
296 ,P_INFORMATION58 in VARCHAR2
297 ,P_INFORMATION59 in VARCHAR2
298 ,P_INFORMATION60 in VARCHAR2
299 ,P_INFORMATION61 in VARCHAR2
300 ,P_INFORMATION62 in VARCHAR2
301 ,P_INFORMATION63 in VARCHAR2
302 ,P_INFORMATION64 in VARCHAR2
303 ,P_INFORMATION65 in VARCHAR2
304 ,P_INFORMATION66 in VARCHAR2
305 ,P_INFORMATION67 in VARCHAR2
306 ,P_INFORMATION68 in VARCHAR2
307 ,P_INFORMATION69 in VARCHAR2
308 ,P_INFORMATION70 in VARCHAR2
309 ,P_INFORMATION71 in VARCHAR2
310 ,P_INFORMATION72 in VARCHAR2
311 ,P_INFORMATION73 in VARCHAR2
312 ,P_INFORMATION74 in VARCHAR2
313 ,P_INFORMATION75 in VARCHAR2
314 ,P_INFORMATION76 in VARCHAR2
315 ,P_INFORMATION77 in VARCHAR2
316 ,P_INFORMATION78 in VARCHAR2
317 ,P_INFORMATION79 in VARCHAR2
318 ,P_INFORMATION80 in VARCHAR2
319 ,P_INFORMATION81 in VARCHAR2
320 ,P_INFORMATION82 in VARCHAR2
321 ,P_INFORMATION83 in VARCHAR2
322 ,P_INFORMATION84 in VARCHAR2
323 ,P_INFORMATION85 in VARCHAR2
324 ,P_INFORMATION86 in VARCHAR2
325 ,P_INFORMATION87 in VARCHAR2
326 ,P_INFORMATION88 in VARCHAR2
327 ,P_INFORMATION89 in VARCHAR2
328 ,P_INFORMATION90 in VARCHAR2
329 ,P_INFORMATION91 in VARCHAR2
330 ,P_INFORMATION92 in VARCHAR2
331 ,P_INFORMATION93 in VARCHAR2
332 ,P_INFORMATION94 in VARCHAR2
333 ,P_INFORMATION95 in VARCHAR2
334 ,P_INFORMATION96 in VARCHAR2
335 ,P_INFORMATION97 in VARCHAR2
336 ,P_INFORMATION98 in VARCHAR2
337 ,P_INFORMATION99 in VARCHAR2
338 ,P_INFORMATION100 in VARCHAR2
339 ,P_INFORMATION101 in VARCHAR2
340 ,P_INFORMATION102 in VARCHAR2
341 ,P_INFORMATION103 in VARCHAR2
342 ,P_INFORMATION104 in VARCHAR2
343 ,P_INFORMATION105 in VARCHAR2
344 ,P_INFORMATION106 in VARCHAR2
345 ,P_INFORMATION107 in VARCHAR2
346 ,P_INFORMATION108 in VARCHAR2
347 ,P_INFORMATION109 in VARCHAR2
348 ,P_INFORMATION110 in VARCHAR2
349 ,P_INFORMATION111 in VARCHAR2
350 ,P_INFORMATION112 in VARCHAR2
351 ,P_INFORMATION113 in VARCHAR2
352 ,P_INFORMATION114 in VARCHAR2
353 ,P_INFORMATION115 in VARCHAR2
354 ,P_INFORMATION116 in VARCHAR2
355 ,P_INFORMATION117 in VARCHAR2
356 ,P_INFORMATION118 in VARCHAR2
357 ,P_INFORMATION119 in VARCHAR2
358 ,P_INFORMATION120 in VARCHAR2
359 ,P_INFORMATION121 in VARCHAR2
360 ,P_INFORMATION122 in VARCHAR2
361 ,P_INFORMATION123 in VARCHAR2
362 ,P_INFORMATION124 in VARCHAR2
363 ,P_INFORMATION125 in VARCHAR2
364 ,P_INFORMATION126 in VARCHAR2
365 ,P_INFORMATION127 in VARCHAR2
366 ,P_INFORMATION128 in VARCHAR2
367 ,P_INFORMATION129 in VARCHAR2
368 ,P_INFORMATION130 in VARCHAR2
369 ,P_INFORMATION131 in VARCHAR2
370 ,P_INFORMATION132 in VARCHAR2
371 ,P_INFORMATION133 in VARCHAR2
372 ,P_INFORMATION134 in VARCHAR2
373 ,P_INFORMATION135 in VARCHAR2
374 ,P_INFORMATION136 in VARCHAR2
375 ,P_INFORMATION137 in VARCHAR2
376 ,P_INFORMATION138 in VARCHAR2
377 ,P_INFORMATION139 in VARCHAR2
378 ,P_INFORMATION140 in VARCHAR2
379 ,P_INFORMATION141 in VARCHAR2
380 ,P_INFORMATION142 in VARCHAR2
381 ,P_INFORMATION143 in VARCHAR2
382 ,P_INFORMATION144 in VARCHAR2
383 ,P_INFORMATION145 in VARCHAR2
384 ,P_INFORMATION146 in VARCHAR2
385 ,P_INFORMATION147 in VARCHAR2
386 ,P_INFORMATION148 in VARCHAR2
387 ,P_INFORMATION149 in VARCHAR2
388 ,P_INFORMATION150 in VARCHAR2
389 ,P_INFORMATION151 in VARCHAR2
390 ,P_INFORMATION152 in VARCHAR2
391 ,P_INFORMATION153 in VARCHAR2
392 ,P_INFORMATION154 in VARCHAR2
393 ,P_INFORMATION155 in VARCHAR2
394 ,P_INFORMATION156 in VARCHAR2
395 ,P_INFORMATION157 in VARCHAR2
396 ,P_INFORMATION158 in VARCHAR2
397 ,P_INFORMATION159 in VARCHAR2
398 ,P_INFORMATION160 in VARCHAR2
399 ,P_INFORMATION161 in VARCHAR2
400 ,P_INFORMATION162 in VARCHAR2
401 ,P_INFORMATION163 in VARCHAR2
402 ,P_INFORMATION164 in VARCHAR2
403 ,P_INFORMATION165 in VARCHAR2
404 ,P_INFORMATION166 in VARCHAR2
405 ,P_INFORMATION167 in VARCHAR2
406 ,P_INFORMATION168 in VARCHAR2
407 ,P_INFORMATION169 in VARCHAR2
408 ,P_INFORMATION170 in VARCHAR2
409 ,P_INFORMATION171 in VARCHAR2
410 ,P_INFORMATION172 in VARCHAR2
411 ,P_INFORMATION173 in VARCHAR2
412 ,P_INFORMATION174 in VARCHAR2
413 ,P_INFORMATION175 in VARCHAR2
414 ,P_INFORMATION176 in VARCHAR2
415 ,P_INFORMATION177 in VARCHAR2
416 ,P_INFORMATION178 in VARCHAR2
417 ,P_INFORMATION179 in VARCHAR2
418 ,P_INFORMATION180 in VARCHAR2
419 ,P_INFORMATION181 in VARCHAR2
420 ,P_INFORMATION182 in VARCHAR2
421 ,P_INFORMATION183 in VARCHAR2
422 ,P_INFORMATION184 in VARCHAR2
423 ,P_INFORMATION185 in VARCHAR2
424 ,P_INFORMATION186 in VARCHAR2
425 ,P_INFORMATION187 in VARCHAR2
426 ,P_INFORMATION188 in VARCHAR2
427 ,P_INFORMATION189 in VARCHAR2
428 ,P_INFORMATION190 in VARCHAR2
429 ,P_MIRROR_ENTITY_RESULT_ID in NUMBER
430 ,P_MIRROR_SRC_ENTITY_RESULT_ID in NUMBER
431 ,P_PARENT_ENTITY_RESULT_ID in NUMBER
432 ,P_TABLE_ROUTE_ID in NUMBER
433 ,P_LONG_ATTRIBUTE1 in LONG
434 ,P_EFFECTIVE_DATE in DATE
435 )is
436 begin
437 hr_utility.set_location('Entering: PQH_COPY_ENTITY_RESULTS_BK1.CREATE_COPY_ENTITY_RESULT_B', 10);
438 hr_utility.set_location(' Leaving: PQH_COPY_ENTITY_RESULTS_BK1.CREATE_COPY_ENTITY_RESULT_B', 20);
439 end CREATE_COPY_ENTITY_RESULT_B;
440 end PQH_COPY_ENTITY_RESULTS_BK1;