51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy per_pju_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
130: Exception
131: When hr_api.check_integrity_violated Then
132: -- A check constraint has been violated
133: --
134: per_pju_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.parent_integrity_violated Then
137: -- Parent integrity has been violated
138: --
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.parent_integrity_violated Then
137: -- Parent integrity has been violated
138: --
139: per_pju_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When hr_api.unique_integrity_violated Then
142: -- Unique integrity has been violated
143: --
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When hr_api.unique_integrity_violated Then
142: -- Unique integrity has been violated
143: --
144: per_pju_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When Others Then
147: --
148: Raise;
180: --
181: -- {End Of Comments}
182: -- ----------------------------------------------------------------------------
183: Procedure pre_update
184: (p_rec in per_pju_shd.g_rec_type
185: ) is
186: --
187: l_proc varchar2(72) := g_package||'pre_update';
188: --
224: --
225: -- {End Of Comments}
226: -- ----------------------------------------------------------------------------
227: Procedure post_update
228: (p_rec in per_pju_shd.g_rec_type
229: ) is
230: --
231: l_proc varchar2(72) := g_package||'post_update';
232: --
397: --
398: -- {End Of Comments}
399: -- ----------------------------------------------------------------------------
400: Procedure convert_defs
401: (p_rec in out nocopy per_pju_shd.g_rec_type
402: ) is
403: --
404: Begin
405: --
409: -- is being used then we must set to the 'current' argument value.
410: --
411: If (p_rec.assignment_id = hr_api.g_number) then
412: p_rec.assignment_id :=
413: per_pju_shd.g_old_rec.assignment_id;
414: End If;
415: If (p_rec.previous_employer_id = hr_api.g_number) then
416: p_rec.previous_employer_id :=
417: per_pju_shd.g_old_rec.previous_employer_id;
413: per_pju_shd.g_old_rec.assignment_id;
414: End If;
415: If (p_rec.previous_employer_id = hr_api.g_number) then
416: p_rec.previous_employer_id :=
417: per_pju_shd.g_old_rec.previous_employer_id;
418: End If;
419: If (p_rec.previous_job_id = hr_api.g_number) then
420: p_rec.previous_job_id :=
421: per_pju_shd.g_old_rec.previous_job_id;
417: per_pju_shd.g_old_rec.previous_employer_id;
418: End If;
419: If (p_rec.previous_job_id = hr_api.g_number) then
420: p_rec.previous_job_id :=
421: per_pju_shd.g_old_rec.previous_job_id;
422: End If;
423: If (p_rec.start_date = hr_api.g_date) then
424: p_rec.start_date :=
425: per_pju_shd.g_old_rec.start_date;
421: per_pju_shd.g_old_rec.previous_job_id;
422: End If;
423: If (p_rec.start_date = hr_api.g_date) then
424: p_rec.start_date :=
425: per_pju_shd.g_old_rec.start_date;
426: End If;
427: If (p_rec.end_date = hr_api.g_date) then
428: p_rec.end_date :=
429: per_pju_shd.g_old_rec.end_date;
425: per_pju_shd.g_old_rec.start_date;
426: End If;
427: If (p_rec.end_date = hr_api.g_date) then
428: p_rec.end_date :=
429: per_pju_shd.g_old_rec.end_date;
430: End If;
431: If (p_rec.period_years = hr_api.g_number) then
432: p_rec.period_years :=
433: per_pju_shd.g_old_rec.period_years;
429: per_pju_shd.g_old_rec.end_date;
430: End If;
431: If (p_rec.period_years = hr_api.g_number) then
432: p_rec.period_years :=
433: per_pju_shd.g_old_rec.period_years;
434: End If;
435: If (p_rec.period_months = hr_api.g_number) then
436: p_rec.period_months :=
437: per_pju_shd.g_old_rec.period_months;
433: per_pju_shd.g_old_rec.period_years;
434: End If;
435: If (p_rec.period_months = hr_api.g_number) then
436: p_rec.period_months :=
437: per_pju_shd.g_old_rec.period_months;
438: End If;
439: If (p_rec.period_days = hr_api.g_number) then
440: p_rec.period_days :=
441: per_pju_shd.g_old_rec.period_days;
437: per_pju_shd.g_old_rec.period_months;
438: End If;
439: If (p_rec.period_days = hr_api.g_number) then
440: p_rec.period_days :=
441: per_pju_shd.g_old_rec.period_days;
442: End If;
443: If (p_rec.pju_attribute_category = hr_api.g_varchar2) then
444: p_rec.pju_attribute_category :=
445: per_pju_shd.g_old_rec.pju_attribute_category;
441: per_pju_shd.g_old_rec.period_days;
442: End If;
443: If (p_rec.pju_attribute_category = hr_api.g_varchar2) then
444: p_rec.pju_attribute_category :=
445: per_pju_shd.g_old_rec.pju_attribute_category;
446: End If;
447: If (p_rec.pju_attribute1 = hr_api.g_varchar2) then
448: p_rec.pju_attribute1 :=
449: per_pju_shd.g_old_rec.pju_attribute1;
445: per_pju_shd.g_old_rec.pju_attribute_category;
446: End If;
447: If (p_rec.pju_attribute1 = hr_api.g_varchar2) then
448: p_rec.pju_attribute1 :=
449: per_pju_shd.g_old_rec.pju_attribute1;
450: End If;
451: If (p_rec.pju_attribute2 = hr_api.g_varchar2) then
452: p_rec.pju_attribute2 :=
453: per_pju_shd.g_old_rec.pju_attribute2;
449: per_pju_shd.g_old_rec.pju_attribute1;
450: End If;
451: If (p_rec.pju_attribute2 = hr_api.g_varchar2) then
452: p_rec.pju_attribute2 :=
453: per_pju_shd.g_old_rec.pju_attribute2;
454: End If;
455: If (p_rec.pju_attribute3 = hr_api.g_varchar2) then
456: p_rec.pju_attribute3 :=
457: per_pju_shd.g_old_rec.pju_attribute3;
453: per_pju_shd.g_old_rec.pju_attribute2;
454: End If;
455: If (p_rec.pju_attribute3 = hr_api.g_varchar2) then
456: p_rec.pju_attribute3 :=
457: per_pju_shd.g_old_rec.pju_attribute3;
458: End If;
459: If (p_rec.pju_attribute4 = hr_api.g_varchar2) then
460: p_rec.pju_attribute4 :=
461: per_pju_shd.g_old_rec.pju_attribute4;
457: per_pju_shd.g_old_rec.pju_attribute3;
458: End If;
459: If (p_rec.pju_attribute4 = hr_api.g_varchar2) then
460: p_rec.pju_attribute4 :=
461: per_pju_shd.g_old_rec.pju_attribute4;
462: End If;
463: If (p_rec.pju_attribute5 = hr_api.g_varchar2) then
464: p_rec.pju_attribute5 :=
465: per_pju_shd.g_old_rec.pju_attribute5;
461: per_pju_shd.g_old_rec.pju_attribute4;
462: End If;
463: If (p_rec.pju_attribute5 = hr_api.g_varchar2) then
464: p_rec.pju_attribute5 :=
465: per_pju_shd.g_old_rec.pju_attribute5;
466: End If;
467: If (p_rec.pju_attribute6 = hr_api.g_varchar2) then
468: p_rec.pju_attribute6 :=
469: per_pju_shd.g_old_rec.pju_attribute6;
465: per_pju_shd.g_old_rec.pju_attribute5;
466: End If;
467: If (p_rec.pju_attribute6 = hr_api.g_varchar2) then
468: p_rec.pju_attribute6 :=
469: per_pju_shd.g_old_rec.pju_attribute6;
470: End If;
471: If (p_rec.pju_attribute7 = hr_api.g_varchar2) then
472: p_rec.pju_attribute7 :=
473: per_pju_shd.g_old_rec.pju_attribute7;
469: per_pju_shd.g_old_rec.pju_attribute6;
470: End If;
471: If (p_rec.pju_attribute7 = hr_api.g_varchar2) then
472: p_rec.pju_attribute7 :=
473: per_pju_shd.g_old_rec.pju_attribute7;
474: End If;
475: If (p_rec.pju_attribute8 = hr_api.g_varchar2) then
476: p_rec.pju_attribute8 :=
477: per_pju_shd.g_old_rec.pju_attribute8;
473: per_pju_shd.g_old_rec.pju_attribute7;
474: End If;
475: If (p_rec.pju_attribute8 = hr_api.g_varchar2) then
476: p_rec.pju_attribute8 :=
477: per_pju_shd.g_old_rec.pju_attribute8;
478: End If;
479: If (p_rec.pju_attribute9 = hr_api.g_varchar2) then
480: p_rec.pju_attribute9 :=
481: per_pju_shd.g_old_rec.pju_attribute9;
477: per_pju_shd.g_old_rec.pju_attribute8;
478: End If;
479: If (p_rec.pju_attribute9 = hr_api.g_varchar2) then
480: p_rec.pju_attribute9 :=
481: per_pju_shd.g_old_rec.pju_attribute9;
482: End If;
483: If (p_rec.pju_attribute10 = hr_api.g_varchar2) then
484: p_rec.pju_attribute10 :=
485: per_pju_shd.g_old_rec.pju_attribute10;
481: per_pju_shd.g_old_rec.pju_attribute9;
482: End If;
483: If (p_rec.pju_attribute10 = hr_api.g_varchar2) then
484: p_rec.pju_attribute10 :=
485: per_pju_shd.g_old_rec.pju_attribute10;
486: End If;
487: If (p_rec.pju_attribute11 = hr_api.g_varchar2) then
488: p_rec.pju_attribute11 :=
489: per_pju_shd.g_old_rec.pju_attribute11;
485: per_pju_shd.g_old_rec.pju_attribute10;
486: End If;
487: If (p_rec.pju_attribute11 = hr_api.g_varchar2) then
488: p_rec.pju_attribute11 :=
489: per_pju_shd.g_old_rec.pju_attribute11;
490: End If;
491: If (p_rec.pju_attribute12 = hr_api.g_varchar2) then
492: p_rec.pju_attribute12 :=
493: per_pju_shd.g_old_rec.pju_attribute12;
489: per_pju_shd.g_old_rec.pju_attribute11;
490: End If;
491: If (p_rec.pju_attribute12 = hr_api.g_varchar2) then
492: p_rec.pju_attribute12 :=
493: per_pju_shd.g_old_rec.pju_attribute12;
494: End If;
495: If (p_rec.pju_attribute13 = hr_api.g_varchar2) then
496: p_rec.pju_attribute13 :=
497: per_pju_shd.g_old_rec.pju_attribute13;
493: per_pju_shd.g_old_rec.pju_attribute12;
494: End If;
495: If (p_rec.pju_attribute13 = hr_api.g_varchar2) then
496: p_rec.pju_attribute13 :=
497: per_pju_shd.g_old_rec.pju_attribute13;
498: End If;
499: If (p_rec.pju_attribute14 = hr_api.g_varchar2) then
500: p_rec.pju_attribute14 :=
501: per_pju_shd.g_old_rec.pju_attribute14;
497: per_pju_shd.g_old_rec.pju_attribute13;
498: End If;
499: If (p_rec.pju_attribute14 = hr_api.g_varchar2) then
500: p_rec.pju_attribute14 :=
501: per_pju_shd.g_old_rec.pju_attribute14;
502: End If;
503: If (p_rec.pju_attribute15 = hr_api.g_varchar2) then
504: p_rec.pju_attribute15 :=
505: per_pju_shd.g_old_rec.pju_attribute15;
501: per_pju_shd.g_old_rec.pju_attribute14;
502: End If;
503: If (p_rec.pju_attribute15 = hr_api.g_varchar2) then
504: p_rec.pju_attribute15 :=
505: per_pju_shd.g_old_rec.pju_attribute15;
506: End If;
507: If (p_rec.pju_attribute16 = hr_api.g_varchar2) then
508: p_rec.pju_attribute16 :=
509: per_pju_shd.g_old_rec.pju_attribute16;
505: per_pju_shd.g_old_rec.pju_attribute15;
506: End If;
507: If (p_rec.pju_attribute16 = hr_api.g_varchar2) then
508: p_rec.pju_attribute16 :=
509: per_pju_shd.g_old_rec.pju_attribute16;
510: End If;
511: If (p_rec.pju_attribute17 = hr_api.g_varchar2) then
512: p_rec.pju_attribute17 :=
513: per_pju_shd.g_old_rec.pju_attribute17;
509: per_pju_shd.g_old_rec.pju_attribute16;
510: End If;
511: If (p_rec.pju_attribute17 = hr_api.g_varchar2) then
512: p_rec.pju_attribute17 :=
513: per_pju_shd.g_old_rec.pju_attribute17;
514: End If;
515: If (p_rec.pju_attribute18 = hr_api.g_varchar2) then
516: p_rec.pju_attribute18 :=
517: per_pju_shd.g_old_rec.pju_attribute18;
513: per_pju_shd.g_old_rec.pju_attribute17;
514: End If;
515: If (p_rec.pju_attribute18 = hr_api.g_varchar2) then
516: p_rec.pju_attribute18 :=
517: per_pju_shd.g_old_rec.pju_attribute18;
518: End If;
519: If (p_rec.pju_attribute19 = hr_api.g_varchar2) then
520: p_rec.pju_attribute19 :=
521: per_pju_shd.g_old_rec.pju_attribute19;
517: per_pju_shd.g_old_rec.pju_attribute18;
518: End If;
519: If (p_rec.pju_attribute19 = hr_api.g_varchar2) then
520: p_rec.pju_attribute19 :=
521: per_pju_shd.g_old_rec.pju_attribute19;
522: End If;
523: If (p_rec.pju_attribute20 = hr_api.g_varchar2) then
524: p_rec.pju_attribute20 :=
525: per_pju_shd.g_old_rec.pju_attribute20;
521: per_pju_shd.g_old_rec.pju_attribute19;
522: End If;
523: If (p_rec.pju_attribute20 = hr_api.g_varchar2) then
524: p_rec.pju_attribute20 :=
525: per_pju_shd.g_old_rec.pju_attribute20;
526: End If;
527: If (p_rec.pju_information_category = hr_api.g_varchar2) then
528: p_rec.pju_information_category :=
529: per_pju_shd.g_old_rec.pju_information_category;
525: per_pju_shd.g_old_rec.pju_attribute20;
526: End If;
527: If (p_rec.pju_information_category = hr_api.g_varchar2) then
528: p_rec.pju_information_category :=
529: per_pju_shd.g_old_rec.pju_information_category;
530: End If;
531: If (p_rec.pju_information1 = hr_api.g_varchar2) then
532: p_rec.pju_information1 :=
533: per_pju_shd.g_old_rec.pju_information1;
529: per_pju_shd.g_old_rec.pju_information_category;
530: End If;
531: If (p_rec.pju_information1 = hr_api.g_varchar2) then
532: p_rec.pju_information1 :=
533: per_pju_shd.g_old_rec.pju_information1;
534: End If;
535: If (p_rec.pju_information2 = hr_api.g_varchar2) then
536: p_rec.pju_information2 :=
537: per_pju_shd.g_old_rec.pju_information2;
533: per_pju_shd.g_old_rec.pju_information1;
534: End If;
535: If (p_rec.pju_information2 = hr_api.g_varchar2) then
536: p_rec.pju_information2 :=
537: per_pju_shd.g_old_rec.pju_information2;
538: End If;
539: If (p_rec.pju_information3 = hr_api.g_varchar2) then
540: p_rec.pju_information3 :=
541: per_pju_shd.g_old_rec.pju_information3;
537: per_pju_shd.g_old_rec.pju_information2;
538: End If;
539: If (p_rec.pju_information3 = hr_api.g_varchar2) then
540: p_rec.pju_information3 :=
541: per_pju_shd.g_old_rec.pju_information3;
542: End If;
543: If (p_rec.pju_information4 = hr_api.g_varchar2) then
544: p_rec.pju_information4 :=
545: per_pju_shd.g_old_rec.pju_information4;
541: per_pju_shd.g_old_rec.pju_information3;
542: End If;
543: If (p_rec.pju_information4 = hr_api.g_varchar2) then
544: p_rec.pju_information4 :=
545: per_pju_shd.g_old_rec.pju_information4;
546: End If;
547: If (p_rec.pju_information5 = hr_api.g_varchar2) then
548: p_rec.pju_information5 :=
549: per_pju_shd.g_old_rec.pju_information5;
545: per_pju_shd.g_old_rec.pju_information4;
546: End If;
547: If (p_rec.pju_information5 = hr_api.g_varchar2) then
548: p_rec.pju_information5 :=
549: per_pju_shd.g_old_rec.pju_information5;
550: End If;
551: If (p_rec.pju_information6 = hr_api.g_varchar2) then
552: p_rec.pju_information6 :=
553: per_pju_shd.g_old_rec.pju_information6;
549: per_pju_shd.g_old_rec.pju_information5;
550: End If;
551: If (p_rec.pju_information6 = hr_api.g_varchar2) then
552: p_rec.pju_information6 :=
553: per_pju_shd.g_old_rec.pju_information6;
554: End If;
555: If (p_rec.pju_information7 = hr_api.g_varchar2) then
556: p_rec.pju_information7 :=
557: per_pju_shd.g_old_rec.pju_information7;
553: per_pju_shd.g_old_rec.pju_information6;
554: End If;
555: If (p_rec.pju_information7 = hr_api.g_varchar2) then
556: p_rec.pju_information7 :=
557: per_pju_shd.g_old_rec.pju_information7;
558: End If;
559: If (p_rec.pju_information8 = hr_api.g_varchar2) then
560: p_rec.pju_information8 :=
561: per_pju_shd.g_old_rec.pju_information8;
557: per_pju_shd.g_old_rec.pju_information7;
558: End If;
559: If (p_rec.pju_information8 = hr_api.g_varchar2) then
560: p_rec.pju_information8 :=
561: per_pju_shd.g_old_rec.pju_information8;
562: End If;
563: If (p_rec.pju_information9 = hr_api.g_varchar2) then
564: p_rec.pju_information9 :=
565: per_pju_shd.g_old_rec.pju_information9;
561: per_pju_shd.g_old_rec.pju_information8;
562: End If;
563: If (p_rec.pju_information9 = hr_api.g_varchar2) then
564: p_rec.pju_information9 :=
565: per_pju_shd.g_old_rec.pju_information9;
566: End If;
567: If (p_rec.pju_information10 = hr_api.g_varchar2) then
568: p_rec.pju_information10 :=
569: per_pju_shd.g_old_rec.pju_information10;
565: per_pju_shd.g_old_rec.pju_information9;
566: End If;
567: If (p_rec.pju_information10 = hr_api.g_varchar2) then
568: p_rec.pju_information10 :=
569: per_pju_shd.g_old_rec.pju_information10;
570: End If;
571: If (p_rec.pju_information11 = hr_api.g_varchar2) then
572: p_rec.pju_information11 :=
573: per_pju_shd.g_old_rec.pju_information11;
569: per_pju_shd.g_old_rec.pju_information10;
570: End If;
571: If (p_rec.pju_information11 = hr_api.g_varchar2) then
572: p_rec.pju_information11 :=
573: per_pju_shd.g_old_rec.pju_information11;
574: End If;
575: If (p_rec.pju_information12 = hr_api.g_varchar2) then
576: p_rec.pju_information12 :=
577: per_pju_shd.g_old_rec.pju_information12;
573: per_pju_shd.g_old_rec.pju_information11;
574: End If;
575: If (p_rec.pju_information12 = hr_api.g_varchar2) then
576: p_rec.pju_information12 :=
577: per_pju_shd.g_old_rec.pju_information12;
578: End If;
579: If (p_rec.pju_information13 = hr_api.g_varchar2) then
580: p_rec.pju_information13 :=
581: per_pju_shd.g_old_rec.pju_information13;
577: per_pju_shd.g_old_rec.pju_information12;
578: End If;
579: If (p_rec.pju_information13 = hr_api.g_varchar2) then
580: p_rec.pju_information13 :=
581: per_pju_shd.g_old_rec.pju_information13;
582: End If;
583: If (p_rec.pju_information14 = hr_api.g_varchar2) then
584: p_rec.pju_information14 :=
585: per_pju_shd.g_old_rec.pju_information14;
581: per_pju_shd.g_old_rec.pju_information13;
582: End If;
583: If (p_rec.pju_information14 = hr_api.g_varchar2) then
584: p_rec.pju_information14 :=
585: per_pju_shd.g_old_rec.pju_information14;
586: End If;
587: If (p_rec.pju_information15 = hr_api.g_varchar2) then
588: p_rec.pju_information15 :=
589: per_pju_shd.g_old_rec.pju_information15;
585: per_pju_shd.g_old_rec.pju_information14;
586: End If;
587: If (p_rec.pju_information15 = hr_api.g_varchar2) then
588: p_rec.pju_information15 :=
589: per_pju_shd.g_old_rec.pju_information15;
590: End If;
591: If (p_rec.pju_information16 = hr_api.g_varchar2) then
592: p_rec.pju_information16 :=
593: per_pju_shd.g_old_rec.pju_information16;
589: per_pju_shd.g_old_rec.pju_information15;
590: End If;
591: If (p_rec.pju_information16 = hr_api.g_varchar2) then
592: p_rec.pju_information16 :=
593: per_pju_shd.g_old_rec.pju_information16;
594: End If;
595: If (p_rec.pju_information17 = hr_api.g_varchar2) then
596: p_rec.pju_information17 :=
597: per_pju_shd.g_old_rec.pju_information17;
593: per_pju_shd.g_old_rec.pju_information16;
594: End If;
595: If (p_rec.pju_information17 = hr_api.g_varchar2) then
596: p_rec.pju_information17 :=
597: per_pju_shd.g_old_rec.pju_information17;
598: End If;
599: If (p_rec.pju_information18 = hr_api.g_varchar2) then
600: p_rec.pju_information18 :=
601: per_pju_shd.g_old_rec.pju_information18;
597: per_pju_shd.g_old_rec.pju_information17;
598: End If;
599: If (p_rec.pju_information18 = hr_api.g_varchar2) then
600: p_rec.pju_information18 :=
601: per_pju_shd.g_old_rec.pju_information18;
602: End If;
603: If (p_rec.pju_information19 = hr_api.g_varchar2) then
604: p_rec.pju_information19 :=
605: per_pju_shd.g_old_rec.pju_information19;
601: per_pju_shd.g_old_rec.pju_information18;
602: End If;
603: If (p_rec.pju_information19 = hr_api.g_varchar2) then
604: p_rec.pju_information19 :=
605: per_pju_shd.g_old_rec.pju_information19;
606: End If;
607: If (p_rec.pju_information20 = hr_api.g_varchar2) then
608: p_rec.pju_information20 :=
609: per_pju_shd.g_old_rec.pju_information20;
605: per_pju_shd.g_old_rec.pju_information19;
606: End If;
607: If (p_rec.pju_information20 = hr_api.g_varchar2) then
608: p_rec.pju_information20 :=
609: per_pju_shd.g_old_rec.pju_information20;
610: End If;
611: --
612: End convert_defs;
613: --
614: -- ----------------------------------------------------------------------------
615: -- |---------------------------------< upd >----------------------------------|
616: -- ----------------------------------------------------------------------------
617: Procedure upd
618: (p_rec in out nocopy per_pju_shd.g_rec_type
619: ) is
620: --
621: l_proc varchar2(72) := g_package||'upd';
622: --
624: hr_utility.set_location('Entering:'||l_proc, 5);
625: --
626: -- We must lock the row which we need to update.
627: --
628: per_pju_shd.lck
629: (p_rec.previous_job_usage_id
630: ,p_rec.object_version_number
631: );
632: --
713: ,p_pju_information19 in varchar2 default hr_api.g_varchar2
714: ,p_pju_information20 in varchar2 default hr_api.g_varchar2
715: ) is
716: --
717: l_rec per_pju_shd.g_rec_type;
718: l_proc varchar2(72) := g_package||'upd';
719: --
720: Begin
721: hr_utility.set_location('Entering:'||l_proc, 5);
723: -- Call conversion function to turn arguments into the
724: -- l_rec structure.
725: --
726: l_rec :=
727: per_pju_shd.convert_args
728: (p_previous_job_usage_id
729: ,p_assignment_id
730: ,p_previous_employer_id
731: ,p_previous_job_id