eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_QUA_UPD dependencies on HR_API

Line 151: When hr_api.check_integrity_violated Then

147: --
148: hr_utility.set_location(' Leaving:'||l_proc, 10);
149: --
150: Exception
151: When hr_api.check_integrity_violated Then
152: -- A check constraint has been violated
153: per_qua_shd.g_api_dml := false; -- Unset the api dml status
154: per_qua_shd.constraint_error
155: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

151: When hr_api.check_integrity_violated Then
152: -- A check constraint has been violated
153: per_qua_shd.g_api_dml := false; -- Unset the api dml status
154: per_qua_shd.constraint_error
155: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
156: When hr_api.parent_integrity_violated Then
157: -- Parent integrity has been violated
158: per_qua_shd.g_api_dml := false; -- Unset the api dml status
159: per_qua_shd.constraint_error

Line 156: When hr_api.parent_integrity_violated Then

152: -- A check constraint has been violated
153: per_qua_shd.g_api_dml := false; -- Unset the api dml status
154: per_qua_shd.constraint_error
155: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
156: When hr_api.parent_integrity_violated Then
157: -- Parent integrity has been violated
158: per_qua_shd.g_api_dml := false; -- Unset the api dml status
159: per_qua_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

156: When hr_api.parent_integrity_violated Then
157: -- Parent integrity has been violated
158: per_qua_shd.g_api_dml := false; -- Unset the api dml status
159: per_qua_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.unique_integrity_violated Then
162: -- Unique integrity has been violated
163: per_qua_shd.g_api_dml := false; -- Unset the api dml status
164: per_qua_shd.constraint_error

Line 161: When hr_api.unique_integrity_violated Then

157: -- Parent integrity has been violated
158: per_qua_shd.g_api_dml := false; -- Unset the api dml status
159: per_qua_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.unique_integrity_violated Then
162: -- Unique integrity has been violated
163: per_qua_shd.g_api_dml := false; -- Unset the api dml status
164: per_qua_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

161: When hr_api.unique_integrity_violated Then
162: -- Unique integrity has been violated
163: per_qua_shd.g_api_dml := false; -- Unset the api dml status
164: per_qua_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When Others Then
167: per_qua_shd.g_api_dml := false; -- Unset the api dml status
168: Raise;
169: End update_dml;

Line 406: when hr_api.cannot_find_prog_unit then

402: p_subscription_payment_meth_o => per_qua_shd.g_old_rec.subscription_payment_method,
403: p_party_id_o => per_qua_shd.g_old_rec.party_id
404: );
405: exception
406: when hr_api.cannot_find_prog_unit then
407: hr_api.cannot_find_prog_unit_error
408: (p_module_name => 'PER_QUALIFICATIONS'
409: ,p_hook_type => 'AU'
410: );

Line 407: hr_api.cannot_find_prog_unit_error

403: p_party_id_o => per_qua_shd.g_old_rec.party_id
404: );
405: exception
406: when hr_api.cannot_find_prog_unit then
407: hr_api.cannot_find_prog_unit_error
408: (p_module_name => 'PER_QUALIFICATIONS'
409: ,p_hook_type => 'AU'
410: );
411: end;

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

471: -- p_rec plsql record structure
472: -- to see if a system default is being used. If a system default
473: -- is being used then we must set to the 'current' argument value.
474: --
475: If (p_rec.business_group_id = hr_api.g_number) then
476: p_rec.business_group_id :=
477: per_qua_shd.g_old_rec.business_group_id;
478: End If;
479: If (p_rec.person_id = hr_api.g_number) then

Line 479: If (p_rec.person_id = hr_api.g_number) then

475: If (p_rec.business_group_id = hr_api.g_number) then
476: p_rec.business_group_id :=
477: per_qua_shd.g_old_rec.business_group_id;
478: End If;
479: If (p_rec.person_id = hr_api.g_number) then
480: p_rec.person_id :=
481: per_qua_shd.g_old_rec.person_id;
482: End If;
483: If (p_rec.title = hr_api.g_varchar2) then

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

479: If (p_rec.person_id = hr_api.g_number) then
480: p_rec.person_id :=
481: per_qua_shd.g_old_rec.person_id;
482: End If;
483: If (p_rec.title = hr_api.g_varchar2) then
484: p_rec.title :=
485: per_qua_shd.g_old_rec.title;
486: End If;
487: If (p_rec.grade_attained = hr_api.g_varchar2) then

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

483: If (p_rec.title = hr_api.g_varchar2) then
484: p_rec.title :=
485: per_qua_shd.g_old_rec.title;
486: End If;
487: If (p_rec.grade_attained = hr_api.g_varchar2) then
488: p_rec.grade_attained :=
489: per_qua_shd.g_old_rec.grade_attained;
490: End If;
491: If (p_rec.status = hr_api.g_varchar2) then

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

487: If (p_rec.grade_attained = hr_api.g_varchar2) then
488: p_rec.grade_attained :=
489: per_qua_shd.g_old_rec.grade_attained;
490: End If;
491: If (p_rec.status = hr_api.g_varchar2) then
492: p_rec.status :=
493: per_qua_shd.g_old_rec.status;
494: End If;
495: If (p_rec.awarded_date = hr_api.g_date) then

Line 495: If (p_rec.awarded_date = hr_api.g_date) then

491: If (p_rec.status = hr_api.g_varchar2) then
492: p_rec.status :=
493: per_qua_shd.g_old_rec.status;
494: End If;
495: If (p_rec.awarded_date = hr_api.g_date) then
496: p_rec.awarded_date :=
497: per_qua_shd.g_old_rec.awarded_date;
498: End If;
499: If (p_rec.fee = hr_api.g_number) then

Line 499: If (p_rec.fee = hr_api.g_number) then

495: If (p_rec.awarded_date = hr_api.g_date) then
496: p_rec.awarded_date :=
497: per_qua_shd.g_old_rec.awarded_date;
498: End If;
499: If (p_rec.fee = hr_api.g_number) then
500: p_rec.fee :=
501: per_qua_shd.g_old_rec.fee;
502: End If;
503: If (p_rec.fee_currency = hr_api.g_varchar2) then

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

499: If (p_rec.fee = hr_api.g_number) then
500: p_rec.fee :=
501: per_qua_shd.g_old_rec.fee;
502: End If;
503: If (p_rec.fee_currency = hr_api.g_varchar2) then
504: p_rec.fee_currency :=
505: per_qua_shd.g_old_rec.fee_currency;
506: End If;
507: If (p_rec.training_completed_amount = hr_api.g_number) then

Line 507: If (p_rec.training_completed_amount = hr_api.g_number) then

503: If (p_rec.fee_currency = hr_api.g_varchar2) then
504: p_rec.fee_currency :=
505: per_qua_shd.g_old_rec.fee_currency;
506: End If;
507: If (p_rec.training_completed_amount = hr_api.g_number) then
508: p_rec.training_completed_amount :=
509: per_qua_shd.g_old_rec.training_completed_amount;
510: End If;
511: If (p_rec.reimbursement_arrangements = hr_api.g_varchar2) then

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

507: If (p_rec.training_completed_amount = hr_api.g_number) then
508: p_rec.training_completed_amount :=
509: per_qua_shd.g_old_rec.training_completed_amount;
510: End If;
511: If (p_rec.reimbursement_arrangements = hr_api.g_varchar2) then
512: p_rec.reimbursement_arrangements :=
513: per_qua_shd.g_old_rec.reimbursement_arrangements;
514: End If;
515: If (p_rec.training_completed_units = hr_api.g_varchar2) then

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

511: If (p_rec.reimbursement_arrangements = hr_api.g_varchar2) then
512: p_rec.reimbursement_arrangements :=
513: per_qua_shd.g_old_rec.reimbursement_arrangements;
514: End If;
515: If (p_rec.training_completed_units = hr_api.g_varchar2) then
516: p_rec.training_completed_units :=
517: per_qua_shd.g_old_rec.training_completed_units;
518: End If;
519: If (p_rec.total_training_amount = hr_api.g_number) then

Line 519: If (p_rec.total_training_amount = hr_api.g_number) then

515: If (p_rec.training_completed_units = hr_api.g_varchar2) then
516: p_rec.training_completed_units :=
517: per_qua_shd.g_old_rec.training_completed_units;
518: End If;
519: If (p_rec.total_training_amount = hr_api.g_number) then
520: p_rec.total_training_amount :=
521: per_qua_shd.g_old_rec.total_training_amount;
522: End If;
523: If (p_rec.start_date = hr_api.g_date) then

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

519: If (p_rec.total_training_amount = hr_api.g_number) then
520: p_rec.total_training_amount :=
521: per_qua_shd.g_old_rec.total_training_amount;
522: End If;
523: If (p_rec.start_date = hr_api.g_date) then
524: p_rec.start_date :=
525: per_qua_shd.g_old_rec.start_date;
526: End If;
527: If (p_rec.end_date = hr_api.g_date) then

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

523: If (p_rec.start_date = hr_api.g_date) then
524: p_rec.start_date :=
525: per_qua_shd.g_old_rec.start_date;
526: End If;
527: If (p_rec.end_date = hr_api.g_date) then
528: p_rec.end_date :=
529: per_qua_shd.g_old_rec.end_date;
530: End If;
531: If (p_rec.license_number = hr_api.g_varchar2) then

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

527: If (p_rec.end_date = hr_api.g_date) then
528: p_rec.end_date :=
529: per_qua_shd.g_old_rec.end_date;
530: End If;
531: If (p_rec.license_number = hr_api.g_varchar2) then
532: p_rec.license_number :=
533: per_qua_shd.g_old_rec.license_number;
534: End If;
535: If (p_rec.expiry_date = hr_api.g_date) then

Line 535: If (p_rec.expiry_date = hr_api.g_date) then

531: If (p_rec.license_number = hr_api.g_varchar2) then
532: p_rec.license_number :=
533: per_qua_shd.g_old_rec.license_number;
534: End If;
535: If (p_rec.expiry_date = hr_api.g_date) then
536: p_rec.expiry_date :=
537: per_qua_shd.g_old_rec.expiry_date;
538: End If;
539: If (p_rec.license_restrictions = hr_api.g_varchar2) then

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

535: If (p_rec.expiry_date = hr_api.g_date) then
536: p_rec.expiry_date :=
537: per_qua_shd.g_old_rec.expiry_date;
538: End If;
539: If (p_rec.license_restrictions = hr_api.g_varchar2) then
540: p_rec.license_restrictions :=
541: per_qua_shd.g_old_rec.license_restrictions;
542: End If;
543: If (p_rec.projected_completion_date = hr_api.g_date) then

Line 543: If (p_rec.projected_completion_date = hr_api.g_date) then

539: If (p_rec.license_restrictions = hr_api.g_varchar2) then
540: p_rec.license_restrictions :=
541: per_qua_shd.g_old_rec.license_restrictions;
542: End If;
543: If (p_rec.projected_completion_date = hr_api.g_date) then
544: p_rec.projected_completion_date :=
545: per_qua_shd.g_old_rec.projected_completion_date;
546: End If;
547: If (p_rec.awarding_body = hr_api.g_varchar2) then

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

543: If (p_rec.projected_completion_date = hr_api.g_date) then
544: p_rec.projected_completion_date :=
545: per_qua_shd.g_old_rec.projected_completion_date;
546: End If;
547: If (p_rec.awarding_body = hr_api.g_varchar2) then
548: p_rec.awarding_body :=
549: per_qua_shd.g_old_rec.awarding_body;
550: End If;
551: If (p_rec.tuition_method = hr_api.g_varchar2) then

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

547: If (p_rec.awarding_body = hr_api.g_varchar2) then
548: p_rec.awarding_body :=
549: per_qua_shd.g_old_rec.awarding_body;
550: End If;
551: If (p_rec.tuition_method = hr_api.g_varchar2) then
552: p_rec.tuition_method :=
553: per_qua_shd.g_old_rec.tuition_method;
554: End If;
555: If (p_rec.group_ranking = hr_api.g_varchar2) then

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

551: If (p_rec.tuition_method = hr_api.g_varchar2) then
552: p_rec.tuition_method :=
553: per_qua_shd.g_old_rec.tuition_method;
554: End If;
555: If (p_rec.group_ranking = hr_api.g_varchar2) then
556: p_rec.group_ranking :=
557: per_qua_shd.g_old_rec.group_ranking;
558: End If;
559: If (p_rec.comments = hr_api.g_varchar2) then

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

555: If (p_rec.group_ranking = hr_api.g_varchar2) then
556: p_rec.group_ranking :=
557: per_qua_shd.g_old_rec.group_ranking;
558: End If;
559: If (p_rec.comments = hr_api.g_varchar2) then
560: p_rec.comments :=
561: per_qua_shd.g_old_rec.comments;
562: End If;
563: If (p_rec.qualification_type_id = hr_api.g_number) then

Line 563: If (p_rec.qualification_type_id = hr_api.g_number) then

559: If (p_rec.comments = hr_api.g_varchar2) then
560: p_rec.comments :=
561: per_qua_shd.g_old_rec.comments;
562: End If;
563: If (p_rec.qualification_type_id = hr_api.g_number) then
564: p_rec.qualification_type_id :=
565: per_qua_shd.g_old_rec.qualification_type_id;
566: End If;
567: If (p_rec.attendance_id = hr_api.g_number) then

Line 567: If (p_rec.attendance_id = hr_api.g_number) then

563: If (p_rec.qualification_type_id = hr_api.g_number) then
564: p_rec.qualification_type_id :=
565: per_qua_shd.g_old_rec.qualification_type_id;
566: End If;
567: If (p_rec.attendance_id = hr_api.g_number) then
568: p_rec.attendance_id :=
569: per_qua_shd.g_old_rec.attendance_id;
570: End If;
571: If (p_rec.attribute_category = hr_api.g_varchar2) then

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

567: If (p_rec.attendance_id = hr_api.g_number) then
568: p_rec.attendance_id :=
569: per_qua_shd.g_old_rec.attendance_id;
570: End If;
571: If (p_rec.attribute_category = hr_api.g_varchar2) then
572: p_rec.attribute_category :=
573: per_qua_shd.g_old_rec.attribute_category;
574: End If;
575: If (p_rec.attribute1 = hr_api.g_varchar2) then

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

571: If (p_rec.attribute_category = hr_api.g_varchar2) then
572: p_rec.attribute_category :=
573: per_qua_shd.g_old_rec.attribute_category;
574: End If;
575: If (p_rec.attribute1 = hr_api.g_varchar2) then
576: p_rec.attribute1 :=
577: per_qua_shd.g_old_rec.attribute1;
578: End If;
579: If (p_rec.attribute2 = hr_api.g_varchar2) then

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

575: If (p_rec.attribute1 = hr_api.g_varchar2) then
576: p_rec.attribute1 :=
577: per_qua_shd.g_old_rec.attribute1;
578: End If;
579: If (p_rec.attribute2 = hr_api.g_varchar2) then
580: p_rec.attribute2 :=
581: per_qua_shd.g_old_rec.attribute2;
582: End If;
583: If (p_rec.attribute3 = hr_api.g_varchar2) then

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

579: If (p_rec.attribute2 = hr_api.g_varchar2) then
580: p_rec.attribute2 :=
581: per_qua_shd.g_old_rec.attribute2;
582: End If;
583: If (p_rec.attribute3 = hr_api.g_varchar2) then
584: p_rec.attribute3 :=
585: per_qua_shd.g_old_rec.attribute3;
586: End If;
587: If (p_rec.attribute4 = hr_api.g_varchar2) then

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

583: If (p_rec.attribute3 = hr_api.g_varchar2) then
584: p_rec.attribute3 :=
585: per_qua_shd.g_old_rec.attribute3;
586: End If;
587: If (p_rec.attribute4 = hr_api.g_varchar2) then
588: p_rec.attribute4 :=
589: per_qua_shd.g_old_rec.attribute4;
590: End If;
591: If (p_rec.attribute5 = hr_api.g_varchar2) then

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

587: If (p_rec.attribute4 = hr_api.g_varchar2) then
588: p_rec.attribute4 :=
589: per_qua_shd.g_old_rec.attribute4;
590: End If;
591: If (p_rec.attribute5 = hr_api.g_varchar2) then
592: p_rec.attribute5 :=
593: per_qua_shd.g_old_rec.attribute5;
594: End If;
595: If (p_rec.attribute6 = hr_api.g_varchar2) then

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

591: If (p_rec.attribute5 = hr_api.g_varchar2) then
592: p_rec.attribute5 :=
593: per_qua_shd.g_old_rec.attribute5;
594: End If;
595: If (p_rec.attribute6 = hr_api.g_varchar2) then
596: p_rec.attribute6 :=
597: per_qua_shd.g_old_rec.attribute6;
598: End If;
599: If (p_rec.attribute7 = hr_api.g_varchar2) then

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

595: If (p_rec.attribute6 = hr_api.g_varchar2) then
596: p_rec.attribute6 :=
597: per_qua_shd.g_old_rec.attribute6;
598: End If;
599: If (p_rec.attribute7 = hr_api.g_varchar2) then
600: p_rec.attribute7 :=
601: per_qua_shd.g_old_rec.attribute7;
602: End If;
603: If (p_rec.attribute8 = hr_api.g_varchar2) then

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

599: If (p_rec.attribute7 = hr_api.g_varchar2) then
600: p_rec.attribute7 :=
601: per_qua_shd.g_old_rec.attribute7;
602: End If;
603: If (p_rec.attribute8 = hr_api.g_varchar2) then
604: p_rec.attribute8 :=
605: per_qua_shd.g_old_rec.attribute8;
606: End If;
607: If (p_rec.attribute9 = hr_api.g_varchar2) then

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

603: If (p_rec.attribute8 = hr_api.g_varchar2) then
604: p_rec.attribute8 :=
605: per_qua_shd.g_old_rec.attribute8;
606: End If;
607: If (p_rec.attribute9 = hr_api.g_varchar2) then
608: p_rec.attribute9 :=
609: per_qua_shd.g_old_rec.attribute9;
610: End If;
611: If (p_rec.attribute10 = hr_api.g_varchar2) then

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

607: If (p_rec.attribute9 = hr_api.g_varchar2) then
608: p_rec.attribute9 :=
609: per_qua_shd.g_old_rec.attribute9;
610: End If;
611: If (p_rec.attribute10 = hr_api.g_varchar2) then
612: p_rec.attribute10 :=
613: per_qua_shd.g_old_rec.attribute10;
614: End If;
615: If (p_rec.attribute11 = hr_api.g_varchar2) then

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

611: If (p_rec.attribute10 = hr_api.g_varchar2) then
612: p_rec.attribute10 :=
613: per_qua_shd.g_old_rec.attribute10;
614: End If;
615: If (p_rec.attribute11 = hr_api.g_varchar2) then
616: p_rec.attribute11 :=
617: per_qua_shd.g_old_rec.attribute11;
618: End If;
619: If (p_rec.attribute12 = hr_api.g_varchar2) then

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

615: If (p_rec.attribute11 = hr_api.g_varchar2) then
616: p_rec.attribute11 :=
617: per_qua_shd.g_old_rec.attribute11;
618: End If;
619: If (p_rec.attribute12 = hr_api.g_varchar2) then
620: p_rec.attribute12 :=
621: per_qua_shd.g_old_rec.attribute12;
622: End If;
623: If (p_rec.attribute13 = hr_api.g_varchar2) then

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

619: If (p_rec.attribute12 = hr_api.g_varchar2) then
620: p_rec.attribute12 :=
621: per_qua_shd.g_old_rec.attribute12;
622: End If;
623: If (p_rec.attribute13 = hr_api.g_varchar2) then
624: p_rec.attribute13 :=
625: per_qua_shd.g_old_rec.attribute13;
626: End If;
627: If (p_rec.attribute14 = hr_api.g_varchar2) then

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

623: If (p_rec.attribute13 = hr_api.g_varchar2) then
624: p_rec.attribute13 :=
625: per_qua_shd.g_old_rec.attribute13;
626: End If;
627: If (p_rec.attribute14 = hr_api.g_varchar2) then
628: p_rec.attribute14 :=
629: per_qua_shd.g_old_rec.attribute14;
630: End If;
631: If (p_rec.attribute15 = hr_api.g_varchar2) then

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

627: If (p_rec.attribute14 = hr_api.g_varchar2) then
628: p_rec.attribute14 :=
629: per_qua_shd.g_old_rec.attribute14;
630: End If;
631: If (p_rec.attribute15 = hr_api.g_varchar2) then
632: p_rec.attribute15 :=
633: per_qua_shd.g_old_rec.attribute15;
634: End If;
635: If (p_rec.attribute16 = hr_api.g_varchar2) then

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

631: If (p_rec.attribute15 = hr_api.g_varchar2) then
632: p_rec.attribute15 :=
633: per_qua_shd.g_old_rec.attribute15;
634: End If;
635: If (p_rec.attribute16 = hr_api.g_varchar2) then
636: p_rec.attribute16 :=
637: per_qua_shd.g_old_rec.attribute16;
638: End If;
639: If (p_rec.attribute17 = hr_api.g_varchar2) then

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

635: If (p_rec.attribute16 = hr_api.g_varchar2) then
636: p_rec.attribute16 :=
637: per_qua_shd.g_old_rec.attribute16;
638: End If;
639: If (p_rec.attribute17 = hr_api.g_varchar2) then
640: p_rec.attribute17 :=
641: per_qua_shd.g_old_rec.attribute17;
642: End If;
643: If (p_rec.attribute18 = hr_api.g_varchar2) then

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

639: If (p_rec.attribute17 = hr_api.g_varchar2) then
640: p_rec.attribute17 :=
641: per_qua_shd.g_old_rec.attribute17;
642: End If;
643: If (p_rec.attribute18 = hr_api.g_varchar2) then
644: p_rec.attribute18 :=
645: per_qua_shd.g_old_rec.attribute18;
646: End If;
647: If (p_rec.attribute19 = hr_api.g_varchar2) then

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

643: If (p_rec.attribute18 = hr_api.g_varchar2) then
644: p_rec.attribute18 :=
645: per_qua_shd.g_old_rec.attribute18;
646: End If;
647: If (p_rec.attribute19 = hr_api.g_varchar2) then
648: p_rec.attribute19 :=
649: per_qua_shd.g_old_rec.attribute19;
650: End If;
651: If (p_rec.attribute20 = hr_api.g_varchar2) then

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

647: If (p_rec.attribute19 = hr_api.g_varchar2) then
648: p_rec.attribute19 :=
649: per_qua_shd.g_old_rec.attribute19;
650: End If;
651: If (p_rec.attribute20 = hr_api.g_varchar2) then
652: p_rec.attribute20 :=
653: per_qua_shd.g_old_rec.attribute20;
654: End If;
655: If (p_rec.qua_information_category = hr_api.g_varchar2) then

Line 655: If (p_rec.qua_information_category = hr_api.g_varchar2) then

651: If (p_rec.attribute20 = hr_api.g_varchar2) then
652: p_rec.attribute20 :=
653: per_qua_shd.g_old_rec.attribute20;
654: End If;
655: If (p_rec.qua_information_category = hr_api.g_varchar2) then
656: p_rec.qua_information_category :=
657: per_qua_shd.g_old_rec.qua_information_category;
658: End If;
659: If (p_rec.qua_information1 = hr_api.g_varchar2) then

Line 659: If (p_rec.qua_information1 = hr_api.g_varchar2) then

655: If (p_rec.qua_information_category = hr_api.g_varchar2) then
656: p_rec.qua_information_category :=
657: per_qua_shd.g_old_rec.qua_information_category;
658: End If;
659: If (p_rec.qua_information1 = hr_api.g_varchar2) then
660: p_rec.qua_information1 :=
661: per_qua_shd.g_old_rec.qua_information1;
662: End If;
663: If (p_rec.qua_information2 = hr_api.g_varchar2) then

Line 663: If (p_rec.qua_information2 = hr_api.g_varchar2) then

659: If (p_rec.qua_information1 = hr_api.g_varchar2) then
660: p_rec.qua_information1 :=
661: per_qua_shd.g_old_rec.qua_information1;
662: End If;
663: If (p_rec.qua_information2 = hr_api.g_varchar2) then
664: p_rec.qua_information2 :=
665: per_qua_shd.g_old_rec.qua_information2;
666: End If;
667: If (p_rec.qua_information3 = hr_api.g_varchar2) then

Line 667: If (p_rec.qua_information3 = hr_api.g_varchar2) then

663: If (p_rec.qua_information2 = hr_api.g_varchar2) then
664: p_rec.qua_information2 :=
665: per_qua_shd.g_old_rec.qua_information2;
666: End If;
667: If (p_rec.qua_information3 = hr_api.g_varchar2) then
668: p_rec.qua_information3 :=
669: per_qua_shd.g_old_rec.qua_information3;
670: End If;
671: If (p_rec.qua_information4 = hr_api.g_varchar2) then

Line 671: If (p_rec.qua_information4 = hr_api.g_varchar2) then

667: If (p_rec.qua_information3 = hr_api.g_varchar2) then
668: p_rec.qua_information3 :=
669: per_qua_shd.g_old_rec.qua_information3;
670: End If;
671: If (p_rec.qua_information4 = hr_api.g_varchar2) then
672: p_rec.qua_information4 :=
673: per_qua_shd.g_old_rec.qua_information4;
674: End If;
675: If (p_rec.qua_information5 = hr_api.g_varchar2) then

Line 675: If (p_rec.qua_information5 = hr_api.g_varchar2) then

671: If (p_rec.qua_information4 = hr_api.g_varchar2) then
672: p_rec.qua_information4 :=
673: per_qua_shd.g_old_rec.qua_information4;
674: End If;
675: If (p_rec.qua_information5 = hr_api.g_varchar2) then
676: p_rec.qua_information5 :=
677: per_qua_shd.g_old_rec.qua_information5;
678: End If;
679: If (p_rec.qua_information6 = hr_api.g_varchar2) then

Line 679: If (p_rec.qua_information6 = hr_api.g_varchar2) then

675: If (p_rec.qua_information5 = hr_api.g_varchar2) then
676: p_rec.qua_information5 :=
677: per_qua_shd.g_old_rec.qua_information5;
678: End If;
679: If (p_rec.qua_information6 = hr_api.g_varchar2) then
680: p_rec.qua_information6 :=
681: per_qua_shd.g_old_rec.qua_information6;
682: End If;
683: If (p_rec.qua_information7 = hr_api.g_varchar2) then

Line 683: If (p_rec.qua_information7 = hr_api.g_varchar2) then

679: If (p_rec.qua_information6 = hr_api.g_varchar2) then
680: p_rec.qua_information6 :=
681: per_qua_shd.g_old_rec.qua_information6;
682: End If;
683: If (p_rec.qua_information7 = hr_api.g_varchar2) then
684: p_rec.qua_information7 :=
685: per_qua_shd.g_old_rec.qua_information7;
686: End If;
687: If (p_rec.qua_information8 = hr_api.g_varchar2) then

Line 687: If (p_rec.qua_information8 = hr_api.g_varchar2) then

683: If (p_rec.qua_information7 = hr_api.g_varchar2) then
684: p_rec.qua_information7 :=
685: per_qua_shd.g_old_rec.qua_information7;
686: End If;
687: If (p_rec.qua_information8 = hr_api.g_varchar2) then
688: p_rec.qua_information8 :=
689: per_qua_shd.g_old_rec.qua_information8;
690: End If;
691: If (p_rec.qua_information9 = hr_api.g_varchar2) then

Line 691: If (p_rec.qua_information9 = hr_api.g_varchar2) then

687: If (p_rec.qua_information8 = hr_api.g_varchar2) then
688: p_rec.qua_information8 :=
689: per_qua_shd.g_old_rec.qua_information8;
690: End If;
691: If (p_rec.qua_information9 = hr_api.g_varchar2) then
692: p_rec.qua_information9 :=
693: per_qua_shd.g_old_rec.qua_information9;
694: End If;
695: If (p_rec.qua_information10 = hr_api.g_varchar2) then

Line 695: If (p_rec.qua_information10 = hr_api.g_varchar2) then

691: If (p_rec.qua_information9 = hr_api.g_varchar2) then
692: p_rec.qua_information9 :=
693: per_qua_shd.g_old_rec.qua_information9;
694: End If;
695: If (p_rec.qua_information10 = hr_api.g_varchar2) then
696: p_rec.qua_information10 :=
697: per_qua_shd.g_old_rec.qua_information10;
698: End If;
699: If (p_rec.qua_information11 = hr_api.g_varchar2) then

Line 699: If (p_rec.qua_information11 = hr_api.g_varchar2) then

695: If (p_rec.qua_information10 = hr_api.g_varchar2) then
696: p_rec.qua_information10 :=
697: per_qua_shd.g_old_rec.qua_information10;
698: End If;
699: If (p_rec.qua_information11 = hr_api.g_varchar2) then
700: p_rec.qua_information11 :=
701: per_qua_shd.g_old_rec.qua_information11;
702: End If;
703: If (p_rec.qua_information12 = hr_api.g_varchar2) then

Line 703: If (p_rec.qua_information12 = hr_api.g_varchar2) then

699: If (p_rec.qua_information11 = hr_api.g_varchar2) then
700: p_rec.qua_information11 :=
701: per_qua_shd.g_old_rec.qua_information11;
702: End If;
703: If (p_rec.qua_information12 = hr_api.g_varchar2) then
704: p_rec.qua_information12 :=
705: per_qua_shd.g_old_rec.qua_information12;
706: End If;
707: If (p_rec.qua_information13 = hr_api.g_varchar2) then

Line 707: If (p_rec.qua_information13 = hr_api.g_varchar2) then

703: If (p_rec.qua_information12 = hr_api.g_varchar2) then
704: p_rec.qua_information12 :=
705: per_qua_shd.g_old_rec.qua_information12;
706: End If;
707: If (p_rec.qua_information13 = hr_api.g_varchar2) then
708: p_rec.qua_information13 :=
709: per_qua_shd.g_old_rec.qua_information13;
710: End If;
711: If (p_rec.qua_information14 = hr_api.g_varchar2) then

Line 711: If (p_rec.qua_information14 = hr_api.g_varchar2) then

707: If (p_rec.qua_information13 = hr_api.g_varchar2) then
708: p_rec.qua_information13 :=
709: per_qua_shd.g_old_rec.qua_information13;
710: End If;
711: If (p_rec.qua_information14 = hr_api.g_varchar2) then
712: p_rec.qua_information14 :=
713: per_qua_shd.g_old_rec.qua_information14;
714: End If;
715: If (p_rec.qua_information15 = hr_api.g_varchar2) then

Line 715: If (p_rec.qua_information15 = hr_api.g_varchar2) then

711: If (p_rec.qua_information14 = hr_api.g_varchar2) then
712: p_rec.qua_information14 :=
713: per_qua_shd.g_old_rec.qua_information14;
714: End If;
715: If (p_rec.qua_information15 = hr_api.g_varchar2) then
716: p_rec.qua_information15 :=
717: per_qua_shd.g_old_rec.qua_information15;
718: End If;
719: If (p_rec.qua_information16 = hr_api.g_varchar2) then

Line 719: If (p_rec.qua_information16 = hr_api.g_varchar2) then

715: If (p_rec.qua_information15 = hr_api.g_varchar2) then
716: p_rec.qua_information15 :=
717: per_qua_shd.g_old_rec.qua_information15;
718: End If;
719: If (p_rec.qua_information16 = hr_api.g_varchar2) then
720: p_rec.qua_information16 :=
721: per_qua_shd.g_old_rec.qua_information16;
722: End If;
723: If (p_rec.qua_information17 = hr_api.g_varchar2) then

Line 723: If (p_rec.qua_information17 = hr_api.g_varchar2) then

719: If (p_rec.qua_information16 = hr_api.g_varchar2) then
720: p_rec.qua_information16 :=
721: per_qua_shd.g_old_rec.qua_information16;
722: End If;
723: If (p_rec.qua_information17 = hr_api.g_varchar2) then
724: p_rec.qua_information17 :=
725: per_qua_shd.g_old_rec.qua_information17;
726: End If;
727: If (p_rec.qua_information18 = hr_api.g_varchar2) then

Line 727: If (p_rec.qua_information18 = hr_api.g_varchar2) then

723: If (p_rec.qua_information17 = hr_api.g_varchar2) then
724: p_rec.qua_information17 :=
725: per_qua_shd.g_old_rec.qua_information17;
726: End If;
727: If (p_rec.qua_information18 = hr_api.g_varchar2) then
728: p_rec.qua_information18 :=
729: per_qua_shd.g_old_rec.qua_information18;
730: End If;
731: If (p_rec.qua_information19 = hr_api.g_varchar2) then

Line 731: If (p_rec.qua_information19 = hr_api.g_varchar2) then

727: If (p_rec.qua_information18 = hr_api.g_varchar2) then
728: p_rec.qua_information18 :=
729: per_qua_shd.g_old_rec.qua_information18;
730: End If;
731: If (p_rec.qua_information19 = hr_api.g_varchar2) then
732: p_rec.qua_information19 :=
733: per_qua_shd.g_old_rec.qua_information19;
734: End If;
735: If (p_rec.qua_information20 = hr_api.g_varchar2) then

Line 735: If (p_rec.qua_information20 = hr_api.g_varchar2) then

731: If (p_rec.qua_information19 = hr_api.g_varchar2) then
732: p_rec.qua_information19 :=
733: per_qua_shd.g_old_rec.qua_information19;
734: End If;
735: If (p_rec.qua_information20 = hr_api.g_varchar2) then
736: p_rec.qua_information20 :=
737: per_qua_shd.g_old_rec.qua_information20;
738: End If;
739: If (p_rec.professional_body_name = hr_api.g_varchar2) then

Line 739: If (p_rec.professional_body_name = hr_api.g_varchar2) then

735: If (p_rec.qua_information20 = hr_api.g_varchar2) then
736: p_rec.qua_information20 :=
737: per_qua_shd.g_old_rec.qua_information20;
738: End If;
739: If (p_rec.professional_body_name = hr_api.g_varchar2) then
740: p_rec.professional_body_name :=
741: per_qua_shd.g_old_rec.professional_body_name;
742: End If;
743: If (p_rec.membership_number = hr_api.g_varchar2) then

Line 743: If (p_rec.membership_number = hr_api.g_varchar2) then

739: If (p_rec.professional_body_name = hr_api.g_varchar2) then
740: p_rec.professional_body_name :=
741: per_qua_shd.g_old_rec.professional_body_name;
742: End If;
743: If (p_rec.membership_number = hr_api.g_varchar2) then
744: p_rec.membership_number :=
745: per_qua_shd.g_old_rec.membership_number;
746: End If;
747: If (p_rec.membership_category = hr_api.g_varchar2) then

Line 747: If (p_rec.membership_category = hr_api.g_varchar2) then

743: If (p_rec.membership_number = hr_api.g_varchar2) then
744: p_rec.membership_number :=
745: per_qua_shd.g_old_rec.membership_number;
746: End If;
747: If (p_rec.membership_category = hr_api.g_varchar2) then
748: p_rec.membership_category :=
749: per_qua_shd.g_old_rec.membership_category;
750: End If;
751: If (p_rec.subscription_payment_method = hr_api.g_varchar2) then

Line 751: If (p_rec.subscription_payment_method = hr_api.g_varchar2) then

747: If (p_rec.membership_category = hr_api.g_varchar2) then
748: p_rec.membership_category :=
749: per_qua_shd.g_old_rec.membership_category;
750: End If;
751: If (p_rec.subscription_payment_method = hr_api.g_varchar2) then
752: p_rec.subscription_payment_method :=
753: per_qua_shd.g_old_rec.subscription_payment_method;
754: End If;
755: If (p_rec.party_id = hr_api.g_number) then -- HR/TCA merge

Line 755: If (p_rec.party_id = hr_api.g_number) then -- HR/TCA merge

751: If (p_rec.subscription_payment_method = hr_api.g_varchar2) then
752: p_rec.subscription_payment_method :=
753: per_qua_shd.g_old_rec.subscription_payment_method;
754: End If;
755: If (p_rec.party_id = hr_api.g_number) then -- HR/TCA merge
756: p_rec.party_id :=
757: per_qua_shd.g_old_rec.party_id;
758: End If;
759: --

Line 828: Raise HR_Api.Validate_Enabled;

824: --
825: -- If we are validating then raise the Validate_Enabled exception
826: --
827: If p_validate then
828: Raise HR_Api.Validate_Enabled;
829: End If;
830: --
831: hr_utility.set_location(' Leaving:'||l_proc, 10);
832: Exception

Line 833: When HR_Api.Validate_Enabled Then

829: End If;
830: --
831: hr_utility.set_location(' Leaving:'||l_proc, 10);
832: Exception
833: When HR_Api.Validate_Enabled Then
834: --
835: -- As the Validate_Enabled exception has been raised
836: -- we must rollback to the savepoint
837: --

Line 847: p_business_group_id in number default hr_api.g_number,

843: -- ----------------------------------------------------------------------------
844: Procedure upd
845: (
846: p_qualification_id in number,
847: p_business_group_id in number default hr_api.g_number,
848: p_object_version_number in out nocopy number,
849: p_person_id in number default hr_api.g_number,
850: p_title in varchar2 default hr_api.g_varchar2,
851: p_grade_attained in varchar2 default hr_api.g_varchar2,

Line 849: p_person_id in number default hr_api.g_number,

845: (
846: p_qualification_id in number,
847: p_business_group_id in number default hr_api.g_number,
848: p_object_version_number in out nocopy number,
849: p_person_id in number default hr_api.g_number,
850: p_title in varchar2 default hr_api.g_varchar2,
851: p_grade_attained in varchar2 default hr_api.g_varchar2,
852: p_status in varchar2 default hr_api.g_varchar2,
853: p_awarded_date in date default hr_api.g_date,

Line 850: p_title in varchar2 default hr_api.g_varchar2,

846: p_qualification_id in number,
847: p_business_group_id in number default hr_api.g_number,
848: p_object_version_number in out nocopy number,
849: p_person_id in number default hr_api.g_number,
850: p_title in varchar2 default hr_api.g_varchar2,
851: p_grade_attained in varchar2 default hr_api.g_varchar2,
852: p_status in varchar2 default hr_api.g_varchar2,
853: p_awarded_date in date default hr_api.g_date,
854: p_fee in number default hr_api.g_number,

Line 851: p_grade_attained in varchar2 default hr_api.g_varchar2,

847: p_business_group_id in number default hr_api.g_number,
848: p_object_version_number in out nocopy number,
849: p_person_id in number default hr_api.g_number,
850: p_title in varchar2 default hr_api.g_varchar2,
851: p_grade_attained in varchar2 default hr_api.g_varchar2,
852: p_status in varchar2 default hr_api.g_varchar2,
853: p_awarded_date in date default hr_api.g_date,
854: p_fee in number default hr_api.g_number,
855: p_fee_currency in varchar2 default hr_api.g_varchar2,

Line 852: p_status in varchar2 default hr_api.g_varchar2,

848: p_object_version_number in out nocopy number,
849: p_person_id in number default hr_api.g_number,
850: p_title in varchar2 default hr_api.g_varchar2,
851: p_grade_attained in varchar2 default hr_api.g_varchar2,
852: p_status in varchar2 default hr_api.g_varchar2,
853: p_awarded_date in date default hr_api.g_date,
854: p_fee in number default hr_api.g_number,
855: p_fee_currency in varchar2 default hr_api.g_varchar2,
856: p_training_completed_amount in number default hr_api.g_number,

Line 853: p_awarded_date in date default hr_api.g_date,

849: p_person_id in number default hr_api.g_number,
850: p_title in varchar2 default hr_api.g_varchar2,
851: p_grade_attained in varchar2 default hr_api.g_varchar2,
852: p_status in varchar2 default hr_api.g_varchar2,
853: p_awarded_date in date default hr_api.g_date,
854: p_fee in number default hr_api.g_number,
855: p_fee_currency in varchar2 default hr_api.g_varchar2,
856: p_training_completed_amount in number default hr_api.g_number,
857: p_reimbursement_arrangements in varchar2 default hr_api.g_varchar2,

Line 854: p_fee in number default hr_api.g_number,

850: p_title in varchar2 default hr_api.g_varchar2,
851: p_grade_attained in varchar2 default hr_api.g_varchar2,
852: p_status in varchar2 default hr_api.g_varchar2,
853: p_awarded_date in date default hr_api.g_date,
854: p_fee in number default hr_api.g_number,
855: p_fee_currency in varchar2 default hr_api.g_varchar2,
856: p_training_completed_amount in number default hr_api.g_number,
857: p_reimbursement_arrangements in varchar2 default hr_api.g_varchar2,
858: p_training_completed_units in varchar2 default hr_api.g_varchar2,

Line 855: p_fee_currency in varchar2 default hr_api.g_varchar2,

851: p_grade_attained in varchar2 default hr_api.g_varchar2,
852: p_status in varchar2 default hr_api.g_varchar2,
853: p_awarded_date in date default hr_api.g_date,
854: p_fee in number default hr_api.g_number,
855: p_fee_currency in varchar2 default hr_api.g_varchar2,
856: p_training_completed_amount in number default hr_api.g_number,
857: p_reimbursement_arrangements in varchar2 default hr_api.g_varchar2,
858: p_training_completed_units in varchar2 default hr_api.g_varchar2,
859: p_total_training_amount in number default hr_api.g_number,

Line 856: p_training_completed_amount in number default hr_api.g_number,

852: p_status in varchar2 default hr_api.g_varchar2,
853: p_awarded_date in date default hr_api.g_date,
854: p_fee in number default hr_api.g_number,
855: p_fee_currency in varchar2 default hr_api.g_varchar2,
856: p_training_completed_amount in number default hr_api.g_number,
857: p_reimbursement_arrangements in varchar2 default hr_api.g_varchar2,
858: p_training_completed_units in varchar2 default hr_api.g_varchar2,
859: p_total_training_amount in number default hr_api.g_number,
860: p_start_date in date default hr_api.g_date,

Line 857: p_reimbursement_arrangements in varchar2 default hr_api.g_varchar2,

853: p_awarded_date in date default hr_api.g_date,
854: p_fee in number default hr_api.g_number,
855: p_fee_currency in varchar2 default hr_api.g_varchar2,
856: p_training_completed_amount in number default hr_api.g_number,
857: p_reimbursement_arrangements in varchar2 default hr_api.g_varchar2,
858: p_training_completed_units in varchar2 default hr_api.g_varchar2,
859: p_total_training_amount in number default hr_api.g_number,
860: p_start_date in date default hr_api.g_date,
861: p_end_date in date default hr_api.g_date,

Line 858: p_training_completed_units in varchar2 default hr_api.g_varchar2,

854: p_fee in number default hr_api.g_number,
855: p_fee_currency in varchar2 default hr_api.g_varchar2,
856: p_training_completed_amount in number default hr_api.g_number,
857: p_reimbursement_arrangements in varchar2 default hr_api.g_varchar2,
858: p_training_completed_units in varchar2 default hr_api.g_varchar2,
859: p_total_training_amount in number default hr_api.g_number,
860: p_start_date in date default hr_api.g_date,
861: p_end_date in date default hr_api.g_date,
862: p_license_number in varchar2 default hr_api.g_varchar2,

Line 859: p_total_training_amount in number default hr_api.g_number,

855: p_fee_currency in varchar2 default hr_api.g_varchar2,
856: p_training_completed_amount in number default hr_api.g_number,
857: p_reimbursement_arrangements in varchar2 default hr_api.g_varchar2,
858: p_training_completed_units in varchar2 default hr_api.g_varchar2,
859: p_total_training_amount in number default hr_api.g_number,
860: p_start_date in date default hr_api.g_date,
861: p_end_date in date default hr_api.g_date,
862: p_license_number in varchar2 default hr_api.g_varchar2,
863: p_expiry_date in date default hr_api.g_date,

Line 860: p_start_date in date default hr_api.g_date,

856: p_training_completed_amount in number default hr_api.g_number,
857: p_reimbursement_arrangements in varchar2 default hr_api.g_varchar2,
858: p_training_completed_units in varchar2 default hr_api.g_varchar2,
859: p_total_training_amount in number default hr_api.g_number,
860: p_start_date in date default hr_api.g_date,
861: p_end_date in date default hr_api.g_date,
862: p_license_number in varchar2 default hr_api.g_varchar2,
863: p_expiry_date in date default hr_api.g_date,
864: p_license_restrictions in varchar2 default hr_api.g_varchar2,

Line 861: p_end_date in date default hr_api.g_date,

857: p_reimbursement_arrangements in varchar2 default hr_api.g_varchar2,
858: p_training_completed_units in varchar2 default hr_api.g_varchar2,
859: p_total_training_amount in number default hr_api.g_number,
860: p_start_date in date default hr_api.g_date,
861: p_end_date in date default hr_api.g_date,
862: p_license_number in varchar2 default hr_api.g_varchar2,
863: p_expiry_date in date default hr_api.g_date,
864: p_license_restrictions in varchar2 default hr_api.g_varchar2,
865: p_projected_completion_date in date default hr_api.g_date,

Line 862: p_license_number in varchar2 default hr_api.g_varchar2,

858: p_training_completed_units in varchar2 default hr_api.g_varchar2,
859: p_total_training_amount in number default hr_api.g_number,
860: p_start_date in date default hr_api.g_date,
861: p_end_date in date default hr_api.g_date,
862: p_license_number in varchar2 default hr_api.g_varchar2,
863: p_expiry_date in date default hr_api.g_date,
864: p_license_restrictions in varchar2 default hr_api.g_varchar2,
865: p_projected_completion_date in date default hr_api.g_date,
866: p_awarding_body in varchar2 default hr_api.g_varchar2,

Line 863: p_expiry_date in date default hr_api.g_date,

859: p_total_training_amount in number default hr_api.g_number,
860: p_start_date in date default hr_api.g_date,
861: p_end_date in date default hr_api.g_date,
862: p_license_number in varchar2 default hr_api.g_varchar2,
863: p_expiry_date in date default hr_api.g_date,
864: p_license_restrictions in varchar2 default hr_api.g_varchar2,
865: p_projected_completion_date in date default hr_api.g_date,
866: p_awarding_body in varchar2 default hr_api.g_varchar2,
867: p_tuition_method in varchar2 default hr_api.g_varchar2,

Line 864: p_license_restrictions in varchar2 default hr_api.g_varchar2,

860: p_start_date in date default hr_api.g_date,
861: p_end_date in date default hr_api.g_date,
862: p_license_number in varchar2 default hr_api.g_varchar2,
863: p_expiry_date in date default hr_api.g_date,
864: p_license_restrictions in varchar2 default hr_api.g_varchar2,
865: p_projected_completion_date in date default hr_api.g_date,
866: p_awarding_body in varchar2 default hr_api.g_varchar2,
867: p_tuition_method in varchar2 default hr_api.g_varchar2,
868: p_group_ranking in varchar2 default hr_api.g_varchar2,

Line 865: p_projected_completion_date in date default hr_api.g_date,

861: p_end_date in date default hr_api.g_date,
862: p_license_number in varchar2 default hr_api.g_varchar2,
863: p_expiry_date in date default hr_api.g_date,
864: p_license_restrictions in varchar2 default hr_api.g_varchar2,
865: p_projected_completion_date in date default hr_api.g_date,
866: p_awarding_body in varchar2 default hr_api.g_varchar2,
867: p_tuition_method in varchar2 default hr_api.g_varchar2,
868: p_group_ranking in varchar2 default hr_api.g_varchar2,
869: p_comments in varchar2 default hr_api.g_varchar2,

Line 866: p_awarding_body in varchar2 default hr_api.g_varchar2,

862: p_license_number in varchar2 default hr_api.g_varchar2,
863: p_expiry_date in date default hr_api.g_date,
864: p_license_restrictions in varchar2 default hr_api.g_varchar2,
865: p_projected_completion_date in date default hr_api.g_date,
866: p_awarding_body in varchar2 default hr_api.g_varchar2,
867: p_tuition_method in varchar2 default hr_api.g_varchar2,
868: p_group_ranking in varchar2 default hr_api.g_varchar2,
869: p_comments in varchar2 default hr_api.g_varchar2,
870: p_qualification_type_id in number default hr_api.g_number,

Line 867: p_tuition_method in varchar2 default hr_api.g_varchar2,

863: p_expiry_date in date default hr_api.g_date,
864: p_license_restrictions in varchar2 default hr_api.g_varchar2,
865: p_projected_completion_date in date default hr_api.g_date,
866: p_awarding_body in varchar2 default hr_api.g_varchar2,
867: p_tuition_method in varchar2 default hr_api.g_varchar2,
868: p_group_ranking in varchar2 default hr_api.g_varchar2,
869: p_comments in varchar2 default hr_api.g_varchar2,
870: p_qualification_type_id in number default hr_api.g_number,
871: p_attendance_id in number default hr_api.g_number,

Line 868: p_group_ranking in varchar2 default hr_api.g_varchar2,

864: p_license_restrictions in varchar2 default hr_api.g_varchar2,
865: p_projected_completion_date in date default hr_api.g_date,
866: p_awarding_body in varchar2 default hr_api.g_varchar2,
867: p_tuition_method in varchar2 default hr_api.g_varchar2,
868: p_group_ranking in varchar2 default hr_api.g_varchar2,
869: p_comments in varchar2 default hr_api.g_varchar2,
870: p_qualification_type_id in number default hr_api.g_number,
871: p_attendance_id in number default hr_api.g_number,
872: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 869: p_comments in varchar2 default hr_api.g_varchar2,

865: p_projected_completion_date in date default hr_api.g_date,
866: p_awarding_body in varchar2 default hr_api.g_varchar2,
867: p_tuition_method in varchar2 default hr_api.g_varchar2,
868: p_group_ranking in varchar2 default hr_api.g_varchar2,
869: p_comments in varchar2 default hr_api.g_varchar2,
870: p_qualification_type_id in number default hr_api.g_number,
871: p_attendance_id in number default hr_api.g_number,
872: p_attribute_category in varchar2 default hr_api.g_varchar2,
873: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 870: p_qualification_type_id in number default hr_api.g_number,

866: p_awarding_body in varchar2 default hr_api.g_varchar2,
867: p_tuition_method in varchar2 default hr_api.g_varchar2,
868: p_group_ranking in varchar2 default hr_api.g_varchar2,
869: p_comments in varchar2 default hr_api.g_varchar2,
870: p_qualification_type_id in number default hr_api.g_number,
871: p_attendance_id in number default hr_api.g_number,
872: p_attribute_category in varchar2 default hr_api.g_varchar2,
873: p_attribute1 in varchar2 default hr_api.g_varchar2,
874: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 871: p_attendance_id in number default hr_api.g_number,

867: p_tuition_method in varchar2 default hr_api.g_varchar2,
868: p_group_ranking in varchar2 default hr_api.g_varchar2,
869: p_comments in varchar2 default hr_api.g_varchar2,
870: p_qualification_type_id in number default hr_api.g_number,
871: p_attendance_id in number default hr_api.g_number,
872: p_attribute_category in varchar2 default hr_api.g_varchar2,
873: p_attribute1 in varchar2 default hr_api.g_varchar2,
874: p_attribute2 in varchar2 default hr_api.g_varchar2,
875: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 872: p_attribute_category in varchar2 default hr_api.g_varchar2,

868: p_group_ranking in varchar2 default hr_api.g_varchar2,
869: p_comments in varchar2 default hr_api.g_varchar2,
870: p_qualification_type_id in number default hr_api.g_number,
871: p_attendance_id in number default hr_api.g_number,
872: p_attribute_category in varchar2 default hr_api.g_varchar2,
873: p_attribute1 in varchar2 default hr_api.g_varchar2,
874: p_attribute2 in varchar2 default hr_api.g_varchar2,
875: p_attribute3 in varchar2 default hr_api.g_varchar2,
876: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 873: p_attribute1 in varchar2 default hr_api.g_varchar2,

869: p_comments in varchar2 default hr_api.g_varchar2,
870: p_qualification_type_id in number default hr_api.g_number,
871: p_attendance_id in number default hr_api.g_number,
872: p_attribute_category in varchar2 default hr_api.g_varchar2,
873: p_attribute1 in varchar2 default hr_api.g_varchar2,
874: p_attribute2 in varchar2 default hr_api.g_varchar2,
875: p_attribute3 in varchar2 default hr_api.g_varchar2,
876: p_attribute4 in varchar2 default hr_api.g_varchar2,
877: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 874: p_attribute2 in varchar2 default hr_api.g_varchar2,

870: p_qualification_type_id in number default hr_api.g_number,
871: p_attendance_id in number default hr_api.g_number,
872: p_attribute_category in varchar2 default hr_api.g_varchar2,
873: p_attribute1 in varchar2 default hr_api.g_varchar2,
874: p_attribute2 in varchar2 default hr_api.g_varchar2,
875: p_attribute3 in varchar2 default hr_api.g_varchar2,
876: p_attribute4 in varchar2 default hr_api.g_varchar2,
877: p_attribute5 in varchar2 default hr_api.g_varchar2,
878: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 875: p_attribute3 in varchar2 default hr_api.g_varchar2,

871: p_attendance_id in number default hr_api.g_number,
872: p_attribute_category in varchar2 default hr_api.g_varchar2,
873: p_attribute1 in varchar2 default hr_api.g_varchar2,
874: p_attribute2 in varchar2 default hr_api.g_varchar2,
875: p_attribute3 in varchar2 default hr_api.g_varchar2,
876: p_attribute4 in varchar2 default hr_api.g_varchar2,
877: p_attribute5 in varchar2 default hr_api.g_varchar2,
878: p_attribute6 in varchar2 default hr_api.g_varchar2,
879: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 876: p_attribute4 in varchar2 default hr_api.g_varchar2,

872: p_attribute_category in varchar2 default hr_api.g_varchar2,
873: p_attribute1 in varchar2 default hr_api.g_varchar2,
874: p_attribute2 in varchar2 default hr_api.g_varchar2,
875: p_attribute3 in varchar2 default hr_api.g_varchar2,
876: p_attribute4 in varchar2 default hr_api.g_varchar2,
877: p_attribute5 in varchar2 default hr_api.g_varchar2,
878: p_attribute6 in varchar2 default hr_api.g_varchar2,
879: p_attribute7 in varchar2 default hr_api.g_varchar2,
880: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 877: p_attribute5 in varchar2 default hr_api.g_varchar2,

873: p_attribute1 in varchar2 default hr_api.g_varchar2,
874: p_attribute2 in varchar2 default hr_api.g_varchar2,
875: p_attribute3 in varchar2 default hr_api.g_varchar2,
876: p_attribute4 in varchar2 default hr_api.g_varchar2,
877: p_attribute5 in varchar2 default hr_api.g_varchar2,
878: p_attribute6 in varchar2 default hr_api.g_varchar2,
879: p_attribute7 in varchar2 default hr_api.g_varchar2,
880: p_attribute8 in varchar2 default hr_api.g_varchar2,
881: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 878: p_attribute6 in varchar2 default hr_api.g_varchar2,

874: p_attribute2 in varchar2 default hr_api.g_varchar2,
875: p_attribute3 in varchar2 default hr_api.g_varchar2,
876: p_attribute4 in varchar2 default hr_api.g_varchar2,
877: p_attribute5 in varchar2 default hr_api.g_varchar2,
878: p_attribute6 in varchar2 default hr_api.g_varchar2,
879: p_attribute7 in varchar2 default hr_api.g_varchar2,
880: p_attribute8 in varchar2 default hr_api.g_varchar2,
881: p_attribute9 in varchar2 default hr_api.g_varchar2,
882: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 879: p_attribute7 in varchar2 default hr_api.g_varchar2,

875: p_attribute3 in varchar2 default hr_api.g_varchar2,
876: p_attribute4 in varchar2 default hr_api.g_varchar2,
877: p_attribute5 in varchar2 default hr_api.g_varchar2,
878: p_attribute6 in varchar2 default hr_api.g_varchar2,
879: p_attribute7 in varchar2 default hr_api.g_varchar2,
880: p_attribute8 in varchar2 default hr_api.g_varchar2,
881: p_attribute9 in varchar2 default hr_api.g_varchar2,
882: p_attribute10 in varchar2 default hr_api.g_varchar2,
883: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 880: p_attribute8 in varchar2 default hr_api.g_varchar2,

876: p_attribute4 in varchar2 default hr_api.g_varchar2,
877: p_attribute5 in varchar2 default hr_api.g_varchar2,
878: p_attribute6 in varchar2 default hr_api.g_varchar2,
879: p_attribute7 in varchar2 default hr_api.g_varchar2,
880: p_attribute8 in varchar2 default hr_api.g_varchar2,
881: p_attribute9 in varchar2 default hr_api.g_varchar2,
882: p_attribute10 in varchar2 default hr_api.g_varchar2,
883: p_attribute11 in varchar2 default hr_api.g_varchar2,
884: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 881: p_attribute9 in varchar2 default hr_api.g_varchar2,

877: p_attribute5 in varchar2 default hr_api.g_varchar2,
878: p_attribute6 in varchar2 default hr_api.g_varchar2,
879: p_attribute7 in varchar2 default hr_api.g_varchar2,
880: p_attribute8 in varchar2 default hr_api.g_varchar2,
881: p_attribute9 in varchar2 default hr_api.g_varchar2,
882: p_attribute10 in varchar2 default hr_api.g_varchar2,
883: p_attribute11 in varchar2 default hr_api.g_varchar2,
884: p_attribute12 in varchar2 default hr_api.g_varchar2,
885: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 882: p_attribute10 in varchar2 default hr_api.g_varchar2,

878: p_attribute6 in varchar2 default hr_api.g_varchar2,
879: p_attribute7 in varchar2 default hr_api.g_varchar2,
880: p_attribute8 in varchar2 default hr_api.g_varchar2,
881: p_attribute9 in varchar2 default hr_api.g_varchar2,
882: p_attribute10 in varchar2 default hr_api.g_varchar2,
883: p_attribute11 in varchar2 default hr_api.g_varchar2,
884: p_attribute12 in varchar2 default hr_api.g_varchar2,
885: p_attribute13 in varchar2 default hr_api.g_varchar2,
886: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 883: p_attribute11 in varchar2 default hr_api.g_varchar2,

879: p_attribute7 in varchar2 default hr_api.g_varchar2,
880: p_attribute8 in varchar2 default hr_api.g_varchar2,
881: p_attribute9 in varchar2 default hr_api.g_varchar2,
882: p_attribute10 in varchar2 default hr_api.g_varchar2,
883: p_attribute11 in varchar2 default hr_api.g_varchar2,
884: p_attribute12 in varchar2 default hr_api.g_varchar2,
885: p_attribute13 in varchar2 default hr_api.g_varchar2,
886: p_attribute14 in varchar2 default hr_api.g_varchar2,
887: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 884: p_attribute12 in varchar2 default hr_api.g_varchar2,

880: p_attribute8 in varchar2 default hr_api.g_varchar2,
881: p_attribute9 in varchar2 default hr_api.g_varchar2,
882: p_attribute10 in varchar2 default hr_api.g_varchar2,
883: p_attribute11 in varchar2 default hr_api.g_varchar2,
884: p_attribute12 in varchar2 default hr_api.g_varchar2,
885: p_attribute13 in varchar2 default hr_api.g_varchar2,
886: p_attribute14 in varchar2 default hr_api.g_varchar2,
887: p_attribute15 in varchar2 default hr_api.g_varchar2,
888: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 885: p_attribute13 in varchar2 default hr_api.g_varchar2,

881: p_attribute9 in varchar2 default hr_api.g_varchar2,
882: p_attribute10 in varchar2 default hr_api.g_varchar2,
883: p_attribute11 in varchar2 default hr_api.g_varchar2,
884: p_attribute12 in varchar2 default hr_api.g_varchar2,
885: p_attribute13 in varchar2 default hr_api.g_varchar2,
886: p_attribute14 in varchar2 default hr_api.g_varchar2,
887: p_attribute15 in varchar2 default hr_api.g_varchar2,
888: p_attribute16 in varchar2 default hr_api.g_varchar2,
889: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 886: p_attribute14 in varchar2 default hr_api.g_varchar2,

882: p_attribute10 in varchar2 default hr_api.g_varchar2,
883: p_attribute11 in varchar2 default hr_api.g_varchar2,
884: p_attribute12 in varchar2 default hr_api.g_varchar2,
885: p_attribute13 in varchar2 default hr_api.g_varchar2,
886: p_attribute14 in varchar2 default hr_api.g_varchar2,
887: p_attribute15 in varchar2 default hr_api.g_varchar2,
888: p_attribute16 in varchar2 default hr_api.g_varchar2,
889: p_attribute17 in varchar2 default hr_api.g_varchar2,
890: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 887: p_attribute15 in varchar2 default hr_api.g_varchar2,

883: p_attribute11 in varchar2 default hr_api.g_varchar2,
884: p_attribute12 in varchar2 default hr_api.g_varchar2,
885: p_attribute13 in varchar2 default hr_api.g_varchar2,
886: p_attribute14 in varchar2 default hr_api.g_varchar2,
887: p_attribute15 in varchar2 default hr_api.g_varchar2,
888: p_attribute16 in varchar2 default hr_api.g_varchar2,
889: p_attribute17 in varchar2 default hr_api.g_varchar2,
890: p_attribute18 in varchar2 default hr_api.g_varchar2,
891: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 888: p_attribute16 in varchar2 default hr_api.g_varchar2,

884: p_attribute12 in varchar2 default hr_api.g_varchar2,
885: p_attribute13 in varchar2 default hr_api.g_varchar2,
886: p_attribute14 in varchar2 default hr_api.g_varchar2,
887: p_attribute15 in varchar2 default hr_api.g_varchar2,
888: p_attribute16 in varchar2 default hr_api.g_varchar2,
889: p_attribute17 in varchar2 default hr_api.g_varchar2,
890: p_attribute18 in varchar2 default hr_api.g_varchar2,
891: p_attribute19 in varchar2 default hr_api.g_varchar2,
892: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 889: p_attribute17 in varchar2 default hr_api.g_varchar2,

885: p_attribute13 in varchar2 default hr_api.g_varchar2,
886: p_attribute14 in varchar2 default hr_api.g_varchar2,
887: p_attribute15 in varchar2 default hr_api.g_varchar2,
888: p_attribute16 in varchar2 default hr_api.g_varchar2,
889: p_attribute17 in varchar2 default hr_api.g_varchar2,
890: p_attribute18 in varchar2 default hr_api.g_varchar2,
891: p_attribute19 in varchar2 default hr_api.g_varchar2,
892: p_attribute20 in varchar2 default hr_api.g_varchar2,
893: p_qua_information_category in varchar2 default hr_api.g_varchar2,

Line 890: p_attribute18 in varchar2 default hr_api.g_varchar2,

886: p_attribute14 in varchar2 default hr_api.g_varchar2,
887: p_attribute15 in varchar2 default hr_api.g_varchar2,
888: p_attribute16 in varchar2 default hr_api.g_varchar2,
889: p_attribute17 in varchar2 default hr_api.g_varchar2,
890: p_attribute18 in varchar2 default hr_api.g_varchar2,
891: p_attribute19 in varchar2 default hr_api.g_varchar2,
892: p_attribute20 in varchar2 default hr_api.g_varchar2,
893: p_qua_information_category in varchar2 default hr_api.g_varchar2,
894: p_qua_information1 in varchar2 default hr_api.g_varchar2,

Line 891: p_attribute19 in varchar2 default hr_api.g_varchar2,

887: p_attribute15 in varchar2 default hr_api.g_varchar2,
888: p_attribute16 in varchar2 default hr_api.g_varchar2,
889: p_attribute17 in varchar2 default hr_api.g_varchar2,
890: p_attribute18 in varchar2 default hr_api.g_varchar2,
891: p_attribute19 in varchar2 default hr_api.g_varchar2,
892: p_attribute20 in varchar2 default hr_api.g_varchar2,
893: p_qua_information_category in varchar2 default hr_api.g_varchar2,
894: p_qua_information1 in varchar2 default hr_api.g_varchar2,
895: p_qua_information2 in varchar2 default hr_api.g_varchar2,

Line 892: p_attribute20 in varchar2 default hr_api.g_varchar2,

888: p_attribute16 in varchar2 default hr_api.g_varchar2,
889: p_attribute17 in varchar2 default hr_api.g_varchar2,
890: p_attribute18 in varchar2 default hr_api.g_varchar2,
891: p_attribute19 in varchar2 default hr_api.g_varchar2,
892: p_attribute20 in varchar2 default hr_api.g_varchar2,
893: p_qua_information_category in varchar2 default hr_api.g_varchar2,
894: p_qua_information1 in varchar2 default hr_api.g_varchar2,
895: p_qua_information2 in varchar2 default hr_api.g_varchar2,
896: p_qua_information3 in varchar2 default hr_api.g_varchar2,

Line 893: p_qua_information_category in varchar2 default hr_api.g_varchar2,

889: p_attribute17 in varchar2 default hr_api.g_varchar2,
890: p_attribute18 in varchar2 default hr_api.g_varchar2,
891: p_attribute19 in varchar2 default hr_api.g_varchar2,
892: p_attribute20 in varchar2 default hr_api.g_varchar2,
893: p_qua_information_category in varchar2 default hr_api.g_varchar2,
894: p_qua_information1 in varchar2 default hr_api.g_varchar2,
895: p_qua_information2 in varchar2 default hr_api.g_varchar2,
896: p_qua_information3 in varchar2 default hr_api.g_varchar2,
897: p_qua_information4 in varchar2 default hr_api.g_varchar2,

Line 894: p_qua_information1 in varchar2 default hr_api.g_varchar2,

890: p_attribute18 in varchar2 default hr_api.g_varchar2,
891: p_attribute19 in varchar2 default hr_api.g_varchar2,
892: p_attribute20 in varchar2 default hr_api.g_varchar2,
893: p_qua_information_category in varchar2 default hr_api.g_varchar2,
894: p_qua_information1 in varchar2 default hr_api.g_varchar2,
895: p_qua_information2 in varchar2 default hr_api.g_varchar2,
896: p_qua_information3 in varchar2 default hr_api.g_varchar2,
897: p_qua_information4 in varchar2 default hr_api.g_varchar2,
898: p_qua_information5 in varchar2 default hr_api.g_varchar2,

Line 895: p_qua_information2 in varchar2 default hr_api.g_varchar2,

891: p_attribute19 in varchar2 default hr_api.g_varchar2,
892: p_attribute20 in varchar2 default hr_api.g_varchar2,
893: p_qua_information_category in varchar2 default hr_api.g_varchar2,
894: p_qua_information1 in varchar2 default hr_api.g_varchar2,
895: p_qua_information2 in varchar2 default hr_api.g_varchar2,
896: p_qua_information3 in varchar2 default hr_api.g_varchar2,
897: p_qua_information4 in varchar2 default hr_api.g_varchar2,
898: p_qua_information5 in varchar2 default hr_api.g_varchar2,
899: p_qua_information6 in varchar2 default hr_api.g_varchar2,

Line 896: p_qua_information3 in varchar2 default hr_api.g_varchar2,

892: p_attribute20 in varchar2 default hr_api.g_varchar2,
893: p_qua_information_category in varchar2 default hr_api.g_varchar2,
894: p_qua_information1 in varchar2 default hr_api.g_varchar2,
895: p_qua_information2 in varchar2 default hr_api.g_varchar2,
896: p_qua_information3 in varchar2 default hr_api.g_varchar2,
897: p_qua_information4 in varchar2 default hr_api.g_varchar2,
898: p_qua_information5 in varchar2 default hr_api.g_varchar2,
899: p_qua_information6 in varchar2 default hr_api.g_varchar2,
900: p_qua_information7 in varchar2 default hr_api.g_varchar2,

Line 897: p_qua_information4 in varchar2 default hr_api.g_varchar2,

893: p_qua_information_category in varchar2 default hr_api.g_varchar2,
894: p_qua_information1 in varchar2 default hr_api.g_varchar2,
895: p_qua_information2 in varchar2 default hr_api.g_varchar2,
896: p_qua_information3 in varchar2 default hr_api.g_varchar2,
897: p_qua_information4 in varchar2 default hr_api.g_varchar2,
898: p_qua_information5 in varchar2 default hr_api.g_varchar2,
899: p_qua_information6 in varchar2 default hr_api.g_varchar2,
900: p_qua_information7 in varchar2 default hr_api.g_varchar2,
901: p_qua_information8 in varchar2 default hr_api.g_varchar2,

Line 898: p_qua_information5 in varchar2 default hr_api.g_varchar2,

894: p_qua_information1 in varchar2 default hr_api.g_varchar2,
895: p_qua_information2 in varchar2 default hr_api.g_varchar2,
896: p_qua_information3 in varchar2 default hr_api.g_varchar2,
897: p_qua_information4 in varchar2 default hr_api.g_varchar2,
898: p_qua_information5 in varchar2 default hr_api.g_varchar2,
899: p_qua_information6 in varchar2 default hr_api.g_varchar2,
900: p_qua_information7 in varchar2 default hr_api.g_varchar2,
901: p_qua_information8 in varchar2 default hr_api.g_varchar2,
902: p_qua_information9 in varchar2 default hr_api.g_varchar2,

Line 899: p_qua_information6 in varchar2 default hr_api.g_varchar2,

895: p_qua_information2 in varchar2 default hr_api.g_varchar2,
896: p_qua_information3 in varchar2 default hr_api.g_varchar2,
897: p_qua_information4 in varchar2 default hr_api.g_varchar2,
898: p_qua_information5 in varchar2 default hr_api.g_varchar2,
899: p_qua_information6 in varchar2 default hr_api.g_varchar2,
900: p_qua_information7 in varchar2 default hr_api.g_varchar2,
901: p_qua_information8 in varchar2 default hr_api.g_varchar2,
902: p_qua_information9 in varchar2 default hr_api.g_varchar2,
903: p_qua_information10 in varchar2 default hr_api.g_varchar2,

Line 900: p_qua_information7 in varchar2 default hr_api.g_varchar2,

896: p_qua_information3 in varchar2 default hr_api.g_varchar2,
897: p_qua_information4 in varchar2 default hr_api.g_varchar2,
898: p_qua_information5 in varchar2 default hr_api.g_varchar2,
899: p_qua_information6 in varchar2 default hr_api.g_varchar2,
900: p_qua_information7 in varchar2 default hr_api.g_varchar2,
901: p_qua_information8 in varchar2 default hr_api.g_varchar2,
902: p_qua_information9 in varchar2 default hr_api.g_varchar2,
903: p_qua_information10 in varchar2 default hr_api.g_varchar2,
904: p_qua_information11 in varchar2 default hr_api.g_varchar2,

Line 901: p_qua_information8 in varchar2 default hr_api.g_varchar2,

897: p_qua_information4 in varchar2 default hr_api.g_varchar2,
898: p_qua_information5 in varchar2 default hr_api.g_varchar2,
899: p_qua_information6 in varchar2 default hr_api.g_varchar2,
900: p_qua_information7 in varchar2 default hr_api.g_varchar2,
901: p_qua_information8 in varchar2 default hr_api.g_varchar2,
902: p_qua_information9 in varchar2 default hr_api.g_varchar2,
903: p_qua_information10 in varchar2 default hr_api.g_varchar2,
904: p_qua_information11 in varchar2 default hr_api.g_varchar2,
905: p_qua_information12 in varchar2 default hr_api.g_varchar2,

Line 902: p_qua_information9 in varchar2 default hr_api.g_varchar2,

898: p_qua_information5 in varchar2 default hr_api.g_varchar2,
899: p_qua_information6 in varchar2 default hr_api.g_varchar2,
900: p_qua_information7 in varchar2 default hr_api.g_varchar2,
901: p_qua_information8 in varchar2 default hr_api.g_varchar2,
902: p_qua_information9 in varchar2 default hr_api.g_varchar2,
903: p_qua_information10 in varchar2 default hr_api.g_varchar2,
904: p_qua_information11 in varchar2 default hr_api.g_varchar2,
905: p_qua_information12 in varchar2 default hr_api.g_varchar2,
906: p_qua_information13 in varchar2 default hr_api.g_varchar2,

Line 903: p_qua_information10 in varchar2 default hr_api.g_varchar2,

899: p_qua_information6 in varchar2 default hr_api.g_varchar2,
900: p_qua_information7 in varchar2 default hr_api.g_varchar2,
901: p_qua_information8 in varchar2 default hr_api.g_varchar2,
902: p_qua_information9 in varchar2 default hr_api.g_varchar2,
903: p_qua_information10 in varchar2 default hr_api.g_varchar2,
904: p_qua_information11 in varchar2 default hr_api.g_varchar2,
905: p_qua_information12 in varchar2 default hr_api.g_varchar2,
906: p_qua_information13 in varchar2 default hr_api.g_varchar2,
907: p_qua_information14 in varchar2 default hr_api.g_varchar2,

Line 904: p_qua_information11 in varchar2 default hr_api.g_varchar2,

900: p_qua_information7 in varchar2 default hr_api.g_varchar2,
901: p_qua_information8 in varchar2 default hr_api.g_varchar2,
902: p_qua_information9 in varchar2 default hr_api.g_varchar2,
903: p_qua_information10 in varchar2 default hr_api.g_varchar2,
904: p_qua_information11 in varchar2 default hr_api.g_varchar2,
905: p_qua_information12 in varchar2 default hr_api.g_varchar2,
906: p_qua_information13 in varchar2 default hr_api.g_varchar2,
907: p_qua_information14 in varchar2 default hr_api.g_varchar2,
908: p_qua_information15 in varchar2 default hr_api.g_varchar2,

Line 905: p_qua_information12 in varchar2 default hr_api.g_varchar2,

901: p_qua_information8 in varchar2 default hr_api.g_varchar2,
902: p_qua_information9 in varchar2 default hr_api.g_varchar2,
903: p_qua_information10 in varchar2 default hr_api.g_varchar2,
904: p_qua_information11 in varchar2 default hr_api.g_varchar2,
905: p_qua_information12 in varchar2 default hr_api.g_varchar2,
906: p_qua_information13 in varchar2 default hr_api.g_varchar2,
907: p_qua_information14 in varchar2 default hr_api.g_varchar2,
908: p_qua_information15 in varchar2 default hr_api.g_varchar2,
909: p_qua_information16 in varchar2 default hr_api.g_varchar2,

Line 906: p_qua_information13 in varchar2 default hr_api.g_varchar2,

902: p_qua_information9 in varchar2 default hr_api.g_varchar2,
903: p_qua_information10 in varchar2 default hr_api.g_varchar2,
904: p_qua_information11 in varchar2 default hr_api.g_varchar2,
905: p_qua_information12 in varchar2 default hr_api.g_varchar2,
906: p_qua_information13 in varchar2 default hr_api.g_varchar2,
907: p_qua_information14 in varchar2 default hr_api.g_varchar2,
908: p_qua_information15 in varchar2 default hr_api.g_varchar2,
909: p_qua_information16 in varchar2 default hr_api.g_varchar2,
910: p_qua_information17 in varchar2 default hr_api.g_varchar2,

Line 907: p_qua_information14 in varchar2 default hr_api.g_varchar2,

903: p_qua_information10 in varchar2 default hr_api.g_varchar2,
904: p_qua_information11 in varchar2 default hr_api.g_varchar2,
905: p_qua_information12 in varchar2 default hr_api.g_varchar2,
906: p_qua_information13 in varchar2 default hr_api.g_varchar2,
907: p_qua_information14 in varchar2 default hr_api.g_varchar2,
908: p_qua_information15 in varchar2 default hr_api.g_varchar2,
909: p_qua_information16 in varchar2 default hr_api.g_varchar2,
910: p_qua_information17 in varchar2 default hr_api.g_varchar2,
911: p_qua_information18 in varchar2 default hr_api.g_varchar2,

Line 908: p_qua_information15 in varchar2 default hr_api.g_varchar2,

904: p_qua_information11 in varchar2 default hr_api.g_varchar2,
905: p_qua_information12 in varchar2 default hr_api.g_varchar2,
906: p_qua_information13 in varchar2 default hr_api.g_varchar2,
907: p_qua_information14 in varchar2 default hr_api.g_varchar2,
908: p_qua_information15 in varchar2 default hr_api.g_varchar2,
909: p_qua_information16 in varchar2 default hr_api.g_varchar2,
910: p_qua_information17 in varchar2 default hr_api.g_varchar2,
911: p_qua_information18 in varchar2 default hr_api.g_varchar2,
912: p_qua_information19 in varchar2 default hr_api.g_varchar2,

Line 909: p_qua_information16 in varchar2 default hr_api.g_varchar2,

905: p_qua_information12 in varchar2 default hr_api.g_varchar2,
906: p_qua_information13 in varchar2 default hr_api.g_varchar2,
907: p_qua_information14 in varchar2 default hr_api.g_varchar2,
908: p_qua_information15 in varchar2 default hr_api.g_varchar2,
909: p_qua_information16 in varchar2 default hr_api.g_varchar2,
910: p_qua_information17 in varchar2 default hr_api.g_varchar2,
911: p_qua_information18 in varchar2 default hr_api.g_varchar2,
912: p_qua_information19 in varchar2 default hr_api.g_varchar2,
913: p_qua_information20 in varchar2 default hr_api.g_varchar2,

Line 910: p_qua_information17 in varchar2 default hr_api.g_varchar2,

906: p_qua_information13 in varchar2 default hr_api.g_varchar2,
907: p_qua_information14 in varchar2 default hr_api.g_varchar2,
908: p_qua_information15 in varchar2 default hr_api.g_varchar2,
909: p_qua_information16 in varchar2 default hr_api.g_varchar2,
910: p_qua_information17 in varchar2 default hr_api.g_varchar2,
911: p_qua_information18 in varchar2 default hr_api.g_varchar2,
912: p_qua_information19 in varchar2 default hr_api.g_varchar2,
913: p_qua_information20 in varchar2 default hr_api.g_varchar2,
914: p_effective_date in date,

Line 911: p_qua_information18 in varchar2 default hr_api.g_varchar2,

907: p_qua_information14 in varchar2 default hr_api.g_varchar2,
908: p_qua_information15 in varchar2 default hr_api.g_varchar2,
909: p_qua_information16 in varchar2 default hr_api.g_varchar2,
910: p_qua_information17 in varchar2 default hr_api.g_varchar2,
911: p_qua_information18 in varchar2 default hr_api.g_varchar2,
912: p_qua_information19 in varchar2 default hr_api.g_varchar2,
913: p_qua_information20 in varchar2 default hr_api.g_varchar2,
914: p_effective_date in date,
915: p_validate in boolean default false,

Line 912: p_qua_information19 in varchar2 default hr_api.g_varchar2,

908: p_qua_information15 in varchar2 default hr_api.g_varchar2,
909: p_qua_information16 in varchar2 default hr_api.g_varchar2,
910: p_qua_information17 in varchar2 default hr_api.g_varchar2,
911: p_qua_information18 in varchar2 default hr_api.g_varchar2,
912: p_qua_information19 in varchar2 default hr_api.g_varchar2,
913: p_qua_information20 in varchar2 default hr_api.g_varchar2,
914: p_effective_date in date,
915: p_validate in boolean default false,
916: p_professional_body_name in varchar2 default hr_api.g_varchar2,

Line 913: p_qua_information20 in varchar2 default hr_api.g_varchar2,

909: p_qua_information16 in varchar2 default hr_api.g_varchar2,
910: p_qua_information17 in varchar2 default hr_api.g_varchar2,
911: p_qua_information18 in varchar2 default hr_api.g_varchar2,
912: p_qua_information19 in varchar2 default hr_api.g_varchar2,
913: p_qua_information20 in varchar2 default hr_api.g_varchar2,
914: p_effective_date in date,
915: p_validate in boolean default false,
916: p_professional_body_name in varchar2 default hr_api.g_varchar2,
917: p_membership_number in varchar2 default hr_api.g_varchar2,

Line 916: p_professional_body_name in varchar2 default hr_api.g_varchar2,

912: p_qua_information19 in varchar2 default hr_api.g_varchar2,
913: p_qua_information20 in varchar2 default hr_api.g_varchar2,
914: p_effective_date in date,
915: p_validate in boolean default false,
916: p_professional_body_name in varchar2 default hr_api.g_varchar2,
917: p_membership_number in varchar2 default hr_api.g_varchar2,
918: p_membership_category in varchar2 default hr_api.g_varchar2,
919: p_subscription_payment_method in varchar2 default hr_api.g_varchar2,
920: p_party_id in number default hr_api.g_number

Line 917: p_membership_number in varchar2 default hr_api.g_varchar2,

913: p_qua_information20 in varchar2 default hr_api.g_varchar2,
914: p_effective_date in date,
915: p_validate in boolean default false,
916: p_professional_body_name in varchar2 default hr_api.g_varchar2,
917: p_membership_number in varchar2 default hr_api.g_varchar2,
918: p_membership_category in varchar2 default hr_api.g_varchar2,
919: p_subscription_payment_method in varchar2 default hr_api.g_varchar2,
920: p_party_id in number default hr_api.g_number
921: ) is

Line 918: p_membership_category in varchar2 default hr_api.g_varchar2,

914: p_effective_date in date,
915: p_validate in boolean default false,
916: p_professional_body_name in varchar2 default hr_api.g_varchar2,
917: p_membership_number in varchar2 default hr_api.g_varchar2,
918: p_membership_category in varchar2 default hr_api.g_varchar2,
919: p_subscription_payment_method in varchar2 default hr_api.g_varchar2,
920: p_party_id in number default hr_api.g_number
921: ) is
922: --

Line 919: p_subscription_payment_method in varchar2 default hr_api.g_varchar2,

915: p_validate in boolean default false,
916: p_professional_body_name in varchar2 default hr_api.g_varchar2,
917: p_membership_number in varchar2 default hr_api.g_varchar2,
918: p_membership_category in varchar2 default hr_api.g_varchar2,
919: p_subscription_payment_method in varchar2 default hr_api.g_varchar2,
920: p_party_id in number default hr_api.g_number
921: ) is
922: --
923: l_rec per_qua_shd.g_rec_type;

Line 920: p_party_id in number default hr_api.g_number

916: p_professional_body_name in varchar2 default hr_api.g_varchar2,
917: p_membership_number in varchar2 default hr_api.g_varchar2,
918: p_membership_category in varchar2 default hr_api.g_varchar2,
919: p_subscription_payment_method in varchar2 default hr_api.g_varchar2,
920: p_party_id in number default hr_api.g_number
921: ) is
922: --
923: l_rec per_qua_shd.g_rec_type;
924: l_proc varchar2(72) := g_package||'upd';