APPS.PER_SUB_UPD dependencies on HR_API

Line 129: When hr_api.check_integrity_violated Then

125: --
126: hr_utility.set_location(' Leaving:'||l_proc, 10);
127: --
128: Exception
129: When hr_api.check_integrity_violated Then
130: -- A check constraint has been violated
131: per_sub_shd.g_api_dml := false; -- Unset the api dml status
132: per_sub_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

129: When hr_api.check_integrity_violated Then
130: -- A check constraint has been violated
131: per_sub_shd.g_api_dml := false; -- Unset the api dml status
132: per_sub_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.parent_integrity_violated Then
135: -- Parent integrity has been violated
136: per_sub_shd.g_api_dml := false; -- Unset the api dml status
137: per_sub_shd.constraint_error

Line 134: When hr_api.parent_integrity_violated Then

130: -- A check constraint has been violated
131: per_sub_shd.g_api_dml := false; -- Unset the api dml status
132: per_sub_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.parent_integrity_violated Then
135: -- Parent integrity has been violated
136: per_sub_shd.g_api_dml := false; -- Unset the api dml status
137: per_sub_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

134: When hr_api.parent_integrity_violated Then
135: -- Parent integrity has been violated
136: per_sub_shd.g_api_dml := false; -- Unset the api dml status
137: per_sub_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.unique_integrity_violated Then
140: -- Unique integrity has been violated
141: per_sub_shd.g_api_dml := false; -- Unset the api dml status
142: per_sub_shd.constraint_error

Line 139: When hr_api.unique_integrity_violated Then

135: -- Parent integrity has been violated
136: per_sub_shd.g_api_dml := false; -- Unset the api dml status
137: per_sub_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.unique_integrity_violated Then
140: -- Unique integrity has been violated
141: per_sub_shd.g_api_dml := false; -- Unset the api dml status
142: per_sub_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

139: When hr_api.unique_integrity_violated Then
140: -- Unique integrity has been violated
141: per_sub_shd.g_api_dml := false; -- Unset the api dml status
142: per_sub_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When Others Then
145: per_sub_shd.g_api_dml := false; -- Unset the api dml status
146: Raise;
147: End update_dml;

Line 340: when hr_api.cannot_find_prog_unit then

336: p_sub_information19_o => per_sub_shd.g_old_rec.sub_information19,
337: p_sub_information20_o => per_sub_shd.g_old_rec.sub_information20
338: );
339: exception
340: when hr_api.cannot_find_prog_unit then
341: hr_api.cannot_find_prog_unit_error
342: (p_module_name => 'PER_SUBJECTS_TAKEN'
343: ,p_hook_type => 'AU'
344: );

Line 341: hr_api.cannot_find_prog_unit_error

337: p_sub_information20_o => per_sub_shd.g_old_rec.sub_information20
338: );
339: exception
340: when hr_api.cannot_find_prog_unit then
341: hr_api.cannot_find_prog_unit_error
342: (p_module_name => 'PER_SUBJECTS_TAKEN'
343: ,p_hook_type => 'AU'
344: );
345: end;

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

405: -- p_rec plsql record structure
406: -- to see if a system default is being used. If a system default
407: -- is being used then we must set to the 'current' argument value.
408: --
409: If (p_rec.start_date = hr_api.g_date) then
410: p_rec.start_date :=
411: per_sub_shd.g_old_rec.start_date;
412: End If;
413: If (p_rec.major = hr_api.g_varchar2) then

Line 413: If (p_rec.major = hr_api.g_varchar2) then

409: If (p_rec.start_date = hr_api.g_date) then
410: p_rec.start_date :=
411: per_sub_shd.g_old_rec.start_date;
412: End If;
413: If (p_rec.major = hr_api.g_varchar2) then
414: p_rec.major :=
415: per_sub_shd.g_old_rec.major;
416: End If;
417: If (p_rec.subject_status = hr_api.g_varchar2) then

Line 417: If (p_rec.subject_status = hr_api.g_varchar2) then

413: If (p_rec.major = hr_api.g_varchar2) then
414: p_rec.major :=
415: per_sub_shd.g_old_rec.major;
416: End If;
417: If (p_rec.subject_status = hr_api.g_varchar2) then
418: p_rec.subject_status :=
419: per_sub_shd.g_old_rec.subject_status;
420: End If;
421: If (p_rec.subject = hr_api.g_varchar2) then

Line 421: If (p_rec.subject = hr_api.g_varchar2) then

417: If (p_rec.subject_status = hr_api.g_varchar2) then
418: p_rec.subject_status :=
419: per_sub_shd.g_old_rec.subject_status;
420: End If;
421: If (p_rec.subject = hr_api.g_varchar2) then
422: p_rec.subject :=
423: per_sub_shd.g_old_rec.subject;
424: End If;
425: If (p_rec.grade_attained = hr_api.g_varchar2) then

Line 425: If (p_rec.grade_attained = hr_api.g_varchar2) then

421: If (p_rec.subject = hr_api.g_varchar2) then
422: p_rec.subject :=
423: per_sub_shd.g_old_rec.subject;
424: End If;
425: If (p_rec.grade_attained = hr_api.g_varchar2) then
426: p_rec.grade_attained :=
427: per_sub_shd.g_old_rec.grade_attained;
428: End If;
429: If (p_rec.end_date = hr_api.g_date) then

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

425: If (p_rec.grade_attained = hr_api.g_varchar2) then
426: p_rec.grade_attained :=
427: per_sub_shd.g_old_rec.grade_attained;
428: End If;
429: If (p_rec.end_date = hr_api.g_date) then
430: p_rec.end_date :=
431: per_sub_shd.g_old_rec.end_date;
432: End If;
433: If (p_rec.qualification_id = hr_api.g_number) then

Line 433: If (p_rec.qualification_id = hr_api.g_number) then

429: If (p_rec.end_date = hr_api.g_date) then
430: p_rec.end_date :=
431: per_sub_shd.g_old_rec.end_date;
432: End If;
433: If (p_rec.qualification_id = hr_api.g_number) then
434: p_rec.qualification_id :=
435: per_sub_shd.g_old_rec.qualification_id;
436: End If;
437: If (p_rec.attribute_category = hr_api.g_varchar2) then

Line 437: If (p_rec.attribute_category = hr_api.g_varchar2) then

433: If (p_rec.qualification_id = hr_api.g_number) then
434: p_rec.qualification_id :=
435: per_sub_shd.g_old_rec.qualification_id;
436: End If;
437: If (p_rec.attribute_category = hr_api.g_varchar2) then
438: p_rec.attribute_category :=
439: per_sub_shd.g_old_rec.attribute_category;
440: End If;
441: If (p_rec.attribute1 = hr_api.g_varchar2) then

Line 441: If (p_rec.attribute1 = hr_api.g_varchar2) then

437: If (p_rec.attribute_category = hr_api.g_varchar2) then
438: p_rec.attribute_category :=
439: per_sub_shd.g_old_rec.attribute_category;
440: End If;
441: If (p_rec.attribute1 = hr_api.g_varchar2) then
442: p_rec.attribute1 :=
443: per_sub_shd.g_old_rec.attribute1;
444: End If;
445: If (p_rec.attribute2 = hr_api.g_varchar2) then

Line 445: If (p_rec.attribute2 = hr_api.g_varchar2) then

441: If (p_rec.attribute1 = hr_api.g_varchar2) then
442: p_rec.attribute1 :=
443: per_sub_shd.g_old_rec.attribute1;
444: End If;
445: If (p_rec.attribute2 = hr_api.g_varchar2) then
446: p_rec.attribute2 :=
447: per_sub_shd.g_old_rec.attribute2;
448: End If;
449: If (p_rec.attribute3 = hr_api.g_varchar2) then

Line 449: If (p_rec.attribute3 = hr_api.g_varchar2) then

445: If (p_rec.attribute2 = hr_api.g_varchar2) then
446: p_rec.attribute2 :=
447: per_sub_shd.g_old_rec.attribute2;
448: End If;
449: If (p_rec.attribute3 = hr_api.g_varchar2) then
450: p_rec.attribute3 :=
451: per_sub_shd.g_old_rec.attribute3;
452: End If;
453: If (p_rec.attribute4 = hr_api.g_varchar2) then

Line 453: If (p_rec.attribute4 = hr_api.g_varchar2) then

449: If (p_rec.attribute3 = hr_api.g_varchar2) then
450: p_rec.attribute3 :=
451: per_sub_shd.g_old_rec.attribute3;
452: End If;
453: If (p_rec.attribute4 = hr_api.g_varchar2) then
454: p_rec.attribute4 :=
455: per_sub_shd.g_old_rec.attribute4;
456: End If;
457: If (p_rec.attribute5 = hr_api.g_varchar2) then

Line 457: If (p_rec.attribute5 = hr_api.g_varchar2) then

453: If (p_rec.attribute4 = hr_api.g_varchar2) then
454: p_rec.attribute4 :=
455: per_sub_shd.g_old_rec.attribute4;
456: End If;
457: If (p_rec.attribute5 = hr_api.g_varchar2) then
458: p_rec.attribute5 :=
459: per_sub_shd.g_old_rec.attribute5;
460: End If;
461: If (p_rec.attribute6 = hr_api.g_varchar2) then

Line 461: If (p_rec.attribute6 = hr_api.g_varchar2) then

457: If (p_rec.attribute5 = hr_api.g_varchar2) then
458: p_rec.attribute5 :=
459: per_sub_shd.g_old_rec.attribute5;
460: End If;
461: If (p_rec.attribute6 = hr_api.g_varchar2) then
462: p_rec.attribute6 :=
463: per_sub_shd.g_old_rec.attribute6;
464: End If;
465: If (p_rec.attribute7 = hr_api.g_varchar2) then

Line 465: If (p_rec.attribute7 = hr_api.g_varchar2) then

461: If (p_rec.attribute6 = hr_api.g_varchar2) then
462: p_rec.attribute6 :=
463: per_sub_shd.g_old_rec.attribute6;
464: End If;
465: If (p_rec.attribute7 = hr_api.g_varchar2) then
466: p_rec.attribute7 :=
467: per_sub_shd.g_old_rec.attribute7;
468: End If;
469: If (p_rec.attribute8 = hr_api.g_varchar2) then

Line 469: If (p_rec.attribute8 = hr_api.g_varchar2) then

465: If (p_rec.attribute7 = hr_api.g_varchar2) then
466: p_rec.attribute7 :=
467: per_sub_shd.g_old_rec.attribute7;
468: End If;
469: If (p_rec.attribute8 = hr_api.g_varchar2) then
470: p_rec.attribute8 :=
471: per_sub_shd.g_old_rec.attribute8;
472: End If;
473: If (p_rec.attribute9 = hr_api.g_varchar2) then

Line 473: If (p_rec.attribute9 = hr_api.g_varchar2) then

469: If (p_rec.attribute8 = hr_api.g_varchar2) then
470: p_rec.attribute8 :=
471: per_sub_shd.g_old_rec.attribute8;
472: End If;
473: If (p_rec.attribute9 = hr_api.g_varchar2) then
474: p_rec.attribute9 :=
475: per_sub_shd.g_old_rec.attribute9;
476: End If;
477: If (p_rec.attribute10 = hr_api.g_varchar2) then

Line 477: If (p_rec.attribute10 = hr_api.g_varchar2) then

473: If (p_rec.attribute9 = hr_api.g_varchar2) then
474: p_rec.attribute9 :=
475: per_sub_shd.g_old_rec.attribute9;
476: End If;
477: If (p_rec.attribute10 = hr_api.g_varchar2) then
478: p_rec.attribute10 :=
479: per_sub_shd.g_old_rec.attribute10;
480: End If;
481: If (p_rec.attribute11 = hr_api.g_varchar2) then

Line 481: If (p_rec.attribute11 = hr_api.g_varchar2) then

477: If (p_rec.attribute10 = hr_api.g_varchar2) then
478: p_rec.attribute10 :=
479: per_sub_shd.g_old_rec.attribute10;
480: End If;
481: If (p_rec.attribute11 = hr_api.g_varchar2) then
482: p_rec.attribute11 :=
483: per_sub_shd.g_old_rec.attribute11;
484: End If;
485: If (p_rec.attribute12 = hr_api.g_varchar2) then

Line 485: If (p_rec.attribute12 = hr_api.g_varchar2) then

481: If (p_rec.attribute11 = hr_api.g_varchar2) then
482: p_rec.attribute11 :=
483: per_sub_shd.g_old_rec.attribute11;
484: End If;
485: If (p_rec.attribute12 = hr_api.g_varchar2) then
486: p_rec.attribute12 :=
487: per_sub_shd.g_old_rec.attribute12;
488: End If;
489: If (p_rec.attribute13 = hr_api.g_varchar2) then

Line 489: If (p_rec.attribute13 = hr_api.g_varchar2) then

485: If (p_rec.attribute12 = hr_api.g_varchar2) then
486: p_rec.attribute12 :=
487: per_sub_shd.g_old_rec.attribute12;
488: End If;
489: If (p_rec.attribute13 = hr_api.g_varchar2) then
490: p_rec.attribute13 :=
491: per_sub_shd.g_old_rec.attribute13;
492: End If;
493: If (p_rec.attribute14 = hr_api.g_varchar2) then

Line 493: If (p_rec.attribute14 = hr_api.g_varchar2) then

489: If (p_rec.attribute13 = hr_api.g_varchar2) then
490: p_rec.attribute13 :=
491: per_sub_shd.g_old_rec.attribute13;
492: End If;
493: If (p_rec.attribute14 = hr_api.g_varchar2) then
494: p_rec.attribute14 :=
495: per_sub_shd.g_old_rec.attribute14;
496: End If;
497: If (p_rec.attribute15 = hr_api.g_varchar2) then

Line 497: If (p_rec.attribute15 = hr_api.g_varchar2) then

493: If (p_rec.attribute14 = hr_api.g_varchar2) then
494: p_rec.attribute14 :=
495: per_sub_shd.g_old_rec.attribute14;
496: End If;
497: If (p_rec.attribute15 = hr_api.g_varchar2) then
498: p_rec.attribute15 :=
499: per_sub_shd.g_old_rec.attribute15;
500: End If;
501: If (p_rec.attribute16 = hr_api.g_varchar2) then

Line 501: If (p_rec.attribute16 = hr_api.g_varchar2) then

497: If (p_rec.attribute15 = hr_api.g_varchar2) then
498: p_rec.attribute15 :=
499: per_sub_shd.g_old_rec.attribute15;
500: End If;
501: If (p_rec.attribute16 = hr_api.g_varchar2) then
502: p_rec.attribute16 :=
503: per_sub_shd.g_old_rec.attribute16;
504: End If;
505: If (p_rec.attribute17 = hr_api.g_varchar2) then

Line 505: If (p_rec.attribute17 = hr_api.g_varchar2) then

501: If (p_rec.attribute16 = hr_api.g_varchar2) then
502: p_rec.attribute16 :=
503: per_sub_shd.g_old_rec.attribute16;
504: End If;
505: If (p_rec.attribute17 = hr_api.g_varchar2) then
506: p_rec.attribute17 :=
507: per_sub_shd.g_old_rec.attribute17;
508: End If;
509: If (p_rec.attribute18 = hr_api.g_varchar2) then

Line 509: If (p_rec.attribute18 = hr_api.g_varchar2) then

505: If (p_rec.attribute17 = hr_api.g_varchar2) then
506: p_rec.attribute17 :=
507: per_sub_shd.g_old_rec.attribute17;
508: End If;
509: If (p_rec.attribute18 = hr_api.g_varchar2) then
510: p_rec.attribute18 :=
511: per_sub_shd.g_old_rec.attribute18;
512: End If;
513: If (p_rec.attribute19 = hr_api.g_varchar2) then

Line 513: If (p_rec.attribute19 = hr_api.g_varchar2) then

509: If (p_rec.attribute18 = hr_api.g_varchar2) then
510: p_rec.attribute18 :=
511: per_sub_shd.g_old_rec.attribute18;
512: End If;
513: If (p_rec.attribute19 = hr_api.g_varchar2) then
514: p_rec.attribute19 :=
515: per_sub_shd.g_old_rec.attribute19;
516: End If;
517: If (p_rec.attribute20 = hr_api.g_varchar2) then

Line 517: If (p_rec.attribute20 = hr_api.g_varchar2) then

513: If (p_rec.attribute19 = hr_api.g_varchar2) then
514: p_rec.attribute19 :=
515: per_sub_shd.g_old_rec.attribute19;
516: End If;
517: If (p_rec.attribute20 = hr_api.g_varchar2) then
518: p_rec.attribute20 :=
519: per_sub_shd.g_old_rec.attribute20;
520: End If;
521: If (p_rec.sub_information_category = hr_api.g_varchar2) then

Line 521: If (p_rec.sub_information_category = hr_api.g_varchar2) then

517: If (p_rec.attribute20 = hr_api.g_varchar2) then
518: p_rec.attribute20 :=
519: per_sub_shd.g_old_rec.attribute20;
520: End If;
521: If (p_rec.sub_information_category = hr_api.g_varchar2) then
522: p_rec.sub_information_category :=
523: per_sub_shd.g_old_rec.sub_information_category;
524: End If;
525: If (p_rec.sub_information1 = hr_api.g_varchar2) then

Line 525: If (p_rec.sub_information1 = hr_api.g_varchar2) then

521: If (p_rec.sub_information_category = hr_api.g_varchar2) then
522: p_rec.sub_information_category :=
523: per_sub_shd.g_old_rec.sub_information_category;
524: End If;
525: If (p_rec.sub_information1 = hr_api.g_varchar2) then
526: p_rec.sub_information1 :=
527: per_sub_shd.g_old_rec.sub_information1;
528: End If;
529: If (p_rec.sub_information2 = hr_api.g_varchar2) then

Line 529: If (p_rec.sub_information2 = hr_api.g_varchar2) then

525: If (p_rec.sub_information1 = hr_api.g_varchar2) then
526: p_rec.sub_information1 :=
527: per_sub_shd.g_old_rec.sub_information1;
528: End If;
529: If (p_rec.sub_information2 = hr_api.g_varchar2) then
530: p_rec.sub_information2 :=
531: per_sub_shd.g_old_rec.sub_information2;
532: End If;
533: If (p_rec.sub_information3 = hr_api.g_varchar2) then

Line 533: If (p_rec.sub_information3 = hr_api.g_varchar2) then

529: If (p_rec.sub_information2 = hr_api.g_varchar2) then
530: p_rec.sub_information2 :=
531: per_sub_shd.g_old_rec.sub_information2;
532: End If;
533: If (p_rec.sub_information3 = hr_api.g_varchar2) then
534: p_rec.sub_information3 :=
535: per_sub_shd.g_old_rec.sub_information3;
536: End If;
537: If (p_rec.sub_information4 = hr_api.g_varchar2) then

Line 537: If (p_rec.sub_information4 = hr_api.g_varchar2) then

533: If (p_rec.sub_information3 = hr_api.g_varchar2) then
534: p_rec.sub_information3 :=
535: per_sub_shd.g_old_rec.sub_information3;
536: End If;
537: If (p_rec.sub_information4 = hr_api.g_varchar2) then
538: p_rec.sub_information4 :=
539: per_sub_shd.g_old_rec.sub_information4;
540: End If;
541: If (p_rec.sub_information5 = hr_api.g_varchar2) then

Line 541: If (p_rec.sub_information5 = hr_api.g_varchar2) then

537: If (p_rec.sub_information4 = hr_api.g_varchar2) then
538: p_rec.sub_information4 :=
539: per_sub_shd.g_old_rec.sub_information4;
540: End If;
541: If (p_rec.sub_information5 = hr_api.g_varchar2) then
542: p_rec.sub_information5 :=
543: per_sub_shd.g_old_rec.sub_information5;
544: End If;
545: If (p_rec.sub_information6 = hr_api.g_varchar2) then

Line 545: If (p_rec.sub_information6 = hr_api.g_varchar2) then

541: If (p_rec.sub_information5 = hr_api.g_varchar2) then
542: p_rec.sub_information5 :=
543: per_sub_shd.g_old_rec.sub_information5;
544: End If;
545: If (p_rec.sub_information6 = hr_api.g_varchar2) then
546: p_rec.sub_information6 :=
547: per_sub_shd.g_old_rec.sub_information6;
548: End If;
549: If (p_rec.sub_information7 = hr_api.g_varchar2) then

Line 549: If (p_rec.sub_information7 = hr_api.g_varchar2) then

545: If (p_rec.sub_information6 = hr_api.g_varchar2) then
546: p_rec.sub_information6 :=
547: per_sub_shd.g_old_rec.sub_information6;
548: End If;
549: If (p_rec.sub_information7 = hr_api.g_varchar2) then
550: p_rec.sub_information7 :=
551: per_sub_shd.g_old_rec.sub_information7;
552: End If;
553: If (p_rec.sub_information8 = hr_api.g_varchar2) then

Line 553: If (p_rec.sub_information8 = hr_api.g_varchar2) then

549: If (p_rec.sub_information7 = hr_api.g_varchar2) then
550: p_rec.sub_information7 :=
551: per_sub_shd.g_old_rec.sub_information7;
552: End If;
553: If (p_rec.sub_information8 = hr_api.g_varchar2) then
554: p_rec.sub_information8 :=
555: per_sub_shd.g_old_rec.sub_information8;
556: End If;
557: If (p_rec.sub_information9 = hr_api.g_varchar2) then

Line 557: If (p_rec.sub_information9 = hr_api.g_varchar2) then

553: If (p_rec.sub_information8 = hr_api.g_varchar2) then
554: p_rec.sub_information8 :=
555: per_sub_shd.g_old_rec.sub_information8;
556: End If;
557: If (p_rec.sub_information9 = hr_api.g_varchar2) then
558: p_rec.sub_information9 :=
559: per_sub_shd.g_old_rec.sub_information9;
560: End If;
561: If (p_rec.sub_information10 = hr_api.g_varchar2) then

Line 561: If (p_rec.sub_information10 = hr_api.g_varchar2) then

557: If (p_rec.sub_information9 = hr_api.g_varchar2) then
558: p_rec.sub_information9 :=
559: per_sub_shd.g_old_rec.sub_information9;
560: End If;
561: If (p_rec.sub_information10 = hr_api.g_varchar2) then
562: p_rec.sub_information10 :=
563: per_sub_shd.g_old_rec.sub_information10;
564: End If;
565: If (p_rec.sub_information11 = hr_api.g_varchar2) then

Line 565: If (p_rec.sub_information11 = hr_api.g_varchar2) then

561: If (p_rec.sub_information10 = hr_api.g_varchar2) then
562: p_rec.sub_information10 :=
563: per_sub_shd.g_old_rec.sub_information10;
564: End If;
565: If (p_rec.sub_information11 = hr_api.g_varchar2) then
566: p_rec.sub_information11 :=
567: per_sub_shd.g_old_rec.sub_information11;
568: End If;
569: If (p_rec.sub_information12 = hr_api.g_varchar2) then

Line 569: If (p_rec.sub_information12 = hr_api.g_varchar2) then

565: If (p_rec.sub_information11 = hr_api.g_varchar2) then
566: p_rec.sub_information11 :=
567: per_sub_shd.g_old_rec.sub_information11;
568: End If;
569: If (p_rec.sub_information12 = hr_api.g_varchar2) then
570: p_rec.sub_information12 :=
571: per_sub_shd.g_old_rec.sub_information12;
572: End If;
573: If (p_rec.sub_information13 = hr_api.g_varchar2) then

Line 573: If (p_rec.sub_information13 = hr_api.g_varchar2) then

569: If (p_rec.sub_information12 = hr_api.g_varchar2) then
570: p_rec.sub_information12 :=
571: per_sub_shd.g_old_rec.sub_information12;
572: End If;
573: If (p_rec.sub_information13 = hr_api.g_varchar2) then
574: p_rec.sub_information13 :=
575: per_sub_shd.g_old_rec.sub_information13;
576: End If;
577: If (p_rec.sub_information14 = hr_api.g_varchar2) then

Line 577: If (p_rec.sub_information14 = hr_api.g_varchar2) then

573: If (p_rec.sub_information13 = hr_api.g_varchar2) then
574: p_rec.sub_information13 :=
575: per_sub_shd.g_old_rec.sub_information13;
576: End If;
577: If (p_rec.sub_information14 = hr_api.g_varchar2) then
578: p_rec.sub_information14 :=
579: per_sub_shd.g_old_rec.sub_information14;
580: End If;
581: If (p_rec.sub_information15 = hr_api.g_varchar2) then

Line 581: If (p_rec.sub_information15 = hr_api.g_varchar2) then

577: If (p_rec.sub_information14 = hr_api.g_varchar2) then
578: p_rec.sub_information14 :=
579: per_sub_shd.g_old_rec.sub_information14;
580: End If;
581: If (p_rec.sub_information15 = hr_api.g_varchar2) then
582: p_rec.sub_information15 :=
583: per_sub_shd.g_old_rec.sub_information15;
584: End If;
585: If (p_rec.sub_information16 = hr_api.g_varchar2) then

Line 585: If (p_rec.sub_information16 = hr_api.g_varchar2) then

581: If (p_rec.sub_information15 = hr_api.g_varchar2) then
582: p_rec.sub_information15 :=
583: per_sub_shd.g_old_rec.sub_information15;
584: End If;
585: If (p_rec.sub_information16 = hr_api.g_varchar2) then
586: p_rec.sub_information16 :=
587: per_sub_shd.g_old_rec.sub_information16;
588: End If;
589: If (p_rec.sub_information17 = hr_api.g_varchar2) then

Line 589: If (p_rec.sub_information17 = hr_api.g_varchar2) then

585: If (p_rec.sub_information16 = hr_api.g_varchar2) then
586: p_rec.sub_information16 :=
587: per_sub_shd.g_old_rec.sub_information16;
588: End If;
589: If (p_rec.sub_information17 = hr_api.g_varchar2) then
590: p_rec.sub_information17 :=
591: per_sub_shd.g_old_rec.sub_information17;
592: End If;
593: If (p_rec.sub_information18 = hr_api.g_varchar2) then

Line 593: If (p_rec.sub_information18 = hr_api.g_varchar2) then

589: If (p_rec.sub_information17 = hr_api.g_varchar2) then
590: p_rec.sub_information17 :=
591: per_sub_shd.g_old_rec.sub_information17;
592: End If;
593: If (p_rec.sub_information18 = hr_api.g_varchar2) then
594: p_rec.sub_information18 :=
595: per_sub_shd.g_old_rec.sub_information18;
596: End If;
597: If (p_rec.sub_information19 = hr_api.g_varchar2) then

Line 597: If (p_rec.sub_information19 = hr_api.g_varchar2) then

593: If (p_rec.sub_information18 = hr_api.g_varchar2) then
594: p_rec.sub_information18 :=
595: per_sub_shd.g_old_rec.sub_information18;
596: End If;
597: If (p_rec.sub_information19 = hr_api.g_varchar2) then
598: p_rec.sub_information19 :=
599: per_sub_shd.g_old_rec.sub_information19;
600: End If;
601: If (p_rec.sub_information20 = hr_api.g_varchar2) then

Line 601: If (p_rec.sub_information20 = hr_api.g_varchar2) then

597: If (p_rec.sub_information19 = hr_api.g_varchar2) then
598: p_rec.sub_information19 :=
599: per_sub_shd.g_old_rec.sub_information19;
600: End If;
601: If (p_rec.sub_information20 = hr_api.g_varchar2) then
602: p_rec.sub_information20 :=
603: per_sub_shd.g_old_rec.sub_information20;
604: End If;
605: --

Line 666: Raise HR_Api.Validate_Enabled;

662: --
663: -- If we are validating then raise the Validate_Enabled exception
664: --
665: If p_validate then
666: Raise HR_Api.Validate_Enabled;
667: End If;
668: --
669: hr_utility.set_location(' Leaving:'||l_proc, 10);
670: Exception

Line 671: When HR_Api.Validate_Enabled Then

667: End If;
668: --
669: hr_utility.set_location(' Leaving:'||l_proc, 10);
670: Exception
671: When HR_Api.Validate_Enabled Then
672: --
673: -- As the Validate_Enabled exception has been raised
674: -- we must rollback to the savepoint
675: --

Line 685: p_start_date in date default hr_api.g_date,

681: -- ----------------------------------------------------------------------------
682: Procedure upd
683: (
684: p_subjects_taken_id in number,
685: p_start_date in date default hr_api.g_date,
686: p_major in varchar2 default hr_api.g_varchar2,
687: p_subject_status in varchar2 default hr_api.g_varchar2,
688: p_subject in varchar2 default hr_api.g_varchar2,
689: p_grade_attained in varchar2 default hr_api.g_varchar2,

Line 686: p_major in varchar2 default hr_api.g_varchar2,

682: Procedure upd
683: (
684: p_subjects_taken_id in number,
685: p_start_date in date default hr_api.g_date,
686: p_major in varchar2 default hr_api.g_varchar2,
687: p_subject_status in varchar2 default hr_api.g_varchar2,
688: p_subject in varchar2 default hr_api.g_varchar2,
689: p_grade_attained in varchar2 default hr_api.g_varchar2,
690: p_end_date in date default hr_api.g_date,

Line 687: p_subject_status in varchar2 default hr_api.g_varchar2,

683: (
684: p_subjects_taken_id in number,
685: p_start_date in date default hr_api.g_date,
686: p_major in varchar2 default hr_api.g_varchar2,
687: p_subject_status in varchar2 default hr_api.g_varchar2,
688: p_subject in varchar2 default hr_api.g_varchar2,
689: p_grade_attained in varchar2 default hr_api.g_varchar2,
690: p_end_date in date default hr_api.g_date,
691: p_qualification_id in number default hr_api.g_number,

Line 688: p_subject in varchar2 default hr_api.g_varchar2,

684: p_subjects_taken_id in number,
685: p_start_date in date default hr_api.g_date,
686: p_major in varchar2 default hr_api.g_varchar2,
687: p_subject_status in varchar2 default hr_api.g_varchar2,
688: p_subject in varchar2 default hr_api.g_varchar2,
689: p_grade_attained in varchar2 default hr_api.g_varchar2,
690: p_end_date in date default hr_api.g_date,
691: p_qualification_id in number default hr_api.g_number,
692: p_object_version_number in out nocopy number,

Line 689: p_grade_attained in varchar2 default hr_api.g_varchar2,

685: p_start_date in date default hr_api.g_date,
686: p_major in varchar2 default hr_api.g_varchar2,
687: p_subject_status in varchar2 default hr_api.g_varchar2,
688: p_subject in varchar2 default hr_api.g_varchar2,
689: p_grade_attained in varchar2 default hr_api.g_varchar2,
690: p_end_date in date default hr_api.g_date,
691: p_qualification_id in number default hr_api.g_number,
692: p_object_version_number in out nocopy number,
693: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 690: p_end_date in date default hr_api.g_date,

686: p_major in varchar2 default hr_api.g_varchar2,
687: p_subject_status in varchar2 default hr_api.g_varchar2,
688: p_subject in varchar2 default hr_api.g_varchar2,
689: p_grade_attained in varchar2 default hr_api.g_varchar2,
690: p_end_date in date default hr_api.g_date,
691: p_qualification_id in number default hr_api.g_number,
692: p_object_version_number in out nocopy number,
693: p_attribute_category in varchar2 default hr_api.g_varchar2,
694: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 691: p_qualification_id in number default hr_api.g_number,

687: p_subject_status in varchar2 default hr_api.g_varchar2,
688: p_subject in varchar2 default hr_api.g_varchar2,
689: p_grade_attained in varchar2 default hr_api.g_varchar2,
690: p_end_date in date default hr_api.g_date,
691: p_qualification_id in number default hr_api.g_number,
692: p_object_version_number in out nocopy number,
693: p_attribute_category in varchar2 default hr_api.g_varchar2,
694: p_attribute1 in varchar2 default hr_api.g_varchar2,
695: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 693: p_attribute_category in varchar2 default hr_api.g_varchar2,

689: p_grade_attained in varchar2 default hr_api.g_varchar2,
690: p_end_date in date default hr_api.g_date,
691: p_qualification_id in number default hr_api.g_number,
692: p_object_version_number in out nocopy number,
693: p_attribute_category in varchar2 default hr_api.g_varchar2,
694: p_attribute1 in varchar2 default hr_api.g_varchar2,
695: p_attribute2 in varchar2 default hr_api.g_varchar2,
696: p_attribute3 in varchar2 default hr_api.g_varchar2,
697: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 694: p_attribute1 in varchar2 default hr_api.g_varchar2,

690: p_end_date in date default hr_api.g_date,
691: p_qualification_id in number default hr_api.g_number,
692: p_object_version_number in out nocopy number,
693: p_attribute_category in varchar2 default hr_api.g_varchar2,
694: p_attribute1 in varchar2 default hr_api.g_varchar2,
695: p_attribute2 in varchar2 default hr_api.g_varchar2,
696: p_attribute3 in varchar2 default hr_api.g_varchar2,
697: p_attribute4 in varchar2 default hr_api.g_varchar2,
698: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 695: p_attribute2 in varchar2 default hr_api.g_varchar2,

691: p_qualification_id in number default hr_api.g_number,
692: p_object_version_number in out nocopy number,
693: p_attribute_category in varchar2 default hr_api.g_varchar2,
694: p_attribute1 in varchar2 default hr_api.g_varchar2,
695: p_attribute2 in varchar2 default hr_api.g_varchar2,
696: p_attribute3 in varchar2 default hr_api.g_varchar2,
697: p_attribute4 in varchar2 default hr_api.g_varchar2,
698: p_attribute5 in varchar2 default hr_api.g_varchar2,
699: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 696: p_attribute3 in varchar2 default hr_api.g_varchar2,

692: p_object_version_number in out nocopy number,
693: p_attribute_category in varchar2 default hr_api.g_varchar2,
694: p_attribute1 in varchar2 default hr_api.g_varchar2,
695: p_attribute2 in varchar2 default hr_api.g_varchar2,
696: p_attribute3 in varchar2 default hr_api.g_varchar2,
697: p_attribute4 in varchar2 default hr_api.g_varchar2,
698: p_attribute5 in varchar2 default hr_api.g_varchar2,
699: p_attribute6 in varchar2 default hr_api.g_varchar2,
700: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 697: p_attribute4 in varchar2 default hr_api.g_varchar2,

693: p_attribute_category in varchar2 default hr_api.g_varchar2,
694: p_attribute1 in varchar2 default hr_api.g_varchar2,
695: p_attribute2 in varchar2 default hr_api.g_varchar2,
696: p_attribute3 in varchar2 default hr_api.g_varchar2,
697: p_attribute4 in varchar2 default hr_api.g_varchar2,
698: p_attribute5 in varchar2 default hr_api.g_varchar2,
699: p_attribute6 in varchar2 default hr_api.g_varchar2,
700: p_attribute7 in varchar2 default hr_api.g_varchar2,
701: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 698: p_attribute5 in varchar2 default hr_api.g_varchar2,

694: p_attribute1 in varchar2 default hr_api.g_varchar2,
695: p_attribute2 in varchar2 default hr_api.g_varchar2,
696: p_attribute3 in varchar2 default hr_api.g_varchar2,
697: p_attribute4 in varchar2 default hr_api.g_varchar2,
698: p_attribute5 in varchar2 default hr_api.g_varchar2,
699: p_attribute6 in varchar2 default hr_api.g_varchar2,
700: p_attribute7 in varchar2 default hr_api.g_varchar2,
701: p_attribute8 in varchar2 default hr_api.g_varchar2,
702: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 699: p_attribute6 in varchar2 default hr_api.g_varchar2,

695: p_attribute2 in varchar2 default hr_api.g_varchar2,
696: p_attribute3 in varchar2 default hr_api.g_varchar2,
697: p_attribute4 in varchar2 default hr_api.g_varchar2,
698: p_attribute5 in varchar2 default hr_api.g_varchar2,
699: p_attribute6 in varchar2 default hr_api.g_varchar2,
700: p_attribute7 in varchar2 default hr_api.g_varchar2,
701: p_attribute8 in varchar2 default hr_api.g_varchar2,
702: p_attribute9 in varchar2 default hr_api.g_varchar2,
703: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 700: p_attribute7 in varchar2 default hr_api.g_varchar2,

696: p_attribute3 in varchar2 default hr_api.g_varchar2,
697: p_attribute4 in varchar2 default hr_api.g_varchar2,
698: p_attribute5 in varchar2 default hr_api.g_varchar2,
699: p_attribute6 in varchar2 default hr_api.g_varchar2,
700: p_attribute7 in varchar2 default hr_api.g_varchar2,
701: p_attribute8 in varchar2 default hr_api.g_varchar2,
702: p_attribute9 in varchar2 default hr_api.g_varchar2,
703: p_attribute10 in varchar2 default hr_api.g_varchar2,
704: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 701: p_attribute8 in varchar2 default hr_api.g_varchar2,

697: p_attribute4 in varchar2 default hr_api.g_varchar2,
698: p_attribute5 in varchar2 default hr_api.g_varchar2,
699: p_attribute6 in varchar2 default hr_api.g_varchar2,
700: p_attribute7 in varchar2 default hr_api.g_varchar2,
701: p_attribute8 in varchar2 default hr_api.g_varchar2,
702: p_attribute9 in varchar2 default hr_api.g_varchar2,
703: p_attribute10 in varchar2 default hr_api.g_varchar2,
704: p_attribute11 in varchar2 default hr_api.g_varchar2,
705: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 702: p_attribute9 in varchar2 default hr_api.g_varchar2,

698: p_attribute5 in varchar2 default hr_api.g_varchar2,
699: p_attribute6 in varchar2 default hr_api.g_varchar2,
700: p_attribute7 in varchar2 default hr_api.g_varchar2,
701: p_attribute8 in varchar2 default hr_api.g_varchar2,
702: p_attribute9 in varchar2 default hr_api.g_varchar2,
703: p_attribute10 in varchar2 default hr_api.g_varchar2,
704: p_attribute11 in varchar2 default hr_api.g_varchar2,
705: p_attribute12 in varchar2 default hr_api.g_varchar2,
706: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 703: p_attribute10 in varchar2 default hr_api.g_varchar2,

699: p_attribute6 in varchar2 default hr_api.g_varchar2,
700: p_attribute7 in varchar2 default hr_api.g_varchar2,
701: p_attribute8 in varchar2 default hr_api.g_varchar2,
702: p_attribute9 in varchar2 default hr_api.g_varchar2,
703: p_attribute10 in varchar2 default hr_api.g_varchar2,
704: p_attribute11 in varchar2 default hr_api.g_varchar2,
705: p_attribute12 in varchar2 default hr_api.g_varchar2,
706: p_attribute13 in varchar2 default hr_api.g_varchar2,
707: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 704: p_attribute11 in varchar2 default hr_api.g_varchar2,

700: p_attribute7 in varchar2 default hr_api.g_varchar2,
701: p_attribute8 in varchar2 default hr_api.g_varchar2,
702: p_attribute9 in varchar2 default hr_api.g_varchar2,
703: p_attribute10 in varchar2 default hr_api.g_varchar2,
704: p_attribute11 in varchar2 default hr_api.g_varchar2,
705: p_attribute12 in varchar2 default hr_api.g_varchar2,
706: p_attribute13 in varchar2 default hr_api.g_varchar2,
707: p_attribute14 in varchar2 default hr_api.g_varchar2,
708: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 705: p_attribute12 in varchar2 default hr_api.g_varchar2,

701: p_attribute8 in varchar2 default hr_api.g_varchar2,
702: p_attribute9 in varchar2 default hr_api.g_varchar2,
703: p_attribute10 in varchar2 default hr_api.g_varchar2,
704: p_attribute11 in varchar2 default hr_api.g_varchar2,
705: p_attribute12 in varchar2 default hr_api.g_varchar2,
706: p_attribute13 in varchar2 default hr_api.g_varchar2,
707: p_attribute14 in varchar2 default hr_api.g_varchar2,
708: p_attribute15 in varchar2 default hr_api.g_varchar2,
709: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 706: p_attribute13 in varchar2 default hr_api.g_varchar2,

702: p_attribute9 in varchar2 default hr_api.g_varchar2,
703: p_attribute10 in varchar2 default hr_api.g_varchar2,
704: p_attribute11 in varchar2 default hr_api.g_varchar2,
705: p_attribute12 in varchar2 default hr_api.g_varchar2,
706: p_attribute13 in varchar2 default hr_api.g_varchar2,
707: p_attribute14 in varchar2 default hr_api.g_varchar2,
708: p_attribute15 in varchar2 default hr_api.g_varchar2,
709: p_attribute16 in varchar2 default hr_api.g_varchar2,
710: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 707: p_attribute14 in varchar2 default hr_api.g_varchar2,

703: p_attribute10 in varchar2 default hr_api.g_varchar2,
704: p_attribute11 in varchar2 default hr_api.g_varchar2,
705: p_attribute12 in varchar2 default hr_api.g_varchar2,
706: p_attribute13 in varchar2 default hr_api.g_varchar2,
707: p_attribute14 in varchar2 default hr_api.g_varchar2,
708: p_attribute15 in varchar2 default hr_api.g_varchar2,
709: p_attribute16 in varchar2 default hr_api.g_varchar2,
710: p_attribute17 in varchar2 default hr_api.g_varchar2,
711: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 708: p_attribute15 in varchar2 default hr_api.g_varchar2,

704: p_attribute11 in varchar2 default hr_api.g_varchar2,
705: p_attribute12 in varchar2 default hr_api.g_varchar2,
706: p_attribute13 in varchar2 default hr_api.g_varchar2,
707: p_attribute14 in varchar2 default hr_api.g_varchar2,
708: p_attribute15 in varchar2 default hr_api.g_varchar2,
709: p_attribute16 in varchar2 default hr_api.g_varchar2,
710: p_attribute17 in varchar2 default hr_api.g_varchar2,
711: p_attribute18 in varchar2 default hr_api.g_varchar2,
712: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 709: p_attribute16 in varchar2 default hr_api.g_varchar2,

705: p_attribute12 in varchar2 default hr_api.g_varchar2,
706: p_attribute13 in varchar2 default hr_api.g_varchar2,
707: p_attribute14 in varchar2 default hr_api.g_varchar2,
708: p_attribute15 in varchar2 default hr_api.g_varchar2,
709: p_attribute16 in varchar2 default hr_api.g_varchar2,
710: p_attribute17 in varchar2 default hr_api.g_varchar2,
711: p_attribute18 in varchar2 default hr_api.g_varchar2,
712: p_attribute19 in varchar2 default hr_api.g_varchar2,
713: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 710: p_attribute17 in varchar2 default hr_api.g_varchar2,

706: p_attribute13 in varchar2 default hr_api.g_varchar2,
707: p_attribute14 in varchar2 default hr_api.g_varchar2,
708: p_attribute15 in varchar2 default hr_api.g_varchar2,
709: p_attribute16 in varchar2 default hr_api.g_varchar2,
710: p_attribute17 in varchar2 default hr_api.g_varchar2,
711: p_attribute18 in varchar2 default hr_api.g_varchar2,
712: p_attribute19 in varchar2 default hr_api.g_varchar2,
713: p_attribute20 in varchar2 default hr_api.g_varchar2,
714: p_sub_information_category in varchar2 default hr_api.g_varchar2,

Line 711: p_attribute18 in varchar2 default hr_api.g_varchar2,

707: p_attribute14 in varchar2 default hr_api.g_varchar2,
708: p_attribute15 in varchar2 default hr_api.g_varchar2,
709: p_attribute16 in varchar2 default hr_api.g_varchar2,
710: p_attribute17 in varchar2 default hr_api.g_varchar2,
711: p_attribute18 in varchar2 default hr_api.g_varchar2,
712: p_attribute19 in varchar2 default hr_api.g_varchar2,
713: p_attribute20 in varchar2 default hr_api.g_varchar2,
714: p_sub_information_category in varchar2 default hr_api.g_varchar2,
715: p_sub_information1 in varchar2 default hr_api.g_varchar2,

Line 712: p_attribute19 in varchar2 default hr_api.g_varchar2,

708: p_attribute15 in varchar2 default hr_api.g_varchar2,
709: p_attribute16 in varchar2 default hr_api.g_varchar2,
710: p_attribute17 in varchar2 default hr_api.g_varchar2,
711: p_attribute18 in varchar2 default hr_api.g_varchar2,
712: p_attribute19 in varchar2 default hr_api.g_varchar2,
713: p_attribute20 in varchar2 default hr_api.g_varchar2,
714: p_sub_information_category in varchar2 default hr_api.g_varchar2,
715: p_sub_information1 in varchar2 default hr_api.g_varchar2,
716: p_sub_information2 in varchar2 default hr_api.g_varchar2,

Line 713: p_attribute20 in varchar2 default hr_api.g_varchar2,

709: p_attribute16 in varchar2 default hr_api.g_varchar2,
710: p_attribute17 in varchar2 default hr_api.g_varchar2,
711: p_attribute18 in varchar2 default hr_api.g_varchar2,
712: p_attribute19 in varchar2 default hr_api.g_varchar2,
713: p_attribute20 in varchar2 default hr_api.g_varchar2,
714: p_sub_information_category in varchar2 default hr_api.g_varchar2,
715: p_sub_information1 in varchar2 default hr_api.g_varchar2,
716: p_sub_information2 in varchar2 default hr_api.g_varchar2,
717: p_sub_information3 in varchar2 default hr_api.g_varchar2,

Line 714: p_sub_information_category in varchar2 default hr_api.g_varchar2,

710: p_attribute17 in varchar2 default hr_api.g_varchar2,
711: p_attribute18 in varchar2 default hr_api.g_varchar2,
712: p_attribute19 in varchar2 default hr_api.g_varchar2,
713: p_attribute20 in varchar2 default hr_api.g_varchar2,
714: p_sub_information_category in varchar2 default hr_api.g_varchar2,
715: p_sub_information1 in varchar2 default hr_api.g_varchar2,
716: p_sub_information2 in varchar2 default hr_api.g_varchar2,
717: p_sub_information3 in varchar2 default hr_api.g_varchar2,
718: p_sub_information4 in varchar2 default hr_api.g_varchar2,

Line 715: p_sub_information1 in varchar2 default hr_api.g_varchar2,

711: p_attribute18 in varchar2 default hr_api.g_varchar2,
712: p_attribute19 in varchar2 default hr_api.g_varchar2,
713: p_attribute20 in varchar2 default hr_api.g_varchar2,
714: p_sub_information_category in varchar2 default hr_api.g_varchar2,
715: p_sub_information1 in varchar2 default hr_api.g_varchar2,
716: p_sub_information2 in varchar2 default hr_api.g_varchar2,
717: p_sub_information3 in varchar2 default hr_api.g_varchar2,
718: p_sub_information4 in varchar2 default hr_api.g_varchar2,
719: p_sub_information5 in varchar2 default hr_api.g_varchar2,

Line 716: p_sub_information2 in varchar2 default hr_api.g_varchar2,

712: p_attribute19 in varchar2 default hr_api.g_varchar2,
713: p_attribute20 in varchar2 default hr_api.g_varchar2,
714: p_sub_information_category in varchar2 default hr_api.g_varchar2,
715: p_sub_information1 in varchar2 default hr_api.g_varchar2,
716: p_sub_information2 in varchar2 default hr_api.g_varchar2,
717: p_sub_information3 in varchar2 default hr_api.g_varchar2,
718: p_sub_information4 in varchar2 default hr_api.g_varchar2,
719: p_sub_information5 in varchar2 default hr_api.g_varchar2,
720: p_sub_information6 in varchar2 default hr_api.g_varchar2,

Line 717: p_sub_information3 in varchar2 default hr_api.g_varchar2,

713: p_attribute20 in varchar2 default hr_api.g_varchar2,
714: p_sub_information_category in varchar2 default hr_api.g_varchar2,
715: p_sub_information1 in varchar2 default hr_api.g_varchar2,
716: p_sub_information2 in varchar2 default hr_api.g_varchar2,
717: p_sub_information3 in varchar2 default hr_api.g_varchar2,
718: p_sub_information4 in varchar2 default hr_api.g_varchar2,
719: p_sub_information5 in varchar2 default hr_api.g_varchar2,
720: p_sub_information6 in varchar2 default hr_api.g_varchar2,
721: p_sub_information7 in varchar2 default hr_api.g_varchar2,

Line 718: p_sub_information4 in varchar2 default hr_api.g_varchar2,

714: p_sub_information_category in varchar2 default hr_api.g_varchar2,
715: p_sub_information1 in varchar2 default hr_api.g_varchar2,
716: p_sub_information2 in varchar2 default hr_api.g_varchar2,
717: p_sub_information3 in varchar2 default hr_api.g_varchar2,
718: p_sub_information4 in varchar2 default hr_api.g_varchar2,
719: p_sub_information5 in varchar2 default hr_api.g_varchar2,
720: p_sub_information6 in varchar2 default hr_api.g_varchar2,
721: p_sub_information7 in varchar2 default hr_api.g_varchar2,
722: p_sub_information8 in varchar2 default hr_api.g_varchar2,

Line 719: p_sub_information5 in varchar2 default hr_api.g_varchar2,

715: p_sub_information1 in varchar2 default hr_api.g_varchar2,
716: p_sub_information2 in varchar2 default hr_api.g_varchar2,
717: p_sub_information3 in varchar2 default hr_api.g_varchar2,
718: p_sub_information4 in varchar2 default hr_api.g_varchar2,
719: p_sub_information5 in varchar2 default hr_api.g_varchar2,
720: p_sub_information6 in varchar2 default hr_api.g_varchar2,
721: p_sub_information7 in varchar2 default hr_api.g_varchar2,
722: p_sub_information8 in varchar2 default hr_api.g_varchar2,
723: p_sub_information9 in varchar2 default hr_api.g_varchar2,

Line 720: p_sub_information6 in varchar2 default hr_api.g_varchar2,

716: p_sub_information2 in varchar2 default hr_api.g_varchar2,
717: p_sub_information3 in varchar2 default hr_api.g_varchar2,
718: p_sub_information4 in varchar2 default hr_api.g_varchar2,
719: p_sub_information5 in varchar2 default hr_api.g_varchar2,
720: p_sub_information6 in varchar2 default hr_api.g_varchar2,
721: p_sub_information7 in varchar2 default hr_api.g_varchar2,
722: p_sub_information8 in varchar2 default hr_api.g_varchar2,
723: p_sub_information9 in varchar2 default hr_api.g_varchar2,
724: p_sub_information10 in varchar2 default hr_api.g_varchar2,

Line 721: p_sub_information7 in varchar2 default hr_api.g_varchar2,

717: p_sub_information3 in varchar2 default hr_api.g_varchar2,
718: p_sub_information4 in varchar2 default hr_api.g_varchar2,
719: p_sub_information5 in varchar2 default hr_api.g_varchar2,
720: p_sub_information6 in varchar2 default hr_api.g_varchar2,
721: p_sub_information7 in varchar2 default hr_api.g_varchar2,
722: p_sub_information8 in varchar2 default hr_api.g_varchar2,
723: p_sub_information9 in varchar2 default hr_api.g_varchar2,
724: p_sub_information10 in varchar2 default hr_api.g_varchar2,
725: p_sub_information11 in varchar2 default hr_api.g_varchar2,

Line 722: p_sub_information8 in varchar2 default hr_api.g_varchar2,

718: p_sub_information4 in varchar2 default hr_api.g_varchar2,
719: p_sub_information5 in varchar2 default hr_api.g_varchar2,
720: p_sub_information6 in varchar2 default hr_api.g_varchar2,
721: p_sub_information7 in varchar2 default hr_api.g_varchar2,
722: p_sub_information8 in varchar2 default hr_api.g_varchar2,
723: p_sub_information9 in varchar2 default hr_api.g_varchar2,
724: p_sub_information10 in varchar2 default hr_api.g_varchar2,
725: p_sub_information11 in varchar2 default hr_api.g_varchar2,
726: p_sub_information12 in varchar2 default hr_api.g_varchar2,

Line 723: p_sub_information9 in varchar2 default hr_api.g_varchar2,

719: p_sub_information5 in varchar2 default hr_api.g_varchar2,
720: p_sub_information6 in varchar2 default hr_api.g_varchar2,
721: p_sub_information7 in varchar2 default hr_api.g_varchar2,
722: p_sub_information8 in varchar2 default hr_api.g_varchar2,
723: p_sub_information9 in varchar2 default hr_api.g_varchar2,
724: p_sub_information10 in varchar2 default hr_api.g_varchar2,
725: p_sub_information11 in varchar2 default hr_api.g_varchar2,
726: p_sub_information12 in varchar2 default hr_api.g_varchar2,
727: p_sub_information13 in varchar2 default hr_api.g_varchar2,

Line 724: p_sub_information10 in varchar2 default hr_api.g_varchar2,

720: p_sub_information6 in varchar2 default hr_api.g_varchar2,
721: p_sub_information7 in varchar2 default hr_api.g_varchar2,
722: p_sub_information8 in varchar2 default hr_api.g_varchar2,
723: p_sub_information9 in varchar2 default hr_api.g_varchar2,
724: p_sub_information10 in varchar2 default hr_api.g_varchar2,
725: p_sub_information11 in varchar2 default hr_api.g_varchar2,
726: p_sub_information12 in varchar2 default hr_api.g_varchar2,
727: p_sub_information13 in varchar2 default hr_api.g_varchar2,
728: p_sub_information14 in varchar2 default hr_api.g_varchar2,

Line 725: p_sub_information11 in varchar2 default hr_api.g_varchar2,

721: p_sub_information7 in varchar2 default hr_api.g_varchar2,
722: p_sub_information8 in varchar2 default hr_api.g_varchar2,
723: p_sub_information9 in varchar2 default hr_api.g_varchar2,
724: p_sub_information10 in varchar2 default hr_api.g_varchar2,
725: p_sub_information11 in varchar2 default hr_api.g_varchar2,
726: p_sub_information12 in varchar2 default hr_api.g_varchar2,
727: p_sub_information13 in varchar2 default hr_api.g_varchar2,
728: p_sub_information14 in varchar2 default hr_api.g_varchar2,
729: p_sub_information15 in varchar2 default hr_api.g_varchar2,

Line 726: p_sub_information12 in varchar2 default hr_api.g_varchar2,

722: p_sub_information8 in varchar2 default hr_api.g_varchar2,
723: p_sub_information9 in varchar2 default hr_api.g_varchar2,
724: p_sub_information10 in varchar2 default hr_api.g_varchar2,
725: p_sub_information11 in varchar2 default hr_api.g_varchar2,
726: p_sub_information12 in varchar2 default hr_api.g_varchar2,
727: p_sub_information13 in varchar2 default hr_api.g_varchar2,
728: p_sub_information14 in varchar2 default hr_api.g_varchar2,
729: p_sub_information15 in varchar2 default hr_api.g_varchar2,
730: p_sub_information16 in varchar2 default hr_api.g_varchar2,

Line 727: p_sub_information13 in varchar2 default hr_api.g_varchar2,

723: p_sub_information9 in varchar2 default hr_api.g_varchar2,
724: p_sub_information10 in varchar2 default hr_api.g_varchar2,
725: p_sub_information11 in varchar2 default hr_api.g_varchar2,
726: p_sub_information12 in varchar2 default hr_api.g_varchar2,
727: p_sub_information13 in varchar2 default hr_api.g_varchar2,
728: p_sub_information14 in varchar2 default hr_api.g_varchar2,
729: p_sub_information15 in varchar2 default hr_api.g_varchar2,
730: p_sub_information16 in varchar2 default hr_api.g_varchar2,
731: p_sub_information17 in varchar2 default hr_api.g_varchar2,

Line 728: p_sub_information14 in varchar2 default hr_api.g_varchar2,

724: p_sub_information10 in varchar2 default hr_api.g_varchar2,
725: p_sub_information11 in varchar2 default hr_api.g_varchar2,
726: p_sub_information12 in varchar2 default hr_api.g_varchar2,
727: p_sub_information13 in varchar2 default hr_api.g_varchar2,
728: p_sub_information14 in varchar2 default hr_api.g_varchar2,
729: p_sub_information15 in varchar2 default hr_api.g_varchar2,
730: p_sub_information16 in varchar2 default hr_api.g_varchar2,
731: p_sub_information17 in varchar2 default hr_api.g_varchar2,
732: p_sub_information18 in varchar2 default hr_api.g_varchar2,

Line 729: p_sub_information15 in varchar2 default hr_api.g_varchar2,

725: p_sub_information11 in varchar2 default hr_api.g_varchar2,
726: p_sub_information12 in varchar2 default hr_api.g_varchar2,
727: p_sub_information13 in varchar2 default hr_api.g_varchar2,
728: p_sub_information14 in varchar2 default hr_api.g_varchar2,
729: p_sub_information15 in varchar2 default hr_api.g_varchar2,
730: p_sub_information16 in varchar2 default hr_api.g_varchar2,
731: p_sub_information17 in varchar2 default hr_api.g_varchar2,
732: p_sub_information18 in varchar2 default hr_api.g_varchar2,
733: p_sub_information19 in varchar2 default hr_api.g_varchar2,

Line 730: p_sub_information16 in varchar2 default hr_api.g_varchar2,

726: p_sub_information12 in varchar2 default hr_api.g_varchar2,
727: p_sub_information13 in varchar2 default hr_api.g_varchar2,
728: p_sub_information14 in varchar2 default hr_api.g_varchar2,
729: p_sub_information15 in varchar2 default hr_api.g_varchar2,
730: p_sub_information16 in varchar2 default hr_api.g_varchar2,
731: p_sub_information17 in varchar2 default hr_api.g_varchar2,
732: p_sub_information18 in varchar2 default hr_api.g_varchar2,
733: p_sub_information19 in varchar2 default hr_api.g_varchar2,
734: p_sub_information20 in varchar2 default hr_api.g_varchar2,

Line 731: p_sub_information17 in varchar2 default hr_api.g_varchar2,

727: p_sub_information13 in varchar2 default hr_api.g_varchar2,
728: p_sub_information14 in varchar2 default hr_api.g_varchar2,
729: p_sub_information15 in varchar2 default hr_api.g_varchar2,
730: p_sub_information16 in varchar2 default hr_api.g_varchar2,
731: p_sub_information17 in varchar2 default hr_api.g_varchar2,
732: p_sub_information18 in varchar2 default hr_api.g_varchar2,
733: p_sub_information19 in varchar2 default hr_api.g_varchar2,
734: p_sub_information20 in varchar2 default hr_api.g_varchar2,
735: p_effective_date in date,

Line 732: p_sub_information18 in varchar2 default hr_api.g_varchar2,

728: p_sub_information14 in varchar2 default hr_api.g_varchar2,
729: p_sub_information15 in varchar2 default hr_api.g_varchar2,
730: p_sub_information16 in varchar2 default hr_api.g_varchar2,
731: p_sub_information17 in varchar2 default hr_api.g_varchar2,
732: p_sub_information18 in varchar2 default hr_api.g_varchar2,
733: p_sub_information19 in varchar2 default hr_api.g_varchar2,
734: p_sub_information20 in varchar2 default hr_api.g_varchar2,
735: p_effective_date in date,
736: p_validate in boolean default false

Line 733: p_sub_information19 in varchar2 default hr_api.g_varchar2,

729: p_sub_information15 in varchar2 default hr_api.g_varchar2,
730: p_sub_information16 in varchar2 default hr_api.g_varchar2,
731: p_sub_information17 in varchar2 default hr_api.g_varchar2,
732: p_sub_information18 in varchar2 default hr_api.g_varchar2,
733: p_sub_information19 in varchar2 default hr_api.g_varchar2,
734: p_sub_information20 in varchar2 default hr_api.g_varchar2,
735: p_effective_date in date,
736: p_validate in boolean default false
737: ) is

Line 734: p_sub_information20 in varchar2 default hr_api.g_varchar2,

730: p_sub_information16 in varchar2 default hr_api.g_varchar2,
731: p_sub_information17 in varchar2 default hr_api.g_varchar2,
732: p_sub_information18 in varchar2 default hr_api.g_varchar2,
733: p_sub_information19 in varchar2 default hr_api.g_varchar2,
734: p_sub_information20 in varchar2 default hr_api.g_varchar2,
735: p_effective_date in date,
736: p_validate in boolean default false
737: ) is
738: --