APPS.IRC_PARTY_API dependencies on HZ_PERSON_PROFILES

Line 106: l_last_name_phonetic hz_person_profiles.person_last_name_phonetic%type

102: l_person_id PER_ALL_PEOPLE_F.PERSON_ID%TYPE;
103: l_date_of_birth per_all_people_f.date_of_birth%type;
104: l_business_group_id per_all_people_f.business_group_id%type;
105: l_person_type_id per_all_people_f.person_type_id%type;
106: l_last_name_phonetic hz_person_profiles.person_last_name_phonetic%type
107: := p_last_name_phonetic;
108: --
109: -- dummy variables
110: --

Line 861: l_last_name_phonetic hz_person_profiles.person_last_name_phonetic%type

857: l_person_id PER_ALL_PEOPLE_F.PERSON_ID%TYPE;
858: l_date_of_birth per_all_people_f.date_of_birth%type;
859: l_business_group_id per_all_people_f.business_group_id%type;
860: l_person_type_id per_all_people_f.person_type_id%type;
861: l_last_name_phonetic hz_person_profiles.person_last_name_phonetic%type
862: := p_last_name_phonetic;
863: --
864: -- dummy variables
865: --

Line 1378: l_last_name_phonetic hz_person_profiles.person_last_name_phonetic%type

1374: l_legislation_code per_business_groups.legislation_code%type;
1375: -- sex is defaulted to null - it is set to the value of sex
1376: -- on per_all_people_f if p_gender exists in hr_lookups
1377: l_sex per_all_people_f.sex%TYPE := hr_api.g_varchar2;
1378: l_last_name_phonetic hz_person_profiles.person_last_name_phonetic%type
1379: := p_last_name_phonetic;
1380: --
1381: -- dummy variables
1382: --

Line 1392: l_marital_status hz_person_profiles.marital_status%type;

1388: l_name_combination_warning boolean;
1389: l_assign_payroll_warning boolean;
1390: l_orig_hire_warning boolean;
1391: l_date_of_birth date;
1392: l_marital_status hz_person_profiles.marital_status%type;
1393: --
1394: -- for disabling the descriptive flex field
1395: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=
1396: hr_dflex_utility.l_ignore_dfcode_varray();