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 3059: l_address_line1 per_addresses.address_line1%type;

3055: l_create_address varchar2(1) := 'N';
3056: l_update_address varchar2(1) := 'N';
3057: l_update_person varchar2(1) := 'N';
3058: l_secondary_asg varchar2(1) := 'N';
3059: l_address_line1 per_addresses.address_line1%type;
3060: l_address_line2 per_addresses.address_line2%type;
3061: l_address_line3 per_addresses.address_line3%type;
3062: l_town_or_city per_addresses.town_or_city%type;
3063: l_region_2 per_addresses.region_2%type;

Line 3060: l_address_line2 per_addresses.address_line2%type;

3056: l_update_address varchar2(1) := 'N';
3057: l_update_person varchar2(1) := 'N';
3058: l_secondary_asg varchar2(1) := 'N';
3059: l_address_line1 per_addresses.address_line1%type;
3060: l_address_line2 per_addresses.address_line2%type;
3061: l_address_line3 per_addresses.address_line3%type;
3062: l_town_or_city per_addresses.town_or_city%type;
3063: l_region_2 per_addresses.region_2%type;
3064: l_city per_addresses.town_or_city%type;

Line 3061: l_address_line3 per_addresses.address_line3%type;

3057: l_update_person varchar2(1) := 'N';
3058: l_secondary_asg varchar2(1) := 'N';
3059: l_address_line1 per_addresses.address_line1%type;
3060: l_address_line2 per_addresses.address_line2%type;
3061: l_address_line3 per_addresses.address_line3%type;
3062: l_town_or_city per_addresses.town_or_city%type;
3063: l_region_2 per_addresses.region_2%type;
3064: l_city per_addresses.town_or_city%type;
3065: l_state per_addresses.region_2%type;

Line 3062: l_town_or_city per_addresses.town_or_city%type;

3058: l_secondary_asg varchar2(1) := 'N';
3059: l_address_line1 per_addresses.address_line1%type;
3060: l_address_line2 per_addresses.address_line2%type;
3061: l_address_line3 per_addresses.address_line3%type;
3062: l_town_or_city per_addresses.town_or_city%type;
3063: l_region_2 per_addresses.region_2%type;
3064: l_city per_addresses.town_or_city%type;
3065: l_state per_addresses.region_2%type;
3066: l_postal_code per_addresses.postal_code%type;

Line 3063: l_region_2 per_addresses.region_2%type;

3059: l_address_line1 per_addresses.address_line1%type;
3060: l_address_line2 per_addresses.address_line2%type;
3061: l_address_line3 per_addresses.address_line3%type;
3062: l_town_or_city per_addresses.town_or_city%type;
3063: l_region_2 per_addresses.region_2%type;
3064: l_city per_addresses.town_or_city%type;
3065: l_state per_addresses.region_2%type;
3066: l_postal_code per_addresses.postal_code%type;
3067: l_country per_addresses.country%type;

Line 3064: l_city per_addresses.town_or_city%type;

3060: l_address_line2 per_addresses.address_line2%type;
3061: l_address_line3 per_addresses.address_line3%type;
3062: l_town_or_city per_addresses.town_or_city%type;
3063: l_region_2 per_addresses.region_2%type;
3064: l_city per_addresses.town_or_city%type;
3065: l_state per_addresses.region_2%type;
3066: l_postal_code per_addresses.postal_code%type;
3067: l_country per_addresses.country%type;
3068: l_noa_family_name varchar2(60);

Line 3065: l_state per_addresses.region_2%type;

3061: l_address_line3 per_addresses.address_line3%type;
3062: l_town_or_city per_addresses.town_or_city%type;
3063: l_region_2 per_addresses.region_2%type;
3064: l_city per_addresses.town_or_city%type;
3065: l_state per_addresses.region_2%type;
3066: l_postal_code per_addresses.postal_code%type;
3067: l_country per_addresses.country%type;
3068: l_noa_family_name varchar2(60);
3069: l_noa_family_code ghr_noa_families.noa_family_code%type;

Line 3066: l_postal_code per_addresses.postal_code%type;

3062: l_town_or_city per_addresses.town_or_city%type;
3063: l_region_2 per_addresses.region_2%type;
3064: l_city per_addresses.town_or_city%type;
3065: l_state per_addresses.region_2%type;
3066: l_postal_code per_addresses.postal_code%type;
3067: l_country per_addresses.country%type;
3068: l_noa_family_name varchar2(60);
3069: l_noa_family_code ghr_noa_families.noa_family_code%type;
3070: --

Line 3067: l_country per_addresses.country%type;

3063: l_region_2 per_addresses.region_2%type;
3064: l_city per_addresses.town_or_city%type;
3065: l_state per_addresses.region_2%type;
3066: l_postal_code per_addresses.postal_code%type;
3067: l_country per_addresses.country%type;
3068: l_noa_family_name varchar2(60);
3069: l_noa_family_code ghr_noa_families.noa_family_code%type;
3070: --
3071: -- hr_person_api.update_person out variables

Line 3123: l_per_add_address_id per_addresses.address_id%type;

3119: l_asg_sus_eff_end_date per_assignments_f.effective_end_date%type;--
3120:
3121: -- Create addresses out variables
3122: --
3123: l_per_add_address_id per_addresses.address_id%type;
3124: l_per_add_ovr_number per_addresses.object_version_number%type;
3125: --
3126:
3127: -- Final Process out variables

Line 3124: l_per_add_ovr_number per_addresses.object_version_number%type;

3120:
3121: -- Create addresses out variables
3122: --
3123: l_per_add_address_id per_addresses.address_id%type;
3124: l_per_add_ovr_number per_addresses.object_version_number%type;
3125: --
3126:
3127: -- Final Process out variables
3128: --

Line 3138: l_add_object_version_number per_addresses.object_version_number%type;

3134: --
3135: --
3136: l_per_object_version_number per_people_f.object_version_number%type;
3137: l_asg_object_version_number per_assignments_f.object_version_number%type;
3138: l_add_object_version_number per_addresses.object_version_number%type;
3139: l_person_id per_people_f.person_id%type;
3140: l_person_type_id per_people_f.person_type_id%type;
3141: l_date1 ghr_pa_requests.effective_date%type;
3142: l_address_id per_addresses.address_id%type;

Line 3142: l_address_id per_addresses.address_id%type;

3138: l_add_object_version_number per_addresses.object_version_number%type;
3139: l_person_id per_people_f.person_id%type;
3140: l_person_type_id per_people_f.person_type_id%type;
3141: l_date1 ghr_pa_requests.effective_date%type;
3142: l_address_id per_addresses.address_id%type;
3143: l_person_type per_person_types.system_person_type%type;
3144: --l_sec_assignmemt_id per_assignments_f.assignment_id%type;
3145: --l_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%type;
3146: --

Line 3194: l_county_name per_addresses.region_1%type;

3190: l_del_ovn number(9);
3191: l_asg_id number(15);
3192: l_v_start_date date;
3193: l_v_end_date date;
3194: l_county_name per_addresses.region_1%type;
3195: l_count_rec number;
3196:
3197: l_session ghr_history_api.g_session_var_type;
3198:

Line 3203: l_pos_object_version_number per_addresses.object_version_number%type;

3199: -- POSITION ABOLISH out parameters
3200: l_val_grd_chg_wng boolean;
3201: l_pos_definition_id number;
3202: l_name varchar2(240);
3203: l_pos_object_version_number per_addresses.object_version_number%type;
3204:
3205:
3206: l_asg_payroll_id number;
3207: -- added for ds change

Line 3217: l_address_data per_addresses%rowtype;

3213: -- Variables used for Update GRE
3214: l_from_org_id hr_organization_units.organization_id%type;
3215: l_to_org_id hr_organization_units.organization_id%type;
3216: l_result_code varchar2(100);
3217: l_address_data per_addresses%rowtype;
3218: l_hr_user_type varchar2(20);
3219:
3220: l_old_system_status per_assignment_status_types.per_system_status%type;
3221:

Line 3319: per_addresses pad

3315: pad.region_2,
3316: pad.postal_code,
3317: pad.country
3318: from
3319: per_addresses pad
3320: where
3321: pad.person_id = p_pa_request_rec.person_id
3322: and g_effective_date + 1
3323: between pad.date_from and nvl(pad.date_to,g_effective_date + 1)

Line 3344: per_addresses pad

3340: pad.country ,
3341: pad.address_type,
3342: pad.primary_flag
3343: from
3344: per_addresses pad
3345: where
3346: pad.person_id = p_pa_request_rec.person_id
3347: and g_effective_date
3348: between pad.date_from and nvl(pad.date_to,g_effective_date)

Line 3356: WHERE pah.table_name = 'PER_ADDRESSES'

3352: p_address_id IN NUMBER)
3353: is
3354: SELECT pah.information1
3355: FROM ghr_pa_history pah
3356: WHERE pah.table_name = 'PER_ADDRESSES'
3357: AND pah.information1 = p_address_id
3358: AND pah.pa_request_id IN
3359: (
3360: SELECT pa_request_id

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

4700: -- Address creation
4701: l_hr_user_type := fnd_profile.value('HR_USER_TYPE');
4702: hr_utility.set_location('in address'||l_hr_user_type,1000);
4703: IF l_hr_user_type = 'INT' THEN
4704: hr_utility.set_location('in per addresses',1000);
4705: If l_create_address = 'Y' or l_update_address = 'Y' then
4706: hr_utility.set_location('in upd addresses',1000);
4707: for county in county_name loop
4708: l_county_name := county.county_name;