APPS.HR_GENERAL2 dependencies on PER_ALL_PEOPLE_F

Line 146: r_party_id per_all_people_f.party_id%type

142: -- START added for the fix of enh duplicate person #3988762
143:
144: type party_id_rec is record
145: (
146: r_party_id per_all_people_f.party_id%type
147: ,r_person_id per_all_people_f.person_id%type
148: ,r_sec_status varchar2(200)
149: ,r_global_name per_all_people_f.global_name%type
150: ,r_BG_name hr_all_organization_units.name%type

Line 147: ,r_person_id per_all_people_f.person_id%type

143:
144: type party_id_rec is record
145: (
146: r_party_id per_all_people_f.party_id%type
147: ,r_person_id per_all_people_f.person_id%type
148: ,r_sec_status varchar2(200)
149: ,r_global_name per_all_people_f.global_name%type
150: ,r_BG_name hr_all_organization_units.name%type
151: ,r_location_code hr_locations_all.location_code%type

Line 149: ,r_global_name per_all_people_f.global_name%type

145: (
146: r_party_id per_all_people_f.party_id%type
147: ,r_person_id per_all_people_f.person_id%type
148: ,r_sec_status varchar2(200)
149: ,r_global_name per_all_people_f.global_name%type
150: ,r_BG_name hr_all_organization_units.name%type
151: ,r_location_code hr_locations_all.location_code%type
152: ,r_org_name hr_all_organization_units.name%type
153: ,r_postal_code per_addresses.postal_code%type

Line 154: ,r_national_identifier per_all_people_f.national_identifier%type

150: ,r_BG_name hr_all_organization_units.name%type
151: ,r_location_code hr_locations_all.location_code%type
152: ,r_org_name hr_all_organization_units.name%type
153: ,r_postal_code per_addresses.postal_code%type
154: ,r_national_identifier per_all_people_f.national_identifier%type
155: ,r_bg_id per_all_people_f.business_group_id%type
156: );
157:
158: type party_id_tbl is table of party_id_rec

Line 155: ,r_bg_id per_all_people_f.business_group_id%type

151: ,r_location_code hr_locations_all.location_code%type
152: ,r_org_name hr_all_organization_units.name%type
153: ,r_postal_code per_addresses.postal_code%type
154: ,r_national_identifier per_all_people_f.national_identifier%type
155: ,r_bg_id per_all_people_f.business_group_id%type
156: );
157:
158: type party_id_tbl is table of party_id_rec
159: index by binary_integer;

Line 170: p_business_group_id in per_all_people_f.business_group_id%TYPE

166: ,p_dup_tbl OUT nocopy hr_general2.party_id_tbl)
167: RETURN BOOLEAN;
168:
169: PROCEDURE is_duplicate_person(
170: p_business_group_id in per_all_people_f.business_group_id%TYPE
171: ,p_first_name IN VARCHAR2
172: ,p_last_name IN VARCHAR2
173: ,p_national_identifier IN VARCHAR2
174: ,p_date_of_birth IN DATE