APPS.PER_HRTCA_MERGE dependencies on HZ_PERSON_PROFILES

Line 2403: l_place_of_birth hz_person_profiles.place_of_birth%type;

2399: l_leg_code varchar2(80);
2400: l_person_rec hz_party_v2pub.person_rec_type; --Modified for Bug #2648797
2401: l_party_rec hz_party_v2pub.party_rec_type; --Modified for Bug #2648797
2402: --
2403: l_place_of_birth hz_person_profiles.place_of_birth%type;
2404: l_place_of_birth_len pls_integer := 0;
2405: --
2406: l_prev_last_name hz_person_profiles.person_previous_last_name%type;
2407: l_prev_last_name_len pls_integer := 0;

Line 2406: l_prev_last_name hz_person_profiles.person_previous_last_name%type;

2402: --
2403: l_place_of_birth hz_person_profiles.place_of_birth%type;
2404: l_place_of_birth_len pls_integer := 0;
2405: --
2406: l_prev_last_name hz_person_profiles.person_previous_last_name%type;
2407: l_prev_last_name_len pls_integer := 0;
2408: --
2409: l_tab_exists varchar2(1);
2410: --

Line 2574: per_hrtca_merge.g_prev_last_name_len := get_column_length('HZ_PERSON_PROFILES','PERSON_PREVIOUS_LAST_NAME',222); --for bug 6331673

2570: -- per_hrtca_merge.g_prev_last_name, if not assigned already
2571: --
2572: -- Modiifed to fix 4201545 starts here
2573: hr_utility.set_location('Before prev_last_name loop ',99);
2574: per_hrtca_merge.g_prev_last_name_len := get_column_length('HZ_PERSON_PROFILES','PERSON_PREVIOUS_LAST_NAME',222); --for bug 6331673
2575: --
2576: if per_hrtca_merge.g_prev_last_name_len is null then
2577: begin
2578: --

Line 2670: l_place_of_birth_len := get_column_length('HZ_PERSON_PROFILES','PLACE_OF_BIRTH',222); --for bug 6331673

2666: l_person_rec.gender := 'MALE';
2667: end if;
2668: --
2669: -- Modiifed to fix 4201545 starts here
2670: l_place_of_birth_len := get_column_length('HZ_PERSON_PROFILES','PLACE_OF_BIRTH',222); --for bug 6331673
2671: --
2672: if l_place_of_birth_len is null then
2673: begin
2674: --

Line 2871: l_place_of_birth hz_person_profiles.place_of_birth%type;

2867: l_party_rec hz_party_v2pub.party_rec_type; --Modified for bug# 2648797
2868: l_dummy number;
2869: l_tca_merge_action varchar2(30);
2870: --
2871: l_place_of_birth hz_person_profiles.place_of_birth%type;
2872: l_place_of_birth_len pls_integer := 0;
2873: --
2874: l_prev_last_name hz_person_profiles.person_previous_last_name%type;
2875: l_prev_last_name_len pls_integer := 0;

Line 2874: l_prev_last_name hz_person_profiles.person_previous_last_name%type;

2870: --
2871: l_place_of_birth hz_person_profiles.place_of_birth%type;
2872: l_place_of_birth_len pls_integer := 0;
2873: --
2874: l_prev_last_name hz_person_profiles.person_previous_last_name%type;
2875: l_prev_last_name_len pls_integer := 0;
2876: --
2877: l_tab_exists varchar2(1);
2878: --

Line 2946: per_hrtca_merge.g_prev_last_name_len := get_column_length('HZ_PERSON_PROFILES','PERSON_PREVIOUS_LAST_NAME',222); --for bug 6331673

2942: -- per_hrtca_merge.g_prev_last_name, if not assigned already
2943: --
2944: -- Modiifed to fix 4201545 starts here
2945: hr_utility.set_location('Before prev_last_name loop ',99);
2946: per_hrtca_merge.g_prev_last_name_len := get_column_length('HZ_PERSON_PROFILES','PERSON_PREVIOUS_LAST_NAME',222); --for bug 6331673
2947: --
2948: if per_hrtca_merge.g_prev_last_name_len is null then
2949: begin
2950: --

Line 3046: l_place_of_birth_len := get_column_length('HZ_PERSON_PROFILES','PLACE_OF_BIRTH',222); --for bug 6331673

3042: --
3043: l_person_rec.date_of_birth := p_rec.date_of_birth;
3044: --
3045: -- Modified to fix 4201545 starts here
3046: l_place_of_birth_len := get_column_length('HZ_PERSON_PROFILES','PLACE_OF_BIRTH',222); --for bug 6331673
3047: --
3048: if l_place_of_birth_len is null then
3049: begin
3050: --

Line 5971: from hz_person_profiles

5967: where mod(ppf.person_id,p_number_of_workers) = p_current_worker-1
5968: and ppf.effective_end_date = hr_api.g_eot
5969: and ppf.party_id is not null
5970: and exists(select null
5971: from hz_person_profiles
5972: where party_id = ppf.party_id
5973: and nvl(gender,'Z') in ('Z','U','M','F'));
5974: --
5975: l_person c_person%rowtype;

Line 5991: update hz_person_profiles

5987: exit when c_person%notfound;
5988: --
5989: l_count := l_count + 1;
5990: --
5991: update hz_person_profiles
5992: set gender = decode(l_person.sex,null,'UNSPECIFIED'
5993: ,'F','FEMALE'
5994: ,'MALE')
5995: where party_id = l_person.party_id;