APPS.IRC_PARTY_API dependencies on HZ_PERSON_PROFILES

Line 101: l_last_name_phonetic hz_person_profiles.person_last_name_phonetic%type

97: l_person_id PER_ALL_PEOPLE_F.PERSON_ID%TYPE;
98: l_date_of_birth per_all_people_f.date_of_birth%type;
99: l_business_group_id per_all_people_f.business_group_id%type;
100: l_person_type_id per_all_people_f.person_type_id%type;
101: l_last_name_phonetic hz_person_profiles.person_last_name_phonetic%type
102: := p_last_name_phonetic;
103: --
104: -- dummy variables
105: --

Line 834: l_last_name_phonetic hz_person_profiles.person_last_name_phonetic%type

830: l_person_id PER_ALL_PEOPLE_F.PERSON_ID%TYPE;
831: l_date_of_birth per_all_people_f.date_of_birth%type;
832: l_business_group_id per_all_people_f.business_group_id%type;
833: l_person_type_id per_all_people_f.person_type_id%type;
834: l_last_name_phonetic hz_person_profiles.person_last_name_phonetic%type
835: := p_last_name_phonetic;
836: --
837: -- dummy variables
838: --

Line 1351: l_last_name_phonetic hz_person_profiles.person_last_name_phonetic%type

1347: l_legislation_code per_business_groups.legislation_code%type;
1348: -- sex is defaulted to null - it is set to the value of sex
1349: -- on per_all_people_f if p_gender exists in hr_lookups
1350: l_sex per_all_people_f.sex%TYPE := hr_api.g_varchar2;
1351: l_last_name_phonetic hz_person_profiles.person_last_name_phonetic%type
1352: := p_last_name_phonetic;
1353: --
1354: -- dummy variables
1355: --

Line 1365: l_marital_status hz_person_profiles.marital_status%type;

1361: l_name_combination_warning boolean;
1362: l_assign_payroll_warning boolean;
1363: l_orig_hire_warning boolean;
1364: l_date_of_birth date;
1365: l_marital_status hz_person_profiles.marital_status%type;
1366: --
1367: -- for disabling the descriptive flex field
1368: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=
1369: hr_dflex_utility.l_ignore_dfcode_varray();