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.HR_PERSON_ATT dependencies on HR_DT_ATTRIBUTE_SUPPORT

Line 753: l_title := hr_dt_attribute_support.get_parameter_char

749: l_proc varchar2(72) := g_package||'process_row';
750: begin
751: hr_utility.set_location('Entering:'|| l_proc, 5);
752: -- get the parameter values to pass to the BP API
753: l_title := hr_dt_attribute_support.get_parameter_char
754: (p_effective_date_row => l_effective_date_row
755: ,p_parameter_name => 'P_TITLE'
756: ,p_new_value => p_title
757: ,p_current_value => c_title);

Line 758: l_marital_status := hr_dt_attribute_support.get_parameter_char

754: (p_effective_date_row => l_effective_date_row
755: ,p_parameter_name => 'P_TITLE'
756: ,p_new_value => p_title
757: ,p_current_value => c_title);
758: l_marital_status := hr_dt_attribute_support.get_parameter_char
759: (p_effective_date_row => l_effective_date_row
760: ,p_parameter_name => 'P_MARITAL_STATUS'
761: ,p_new_value => p_marital_status
762: ,p_current_value => c_marital_status);

Line 763: l_first_name := hr_dt_attribute_support.get_parameter_char

759: (p_effective_date_row => l_effective_date_row
760: ,p_parameter_name => 'P_MARITAL_STATUS'
761: ,p_new_value => p_marital_status
762: ,p_current_value => c_marital_status);
763: l_first_name := hr_dt_attribute_support.get_parameter_char
764: (p_effective_date_row => l_effective_date_row
765: ,p_parameter_name => 'P_FIRST_NAME'
766: ,p_new_value => p_first_name
767: ,p_current_value => c_first_name);

Line 768: l_middle_names := hr_dt_attribute_support.get_parameter_char

764: (p_effective_date_row => l_effective_date_row
765: ,p_parameter_name => 'P_FIRST_NAME'
766: ,p_new_value => p_first_name
767: ,p_current_value => c_first_name);
768: l_middle_names := hr_dt_attribute_support.get_parameter_char
769: (p_effective_date_row => l_effective_date_row
770: ,p_parameter_name => 'P_MIDDLE_NAMES'
771: ,p_new_value => p_middle_names
772: ,p_current_value => c_middle_names);

Line 773: l_last_name := hr_dt_attribute_support.get_parameter_char

769: (p_effective_date_row => l_effective_date_row
770: ,p_parameter_name => 'P_MIDDLE_NAMES'
771: ,p_new_value => p_middle_names
772: ,p_current_value => c_middle_names);
773: l_last_name := hr_dt_attribute_support.get_parameter_char
774: (p_effective_date_row => l_effective_date_row
775: ,p_parameter_name => 'P_LAST_NAME'
776: ,p_new_value => p_last_name
777: ,p_current_value => c_last_name);

Line 778: l_known_as := hr_dt_attribute_support.get_parameter_char

774: (p_effective_date_row => l_effective_date_row
775: ,p_parameter_name => 'P_LAST_NAME'
776: ,p_new_value => p_last_name
777: ,p_current_value => c_last_name);
778: l_known_as := hr_dt_attribute_support.get_parameter_char
779: (p_effective_date_row => l_effective_date_row
780: ,p_parameter_name => 'P_KNOWN_AS'
781: ,p_new_value => p_known_as
782: ,p_current_value => c_known_as);

Line 783: l_previous_last_name := hr_dt_attribute_support.get_parameter_char

779: (p_effective_date_row => l_effective_date_row
780: ,p_parameter_name => 'P_KNOWN_AS'
781: ,p_new_value => p_known_as
782: ,p_current_value => c_known_as);
783: l_previous_last_name := hr_dt_attribute_support.get_parameter_char
784: (p_effective_date_row => l_effective_date_row
785: ,p_parameter_name => 'P_PREVIOUS_LAST_NAME'
786: ,p_new_value => p_previous_last_name
787: ,p_current_value => c_previous_last_name);

Line 788: l_date_of_birth := hr_dt_attribute_support.get_parameter_date

784: (p_effective_date_row => l_effective_date_row
785: ,p_parameter_name => 'P_PREVIOUS_LAST_NAME'
786: ,p_new_value => p_previous_last_name
787: ,p_current_value => c_previous_last_name);
788: l_date_of_birth := hr_dt_attribute_support.get_parameter_date
789: (p_effective_date_row => l_effective_date_row
790: ,p_parameter_name => 'P_DATE_OF_BIRTH'
791: ,p_new_value => p_date_of_birth
792: ,p_current_value => c_date_of_birth);

Line 793: l_email_address := hr_dt_attribute_support.get_parameter_char

789: (p_effective_date_row => l_effective_date_row
790: ,p_parameter_name => 'P_DATE_OF_BIRTH'
791: ,p_new_value => p_date_of_birth
792: ,p_current_value => c_date_of_birth);
793: l_email_address := hr_dt_attribute_support.get_parameter_char
794: (p_effective_date_row => l_effective_date_row
795: ,p_parameter_name => 'P_EMAIL_ADDRESS'
796: ,p_new_value => p_email_address
797: ,p_current_value => c_email_address);

Line 798: l_nationality := hr_dt_attribute_support.get_parameter_char

794: (p_effective_date_row => l_effective_date_row
795: ,p_parameter_name => 'P_EMAIL_ADDRESS'
796: ,p_new_value => p_email_address
797: ,p_current_value => c_email_address);
798: l_nationality := hr_dt_attribute_support.get_parameter_char
799: (p_effective_date_row => l_effective_date_row
800: ,p_parameter_name => 'P_NATIONALITY'
801: ,p_new_value => p_nationality
802: ,p_current_value => c_nationality);

Line 803: l_sex := hr_dt_attribute_support.get_parameter_char

799: (p_effective_date_row => l_effective_date_row
800: ,p_parameter_name => 'P_NATIONALITY'
801: ,p_new_value => p_nationality
802: ,p_current_value => c_nationality);
803: l_sex := hr_dt_attribute_support.get_parameter_char
804: (p_effective_date_row => l_effective_date_row
805: ,p_parameter_name => 'P_SEX'
806: ,p_new_value => p_sex
807: ,p_current_value => c_sex);

Line 808: l_work_telephone := hr_dt_attribute_support.get_parameter_char

804: (p_effective_date_row => l_effective_date_row
805: ,p_parameter_name => 'P_SEX'
806: ,p_new_value => p_sex
807: ,p_current_value => c_sex);
808: l_work_telephone := hr_dt_attribute_support.get_parameter_char
809: (p_effective_date_row => l_effective_date_row
810: ,p_parameter_name => 'P_WORK_TELEPHONE'
811: ,p_new_value => p_work_telephone
812: ,p_current_value => c_work_telephone);

Line 813: l_suffix := hr_dt_attribute_support.get_parameter_char

809: (p_effective_date_row => l_effective_date_row
810: ,p_parameter_name => 'P_WORK_TELEPHONE'
811: ,p_new_value => p_work_telephone
812: ,p_current_value => c_work_telephone);
813: l_suffix := hr_dt_attribute_support.get_parameter_char
814: (p_effective_date_row => l_effective_date_row
815: ,p_parameter_name => 'P_SUFFIX'
816: ,p_new_value => p_suffix
817: ,p_current_value => c_suffix);

Line 818: l_person_type_id := hr_dt_attribute_support.get_parameter_number

814: (p_effective_date_row => l_effective_date_row
815: ,p_parameter_name => 'P_SUFFIX'
816: ,p_new_value => p_suffix
817: ,p_current_value => c_suffix);
818: l_person_type_id := hr_dt_attribute_support.get_parameter_number
819: (p_effective_date_row => l_effective_date_row
820: ,p_parameter_name => 'P_PERSON_TYPE_ID'
821: ,p_new_value => p_person_type_id
822: ,p_current_value => c_person_type_id);

Line 823: l_applicant_number := hr_dt_attribute_support.get_parameter_char

819: (p_effective_date_row => l_effective_date_row
820: ,p_parameter_name => 'P_PERSON_TYPE_ID'
821: ,p_new_value => p_person_type_id
822: ,p_current_value => c_person_type_id);
823: l_applicant_number := hr_dt_attribute_support.get_parameter_char
824: (p_effective_date_row => l_effective_date_row
825: ,p_parameter_name => 'P_APPLICANT_NUMBER'
826: ,p_new_value => p_applicant_number
827: ,p_current_value => c_applicant_number);

Line 828: l_comments := hr_dt_attribute_support.get_parameter_char

824: (p_effective_date_row => l_effective_date_row
825: ,p_parameter_name => 'P_APPLICANT_NUMBER'
826: ,p_new_value => p_applicant_number
827: ,p_current_value => c_applicant_number);
828: l_comments := hr_dt_attribute_support.get_parameter_char
829: (p_effective_date_row => l_effective_date_row
830: ,p_parameter_name => 'P_COMMENTS'
831: ,p_new_value => p_comments
832: ,p_current_value => c_comments);

Line 834: := hr_dt_attribute_support.get_parameter_date

830: ,p_parameter_name => 'P_COMMENTS'
831: ,p_new_value => p_comments
832: ,p_current_value => c_comments);
833: l_date_employee_data_verified
834: := hr_dt_attribute_support.get_parameter_date
835: (p_effective_date_row => l_effective_date_row
836: ,p_parameter_name => 'P_DATE_EMPLOYEE_DATA_VERIFIED'
837: ,p_new_value => p_date_employee_data_verified
838: ,p_current_value => c_date_employee_data_verified);

Line 839: l_employee_number := hr_dt_attribute_support.get_parameter_char

835: (p_effective_date_row => l_effective_date_row
836: ,p_parameter_name => 'P_DATE_EMPLOYEE_DATA_VERIFIED'
837: ,p_new_value => p_date_employee_data_verified
838: ,p_current_value => c_date_employee_data_verified);
839: l_employee_number := hr_dt_attribute_support.get_parameter_char
840: (p_effective_date_row => l_effective_date_row
841: ,p_parameter_name => 'P_EMPLOYEE_NUMBER'
842: ,p_new_value => p_employee_number
843: ,p_current_value => c_employee_number);

Line 845: hr_dt_attribute_support.get_parameter_char

841: ,p_parameter_name => 'P_EMPLOYEE_NUMBER'
842: ,p_new_value => p_employee_number
843: ,p_current_value => c_employee_number);
844: l_expense_check_send_to_addres :=
845: hr_dt_attribute_support.get_parameter_char
846: (p_effective_date_row => l_effective_date_row
847: ,p_parameter_name => 'P_EXPENSE_CHECK_SEND_TO_ADDRES'
848: ,p_new_value => p_expense_check_send_to_addres
849: ,p_current_value => c_expense_check_send_to_addres);

Line 850: l_national_identifier := hr_dt_attribute_support.get_parameter_char

846: (p_effective_date_row => l_effective_date_row
847: ,p_parameter_name => 'P_EXPENSE_CHECK_SEND_TO_ADDRES'
848: ,p_new_value => p_expense_check_send_to_addres
849: ,p_current_value => c_expense_check_send_to_addres);
850: l_national_identifier := hr_dt_attribute_support.get_parameter_char
851: (p_effective_date_row => l_effective_date_row
852: ,p_parameter_name => 'P_NATIONAL_IDENTIFIER'
853: ,p_new_value => p_national_identifier
854: ,p_current_value => c_national_identifier);

Line 855: l_registered_disabled_flag := hr_dt_attribute_support.get_parameter_char

851: (p_effective_date_row => l_effective_date_row
852: ,p_parameter_name => 'P_NATIONAL_IDENTIFIER'
853: ,p_new_value => p_national_identifier
854: ,p_current_value => c_national_identifier);
855: l_registered_disabled_flag := hr_dt_attribute_support.get_parameter_char
856: (p_effective_date_row => l_effective_date_row
857: ,p_parameter_name => 'P_REGISTERED_DISABLED_FLAG'
858: ,p_new_value => p_registered_disabled_flag
859: ,p_current_value => c_registered_disabled_flag);

Line 860: l_vendor_id := hr_dt_attribute_support.get_parameter_number

856: (p_effective_date_row => l_effective_date_row
857: ,p_parameter_name => 'P_REGISTERED_DISABLED_FLAG'
858: ,p_new_value => p_registered_disabled_flag
859: ,p_current_value => c_registered_disabled_flag);
860: l_vendor_id := hr_dt_attribute_support.get_parameter_number
861: (p_effective_date_row => l_effective_date_row
862: ,p_parameter_name => 'P_VENDOR_ID'
863: ,p_new_value => p_vendor_id
864: ,p_current_value => c_vendor_id);

Line 865: l_attribute_category := hr_dt_attribute_support.get_parameter_char

861: (p_effective_date_row => l_effective_date_row
862: ,p_parameter_name => 'P_VENDOR_ID'
863: ,p_new_value => p_vendor_id
864: ,p_current_value => c_vendor_id);
865: l_attribute_category := hr_dt_attribute_support.get_parameter_char
866: (p_effective_date_row => l_effective_date_row
867: ,p_parameter_name => 'P_ATTRIBUTE_CATEGORY'
868: ,p_new_value => p_attribute_category
869: ,p_current_value => c_attribute_category);

Line 870: l_attribute1 := hr_dt_attribute_support.get_parameter_char

866: (p_effective_date_row => l_effective_date_row
867: ,p_parameter_name => 'P_ATTRIBUTE_CATEGORY'
868: ,p_new_value => p_attribute_category
869: ,p_current_value => c_attribute_category);
870: l_attribute1 := hr_dt_attribute_support.get_parameter_char
871: (p_effective_date_row => l_effective_date_row
872: ,p_parameter_name => 'P_ATTRIBUTE1'
873: ,p_new_value => p_attribute1
874: ,p_current_value => c_attribute1);

Line 875: l_attribute2 := hr_dt_attribute_support.get_parameter_char

871: (p_effective_date_row => l_effective_date_row
872: ,p_parameter_name => 'P_ATTRIBUTE1'
873: ,p_new_value => p_attribute1
874: ,p_current_value => c_attribute1);
875: l_attribute2 := hr_dt_attribute_support.get_parameter_char
876: (p_effective_date_row => l_effective_date_row
877: ,p_parameter_name => 'P_ATTRIBUTE2'
878: ,p_new_value => p_attribute2
879: ,p_current_value => c_attribute2);

Line 880: l_attribute3 := hr_dt_attribute_support.get_parameter_char

876: (p_effective_date_row => l_effective_date_row
877: ,p_parameter_name => 'P_ATTRIBUTE2'
878: ,p_new_value => p_attribute2
879: ,p_current_value => c_attribute2);
880: l_attribute3 := hr_dt_attribute_support.get_parameter_char
881: (p_effective_date_row => l_effective_date_row
882: ,p_parameter_name => 'P_ATTRIBUTE3'
883: ,p_new_value => p_attribute3
884: ,p_current_value => c_attribute3);

Line 885: l_attribute4 := hr_dt_attribute_support.get_parameter_char

881: (p_effective_date_row => l_effective_date_row
882: ,p_parameter_name => 'P_ATTRIBUTE3'
883: ,p_new_value => p_attribute3
884: ,p_current_value => c_attribute3);
885: l_attribute4 := hr_dt_attribute_support.get_parameter_char
886: (p_effective_date_row => l_effective_date_row
887: ,p_parameter_name => 'P_ATTRIBUTE4'
888: ,p_new_value => p_attribute4
889: ,p_current_value => c_attribute4);

Line 890: l_attribute5 := hr_dt_attribute_support.get_parameter_char

886: (p_effective_date_row => l_effective_date_row
887: ,p_parameter_name => 'P_ATTRIBUTE4'
888: ,p_new_value => p_attribute4
889: ,p_current_value => c_attribute4);
890: l_attribute5 := hr_dt_attribute_support.get_parameter_char
891: (p_effective_date_row => l_effective_date_row
892: ,p_parameter_name => 'P_ATTRIBUTE5'
893: ,p_new_value => p_attribute5
894: ,p_current_value => c_attribute5);

Line 895: l_attribute6 := hr_dt_attribute_support.get_parameter_char

891: (p_effective_date_row => l_effective_date_row
892: ,p_parameter_name => 'P_ATTRIBUTE5'
893: ,p_new_value => p_attribute5
894: ,p_current_value => c_attribute5);
895: l_attribute6 := hr_dt_attribute_support.get_parameter_char
896: (p_effective_date_row => l_effective_date_row
897: ,p_parameter_name => 'P_ATTRIBUTE6'
898: ,p_new_value => p_attribute6
899: ,p_current_value => c_attribute6);

Line 900: l_attribute7 := hr_dt_attribute_support.get_parameter_char

896: (p_effective_date_row => l_effective_date_row
897: ,p_parameter_name => 'P_ATTRIBUTE6'
898: ,p_new_value => p_attribute6
899: ,p_current_value => c_attribute6);
900: l_attribute7 := hr_dt_attribute_support.get_parameter_char
901: (p_effective_date_row => l_effective_date_row
902: ,p_parameter_name => 'P_ATTRIBUTE7'
903: ,p_new_value => p_attribute7
904: ,p_current_value => c_attribute7);

Line 905: l_attribute8 := hr_dt_attribute_support.get_parameter_char

901: (p_effective_date_row => l_effective_date_row
902: ,p_parameter_name => 'P_ATTRIBUTE7'
903: ,p_new_value => p_attribute7
904: ,p_current_value => c_attribute7);
905: l_attribute8 := hr_dt_attribute_support.get_parameter_char
906: (p_effective_date_row => l_effective_date_row
907: ,p_parameter_name => 'P_ATTRIBUTE8'
908: ,p_new_value => p_attribute8
909: ,p_current_value => c_attribute8);

Line 910: l_attribute9 := hr_dt_attribute_support.get_parameter_char

906: (p_effective_date_row => l_effective_date_row
907: ,p_parameter_name => 'P_ATTRIBUTE8'
908: ,p_new_value => p_attribute8
909: ,p_current_value => c_attribute8);
910: l_attribute9 := hr_dt_attribute_support.get_parameter_char
911: (p_effective_date_row => l_effective_date_row
912: ,p_parameter_name => 'P_ATTRIBUTE9'
913: ,p_new_value => p_attribute9
914: ,p_current_value => c_attribute9);

Line 915: l_attribute10 := hr_dt_attribute_support.get_parameter_char

911: (p_effective_date_row => l_effective_date_row
912: ,p_parameter_name => 'P_ATTRIBUTE9'
913: ,p_new_value => p_attribute9
914: ,p_current_value => c_attribute9);
915: l_attribute10 := hr_dt_attribute_support.get_parameter_char
916: (p_effective_date_row => l_effective_date_row
917: ,p_parameter_name => 'P_ATTRIBUTE10'
918: ,p_new_value => p_attribute10
919: ,p_current_value => c_attribute10);

Line 920: l_attribute11 := hr_dt_attribute_support.get_parameter_char

916: (p_effective_date_row => l_effective_date_row
917: ,p_parameter_name => 'P_ATTRIBUTE10'
918: ,p_new_value => p_attribute10
919: ,p_current_value => c_attribute10);
920: l_attribute11 := hr_dt_attribute_support.get_parameter_char
921: (p_effective_date_row => l_effective_date_row
922: ,p_parameter_name => 'P_ATTRIBUTE11'
923: ,p_new_value => p_attribute11
924: ,p_current_value => c_attribute11);

Line 925: l_attribute12 := hr_dt_attribute_support.get_parameter_char

921: (p_effective_date_row => l_effective_date_row
922: ,p_parameter_name => 'P_ATTRIBUTE11'
923: ,p_new_value => p_attribute11
924: ,p_current_value => c_attribute11);
925: l_attribute12 := hr_dt_attribute_support.get_parameter_char
926: (p_effective_date_row => l_effective_date_row
927: ,p_parameter_name => 'P_ATTRIBUTE12'
928: ,p_new_value => p_attribute12
929: ,p_current_value => c_attribute12);

Line 930: l_attribute13 := hr_dt_attribute_support.get_parameter_char

926: (p_effective_date_row => l_effective_date_row
927: ,p_parameter_name => 'P_ATTRIBUTE12'
928: ,p_new_value => p_attribute12
929: ,p_current_value => c_attribute12);
930: l_attribute13 := hr_dt_attribute_support.get_parameter_char
931: (p_effective_date_row => l_effective_date_row
932: ,p_parameter_name => 'P_ATTRIBUTE13'
933: ,p_new_value => p_attribute13
934: ,p_current_value => c_attribute13);

Line 935: l_attribute14 := hr_dt_attribute_support.get_parameter_char

931: (p_effective_date_row => l_effective_date_row
932: ,p_parameter_name => 'P_ATTRIBUTE13'
933: ,p_new_value => p_attribute13
934: ,p_current_value => c_attribute13);
935: l_attribute14 := hr_dt_attribute_support.get_parameter_char
936: (p_effective_date_row => l_effective_date_row
937: ,p_parameter_name => 'P_ATTRIBUTE14'
938: ,p_new_value => p_attribute14
939: ,p_current_value => c_attribute14);

Line 940: l_attribute15 := hr_dt_attribute_support.get_parameter_char

936: (p_effective_date_row => l_effective_date_row
937: ,p_parameter_name => 'P_ATTRIBUTE14'
938: ,p_new_value => p_attribute14
939: ,p_current_value => c_attribute14);
940: l_attribute15 := hr_dt_attribute_support.get_parameter_char
941: (p_effective_date_row => l_effective_date_row
942: ,p_parameter_name => 'P_ATTRIBUTE15'
943: ,p_new_value => p_attribute15
944: ,p_current_value => c_attribute15);

Line 945: l_attribute16 := hr_dt_attribute_support.get_parameter_char

941: (p_effective_date_row => l_effective_date_row
942: ,p_parameter_name => 'P_ATTRIBUTE15'
943: ,p_new_value => p_attribute15
944: ,p_current_value => c_attribute15);
945: l_attribute16 := hr_dt_attribute_support.get_parameter_char
946: (p_effective_date_row => l_effective_date_row
947: ,p_parameter_name => 'P_ATTRIBUTE16'
948: ,p_new_value => p_attribute16
949: ,p_current_value => c_attribute16);

Line 950: l_attribute17 := hr_dt_attribute_support.get_parameter_char

946: (p_effective_date_row => l_effective_date_row
947: ,p_parameter_name => 'P_ATTRIBUTE16'
948: ,p_new_value => p_attribute16
949: ,p_current_value => c_attribute16);
950: l_attribute17 := hr_dt_attribute_support.get_parameter_char
951: (p_effective_date_row => l_effective_date_row
952: ,p_parameter_name => 'P_ATTRIBUTE17'
953: ,p_new_value => p_attribute17
954: ,p_current_value => c_attribute17);

Line 955: l_attribute18 := hr_dt_attribute_support.get_parameter_char

951: (p_effective_date_row => l_effective_date_row
952: ,p_parameter_name => 'P_ATTRIBUTE17'
953: ,p_new_value => p_attribute17
954: ,p_current_value => c_attribute17);
955: l_attribute18 := hr_dt_attribute_support.get_parameter_char
956: (p_effective_date_row => l_effective_date_row
957: ,p_parameter_name => 'P_ATTRIBUTE18'
958: ,p_new_value => p_attribute18
959: ,p_current_value => c_attribute18);

Line 960: l_attribute19 := hr_dt_attribute_support.get_parameter_char

956: (p_effective_date_row => l_effective_date_row
957: ,p_parameter_name => 'P_ATTRIBUTE18'
958: ,p_new_value => p_attribute18
959: ,p_current_value => c_attribute18);
960: l_attribute19 := hr_dt_attribute_support.get_parameter_char
961: (p_effective_date_row => l_effective_date_row
962: ,p_parameter_name => 'P_ATTRIBUTE19'
963: ,p_new_value => p_attribute19
964: ,p_current_value => c_attribute19);

Line 965: l_attribute20 := hr_dt_attribute_support.get_parameter_char

961: (p_effective_date_row => l_effective_date_row
962: ,p_parameter_name => 'P_ATTRIBUTE19'
963: ,p_new_value => p_attribute19
964: ,p_current_value => c_attribute19);
965: l_attribute20 := hr_dt_attribute_support.get_parameter_char
966: (p_effective_date_row => l_effective_date_row
967: ,p_parameter_name => 'P_ATTRIBUTE20'
968: ,p_new_value => p_attribute20
969: ,p_current_value => c_attribute20);

Line 970: l_attribute21 := hr_dt_attribute_support.get_parameter_char

966: (p_effective_date_row => l_effective_date_row
967: ,p_parameter_name => 'P_ATTRIBUTE20'
968: ,p_new_value => p_attribute20
969: ,p_current_value => c_attribute20);
970: l_attribute21 := hr_dt_attribute_support.get_parameter_char
971: (p_effective_date_row => l_effective_date_row
972: ,p_parameter_name => 'P_ATTRIBUTE21'
973: ,p_new_value => p_attribute21
974: ,p_current_value => c_attribute21);

Line 975: l_attribute22 := hr_dt_attribute_support.get_parameter_char

971: (p_effective_date_row => l_effective_date_row
972: ,p_parameter_name => 'P_ATTRIBUTE21'
973: ,p_new_value => p_attribute21
974: ,p_current_value => c_attribute21);
975: l_attribute22 := hr_dt_attribute_support.get_parameter_char
976: (p_effective_date_row => l_effective_date_row
977: ,p_parameter_name => 'P_ATTRIBUTE22'
978: ,p_new_value => p_attribute22
979: ,p_current_value => c_attribute22);

Line 980: l_attribute23 := hr_dt_attribute_support.get_parameter_char

976: (p_effective_date_row => l_effective_date_row
977: ,p_parameter_name => 'P_ATTRIBUTE22'
978: ,p_new_value => p_attribute22
979: ,p_current_value => c_attribute22);
980: l_attribute23 := hr_dt_attribute_support.get_parameter_char
981: (p_effective_date_row => l_effective_date_row
982: ,p_parameter_name => 'P_ATTRIBUTE23'
983: ,p_new_value => p_attribute23
984: ,p_current_value => c_attribute23);

Line 985: l_attribute24 := hr_dt_attribute_support.get_parameter_char

981: (p_effective_date_row => l_effective_date_row
982: ,p_parameter_name => 'P_ATTRIBUTE23'
983: ,p_new_value => p_attribute23
984: ,p_current_value => c_attribute23);
985: l_attribute24 := hr_dt_attribute_support.get_parameter_char
986: (p_effective_date_row => l_effective_date_row
987: ,p_parameter_name => 'P_ATTRIBUTE24'
988: ,p_new_value => p_attribute24
989: ,p_current_value => c_attribute24);

Line 990: l_attribute25 := hr_dt_attribute_support.get_parameter_char

986: (p_effective_date_row => l_effective_date_row
987: ,p_parameter_name => 'P_ATTRIBUTE24'
988: ,p_new_value => p_attribute24
989: ,p_current_value => c_attribute24);
990: l_attribute25 := hr_dt_attribute_support.get_parameter_char
991: (p_effective_date_row => l_effective_date_row
992: ,p_parameter_name => 'P_ATTRIBUTE5'
993: ,p_new_value => p_attribute25
994: ,p_current_value => c_attribute25);

Line 995: l_attribute26 := hr_dt_attribute_support.get_parameter_char

991: (p_effective_date_row => l_effective_date_row
992: ,p_parameter_name => 'P_ATTRIBUTE5'
993: ,p_new_value => p_attribute25
994: ,p_current_value => c_attribute25);
995: l_attribute26 := hr_dt_attribute_support.get_parameter_char
996: (p_effective_date_row => l_effective_date_row
997: ,p_parameter_name => 'P_ATTRIBUTE26'
998: ,p_new_value => p_attribute26
999: ,p_current_value => c_attribute26);

Line 1000: l_attribute27 := hr_dt_attribute_support.get_parameter_char

996: (p_effective_date_row => l_effective_date_row
997: ,p_parameter_name => 'P_ATTRIBUTE26'
998: ,p_new_value => p_attribute26
999: ,p_current_value => c_attribute26);
1000: l_attribute27 := hr_dt_attribute_support.get_parameter_char
1001: (p_effective_date_row => l_effective_date_row
1002: ,p_parameter_name => 'P_ATTRIBUTE27'
1003: ,p_new_value => p_attribute27
1004: ,p_current_value => c_attribute27);

Line 1005: l_attribute28 := hr_dt_attribute_support.get_parameter_char

1001: (p_effective_date_row => l_effective_date_row
1002: ,p_parameter_name => 'P_ATTRIBUTE27'
1003: ,p_new_value => p_attribute27
1004: ,p_current_value => c_attribute27);
1005: l_attribute28 := hr_dt_attribute_support.get_parameter_char
1006: (p_effective_date_row => l_effective_date_row
1007: ,p_parameter_name => 'P_ATTRIBUTE28'
1008: ,p_new_value => p_attribute28
1009: ,p_current_value => c_attribute28);

Line 1010: l_attribute29 := hr_dt_attribute_support.get_parameter_char

1006: (p_effective_date_row => l_effective_date_row
1007: ,p_parameter_name => 'P_ATTRIBUTE28'
1008: ,p_new_value => p_attribute28
1009: ,p_current_value => c_attribute28);
1010: l_attribute29 := hr_dt_attribute_support.get_parameter_char
1011: (p_effective_date_row => l_effective_date_row
1012: ,p_parameter_name => 'P_ATTRIBUTE29'
1013: ,p_new_value => p_attribute29
1014: ,p_current_value => c_attribute29);

Line 1015: l_attribute30 := hr_dt_attribute_support.get_parameter_char

1011: (p_effective_date_row => l_effective_date_row
1012: ,p_parameter_name => 'P_ATTRIBUTE29'
1013: ,p_new_value => p_attribute29
1014: ,p_current_value => c_attribute29);
1015: l_attribute30 := hr_dt_attribute_support.get_parameter_char
1016: (p_effective_date_row => l_effective_date_row
1017: ,p_parameter_name => 'P_ATTRIBUTE30'
1018: ,p_new_value => p_attribute30
1019: ,p_current_value => c_attribute30);

Line 1020: l_per_information_category := hr_dt_attribute_support.get_parameter_char

1016: (p_effective_date_row => l_effective_date_row
1017: ,p_parameter_name => 'P_ATTRIBUTE30'
1018: ,p_new_value => p_attribute30
1019: ,p_current_value => c_attribute30);
1020: l_per_information_category := hr_dt_attribute_support.get_parameter_char
1021: (p_effective_date_row => l_effective_date_row
1022: ,p_parameter_name => 'P_PER_INFORMATION_CATEGORY'
1023: ,p_new_value => p_per_information_category
1024: ,p_current_value => c_per_information_category);

Line 1025: l_per_information1 := hr_dt_attribute_support.get_parameter_char

1021: (p_effective_date_row => l_effective_date_row
1022: ,p_parameter_name => 'P_PER_INFORMATION_CATEGORY'
1023: ,p_new_value => p_per_information_category
1024: ,p_current_value => c_per_information_category);
1025: l_per_information1 := hr_dt_attribute_support.get_parameter_char
1026: (p_effective_date_row => l_effective_date_row
1027: ,p_parameter_name => 'P_PER_INFORMATION1'
1028: ,p_new_value => p_per_information1
1029: ,p_current_value => c_per_information1);

Line 1030: l_per_information2 := hr_dt_attribute_support.get_parameter_char

1026: (p_effective_date_row => l_effective_date_row
1027: ,p_parameter_name => 'P_PER_INFORMATION1'
1028: ,p_new_value => p_per_information1
1029: ,p_current_value => c_per_information1);
1030: l_per_information2 := hr_dt_attribute_support.get_parameter_char
1031: (p_effective_date_row => l_effective_date_row
1032: ,p_parameter_name => 'P_PER_INFORMATION2'
1033: ,p_new_value => p_per_information2
1034: ,p_current_value => c_per_information2);

Line 1035: l_per_information3 := hr_dt_attribute_support.get_parameter_char

1031: (p_effective_date_row => l_effective_date_row
1032: ,p_parameter_name => 'P_PER_INFORMATION2'
1033: ,p_new_value => p_per_information2
1034: ,p_current_value => c_per_information2);
1035: l_per_information3 := hr_dt_attribute_support.get_parameter_char
1036: (p_effective_date_row => l_effective_date_row
1037: ,p_parameter_name => 'P_PER_INFORMATION3'
1038: ,p_new_value => p_per_information3
1039: ,p_current_value => c_per_information3);

Line 1040: l_per_information4 := hr_dt_attribute_support.get_parameter_char

1036: (p_effective_date_row => l_effective_date_row
1037: ,p_parameter_name => 'P_PER_INFORMATION3'
1038: ,p_new_value => p_per_information3
1039: ,p_current_value => c_per_information3);
1040: l_per_information4 := hr_dt_attribute_support.get_parameter_char
1041: (p_effective_date_row => l_effective_date_row
1042: ,p_parameter_name => 'P_PER_INFORMATION4'
1043: ,p_new_value => p_per_information4
1044: ,p_current_value => c_per_information4);

Line 1045: l_per_information5 := hr_dt_attribute_support.get_parameter_char

1041: (p_effective_date_row => l_effective_date_row
1042: ,p_parameter_name => 'P_PER_INFORMATION4'
1043: ,p_new_value => p_per_information4
1044: ,p_current_value => c_per_information4);
1045: l_per_information5 := hr_dt_attribute_support.get_parameter_char
1046: (p_effective_date_row => l_effective_date_row
1047: ,p_parameter_name => 'P_PER_INFORMATION5'
1048: ,p_new_value => p_per_information5
1049: ,p_current_value => c_per_information5);

Line 1050: l_per_information6 := hr_dt_attribute_support.get_parameter_char

1046: (p_effective_date_row => l_effective_date_row
1047: ,p_parameter_name => 'P_PER_INFORMATION5'
1048: ,p_new_value => p_per_information5
1049: ,p_current_value => c_per_information5);
1050: l_per_information6 := hr_dt_attribute_support.get_parameter_char
1051: (p_effective_date_row => l_effective_date_row
1052: ,p_parameter_name => 'P_PER_INFORMATION6'
1053: ,p_new_value => p_per_information6
1054: ,p_current_value => c_per_information6);

Line 1055: l_per_information7 := hr_dt_attribute_support.get_parameter_char

1051: (p_effective_date_row => l_effective_date_row
1052: ,p_parameter_name => 'P_PER_INFORMATION6'
1053: ,p_new_value => p_per_information6
1054: ,p_current_value => c_per_information6);
1055: l_per_information7 := hr_dt_attribute_support.get_parameter_char
1056: (p_effective_date_row => l_effective_date_row
1057: ,p_parameter_name => 'P_PER_INFORMATION7'
1058: ,p_new_value => p_per_information7
1059: ,p_current_value => c_per_information7);

Line 1060: l_per_information8 := hr_dt_attribute_support.get_parameter_char

1056: (p_effective_date_row => l_effective_date_row
1057: ,p_parameter_name => 'P_PER_INFORMATION7'
1058: ,p_new_value => p_per_information7
1059: ,p_current_value => c_per_information7);
1060: l_per_information8 := hr_dt_attribute_support.get_parameter_char
1061: (p_effective_date_row => l_effective_date_row
1062: ,p_parameter_name => 'P_PER_INFORMATION8'
1063: ,p_new_value => p_per_information8
1064: ,p_current_value => c_per_information8);

Line 1065: l_per_information9 := hr_dt_attribute_support.get_parameter_char

1061: (p_effective_date_row => l_effective_date_row
1062: ,p_parameter_name => 'P_PER_INFORMATION8'
1063: ,p_new_value => p_per_information8
1064: ,p_current_value => c_per_information8);
1065: l_per_information9 := hr_dt_attribute_support.get_parameter_char
1066: (p_effective_date_row => l_effective_date_row
1067: ,p_parameter_name => 'P_PER_INFORMATION9'
1068: ,p_new_value => p_per_information9
1069: ,p_current_value => c_per_information9);

Line 1070: l_per_information10 := hr_dt_attribute_support.get_parameter_char

1066: (p_effective_date_row => l_effective_date_row
1067: ,p_parameter_name => 'P_PER_INFORMATION9'
1068: ,p_new_value => p_per_information9
1069: ,p_current_value => c_per_information9);
1070: l_per_information10 := hr_dt_attribute_support.get_parameter_char
1071: (p_effective_date_row => l_effective_date_row
1072: ,p_parameter_name => 'P_PER_INFORMATION10'
1073: ,p_new_value => p_per_information10
1074: ,p_current_value => c_per_information10);

Line 1075: l_per_information11 := hr_dt_attribute_support.get_parameter_char

1071: (p_effective_date_row => l_effective_date_row
1072: ,p_parameter_name => 'P_PER_INFORMATION10'
1073: ,p_new_value => p_per_information10
1074: ,p_current_value => c_per_information10);
1075: l_per_information11 := hr_dt_attribute_support.get_parameter_char
1076: (p_effective_date_row => l_effective_date_row
1077: ,p_parameter_name => 'P_PER_INFORMATION11'
1078: ,p_new_value => p_per_information11
1079: ,p_current_value => c_per_information11);

Line 1080: l_per_information12 := hr_dt_attribute_support.get_parameter_char

1076: (p_effective_date_row => l_effective_date_row
1077: ,p_parameter_name => 'P_PER_INFORMATION11'
1078: ,p_new_value => p_per_information11
1079: ,p_current_value => c_per_information11);
1080: l_per_information12 := hr_dt_attribute_support.get_parameter_char
1081: (p_effective_date_row => l_effective_date_row
1082: ,p_parameter_name => 'P_PER_INFORMATION12'
1083: ,p_new_value => p_per_information12
1084: ,p_current_value => c_per_information12);

Line 1085: l_per_information13 := hr_dt_attribute_support.get_parameter_char

1081: (p_effective_date_row => l_effective_date_row
1082: ,p_parameter_name => 'P_PER_INFORMATION12'
1083: ,p_new_value => p_per_information12
1084: ,p_current_value => c_per_information12);
1085: l_per_information13 := hr_dt_attribute_support.get_parameter_char
1086: (p_effective_date_row => l_effective_date_row
1087: ,p_parameter_name => 'P_PER_INFORMATION13'
1088: ,p_new_value => p_per_information13
1089: ,p_current_value => c_per_information13);

Line 1090: l_per_information14 := hr_dt_attribute_support.get_parameter_char

1086: (p_effective_date_row => l_effective_date_row
1087: ,p_parameter_name => 'P_PER_INFORMATION13'
1088: ,p_new_value => p_per_information13
1089: ,p_current_value => c_per_information13);
1090: l_per_information14 := hr_dt_attribute_support.get_parameter_char
1091: (p_effective_date_row => l_effective_date_row
1092: ,p_parameter_name => 'P_PER_INFORMATION14'
1093: ,p_new_value => p_per_information14
1094: ,p_current_value => c_per_information14);

Line 1095: l_per_information15 := hr_dt_attribute_support.get_parameter_char

1091: (p_effective_date_row => l_effective_date_row
1092: ,p_parameter_name => 'P_PER_INFORMATION14'
1093: ,p_new_value => p_per_information14
1094: ,p_current_value => c_per_information14);
1095: l_per_information15 := hr_dt_attribute_support.get_parameter_char
1096: (p_effective_date_row => l_effective_date_row
1097: ,p_parameter_name => 'P_PER_INFORMATION15'
1098: ,p_new_value => p_per_information15
1099: ,p_current_value => c_per_information15);

Line 1100: l_per_information16 := hr_dt_attribute_support.get_parameter_char

1096: (p_effective_date_row => l_effective_date_row
1097: ,p_parameter_name => 'P_PER_INFORMATION15'
1098: ,p_new_value => p_per_information15
1099: ,p_current_value => c_per_information15);
1100: l_per_information16 := hr_dt_attribute_support.get_parameter_char
1101: (p_effective_date_row => l_effective_date_row
1102: ,p_parameter_name => 'P_PER_INFORMATION16'
1103: ,p_new_value => p_per_information16
1104: ,p_current_value => c_per_information16);

Line 1105: l_per_information17 := hr_dt_attribute_support.get_parameter_char

1101: (p_effective_date_row => l_effective_date_row
1102: ,p_parameter_name => 'P_PER_INFORMATION16'
1103: ,p_new_value => p_per_information16
1104: ,p_current_value => c_per_information16);
1105: l_per_information17 := hr_dt_attribute_support.get_parameter_char
1106: (p_effective_date_row => l_effective_date_row
1107: ,p_parameter_name => 'P_PER_INFORMATION17'
1108: ,p_new_value => p_per_information17
1109: ,p_current_value => c_per_information17);

Line 1110: l_per_information18 := hr_dt_attribute_support.get_parameter_char

1106: (p_effective_date_row => l_effective_date_row
1107: ,p_parameter_name => 'P_PER_INFORMATION17'
1108: ,p_new_value => p_per_information17
1109: ,p_current_value => c_per_information17);
1110: l_per_information18 := hr_dt_attribute_support.get_parameter_char
1111: (p_effective_date_row => l_effective_date_row
1112: ,p_parameter_name => 'P_PER_INFORMATION18'
1113: ,p_new_value => p_per_information18
1114: ,p_current_value => c_per_information18);

Line 1115: l_per_information19 := hr_dt_attribute_support.get_parameter_char

1111: (p_effective_date_row => l_effective_date_row
1112: ,p_parameter_name => 'P_PER_INFORMATION18'
1113: ,p_new_value => p_per_information18
1114: ,p_current_value => c_per_information18);
1115: l_per_information19 := hr_dt_attribute_support.get_parameter_char
1116: (p_effective_date_row => l_effective_date_row
1117: ,p_parameter_name => 'P_PER_INFORMATION19'
1118: ,p_new_value => p_per_information19
1119: ,p_current_value => c_per_information19);

Line 1120: l_per_information20 := hr_dt_attribute_support.get_parameter_char

1116: (p_effective_date_row => l_effective_date_row
1117: ,p_parameter_name => 'P_PER_INFORMATION19'
1118: ,p_new_value => p_per_information19
1119: ,p_current_value => c_per_information19);
1120: l_per_information20 := hr_dt_attribute_support.get_parameter_char
1121: (p_effective_date_row => l_effective_date_row
1122: ,p_parameter_name => 'P_PER_INFORMATION20'
1123: ,p_new_value => p_per_information20
1124: ,p_current_value => c_per_information20);

Line 1125: l_per_information21 := hr_dt_attribute_support.get_parameter_char

1121: (p_effective_date_row => l_effective_date_row
1122: ,p_parameter_name => 'P_PER_INFORMATION20'
1123: ,p_new_value => p_per_information20
1124: ,p_current_value => c_per_information20);
1125: l_per_information21 := hr_dt_attribute_support.get_parameter_char
1126: (p_effective_date_row => l_effective_date_row
1127: ,p_parameter_name => 'P_PER_INFORMATION21'
1128: ,p_new_value => p_per_information21
1129: ,p_current_value => c_per_information21);

Line 1130: l_per_information22 := hr_dt_attribute_support.get_parameter_char

1126: (p_effective_date_row => l_effective_date_row
1127: ,p_parameter_name => 'P_PER_INFORMATION21'
1128: ,p_new_value => p_per_information21
1129: ,p_current_value => c_per_information21);
1130: l_per_information22 := hr_dt_attribute_support.get_parameter_char
1131: (p_effective_date_row => l_effective_date_row
1132: ,p_parameter_name => 'P_PER_INFORMATION22'
1133: ,p_new_value => p_per_information22
1134: ,p_current_value => c_per_information22);

Line 1135: l_per_information23 := hr_dt_attribute_support.get_parameter_char

1131: (p_effective_date_row => l_effective_date_row
1132: ,p_parameter_name => 'P_PER_INFORMATION22'
1133: ,p_new_value => p_per_information22
1134: ,p_current_value => c_per_information22);
1135: l_per_information23 := hr_dt_attribute_support.get_parameter_char
1136: (p_effective_date_row => l_effective_date_row
1137: ,p_parameter_name => 'P_PER_INFORMATION23'
1138: ,p_new_value => p_per_information23
1139: ,p_current_value => c_per_information23);

Line 1140: l_per_information24 := hr_dt_attribute_support.get_parameter_char

1136: (p_effective_date_row => l_effective_date_row
1137: ,p_parameter_name => 'P_PER_INFORMATION23'
1138: ,p_new_value => p_per_information23
1139: ,p_current_value => c_per_information23);
1140: l_per_information24 := hr_dt_attribute_support.get_parameter_char
1141: (p_effective_date_row => l_effective_date_row
1142: ,p_parameter_name => 'P_PER_INFORMATION24'
1143: ,p_new_value => p_per_information24
1144: ,p_current_value => c_per_information24);

Line 1145: l_per_information25 := hr_dt_attribute_support.get_parameter_char

1141: (p_effective_date_row => l_effective_date_row
1142: ,p_parameter_name => 'P_PER_INFORMATION24'
1143: ,p_new_value => p_per_information24
1144: ,p_current_value => c_per_information24);
1145: l_per_information25 := hr_dt_attribute_support.get_parameter_char
1146: (p_effective_date_row => l_effective_date_row
1147: ,p_parameter_name => 'P_PER_INFORMATION25'
1148: ,p_new_value => p_per_information25
1149: ,p_current_value => c_per_information25);

Line 1150: l_per_information26 := hr_dt_attribute_support.get_parameter_char

1146: (p_effective_date_row => l_effective_date_row
1147: ,p_parameter_name => 'P_PER_INFORMATION25'
1148: ,p_new_value => p_per_information25
1149: ,p_current_value => c_per_information25);
1150: l_per_information26 := hr_dt_attribute_support.get_parameter_char
1151: (p_effective_date_row => l_effective_date_row
1152: ,p_parameter_name => 'P_PER_INFORMATION26'
1153: ,p_new_value => p_per_information26
1154: ,p_current_value => c_per_information26);

Line 1155: l_per_information27 := hr_dt_attribute_support.get_parameter_char

1151: (p_effective_date_row => l_effective_date_row
1152: ,p_parameter_name => 'P_PER_INFORMATION26'
1153: ,p_new_value => p_per_information26
1154: ,p_current_value => c_per_information26);
1155: l_per_information27 := hr_dt_attribute_support.get_parameter_char
1156: (p_effective_date_row => l_effective_date_row
1157: ,p_parameter_name => 'P_PER_INFORMATION27'
1158: ,p_new_value => p_per_information27
1159: ,p_current_value => c_per_information27);

Line 1160: l_per_information28 := hr_dt_attribute_support.get_parameter_char

1156: (p_effective_date_row => l_effective_date_row
1157: ,p_parameter_name => 'P_PER_INFORMATION27'
1158: ,p_new_value => p_per_information27
1159: ,p_current_value => c_per_information27);
1160: l_per_information28 := hr_dt_attribute_support.get_parameter_char
1161: (p_effective_date_row => l_effective_date_row
1162: ,p_parameter_name => 'P_PER_INFORMATION28'
1163: ,p_new_value => p_per_information28
1164: ,p_current_value => c_per_information28);

Line 1165: l_per_information29 := hr_dt_attribute_support.get_parameter_char

1161: (p_effective_date_row => l_effective_date_row
1162: ,p_parameter_name => 'P_PER_INFORMATION28'
1163: ,p_new_value => p_per_information28
1164: ,p_current_value => c_per_information28);
1165: l_per_information29 := hr_dt_attribute_support.get_parameter_char
1166: (p_effective_date_row => l_effective_date_row
1167: ,p_parameter_name => 'P_PER_INFORMATION29'
1168: ,p_new_value => p_per_information29
1169: ,p_current_value => c_per_information29);

Line 1170: l_per_information30 := hr_dt_attribute_support.get_parameter_char

1166: (p_effective_date_row => l_effective_date_row
1167: ,p_parameter_name => 'P_PER_INFORMATION29'
1168: ,p_new_value => p_per_information29
1169: ,p_current_value => c_per_information29);
1170: l_per_information30 := hr_dt_attribute_support.get_parameter_char
1171: (p_effective_date_row => l_effective_date_row
1172: ,p_parameter_name => 'P_PER_INFORMATION30'
1173: ,p_new_value => p_per_information30
1174: ,p_current_value => c_per_information30);

Line 1175: l_date_of_death := hr_dt_attribute_support.get_parameter_date

1171: (p_effective_date_row => l_effective_date_row
1172: ,p_parameter_name => 'P_PER_INFORMATION30'
1173: ,p_new_value => p_per_information30
1174: ,p_current_value => c_per_information30);
1175: l_date_of_death := hr_dt_attribute_support.get_parameter_date
1176: (p_effective_date_row => l_effective_date_row
1177: ,p_parameter_name => 'P_DATE_OF_DEATH'
1178: ,p_new_value => p_date_of_death
1179: ,p_current_value => c_date_of_death);

Line 1180: l_background_check_status := hr_dt_attribute_support.get_parameter_char

1176: (p_effective_date_row => l_effective_date_row
1177: ,p_parameter_name => 'P_DATE_OF_DEATH'
1178: ,p_new_value => p_date_of_death
1179: ,p_current_value => c_date_of_death);
1180: l_background_check_status := hr_dt_attribute_support.get_parameter_char
1181: (p_effective_date_row => l_effective_date_row
1182: ,p_parameter_name => 'P_BACKGROUND_CHECK_STATUS'
1183: ,p_new_value => p_background_check_status
1184: ,p_current_value => c_background_check_status);

Line 1185: l_background_date_check := hr_dt_attribute_support.get_parameter_date

1181: (p_effective_date_row => l_effective_date_row
1182: ,p_parameter_name => 'P_BACKGROUND_CHECK_STATUS'
1183: ,p_new_value => p_background_check_status
1184: ,p_current_value => c_background_check_status);
1185: l_background_date_check := hr_dt_attribute_support.get_parameter_date
1186: (p_effective_date_row => l_effective_date_row
1187: ,p_parameter_name => 'P_BACKGROUND_DATE_CHECK'
1188: ,p_new_value => p_background_date_check
1189: ,p_current_value => c_background_date_check);

Line 1190: l_blood_type := hr_dt_attribute_support.get_parameter_char

1186: (p_effective_date_row => l_effective_date_row
1187: ,p_parameter_name => 'P_BACKGROUND_DATE_CHECK'
1188: ,p_new_value => p_background_date_check
1189: ,p_current_value => c_background_date_check);
1190: l_blood_type := hr_dt_attribute_support.get_parameter_char
1191: (p_effective_date_row => l_effective_date_row
1192: ,p_parameter_name => 'P_BLOOD_TYPE'
1193: ,p_new_value => p_blood_type
1194: ,p_current_value => c_blood_type);

Line 1195: l_correspondence_language := hr_dt_attribute_support.get_parameter_char

1191: (p_effective_date_row => l_effective_date_row
1192: ,p_parameter_name => 'P_BLOOD_TYPE'
1193: ,p_new_value => p_blood_type
1194: ,p_current_value => c_blood_type);
1195: l_correspondence_language := hr_dt_attribute_support.get_parameter_char
1196: (p_effective_date_row => l_effective_date_row
1197: ,p_parameter_name => 'P_CORRESPONDENCE_LANGUAGE'
1198: ,p_new_value => p_correspondence_language
1199: ,p_current_value => c_correspondence_language);

Line 1200: l_fast_path_employee := hr_dt_attribute_support.get_parameter_char

1196: (p_effective_date_row => l_effective_date_row
1197: ,p_parameter_name => 'P_CORRESPONDENCE_LANGUAGE'
1198: ,p_new_value => p_correspondence_language
1199: ,p_current_value => c_correspondence_language);
1200: l_fast_path_employee := hr_dt_attribute_support.get_parameter_char
1201: (p_effective_date_row => l_effective_date_row
1202: ,p_parameter_name => 'P_FAST_PATH_EMPLOYEE'
1203: ,p_new_value => p_fast_path_employee
1204: ,p_current_value => c_fast_path_employee);

Line 1205: l_fte_capacity := hr_dt_attribute_support.get_parameter_number

1201: (p_effective_date_row => l_effective_date_row
1202: ,p_parameter_name => 'P_FAST_PATH_EMPLOYEE'
1203: ,p_new_value => p_fast_path_employee
1204: ,p_current_value => c_fast_path_employee);
1205: l_fte_capacity := hr_dt_attribute_support.get_parameter_number
1206: (p_effective_date_row => l_effective_date_row
1207: ,p_parameter_name => 'P_FTE_CAPACITY'
1208: ,p_new_value => p_fte_capacity
1209: ,p_current_value => c_fte_capacity);

Line 1211: := hr_dt_attribute_support.get_parameter_date

1207: ,p_parameter_name => 'P_FTE_CAPACITY'
1208: ,p_new_value => p_fte_capacity
1209: ,p_current_value => c_fte_capacity);
1210: l_hold_applicant_date_until
1211: := hr_dt_attribute_support.get_parameter_date
1212: (p_effective_date_row => l_effective_date_row
1213: ,p_parameter_name => 'P_HOLD_APPLICANT_DATE_UNTIL'
1214: ,p_new_value => p_hold_applicant_date_until
1215: ,p_current_value => c_hold_applicant_date_until);

Line 1216: l_honors := hr_dt_attribute_support.get_parameter_char

1212: (p_effective_date_row => l_effective_date_row
1213: ,p_parameter_name => 'P_HOLD_APPLICANT_DATE_UNTIL'
1214: ,p_new_value => p_hold_applicant_date_until
1215: ,p_current_value => c_hold_applicant_date_until);
1216: l_honors := hr_dt_attribute_support.get_parameter_char
1217: (p_effective_date_row => l_effective_date_row
1218: ,p_parameter_name => 'P_HONORS'
1219: ,p_new_value => p_honors
1220: ,p_current_value => c_honors);

Line 1221: l_internal_location := hr_dt_attribute_support.get_parameter_char

1217: (p_effective_date_row => l_effective_date_row
1218: ,p_parameter_name => 'P_HONORS'
1219: ,p_new_value => p_honors
1220: ,p_current_value => c_honors);
1221: l_internal_location := hr_dt_attribute_support.get_parameter_char
1222: (p_effective_date_row => l_effective_date_row
1223: ,p_parameter_name => 'P_INTERNAL_LOCATION'
1224: ,p_new_value => p_internal_location
1225: ,p_current_value => c_internal_location);

Line 1226: l_last_medical_test_by := hr_dt_attribute_support.get_parameter_char

1222: (p_effective_date_row => l_effective_date_row
1223: ,p_parameter_name => 'P_INTERNAL_LOCATION'
1224: ,p_new_value => p_internal_location
1225: ,p_current_value => c_internal_location);
1226: l_last_medical_test_by := hr_dt_attribute_support.get_parameter_char
1227: (p_effective_date_row => l_effective_date_row
1228: ,p_parameter_name => 'P_LAST_MEDICAL_TEST_BY'
1229: ,p_new_value => p_last_medical_test_by
1230: ,p_current_value => c_last_medical_test_by);

Line 1231: l_last_medical_test_date := hr_dt_attribute_support.get_parameter_date

1227: (p_effective_date_row => l_effective_date_row
1228: ,p_parameter_name => 'P_LAST_MEDICAL_TEST_BY'
1229: ,p_new_value => p_last_medical_test_by
1230: ,p_current_value => c_last_medical_test_by);
1231: l_last_medical_test_date := hr_dt_attribute_support.get_parameter_date
1232: (p_effective_date_row => l_effective_date_row
1233: ,p_parameter_name => 'P_LAST_MEDICAL_TEST_DATE'
1234: ,p_new_value => p_last_medical_test_date
1235: ,p_current_value => c_last_medical_test_date);

Line 1236: l_mailstop := hr_dt_attribute_support.get_parameter_char

1232: (p_effective_date_row => l_effective_date_row
1233: ,p_parameter_name => 'P_LAST_MEDICAL_TEST_DATE'
1234: ,p_new_value => p_last_medical_test_date
1235: ,p_current_value => c_last_medical_test_date);
1236: l_mailstop := hr_dt_attribute_support.get_parameter_char
1237: (p_effective_date_row => l_effective_date_row
1238: ,p_parameter_name => 'P_MAILSTOP'
1239: ,p_new_value => p_mailstop
1240: ,p_current_value => c_mailstop);

Line 1241: l_office_number := hr_dt_attribute_support.get_parameter_char

1237: (p_effective_date_row => l_effective_date_row
1238: ,p_parameter_name => 'P_MAILSTOP'
1239: ,p_new_value => p_mailstop
1240: ,p_current_value => c_mailstop);
1241: l_office_number := hr_dt_attribute_support.get_parameter_char
1242: (p_effective_date_row => l_effective_date_row
1243: ,p_parameter_name => 'P_OFFICE_NUMBER'
1244: ,p_new_value => p_office_number
1245: ,p_current_value => c_office_number);

Line 1246: l_on_military_service := hr_dt_attribute_support.get_parameter_char

1242: (p_effective_date_row => l_effective_date_row
1243: ,p_parameter_name => 'P_OFFICE_NUMBER'
1244: ,p_new_value => p_office_number
1245: ,p_current_value => c_office_number);
1246: l_on_military_service := hr_dt_attribute_support.get_parameter_char
1247: (p_effective_date_row => l_effective_date_row
1248: ,p_parameter_name => 'P_ON_MILITARY_SERVICE'
1249: ,p_new_value => p_on_military_service
1250: ,p_current_value => c_on_military_service);

Line 1251: l_pre_name_adjunct := hr_dt_attribute_support.get_parameter_char

1247: (p_effective_date_row => l_effective_date_row
1248: ,p_parameter_name => 'P_ON_MILITARY_SERVICE'
1249: ,p_new_value => p_on_military_service
1250: ,p_current_value => c_on_military_service);
1251: l_pre_name_adjunct := hr_dt_attribute_support.get_parameter_char
1252: (p_effective_date_row => l_effective_date_row
1253: ,p_parameter_name => 'P_PRE_NAME_ADJUNCT'
1254: ,p_new_value => p_pre_name_adjunct
1255: ,p_current_value => c_pre_name_adjunct);

Line 1256: l_projected_start_date := hr_dt_attribute_support.get_parameter_date

1252: (p_effective_date_row => l_effective_date_row
1253: ,p_parameter_name => 'P_PRE_NAME_ADJUNCT'
1254: ,p_new_value => p_pre_name_adjunct
1255: ,p_current_value => c_pre_name_adjunct);
1256: l_projected_start_date := hr_dt_attribute_support.get_parameter_date
1257: (p_effective_date_row => l_effective_date_row
1258: ,p_parameter_name => 'P_PROJECTED_START_DATE'
1259: ,p_new_value => p_projected_start_date
1260: ,p_current_value => c_projected_start_date);

Line 1261: l_rehire_authorizor := hr_dt_attribute_support.get_parameter_char

1257: (p_effective_date_row => l_effective_date_row
1258: ,p_parameter_name => 'P_PROJECTED_START_DATE'
1259: ,p_new_value => p_projected_start_date
1260: ,p_current_value => c_projected_start_date);
1261: l_rehire_authorizor := hr_dt_attribute_support.get_parameter_char
1262: (p_effective_date_row => l_effective_date_row
1263: ,p_parameter_name => 'P_REHIRE_AUTHORIZOR'
1264: ,p_new_value => p_rehire_authorizor
1265: ,p_current_value => c_rehire_authorizor);

Line 1266: l_rehire_recommendation := hr_dt_attribute_support.get_parameter_char

1262: (p_effective_date_row => l_effective_date_row
1263: ,p_parameter_name => 'P_REHIRE_AUTHORIZOR'
1264: ,p_new_value => p_rehire_authorizor
1265: ,p_current_value => c_rehire_authorizor);
1266: l_rehire_recommendation := hr_dt_attribute_support.get_parameter_char
1267: (p_effective_date_row => l_effective_date_row
1268: ,p_parameter_name => 'P_REHIRE_RECOMMENDATION'
1269: ,p_new_value => p_rehire_recommendation
1270: ,p_current_value => c_rehire_recommendation);

Line 1271: l_resume_exists := hr_dt_attribute_support.get_parameter_char

1267: (p_effective_date_row => l_effective_date_row
1268: ,p_parameter_name => 'P_REHIRE_RECOMMENDATION'
1269: ,p_new_value => p_rehire_recommendation
1270: ,p_current_value => c_rehire_recommendation);
1271: l_resume_exists := hr_dt_attribute_support.get_parameter_char
1272: (p_effective_date_row => l_effective_date_row
1273: ,p_parameter_name => 'P_RESUME_EXISTS'
1274: ,p_new_value => p_resume_exists
1275: ,p_current_value => c_resume_exists);

Line 1276: l_resume_last_updated := hr_dt_attribute_support.get_parameter_date

1272: (p_effective_date_row => l_effective_date_row
1273: ,p_parameter_name => 'P_RESUME_EXISTS'
1274: ,p_new_value => p_resume_exists
1275: ,p_current_value => c_resume_exists);
1276: l_resume_last_updated := hr_dt_attribute_support.get_parameter_date
1277: (p_effective_date_row => l_effective_date_row
1278: ,p_parameter_name => 'P_RESUME_LAST_UPDATED'
1279: ,p_new_value => p_resume_last_updated
1280: ,p_current_value => c_resume_last_updated);

Line 1281: l_second_passport_exists := hr_dt_attribute_support.get_parameter_char

1277: (p_effective_date_row => l_effective_date_row
1278: ,p_parameter_name => 'P_RESUME_LAST_UPDATED'
1279: ,p_new_value => p_resume_last_updated
1280: ,p_current_value => c_resume_last_updated);
1281: l_second_passport_exists := hr_dt_attribute_support.get_parameter_char
1282: (p_effective_date_row => l_effective_date_row
1283: ,p_parameter_name => 'P_SECOND_PASSPORT_EXISTS'
1284: ,p_new_value => p_second_passport_exists
1285: ,p_current_value => c_second_passport_exists);

Line 1286: l_student_status := hr_dt_attribute_support.get_parameter_char

1282: (p_effective_date_row => l_effective_date_row
1283: ,p_parameter_name => 'P_SECOND_PASSPORT_EXISTS'
1284: ,p_new_value => p_second_passport_exists
1285: ,p_current_value => c_second_passport_exists);
1286: l_student_status := hr_dt_attribute_support.get_parameter_char
1287: (p_effective_date_row => l_effective_date_row
1288: ,p_parameter_name => 'P_STUDENT_STATUS'
1289: ,p_new_value => p_student_status
1290: ,p_current_value => c_student_status);

Line 1291: l_work_schedule := hr_dt_attribute_support.get_parameter_char

1287: (p_effective_date_row => l_effective_date_row
1288: ,p_parameter_name => 'P_STUDENT_STATUS'
1289: ,p_new_value => p_student_status
1290: ,p_current_value => c_student_status);
1291: l_work_schedule := hr_dt_attribute_support.get_parameter_char
1292: (p_effective_date_row => l_effective_date_row
1293: ,p_parameter_name => 'P_WORK_SCHEDULE'
1294: ,p_new_value => p_work_schedule
1295: ,p_current_value => c_work_schedule);

Line 1296: l_rehire_reason := hr_dt_attribute_support.get_parameter_char

1292: (p_effective_date_row => l_effective_date_row
1293: ,p_parameter_name => 'P_WORK_SCHEDULE'
1294: ,p_new_value => p_work_schedule
1295: ,p_current_value => c_work_schedule);
1296: l_rehire_reason := hr_dt_attribute_support.get_parameter_char
1297: (p_effective_date_row => l_effective_date_row
1298: ,p_parameter_name => 'P_REHIRE_REASON'
1299: ,p_new_value => p_rehire_reason
1300: ,p_current_value => c_rehire_reason);

Line 1301: l_benefit_group_id := hr_dt_attribute_support.get_parameter_number

1297: (p_effective_date_row => l_effective_date_row
1298: ,p_parameter_name => 'P_REHIRE_REASON'
1299: ,p_new_value => p_rehire_reason
1300: ,p_current_value => c_rehire_reason);
1301: l_benefit_group_id := hr_dt_attribute_support.get_parameter_number
1302: (p_effective_date_row => l_effective_date_row
1303: ,p_parameter_name => 'P_BENEFIT_GROUP_ID'
1304: ,p_new_value => p_benefit_group_id
1305: ,p_current_value => c_benefit_group_id);

Line 1306: l_receipt_of_death_cert_date := hr_dt_attribute_support.get_parameter_date

1302: (p_effective_date_row => l_effective_date_row
1303: ,p_parameter_name => 'P_BENEFIT_GROUP_ID'
1304: ,p_new_value => p_benefit_group_id
1305: ,p_current_value => c_benefit_group_id);
1306: l_receipt_of_death_cert_date := hr_dt_attribute_support.get_parameter_date
1307: (p_effective_date_row => l_effective_date_row
1308: ,p_parameter_name => 'P_RECEIPT_OF_DEATH_CERT_DATE'
1309: ,p_new_value => p_receipt_of_death_cert_date
1310: ,p_current_value => c_receipt_of_death_cert_date);

Line 1311: l_coord_ben_med_pln_no := hr_dt_attribute_support.get_parameter_char

1307: (p_effective_date_row => l_effective_date_row
1308: ,p_parameter_name => 'P_RECEIPT_OF_DEATH_CERT_DATE'
1309: ,p_new_value => p_receipt_of_death_cert_date
1310: ,p_current_value => c_receipt_of_death_cert_date);
1311: l_coord_ben_med_pln_no := hr_dt_attribute_support.get_parameter_char
1312: (p_effective_date_row => l_effective_date_row
1313: ,p_parameter_name => 'P_COORD_BEN_MED_PLN_NO'
1314: ,p_new_value => p_coord_ben_med_pln_no
1315: ,p_current_value => c_coord_ben_med_pln_no);

Line 1316: l_coord_ben_no_cvg_flag := hr_dt_attribute_support.get_parameter_char

1312: (p_effective_date_row => l_effective_date_row
1313: ,p_parameter_name => 'P_COORD_BEN_MED_PLN_NO'
1314: ,p_new_value => p_coord_ben_med_pln_no
1315: ,p_current_value => c_coord_ben_med_pln_no);
1316: l_coord_ben_no_cvg_flag := hr_dt_attribute_support.get_parameter_char
1317: (p_effective_date_row => l_effective_date_row
1318: ,p_parameter_name => 'P_COORD_BEN_NO_CVG_FLAG'
1319: ,p_new_value => p_coord_ben_no_cvg_flag
1320: ,p_current_value => c_coord_ben_no_cvg_flag);

Line 1321: l_uses_tobacco_flag := hr_dt_attribute_support.get_parameter_char

1317: (p_effective_date_row => l_effective_date_row
1318: ,p_parameter_name => 'P_COORD_BEN_NO_CVG_FLAG'
1319: ,p_new_value => p_coord_ben_no_cvg_flag
1320: ,p_current_value => c_coord_ben_no_cvg_flag);
1321: l_uses_tobacco_flag := hr_dt_attribute_support.get_parameter_char
1322: (p_effective_date_row => l_effective_date_row
1323: ,p_parameter_name => 'P_USES_TOBACCO_FLAG'
1324: ,p_new_value => p_uses_tobacco_flag
1325: ,p_current_value => c_uses_tobacco_flag);

Line 1326: l_dpdnt_adoption_date := hr_dt_attribute_support.get_parameter_date

1322: (p_effective_date_row => l_effective_date_row
1323: ,p_parameter_name => 'P_USES_TOBACCO_FLAG'
1324: ,p_new_value => p_uses_tobacco_flag
1325: ,p_current_value => c_uses_tobacco_flag);
1326: l_dpdnt_adoption_date := hr_dt_attribute_support.get_parameter_date
1327: (p_effective_date_row => l_effective_date_row
1328: ,p_parameter_name => 'P_DPDNT_ADOPTION_DATE'
1329: ,p_new_value => p_dpdnt_adoption_date
1330: ,p_current_value => c_dpdnt_adoption_date);

Line 1331: l_dpdnt_vlntry_svce_flag := hr_dt_attribute_support.get_parameter_char

1327: (p_effective_date_row => l_effective_date_row
1328: ,p_parameter_name => 'P_DPDNT_ADOPTION_DATE'
1329: ,p_new_value => p_dpdnt_adoption_date
1330: ,p_current_value => c_dpdnt_adoption_date);
1331: l_dpdnt_vlntry_svce_flag := hr_dt_attribute_support.get_parameter_char
1332: (p_effective_date_row => l_effective_date_row
1333: ,p_parameter_name => 'P_DPDNT_VLNTRY_SVCE_FLAG'
1334: ,p_new_value => p_dpdnt_vlntry_svce_flag
1335: ,p_current_value => c_dpdnt_vlntry_svce_flag);

Line 1336: l_original_date_of_hire := hr_dt_attribute_support.get_parameter_date

1332: (p_effective_date_row => l_effective_date_row
1333: ,p_parameter_name => 'P_DPDNT_VLNTRY_SVCE_FLAG'
1334: ,p_new_value => p_dpdnt_vlntry_svce_flag
1335: ,p_current_value => c_dpdnt_vlntry_svce_flag);
1336: l_original_date_of_hire := hr_dt_attribute_support.get_parameter_date
1337: (p_effective_date_row => l_effective_date_row
1338: ,p_parameter_name => 'P_ORIGINAL_DATE_OF_HIRE'
1339: ,p_new_value => p_original_date_of_hire
1340: ,p_current_value => c_original_date_of_hire);

Line 1341: l_town_of_birth := hr_dt_attribute_support.get_parameter_char

1337: (p_effective_date_row => l_effective_date_row
1338: ,p_parameter_name => 'P_ORIGINAL_DATE_OF_HIRE'
1339: ,p_new_value => p_original_date_of_hire
1340: ,p_current_value => c_original_date_of_hire);
1341: l_town_of_birth := hr_dt_attribute_support.get_parameter_char
1342: (p_effective_date_row => l_effective_date_row
1343: ,p_parameter_name => 'P_TOWN_OF_BIRTH'
1344: ,p_new_value => p_town_of_birth
1345: ,p_current_value => c_town_of_birth);

Line 1346: l_region_of_birth := hr_dt_attribute_support.get_parameter_char

1342: (p_effective_date_row => l_effective_date_row
1343: ,p_parameter_name => 'P_TOWN_OF_BIRTH'
1344: ,p_new_value => p_town_of_birth
1345: ,p_current_value => c_town_of_birth);
1346: l_region_of_birth := hr_dt_attribute_support.get_parameter_char
1347: (p_effective_date_row => l_effective_date_row
1348: ,p_parameter_name => 'P_REGION_OF_BIRTH'
1349: ,p_new_value => p_region_of_birth
1350: ,p_current_value => c_region_of_birth);

Line 1351: l_country_of_birth := hr_dt_attribute_support.get_parameter_char

1347: (p_effective_date_row => l_effective_date_row
1348: ,p_parameter_name => 'P_REGION_OF_BIRTH'
1349: ,p_new_value => p_region_of_birth
1350: ,p_current_value => c_region_of_birth);
1351: l_country_of_birth := hr_dt_attribute_support.get_parameter_char
1352: (p_effective_date_row => l_effective_date_row
1353: ,p_parameter_name => 'P_COUNTRY_OF_BIRTH'
1354: ,p_new_value => p_country_of_birth
1355: ,p_current_value => c_country_of_birth);

Line 1356: l_global_person_id := hr_dt_attribute_support.get_parameter_char

1352: (p_effective_date_row => l_effective_date_row
1353: ,p_parameter_name => 'P_COUNTRY_OF_BIRTH'
1354: ,p_new_value => p_country_of_birth
1355: ,p_current_value => c_country_of_birth);
1356: l_global_person_id := hr_dt_attribute_support.get_parameter_char
1357: (p_effective_date_row => l_effective_date_row
1358: ,p_parameter_name => 'P_GLOBAL_PERSON_ID'
1359: ,p_new_value => p_global_person_id
1360: ,p_current_value => c_global_person_id);

Line 1362: if hr_dt_attribute_support.is_current_row_changing then

1358: ,p_parameter_name => 'P_GLOBAL_PERSON_ID'
1359: ,p_new_value => p_global_person_id
1360: ,p_current_value => c_global_person_id);
1361: -- call the business process API if at least one attribute can be changed
1362: if hr_dt_attribute_support.is_current_row_changing then
1363: -- set the object version number and effective date
1364: if l_effective_date_row then
1365: -- as we are on the first row, the ovn and effective date should be
1366: -- set to the parameter specified by the caller

Line 1760: hr_dt_attribute_support.reset_parameter_statuses;

1756: -- ------------------------------------------------------------------------
1757: -- process any past row(s)
1758: if p_attribute_update_mode = 'ATTRIBUTE_CORRECTION' then
1759: -- reset the parameter statuses
1760: hr_dt_attribute_support.reset_parameter_statuses;
1761: for csr_past in csr_per2 loop
1762: if not process_row
1763: (c_effective_start_date => csr_past.effective_start_date
1764: ,c_object_version_number => csr_past.object_version_number