eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_SF52_DO_UPDATE dependencies on PER_ADDRESSES

Line 2855: l_address_line1 per_addresses.address_line1%type;

2851: l_create_address varchar2(1) := 'N';
2852: l_update_address varchar2(1) := 'N';
2853: l_update_person varchar2(1) := 'N';
2854: l_secondary_asg varchar2(1) := 'N';
2855: l_address_line1 per_addresses.address_line1%type;
2856: l_address_line2 per_addresses.address_line2%type;
2857: l_address_line3 per_addresses.address_line3%type;
2858: l_town_or_city per_addresses.town_or_city%type;
2859: l_region_2 per_addresses.region_2%type;

Line 2856: l_address_line2 per_addresses.address_line2%type;

2852: l_update_address varchar2(1) := 'N';
2853: l_update_person varchar2(1) := 'N';
2854: l_secondary_asg varchar2(1) := 'N';
2855: l_address_line1 per_addresses.address_line1%type;
2856: l_address_line2 per_addresses.address_line2%type;
2857: l_address_line3 per_addresses.address_line3%type;
2858: l_town_or_city per_addresses.town_or_city%type;
2859: l_region_2 per_addresses.region_2%type;
2860: l_city per_addresses.town_or_city%type;

Line 2857: l_address_line3 per_addresses.address_line3%type;

2853: l_update_person varchar2(1) := 'N';
2854: l_secondary_asg varchar2(1) := 'N';
2855: l_address_line1 per_addresses.address_line1%type;
2856: l_address_line2 per_addresses.address_line2%type;
2857: l_address_line3 per_addresses.address_line3%type;
2858: l_town_or_city per_addresses.town_or_city%type;
2859: l_region_2 per_addresses.region_2%type;
2860: l_city per_addresses.town_or_city%type;
2861: l_state per_addresses.region_2%type;

Line 2858: l_town_or_city per_addresses.town_or_city%type;

2854: l_secondary_asg varchar2(1) := 'N';
2855: l_address_line1 per_addresses.address_line1%type;
2856: l_address_line2 per_addresses.address_line2%type;
2857: l_address_line3 per_addresses.address_line3%type;
2858: l_town_or_city per_addresses.town_or_city%type;
2859: l_region_2 per_addresses.region_2%type;
2860: l_city per_addresses.town_or_city%type;
2861: l_state per_addresses.region_2%type;
2862: l_postal_code per_addresses.postal_code%type;

Line 2859: l_region_2 per_addresses.region_2%type;

2855: l_address_line1 per_addresses.address_line1%type;
2856: l_address_line2 per_addresses.address_line2%type;
2857: l_address_line3 per_addresses.address_line3%type;
2858: l_town_or_city per_addresses.town_or_city%type;
2859: l_region_2 per_addresses.region_2%type;
2860: l_city per_addresses.town_or_city%type;
2861: l_state per_addresses.region_2%type;
2862: l_postal_code per_addresses.postal_code%type;
2863: l_country per_addresses.country%type;

Line 2860: l_city per_addresses.town_or_city%type;

2856: l_address_line2 per_addresses.address_line2%type;
2857: l_address_line3 per_addresses.address_line3%type;
2858: l_town_or_city per_addresses.town_or_city%type;
2859: l_region_2 per_addresses.region_2%type;
2860: l_city per_addresses.town_or_city%type;
2861: l_state per_addresses.region_2%type;
2862: l_postal_code per_addresses.postal_code%type;
2863: l_country per_addresses.country%type;
2864: l_noa_family_name varchar2(60);

Line 2861: l_state per_addresses.region_2%type;

2857: l_address_line3 per_addresses.address_line3%type;
2858: l_town_or_city per_addresses.town_or_city%type;
2859: l_region_2 per_addresses.region_2%type;
2860: l_city per_addresses.town_or_city%type;
2861: l_state per_addresses.region_2%type;
2862: l_postal_code per_addresses.postal_code%type;
2863: l_country per_addresses.country%type;
2864: l_noa_family_name varchar2(60);
2865: l_noa_family_code ghr_noa_families.noa_family_code%type;

Line 2862: l_postal_code per_addresses.postal_code%type;

2858: l_town_or_city per_addresses.town_or_city%type;
2859: l_region_2 per_addresses.region_2%type;
2860: l_city per_addresses.town_or_city%type;
2861: l_state per_addresses.region_2%type;
2862: l_postal_code per_addresses.postal_code%type;
2863: l_country per_addresses.country%type;
2864: l_noa_family_name varchar2(60);
2865: l_noa_family_code ghr_noa_families.noa_family_code%type;
2866: --

Line 2863: l_country per_addresses.country%type;

2859: l_region_2 per_addresses.region_2%type;
2860: l_city per_addresses.town_or_city%type;
2861: l_state per_addresses.region_2%type;
2862: l_postal_code per_addresses.postal_code%type;
2863: l_country per_addresses.country%type;
2864: l_noa_family_name varchar2(60);
2865: l_noa_family_code ghr_noa_families.noa_family_code%type;
2866: --
2867: -- hr_person_api.update_person out variables

Line 2919: l_per_add_address_id per_addresses.address_id%type;

2915: l_asg_sus_eff_end_date per_assignments_f.effective_end_date%type;--
2916:
2917: -- Create addresses out variables
2918: --
2919: l_per_add_address_id per_addresses.address_id%type;
2920: l_per_add_ovr_number per_addresses.object_version_number%type;
2921: --
2922:
2923: -- Final Process out variables

Line 2920: l_per_add_ovr_number per_addresses.object_version_number%type;

2916:
2917: -- Create addresses out variables
2918: --
2919: l_per_add_address_id per_addresses.address_id%type;
2920: l_per_add_ovr_number per_addresses.object_version_number%type;
2921: --
2922:
2923: -- Final Process out variables
2924: --

Line 2934: l_add_object_version_number per_addresses.object_version_number%type;

2930: --
2931: --
2932: l_per_object_version_number per_people_f.object_version_number%type;
2933: l_asg_object_version_number per_assignments_f.object_version_number%type;
2934: l_add_object_version_number per_addresses.object_version_number%type;
2935: l_person_id per_people_f.person_id%type;
2936: l_person_type_id per_people_f.person_type_id%type;
2937: l_date1 ghr_pa_requests.effective_date%type;
2938: l_address_id per_addresses.address_id%type;

Line 2938: l_address_id per_addresses.address_id%type;

2934: l_add_object_version_number per_addresses.object_version_number%type;
2935: l_person_id per_people_f.person_id%type;
2936: l_person_type_id per_people_f.person_type_id%type;
2937: l_date1 ghr_pa_requests.effective_date%type;
2938: l_address_id per_addresses.address_id%type;
2939: l_person_type per_person_types.system_person_type%type;
2940: --l_sec_assignmemt_id per_assignments_f.assignment_id%type;
2941: --l_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%type;
2942: --

Line 2990: l_county_name per_addresses.region_1%type;

2986: l_del_ovn number(9);
2987: l_asg_id number(15);
2988: l_v_start_date date;
2989: l_v_end_date date;
2990: l_county_name per_addresses.region_1%type;
2991: l_count_rec number;
2992:
2993: l_session ghr_history_api.g_session_var_type;
2994:

Line 2999: l_pos_object_version_number per_addresses.object_version_number%type;

2995: -- POSITION ABOLISH out parameters
2996: l_val_grd_chg_wng boolean;
2997: l_pos_definition_id number;
2998: l_name varchar2(240);
2999: l_pos_object_version_number per_addresses.object_version_number%type;
3000:
3001:
3002: l_asg_payroll_id number;
3003: -- added for ds change

Line 3013: l_address_data per_addresses%rowtype;

3009: -- Variables used for Update GRE
3010: l_from_org_id hr_organization_units.organization_id%type;
3011: l_to_org_id hr_organization_units.organization_id%type;
3012: l_result_code varchar2(100);
3013: l_address_data per_addresses%rowtype;
3014: l_hr_user_type varchar2(20);
3015:
3016: l_old_system_status per_assignment_status_types.per_system_status%type;
3017:

Line 3115: per_addresses pad

3111: pad.region_2,
3112: pad.postal_code,
3113: pad.country
3114: from
3115: per_addresses pad
3116: where
3117: pad.person_id = p_pa_request_rec.person_id
3118: and g_effective_date + 1
3119: between pad.date_from and nvl(pad.date_to,g_effective_date + 1)

Line 3140: per_addresses pad

3136: pad.country ,
3137: pad.address_type,
3138: pad.primary_flag
3139: from
3140: per_addresses pad
3141: where
3142: pad.person_id = p_pa_request_rec.person_id
3143: and g_effective_date
3144: between pad.date_from and nvl(pad.date_to,g_effective_date)

Line 3152: WHERE pah.table_name = 'PER_ADDRESSES'

3148: p_address_id IN NUMBER)
3149: is
3150: SELECT pah.information1
3151: FROM ghr_pa_history pah
3152: WHERE pah.table_name = 'PER_ADDRESSES'
3153: AND pah.information1 = p_address_id
3154: AND pah.pa_request_id IN
3155: (
3156: SELECT pa_request_id

Line 4445: hr_utility.set_location('in per addresses',1000);

4441: -- Address creation
4442: l_hr_user_type := fnd_profile.value('HR_USER_TYPE');
4443: hr_utility.set_location('in address'||l_hr_user_type,1000);
4444: IF l_hr_user_type = 'INT' THEN
4445: hr_utility.set_location('in per addresses',1000);
4446: If l_create_address = 'Y' or l_update_address = 'Y' then
4447: hr_utility.set_location('in upd addresses',1000);
4448: for county in county_name loop
4449: l_county_name := county.county_name;