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.
PACKAGE BODY: APPS.HR_ASSIGNMENT_BKN

Source


1 package body HR_ASSIGNMENT_BKN as
2 /* $Header: peasgapi.pkb 120.20.12010000.4 2008/09/29 13:00:03 generated ship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2009/03/30 04:46:36 (YYYY/MM/DD HH24:MI:SS)
5 procedure CREATE_SECONDARY_CWK_ASG_A
6 (P_EFFECTIVE_DATE in DATE
7 ,P_BUSINESS_GROUP_ID in NUMBER
8 ,P_PERSON_ID in NUMBER
9 ,P_ORGANIZATION_ID in NUMBER
10 ,P_ASSIGNMENT_NUMBER in VARCHAR2
11 ,P_ASSIGNMENT_CATEGORY in VARCHAR2
12 ,P_ASSIGNMENT_STATUS_TYPE_ID in NUMBER
13 ,P_CHANGE_REASON in VARCHAR2
14 ,P_COMMENTS in VARCHAR2
15 ,P_DEFAULT_CODE_COMB_ID in NUMBER
16 ,P_ESTABLISHMENT_ID in NUMBER
17 ,P_FREQUENCY in VARCHAR2
18 ,P_INTERNAL_ADDRESS_LINE in VARCHAR2
19 ,P_JOB_ID in NUMBER
20 ,P_LABOUR_UNION_MEMBER_FLAG in VARCHAR2
21 ,P_LOCATION_ID in NUMBER
22 ,P_MANAGER_FLAG in VARCHAR2
23 ,P_NORMAL_HOURS in NUMBER
24 ,P_POSITION_ID in NUMBER
25 ,P_GRADE_ID in NUMBER
26 ,P_PROJECT_TITLE in VARCHAR2
27 ,P_SET_OF_BOOKS_ID in NUMBER
28 ,P_SOURCE_TYPE in VARCHAR2
29 ,P_SUPERVISOR_ID in NUMBER
30 ,P_TIME_NORMAL_FINISH in VARCHAR2
31 ,P_TIME_NORMAL_START in VARCHAR2
32 ,P_TITLE in VARCHAR2
33 ,P_VENDOR_ASSIGNMENT_NUMBER in VARCHAR2
34 ,P_VENDOR_EMPLOYEE_NUMBER in VARCHAR2
35 ,P_VENDOR_ID in NUMBER
36 ,P_VENDOR_SITE_ID in NUMBER
37 ,P_PO_HEADER_ID in NUMBER
38 ,P_PO_LINE_ID in NUMBER
39 ,P_PROJECTED_ASSIGNMENT_END in DATE
40 ,P_ATTRIBUTE_CATEGORY in VARCHAR2
41 ,P_ATTRIBUTE1 in VARCHAR2
42 ,P_ATTRIBUTE2 in VARCHAR2
43 ,P_ATTRIBUTE3 in VARCHAR2
44 ,P_ATTRIBUTE4 in VARCHAR2
45 ,P_ATTRIBUTE5 in VARCHAR2
46 ,P_ATTRIBUTE6 in VARCHAR2
47 ,P_ATTRIBUTE7 in VARCHAR2
48 ,P_ATTRIBUTE8 in VARCHAR2
49 ,P_ATTRIBUTE9 in VARCHAR2
50 ,P_ATTRIBUTE10 in VARCHAR2
51 ,P_ATTRIBUTE11 in VARCHAR2
52 ,P_ATTRIBUTE12 in VARCHAR2
53 ,P_ATTRIBUTE13 in VARCHAR2
54 ,P_ATTRIBUTE14 in VARCHAR2
55 ,P_ATTRIBUTE15 in VARCHAR2
56 ,P_ATTRIBUTE16 in VARCHAR2
57 ,P_ATTRIBUTE17 in VARCHAR2
58 ,P_ATTRIBUTE18 in VARCHAR2
59 ,P_ATTRIBUTE19 in VARCHAR2
60 ,P_ATTRIBUTE20 in VARCHAR2
61 ,P_ATTRIBUTE21 in VARCHAR2
62 ,P_ATTRIBUTE22 in VARCHAR2
63 ,P_ATTRIBUTE23 in VARCHAR2
64 ,P_ATTRIBUTE24 in VARCHAR2
65 ,P_ATTRIBUTE25 in VARCHAR2
66 ,P_ATTRIBUTE26 in VARCHAR2
67 ,P_ATTRIBUTE27 in VARCHAR2
68 ,P_ATTRIBUTE28 in VARCHAR2
69 ,P_ATTRIBUTE29 in VARCHAR2
70 ,P_ATTRIBUTE30 in VARCHAR2
71 ,P_PGP_SEGMENT1 in VARCHAR2
72 ,P_PGP_SEGMENT2 in VARCHAR2
73 ,P_PGP_SEGMENT3 in VARCHAR2
74 ,P_PGP_SEGMENT4 in VARCHAR2
75 ,P_PGP_SEGMENT5 in VARCHAR2
76 ,P_PGP_SEGMENT6 in VARCHAR2
77 ,P_PGP_SEGMENT7 in VARCHAR2
78 ,P_PGP_SEGMENT8 in VARCHAR2
79 ,P_PGP_SEGMENT9 in VARCHAR2
80 ,P_PGP_SEGMENT10 in VARCHAR2
81 ,P_PGP_SEGMENT11 in VARCHAR2
82 ,P_PGP_SEGMENT12 in VARCHAR2
83 ,P_PGP_SEGMENT13 in VARCHAR2
84 ,P_PGP_SEGMENT14 in VARCHAR2
85 ,P_PGP_SEGMENT15 in VARCHAR2
86 ,P_PGP_SEGMENT16 in VARCHAR2
87 ,P_PGP_SEGMENT17 in VARCHAR2
88 ,P_PGP_SEGMENT18 in VARCHAR2
89 ,P_PGP_SEGMENT19 in VARCHAR2
90 ,P_PGP_SEGMENT20 in VARCHAR2
91 ,P_PGP_SEGMENT21 in VARCHAR2
92 ,P_PGP_SEGMENT22 in VARCHAR2
93 ,P_PGP_SEGMENT23 in VARCHAR2
94 ,P_PGP_SEGMENT24 in VARCHAR2
95 ,P_PGP_SEGMENT25 in VARCHAR2
96 ,P_PGP_SEGMENT26 in VARCHAR2
97 ,P_PGP_SEGMENT27 in VARCHAR2
98 ,P_PGP_SEGMENT28 in VARCHAR2
99 ,P_PGP_SEGMENT29 in VARCHAR2
100 ,P_PGP_SEGMENT30 in VARCHAR2
101 ,P_SCL_SEGMENT1 in VARCHAR2
102 ,P_SCL_SEGMENT2 in VARCHAR2
103 ,P_SCL_SEGMENT3 in VARCHAR2
104 ,P_SCL_SEGMENT4 in VARCHAR2
105 ,P_SCL_SEGMENT5 in VARCHAR2
106 ,P_SCL_SEGMENT6 in VARCHAR2
107 ,P_SCL_SEGMENT7 in VARCHAR2
108 ,P_SCL_SEGMENT8 in VARCHAR2
109 ,P_SCL_SEGMENT9 in VARCHAR2
110 ,P_SCL_SEGMENT10 in VARCHAR2
111 ,P_SCL_SEGMENT11 in VARCHAR2
112 ,P_SCL_SEGMENT12 in VARCHAR2
113 ,P_SCL_SEGMENT13 in VARCHAR2
114 ,P_SCL_SEGMENT14 in VARCHAR2
115 ,P_SCL_SEGMENT15 in VARCHAR2
116 ,P_SCL_SEGMENT16 in VARCHAR2
117 ,P_SCL_SEGMENT17 in VARCHAR2
118 ,P_SCL_SEGMENT18 in VARCHAR2
119 ,P_SCL_SEGMENT19 in VARCHAR2
120 ,P_SCL_SEGMENT20 in VARCHAR2
121 ,P_SCL_SEGMENT21 in VARCHAR2
122 ,P_SCL_SEGMENT22 in VARCHAR2
123 ,P_SCL_SEGMENT23 in VARCHAR2
124 ,P_SCL_SEGMENT24 in VARCHAR2
125 ,P_SCL_SEGMENT25 in VARCHAR2
126 ,P_SCL_SEGMENT26 in VARCHAR2
127 ,P_SCL_SEGMENT27 in VARCHAR2
128 ,P_SCL_SEGMENT28 in VARCHAR2
129 ,P_SCL_SEGMENT29 in VARCHAR2
130 ,P_SCL_SEGMENT30 in VARCHAR2
131 ,P_SCL_CONCAT_SEGMENTS in VARCHAR2
132 ,P_PGP_CONCAT_SEGMENTS in VARCHAR2
133 ,P_ASSIGNMENT_ID in NUMBER
134 ,P_OBJECT_VERSION_NUMBER in NUMBER
135 ,P_EFFECTIVE_START_DATE in DATE
136 ,P_EFFECTIVE_END_DATE in DATE
137 ,P_ASSIGNMENT_SEQUENCE in NUMBER
138 ,P_COMMENT_ID in NUMBER
139 ,P_PEOPLE_GROUP_ID in NUMBER
140 ,P_PEOPLE_GROUP_NAME in VARCHAR2
141 ,P_OTHER_MANAGER_WARNING in BOOLEAN
142 ,P_HOURLY_SALARIED_WARNING in BOOLEAN
143 ,P_SOFT_CODING_KEYFLEX_ID in NUMBER
144 ,P_SUPERVISOR_ASSIGNMENT_ID in NUMBER
145 )is
146 l_commit_unit_number number;
147 l_legislation_code   varchar2(30);
148 begin
149 hr_utility.set_location('Entering: HR_ASSIGNMENT_BKN.CREATE_SECONDARY_CWK_ASG_A', 10);
150 l_commit_unit_number := hr_api.return_commit_unit;
151 if hr_api.call_app_hooks then
152 hr_assignment_beN.CREATE_SECONDARY_CWK_ASG_A
153 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
154 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
155 ,P_PERSON_ID => P_PERSON_ID
156 ,P_ORGANIZATION_ID => P_ORGANIZATION_ID
157 ,P_ASSIGNMENT_NUMBER => P_ASSIGNMENT_NUMBER
158 ,P_ASSIGNMENT_CATEGORY => P_ASSIGNMENT_CATEGORY
159 ,P_ASSIGNMENT_STATUS_TYPE_ID => P_ASSIGNMENT_STATUS_TYPE_ID
160 ,P_CHANGE_REASON => P_CHANGE_REASON
161 ,P_COMMENTS => P_COMMENTS
162 ,P_DEFAULT_CODE_COMB_ID => P_DEFAULT_CODE_COMB_ID
163 ,P_ESTABLISHMENT_ID => P_ESTABLISHMENT_ID
164 ,P_FREQUENCY => P_FREQUENCY
165 ,P_INTERNAL_ADDRESS_LINE => P_INTERNAL_ADDRESS_LINE
166 ,P_JOB_ID => P_JOB_ID
167 ,P_LABOUR_UNION_MEMBER_FLAG => P_LABOUR_UNION_MEMBER_FLAG
168 ,P_LOCATION_ID => P_LOCATION_ID
169 ,P_MANAGER_FLAG => P_MANAGER_FLAG
170 ,P_NORMAL_HOURS => P_NORMAL_HOURS
171 ,P_POSITION_ID => P_POSITION_ID
172 ,P_GRADE_ID => P_GRADE_ID
173 ,P_PROJECT_TITLE => P_PROJECT_TITLE
174 ,P_SET_OF_BOOKS_ID => P_SET_OF_BOOKS_ID
175 ,P_SOURCE_TYPE => P_SOURCE_TYPE
176 ,P_SUPERVISOR_ID => P_SUPERVISOR_ID
177 ,P_TIME_NORMAL_FINISH => P_TIME_NORMAL_FINISH
178 ,P_TIME_NORMAL_START => P_TIME_NORMAL_START
179 ,P_TITLE => P_TITLE
180 ,P_VENDOR_ASSIGNMENT_NUMBER => P_VENDOR_ASSIGNMENT_NUMBER
181 ,P_VENDOR_EMPLOYEE_NUMBER => P_VENDOR_EMPLOYEE_NUMBER
182 ,P_VENDOR_ID => P_VENDOR_ID
183 ,P_VENDOR_SITE_ID => P_VENDOR_SITE_ID
184 ,P_PO_HEADER_ID => P_PO_HEADER_ID
185 ,P_PO_LINE_ID => P_PO_LINE_ID
186 ,P_PROJECTED_ASSIGNMENT_END => P_PROJECTED_ASSIGNMENT_END
187 ,P_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY
188 ,P_ATTRIBUTE1 => P_ATTRIBUTE1
189 ,P_ATTRIBUTE2 => P_ATTRIBUTE2
190 ,P_ATTRIBUTE3 => P_ATTRIBUTE3
191 ,P_ATTRIBUTE4 => P_ATTRIBUTE4
192 ,P_ATTRIBUTE5 => P_ATTRIBUTE5
193 ,P_ATTRIBUTE6 => P_ATTRIBUTE6
194 ,P_ATTRIBUTE7 => P_ATTRIBUTE7
195 ,P_ATTRIBUTE8 => P_ATTRIBUTE8
196 ,P_ATTRIBUTE9 => P_ATTRIBUTE9
197 ,P_ATTRIBUTE10 => P_ATTRIBUTE10
198 ,P_ATTRIBUTE11 => P_ATTRIBUTE11
199 ,P_ATTRIBUTE12 => P_ATTRIBUTE12
200 ,P_ATTRIBUTE13 => P_ATTRIBUTE13
201 ,P_ATTRIBUTE14 => P_ATTRIBUTE14
202 ,P_ATTRIBUTE15 => P_ATTRIBUTE15
203 ,P_ATTRIBUTE16 => P_ATTRIBUTE16
204 ,P_ATTRIBUTE17 => P_ATTRIBUTE17
205 ,P_ATTRIBUTE18 => P_ATTRIBUTE18
206 ,P_ATTRIBUTE19 => P_ATTRIBUTE19
207 ,P_ATTRIBUTE20 => P_ATTRIBUTE20
208 ,P_ATTRIBUTE21 => P_ATTRIBUTE21
209 ,P_ATTRIBUTE22 => P_ATTRIBUTE22
210 ,P_ATTRIBUTE23 => P_ATTRIBUTE23
211 ,P_ATTRIBUTE24 => P_ATTRIBUTE24
212 ,P_ATTRIBUTE25 => P_ATTRIBUTE25
213 ,P_ATTRIBUTE26 => P_ATTRIBUTE26
214 ,P_ATTRIBUTE27 => P_ATTRIBUTE27
215 ,P_ATTRIBUTE28 => P_ATTRIBUTE28
216 ,P_ATTRIBUTE29 => P_ATTRIBUTE29
217 ,P_ATTRIBUTE30 => P_ATTRIBUTE30
218 ,P_PGP_SEGMENT1 => P_PGP_SEGMENT1
219 ,P_PGP_SEGMENT2 => P_PGP_SEGMENT2
220 ,P_PGP_SEGMENT3 => P_PGP_SEGMENT3
221 ,P_PGP_SEGMENT4 => P_PGP_SEGMENT4
222 ,P_PGP_SEGMENT5 => P_PGP_SEGMENT5
223 ,P_PGP_SEGMENT6 => P_PGP_SEGMENT6
224 ,P_PGP_SEGMENT7 => P_PGP_SEGMENT7
225 ,P_PGP_SEGMENT8 => P_PGP_SEGMENT8
226 ,P_PGP_SEGMENT9 => P_PGP_SEGMENT9
227 ,P_PGP_SEGMENT10 => P_PGP_SEGMENT10
228 ,P_PGP_SEGMENT11 => P_PGP_SEGMENT11
229 ,P_PGP_SEGMENT12 => P_PGP_SEGMENT12
230 ,P_PGP_SEGMENT13 => P_PGP_SEGMENT13
231 ,P_PGP_SEGMENT14 => P_PGP_SEGMENT14
232 ,P_PGP_SEGMENT15 => P_PGP_SEGMENT15
233 ,P_PGP_SEGMENT16 => P_PGP_SEGMENT16
234 ,P_PGP_SEGMENT17 => P_PGP_SEGMENT17
235 ,P_PGP_SEGMENT18 => P_PGP_SEGMENT18
236 ,P_PGP_SEGMENT19 => P_PGP_SEGMENT19
237 ,P_PGP_SEGMENT20 => P_PGP_SEGMENT20
238 ,P_PGP_SEGMENT21 => P_PGP_SEGMENT21
239 ,P_PGP_SEGMENT22 => P_PGP_SEGMENT22
240 ,P_PGP_SEGMENT23 => P_PGP_SEGMENT23
241 ,P_PGP_SEGMENT24 => P_PGP_SEGMENT24
242 ,P_PGP_SEGMENT25 => P_PGP_SEGMENT25
243 ,P_PGP_SEGMENT26 => P_PGP_SEGMENT26
244 ,P_PGP_SEGMENT27 => P_PGP_SEGMENT27
245 ,P_PGP_SEGMENT28 => P_PGP_SEGMENT28
246 ,P_PGP_SEGMENT29 => P_PGP_SEGMENT29
247 ,P_PGP_SEGMENT30 => P_PGP_SEGMENT30
248 ,P_SCL_SEGMENT1 => P_SCL_SEGMENT1
249 ,P_SCL_SEGMENT2 => P_SCL_SEGMENT2
250 ,P_SCL_SEGMENT3 => P_SCL_SEGMENT3
251 ,P_SCL_SEGMENT4 => P_SCL_SEGMENT4
252 ,P_SCL_SEGMENT5 => P_SCL_SEGMENT5
253 ,P_SCL_SEGMENT6 => P_SCL_SEGMENT6
254 ,P_SCL_SEGMENT7 => P_SCL_SEGMENT7
255 ,P_SCL_SEGMENT8 => P_SCL_SEGMENT8
256 ,P_SCL_SEGMENT9 => P_SCL_SEGMENT9
257 ,P_SCL_SEGMENT10 => P_SCL_SEGMENT10
258 ,P_SCL_SEGMENT11 => P_SCL_SEGMENT11
259 ,P_SCL_SEGMENT12 => P_SCL_SEGMENT12
260 ,P_SCL_SEGMENT13 => P_SCL_SEGMENT13
261 ,P_SCL_SEGMENT14 => P_SCL_SEGMENT14
262 ,P_SCL_SEGMENT15 => P_SCL_SEGMENT15
263 ,P_SCL_SEGMENT16 => P_SCL_SEGMENT16
264 ,P_SCL_SEGMENT17 => P_SCL_SEGMENT17
265 ,P_SCL_SEGMENT18 => P_SCL_SEGMENT18
266 ,P_SCL_SEGMENT19 => P_SCL_SEGMENT19
267 ,P_SCL_SEGMENT20 => P_SCL_SEGMENT20
268 ,P_SCL_SEGMENT21 => P_SCL_SEGMENT21
269 ,P_SCL_SEGMENT22 => P_SCL_SEGMENT22
270 ,P_SCL_SEGMENT23 => P_SCL_SEGMENT23
271 ,P_SCL_SEGMENT24 => P_SCL_SEGMENT24
272 ,P_SCL_SEGMENT25 => P_SCL_SEGMENT25
273 ,P_SCL_SEGMENT26 => P_SCL_SEGMENT26
274 ,P_SCL_SEGMENT27 => P_SCL_SEGMENT27
275 ,P_SCL_SEGMENT28 => P_SCL_SEGMENT28
276 ,P_SCL_SEGMENT29 => P_SCL_SEGMENT29
277 ,P_SCL_SEGMENT30 => P_SCL_SEGMENT30
278 ,P_SCL_CONCAT_SEGMENTS => P_SCL_CONCAT_SEGMENTS
279 ,P_PGP_CONCAT_SEGMENTS => P_PGP_CONCAT_SEGMENTS
280 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
281 ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
282 ,P_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE
283 ,P_EFFECTIVE_END_DATE => P_EFFECTIVE_END_DATE
284 ,P_ASSIGNMENT_SEQUENCE => P_ASSIGNMENT_SEQUENCE
285 ,P_COMMENT_ID => P_COMMENT_ID
286 ,P_PEOPLE_GROUP_ID => P_PEOPLE_GROUP_ID
287 ,P_PEOPLE_GROUP_NAME => P_PEOPLE_GROUP_NAME
288 ,P_OTHER_MANAGER_WARNING => P_OTHER_MANAGER_WARNING
289 ,P_HOURLY_SALARIED_WARNING => P_HOURLY_SALARIED_WARNING
290 ,P_SOFT_CODING_KEYFLEX_ID => P_SOFT_CODING_KEYFLEX_ID
291 ,P_SUPERVISOR_ASSIGNMENT_ID => P_SUPERVISOR_ASSIGNMENT_ID
292 );
293 end if;
294 hr_multi_message.end_validation_set;
295 hr_api.validate_commit_unit(l_commit_unit_number, 'CREATE_SECONDARY_CWK_ASG', 'AP');
296 hr_utility.set_location(' Leaving: HR_ASSIGNMENT_BKN.CREATE_SECONDARY_CWK_ASG_A', 20);
297 end CREATE_SECONDARY_CWK_ASG_A;
298 procedure CREATE_SECONDARY_CWK_ASG_B
299 (P_EFFECTIVE_DATE in DATE
300 ,P_BUSINESS_GROUP_ID in NUMBER
301 ,P_PERSON_ID in NUMBER
302 ,P_ORGANIZATION_ID in NUMBER
303 ,P_ASSIGNMENT_NUMBER in VARCHAR2
304 ,P_ASSIGNMENT_CATEGORY in VARCHAR2
305 ,P_ASSIGNMENT_STATUS_TYPE_ID in NUMBER
306 ,P_CHANGE_REASON in VARCHAR2
307 ,P_COMMENTS in VARCHAR2
308 ,P_DEFAULT_CODE_COMB_ID in NUMBER
309 ,P_ESTABLISHMENT_ID in NUMBER
310 ,P_FREQUENCY in VARCHAR2
311 ,P_INTERNAL_ADDRESS_LINE in VARCHAR2
312 ,P_JOB_ID in NUMBER
313 ,P_LABOUR_UNION_MEMBER_FLAG in VARCHAR2
314 ,P_LOCATION_ID in NUMBER
315 ,P_MANAGER_FLAG in VARCHAR2
316 ,P_NORMAL_HOURS in NUMBER
317 ,P_POSITION_ID in NUMBER
318 ,P_GRADE_ID in NUMBER
319 ,P_PROJECT_TITLE in VARCHAR2
320 ,P_SET_OF_BOOKS_ID in NUMBER
321 ,P_SOURCE_TYPE in VARCHAR2
322 ,P_SUPERVISOR_ID in NUMBER
323 ,P_TIME_NORMAL_FINISH in VARCHAR2
324 ,P_TIME_NORMAL_START in VARCHAR2
325 ,P_TITLE in VARCHAR2
326 ,P_VENDOR_ASSIGNMENT_NUMBER in VARCHAR2
327 ,P_VENDOR_EMPLOYEE_NUMBER in VARCHAR2
328 ,P_VENDOR_ID in NUMBER
329 ,P_VENDOR_SITE_ID in NUMBER
330 ,P_PO_HEADER_ID in NUMBER
331 ,P_PO_LINE_ID in NUMBER
332 ,P_PROJECTED_ASSIGNMENT_END in DATE
333 ,P_ATTRIBUTE_CATEGORY in VARCHAR2
334 ,P_ATTRIBUTE1 in VARCHAR2
335 ,P_ATTRIBUTE2 in VARCHAR2
336 ,P_ATTRIBUTE3 in VARCHAR2
337 ,P_ATTRIBUTE4 in VARCHAR2
338 ,P_ATTRIBUTE5 in VARCHAR2
339 ,P_ATTRIBUTE6 in VARCHAR2
340 ,P_ATTRIBUTE7 in VARCHAR2
341 ,P_ATTRIBUTE8 in VARCHAR2
342 ,P_ATTRIBUTE9 in VARCHAR2
343 ,P_ATTRIBUTE10 in VARCHAR2
344 ,P_ATTRIBUTE11 in VARCHAR2
345 ,P_ATTRIBUTE12 in VARCHAR2
346 ,P_ATTRIBUTE13 in VARCHAR2
347 ,P_ATTRIBUTE14 in VARCHAR2
348 ,P_ATTRIBUTE15 in VARCHAR2
349 ,P_ATTRIBUTE16 in VARCHAR2
350 ,P_ATTRIBUTE17 in VARCHAR2
351 ,P_ATTRIBUTE18 in VARCHAR2
352 ,P_ATTRIBUTE19 in VARCHAR2
353 ,P_ATTRIBUTE20 in VARCHAR2
354 ,P_ATTRIBUTE21 in VARCHAR2
355 ,P_ATTRIBUTE22 in VARCHAR2
356 ,P_ATTRIBUTE23 in VARCHAR2
357 ,P_ATTRIBUTE24 in VARCHAR2
358 ,P_ATTRIBUTE25 in VARCHAR2
359 ,P_ATTRIBUTE26 in VARCHAR2
360 ,P_ATTRIBUTE27 in VARCHAR2
361 ,P_ATTRIBUTE28 in VARCHAR2
362 ,P_ATTRIBUTE29 in VARCHAR2
363 ,P_ATTRIBUTE30 in VARCHAR2
364 ,P_PGP_SEGMENT1 in VARCHAR2
365 ,P_PGP_SEGMENT2 in VARCHAR2
366 ,P_PGP_SEGMENT3 in VARCHAR2
367 ,P_PGP_SEGMENT4 in VARCHAR2
368 ,P_PGP_SEGMENT5 in VARCHAR2
369 ,P_PGP_SEGMENT6 in VARCHAR2
370 ,P_PGP_SEGMENT7 in VARCHAR2
371 ,P_PGP_SEGMENT8 in VARCHAR2
372 ,P_PGP_SEGMENT9 in VARCHAR2
373 ,P_PGP_SEGMENT10 in VARCHAR2
374 ,P_PGP_SEGMENT11 in VARCHAR2
375 ,P_PGP_SEGMENT12 in VARCHAR2
376 ,P_PGP_SEGMENT13 in VARCHAR2
377 ,P_PGP_SEGMENT14 in VARCHAR2
378 ,P_PGP_SEGMENT15 in VARCHAR2
379 ,P_PGP_SEGMENT16 in VARCHAR2
380 ,P_PGP_SEGMENT17 in VARCHAR2
381 ,P_PGP_SEGMENT18 in VARCHAR2
382 ,P_PGP_SEGMENT19 in VARCHAR2
383 ,P_PGP_SEGMENT20 in VARCHAR2
384 ,P_PGP_SEGMENT21 in VARCHAR2
385 ,P_PGP_SEGMENT22 in VARCHAR2
386 ,P_PGP_SEGMENT23 in VARCHAR2
387 ,P_PGP_SEGMENT24 in VARCHAR2
388 ,P_PGP_SEGMENT25 in VARCHAR2
389 ,P_PGP_SEGMENT26 in VARCHAR2
390 ,P_PGP_SEGMENT27 in VARCHAR2
391 ,P_PGP_SEGMENT28 in VARCHAR2
392 ,P_PGP_SEGMENT29 in VARCHAR2
393 ,P_PGP_SEGMENT30 in VARCHAR2
394 ,P_SCL_SEGMENT1 in VARCHAR2
395 ,P_SCL_SEGMENT2 in VARCHAR2
396 ,P_SCL_SEGMENT3 in VARCHAR2
397 ,P_SCL_SEGMENT4 in VARCHAR2
398 ,P_SCL_SEGMENT5 in VARCHAR2
399 ,P_SCL_SEGMENT6 in VARCHAR2
400 ,P_SCL_SEGMENT7 in VARCHAR2
401 ,P_SCL_SEGMENT8 in VARCHAR2
402 ,P_SCL_SEGMENT9 in VARCHAR2
403 ,P_SCL_SEGMENT10 in VARCHAR2
404 ,P_SCL_SEGMENT11 in VARCHAR2
405 ,P_SCL_SEGMENT12 in VARCHAR2
406 ,P_SCL_SEGMENT13 in VARCHAR2
407 ,P_SCL_SEGMENT14 in VARCHAR2
408 ,P_SCL_SEGMENT15 in VARCHAR2
409 ,P_SCL_SEGMENT16 in VARCHAR2
410 ,P_SCL_SEGMENT17 in VARCHAR2
411 ,P_SCL_SEGMENT18 in VARCHAR2
412 ,P_SCL_SEGMENT19 in VARCHAR2
413 ,P_SCL_SEGMENT20 in VARCHAR2
414 ,P_SCL_SEGMENT21 in VARCHAR2
415 ,P_SCL_SEGMENT22 in VARCHAR2
416 ,P_SCL_SEGMENT23 in VARCHAR2
417 ,P_SCL_SEGMENT24 in VARCHAR2
418 ,P_SCL_SEGMENT25 in VARCHAR2
419 ,P_SCL_SEGMENT26 in VARCHAR2
420 ,P_SCL_SEGMENT27 in VARCHAR2
421 ,P_SCL_SEGMENT28 in VARCHAR2
422 ,P_SCL_SEGMENT29 in VARCHAR2
423 ,P_SCL_SEGMENT30 in VARCHAR2
424 ,P_SCL_CONCAT_SEGMENTS in VARCHAR2
425 ,P_PGP_CONCAT_SEGMENTS in VARCHAR2
426 ,P_SUPERVISOR_ASSIGNMENT_ID in NUMBER
427 )is
428 begin
429 hr_utility.set_location('Entering: HR_ASSIGNMENT_BKN.CREATE_SECONDARY_CWK_ASG_B', 10);
430 hr_utility.set_location(' Leaving: HR_ASSIGNMENT_BKN.CREATE_SECONDARY_CWK_ASG_B', 20);
431 end CREATE_SECONDARY_CWK_ASG_B;
432 end HR_ASSIGNMENT_BKN;