DBA Data[Home] [Help]

APPS.PER_JOB_UPD dependencies on HR_API

Line 145: When hr_api.check_integrity_violated Then

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
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

Line 150: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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
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

Line 151: When hr_api.parent_integrity_violated Then

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
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

Line 156: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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));
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

Line 157: When hr_api.unique_integrity_violated Then

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));
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

Line 162: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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));
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;

Line 371: when hr_api.cannot_find_prog_unit then

367: p_job_group_id_o => per_job_shd.g_old_rec.job_group_id,
368: p_object_version_number_o => per_job_shd.g_old_rec.object_version_number
369: );
370: exception
371: when hr_api.cannot_find_prog_unit then
372: hr_api.cannot_find_prog_unit_error
373: (p_module_name => 'PER_JOBS'
374: ,p_hook_type => 'AU'
375: );

Line 372: hr_api.cannot_find_prog_unit_error

368: p_object_version_number_o => per_job_shd.g_old_rec.object_version_number
369: );
370: exception
371: when hr_api.cannot_find_prog_unit then
372: hr_api.cannot_find_prog_unit_error
373: (p_module_name => 'PER_JOBS'
374: ,p_hook_type => 'AU'
375: );
376: end;

Line 439: If (p_rec.business_group_id = hr_api.g_number) then

435: -- p_rec plsql record structure
436: -- to see if a system default is being used. If a system default
437: -- is being used then we must set to the 'current' argument value.
438: --
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);

Line 444: If (p_rec.job_definition_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;
448: hr_utility.set_location('Entering:'||l_proc, 7);

Line 449: If (p_rec.date_from = hr_api.g_date) 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;
453: hr_utility.set_location('Entering:'||l_proc, 8);

Line 454: If (p_rec.comments = hr_api.g_varchar2) 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;
458: hr_utility.set_location('Entering:'||l_proc, 9);

Line 459: If (p_rec.date_to = hr_api.g_date) 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;
463: hr_utility.set_location('Entering:'||p_rec.approval_authority, 10);

Line 464: If (p_rec.approval_authority = hr_api.g_number) 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;
468: hr_utility.set_location('Entering:'||l_proc, 11);

Line 469: If (p_rec.name = hr_api.g_varchar2) 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;
473: hr_utility.set_location('Entering:'||p_rec.request_id , 12);

Line 474: If (p_rec.request_id = hr_api.g_number) 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;
478: hr_utility.set_location('Entering:'||l_proc, 14);

Line 479: If (p_rec.program_application_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;
483: hr_utility.set_location('Entering:'||l_proc, 15);

Line 484: If (p_rec.program_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;
488: hr_utility.set_location('Entering:'||l_proc, 16);

Line 489: If (p_rec.program_update_date = hr_api.g_date) 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;
493: hr_utility.set_location('Entering:'||l_proc, 17);

Line 494: If (p_rec.attribute_category = hr_api.g_varchar2) 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;
498: hr_utility.set_location('Entering:'||l_proc, 18);

Line 499: If (p_rec.attribute1 = 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;
503: hr_utility.set_location('Entering:'||l_proc, 19);

Line 504: If (p_rec.attribute2 = 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;
508: hr_utility.set_location('Entering:'||l_proc, 20);

Line 509: If (p_rec.attribute3 = 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;
513: hr_utility.set_location('Entering:'||l_proc, 21);

Line 514: If (p_rec.attribute4 = 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;
518: hr_utility.set_location('Entering:'||l_proc, 22);

Line 519: If (p_rec.attribute5 = 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;
523: hr_utility.set_location('Entering:'||l_proc, 23);

Line 524: If (p_rec.attribute6 = 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;
528: hr_utility.set_location('Entering:'||l_proc, 24);

Line 529: If (p_rec.attribute7 = 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;
533: hr_utility.set_location('Entering:'||l_proc, 25);

Line 534: If (p_rec.attribute8 = 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;
538: hr_utility.set_location('Entering:'||l_proc, 26);

Line 539: If (p_rec.attribute9 = 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;
543: hr_utility.set_location('Entering:'||l_proc, 27);

Line 544: If (p_rec.attribute10 = 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;
548: hr_utility.set_location('Entering:'||l_proc, 28);

Line 549: If (p_rec.attribute11 = 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;
553: hr_utility.set_location('Entering:'||l_proc, 29);

Line 554: If (p_rec.attribute12 = 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;
558: hr_utility.set_location('Entering:'||l_proc, 30);

Line 559: If (p_rec.attribute13 = 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;
563: hr_utility.set_location('Entering:'||l_proc, 31);

Line 564: If (p_rec.attribute14 = 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;
568: hr_utility.set_location('Entering:'||l_proc, 32);

Line 569: If (p_rec.attribute15 = 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;
573: hr_utility.set_location('Entering:'||l_proc, 33);

Line 574: If (p_rec.attribute16 = 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;
578: hr_utility.set_location('Entering:'||l_proc, 34);

Line 579: If (p_rec.attribute17 = 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;
583: hr_utility.set_location('Entering:'||l_proc, 35);

Line 584: If (p_rec.attribute18 = 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;
588: hr_utility.set_location('Entering:'||l_proc, 36);

Line 589: If (p_rec.attribute19 = 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;
593: hr_utility.set_location('Entering:'||l_proc, 37);

Line 594: If (p_rec.attribute20 = 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;
598: hr_utility.set_location('Entering:'||l_proc, 38);

Line 599: If (p_rec.job_information_category = 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;
603: hr_utility.set_location('Entering:'||l_proc, 39);

Line 604: If (p_rec.job_information1= 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;
608: hr_utility.set_location('Entering:'||l_proc, 40);

Line 609: If (p_rec.job_information2= 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;
613: hr_utility.set_location('Entering:'||l_proc, 41);

Line 614: If (p_rec.job_information3= 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;
618: hr_utility.set_location('Entering:'||l_proc, 42);

Line 619: If (p_rec.job_information4= 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;
623: hr_utility.set_location('Entering:'||l_proc, 43);

Line 624: If (p_rec.job_information5= 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;
628: hr_utility.set_location('Entering:'||l_proc, 44);

Line 629: If (p_rec.job_information6= 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;
633: hr_utility.set_location('Entering:'||l_proc, 45);

Line 634: If (p_rec.job_information7= 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;
638: hr_utility.set_location('Entering:'||l_proc, 46);

Line 639: If (p_rec.job_information8= 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;
643: hr_utility.set_location('Entering:'||l_proc, 47);

Line 644: If (p_rec.job_information9= 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;
648: hr_utility.set_location('Entering:'||l_proc, 48);

Line 649: If (p_rec.job_information10= 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;
653: hr_utility.set_location('Entering:'||l_proc, 49);

Line 654: If (p_rec.job_information11= 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;
658: hr_utility.set_location('Entering:'||l_proc, 50);

Line 659: If (p_rec.job_information12= 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;
663: hr_utility.set_location('Entering:'||l_proc, 51);

Line 664: If (p_rec.job_information13= 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;
668: hr_utility.set_location('Entering:'||l_proc, 52);

Line 669: If (p_rec.job_information14= 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;
673: hr_utility.set_location('Entering:'||l_proc, 53);

Line 674: If (p_rec.job_information15= 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;
678: hr_utility.set_location('Entering:'||l_proc, 54);

Line 679: If (p_rec.job_information16= 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;
683: hr_utility.set_location('Entering:'||l_proc, 55);

Line 684: If (p_rec.job_information17= 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;
688: hr_utility.set_location('Entering:'||l_proc, 56);

Line 689: If (p_rec.job_information18= 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;
693: hr_utility.set_location('Entering:'||l_proc, 57);

Line 694: If (p_rec.job_information19= 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;
698: hr_utility.set_location('Entering:'||l_proc, 58);

Line 699: If (p_rec.job_information20= 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;
703: hr_utility.set_location('Entering:'||l_proc, 59);

Line 704: If (p_rec.benchmark_job_flag = 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;
708: hr_utility.set_location('Entering:'||p_rec.benchmark_job_id, 60);

Line 709: If (p_rec.benchmark_job_id = hr_api.g_number) 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;
713: hr_utility.set_location('Entering:'||l_proc, 61);

Line 714: If (p_rec.emp_rights_flag = hr_api.g_varchar2) 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;
718: hr_utility.set_location('Entering:'||l_proc, 62);

Line 719: If (p_rec.job_group_id = hr_api.g_number) 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;
723: --

Line 787: Raise HR_Api.Validate_Enabled;

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);
791: Exception

Line 792: When HR_Api.Validate_Enabled Then

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: --
795: -- As the Validate_Enabled exception has been raised
796: -- we must rollback to the savepoint

Line 807: p_job_definition_id in number default hr_api.g_number,

803: -- ----------------------------------------------------------------------------
804: Procedure upd
805: (
806: p_job_id in number,
807: p_job_definition_id in number default hr_api.g_number,
808: p_date_from in date default hr_api.g_date,
809: p_comments in varchar2 default hr_api.g_varchar2,
810: p_date_to in date default hr_api.g_date,
811: p_approval_authority in number default hr_api.g_number,

Line 808: p_date_from in date default hr_api.g_date,

804: Procedure upd
805: (
806: p_job_id in number,
807: p_job_definition_id in number default hr_api.g_number,
808: p_date_from in date default hr_api.g_date,
809: p_comments in varchar2 default hr_api.g_varchar2,
810: p_date_to in date default hr_api.g_date,
811: p_approval_authority in number default hr_api.g_number,
812: p_name in varchar2 default hr_api.g_varchar2,

Line 809: p_comments in varchar2 default hr_api.g_varchar2,

805: (
806: p_job_id in number,
807: p_job_definition_id in number default hr_api.g_number,
808: p_date_from in date default hr_api.g_date,
809: p_comments in varchar2 default hr_api.g_varchar2,
810: p_date_to in date default hr_api.g_date,
811: p_approval_authority in number default hr_api.g_number,
812: p_name in varchar2 default hr_api.g_varchar2,
813: p_request_id in number default hr_api.g_number,

Line 810: p_date_to in date default hr_api.g_date,

806: p_job_id in number,
807: p_job_definition_id in number default hr_api.g_number,
808: p_date_from in date default hr_api.g_date,
809: p_comments in varchar2 default hr_api.g_varchar2,
810: p_date_to in date default hr_api.g_date,
811: p_approval_authority in number default hr_api.g_number,
812: p_name in varchar2 default hr_api.g_varchar2,
813: p_request_id in number default hr_api.g_number,
814: p_program_application_id in number default hr_api.g_number,

Line 811: p_approval_authority in number default hr_api.g_number,

807: p_job_definition_id in number default hr_api.g_number,
808: p_date_from in date default hr_api.g_date,
809: p_comments in varchar2 default hr_api.g_varchar2,
810: p_date_to in date default hr_api.g_date,
811: p_approval_authority in number default hr_api.g_number,
812: p_name in varchar2 default hr_api.g_varchar2,
813: p_request_id in number default hr_api.g_number,
814: p_program_application_id in number default hr_api.g_number,
815: p_program_id in number default hr_api.g_number,

Line 812: p_name in varchar2 default hr_api.g_varchar2,

808: p_date_from in date default hr_api.g_date,
809: p_comments in varchar2 default hr_api.g_varchar2,
810: p_date_to in date default hr_api.g_date,
811: p_approval_authority in number default hr_api.g_number,
812: p_name in varchar2 default hr_api.g_varchar2,
813: p_request_id in number default hr_api.g_number,
814: p_program_application_id in number default hr_api.g_number,
815: p_program_id in number default hr_api.g_number,
816: p_program_update_date in date default hr_api.g_date,

Line 813: p_request_id in number default hr_api.g_number,

809: p_comments in varchar2 default hr_api.g_varchar2,
810: p_date_to in date default hr_api.g_date,
811: p_approval_authority in number default hr_api.g_number,
812: p_name in varchar2 default hr_api.g_varchar2,
813: p_request_id in number default hr_api.g_number,
814: p_program_application_id in number default hr_api.g_number,
815: p_program_id in number default hr_api.g_number,
816: p_program_update_date in date default hr_api.g_date,
817: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 814: p_program_application_id in number default hr_api.g_number,

810: p_date_to in date default hr_api.g_date,
811: p_approval_authority in number default hr_api.g_number,
812: p_name in varchar2 default hr_api.g_varchar2,
813: p_request_id in number default hr_api.g_number,
814: p_program_application_id in number default hr_api.g_number,
815: p_program_id in number default hr_api.g_number,
816: p_program_update_date in date default hr_api.g_date,
817: p_attribute_category in varchar2 default hr_api.g_varchar2,
818: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 815: p_program_id in number default hr_api.g_number,

811: p_approval_authority in number default hr_api.g_number,
812: p_name in varchar2 default hr_api.g_varchar2,
813: p_request_id in number default hr_api.g_number,
814: p_program_application_id in number default hr_api.g_number,
815: p_program_id in number default hr_api.g_number,
816: p_program_update_date in date default hr_api.g_date,
817: p_attribute_category in varchar2 default hr_api.g_varchar2,
818: p_attribute1 in varchar2 default hr_api.g_varchar2,
819: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 816: p_program_update_date in date default hr_api.g_date,

812: p_name in varchar2 default hr_api.g_varchar2,
813: p_request_id in number default hr_api.g_number,
814: p_program_application_id in number default hr_api.g_number,
815: p_program_id in number default hr_api.g_number,
816: p_program_update_date in date default hr_api.g_date,
817: p_attribute_category in varchar2 default hr_api.g_varchar2,
818: p_attribute1 in varchar2 default hr_api.g_varchar2,
819: p_attribute2 in varchar2 default hr_api.g_varchar2,
820: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 817: p_attribute_category in varchar2 default hr_api.g_varchar2,

813: p_request_id in number default hr_api.g_number,
814: p_program_application_id in number default hr_api.g_number,
815: p_program_id in number default hr_api.g_number,
816: p_program_update_date in date default hr_api.g_date,
817: p_attribute_category in varchar2 default hr_api.g_varchar2,
818: p_attribute1 in varchar2 default hr_api.g_varchar2,
819: p_attribute2 in varchar2 default hr_api.g_varchar2,
820: p_attribute3 in varchar2 default hr_api.g_varchar2,
821: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 818: p_attribute1 in varchar2 default hr_api.g_varchar2,

814: p_program_application_id in number default hr_api.g_number,
815: p_program_id in number default hr_api.g_number,
816: p_program_update_date in date default hr_api.g_date,
817: p_attribute_category in varchar2 default hr_api.g_varchar2,
818: p_attribute1 in varchar2 default hr_api.g_varchar2,
819: p_attribute2 in varchar2 default hr_api.g_varchar2,
820: p_attribute3 in varchar2 default hr_api.g_varchar2,
821: p_attribute4 in varchar2 default hr_api.g_varchar2,
822: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 819: p_attribute2 in varchar2 default hr_api.g_varchar2,

815: p_program_id in number default hr_api.g_number,
816: p_program_update_date in date default hr_api.g_date,
817: p_attribute_category in varchar2 default hr_api.g_varchar2,
818: p_attribute1 in varchar2 default hr_api.g_varchar2,
819: p_attribute2 in varchar2 default hr_api.g_varchar2,
820: p_attribute3 in varchar2 default hr_api.g_varchar2,
821: p_attribute4 in varchar2 default hr_api.g_varchar2,
822: p_attribute5 in varchar2 default hr_api.g_varchar2,
823: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 820: p_attribute3 in varchar2 default hr_api.g_varchar2,

816: p_program_update_date in date default hr_api.g_date,
817: p_attribute_category in varchar2 default hr_api.g_varchar2,
818: p_attribute1 in varchar2 default hr_api.g_varchar2,
819: p_attribute2 in varchar2 default hr_api.g_varchar2,
820: p_attribute3 in varchar2 default hr_api.g_varchar2,
821: p_attribute4 in varchar2 default hr_api.g_varchar2,
822: p_attribute5 in varchar2 default hr_api.g_varchar2,
823: p_attribute6 in varchar2 default hr_api.g_varchar2,
824: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 821: p_attribute4 in varchar2 default hr_api.g_varchar2,

817: p_attribute_category in varchar2 default hr_api.g_varchar2,
818: p_attribute1 in varchar2 default hr_api.g_varchar2,
819: p_attribute2 in varchar2 default hr_api.g_varchar2,
820: p_attribute3 in varchar2 default hr_api.g_varchar2,
821: p_attribute4 in varchar2 default hr_api.g_varchar2,
822: p_attribute5 in varchar2 default hr_api.g_varchar2,
823: p_attribute6 in varchar2 default hr_api.g_varchar2,
824: p_attribute7 in varchar2 default hr_api.g_varchar2,
825: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 822: p_attribute5 in varchar2 default hr_api.g_varchar2,

818: p_attribute1 in varchar2 default hr_api.g_varchar2,
819: p_attribute2 in varchar2 default hr_api.g_varchar2,
820: p_attribute3 in varchar2 default hr_api.g_varchar2,
821: p_attribute4 in varchar2 default hr_api.g_varchar2,
822: p_attribute5 in varchar2 default hr_api.g_varchar2,
823: p_attribute6 in varchar2 default hr_api.g_varchar2,
824: p_attribute7 in varchar2 default hr_api.g_varchar2,
825: p_attribute8 in varchar2 default hr_api.g_varchar2,
826: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 823: p_attribute6 in varchar2 default hr_api.g_varchar2,

819: p_attribute2 in varchar2 default hr_api.g_varchar2,
820: p_attribute3 in varchar2 default hr_api.g_varchar2,
821: p_attribute4 in varchar2 default hr_api.g_varchar2,
822: p_attribute5 in varchar2 default hr_api.g_varchar2,
823: p_attribute6 in varchar2 default hr_api.g_varchar2,
824: p_attribute7 in varchar2 default hr_api.g_varchar2,
825: p_attribute8 in varchar2 default hr_api.g_varchar2,
826: p_attribute9 in varchar2 default hr_api.g_varchar2,
827: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 824: p_attribute7 in varchar2 default hr_api.g_varchar2,

820: p_attribute3 in varchar2 default hr_api.g_varchar2,
821: p_attribute4 in varchar2 default hr_api.g_varchar2,
822: p_attribute5 in varchar2 default hr_api.g_varchar2,
823: p_attribute6 in varchar2 default hr_api.g_varchar2,
824: p_attribute7 in varchar2 default hr_api.g_varchar2,
825: p_attribute8 in varchar2 default hr_api.g_varchar2,
826: p_attribute9 in varchar2 default hr_api.g_varchar2,
827: p_attribute10 in varchar2 default hr_api.g_varchar2,
828: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 825: p_attribute8 in varchar2 default hr_api.g_varchar2,

821: p_attribute4 in varchar2 default hr_api.g_varchar2,
822: p_attribute5 in varchar2 default hr_api.g_varchar2,
823: p_attribute6 in varchar2 default hr_api.g_varchar2,
824: p_attribute7 in varchar2 default hr_api.g_varchar2,
825: p_attribute8 in varchar2 default hr_api.g_varchar2,
826: p_attribute9 in varchar2 default hr_api.g_varchar2,
827: p_attribute10 in varchar2 default hr_api.g_varchar2,
828: p_attribute11 in varchar2 default hr_api.g_varchar2,
829: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 826: p_attribute9 in varchar2 default hr_api.g_varchar2,

822: p_attribute5 in varchar2 default hr_api.g_varchar2,
823: p_attribute6 in varchar2 default hr_api.g_varchar2,
824: p_attribute7 in varchar2 default hr_api.g_varchar2,
825: p_attribute8 in varchar2 default hr_api.g_varchar2,
826: p_attribute9 in varchar2 default hr_api.g_varchar2,
827: p_attribute10 in varchar2 default hr_api.g_varchar2,
828: p_attribute11 in varchar2 default hr_api.g_varchar2,
829: p_attribute12 in varchar2 default hr_api.g_varchar2,
830: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 827: p_attribute10 in varchar2 default hr_api.g_varchar2,

823: p_attribute6 in varchar2 default hr_api.g_varchar2,
824: p_attribute7 in varchar2 default hr_api.g_varchar2,
825: p_attribute8 in varchar2 default hr_api.g_varchar2,
826: p_attribute9 in varchar2 default hr_api.g_varchar2,
827: p_attribute10 in varchar2 default hr_api.g_varchar2,
828: p_attribute11 in varchar2 default hr_api.g_varchar2,
829: p_attribute12 in varchar2 default hr_api.g_varchar2,
830: p_attribute13 in varchar2 default hr_api.g_varchar2,
831: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 828: p_attribute11 in varchar2 default hr_api.g_varchar2,

824: p_attribute7 in varchar2 default hr_api.g_varchar2,
825: p_attribute8 in varchar2 default hr_api.g_varchar2,
826: p_attribute9 in varchar2 default hr_api.g_varchar2,
827: p_attribute10 in varchar2 default hr_api.g_varchar2,
828: p_attribute11 in varchar2 default hr_api.g_varchar2,
829: p_attribute12 in varchar2 default hr_api.g_varchar2,
830: p_attribute13 in varchar2 default hr_api.g_varchar2,
831: p_attribute14 in varchar2 default hr_api.g_varchar2,
832: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 829: p_attribute12 in varchar2 default hr_api.g_varchar2,

825: p_attribute8 in varchar2 default hr_api.g_varchar2,
826: p_attribute9 in varchar2 default hr_api.g_varchar2,
827: p_attribute10 in varchar2 default hr_api.g_varchar2,
828: p_attribute11 in varchar2 default hr_api.g_varchar2,
829: p_attribute12 in varchar2 default hr_api.g_varchar2,
830: p_attribute13 in varchar2 default hr_api.g_varchar2,
831: p_attribute14 in varchar2 default hr_api.g_varchar2,
832: p_attribute15 in varchar2 default hr_api.g_varchar2,
833: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 830: p_attribute13 in varchar2 default hr_api.g_varchar2,

826: p_attribute9 in varchar2 default hr_api.g_varchar2,
827: p_attribute10 in varchar2 default hr_api.g_varchar2,
828: p_attribute11 in varchar2 default hr_api.g_varchar2,
829: p_attribute12 in varchar2 default hr_api.g_varchar2,
830: p_attribute13 in varchar2 default hr_api.g_varchar2,
831: p_attribute14 in varchar2 default hr_api.g_varchar2,
832: p_attribute15 in varchar2 default hr_api.g_varchar2,
833: p_attribute16 in varchar2 default hr_api.g_varchar2,
834: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 831: p_attribute14 in varchar2 default hr_api.g_varchar2,

827: p_attribute10 in varchar2 default hr_api.g_varchar2,
828: p_attribute11 in varchar2 default hr_api.g_varchar2,
829: p_attribute12 in varchar2 default hr_api.g_varchar2,
830: p_attribute13 in varchar2 default hr_api.g_varchar2,
831: p_attribute14 in varchar2 default hr_api.g_varchar2,
832: p_attribute15 in varchar2 default hr_api.g_varchar2,
833: p_attribute16 in varchar2 default hr_api.g_varchar2,
834: p_attribute17 in varchar2 default hr_api.g_varchar2,
835: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 832: p_attribute15 in varchar2 default hr_api.g_varchar2,

828: p_attribute11 in varchar2 default hr_api.g_varchar2,
829: p_attribute12 in varchar2 default hr_api.g_varchar2,
830: p_attribute13 in varchar2 default hr_api.g_varchar2,
831: p_attribute14 in varchar2 default hr_api.g_varchar2,
832: p_attribute15 in varchar2 default hr_api.g_varchar2,
833: p_attribute16 in varchar2 default hr_api.g_varchar2,
834: p_attribute17 in varchar2 default hr_api.g_varchar2,
835: p_attribute18 in varchar2 default hr_api.g_varchar2,
836: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 833: p_attribute16 in varchar2 default hr_api.g_varchar2,

829: p_attribute12 in varchar2 default hr_api.g_varchar2,
830: p_attribute13 in varchar2 default hr_api.g_varchar2,
831: p_attribute14 in varchar2 default hr_api.g_varchar2,
832: p_attribute15 in varchar2 default hr_api.g_varchar2,
833: p_attribute16 in varchar2 default hr_api.g_varchar2,
834: p_attribute17 in varchar2 default hr_api.g_varchar2,
835: p_attribute18 in varchar2 default hr_api.g_varchar2,
836: p_attribute19 in varchar2 default hr_api.g_varchar2,
837: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 834: p_attribute17 in varchar2 default hr_api.g_varchar2,

830: p_attribute13 in varchar2 default hr_api.g_varchar2,
831: p_attribute14 in varchar2 default hr_api.g_varchar2,
832: p_attribute15 in varchar2 default hr_api.g_varchar2,
833: p_attribute16 in varchar2 default hr_api.g_varchar2,
834: p_attribute17 in varchar2 default hr_api.g_varchar2,
835: p_attribute18 in varchar2 default hr_api.g_varchar2,
836: p_attribute19 in varchar2 default hr_api.g_varchar2,
837: p_attribute20 in varchar2 default hr_api.g_varchar2,
838: p_job_information_category in varchar2 default hr_api.g_varchar2,

Line 835: p_attribute18 in varchar2 default hr_api.g_varchar2,

831: p_attribute14 in varchar2 default hr_api.g_varchar2,
832: p_attribute15 in varchar2 default hr_api.g_varchar2,
833: p_attribute16 in varchar2 default hr_api.g_varchar2,
834: p_attribute17 in varchar2 default hr_api.g_varchar2,
835: p_attribute18 in varchar2 default hr_api.g_varchar2,
836: p_attribute19 in varchar2 default hr_api.g_varchar2,
837: p_attribute20 in varchar2 default hr_api.g_varchar2,
838: p_job_information_category in varchar2 default hr_api.g_varchar2,
839: p_job_information1 in varchar2 default hr_api.g_varchar2,

Line 836: p_attribute19 in varchar2 default hr_api.g_varchar2,

832: p_attribute15 in varchar2 default hr_api.g_varchar2,
833: p_attribute16 in varchar2 default hr_api.g_varchar2,
834: p_attribute17 in varchar2 default hr_api.g_varchar2,
835: p_attribute18 in varchar2 default hr_api.g_varchar2,
836: p_attribute19 in varchar2 default hr_api.g_varchar2,
837: p_attribute20 in varchar2 default hr_api.g_varchar2,
838: p_job_information_category in varchar2 default hr_api.g_varchar2,
839: p_job_information1 in varchar2 default hr_api.g_varchar2,
840: p_job_information2 in varchar2 default hr_api.g_varchar2,

Line 837: p_attribute20 in varchar2 default hr_api.g_varchar2,

833: p_attribute16 in varchar2 default hr_api.g_varchar2,
834: p_attribute17 in varchar2 default hr_api.g_varchar2,
835: p_attribute18 in varchar2 default hr_api.g_varchar2,
836: p_attribute19 in varchar2 default hr_api.g_varchar2,
837: p_attribute20 in varchar2 default hr_api.g_varchar2,
838: p_job_information_category in varchar2 default hr_api.g_varchar2,
839: p_job_information1 in varchar2 default hr_api.g_varchar2,
840: p_job_information2 in varchar2 default hr_api.g_varchar2,
841: p_job_information3 in varchar2 default hr_api.g_varchar2,

Line 838: p_job_information_category in varchar2 default hr_api.g_varchar2,

834: p_attribute17 in varchar2 default hr_api.g_varchar2,
835: p_attribute18 in varchar2 default hr_api.g_varchar2,
836: p_attribute19 in varchar2 default hr_api.g_varchar2,
837: p_attribute20 in varchar2 default hr_api.g_varchar2,
838: p_job_information_category in varchar2 default hr_api.g_varchar2,
839: p_job_information1 in varchar2 default hr_api.g_varchar2,
840: p_job_information2 in varchar2 default hr_api.g_varchar2,
841: p_job_information3 in varchar2 default hr_api.g_varchar2,
842: p_job_information4 in varchar2 default hr_api.g_varchar2,

Line 839: p_job_information1 in varchar2 default hr_api.g_varchar2,

835: p_attribute18 in varchar2 default hr_api.g_varchar2,
836: p_attribute19 in varchar2 default hr_api.g_varchar2,
837: p_attribute20 in varchar2 default hr_api.g_varchar2,
838: p_job_information_category in varchar2 default hr_api.g_varchar2,
839: p_job_information1 in varchar2 default hr_api.g_varchar2,
840: p_job_information2 in varchar2 default hr_api.g_varchar2,
841: p_job_information3 in varchar2 default hr_api.g_varchar2,
842: p_job_information4 in varchar2 default hr_api.g_varchar2,
843: p_job_information5 in varchar2 default hr_api.g_varchar2,

Line 840: p_job_information2 in varchar2 default hr_api.g_varchar2,

836: p_attribute19 in varchar2 default hr_api.g_varchar2,
837: p_attribute20 in varchar2 default hr_api.g_varchar2,
838: p_job_information_category in varchar2 default hr_api.g_varchar2,
839: p_job_information1 in varchar2 default hr_api.g_varchar2,
840: p_job_information2 in varchar2 default hr_api.g_varchar2,
841: p_job_information3 in varchar2 default hr_api.g_varchar2,
842: p_job_information4 in varchar2 default hr_api.g_varchar2,
843: p_job_information5 in varchar2 default hr_api.g_varchar2,
844: p_job_information6 in varchar2 default hr_api.g_varchar2,

Line 841: p_job_information3 in varchar2 default hr_api.g_varchar2,

837: p_attribute20 in varchar2 default hr_api.g_varchar2,
838: p_job_information_category in varchar2 default hr_api.g_varchar2,
839: p_job_information1 in varchar2 default hr_api.g_varchar2,
840: p_job_information2 in varchar2 default hr_api.g_varchar2,
841: p_job_information3 in varchar2 default hr_api.g_varchar2,
842: p_job_information4 in varchar2 default hr_api.g_varchar2,
843: p_job_information5 in varchar2 default hr_api.g_varchar2,
844: p_job_information6 in varchar2 default hr_api.g_varchar2,
845: p_job_information7 in varchar2 default hr_api.g_varchar2,

Line 842: p_job_information4 in varchar2 default hr_api.g_varchar2,

838: p_job_information_category in varchar2 default hr_api.g_varchar2,
839: p_job_information1 in varchar2 default hr_api.g_varchar2,
840: p_job_information2 in varchar2 default hr_api.g_varchar2,
841: p_job_information3 in varchar2 default hr_api.g_varchar2,
842: p_job_information4 in varchar2 default hr_api.g_varchar2,
843: p_job_information5 in varchar2 default hr_api.g_varchar2,
844: p_job_information6 in varchar2 default hr_api.g_varchar2,
845: p_job_information7 in varchar2 default hr_api.g_varchar2,
846: p_job_information8 in varchar2 default hr_api.g_varchar2,

Line 843: p_job_information5 in varchar2 default hr_api.g_varchar2,

839: p_job_information1 in varchar2 default hr_api.g_varchar2,
840: p_job_information2 in varchar2 default hr_api.g_varchar2,
841: p_job_information3 in varchar2 default hr_api.g_varchar2,
842: p_job_information4 in varchar2 default hr_api.g_varchar2,
843: p_job_information5 in varchar2 default hr_api.g_varchar2,
844: p_job_information6 in varchar2 default hr_api.g_varchar2,
845: p_job_information7 in varchar2 default hr_api.g_varchar2,
846: p_job_information8 in varchar2 default hr_api.g_varchar2,
847: p_job_information9 in varchar2 default hr_api.g_varchar2,

Line 844: p_job_information6 in varchar2 default hr_api.g_varchar2,

840: p_job_information2 in varchar2 default hr_api.g_varchar2,
841: p_job_information3 in varchar2 default hr_api.g_varchar2,
842: p_job_information4 in varchar2 default hr_api.g_varchar2,
843: p_job_information5 in varchar2 default hr_api.g_varchar2,
844: p_job_information6 in varchar2 default hr_api.g_varchar2,
845: p_job_information7 in varchar2 default hr_api.g_varchar2,
846: p_job_information8 in varchar2 default hr_api.g_varchar2,
847: p_job_information9 in varchar2 default hr_api.g_varchar2,
848: p_job_information10 in varchar2 default hr_api.g_varchar2,

Line 845: p_job_information7 in varchar2 default hr_api.g_varchar2,

841: p_job_information3 in varchar2 default hr_api.g_varchar2,
842: p_job_information4 in varchar2 default hr_api.g_varchar2,
843: p_job_information5 in varchar2 default hr_api.g_varchar2,
844: p_job_information6 in varchar2 default hr_api.g_varchar2,
845: p_job_information7 in varchar2 default hr_api.g_varchar2,
846: p_job_information8 in varchar2 default hr_api.g_varchar2,
847: p_job_information9 in varchar2 default hr_api.g_varchar2,
848: p_job_information10 in varchar2 default hr_api.g_varchar2,
849: p_job_information11 in varchar2 default hr_api.g_varchar2,

Line 846: p_job_information8 in varchar2 default hr_api.g_varchar2,

842: p_job_information4 in varchar2 default hr_api.g_varchar2,
843: p_job_information5 in varchar2 default hr_api.g_varchar2,
844: p_job_information6 in varchar2 default hr_api.g_varchar2,
845: p_job_information7 in varchar2 default hr_api.g_varchar2,
846: p_job_information8 in varchar2 default hr_api.g_varchar2,
847: p_job_information9 in varchar2 default hr_api.g_varchar2,
848: p_job_information10 in varchar2 default hr_api.g_varchar2,
849: p_job_information11 in varchar2 default hr_api.g_varchar2,
850: p_job_information12 in varchar2 default hr_api.g_varchar2,

Line 847: p_job_information9 in varchar2 default hr_api.g_varchar2,

843: p_job_information5 in varchar2 default hr_api.g_varchar2,
844: p_job_information6 in varchar2 default hr_api.g_varchar2,
845: p_job_information7 in varchar2 default hr_api.g_varchar2,
846: p_job_information8 in varchar2 default hr_api.g_varchar2,
847: p_job_information9 in varchar2 default hr_api.g_varchar2,
848: p_job_information10 in varchar2 default hr_api.g_varchar2,
849: p_job_information11 in varchar2 default hr_api.g_varchar2,
850: p_job_information12 in varchar2 default hr_api.g_varchar2,
851: p_job_information13 in varchar2 default hr_api.g_varchar2,

Line 848: p_job_information10 in varchar2 default hr_api.g_varchar2,

844: p_job_information6 in varchar2 default hr_api.g_varchar2,
845: p_job_information7 in varchar2 default hr_api.g_varchar2,
846: p_job_information8 in varchar2 default hr_api.g_varchar2,
847: p_job_information9 in varchar2 default hr_api.g_varchar2,
848: p_job_information10 in varchar2 default hr_api.g_varchar2,
849: p_job_information11 in varchar2 default hr_api.g_varchar2,
850: p_job_information12 in varchar2 default hr_api.g_varchar2,
851: p_job_information13 in varchar2 default hr_api.g_varchar2,
852: p_job_information14 in varchar2 default hr_api.g_varchar2,

Line 849: p_job_information11 in varchar2 default hr_api.g_varchar2,

845: p_job_information7 in varchar2 default hr_api.g_varchar2,
846: p_job_information8 in varchar2 default hr_api.g_varchar2,
847: p_job_information9 in varchar2 default hr_api.g_varchar2,
848: p_job_information10 in varchar2 default hr_api.g_varchar2,
849: p_job_information11 in varchar2 default hr_api.g_varchar2,
850: p_job_information12 in varchar2 default hr_api.g_varchar2,
851: p_job_information13 in varchar2 default hr_api.g_varchar2,
852: p_job_information14 in varchar2 default hr_api.g_varchar2,
853: p_job_information15 in varchar2 default hr_api.g_varchar2,

Line 850: p_job_information12 in varchar2 default hr_api.g_varchar2,

846: p_job_information8 in varchar2 default hr_api.g_varchar2,
847: p_job_information9 in varchar2 default hr_api.g_varchar2,
848: p_job_information10 in varchar2 default hr_api.g_varchar2,
849: p_job_information11 in varchar2 default hr_api.g_varchar2,
850: p_job_information12 in varchar2 default hr_api.g_varchar2,
851: p_job_information13 in varchar2 default hr_api.g_varchar2,
852: p_job_information14 in varchar2 default hr_api.g_varchar2,
853: p_job_information15 in varchar2 default hr_api.g_varchar2,
854: p_job_information16 in varchar2 default hr_api.g_varchar2,

Line 851: p_job_information13 in varchar2 default hr_api.g_varchar2,

847: p_job_information9 in varchar2 default hr_api.g_varchar2,
848: p_job_information10 in varchar2 default hr_api.g_varchar2,
849: p_job_information11 in varchar2 default hr_api.g_varchar2,
850: p_job_information12 in varchar2 default hr_api.g_varchar2,
851: p_job_information13 in varchar2 default hr_api.g_varchar2,
852: p_job_information14 in varchar2 default hr_api.g_varchar2,
853: p_job_information15 in varchar2 default hr_api.g_varchar2,
854: p_job_information16 in varchar2 default hr_api.g_varchar2,
855: p_job_information17 in varchar2 default hr_api.g_varchar2,

Line 852: p_job_information14 in varchar2 default hr_api.g_varchar2,

848: p_job_information10 in varchar2 default hr_api.g_varchar2,
849: p_job_information11 in varchar2 default hr_api.g_varchar2,
850: p_job_information12 in varchar2 default hr_api.g_varchar2,
851: p_job_information13 in varchar2 default hr_api.g_varchar2,
852: p_job_information14 in varchar2 default hr_api.g_varchar2,
853: p_job_information15 in varchar2 default hr_api.g_varchar2,
854: p_job_information16 in varchar2 default hr_api.g_varchar2,
855: p_job_information17 in varchar2 default hr_api.g_varchar2,
856: p_job_information18 in varchar2 default hr_api.g_varchar2,

Line 853: p_job_information15 in varchar2 default hr_api.g_varchar2,

849: p_job_information11 in varchar2 default hr_api.g_varchar2,
850: p_job_information12 in varchar2 default hr_api.g_varchar2,
851: p_job_information13 in varchar2 default hr_api.g_varchar2,
852: p_job_information14 in varchar2 default hr_api.g_varchar2,
853: p_job_information15 in varchar2 default hr_api.g_varchar2,
854: p_job_information16 in varchar2 default hr_api.g_varchar2,
855: p_job_information17 in varchar2 default hr_api.g_varchar2,
856: p_job_information18 in varchar2 default hr_api.g_varchar2,
857: p_job_information19 in varchar2 default hr_api.g_varchar2,

Line 854: p_job_information16 in varchar2 default hr_api.g_varchar2,

850: p_job_information12 in varchar2 default hr_api.g_varchar2,
851: p_job_information13 in varchar2 default hr_api.g_varchar2,
852: p_job_information14 in varchar2 default hr_api.g_varchar2,
853: p_job_information15 in varchar2 default hr_api.g_varchar2,
854: p_job_information16 in varchar2 default hr_api.g_varchar2,
855: p_job_information17 in varchar2 default hr_api.g_varchar2,
856: p_job_information18 in varchar2 default hr_api.g_varchar2,
857: p_job_information19 in varchar2 default hr_api.g_varchar2,
858: p_job_information20 in varchar2 default hr_api.g_varchar2,

Line 855: p_job_information17 in varchar2 default hr_api.g_varchar2,

851: p_job_information13 in varchar2 default hr_api.g_varchar2,
852: p_job_information14 in varchar2 default hr_api.g_varchar2,
853: p_job_information15 in varchar2 default hr_api.g_varchar2,
854: p_job_information16 in varchar2 default hr_api.g_varchar2,
855: p_job_information17 in varchar2 default hr_api.g_varchar2,
856: p_job_information18 in varchar2 default hr_api.g_varchar2,
857: p_job_information19 in varchar2 default hr_api.g_varchar2,
858: p_job_information20 in varchar2 default hr_api.g_varchar2,
859: p_benchmark_job_flag in varchar2 default hr_api.g_varchar2,

Line 856: p_job_information18 in varchar2 default hr_api.g_varchar2,

852: p_job_information14 in varchar2 default hr_api.g_varchar2,
853: p_job_information15 in varchar2 default hr_api.g_varchar2,
854: p_job_information16 in varchar2 default hr_api.g_varchar2,
855: p_job_information17 in varchar2 default hr_api.g_varchar2,
856: p_job_information18 in varchar2 default hr_api.g_varchar2,
857: p_job_information19 in varchar2 default hr_api.g_varchar2,
858: p_job_information20 in varchar2 default hr_api.g_varchar2,
859: p_benchmark_job_flag in varchar2 default hr_api.g_varchar2,
860: p_benchmark_job_id in number default hr_api.g_number,

Line 857: p_job_information19 in varchar2 default hr_api.g_varchar2,

853: p_job_information15 in varchar2 default hr_api.g_varchar2,
854: p_job_information16 in varchar2 default hr_api.g_varchar2,
855: p_job_information17 in varchar2 default hr_api.g_varchar2,
856: p_job_information18 in varchar2 default hr_api.g_varchar2,
857: p_job_information19 in varchar2 default hr_api.g_varchar2,
858: p_job_information20 in varchar2 default hr_api.g_varchar2,
859: p_benchmark_job_flag in varchar2 default hr_api.g_varchar2,
860: p_benchmark_job_id in number default hr_api.g_number,
861: p_emp_rights_flag in varchar2 default hr_api.g_varchar2,

Line 858: p_job_information20 in varchar2 default hr_api.g_varchar2,

854: p_job_information16 in varchar2 default hr_api.g_varchar2,
855: p_job_information17 in varchar2 default hr_api.g_varchar2,
856: p_job_information18 in varchar2 default hr_api.g_varchar2,
857: p_job_information19 in varchar2 default hr_api.g_varchar2,
858: p_job_information20 in varchar2 default hr_api.g_varchar2,
859: p_benchmark_job_flag in varchar2 default hr_api.g_varchar2,
860: p_benchmark_job_id in number default hr_api.g_number,
861: p_emp_rights_flag in varchar2 default hr_api.g_varchar2,
862: --p_job_group_id in number default hr_api.g_number,

Line 859: p_benchmark_job_flag in varchar2 default hr_api.g_varchar2,

855: p_job_information17 in varchar2 default hr_api.g_varchar2,
856: p_job_information18 in varchar2 default hr_api.g_varchar2,
857: p_job_information19 in varchar2 default hr_api.g_varchar2,
858: p_job_information20 in varchar2 default hr_api.g_varchar2,
859: p_benchmark_job_flag in varchar2 default hr_api.g_varchar2,
860: p_benchmark_job_id in number default hr_api.g_number,
861: p_emp_rights_flag in varchar2 default hr_api.g_varchar2,
862: --p_job_group_id in number default hr_api.g_number,
863: p_object_version_number in out nocopy number,

Line 860: p_benchmark_job_id in number default hr_api.g_number,

856: p_job_information18 in varchar2 default hr_api.g_varchar2,
857: p_job_information19 in varchar2 default hr_api.g_varchar2,
858: p_job_information20 in varchar2 default hr_api.g_varchar2,
859: p_benchmark_job_flag in varchar2 default hr_api.g_varchar2,
860: p_benchmark_job_id in number default hr_api.g_number,
861: p_emp_rights_flag in varchar2 default hr_api.g_varchar2,
862: --p_job_group_id in number default hr_api.g_number,
863: p_object_version_number in out nocopy number,
864: p_validate in boolean default false

Line 861: p_emp_rights_flag in varchar2 default hr_api.g_varchar2,

857: p_job_information19 in varchar2 default hr_api.g_varchar2,
858: p_job_information20 in varchar2 default hr_api.g_varchar2,
859: p_benchmark_job_flag in varchar2 default hr_api.g_varchar2,
860: p_benchmark_job_id in number default hr_api.g_number,
861: p_emp_rights_flag in varchar2 default hr_api.g_varchar2,
862: --p_job_group_id in number default hr_api.g_number,
863: p_object_version_number in out nocopy number,
864: p_validate in boolean default false
865: ) is

Line 862: --p_job_group_id in number default hr_api.g_number,

858: p_job_information20 in varchar2 default hr_api.g_varchar2,
859: p_benchmark_job_flag in varchar2 default hr_api.g_varchar2,
860: p_benchmark_job_id in number default hr_api.g_number,
861: p_emp_rights_flag in varchar2 default hr_api.g_varchar2,
862: --p_job_group_id in number default hr_api.g_number,
863: p_object_version_number in out nocopy number,
864: p_validate in boolean default false
865: ) is
866: --

Line 880: hr_api.g_number, -- p_business_group_id

876: l_rec :=
877: per_job_shd.convert_args
878: (
879: p_job_id,
880: hr_api.g_number, -- p_business_group_id
881: p_job_definition_id,
882: p_date_from,
883: p_comments,
884: p_date_to,

Line 936: hr_api.g_number, -- p_job_group_id

932: p_job_information20,
933: p_benchmark_job_flag,
934: p_benchmark_job_id,
935: p_emp_rights_flag,
936: hr_api.g_number, -- p_job_group_id
937: p_object_version_number
938: );
939: --
940: -- Having converted the arguments into the