APPS.PER_HRTCA_MERGE dependencies on HZ_PERSON_PROFILES

Line 2406: l_place_of_birth hz_person_profiles.place_of_birth%type;

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

Line 2409: l_prev_last_name hz_person_profiles.person_previous_last_name%type;

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

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

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

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

2671: l_person_rec.gender := 'UNKNOWN';
2672: end if;
2673: --
2674: -- Modiifed to fix 4201545 starts here
2675: l_place_of_birth_len := get_column_length('HZ_PERSON_PROFILES','PLACE_OF_BIRTH',222); --for bug 6331673
2676: --
2677: if l_place_of_birth_len is null then
2678: begin
2679: --

Line 2877: l_place_of_birth hz_person_profiles.place_of_birth%type;

2873: l_party_rec hz_party_v2pub.party_rec_type; --Modified for bug# 2648797
2874: l_dummy number;
2875: l_tca_merge_action varchar2(30);
2876: --
2877: l_place_of_birth hz_person_profiles.place_of_birth%type;
2878: l_place_of_birth_len pls_integer := 0;
2879: --
2880: l_prev_last_name hz_person_profiles.person_previous_last_name%type;
2881: l_prev_last_name_len pls_integer := 0;

Line 2880: l_prev_last_name hz_person_profiles.person_previous_last_name%type;

2876: --
2877: l_place_of_birth hz_person_profiles.place_of_birth%type;
2878: l_place_of_birth_len pls_integer := 0;
2879: --
2880: l_prev_last_name hz_person_profiles.person_previous_last_name%type;
2881: l_prev_last_name_len pls_integer := 0;
2882: --
2883: l_tab_exists varchar2(1);
2884: --

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

2948: -- per_hrtca_merge.g_prev_last_name, if not assigned already
2949: --
2950: -- Modiifed to fix 4201545 starts here
2951: hr_utility.set_location('Before prev_last_name loop ',99);
2952: per_hrtca_merge.g_prev_last_name_len := get_column_length('HZ_PERSON_PROFILES','PERSON_PREVIOUS_LAST_NAME',222); --for bug 6331673
2953: --
2954: if per_hrtca_merge.g_prev_last_name_len is null then
2955: begin
2956: --

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

3056: --
3057: l_person_rec.date_of_birth := p_rec.date_of_birth;
3058: --
3059: -- Modified to fix 4201545 starts here
3060: l_place_of_birth_len := get_column_length('HZ_PERSON_PROFILES','PLACE_OF_BIRTH',222); --for bug 6331673
3061: --
3062: if l_place_of_birth_len is null then
3063: begin
3064: --

Line 5991: from hz_person_profiles

5987: where mod(ppf.person_id,p_number_of_workers) = p_current_worker-1
5988: and ppf.effective_end_date = hr_api.g_eot
5989: and ppf.party_id is not null
5990: and exists(select null
5991: from hz_person_profiles
5992: where party_id = ppf.party_id
5993: and nvl(gender,'Z') in ('Z','U','M','F'));
5994: --
5995: l_person c_person%rowtype;

Line 6011: update hz_person_profiles

6007: exit when c_person%notfound;
6008: --
6009: l_count := l_count + 1;
6010: --
6011: update hz_person_profiles
6012: set gender = decode(l_person.sex,null,'UNSPECIFIED'
6013: ,'F','FEMALE'
6014: ,'MALE')
6015: where party_id = l_person.party_id;