[Home] [Help]
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin
59: hr_utility.set_location('Entering:'||l_proc, 5);
60: --
61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
67: -- Bug 3213714
68: -- Restricting size of the name column
69: p_rec.name := substr(p_rec.name,1,700);
70:
71: hr_utility.set_location('Entering:'||l_proc, 6);
72: --
73: -- Update the per_jobs Row
74: --
75: update per_jobs
134: object_version_number = p_rec.object_version_number
135: where job_id = p_rec.job_id;
136:
137: --
138: hr_utility.set_location('Entering:'||l_proc, 7);
139: --
140: per_job_shd.g_api_dml := false; -- Unset the api dml status
141: --
142: hr_utility.set_location(' Leaving:'||l_proc, 10);
138: hr_utility.set_location('Entering:'||l_proc, 7);
139: --
140: per_job_shd.g_api_dml := false; -- Unset the api dml status
141: --
142: hr_utility.set_location(' Leaving:'||l_proc, 10);
143: --
144: Exception
145: When hr_api.check_integrity_violated Then
146: -- A check constraint has been violated
143: --
144: Exception
145: When hr_api.check_integrity_violated Then
146: -- A check constraint has been violated
147: hr_utility.set_location('Entering:'||l_proc, 20);
148: per_job_shd.g_api_dml := false; -- Unset the api dml status
149: per_job_shd.constraint_error
150: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
151: When hr_api.parent_integrity_violated Then
148: per_job_shd.g_api_dml := false; -- Unset the api dml status
149: per_job_shd.constraint_error
150: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
151: When hr_api.parent_integrity_violated Then
152: hr_utility.set_location('Entering:'||l_proc, 21);
153: -- Parent integrity has been violated
154: per_job_shd.g_api_dml := false; -- Unset the api dml status
155: per_job_shd.constraint_error
156: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: per_job_shd.g_api_dml := false; -- Unset the api dml status
155: per_job_shd.constraint_error
156: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
157: When hr_api.unique_integrity_violated Then
158: hr_utility.set_location('Entering:'||l_proc, 22);
159: -- Unique integrity has been violated
160: per_job_shd.g_api_dml := false; -- Unset the api dml status
161: per_job_shd.constraint_error
162: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
160: per_job_shd.g_api_dml := false; -- Unset the api dml status
161: per_job_shd.constraint_error
162: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
163: When Others Then
164: hr_utility.set_location('Entering:'||l_proc, 23);
165: per_job_shd.g_api_dml := false; -- Unset the api dml status
166: Raise;
167: End update_dml;
168: --
202: --
203: l_proc varchar2(72) := g_package||'pre_update';
204: --
205: Begin
206: hr_utility.set_location('Entering:'||l_proc, 5);
207: --
208: hr_utility.set_location(' Leaving:'||l_proc, 10);
209: End pre_update;
210: --
204: --
205: Begin
206: hr_utility.set_location('Entering:'||l_proc, 5);
207: --
208: hr_utility.set_location(' Leaving:'||l_proc, 10);
209: End pre_update;
210: --
211: -- ----------------------------------------------------------------------------
212: -- |-----------------------------< post_update >------------------------------|
244: --
245: l_proc varchar2(72) := g_package||'post_update';
246: --
247: Begin
248: hr_utility.set_location('Entering:'||l_proc, 5);
249: --
250: -- Start of API User Hook for post_update.
251: begin
252: per_job_rku.after_update
375: );
376: end;
377: -- End of API User Hook for post_update.
378: --
379: hr_utility.set_location(' Leaving:'||l_proc, 10);
380: End post_update;
381: --
382: -- ----------------------------------------------------------------------------
383: -- |-----------------------------< convert_defs >-----------------------------|
428: l_proc varchar2(72) := g_package||'convert_defs';
429: --
430: Begin
431: --
432: hr_utility.set_location('Entering:'||l_proc, 5);
433: --
434: -- We must now examine each argument value in the
435: -- p_rec plsql record structure
436: -- to see if a system default is being used. If a system default
439: If (p_rec.business_group_id = hr_api.g_number) then
440: p_rec.business_group_id :=
441: per_job_shd.g_old_rec.business_group_id;
442: End If;
443: hr_utility.set_location('Entering:'||p_rec.job_definition_id, 6);
444: If (p_rec.job_definition_id = hr_api.g_number) then
445: p_rec.job_definition_id :=
446: per_job_shd.g_old_rec.job_definition_id;
447: End If;
444: If (p_rec.job_definition_id = hr_api.g_number) then
445: p_rec.job_definition_id :=
446: per_job_shd.g_old_rec.job_definition_id;
447: End If;
448: hr_utility.set_location('Entering:'||l_proc, 7);
449: If (p_rec.date_from = hr_api.g_date) then
450: p_rec.date_from :=
451: per_job_shd.g_old_rec.date_from;
452: End If;
449: If (p_rec.date_from = hr_api.g_date) then
450: p_rec.date_from :=
451: per_job_shd.g_old_rec.date_from;
452: End If;
453: hr_utility.set_location('Entering:'||l_proc, 8);
454: If (p_rec.comments = hr_api.g_varchar2) then
455: p_rec.comments :=
456: per_job_shd.g_old_rec.comments;
457: End If;
454: If (p_rec.comments = hr_api.g_varchar2) then
455: p_rec.comments :=
456: per_job_shd.g_old_rec.comments;
457: End If;
458: hr_utility.set_location('Entering:'||l_proc, 9);
459: If (p_rec.date_to = hr_api.g_date) then
460: p_rec.date_to :=
461: per_job_shd.g_old_rec.date_to;
462: End If;
459: If (p_rec.date_to = hr_api.g_date) then
460: p_rec.date_to :=
461: per_job_shd.g_old_rec.date_to;
462: End If;
463: hr_utility.set_location('Entering:'||p_rec.approval_authority, 10);
464: If (p_rec.approval_authority = hr_api.g_number) then
465: p_rec.approval_authority :=
466: per_job_shd.g_old_rec.approval_authority;
467: End If;
464: If (p_rec.approval_authority = hr_api.g_number) then
465: p_rec.approval_authority :=
466: per_job_shd.g_old_rec.approval_authority;
467: End If;
468: hr_utility.set_location('Entering:'||l_proc, 11);
469: If (p_rec.name = hr_api.g_varchar2) then
470: p_rec.name :=
471: per_job_shd.g_old_rec.name;
472: End If;
469: If (p_rec.name = hr_api.g_varchar2) then
470: p_rec.name :=
471: per_job_shd.g_old_rec.name;
472: End If;
473: hr_utility.set_location('Entering:'||p_rec.request_id , 12);
474: If (p_rec.request_id = hr_api.g_number) then
475: p_rec.request_id :=
476: per_job_shd.g_old_rec.request_id;
477: End If;
474: If (p_rec.request_id = hr_api.g_number) then
475: p_rec.request_id :=
476: per_job_shd.g_old_rec.request_id;
477: End If;
478: hr_utility.set_location('Entering:'||l_proc, 14);
479: If (p_rec.program_application_id = hr_api.g_number) then
480: p_rec.program_application_id :=
481: per_job_shd.g_old_rec.program_application_id;
482: End If;
479: If (p_rec.program_application_id = hr_api.g_number) then
480: p_rec.program_application_id :=
481: per_job_shd.g_old_rec.program_application_id;
482: End If;
483: hr_utility.set_location('Entering:'||l_proc, 15);
484: If (p_rec.program_id = hr_api.g_number) then
485: p_rec.program_id :=
486: per_job_shd.g_old_rec.program_id;
487: End If;
484: If (p_rec.program_id = hr_api.g_number) then
485: p_rec.program_id :=
486: per_job_shd.g_old_rec.program_id;
487: End If;
488: hr_utility.set_location('Entering:'||l_proc, 16);
489: If (p_rec.program_update_date = hr_api.g_date) then
490: p_rec.program_update_date :=
491: per_job_shd.g_old_rec.program_update_date;
492: End If;
489: If (p_rec.program_update_date = hr_api.g_date) then
490: p_rec.program_update_date :=
491: per_job_shd.g_old_rec.program_update_date;
492: End If;
493: hr_utility.set_location('Entering:'||l_proc, 17);
494: If (p_rec.attribute_category = hr_api.g_varchar2) then
495: p_rec.attribute_category :=
496: per_job_shd.g_old_rec.attribute_category;
497: End If;
494: If (p_rec.attribute_category = hr_api.g_varchar2) then
495: p_rec.attribute_category :=
496: per_job_shd.g_old_rec.attribute_category;
497: End If;
498: hr_utility.set_location('Entering:'||l_proc, 18);
499: If (p_rec.attribute1 = hr_api.g_varchar2) then
500: p_rec.attribute1 :=
501: per_job_shd.g_old_rec.attribute1;
502: End If;
499: If (p_rec.attribute1 = hr_api.g_varchar2) then
500: p_rec.attribute1 :=
501: per_job_shd.g_old_rec.attribute1;
502: End If;
503: hr_utility.set_location('Entering:'||l_proc, 19);
504: If (p_rec.attribute2 = hr_api.g_varchar2) then
505: p_rec.attribute2 :=
506: per_job_shd.g_old_rec.attribute2;
507: End If;
504: If (p_rec.attribute2 = hr_api.g_varchar2) then
505: p_rec.attribute2 :=
506: per_job_shd.g_old_rec.attribute2;
507: End If;
508: hr_utility.set_location('Entering:'||l_proc, 20);
509: If (p_rec.attribute3 = hr_api.g_varchar2) then
510: p_rec.attribute3 :=
511: per_job_shd.g_old_rec.attribute3;
512: End If;
509: If (p_rec.attribute3 = hr_api.g_varchar2) then
510: p_rec.attribute3 :=
511: per_job_shd.g_old_rec.attribute3;
512: End If;
513: hr_utility.set_location('Entering:'||l_proc, 21);
514: If (p_rec.attribute4 = hr_api.g_varchar2) then
515: p_rec.attribute4 :=
516: per_job_shd.g_old_rec.attribute4;
517: End If;
514: If (p_rec.attribute4 = hr_api.g_varchar2) then
515: p_rec.attribute4 :=
516: per_job_shd.g_old_rec.attribute4;
517: End If;
518: hr_utility.set_location('Entering:'||l_proc, 22);
519: If (p_rec.attribute5 = hr_api.g_varchar2) then
520: p_rec.attribute5 :=
521: per_job_shd.g_old_rec.attribute5;
522: End If;
519: If (p_rec.attribute5 = hr_api.g_varchar2) then
520: p_rec.attribute5 :=
521: per_job_shd.g_old_rec.attribute5;
522: End If;
523: hr_utility.set_location('Entering:'||l_proc, 23);
524: If (p_rec.attribute6 = hr_api.g_varchar2) then
525: p_rec.attribute6 :=
526: per_job_shd.g_old_rec.attribute6;
527: End If;
524: If (p_rec.attribute6 = hr_api.g_varchar2) then
525: p_rec.attribute6 :=
526: per_job_shd.g_old_rec.attribute6;
527: End If;
528: hr_utility.set_location('Entering:'||l_proc, 24);
529: If (p_rec.attribute7 = hr_api.g_varchar2) then
530: p_rec.attribute7 :=
531: per_job_shd.g_old_rec.attribute7;
532: End If;
529: If (p_rec.attribute7 = hr_api.g_varchar2) then
530: p_rec.attribute7 :=
531: per_job_shd.g_old_rec.attribute7;
532: End If;
533: hr_utility.set_location('Entering:'||l_proc, 25);
534: If (p_rec.attribute8 = hr_api.g_varchar2) then
535: p_rec.attribute8 :=
536: per_job_shd.g_old_rec.attribute8;
537: End If;
534: If (p_rec.attribute8 = hr_api.g_varchar2) then
535: p_rec.attribute8 :=
536: per_job_shd.g_old_rec.attribute8;
537: End If;
538: hr_utility.set_location('Entering:'||l_proc, 26);
539: If (p_rec.attribute9 = hr_api.g_varchar2) then
540: p_rec.attribute9 :=
541: per_job_shd.g_old_rec.attribute9;
542: End If;
539: If (p_rec.attribute9 = hr_api.g_varchar2) then
540: p_rec.attribute9 :=
541: per_job_shd.g_old_rec.attribute9;
542: End If;
543: hr_utility.set_location('Entering:'||l_proc, 27);
544: If (p_rec.attribute10 = hr_api.g_varchar2) then
545: p_rec.attribute10 :=
546: per_job_shd.g_old_rec.attribute10;
547: End If;
544: If (p_rec.attribute10 = hr_api.g_varchar2) then
545: p_rec.attribute10 :=
546: per_job_shd.g_old_rec.attribute10;
547: End If;
548: hr_utility.set_location('Entering:'||l_proc, 28);
549: If (p_rec.attribute11 = hr_api.g_varchar2) then
550: p_rec.attribute11 :=
551: per_job_shd.g_old_rec.attribute11;
552: End If;
549: If (p_rec.attribute11 = hr_api.g_varchar2) then
550: p_rec.attribute11 :=
551: per_job_shd.g_old_rec.attribute11;
552: End If;
553: hr_utility.set_location('Entering:'||l_proc, 29);
554: If (p_rec.attribute12 = hr_api.g_varchar2) then
555: p_rec.attribute12 :=
556: per_job_shd.g_old_rec.attribute12;
557: End If;
554: If (p_rec.attribute12 = hr_api.g_varchar2) then
555: p_rec.attribute12 :=
556: per_job_shd.g_old_rec.attribute12;
557: End If;
558: hr_utility.set_location('Entering:'||l_proc, 30);
559: If (p_rec.attribute13 = hr_api.g_varchar2) then
560: p_rec.attribute13 :=
561: per_job_shd.g_old_rec.attribute13;
562: End If;
559: If (p_rec.attribute13 = hr_api.g_varchar2) then
560: p_rec.attribute13 :=
561: per_job_shd.g_old_rec.attribute13;
562: End If;
563: hr_utility.set_location('Entering:'||l_proc, 31);
564: If (p_rec.attribute14 = hr_api.g_varchar2) then
565: p_rec.attribute14 :=
566: per_job_shd.g_old_rec.attribute14;
567: End If;
564: If (p_rec.attribute14 = hr_api.g_varchar2) then
565: p_rec.attribute14 :=
566: per_job_shd.g_old_rec.attribute14;
567: End If;
568: hr_utility.set_location('Entering:'||l_proc, 32);
569: If (p_rec.attribute15 = hr_api.g_varchar2) then
570: p_rec.attribute15 :=
571: per_job_shd.g_old_rec.attribute15;
572: End If;
569: If (p_rec.attribute15 = hr_api.g_varchar2) then
570: p_rec.attribute15 :=
571: per_job_shd.g_old_rec.attribute15;
572: End If;
573: hr_utility.set_location('Entering:'||l_proc, 33);
574: If (p_rec.attribute16 = hr_api.g_varchar2) then
575: p_rec.attribute16 :=
576: per_job_shd.g_old_rec.attribute16;
577: End If;
574: If (p_rec.attribute16 = hr_api.g_varchar2) then
575: p_rec.attribute16 :=
576: per_job_shd.g_old_rec.attribute16;
577: End If;
578: hr_utility.set_location('Entering:'||l_proc, 34);
579: If (p_rec.attribute17 = hr_api.g_varchar2) then
580: p_rec.attribute17 :=
581: per_job_shd.g_old_rec.attribute17;
582: End If;
579: If (p_rec.attribute17 = hr_api.g_varchar2) then
580: p_rec.attribute17 :=
581: per_job_shd.g_old_rec.attribute17;
582: End If;
583: hr_utility.set_location('Entering:'||l_proc, 35);
584: If (p_rec.attribute18 = hr_api.g_varchar2) then
585: p_rec.attribute18 :=
586: per_job_shd.g_old_rec.attribute18;
587: End If;
584: If (p_rec.attribute18 = hr_api.g_varchar2) then
585: p_rec.attribute18 :=
586: per_job_shd.g_old_rec.attribute18;
587: End If;
588: hr_utility.set_location('Entering:'||l_proc, 36);
589: If (p_rec.attribute19 = hr_api.g_varchar2) then
590: p_rec.attribute19 :=
591: per_job_shd.g_old_rec.attribute19;
592: End If;
589: If (p_rec.attribute19 = hr_api.g_varchar2) then
590: p_rec.attribute19 :=
591: per_job_shd.g_old_rec.attribute19;
592: End If;
593: hr_utility.set_location('Entering:'||l_proc, 37);
594: If (p_rec.attribute20 = hr_api.g_varchar2) then
595: p_rec.attribute20 :=
596: per_job_shd.g_old_rec.attribute20;
597: End If;
594: If (p_rec.attribute20 = hr_api.g_varchar2) then
595: p_rec.attribute20 :=
596: per_job_shd.g_old_rec.attribute20;
597: End If;
598: hr_utility.set_location('Entering:'||l_proc, 38);
599: If (p_rec.job_information_category = hr_api.g_varchar2) then
600: p_rec.job_information_category :=
601: per_job_shd.g_old_rec.job_information_category;
602: End If;
599: If (p_rec.job_information_category = hr_api.g_varchar2) then
600: p_rec.job_information_category :=
601: per_job_shd.g_old_rec.job_information_category;
602: End If;
603: hr_utility.set_location('Entering:'||l_proc, 39);
604: If (p_rec.job_information1= hr_api.g_varchar2) then
605: p_rec.job_information1 :=
606: per_job_shd.g_old_rec.job_information1;
607: End If;
604: If (p_rec.job_information1= hr_api.g_varchar2) then
605: p_rec.job_information1 :=
606: per_job_shd.g_old_rec.job_information1;
607: End If;
608: hr_utility.set_location('Entering:'||l_proc, 40);
609: If (p_rec.job_information2= hr_api.g_varchar2) then
610: p_rec.job_information2 :=
611: per_job_shd.g_old_rec.job_information2;
612: End If;
609: If (p_rec.job_information2= hr_api.g_varchar2) then
610: p_rec.job_information2 :=
611: per_job_shd.g_old_rec.job_information2;
612: End If;
613: hr_utility.set_location('Entering:'||l_proc, 41);
614: If (p_rec.job_information3= hr_api.g_varchar2) then
615: p_rec.job_information3 :=
616: per_job_shd.g_old_rec.job_information3;
617: End If;
614: If (p_rec.job_information3= hr_api.g_varchar2) then
615: p_rec.job_information3 :=
616: per_job_shd.g_old_rec.job_information3;
617: End If;
618: hr_utility.set_location('Entering:'||l_proc, 42);
619: If (p_rec.job_information4= hr_api.g_varchar2) then
620: p_rec.job_information4 :=
621: per_job_shd.g_old_rec.job_information4;
622: End If;
619: If (p_rec.job_information4= hr_api.g_varchar2) then
620: p_rec.job_information4 :=
621: per_job_shd.g_old_rec.job_information4;
622: End If;
623: hr_utility.set_location('Entering:'||l_proc, 43);
624: If (p_rec.job_information5= hr_api.g_varchar2) then
625: p_rec.job_information5 :=
626: per_job_shd.g_old_rec.job_information5;
627: End If;
624: If (p_rec.job_information5= hr_api.g_varchar2) then
625: p_rec.job_information5 :=
626: per_job_shd.g_old_rec.job_information5;
627: End If;
628: hr_utility.set_location('Entering:'||l_proc, 44);
629: If (p_rec.job_information6= hr_api.g_varchar2) then
630: p_rec.job_information6 :=
631: per_job_shd.g_old_rec.job_information6;
632: End If;
629: If (p_rec.job_information6= hr_api.g_varchar2) then
630: p_rec.job_information6 :=
631: per_job_shd.g_old_rec.job_information6;
632: End If;
633: hr_utility.set_location('Entering:'||l_proc, 45);
634: If (p_rec.job_information7= hr_api.g_varchar2) then
635: p_rec.job_information7 :=
636: per_job_shd.g_old_rec.job_information7;
637: End If;
634: If (p_rec.job_information7= hr_api.g_varchar2) then
635: p_rec.job_information7 :=
636: per_job_shd.g_old_rec.job_information7;
637: End If;
638: hr_utility.set_location('Entering:'||l_proc, 46);
639: If (p_rec.job_information8= hr_api.g_varchar2) then
640: p_rec.job_information8 :=
641: per_job_shd.g_old_rec.job_information8;
642: End If;
639: If (p_rec.job_information8= hr_api.g_varchar2) then
640: p_rec.job_information8 :=
641: per_job_shd.g_old_rec.job_information8;
642: End If;
643: hr_utility.set_location('Entering:'||l_proc, 47);
644: If (p_rec.job_information9= hr_api.g_varchar2) then
645: p_rec.job_information9 :=
646: per_job_shd.g_old_rec.job_information9;
647: End If;
644: If (p_rec.job_information9= hr_api.g_varchar2) then
645: p_rec.job_information9 :=
646: per_job_shd.g_old_rec.job_information9;
647: End If;
648: hr_utility.set_location('Entering:'||l_proc, 48);
649: If (p_rec.job_information10= hr_api.g_varchar2) then
650: p_rec.job_information10 :=
651: per_job_shd.g_old_rec.job_information10;
652: End If;
649: If (p_rec.job_information10= hr_api.g_varchar2) then
650: p_rec.job_information10 :=
651: per_job_shd.g_old_rec.job_information10;
652: End If;
653: hr_utility.set_location('Entering:'||l_proc, 49);
654: If (p_rec.job_information11= hr_api.g_varchar2) then
655: p_rec.job_information11:=
656: per_job_shd.g_old_rec.job_information11;
657: End If;
654: If (p_rec.job_information11= hr_api.g_varchar2) then
655: p_rec.job_information11:=
656: per_job_shd.g_old_rec.job_information11;
657: End If;
658: hr_utility.set_location('Entering:'||l_proc, 50);
659: If (p_rec.job_information12= hr_api.g_varchar2) then
660: p_rec.job_information12 :=
661: per_job_shd.g_old_rec.job_information12;
662: End If;
659: If (p_rec.job_information12= hr_api.g_varchar2) then
660: p_rec.job_information12 :=
661: per_job_shd.g_old_rec.job_information12;
662: End If;
663: hr_utility.set_location('Entering:'||l_proc, 51);
664: If (p_rec.job_information13= hr_api.g_varchar2) then
665: p_rec.job_information13 :=
666: per_job_shd.g_old_rec.job_information13;
667: End If;
664: If (p_rec.job_information13= hr_api.g_varchar2) then
665: p_rec.job_information13 :=
666: per_job_shd.g_old_rec.job_information13;
667: End If;
668: hr_utility.set_location('Entering:'||l_proc, 52);
669: If (p_rec.job_information14= hr_api.g_varchar2) then
670: p_rec.job_information14 :=
671: per_job_shd.g_old_rec.job_information14;
672: End If;
669: If (p_rec.job_information14= hr_api.g_varchar2) then
670: p_rec.job_information14 :=
671: per_job_shd.g_old_rec.job_information14;
672: End If;
673: hr_utility.set_location('Entering:'||l_proc, 53);
674: If (p_rec.job_information15= hr_api.g_varchar2) then
675: p_rec.job_information15 :=
676: per_job_shd.g_old_rec.job_information15;
677: End If;
674: If (p_rec.job_information15= hr_api.g_varchar2) then
675: p_rec.job_information15 :=
676: per_job_shd.g_old_rec.job_information15;
677: End If;
678: hr_utility.set_location('Entering:'||l_proc, 54);
679: If (p_rec.job_information16= hr_api.g_varchar2) then
680: p_rec.job_information16 :=
681: per_job_shd.g_old_rec.job_information16;
682: End If;
679: If (p_rec.job_information16= hr_api.g_varchar2) then
680: p_rec.job_information16 :=
681: per_job_shd.g_old_rec.job_information16;
682: End If;
683: hr_utility.set_location('Entering:'||l_proc, 55);
684: If (p_rec.job_information17= hr_api.g_varchar2) then
685: p_rec.job_information17 :=
686: per_job_shd.g_old_rec.job_information17;
687: End If;
684: If (p_rec.job_information17= hr_api.g_varchar2) then
685: p_rec.job_information17 :=
686: per_job_shd.g_old_rec.job_information17;
687: End If;
688: hr_utility.set_location('Entering:'||l_proc, 56);
689: If (p_rec.job_information18= hr_api.g_varchar2) then
690: p_rec.job_information18 :=
691: per_job_shd.g_old_rec.job_information18;
692: End If;
689: If (p_rec.job_information18= hr_api.g_varchar2) then
690: p_rec.job_information18 :=
691: per_job_shd.g_old_rec.job_information18;
692: End If;
693: hr_utility.set_location('Entering:'||l_proc, 57);
694: If (p_rec.job_information19= hr_api.g_varchar2) then
695: p_rec.job_information19 :=
696: per_job_shd.g_old_rec.job_information19;
697: End If;
694: If (p_rec.job_information19= hr_api.g_varchar2) then
695: p_rec.job_information19 :=
696: per_job_shd.g_old_rec.job_information19;
697: End If;
698: hr_utility.set_location('Entering:'||l_proc, 58);
699: If (p_rec.job_information20= hr_api.g_varchar2) then
700: p_rec.job_information20 :=
701: per_job_shd.g_old_rec.job_information20;
702: End If;
699: If (p_rec.job_information20= hr_api.g_varchar2) then
700: p_rec.job_information20 :=
701: per_job_shd.g_old_rec.job_information20;
702: End If;
703: hr_utility.set_location('Entering:'||l_proc, 59);
704: If (p_rec.benchmark_job_flag = hr_api.g_varchar2) then
705: p_rec.benchmark_job_flag :=
706: per_job_shd.g_old_rec.benchmark_job_flag;
707: End If;
704: If (p_rec.benchmark_job_flag = hr_api.g_varchar2) then
705: p_rec.benchmark_job_flag :=
706: per_job_shd.g_old_rec.benchmark_job_flag;
707: End If;
708: hr_utility.set_location('Entering:'||p_rec.benchmark_job_id, 60);
709: If (p_rec.benchmark_job_id = hr_api.g_number) then
710: p_rec.benchmark_job_id :=
711: per_job_shd.g_old_rec.benchmark_job_id;
712: End If;
709: If (p_rec.benchmark_job_id = hr_api.g_number) then
710: p_rec.benchmark_job_id :=
711: per_job_shd.g_old_rec.benchmark_job_id;
712: End If;
713: hr_utility.set_location('Entering:'||l_proc, 61);
714: If (p_rec.emp_rights_flag = hr_api.g_varchar2) then
715: p_rec.emp_rights_flag :=
716: per_job_shd.g_old_rec.emp_rights_flag;
717: End If;
714: If (p_rec.emp_rights_flag = hr_api.g_varchar2) then
715: p_rec.emp_rights_flag :=
716: per_job_shd.g_old_rec.emp_rights_flag;
717: End If;
718: hr_utility.set_location('Entering:'||l_proc, 62);
719: If (p_rec.job_group_id = hr_api.g_number) then
720: p_rec.job_group_id :=
721: per_job_shd.g_old_rec.job_group_id;
722: End IF;
720: p_rec.job_group_id :=
721: per_job_shd.g_old_rec.job_group_id;
722: End IF;
723: --
724: hr_utility.set_location(' Leaving:'||l_proc, 10);
725: --
726: End convert_defs;
727: --
728: -- ----------------------------------------------------------------------------
736: --
737: l_proc varchar2(72) := g_package||'upd';
738: --
739: Begin
740: hr_utility.set_location('Entering:'||l_proc, 5);
741: --
742: -- Determine if the business process is to be validated.
743: --
744: If p_validate then
782: --
783: -- If we are validating then raise the Validate_Enabled exception
784: --
785: If p_validate then
786: hr_utility.set_location(' Leaving:'||l_proc, 9);
787: Raise HR_Api.Validate_Enabled;
788: End If;
789: --
790: hr_utility.set_location(' Leaving:'||l_proc, 10);
786: hr_utility.set_location(' Leaving:'||l_proc, 9);
787: Raise HR_Api.Validate_Enabled;
788: End If;
789: --
790: hr_utility.set_location(' Leaving:'||l_proc, 10);
791: Exception
792: When HR_Api.Validate_Enabled Then
793: hr_utility.set_location(' Leaving:'||l_proc, 20);
794: --
789: --
790: hr_utility.set_location(' Leaving:'||l_proc, 10);
791: Exception
792: When HR_Api.Validate_Enabled Then
793: hr_utility.set_location(' Leaving:'||l_proc, 20);
794: --
795: -- As the Validate_Enabled exception has been raised
796: -- we must rollback to the savepoint
797: --
867: l_rec per_job_shd.g_rec_type;
868: l_proc varchar2(72) := g_package||'upd';
869: --
870: Begin
871: hr_utility.set_location('Entering:'||l_proc, 5);
872: --
873: -- Call conversion function to turn arguments into the
874: -- l_rec structure.
875: --
943: --
944: upd(l_rec,p_validate);
945: p_object_version_number := l_rec.object_version_number;
946: --
947: hr_utility.set_location(' Leaving:' ||l_proc, 10);
948: End upd;
949: --
950: end per_job_upd;