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.HR_FULL_SYNC_MESSAGES dependencies on HR_LOCATIONS_ALL

Line 291: p_bg_id hr_locations_all.business_group_id%type;

287: PROCEDURE HR_LOCATION_FULL_SYNC(errbuf OUT NOCOPY VARCHAR2
288: ,retcode OUT NOCOPY VARCHAR2)
289: is
290:
291: p_bg_id hr_locations_all.business_group_id%type;
292: p_loc_id hr_locations_all.LOCATION_ID%type;
293: p_active_date date;
294: p_effecive_status varchar2(10);
295: p_loc_code hr_locations_all.LOCATION_CODE%type;

Line 292: p_loc_id hr_locations_all.LOCATION_ID%type;

288: ,retcode OUT NOCOPY VARCHAR2)
289: is
290:
291: p_bg_id hr_locations_all.business_group_id%type;
292: p_loc_id hr_locations_all.LOCATION_ID%type;
293: p_active_date date;
294: p_effecive_status varchar2(10);
295: p_loc_code hr_locations_all.LOCATION_CODE%type;
296: p_loc_desc hr_locations_all.DESCRIPTION%type;

Line 295: p_loc_code hr_locations_all.LOCATION_CODE%type;

291: p_bg_id hr_locations_all.business_group_id%type;
292: p_loc_id hr_locations_all.LOCATION_ID%type;
293: p_active_date date;
294: p_effecive_status varchar2(10);
295: p_loc_code hr_locations_all.LOCATION_CODE%type;
296: p_loc_desc hr_locations_all.DESCRIPTION%type;
297: p_loc_style hr_locations_all.STYLE%type;
298: p_add_line_1 hr_locations_all.ADDRESS_LINE_1%type;
299: p_add_line_2 hr_locations_all.ADDRESS_LINE_2%type;

Line 296: p_loc_desc hr_locations_all.DESCRIPTION%type;

292: p_loc_id hr_locations_all.LOCATION_ID%type;
293: p_active_date date;
294: p_effecive_status varchar2(10);
295: p_loc_code hr_locations_all.LOCATION_CODE%type;
296: p_loc_desc hr_locations_all.DESCRIPTION%type;
297: p_loc_style hr_locations_all.STYLE%type;
298: p_add_line_1 hr_locations_all.ADDRESS_LINE_1%type;
299: p_add_line_2 hr_locations_all.ADDRESS_LINE_2%type;
300: p_add_line_3 hr_locations_all.ADDRESS_LINE_3%type;

Line 297: p_loc_style hr_locations_all.STYLE%type;

293: p_active_date date;
294: p_effecive_status varchar2(10);
295: p_loc_code hr_locations_all.LOCATION_CODE%type;
296: p_loc_desc hr_locations_all.DESCRIPTION%type;
297: p_loc_style hr_locations_all.STYLE%type;
298: p_add_line_1 hr_locations_all.ADDRESS_LINE_1%type;
299: p_add_line_2 hr_locations_all.ADDRESS_LINE_2%type;
300: p_add_line_3 hr_locations_all.ADDRESS_LINE_3%type;
301: p_town_or_city hr_locations_all.TOWN_OR_CITY%type;

Line 298: p_add_line_1 hr_locations_all.ADDRESS_LINE_1%type;

294: p_effecive_status varchar2(10);
295: p_loc_code hr_locations_all.LOCATION_CODE%type;
296: p_loc_desc hr_locations_all.DESCRIPTION%type;
297: p_loc_style hr_locations_all.STYLE%type;
298: p_add_line_1 hr_locations_all.ADDRESS_LINE_1%type;
299: p_add_line_2 hr_locations_all.ADDRESS_LINE_2%type;
300: p_add_line_3 hr_locations_all.ADDRESS_LINE_3%type;
301: p_town_or_city hr_locations_all.TOWN_OR_CITY%type;
302: p_country hr_locations_all.COUNTRY%type;

Line 299: p_add_line_2 hr_locations_all.ADDRESS_LINE_2%type;

295: p_loc_code hr_locations_all.LOCATION_CODE%type;
296: p_loc_desc hr_locations_all.DESCRIPTION%type;
297: p_loc_style hr_locations_all.STYLE%type;
298: p_add_line_1 hr_locations_all.ADDRESS_LINE_1%type;
299: p_add_line_2 hr_locations_all.ADDRESS_LINE_2%type;
300: p_add_line_3 hr_locations_all.ADDRESS_LINE_3%type;
301: p_town_or_city hr_locations_all.TOWN_OR_CITY%type;
302: p_country hr_locations_all.COUNTRY%type;
303: p_postal_code hr_locations_all.POSTAL_CODE%type;

Line 300: p_add_line_3 hr_locations_all.ADDRESS_LINE_3%type;

296: p_loc_desc hr_locations_all.DESCRIPTION%type;
297: p_loc_style hr_locations_all.STYLE%type;
298: p_add_line_1 hr_locations_all.ADDRESS_LINE_1%type;
299: p_add_line_2 hr_locations_all.ADDRESS_LINE_2%type;
300: p_add_line_3 hr_locations_all.ADDRESS_LINE_3%type;
301: p_town_or_city hr_locations_all.TOWN_OR_CITY%type;
302: p_country hr_locations_all.COUNTRY%type;
303: p_postal_code hr_locations_all.POSTAL_CODE%type;
304: p_region_1 hr_locations_all.REGION_1%type;

Line 301: p_town_or_city hr_locations_all.TOWN_OR_CITY%type;

297: p_loc_style hr_locations_all.STYLE%type;
298: p_add_line_1 hr_locations_all.ADDRESS_LINE_1%type;
299: p_add_line_2 hr_locations_all.ADDRESS_LINE_2%type;
300: p_add_line_3 hr_locations_all.ADDRESS_LINE_3%type;
301: p_town_or_city hr_locations_all.TOWN_OR_CITY%type;
302: p_country hr_locations_all.COUNTRY%type;
303: p_postal_code hr_locations_all.POSTAL_CODE%type;
304: p_region_1 hr_locations_all.REGION_1%type;
305: p_region_2 hr_locations_all.REGION_2%type;

Line 302: p_country hr_locations_all.COUNTRY%type;

298: p_add_line_1 hr_locations_all.ADDRESS_LINE_1%type;
299: p_add_line_2 hr_locations_all.ADDRESS_LINE_2%type;
300: p_add_line_3 hr_locations_all.ADDRESS_LINE_3%type;
301: p_town_or_city hr_locations_all.TOWN_OR_CITY%type;
302: p_country hr_locations_all.COUNTRY%type;
303: p_postal_code hr_locations_all.POSTAL_CODE%type;
304: p_region_1 hr_locations_all.REGION_1%type;
305: p_region_2 hr_locations_all.REGION_2%type;
306: p_region_3 hr_locations_all.REGION_3%type;

Line 303: p_postal_code hr_locations_all.POSTAL_CODE%type;

299: p_add_line_2 hr_locations_all.ADDRESS_LINE_2%type;
300: p_add_line_3 hr_locations_all.ADDRESS_LINE_3%type;
301: p_town_or_city hr_locations_all.TOWN_OR_CITY%type;
302: p_country hr_locations_all.COUNTRY%type;
303: p_postal_code hr_locations_all.POSTAL_CODE%type;
304: p_region_1 hr_locations_all.REGION_1%type;
305: p_region_2 hr_locations_all.REGION_2%type;
306: p_region_3 hr_locations_all.REGION_3%type;
307: p_tel_no_1 hr_locations_all.TELEPHONE_NUMBER_1%type;

Line 304: p_region_1 hr_locations_all.REGION_1%type;

300: p_add_line_3 hr_locations_all.ADDRESS_LINE_3%type;
301: p_town_or_city hr_locations_all.TOWN_OR_CITY%type;
302: p_country hr_locations_all.COUNTRY%type;
303: p_postal_code hr_locations_all.POSTAL_CODE%type;
304: p_region_1 hr_locations_all.REGION_1%type;
305: p_region_2 hr_locations_all.REGION_2%type;
306: p_region_3 hr_locations_all.REGION_3%type;
307: p_tel_no_1 hr_locations_all.TELEPHONE_NUMBER_1%type;
308: p_tel_no_2 hr_locations_all.TELEPHONE_NUMBER_2%type;

Line 305: p_region_2 hr_locations_all.REGION_2%type;

301: p_town_or_city hr_locations_all.TOWN_OR_CITY%type;
302: p_country hr_locations_all.COUNTRY%type;
303: p_postal_code hr_locations_all.POSTAL_CODE%type;
304: p_region_1 hr_locations_all.REGION_1%type;
305: p_region_2 hr_locations_all.REGION_2%type;
306: p_region_3 hr_locations_all.REGION_3%type;
307: p_tel_no_1 hr_locations_all.TELEPHONE_NUMBER_1%type;
308: p_tel_no_2 hr_locations_all.TELEPHONE_NUMBER_2%type;
309: p_tel_no_3 hr_locations_all.TELEPHONE_NUMBER_3%type;

Line 306: p_region_3 hr_locations_all.REGION_3%type;

302: p_country hr_locations_all.COUNTRY%type;
303: p_postal_code hr_locations_all.POSTAL_CODE%type;
304: p_region_1 hr_locations_all.REGION_1%type;
305: p_region_2 hr_locations_all.REGION_2%type;
306: p_region_3 hr_locations_all.REGION_3%type;
307: p_tel_no_1 hr_locations_all.TELEPHONE_NUMBER_1%type;
308: p_tel_no_2 hr_locations_all.TELEPHONE_NUMBER_2%type;
309: p_tel_no_3 hr_locations_all.TELEPHONE_NUMBER_3%type;
310: p_loc_info_13 hr_locations_all.LOC_INFORMATION13%type;

Line 307: p_tel_no_1 hr_locations_all.TELEPHONE_NUMBER_1%type;

303: p_postal_code hr_locations_all.POSTAL_CODE%type;
304: p_region_1 hr_locations_all.REGION_1%type;
305: p_region_2 hr_locations_all.REGION_2%type;
306: p_region_3 hr_locations_all.REGION_3%type;
307: p_tel_no_1 hr_locations_all.TELEPHONE_NUMBER_1%type;
308: p_tel_no_2 hr_locations_all.TELEPHONE_NUMBER_2%type;
309: p_tel_no_3 hr_locations_all.TELEPHONE_NUMBER_3%type;
310: p_loc_info_13 hr_locations_all.LOC_INFORMATION13%type;
311: p_loc_info_14 hr_locations_all.LOC_INFORMATION14%type;

Line 308: p_tel_no_2 hr_locations_all.TELEPHONE_NUMBER_2%type;

304: p_region_1 hr_locations_all.REGION_1%type;
305: p_region_2 hr_locations_all.REGION_2%type;
306: p_region_3 hr_locations_all.REGION_3%type;
307: p_tel_no_1 hr_locations_all.TELEPHONE_NUMBER_1%type;
308: p_tel_no_2 hr_locations_all.TELEPHONE_NUMBER_2%type;
309: p_tel_no_3 hr_locations_all.TELEPHONE_NUMBER_3%type;
310: p_loc_info_13 hr_locations_all.LOC_INFORMATION13%type;
311: p_loc_info_14 hr_locations_all.LOC_INFORMATION14%type;
312: p_loc_info_15 hr_locations_all.LOC_INFORMATION15%type;

Line 309: p_tel_no_3 hr_locations_all.TELEPHONE_NUMBER_3%type;

305: p_region_2 hr_locations_all.REGION_2%type;
306: p_region_3 hr_locations_all.REGION_3%type;
307: p_tel_no_1 hr_locations_all.TELEPHONE_NUMBER_1%type;
308: p_tel_no_2 hr_locations_all.TELEPHONE_NUMBER_2%type;
309: p_tel_no_3 hr_locations_all.TELEPHONE_NUMBER_3%type;
310: p_loc_info_13 hr_locations_all.LOC_INFORMATION13%type;
311: p_loc_info_14 hr_locations_all.LOC_INFORMATION14%type;
312: p_loc_info_15 hr_locations_all.LOC_INFORMATION15%type;
313: p_loc_info_16 hr_locations_all.LOC_INFORMATION16%type;

Line 310: p_loc_info_13 hr_locations_all.LOC_INFORMATION13%type;

306: p_region_3 hr_locations_all.REGION_3%type;
307: p_tel_no_1 hr_locations_all.TELEPHONE_NUMBER_1%type;
308: p_tel_no_2 hr_locations_all.TELEPHONE_NUMBER_2%type;
309: p_tel_no_3 hr_locations_all.TELEPHONE_NUMBER_3%type;
310: p_loc_info_13 hr_locations_all.LOC_INFORMATION13%type;
311: p_loc_info_14 hr_locations_all.LOC_INFORMATION14%type;
312: p_loc_info_15 hr_locations_all.LOC_INFORMATION15%type;
313: p_loc_info_16 hr_locations_all.LOC_INFORMATION16%type;
314: p_loc_info_17 hr_locations_all.LOC_INFORMATION17%type;

Line 311: p_loc_info_14 hr_locations_all.LOC_INFORMATION14%type;

307: p_tel_no_1 hr_locations_all.TELEPHONE_NUMBER_1%type;
308: p_tel_no_2 hr_locations_all.TELEPHONE_NUMBER_2%type;
309: p_tel_no_3 hr_locations_all.TELEPHONE_NUMBER_3%type;
310: p_loc_info_13 hr_locations_all.LOC_INFORMATION13%type;
311: p_loc_info_14 hr_locations_all.LOC_INFORMATION14%type;
312: p_loc_info_15 hr_locations_all.LOC_INFORMATION15%type;
313: p_loc_info_16 hr_locations_all.LOC_INFORMATION16%type;
314: p_loc_info_17 hr_locations_all.LOC_INFORMATION17%type;
315: p_loc_info_18 hr_locations_all.LOC_INFORMATION18%type;

Line 312: p_loc_info_15 hr_locations_all.LOC_INFORMATION15%type;

308: p_tel_no_2 hr_locations_all.TELEPHONE_NUMBER_2%type;
309: p_tel_no_3 hr_locations_all.TELEPHONE_NUMBER_3%type;
310: p_loc_info_13 hr_locations_all.LOC_INFORMATION13%type;
311: p_loc_info_14 hr_locations_all.LOC_INFORMATION14%type;
312: p_loc_info_15 hr_locations_all.LOC_INFORMATION15%type;
313: p_loc_info_16 hr_locations_all.LOC_INFORMATION16%type;
314: p_loc_info_17 hr_locations_all.LOC_INFORMATION17%type;
315: p_loc_info_18 hr_locations_all.LOC_INFORMATION18%type;
316: p_loc_info_19 hr_locations_all.LOC_INFORMATION19%type;

Line 313: p_loc_info_16 hr_locations_all.LOC_INFORMATION16%type;

309: p_tel_no_3 hr_locations_all.TELEPHONE_NUMBER_3%type;
310: p_loc_info_13 hr_locations_all.LOC_INFORMATION13%type;
311: p_loc_info_14 hr_locations_all.LOC_INFORMATION14%type;
312: p_loc_info_15 hr_locations_all.LOC_INFORMATION15%type;
313: p_loc_info_16 hr_locations_all.LOC_INFORMATION16%type;
314: p_loc_info_17 hr_locations_all.LOC_INFORMATION17%type;
315: p_loc_info_18 hr_locations_all.LOC_INFORMATION18%type;
316: p_loc_info_19 hr_locations_all.LOC_INFORMATION19%type;
317: p_loc_info_20 hr_locations_all.LOC_INFORMATION20%type;

Line 314: p_loc_info_17 hr_locations_all.LOC_INFORMATION17%type;

310: p_loc_info_13 hr_locations_all.LOC_INFORMATION13%type;
311: p_loc_info_14 hr_locations_all.LOC_INFORMATION14%type;
312: p_loc_info_15 hr_locations_all.LOC_INFORMATION15%type;
313: p_loc_info_16 hr_locations_all.LOC_INFORMATION16%type;
314: p_loc_info_17 hr_locations_all.LOC_INFORMATION17%type;
315: p_loc_info_18 hr_locations_all.LOC_INFORMATION18%type;
316: p_loc_info_19 hr_locations_all.LOC_INFORMATION19%type;
317: p_loc_info_20 hr_locations_all.LOC_INFORMATION20%type;
318: p_effective_date date default sysdate;

Line 315: p_loc_info_18 hr_locations_all.LOC_INFORMATION18%type;

311: p_loc_info_14 hr_locations_all.LOC_INFORMATION14%type;
312: p_loc_info_15 hr_locations_all.LOC_INFORMATION15%type;
313: p_loc_info_16 hr_locations_all.LOC_INFORMATION16%type;
314: p_loc_info_17 hr_locations_all.LOC_INFORMATION17%type;
315: p_loc_info_18 hr_locations_all.LOC_INFORMATION18%type;
316: p_loc_info_19 hr_locations_all.LOC_INFORMATION19%type;
317: p_loc_info_20 hr_locations_all.LOC_INFORMATION20%type;
318: p_effective_date date default sysdate;
319:

Line 316: p_loc_info_19 hr_locations_all.LOC_INFORMATION19%type;

312: p_loc_info_15 hr_locations_all.LOC_INFORMATION15%type;
313: p_loc_info_16 hr_locations_all.LOC_INFORMATION16%type;
314: p_loc_info_17 hr_locations_all.LOC_INFORMATION17%type;
315: p_loc_info_18 hr_locations_all.LOC_INFORMATION18%type;
316: p_loc_info_19 hr_locations_all.LOC_INFORMATION19%type;
317: p_loc_info_20 hr_locations_all.LOC_INFORMATION20%type;
318: p_effective_date date default sysdate;
319:
320: cursor fet_loc_sync is

Line 317: p_loc_info_20 hr_locations_all.LOC_INFORMATION20%type;

313: p_loc_info_16 hr_locations_all.LOC_INFORMATION16%type;
314: p_loc_info_17 hr_locations_all.LOC_INFORMATION17%type;
315: p_loc_info_18 hr_locations_all.LOC_INFORMATION18%type;
316: p_loc_info_19 hr_locations_all.LOC_INFORMATION19%type;
317: p_loc_info_20 hr_locations_all.LOC_INFORMATION20%type;
318: p_effective_date date default sysdate;
319:
320: cursor fet_loc_sync is
321: select BUSINESS_GROUP_ID,

Line 351: hr_locations_all

347: LOC_INFORMATION18,
348: LOC_INFORMATION19,
349: LOC_INFORMATION20
350: from
351: hr_locations_all
352: where inactive_date is null;
353:
354:
355: cursor fet_psft_sync is