51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy per_psh_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
113: Exception
114: When hr_api.check_integrity_violated Then
115: -- A check constraint has been violated
116: --
117: per_psh_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.parent_integrity_violated Then
120: -- Parent integrity has been violated
121: --
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.parent_integrity_violated Then
120: -- Parent integrity has been violated
121: --
122: per_psh_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.unique_integrity_violated Then
125: -- Unique integrity has been violated
126: --
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.unique_integrity_violated Then
125: -- Unique integrity has been violated
126: --
127: per_psh_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When Others Then
130: --
131: Raise;
163: --
164: -- {End Of Comments}
165: -- ----------------------------------------------------------------------------
166: Procedure pre_update
167: (p_rec in per_psh_shd.g_rec_type
168: ) is
169: --
170: l_proc varchar2(72) := g_package||'pre_update';
171: --
207: --
208: -- {End Of Comments}
209: -- ----------------------------------------------------------------------------
210: Procedure post_update
211: (p_rec in per_psh_shd.g_rec_type
212: ) is
213: --
214: l_proc varchar2(72) := g_package||'post_update';
215: --
288: => p_rec.attribute29
289: ,p_attribute30
290: => p_rec.attribute30
291: ,p_object_version_number_o
292: => per_psh_shd.g_old_rec.object_version_number
293: ,p_scorecard_id_o
294: => per_psh_shd.g_old_rec.scorecard_id
295: ,p_person_id_o
296: => per_psh_shd.g_old_rec.person_id
290: => p_rec.attribute30
291: ,p_object_version_number_o
292: => per_psh_shd.g_old_rec.object_version_number
293: ,p_scorecard_id_o
294: => per_psh_shd.g_old_rec.scorecard_id
295: ,p_person_id_o
296: => per_psh_shd.g_old_rec.person_id
297: ,p_attribute_category_o
298: => per_psh_shd.g_old_rec.attribute_category
292: => per_psh_shd.g_old_rec.object_version_number
293: ,p_scorecard_id_o
294: => per_psh_shd.g_old_rec.scorecard_id
295: ,p_person_id_o
296: => per_psh_shd.g_old_rec.person_id
297: ,p_attribute_category_o
298: => per_psh_shd.g_old_rec.attribute_category
299: ,p_attribute1_o
300: => per_psh_shd.g_old_rec.attribute1
294: => per_psh_shd.g_old_rec.scorecard_id
295: ,p_person_id_o
296: => per_psh_shd.g_old_rec.person_id
297: ,p_attribute_category_o
298: => per_psh_shd.g_old_rec.attribute_category
299: ,p_attribute1_o
300: => per_psh_shd.g_old_rec.attribute1
301: ,p_attribute2_o
302: => per_psh_shd.g_old_rec.attribute2
296: => per_psh_shd.g_old_rec.person_id
297: ,p_attribute_category_o
298: => per_psh_shd.g_old_rec.attribute_category
299: ,p_attribute1_o
300: => per_psh_shd.g_old_rec.attribute1
301: ,p_attribute2_o
302: => per_psh_shd.g_old_rec.attribute2
303: ,p_attribute3_o
304: => per_psh_shd.g_old_rec.attribute3
298: => per_psh_shd.g_old_rec.attribute_category
299: ,p_attribute1_o
300: => per_psh_shd.g_old_rec.attribute1
301: ,p_attribute2_o
302: => per_psh_shd.g_old_rec.attribute2
303: ,p_attribute3_o
304: => per_psh_shd.g_old_rec.attribute3
305: ,p_attribute4_o
306: => per_psh_shd.g_old_rec.attribute4
300: => per_psh_shd.g_old_rec.attribute1
301: ,p_attribute2_o
302: => per_psh_shd.g_old_rec.attribute2
303: ,p_attribute3_o
304: => per_psh_shd.g_old_rec.attribute3
305: ,p_attribute4_o
306: => per_psh_shd.g_old_rec.attribute4
307: ,p_attribute5_o
308: => per_psh_shd.g_old_rec.attribute5
302: => per_psh_shd.g_old_rec.attribute2
303: ,p_attribute3_o
304: => per_psh_shd.g_old_rec.attribute3
305: ,p_attribute4_o
306: => per_psh_shd.g_old_rec.attribute4
307: ,p_attribute5_o
308: => per_psh_shd.g_old_rec.attribute5
309: ,p_attribute6_o
310: => per_psh_shd.g_old_rec.attribute6
304: => per_psh_shd.g_old_rec.attribute3
305: ,p_attribute4_o
306: => per_psh_shd.g_old_rec.attribute4
307: ,p_attribute5_o
308: => per_psh_shd.g_old_rec.attribute5
309: ,p_attribute6_o
310: => per_psh_shd.g_old_rec.attribute6
311: ,p_attribute7_o
312: => per_psh_shd.g_old_rec.attribute7
306: => per_psh_shd.g_old_rec.attribute4
307: ,p_attribute5_o
308: => per_psh_shd.g_old_rec.attribute5
309: ,p_attribute6_o
310: => per_psh_shd.g_old_rec.attribute6
311: ,p_attribute7_o
312: => per_psh_shd.g_old_rec.attribute7
313: ,p_attribute8_o
314: => per_psh_shd.g_old_rec.attribute8
308: => per_psh_shd.g_old_rec.attribute5
309: ,p_attribute6_o
310: => per_psh_shd.g_old_rec.attribute6
311: ,p_attribute7_o
312: => per_psh_shd.g_old_rec.attribute7
313: ,p_attribute8_o
314: => per_psh_shd.g_old_rec.attribute8
315: ,p_attribute9_o
316: => per_psh_shd.g_old_rec.attribute9
310: => per_psh_shd.g_old_rec.attribute6
311: ,p_attribute7_o
312: => per_psh_shd.g_old_rec.attribute7
313: ,p_attribute8_o
314: => per_psh_shd.g_old_rec.attribute8
315: ,p_attribute9_o
316: => per_psh_shd.g_old_rec.attribute9
317: ,p_attribute10_o
318: => per_psh_shd.g_old_rec.attribute10
312: => per_psh_shd.g_old_rec.attribute7
313: ,p_attribute8_o
314: => per_psh_shd.g_old_rec.attribute8
315: ,p_attribute9_o
316: => per_psh_shd.g_old_rec.attribute9
317: ,p_attribute10_o
318: => per_psh_shd.g_old_rec.attribute10
319: ,p_attribute11_o
320: => per_psh_shd.g_old_rec.attribute11
314: => per_psh_shd.g_old_rec.attribute8
315: ,p_attribute9_o
316: => per_psh_shd.g_old_rec.attribute9
317: ,p_attribute10_o
318: => per_psh_shd.g_old_rec.attribute10
319: ,p_attribute11_o
320: => per_psh_shd.g_old_rec.attribute11
321: ,p_attribute12_o
322: => per_psh_shd.g_old_rec.attribute12
316: => per_psh_shd.g_old_rec.attribute9
317: ,p_attribute10_o
318: => per_psh_shd.g_old_rec.attribute10
319: ,p_attribute11_o
320: => per_psh_shd.g_old_rec.attribute11
321: ,p_attribute12_o
322: => per_psh_shd.g_old_rec.attribute12
323: ,p_attribute13_o
324: => per_psh_shd.g_old_rec.attribute13
318: => per_psh_shd.g_old_rec.attribute10
319: ,p_attribute11_o
320: => per_psh_shd.g_old_rec.attribute11
321: ,p_attribute12_o
322: => per_psh_shd.g_old_rec.attribute12
323: ,p_attribute13_o
324: => per_psh_shd.g_old_rec.attribute13
325: ,p_attribute14_o
326: => per_psh_shd.g_old_rec.attribute14
320: => per_psh_shd.g_old_rec.attribute11
321: ,p_attribute12_o
322: => per_psh_shd.g_old_rec.attribute12
323: ,p_attribute13_o
324: => per_psh_shd.g_old_rec.attribute13
325: ,p_attribute14_o
326: => per_psh_shd.g_old_rec.attribute14
327: ,p_attribute15_o
328: => per_psh_shd.g_old_rec.attribute15
322: => per_psh_shd.g_old_rec.attribute12
323: ,p_attribute13_o
324: => per_psh_shd.g_old_rec.attribute13
325: ,p_attribute14_o
326: => per_psh_shd.g_old_rec.attribute14
327: ,p_attribute15_o
328: => per_psh_shd.g_old_rec.attribute15
329: ,p_attribute16_o
330: => per_psh_shd.g_old_rec.attribute16
324: => per_psh_shd.g_old_rec.attribute13
325: ,p_attribute14_o
326: => per_psh_shd.g_old_rec.attribute14
327: ,p_attribute15_o
328: => per_psh_shd.g_old_rec.attribute15
329: ,p_attribute16_o
330: => per_psh_shd.g_old_rec.attribute16
331: ,p_attribute17_o
332: => per_psh_shd.g_old_rec.attribute17
326: => per_psh_shd.g_old_rec.attribute14
327: ,p_attribute15_o
328: => per_psh_shd.g_old_rec.attribute15
329: ,p_attribute16_o
330: => per_psh_shd.g_old_rec.attribute16
331: ,p_attribute17_o
332: => per_psh_shd.g_old_rec.attribute17
333: ,p_attribute18_o
334: => per_psh_shd.g_old_rec.attribute18
328: => per_psh_shd.g_old_rec.attribute15
329: ,p_attribute16_o
330: => per_psh_shd.g_old_rec.attribute16
331: ,p_attribute17_o
332: => per_psh_shd.g_old_rec.attribute17
333: ,p_attribute18_o
334: => per_psh_shd.g_old_rec.attribute18
335: ,p_attribute19_o
336: => per_psh_shd.g_old_rec.attribute19
330: => per_psh_shd.g_old_rec.attribute16
331: ,p_attribute17_o
332: => per_psh_shd.g_old_rec.attribute17
333: ,p_attribute18_o
334: => per_psh_shd.g_old_rec.attribute18
335: ,p_attribute19_o
336: => per_psh_shd.g_old_rec.attribute19
337: ,p_attribute20_o
338: => per_psh_shd.g_old_rec.attribute20
332: => per_psh_shd.g_old_rec.attribute17
333: ,p_attribute18_o
334: => per_psh_shd.g_old_rec.attribute18
335: ,p_attribute19_o
336: => per_psh_shd.g_old_rec.attribute19
337: ,p_attribute20_o
338: => per_psh_shd.g_old_rec.attribute20
339: ,p_attribute21_o
340: => per_psh_shd.g_old_rec.attribute21
334: => per_psh_shd.g_old_rec.attribute18
335: ,p_attribute19_o
336: => per_psh_shd.g_old_rec.attribute19
337: ,p_attribute20_o
338: => per_psh_shd.g_old_rec.attribute20
339: ,p_attribute21_o
340: => per_psh_shd.g_old_rec.attribute21
341: ,p_attribute22_o
342: => per_psh_shd.g_old_rec.attribute22
336: => per_psh_shd.g_old_rec.attribute19
337: ,p_attribute20_o
338: => per_psh_shd.g_old_rec.attribute20
339: ,p_attribute21_o
340: => per_psh_shd.g_old_rec.attribute21
341: ,p_attribute22_o
342: => per_psh_shd.g_old_rec.attribute22
343: ,p_attribute23_o
344: => per_psh_shd.g_old_rec.attribute23
338: => per_psh_shd.g_old_rec.attribute20
339: ,p_attribute21_o
340: => per_psh_shd.g_old_rec.attribute21
341: ,p_attribute22_o
342: => per_psh_shd.g_old_rec.attribute22
343: ,p_attribute23_o
344: => per_psh_shd.g_old_rec.attribute23
345: ,p_attribute24_o
346: => per_psh_shd.g_old_rec.attribute24
340: => per_psh_shd.g_old_rec.attribute21
341: ,p_attribute22_o
342: => per_psh_shd.g_old_rec.attribute22
343: ,p_attribute23_o
344: => per_psh_shd.g_old_rec.attribute23
345: ,p_attribute24_o
346: => per_psh_shd.g_old_rec.attribute24
347: ,p_attribute25_o
348: => per_psh_shd.g_old_rec.attribute25
342: => per_psh_shd.g_old_rec.attribute22
343: ,p_attribute23_o
344: => per_psh_shd.g_old_rec.attribute23
345: ,p_attribute24_o
346: => per_psh_shd.g_old_rec.attribute24
347: ,p_attribute25_o
348: => per_psh_shd.g_old_rec.attribute25
349: ,p_attribute26_o
350: => per_psh_shd.g_old_rec.attribute26
344: => per_psh_shd.g_old_rec.attribute23
345: ,p_attribute24_o
346: => per_psh_shd.g_old_rec.attribute24
347: ,p_attribute25_o
348: => per_psh_shd.g_old_rec.attribute25
349: ,p_attribute26_o
350: => per_psh_shd.g_old_rec.attribute26
351: ,p_attribute27_o
352: => per_psh_shd.g_old_rec.attribute27
346: => per_psh_shd.g_old_rec.attribute24
347: ,p_attribute25_o
348: => per_psh_shd.g_old_rec.attribute25
349: ,p_attribute26_o
350: => per_psh_shd.g_old_rec.attribute26
351: ,p_attribute27_o
352: => per_psh_shd.g_old_rec.attribute27
353: ,p_attribute28_o
354: => per_psh_shd.g_old_rec.attribute28
348: => per_psh_shd.g_old_rec.attribute25
349: ,p_attribute26_o
350: => per_psh_shd.g_old_rec.attribute26
351: ,p_attribute27_o
352: => per_psh_shd.g_old_rec.attribute27
353: ,p_attribute28_o
354: => per_psh_shd.g_old_rec.attribute28
355: ,p_attribute29_o
356: => per_psh_shd.g_old_rec.attribute29
350: => per_psh_shd.g_old_rec.attribute26
351: ,p_attribute27_o
352: => per_psh_shd.g_old_rec.attribute27
353: ,p_attribute28_o
354: => per_psh_shd.g_old_rec.attribute28
355: ,p_attribute29_o
356: => per_psh_shd.g_old_rec.attribute29
357: ,p_attribute30_o
358: => per_psh_shd.g_old_rec.attribute30
352: => per_psh_shd.g_old_rec.attribute27
353: ,p_attribute28_o
354: => per_psh_shd.g_old_rec.attribute28
355: ,p_attribute29_o
356: => per_psh_shd.g_old_rec.attribute29
357: ,p_attribute30_o
358: => per_psh_shd.g_old_rec.attribute30
359: );
360: --
354: => per_psh_shd.g_old_rec.attribute28
355: ,p_attribute29_o
356: => per_psh_shd.g_old_rec.attribute29
357: ,p_attribute30_o
358: => per_psh_shd.g_old_rec.attribute30
359: );
360: --
361: exception
362: --
414: --
415: -- {End Of Comments}
416: -- ----------------------------------------------------------------------------
417: Procedure convert_defs
418: (p_rec in out nocopy per_psh_shd.g_rec_type
419: ) is
420: --
421: Begin
422: --
426: -- is being used then we must set to the 'current' argument value.
427: --
428: If (p_rec.scorecard_id = hr_api.g_number) then
429: p_rec.scorecard_id :=
430: per_psh_shd.g_old_rec.scorecard_id;
431: End If;
432: If (p_rec.person_id = hr_api.g_number) then
433: p_rec.person_id :=
434: per_psh_shd.g_old_rec.person_id;
430: per_psh_shd.g_old_rec.scorecard_id;
431: End If;
432: If (p_rec.person_id = hr_api.g_number) then
433: p_rec.person_id :=
434: per_psh_shd.g_old_rec.person_id;
435: End If;
436: If (p_rec.attribute_category = hr_api.g_varchar2) then
437: p_rec.attribute_category :=
438: per_psh_shd.g_old_rec.attribute_category;
434: per_psh_shd.g_old_rec.person_id;
435: End If;
436: If (p_rec.attribute_category = hr_api.g_varchar2) then
437: p_rec.attribute_category :=
438: per_psh_shd.g_old_rec.attribute_category;
439: End If;
440: If (p_rec.attribute1 = hr_api.g_varchar2) then
441: p_rec.attribute1 :=
442: per_psh_shd.g_old_rec.attribute1;
438: per_psh_shd.g_old_rec.attribute_category;
439: End If;
440: If (p_rec.attribute1 = hr_api.g_varchar2) then
441: p_rec.attribute1 :=
442: per_psh_shd.g_old_rec.attribute1;
443: End If;
444: If (p_rec.attribute2 = hr_api.g_varchar2) then
445: p_rec.attribute2 :=
446: per_psh_shd.g_old_rec.attribute2;
442: per_psh_shd.g_old_rec.attribute1;
443: End If;
444: If (p_rec.attribute2 = hr_api.g_varchar2) then
445: p_rec.attribute2 :=
446: per_psh_shd.g_old_rec.attribute2;
447: End If;
448: If (p_rec.attribute3 = hr_api.g_varchar2) then
449: p_rec.attribute3 :=
450: per_psh_shd.g_old_rec.attribute3;
446: per_psh_shd.g_old_rec.attribute2;
447: End If;
448: If (p_rec.attribute3 = hr_api.g_varchar2) then
449: p_rec.attribute3 :=
450: per_psh_shd.g_old_rec.attribute3;
451: End If;
452: If (p_rec.attribute4 = hr_api.g_varchar2) then
453: p_rec.attribute4 :=
454: per_psh_shd.g_old_rec.attribute4;
450: per_psh_shd.g_old_rec.attribute3;
451: End If;
452: If (p_rec.attribute4 = hr_api.g_varchar2) then
453: p_rec.attribute4 :=
454: per_psh_shd.g_old_rec.attribute4;
455: End If;
456: If (p_rec.attribute5 = hr_api.g_varchar2) then
457: p_rec.attribute5 :=
458: per_psh_shd.g_old_rec.attribute5;
454: per_psh_shd.g_old_rec.attribute4;
455: End If;
456: If (p_rec.attribute5 = hr_api.g_varchar2) then
457: p_rec.attribute5 :=
458: per_psh_shd.g_old_rec.attribute5;
459: End If;
460: If (p_rec.attribute6 = hr_api.g_varchar2) then
461: p_rec.attribute6 :=
462: per_psh_shd.g_old_rec.attribute6;
458: per_psh_shd.g_old_rec.attribute5;
459: End If;
460: If (p_rec.attribute6 = hr_api.g_varchar2) then
461: p_rec.attribute6 :=
462: per_psh_shd.g_old_rec.attribute6;
463: End If;
464: If (p_rec.attribute7 = hr_api.g_varchar2) then
465: p_rec.attribute7 :=
466: per_psh_shd.g_old_rec.attribute7;
462: per_psh_shd.g_old_rec.attribute6;
463: End If;
464: If (p_rec.attribute7 = hr_api.g_varchar2) then
465: p_rec.attribute7 :=
466: per_psh_shd.g_old_rec.attribute7;
467: End If;
468: If (p_rec.attribute8 = hr_api.g_varchar2) then
469: p_rec.attribute8 :=
470: per_psh_shd.g_old_rec.attribute8;
466: per_psh_shd.g_old_rec.attribute7;
467: End If;
468: If (p_rec.attribute8 = hr_api.g_varchar2) then
469: p_rec.attribute8 :=
470: per_psh_shd.g_old_rec.attribute8;
471: End If;
472: If (p_rec.attribute9 = hr_api.g_varchar2) then
473: p_rec.attribute9 :=
474: per_psh_shd.g_old_rec.attribute9;
470: per_psh_shd.g_old_rec.attribute8;
471: End If;
472: If (p_rec.attribute9 = hr_api.g_varchar2) then
473: p_rec.attribute9 :=
474: per_psh_shd.g_old_rec.attribute9;
475: End If;
476: If (p_rec.attribute10 = hr_api.g_varchar2) then
477: p_rec.attribute10 :=
478: per_psh_shd.g_old_rec.attribute10;
474: per_psh_shd.g_old_rec.attribute9;
475: End If;
476: If (p_rec.attribute10 = hr_api.g_varchar2) then
477: p_rec.attribute10 :=
478: per_psh_shd.g_old_rec.attribute10;
479: End If;
480: If (p_rec.attribute11 = hr_api.g_varchar2) then
481: p_rec.attribute11 :=
482: per_psh_shd.g_old_rec.attribute11;
478: per_psh_shd.g_old_rec.attribute10;
479: End If;
480: If (p_rec.attribute11 = hr_api.g_varchar2) then
481: p_rec.attribute11 :=
482: per_psh_shd.g_old_rec.attribute11;
483: End If;
484: If (p_rec.attribute12 = hr_api.g_varchar2) then
485: p_rec.attribute12 :=
486: per_psh_shd.g_old_rec.attribute12;
482: per_psh_shd.g_old_rec.attribute11;
483: End If;
484: If (p_rec.attribute12 = hr_api.g_varchar2) then
485: p_rec.attribute12 :=
486: per_psh_shd.g_old_rec.attribute12;
487: End If;
488: If (p_rec.attribute13 = hr_api.g_varchar2) then
489: p_rec.attribute13 :=
490: per_psh_shd.g_old_rec.attribute13;
486: per_psh_shd.g_old_rec.attribute12;
487: End If;
488: If (p_rec.attribute13 = hr_api.g_varchar2) then
489: p_rec.attribute13 :=
490: per_psh_shd.g_old_rec.attribute13;
491: End If;
492: If (p_rec.attribute14 = hr_api.g_varchar2) then
493: p_rec.attribute14 :=
494: per_psh_shd.g_old_rec.attribute14;
490: per_psh_shd.g_old_rec.attribute13;
491: End If;
492: If (p_rec.attribute14 = hr_api.g_varchar2) then
493: p_rec.attribute14 :=
494: per_psh_shd.g_old_rec.attribute14;
495: End If;
496: If (p_rec.attribute15 = hr_api.g_varchar2) then
497: p_rec.attribute15 :=
498: per_psh_shd.g_old_rec.attribute15;
494: per_psh_shd.g_old_rec.attribute14;
495: End If;
496: If (p_rec.attribute15 = hr_api.g_varchar2) then
497: p_rec.attribute15 :=
498: per_psh_shd.g_old_rec.attribute15;
499: End If;
500: If (p_rec.attribute16 = hr_api.g_varchar2) then
501: p_rec.attribute16 :=
502: per_psh_shd.g_old_rec.attribute16;
498: per_psh_shd.g_old_rec.attribute15;
499: End If;
500: If (p_rec.attribute16 = hr_api.g_varchar2) then
501: p_rec.attribute16 :=
502: per_psh_shd.g_old_rec.attribute16;
503: End If;
504: If (p_rec.attribute17 = hr_api.g_varchar2) then
505: p_rec.attribute17 :=
506: per_psh_shd.g_old_rec.attribute17;
502: per_psh_shd.g_old_rec.attribute16;
503: End If;
504: If (p_rec.attribute17 = hr_api.g_varchar2) then
505: p_rec.attribute17 :=
506: per_psh_shd.g_old_rec.attribute17;
507: End If;
508: If (p_rec.attribute18 = hr_api.g_varchar2) then
509: p_rec.attribute18 :=
510: per_psh_shd.g_old_rec.attribute18;
506: per_psh_shd.g_old_rec.attribute17;
507: End If;
508: If (p_rec.attribute18 = hr_api.g_varchar2) then
509: p_rec.attribute18 :=
510: per_psh_shd.g_old_rec.attribute18;
511: End If;
512: If (p_rec.attribute19 = hr_api.g_varchar2) then
513: p_rec.attribute19 :=
514: per_psh_shd.g_old_rec.attribute19;
510: per_psh_shd.g_old_rec.attribute18;
511: End If;
512: If (p_rec.attribute19 = hr_api.g_varchar2) then
513: p_rec.attribute19 :=
514: per_psh_shd.g_old_rec.attribute19;
515: End If;
516: If (p_rec.attribute20 = hr_api.g_varchar2) then
517: p_rec.attribute20 :=
518: per_psh_shd.g_old_rec.attribute20;
514: per_psh_shd.g_old_rec.attribute19;
515: End If;
516: If (p_rec.attribute20 = hr_api.g_varchar2) then
517: p_rec.attribute20 :=
518: per_psh_shd.g_old_rec.attribute20;
519: End If;
520: If (p_rec.attribute21 = hr_api.g_varchar2) then
521: p_rec.attribute21 :=
522: per_psh_shd.g_old_rec.attribute21;
518: per_psh_shd.g_old_rec.attribute20;
519: End If;
520: If (p_rec.attribute21 = hr_api.g_varchar2) then
521: p_rec.attribute21 :=
522: per_psh_shd.g_old_rec.attribute21;
523: End If;
524: If (p_rec.attribute22 = hr_api.g_varchar2) then
525: p_rec.attribute22 :=
526: per_psh_shd.g_old_rec.attribute22;
522: per_psh_shd.g_old_rec.attribute21;
523: End If;
524: If (p_rec.attribute22 = hr_api.g_varchar2) then
525: p_rec.attribute22 :=
526: per_psh_shd.g_old_rec.attribute22;
527: End If;
528: If (p_rec.attribute23 = hr_api.g_varchar2) then
529: p_rec.attribute23 :=
530: per_psh_shd.g_old_rec.attribute23;
526: per_psh_shd.g_old_rec.attribute22;
527: End If;
528: If (p_rec.attribute23 = hr_api.g_varchar2) then
529: p_rec.attribute23 :=
530: per_psh_shd.g_old_rec.attribute23;
531: End If;
532: If (p_rec.attribute24 = hr_api.g_varchar2) then
533: p_rec.attribute24 :=
534: per_psh_shd.g_old_rec.attribute24;
530: per_psh_shd.g_old_rec.attribute23;
531: End If;
532: If (p_rec.attribute24 = hr_api.g_varchar2) then
533: p_rec.attribute24 :=
534: per_psh_shd.g_old_rec.attribute24;
535: End If;
536: If (p_rec.attribute25 = hr_api.g_varchar2) then
537: p_rec.attribute25 :=
538: per_psh_shd.g_old_rec.attribute25;
534: per_psh_shd.g_old_rec.attribute24;
535: End If;
536: If (p_rec.attribute25 = hr_api.g_varchar2) then
537: p_rec.attribute25 :=
538: per_psh_shd.g_old_rec.attribute25;
539: End If;
540: If (p_rec.attribute26 = hr_api.g_varchar2) then
541: p_rec.attribute26 :=
542: per_psh_shd.g_old_rec.attribute26;
538: per_psh_shd.g_old_rec.attribute25;
539: End If;
540: If (p_rec.attribute26 = hr_api.g_varchar2) then
541: p_rec.attribute26 :=
542: per_psh_shd.g_old_rec.attribute26;
543: End If;
544: If (p_rec.attribute27 = hr_api.g_varchar2) then
545: p_rec.attribute27 :=
546: per_psh_shd.g_old_rec.attribute27;
542: per_psh_shd.g_old_rec.attribute26;
543: End If;
544: If (p_rec.attribute27 = hr_api.g_varchar2) then
545: p_rec.attribute27 :=
546: per_psh_shd.g_old_rec.attribute27;
547: End If;
548: If (p_rec.attribute28 = hr_api.g_varchar2) then
549: p_rec.attribute28 :=
550: per_psh_shd.g_old_rec.attribute28;
546: per_psh_shd.g_old_rec.attribute27;
547: End If;
548: If (p_rec.attribute28 = hr_api.g_varchar2) then
549: p_rec.attribute28 :=
550: per_psh_shd.g_old_rec.attribute28;
551: End If;
552: If (p_rec.attribute29 = hr_api.g_varchar2) then
553: p_rec.attribute29 :=
554: per_psh_shd.g_old_rec.attribute29;
550: per_psh_shd.g_old_rec.attribute28;
551: End If;
552: If (p_rec.attribute29 = hr_api.g_varchar2) then
553: p_rec.attribute29 :=
554: per_psh_shd.g_old_rec.attribute29;
555: End If;
556: If (p_rec.attribute30 = hr_api.g_varchar2) then
557: p_rec.attribute30 :=
558: per_psh_shd.g_old_rec.attribute30;
554: per_psh_shd.g_old_rec.attribute29;
555: End If;
556: If (p_rec.attribute30 = hr_api.g_varchar2) then
557: p_rec.attribute30 :=
558: per_psh_shd.g_old_rec.attribute30;
559: End If;
560: --
561: End convert_defs;
562: --
563: -- ----------------------------------------------------------------------------
564: -- |---------------------------------< upd >----------------------------------|
565: -- ----------------------------------------------------------------------------
566: Procedure upd
567: (p_rec in out nocopy per_psh_shd.g_rec_type
568: ) is
569: --
570: l_proc varchar2(72) := g_package||'upd';
571: --
573: hr_utility.set_location('Entering:'||l_proc, 5);
574: --
575: -- We must lock the row which we need to update.
576: --
577: per_psh_shd.lck
578: (p_rec.sharing_instance_id
579: ,p_rec.object_version_number
580: );
581: --
651: ,p_attribute29 in varchar2 default hr_api.g_varchar2
652: ,p_attribute30 in varchar2 default hr_api.g_varchar2
653: ) is
654: --
655: l_rec per_psh_shd.g_rec_type;
656: l_proc varchar2(72) := g_package||'upd';
657: --
658: Begin
659: hr_utility.set_location('Entering:'||l_proc, 5);
661: -- Call conversion function to turn arguments into the
662: -- l_rec structure.
663: --
664: l_rec :=
665: per_psh_shd.convert_args
666: (p_sharing_instance_id
667: ,p_object_version_number
668: ,p_scorecard_id
669: ,p_person_id