APPS.HR_GENERAL2 dependencies on PER_ALL_PEOPLE_F

Line 150: r_party_id per_all_people_f.party_id%type

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

Line 151: ,r_person_id per_all_people_f.person_id%type

147:
148: type party_id_rec is record
149: (
150: r_party_id per_all_people_f.party_id%type
151: ,r_person_id per_all_people_f.person_id%type
152: ,r_sec_status varchar2(200)
153: ,r_global_name per_all_people_f.global_name%type
154: ,r_BG_name hr_all_organization_units.name%type
155: ,r_location_code hr_locations_all.location_code%type

Line 153: ,r_global_name per_all_people_f.global_name%type

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

Line 158: ,r_national_identifier per_all_people_f.national_identifier%type

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

Line 159: ,r_bg_id per_all_people_f.business_group_id%type

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

Line 174: p_business_group_id in per_all_people_f.business_group_id%TYPE

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