DBA Data[Home] [Help]

APPS.PER_PJU_UPD dependencies on HR_API

Line 131: When hr_api.check_integrity_violated Then

127: --
128: hr_utility.set_location(' Leaving:'||l_proc, 10);
129: --
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));

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

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: --
139: per_pju_shd.constraint_error

Line 136: When hr_api.parent_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: --
139: per_pju_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 140: (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: --
144: per_pju_shd.constraint_error

Line 141: When hr_api.unique_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: --
144: per_pju_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 145: (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;
149: End update_dml;

Line 346: when hr_api.cannot_find_prog_unit then

342: );
343: --
344: exception
345: --
346: when hr_api.cannot_find_prog_unit then
347: --
348: hr_api.cannot_find_prog_unit_error
349: (p_module_name => 'PER_PREVIOUS_JOB_USAGES'
350: ,p_hook_type => 'AU');

Line 348: hr_api.cannot_find_prog_unit_error

344: exception
345: --
346: when hr_api.cannot_find_prog_unit then
347: --
348: hr_api.cannot_find_prog_unit_error
349: (p_module_name => 'PER_PREVIOUS_JOB_USAGES'
350: ,p_hook_type => 'AU');
351: --
352: end;

Line 411: If (p_rec.assignment_id = hr_api.g_number) then

407: -- p_rec plsql record structure
408: -- to see if a system default is being used. If a system default
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

Line 415: If (p_rec.previous_employer_id = hr_api.g_number) then

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;
418: End If;
419: If (p_rec.previous_job_id = hr_api.g_number) then

Line 419: If (p_rec.previous_job_id = hr_api.g_number) then

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;
422: End If;
423: If (p_rec.start_date = hr_api.g_date) then

Line 423: If (p_rec.start_date = hr_api.g_date) then

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;
426: End If;
427: If (p_rec.end_date = hr_api.g_date) then

Line 427: If (p_rec.end_date = hr_api.g_date) then

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;
430: End If;
431: If (p_rec.period_years = hr_api.g_number) then

Line 431: If (p_rec.period_years = hr_api.g_number) then

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;
434: End If;
435: If (p_rec.period_months = hr_api.g_number) then

Line 435: If (p_rec.period_months = hr_api.g_number) then

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;
438: End If;
439: If (p_rec.period_days = hr_api.g_number) then

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

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;
442: End If;
443: If (p_rec.pju_attribute_category = hr_api.g_varchar2) then

Line 443: If (p_rec.pju_attribute_category = hr_api.g_varchar2) then

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;
446: End If;
447: If (p_rec.pju_attribute1 = hr_api.g_varchar2) then

Line 447: If (p_rec.pju_attribute1 = hr_api.g_varchar2) then

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;
450: End If;
451: If (p_rec.pju_attribute2 = hr_api.g_varchar2) then

Line 451: If (p_rec.pju_attribute2 = hr_api.g_varchar2) then

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;
454: End If;
455: If (p_rec.pju_attribute3 = hr_api.g_varchar2) then

Line 455: If (p_rec.pju_attribute3 = hr_api.g_varchar2) then

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;
458: End If;
459: If (p_rec.pju_attribute4 = hr_api.g_varchar2) then

Line 459: If (p_rec.pju_attribute4 = hr_api.g_varchar2) then

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;
462: End If;
463: If (p_rec.pju_attribute5 = hr_api.g_varchar2) then

Line 463: If (p_rec.pju_attribute5 = hr_api.g_varchar2) then

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;
466: End If;
467: If (p_rec.pju_attribute6 = hr_api.g_varchar2) then

Line 467: If (p_rec.pju_attribute6 = hr_api.g_varchar2) then

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;
470: End If;
471: If (p_rec.pju_attribute7 = hr_api.g_varchar2) then

Line 471: If (p_rec.pju_attribute7 = hr_api.g_varchar2) then

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;
474: End If;
475: If (p_rec.pju_attribute8 = hr_api.g_varchar2) then

Line 475: If (p_rec.pju_attribute8 = hr_api.g_varchar2) then

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;
478: End If;
479: If (p_rec.pju_attribute9 = hr_api.g_varchar2) then

Line 479: If (p_rec.pju_attribute9 = hr_api.g_varchar2) then

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;
482: End If;
483: If (p_rec.pju_attribute10 = hr_api.g_varchar2) then

Line 483: If (p_rec.pju_attribute10 = hr_api.g_varchar2) then

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;
486: End If;
487: If (p_rec.pju_attribute11 = hr_api.g_varchar2) then

Line 487: If (p_rec.pju_attribute11 = hr_api.g_varchar2) then

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;
490: End If;
491: If (p_rec.pju_attribute12 = hr_api.g_varchar2) then

Line 491: If (p_rec.pju_attribute12 = hr_api.g_varchar2) then

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;
494: End If;
495: If (p_rec.pju_attribute13 = hr_api.g_varchar2) then

Line 495: If (p_rec.pju_attribute13 = hr_api.g_varchar2) then

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;
498: End If;
499: If (p_rec.pju_attribute14 = hr_api.g_varchar2) then

Line 499: If (p_rec.pju_attribute14 = hr_api.g_varchar2) then

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;
502: End If;
503: If (p_rec.pju_attribute15 = hr_api.g_varchar2) then

Line 503: If (p_rec.pju_attribute15 = hr_api.g_varchar2) then

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;
506: End If;
507: If (p_rec.pju_attribute16 = hr_api.g_varchar2) then

Line 507: If (p_rec.pju_attribute16 = hr_api.g_varchar2) then

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;
510: End If;
511: If (p_rec.pju_attribute17 = hr_api.g_varchar2) then

Line 511: If (p_rec.pju_attribute17 = hr_api.g_varchar2) then

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;
514: End If;
515: If (p_rec.pju_attribute18 = hr_api.g_varchar2) then

Line 515: If (p_rec.pju_attribute18 = hr_api.g_varchar2) then

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;
518: End If;
519: If (p_rec.pju_attribute19 = hr_api.g_varchar2) then

Line 519: If (p_rec.pju_attribute19 = hr_api.g_varchar2) then

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;
522: End If;
523: If (p_rec.pju_attribute20 = hr_api.g_varchar2) then

Line 523: If (p_rec.pju_attribute20 = hr_api.g_varchar2) then

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;
526: End If;
527: If (p_rec.pju_information_category = hr_api.g_varchar2) then

Line 527: If (p_rec.pju_information_category = hr_api.g_varchar2) then

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;
530: End If;
531: If (p_rec.pju_information1 = hr_api.g_varchar2) then

Line 531: If (p_rec.pju_information1 = hr_api.g_varchar2) then

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;
534: End If;
535: If (p_rec.pju_information2 = hr_api.g_varchar2) then

Line 535: If (p_rec.pju_information2 = hr_api.g_varchar2) then

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;
538: End If;
539: If (p_rec.pju_information3 = hr_api.g_varchar2) then

Line 539: If (p_rec.pju_information3 = hr_api.g_varchar2) then

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;
542: End If;
543: If (p_rec.pju_information4 = hr_api.g_varchar2) then

Line 543: If (p_rec.pju_information4 = hr_api.g_varchar2) then

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;
546: End If;
547: If (p_rec.pju_information5 = hr_api.g_varchar2) then

Line 547: If (p_rec.pju_information5 = hr_api.g_varchar2) then

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;
550: End If;
551: If (p_rec.pju_information6 = hr_api.g_varchar2) then

Line 551: If (p_rec.pju_information6 = hr_api.g_varchar2) then

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;
554: End If;
555: If (p_rec.pju_information7 = hr_api.g_varchar2) then

Line 555: If (p_rec.pju_information7 = hr_api.g_varchar2) then

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;
558: End If;
559: If (p_rec.pju_information8 = hr_api.g_varchar2) then

Line 559: If (p_rec.pju_information8 = hr_api.g_varchar2) then

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;
562: End If;
563: If (p_rec.pju_information9 = hr_api.g_varchar2) then

Line 563: If (p_rec.pju_information9 = hr_api.g_varchar2) then

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;
566: End If;
567: If (p_rec.pju_information10 = hr_api.g_varchar2) then

Line 567: If (p_rec.pju_information10 = hr_api.g_varchar2) then

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;
570: End If;
571: If (p_rec.pju_information11 = hr_api.g_varchar2) then

Line 571: If (p_rec.pju_information11 = hr_api.g_varchar2) then

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;
574: End If;
575: If (p_rec.pju_information12 = hr_api.g_varchar2) then

Line 575: If (p_rec.pju_information12 = hr_api.g_varchar2) then

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;
578: End If;
579: If (p_rec.pju_information13 = hr_api.g_varchar2) then

Line 579: If (p_rec.pju_information13 = hr_api.g_varchar2) then

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;
582: End If;
583: If (p_rec.pju_information14 = hr_api.g_varchar2) then

Line 583: If (p_rec.pju_information14 = hr_api.g_varchar2) then

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;
586: End If;
587: If (p_rec.pju_information15 = hr_api.g_varchar2) then

Line 587: If (p_rec.pju_information15 = hr_api.g_varchar2) then

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;
590: End If;
591: If (p_rec.pju_information16 = hr_api.g_varchar2) then

Line 591: If (p_rec.pju_information16 = hr_api.g_varchar2) then

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;
594: End If;
595: If (p_rec.pju_information17 = hr_api.g_varchar2) then

Line 595: If (p_rec.pju_information17 = hr_api.g_varchar2) then

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;
598: End If;
599: If (p_rec.pju_information18 = hr_api.g_varchar2) then

Line 599: If (p_rec.pju_information18 = hr_api.g_varchar2) then

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;
602: End If;
603: If (p_rec.pju_information19 = hr_api.g_varchar2) then

Line 603: If (p_rec.pju_information19 = hr_api.g_varchar2) then

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;
606: End If;
607: If (p_rec.pju_information20 = hr_api.g_varchar2) then

Line 607: If (p_rec.pju_information20 = hr_api.g_varchar2) then

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;
610: End If;
611: --

Line 665: ,p_assignment_id in number default hr_api.g_number

661: -- ----------------------------------------------------------------------------
662: Procedure upd
663: (p_previous_job_usage_id in number
664: ,p_object_version_number in out nocopy number
665: ,p_assignment_id in number default hr_api.g_number
666: ,p_previous_employer_id in number default hr_api.g_number
667: ,p_previous_job_id in number default hr_api.g_number
668: ,p_start_date in date default hr_api.g_date
669: ,p_end_date in date default hr_api.g_date

Line 666: ,p_previous_employer_id in number default hr_api.g_number

662: Procedure upd
663: (p_previous_job_usage_id in number
664: ,p_object_version_number in out nocopy number
665: ,p_assignment_id in number default hr_api.g_number
666: ,p_previous_employer_id in number default hr_api.g_number
667: ,p_previous_job_id in number default hr_api.g_number
668: ,p_start_date in date default hr_api.g_date
669: ,p_end_date in date default hr_api.g_date
670: ,p_period_years in number default hr_api.g_number

Line 667: ,p_previous_job_id in number default hr_api.g_number

663: (p_previous_job_usage_id in number
664: ,p_object_version_number in out nocopy number
665: ,p_assignment_id in number default hr_api.g_number
666: ,p_previous_employer_id in number default hr_api.g_number
667: ,p_previous_job_id in number default hr_api.g_number
668: ,p_start_date in date default hr_api.g_date
669: ,p_end_date in date default hr_api.g_date
670: ,p_period_years in number default hr_api.g_number
671: ,p_period_months in number default hr_api.g_number

Line 668: ,p_start_date in date default hr_api.g_date

664: ,p_object_version_number in out nocopy number
665: ,p_assignment_id in number default hr_api.g_number
666: ,p_previous_employer_id in number default hr_api.g_number
667: ,p_previous_job_id in number default hr_api.g_number
668: ,p_start_date in date default hr_api.g_date
669: ,p_end_date in date default hr_api.g_date
670: ,p_period_years in number default hr_api.g_number
671: ,p_period_months in number default hr_api.g_number
672: ,p_period_days in number default hr_api.g_number

Line 669: ,p_end_date in date default hr_api.g_date

665: ,p_assignment_id in number default hr_api.g_number
666: ,p_previous_employer_id in number default hr_api.g_number
667: ,p_previous_job_id in number default hr_api.g_number
668: ,p_start_date in date default hr_api.g_date
669: ,p_end_date in date default hr_api.g_date
670: ,p_period_years in number default hr_api.g_number
671: ,p_period_months in number default hr_api.g_number
672: ,p_period_days in number default hr_api.g_number
673: ,p_pju_attribute_category in varchar2 default hr_api.g_varchar2

Line 670: ,p_period_years in number default hr_api.g_number

666: ,p_previous_employer_id in number default hr_api.g_number
667: ,p_previous_job_id in number default hr_api.g_number
668: ,p_start_date in date default hr_api.g_date
669: ,p_end_date in date default hr_api.g_date
670: ,p_period_years in number default hr_api.g_number
671: ,p_period_months in number default hr_api.g_number
672: ,p_period_days in number default hr_api.g_number
673: ,p_pju_attribute_category in varchar2 default hr_api.g_varchar2
674: ,p_pju_attribute1 in varchar2 default hr_api.g_varchar2

Line 671: ,p_period_months in number default hr_api.g_number

667: ,p_previous_job_id in number default hr_api.g_number
668: ,p_start_date in date default hr_api.g_date
669: ,p_end_date in date default hr_api.g_date
670: ,p_period_years in number default hr_api.g_number
671: ,p_period_months in number default hr_api.g_number
672: ,p_period_days in number default hr_api.g_number
673: ,p_pju_attribute_category in varchar2 default hr_api.g_varchar2
674: ,p_pju_attribute1 in varchar2 default hr_api.g_varchar2
675: ,p_pju_attribute2 in varchar2 default hr_api.g_varchar2

Line 672: ,p_period_days in number default hr_api.g_number

668: ,p_start_date in date default hr_api.g_date
669: ,p_end_date in date default hr_api.g_date
670: ,p_period_years in number default hr_api.g_number
671: ,p_period_months in number default hr_api.g_number
672: ,p_period_days in number default hr_api.g_number
673: ,p_pju_attribute_category in varchar2 default hr_api.g_varchar2
674: ,p_pju_attribute1 in varchar2 default hr_api.g_varchar2
675: ,p_pju_attribute2 in varchar2 default hr_api.g_varchar2
676: ,p_pju_attribute3 in varchar2 default hr_api.g_varchar2

Line 673: ,p_pju_attribute_category in varchar2 default hr_api.g_varchar2

669: ,p_end_date in date default hr_api.g_date
670: ,p_period_years in number default hr_api.g_number
671: ,p_period_months in number default hr_api.g_number
672: ,p_period_days in number default hr_api.g_number
673: ,p_pju_attribute_category in varchar2 default hr_api.g_varchar2
674: ,p_pju_attribute1 in varchar2 default hr_api.g_varchar2
675: ,p_pju_attribute2 in varchar2 default hr_api.g_varchar2
676: ,p_pju_attribute3 in varchar2 default hr_api.g_varchar2
677: ,p_pju_attribute4 in varchar2 default hr_api.g_varchar2

Line 674: ,p_pju_attribute1 in varchar2 default hr_api.g_varchar2

670: ,p_period_years in number default hr_api.g_number
671: ,p_period_months in number default hr_api.g_number
672: ,p_period_days in number default hr_api.g_number
673: ,p_pju_attribute_category in varchar2 default hr_api.g_varchar2
674: ,p_pju_attribute1 in varchar2 default hr_api.g_varchar2
675: ,p_pju_attribute2 in varchar2 default hr_api.g_varchar2
676: ,p_pju_attribute3 in varchar2 default hr_api.g_varchar2
677: ,p_pju_attribute4 in varchar2 default hr_api.g_varchar2
678: ,p_pju_attribute5 in varchar2 default hr_api.g_varchar2

Line 675: ,p_pju_attribute2 in varchar2 default hr_api.g_varchar2

671: ,p_period_months in number default hr_api.g_number
672: ,p_period_days in number default hr_api.g_number
673: ,p_pju_attribute_category in varchar2 default hr_api.g_varchar2
674: ,p_pju_attribute1 in varchar2 default hr_api.g_varchar2
675: ,p_pju_attribute2 in varchar2 default hr_api.g_varchar2
676: ,p_pju_attribute3 in varchar2 default hr_api.g_varchar2
677: ,p_pju_attribute4 in varchar2 default hr_api.g_varchar2
678: ,p_pju_attribute5 in varchar2 default hr_api.g_varchar2
679: ,p_pju_attribute6 in varchar2 default hr_api.g_varchar2

Line 676: ,p_pju_attribute3 in varchar2 default hr_api.g_varchar2

672: ,p_period_days in number default hr_api.g_number
673: ,p_pju_attribute_category in varchar2 default hr_api.g_varchar2
674: ,p_pju_attribute1 in varchar2 default hr_api.g_varchar2
675: ,p_pju_attribute2 in varchar2 default hr_api.g_varchar2
676: ,p_pju_attribute3 in varchar2 default hr_api.g_varchar2
677: ,p_pju_attribute4 in varchar2 default hr_api.g_varchar2
678: ,p_pju_attribute5 in varchar2 default hr_api.g_varchar2
679: ,p_pju_attribute6 in varchar2 default hr_api.g_varchar2
680: ,p_pju_attribute7 in varchar2 default hr_api.g_varchar2

Line 677: ,p_pju_attribute4 in varchar2 default hr_api.g_varchar2

673: ,p_pju_attribute_category in varchar2 default hr_api.g_varchar2
674: ,p_pju_attribute1 in varchar2 default hr_api.g_varchar2
675: ,p_pju_attribute2 in varchar2 default hr_api.g_varchar2
676: ,p_pju_attribute3 in varchar2 default hr_api.g_varchar2
677: ,p_pju_attribute4 in varchar2 default hr_api.g_varchar2
678: ,p_pju_attribute5 in varchar2 default hr_api.g_varchar2
679: ,p_pju_attribute6 in varchar2 default hr_api.g_varchar2
680: ,p_pju_attribute7 in varchar2 default hr_api.g_varchar2
681: ,p_pju_attribute8 in varchar2 default hr_api.g_varchar2

Line 678: ,p_pju_attribute5 in varchar2 default hr_api.g_varchar2

674: ,p_pju_attribute1 in varchar2 default hr_api.g_varchar2
675: ,p_pju_attribute2 in varchar2 default hr_api.g_varchar2
676: ,p_pju_attribute3 in varchar2 default hr_api.g_varchar2
677: ,p_pju_attribute4 in varchar2 default hr_api.g_varchar2
678: ,p_pju_attribute5 in varchar2 default hr_api.g_varchar2
679: ,p_pju_attribute6 in varchar2 default hr_api.g_varchar2
680: ,p_pju_attribute7 in varchar2 default hr_api.g_varchar2
681: ,p_pju_attribute8 in varchar2 default hr_api.g_varchar2
682: ,p_pju_attribute9 in varchar2 default hr_api.g_varchar2

Line 679: ,p_pju_attribute6 in varchar2 default hr_api.g_varchar2

675: ,p_pju_attribute2 in varchar2 default hr_api.g_varchar2
676: ,p_pju_attribute3 in varchar2 default hr_api.g_varchar2
677: ,p_pju_attribute4 in varchar2 default hr_api.g_varchar2
678: ,p_pju_attribute5 in varchar2 default hr_api.g_varchar2
679: ,p_pju_attribute6 in varchar2 default hr_api.g_varchar2
680: ,p_pju_attribute7 in varchar2 default hr_api.g_varchar2
681: ,p_pju_attribute8 in varchar2 default hr_api.g_varchar2
682: ,p_pju_attribute9 in varchar2 default hr_api.g_varchar2
683: ,p_pju_attribute10 in varchar2 default hr_api.g_varchar2

Line 680: ,p_pju_attribute7 in varchar2 default hr_api.g_varchar2

676: ,p_pju_attribute3 in varchar2 default hr_api.g_varchar2
677: ,p_pju_attribute4 in varchar2 default hr_api.g_varchar2
678: ,p_pju_attribute5 in varchar2 default hr_api.g_varchar2
679: ,p_pju_attribute6 in varchar2 default hr_api.g_varchar2
680: ,p_pju_attribute7 in varchar2 default hr_api.g_varchar2
681: ,p_pju_attribute8 in varchar2 default hr_api.g_varchar2
682: ,p_pju_attribute9 in varchar2 default hr_api.g_varchar2
683: ,p_pju_attribute10 in varchar2 default hr_api.g_varchar2
684: ,p_pju_attribute11 in varchar2 default hr_api.g_varchar2

Line 681: ,p_pju_attribute8 in varchar2 default hr_api.g_varchar2

677: ,p_pju_attribute4 in varchar2 default hr_api.g_varchar2
678: ,p_pju_attribute5 in varchar2 default hr_api.g_varchar2
679: ,p_pju_attribute6 in varchar2 default hr_api.g_varchar2
680: ,p_pju_attribute7 in varchar2 default hr_api.g_varchar2
681: ,p_pju_attribute8 in varchar2 default hr_api.g_varchar2
682: ,p_pju_attribute9 in varchar2 default hr_api.g_varchar2
683: ,p_pju_attribute10 in varchar2 default hr_api.g_varchar2
684: ,p_pju_attribute11 in varchar2 default hr_api.g_varchar2
685: ,p_pju_attribute12 in varchar2 default hr_api.g_varchar2

Line 682: ,p_pju_attribute9 in varchar2 default hr_api.g_varchar2

678: ,p_pju_attribute5 in varchar2 default hr_api.g_varchar2
679: ,p_pju_attribute6 in varchar2 default hr_api.g_varchar2
680: ,p_pju_attribute7 in varchar2 default hr_api.g_varchar2
681: ,p_pju_attribute8 in varchar2 default hr_api.g_varchar2
682: ,p_pju_attribute9 in varchar2 default hr_api.g_varchar2
683: ,p_pju_attribute10 in varchar2 default hr_api.g_varchar2
684: ,p_pju_attribute11 in varchar2 default hr_api.g_varchar2
685: ,p_pju_attribute12 in varchar2 default hr_api.g_varchar2
686: ,p_pju_attribute13 in varchar2 default hr_api.g_varchar2

Line 683: ,p_pju_attribute10 in varchar2 default hr_api.g_varchar2

679: ,p_pju_attribute6 in varchar2 default hr_api.g_varchar2
680: ,p_pju_attribute7 in varchar2 default hr_api.g_varchar2
681: ,p_pju_attribute8 in varchar2 default hr_api.g_varchar2
682: ,p_pju_attribute9 in varchar2 default hr_api.g_varchar2
683: ,p_pju_attribute10 in varchar2 default hr_api.g_varchar2
684: ,p_pju_attribute11 in varchar2 default hr_api.g_varchar2
685: ,p_pju_attribute12 in varchar2 default hr_api.g_varchar2
686: ,p_pju_attribute13 in varchar2 default hr_api.g_varchar2
687: ,p_pju_attribute14 in varchar2 default hr_api.g_varchar2

Line 684: ,p_pju_attribute11 in varchar2 default hr_api.g_varchar2

680: ,p_pju_attribute7 in varchar2 default hr_api.g_varchar2
681: ,p_pju_attribute8 in varchar2 default hr_api.g_varchar2
682: ,p_pju_attribute9 in varchar2 default hr_api.g_varchar2
683: ,p_pju_attribute10 in varchar2 default hr_api.g_varchar2
684: ,p_pju_attribute11 in varchar2 default hr_api.g_varchar2
685: ,p_pju_attribute12 in varchar2 default hr_api.g_varchar2
686: ,p_pju_attribute13 in varchar2 default hr_api.g_varchar2
687: ,p_pju_attribute14 in varchar2 default hr_api.g_varchar2
688: ,p_pju_attribute15 in varchar2 default hr_api.g_varchar2

Line 685: ,p_pju_attribute12 in varchar2 default hr_api.g_varchar2

681: ,p_pju_attribute8 in varchar2 default hr_api.g_varchar2
682: ,p_pju_attribute9 in varchar2 default hr_api.g_varchar2
683: ,p_pju_attribute10 in varchar2 default hr_api.g_varchar2
684: ,p_pju_attribute11 in varchar2 default hr_api.g_varchar2
685: ,p_pju_attribute12 in varchar2 default hr_api.g_varchar2
686: ,p_pju_attribute13 in varchar2 default hr_api.g_varchar2
687: ,p_pju_attribute14 in varchar2 default hr_api.g_varchar2
688: ,p_pju_attribute15 in varchar2 default hr_api.g_varchar2
689: ,p_pju_attribute16 in varchar2 default hr_api.g_varchar2

Line 686: ,p_pju_attribute13 in varchar2 default hr_api.g_varchar2

682: ,p_pju_attribute9 in varchar2 default hr_api.g_varchar2
683: ,p_pju_attribute10 in varchar2 default hr_api.g_varchar2
684: ,p_pju_attribute11 in varchar2 default hr_api.g_varchar2
685: ,p_pju_attribute12 in varchar2 default hr_api.g_varchar2
686: ,p_pju_attribute13 in varchar2 default hr_api.g_varchar2
687: ,p_pju_attribute14 in varchar2 default hr_api.g_varchar2
688: ,p_pju_attribute15 in varchar2 default hr_api.g_varchar2
689: ,p_pju_attribute16 in varchar2 default hr_api.g_varchar2
690: ,p_pju_attribute17 in varchar2 default hr_api.g_varchar2

Line 687: ,p_pju_attribute14 in varchar2 default hr_api.g_varchar2

683: ,p_pju_attribute10 in varchar2 default hr_api.g_varchar2
684: ,p_pju_attribute11 in varchar2 default hr_api.g_varchar2
685: ,p_pju_attribute12 in varchar2 default hr_api.g_varchar2
686: ,p_pju_attribute13 in varchar2 default hr_api.g_varchar2
687: ,p_pju_attribute14 in varchar2 default hr_api.g_varchar2
688: ,p_pju_attribute15 in varchar2 default hr_api.g_varchar2
689: ,p_pju_attribute16 in varchar2 default hr_api.g_varchar2
690: ,p_pju_attribute17 in varchar2 default hr_api.g_varchar2
691: ,p_pju_attribute18 in varchar2 default hr_api.g_varchar2

Line 688: ,p_pju_attribute15 in varchar2 default hr_api.g_varchar2

684: ,p_pju_attribute11 in varchar2 default hr_api.g_varchar2
685: ,p_pju_attribute12 in varchar2 default hr_api.g_varchar2
686: ,p_pju_attribute13 in varchar2 default hr_api.g_varchar2
687: ,p_pju_attribute14 in varchar2 default hr_api.g_varchar2
688: ,p_pju_attribute15 in varchar2 default hr_api.g_varchar2
689: ,p_pju_attribute16 in varchar2 default hr_api.g_varchar2
690: ,p_pju_attribute17 in varchar2 default hr_api.g_varchar2
691: ,p_pju_attribute18 in varchar2 default hr_api.g_varchar2
692: ,p_pju_attribute19 in varchar2 default hr_api.g_varchar2

Line 689: ,p_pju_attribute16 in varchar2 default hr_api.g_varchar2

685: ,p_pju_attribute12 in varchar2 default hr_api.g_varchar2
686: ,p_pju_attribute13 in varchar2 default hr_api.g_varchar2
687: ,p_pju_attribute14 in varchar2 default hr_api.g_varchar2
688: ,p_pju_attribute15 in varchar2 default hr_api.g_varchar2
689: ,p_pju_attribute16 in varchar2 default hr_api.g_varchar2
690: ,p_pju_attribute17 in varchar2 default hr_api.g_varchar2
691: ,p_pju_attribute18 in varchar2 default hr_api.g_varchar2
692: ,p_pju_attribute19 in varchar2 default hr_api.g_varchar2
693: ,p_pju_attribute20 in varchar2 default hr_api.g_varchar2

Line 690: ,p_pju_attribute17 in varchar2 default hr_api.g_varchar2

686: ,p_pju_attribute13 in varchar2 default hr_api.g_varchar2
687: ,p_pju_attribute14 in varchar2 default hr_api.g_varchar2
688: ,p_pju_attribute15 in varchar2 default hr_api.g_varchar2
689: ,p_pju_attribute16 in varchar2 default hr_api.g_varchar2
690: ,p_pju_attribute17 in varchar2 default hr_api.g_varchar2
691: ,p_pju_attribute18 in varchar2 default hr_api.g_varchar2
692: ,p_pju_attribute19 in varchar2 default hr_api.g_varchar2
693: ,p_pju_attribute20 in varchar2 default hr_api.g_varchar2
694: ,p_pju_information_category in varchar2 default hr_api.g_varchar2

Line 691: ,p_pju_attribute18 in varchar2 default hr_api.g_varchar2

687: ,p_pju_attribute14 in varchar2 default hr_api.g_varchar2
688: ,p_pju_attribute15 in varchar2 default hr_api.g_varchar2
689: ,p_pju_attribute16 in varchar2 default hr_api.g_varchar2
690: ,p_pju_attribute17 in varchar2 default hr_api.g_varchar2
691: ,p_pju_attribute18 in varchar2 default hr_api.g_varchar2
692: ,p_pju_attribute19 in varchar2 default hr_api.g_varchar2
693: ,p_pju_attribute20 in varchar2 default hr_api.g_varchar2
694: ,p_pju_information_category in varchar2 default hr_api.g_varchar2
695: ,p_pju_information1 in varchar2 default hr_api.g_varchar2

Line 692: ,p_pju_attribute19 in varchar2 default hr_api.g_varchar2

688: ,p_pju_attribute15 in varchar2 default hr_api.g_varchar2
689: ,p_pju_attribute16 in varchar2 default hr_api.g_varchar2
690: ,p_pju_attribute17 in varchar2 default hr_api.g_varchar2
691: ,p_pju_attribute18 in varchar2 default hr_api.g_varchar2
692: ,p_pju_attribute19 in varchar2 default hr_api.g_varchar2
693: ,p_pju_attribute20 in varchar2 default hr_api.g_varchar2
694: ,p_pju_information_category in varchar2 default hr_api.g_varchar2
695: ,p_pju_information1 in varchar2 default hr_api.g_varchar2
696: ,p_pju_information2 in varchar2 default hr_api.g_varchar2

Line 693: ,p_pju_attribute20 in varchar2 default hr_api.g_varchar2

689: ,p_pju_attribute16 in varchar2 default hr_api.g_varchar2
690: ,p_pju_attribute17 in varchar2 default hr_api.g_varchar2
691: ,p_pju_attribute18 in varchar2 default hr_api.g_varchar2
692: ,p_pju_attribute19 in varchar2 default hr_api.g_varchar2
693: ,p_pju_attribute20 in varchar2 default hr_api.g_varchar2
694: ,p_pju_information_category in varchar2 default hr_api.g_varchar2
695: ,p_pju_information1 in varchar2 default hr_api.g_varchar2
696: ,p_pju_information2 in varchar2 default hr_api.g_varchar2
697: ,p_pju_information3 in varchar2 default hr_api.g_varchar2

Line 694: ,p_pju_information_category in varchar2 default hr_api.g_varchar2

690: ,p_pju_attribute17 in varchar2 default hr_api.g_varchar2
691: ,p_pju_attribute18 in varchar2 default hr_api.g_varchar2
692: ,p_pju_attribute19 in varchar2 default hr_api.g_varchar2
693: ,p_pju_attribute20 in varchar2 default hr_api.g_varchar2
694: ,p_pju_information_category in varchar2 default hr_api.g_varchar2
695: ,p_pju_information1 in varchar2 default hr_api.g_varchar2
696: ,p_pju_information2 in varchar2 default hr_api.g_varchar2
697: ,p_pju_information3 in varchar2 default hr_api.g_varchar2
698: ,p_pju_information4 in varchar2 default hr_api.g_varchar2

Line 695: ,p_pju_information1 in varchar2 default hr_api.g_varchar2

691: ,p_pju_attribute18 in varchar2 default hr_api.g_varchar2
692: ,p_pju_attribute19 in varchar2 default hr_api.g_varchar2
693: ,p_pju_attribute20 in varchar2 default hr_api.g_varchar2
694: ,p_pju_information_category in varchar2 default hr_api.g_varchar2
695: ,p_pju_information1 in varchar2 default hr_api.g_varchar2
696: ,p_pju_information2 in varchar2 default hr_api.g_varchar2
697: ,p_pju_information3 in varchar2 default hr_api.g_varchar2
698: ,p_pju_information4 in varchar2 default hr_api.g_varchar2
699: ,p_pju_information5 in varchar2 default hr_api.g_varchar2

Line 696: ,p_pju_information2 in varchar2 default hr_api.g_varchar2

692: ,p_pju_attribute19 in varchar2 default hr_api.g_varchar2
693: ,p_pju_attribute20 in varchar2 default hr_api.g_varchar2
694: ,p_pju_information_category in varchar2 default hr_api.g_varchar2
695: ,p_pju_information1 in varchar2 default hr_api.g_varchar2
696: ,p_pju_information2 in varchar2 default hr_api.g_varchar2
697: ,p_pju_information3 in varchar2 default hr_api.g_varchar2
698: ,p_pju_information4 in varchar2 default hr_api.g_varchar2
699: ,p_pju_information5 in varchar2 default hr_api.g_varchar2
700: ,p_pju_information6 in varchar2 default hr_api.g_varchar2

Line 697: ,p_pju_information3 in varchar2 default hr_api.g_varchar2

693: ,p_pju_attribute20 in varchar2 default hr_api.g_varchar2
694: ,p_pju_information_category in varchar2 default hr_api.g_varchar2
695: ,p_pju_information1 in varchar2 default hr_api.g_varchar2
696: ,p_pju_information2 in varchar2 default hr_api.g_varchar2
697: ,p_pju_information3 in varchar2 default hr_api.g_varchar2
698: ,p_pju_information4 in varchar2 default hr_api.g_varchar2
699: ,p_pju_information5 in varchar2 default hr_api.g_varchar2
700: ,p_pju_information6 in varchar2 default hr_api.g_varchar2
701: ,p_pju_information7 in varchar2 default hr_api.g_varchar2

Line 698: ,p_pju_information4 in varchar2 default hr_api.g_varchar2

694: ,p_pju_information_category in varchar2 default hr_api.g_varchar2
695: ,p_pju_information1 in varchar2 default hr_api.g_varchar2
696: ,p_pju_information2 in varchar2 default hr_api.g_varchar2
697: ,p_pju_information3 in varchar2 default hr_api.g_varchar2
698: ,p_pju_information4 in varchar2 default hr_api.g_varchar2
699: ,p_pju_information5 in varchar2 default hr_api.g_varchar2
700: ,p_pju_information6 in varchar2 default hr_api.g_varchar2
701: ,p_pju_information7 in varchar2 default hr_api.g_varchar2
702: ,p_pju_information8 in varchar2 default hr_api.g_varchar2

Line 699: ,p_pju_information5 in varchar2 default hr_api.g_varchar2

695: ,p_pju_information1 in varchar2 default hr_api.g_varchar2
696: ,p_pju_information2 in varchar2 default hr_api.g_varchar2
697: ,p_pju_information3 in varchar2 default hr_api.g_varchar2
698: ,p_pju_information4 in varchar2 default hr_api.g_varchar2
699: ,p_pju_information5 in varchar2 default hr_api.g_varchar2
700: ,p_pju_information6 in varchar2 default hr_api.g_varchar2
701: ,p_pju_information7 in varchar2 default hr_api.g_varchar2
702: ,p_pju_information8 in varchar2 default hr_api.g_varchar2
703: ,p_pju_information9 in varchar2 default hr_api.g_varchar2

Line 700: ,p_pju_information6 in varchar2 default hr_api.g_varchar2

696: ,p_pju_information2 in varchar2 default hr_api.g_varchar2
697: ,p_pju_information3 in varchar2 default hr_api.g_varchar2
698: ,p_pju_information4 in varchar2 default hr_api.g_varchar2
699: ,p_pju_information5 in varchar2 default hr_api.g_varchar2
700: ,p_pju_information6 in varchar2 default hr_api.g_varchar2
701: ,p_pju_information7 in varchar2 default hr_api.g_varchar2
702: ,p_pju_information8 in varchar2 default hr_api.g_varchar2
703: ,p_pju_information9 in varchar2 default hr_api.g_varchar2
704: ,p_pju_information10 in varchar2 default hr_api.g_varchar2

Line 701: ,p_pju_information7 in varchar2 default hr_api.g_varchar2

697: ,p_pju_information3 in varchar2 default hr_api.g_varchar2
698: ,p_pju_information4 in varchar2 default hr_api.g_varchar2
699: ,p_pju_information5 in varchar2 default hr_api.g_varchar2
700: ,p_pju_information6 in varchar2 default hr_api.g_varchar2
701: ,p_pju_information7 in varchar2 default hr_api.g_varchar2
702: ,p_pju_information8 in varchar2 default hr_api.g_varchar2
703: ,p_pju_information9 in varchar2 default hr_api.g_varchar2
704: ,p_pju_information10 in varchar2 default hr_api.g_varchar2
705: ,p_pju_information11 in varchar2 default hr_api.g_varchar2

Line 702: ,p_pju_information8 in varchar2 default hr_api.g_varchar2

698: ,p_pju_information4 in varchar2 default hr_api.g_varchar2
699: ,p_pju_information5 in varchar2 default hr_api.g_varchar2
700: ,p_pju_information6 in varchar2 default hr_api.g_varchar2
701: ,p_pju_information7 in varchar2 default hr_api.g_varchar2
702: ,p_pju_information8 in varchar2 default hr_api.g_varchar2
703: ,p_pju_information9 in varchar2 default hr_api.g_varchar2
704: ,p_pju_information10 in varchar2 default hr_api.g_varchar2
705: ,p_pju_information11 in varchar2 default hr_api.g_varchar2
706: ,p_pju_information12 in varchar2 default hr_api.g_varchar2

Line 703: ,p_pju_information9 in varchar2 default hr_api.g_varchar2

699: ,p_pju_information5 in varchar2 default hr_api.g_varchar2
700: ,p_pju_information6 in varchar2 default hr_api.g_varchar2
701: ,p_pju_information7 in varchar2 default hr_api.g_varchar2
702: ,p_pju_information8 in varchar2 default hr_api.g_varchar2
703: ,p_pju_information9 in varchar2 default hr_api.g_varchar2
704: ,p_pju_information10 in varchar2 default hr_api.g_varchar2
705: ,p_pju_information11 in varchar2 default hr_api.g_varchar2
706: ,p_pju_information12 in varchar2 default hr_api.g_varchar2
707: ,p_pju_information13 in varchar2 default hr_api.g_varchar2

Line 704: ,p_pju_information10 in varchar2 default hr_api.g_varchar2

700: ,p_pju_information6 in varchar2 default hr_api.g_varchar2
701: ,p_pju_information7 in varchar2 default hr_api.g_varchar2
702: ,p_pju_information8 in varchar2 default hr_api.g_varchar2
703: ,p_pju_information9 in varchar2 default hr_api.g_varchar2
704: ,p_pju_information10 in varchar2 default hr_api.g_varchar2
705: ,p_pju_information11 in varchar2 default hr_api.g_varchar2
706: ,p_pju_information12 in varchar2 default hr_api.g_varchar2
707: ,p_pju_information13 in varchar2 default hr_api.g_varchar2
708: ,p_pju_information14 in varchar2 default hr_api.g_varchar2

Line 705: ,p_pju_information11 in varchar2 default hr_api.g_varchar2

701: ,p_pju_information7 in varchar2 default hr_api.g_varchar2
702: ,p_pju_information8 in varchar2 default hr_api.g_varchar2
703: ,p_pju_information9 in varchar2 default hr_api.g_varchar2
704: ,p_pju_information10 in varchar2 default hr_api.g_varchar2
705: ,p_pju_information11 in varchar2 default hr_api.g_varchar2
706: ,p_pju_information12 in varchar2 default hr_api.g_varchar2
707: ,p_pju_information13 in varchar2 default hr_api.g_varchar2
708: ,p_pju_information14 in varchar2 default hr_api.g_varchar2
709: ,p_pju_information15 in varchar2 default hr_api.g_varchar2

Line 706: ,p_pju_information12 in varchar2 default hr_api.g_varchar2

702: ,p_pju_information8 in varchar2 default hr_api.g_varchar2
703: ,p_pju_information9 in varchar2 default hr_api.g_varchar2
704: ,p_pju_information10 in varchar2 default hr_api.g_varchar2
705: ,p_pju_information11 in varchar2 default hr_api.g_varchar2
706: ,p_pju_information12 in varchar2 default hr_api.g_varchar2
707: ,p_pju_information13 in varchar2 default hr_api.g_varchar2
708: ,p_pju_information14 in varchar2 default hr_api.g_varchar2
709: ,p_pju_information15 in varchar2 default hr_api.g_varchar2
710: ,p_pju_information16 in varchar2 default hr_api.g_varchar2

Line 707: ,p_pju_information13 in varchar2 default hr_api.g_varchar2

703: ,p_pju_information9 in varchar2 default hr_api.g_varchar2
704: ,p_pju_information10 in varchar2 default hr_api.g_varchar2
705: ,p_pju_information11 in varchar2 default hr_api.g_varchar2
706: ,p_pju_information12 in varchar2 default hr_api.g_varchar2
707: ,p_pju_information13 in varchar2 default hr_api.g_varchar2
708: ,p_pju_information14 in varchar2 default hr_api.g_varchar2
709: ,p_pju_information15 in varchar2 default hr_api.g_varchar2
710: ,p_pju_information16 in varchar2 default hr_api.g_varchar2
711: ,p_pju_information17 in varchar2 default hr_api.g_varchar2

Line 708: ,p_pju_information14 in varchar2 default hr_api.g_varchar2

704: ,p_pju_information10 in varchar2 default hr_api.g_varchar2
705: ,p_pju_information11 in varchar2 default hr_api.g_varchar2
706: ,p_pju_information12 in varchar2 default hr_api.g_varchar2
707: ,p_pju_information13 in varchar2 default hr_api.g_varchar2
708: ,p_pju_information14 in varchar2 default hr_api.g_varchar2
709: ,p_pju_information15 in varchar2 default hr_api.g_varchar2
710: ,p_pju_information16 in varchar2 default hr_api.g_varchar2
711: ,p_pju_information17 in varchar2 default hr_api.g_varchar2
712: ,p_pju_information18 in varchar2 default hr_api.g_varchar2

Line 709: ,p_pju_information15 in varchar2 default hr_api.g_varchar2

705: ,p_pju_information11 in varchar2 default hr_api.g_varchar2
706: ,p_pju_information12 in varchar2 default hr_api.g_varchar2
707: ,p_pju_information13 in varchar2 default hr_api.g_varchar2
708: ,p_pju_information14 in varchar2 default hr_api.g_varchar2
709: ,p_pju_information15 in varchar2 default hr_api.g_varchar2
710: ,p_pju_information16 in varchar2 default hr_api.g_varchar2
711: ,p_pju_information17 in varchar2 default hr_api.g_varchar2
712: ,p_pju_information18 in varchar2 default hr_api.g_varchar2
713: ,p_pju_information19 in varchar2 default hr_api.g_varchar2

Line 710: ,p_pju_information16 in varchar2 default hr_api.g_varchar2

706: ,p_pju_information12 in varchar2 default hr_api.g_varchar2
707: ,p_pju_information13 in varchar2 default hr_api.g_varchar2
708: ,p_pju_information14 in varchar2 default hr_api.g_varchar2
709: ,p_pju_information15 in varchar2 default hr_api.g_varchar2
710: ,p_pju_information16 in varchar2 default hr_api.g_varchar2
711: ,p_pju_information17 in varchar2 default hr_api.g_varchar2
712: ,p_pju_information18 in varchar2 default hr_api.g_varchar2
713: ,p_pju_information19 in varchar2 default hr_api.g_varchar2
714: ,p_pju_information20 in varchar2 default hr_api.g_varchar2

Line 711: ,p_pju_information17 in varchar2 default hr_api.g_varchar2

707: ,p_pju_information13 in varchar2 default hr_api.g_varchar2
708: ,p_pju_information14 in varchar2 default hr_api.g_varchar2
709: ,p_pju_information15 in varchar2 default hr_api.g_varchar2
710: ,p_pju_information16 in varchar2 default hr_api.g_varchar2
711: ,p_pju_information17 in varchar2 default hr_api.g_varchar2
712: ,p_pju_information18 in varchar2 default hr_api.g_varchar2
713: ,p_pju_information19 in varchar2 default hr_api.g_varchar2
714: ,p_pju_information20 in varchar2 default hr_api.g_varchar2
715: ) is

Line 712: ,p_pju_information18 in varchar2 default hr_api.g_varchar2

708: ,p_pju_information14 in varchar2 default hr_api.g_varchar2
709: ,p_pju_information15 in varchar2 default hr_api.g_varchar2
710: ,p_pju_information16 in varchar2 default hr_api.g_varchar2
711: ,p_pju_information17 in varchar2 default hr_api.g_varchar2
712: ,p_pju_information18 in varchar2 default hr_api.g_varchar2
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: --

Line 713: ,p_pju_information19 in varchar2 default hr_api.g_varchar2

709: ,p_pju_information15 in varchar2 default hr_api.g_varchar2
710: ,p_pju_information16 in varchar2 default hr_api.g_varchar2
711: ,p_pju_information17 in varchar2 default hr_api.g_varchar2
712: ,p_pju_information18 in varchar2 default hr_api.g_varchar2
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;

Line 714: ,p_pju_information20 in varchar2 default hr_api.g_varchar2

710: ,p_pju_information16 in varchar2 default hr_api.g_varchar2
711: ,p_pju_information17 in varchar2 default hr_api.g_varchar2
712: ,p_pju_information18 in varchar2 default hr_api.g_varchar2
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';