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_HRHD_INITIAL_LOAD dependencies on HR_LOCATIONS_ALL

Line 12: p_bg_id hr_locations_all.business_group_id%type;

8: ,retcode OUT NOCOPY VARCHAR2
9: ,p_number_of_files in Number)
10: is
11:
12: p_bg_id hr_locations_all.business_group_id%type;
13: p_loc_id hr_locations_all.LOCATION_ID%type;
14: p_active_date varchar2(10);
15: p_effecive_status varchar2(10);
16: p_lang_code varchar2(10);

Line 13: p_loc_id hr_locations_all.LOCATION_ID%type;

9: ,p_number_of_files in Number)
10: is
11:
12: p_bg_id hr_locations_all.business_group_id%type;
13: p_loc_id hr_locations_all.LOCATION_ID%type;
14: p_active_date varchar2(10);
15: p_effecive_status varchar2(10);
16: p_lang_code varchar2(10);
17: p_loc_desc hr_locations_all.DESCRIPTION%type;

Line 17: p_loc_desc hr_locations_all.DESCRIPTION%type;

13: p_loc_id hr_locations_all.LOCATION_ID%type;
14: p_active_date varchar2(10);
15: p_effecive_status varchar2(10);
16: p_lang_code varchar2(10);
17: p_loc_desc hr_locations_all.DESCRIPTION%type;
18: p_loc_style hr_locations_all.STYLE%type;
19: p_add_line_1 hr_locations_all.ADDRESS_LINE_1%type;
20: p_add_line_2 hr_locations_all.ADDRESS_LINE_2%type;
21: p_add_line_3 hr_locations_all.ADDRESS_LINE_3%type;

Line 18: p_loc_style hr_locations_all.STYLE%type;

14: p_active_date varchar2(10);
15: p_effecive_status varchar2(10);
16: p_lang_code varchar2(10);
17: p_loc_desc hr_locations_all.DESCRIPTION%type;
18: p_loc_style hr_locations_all.STYLE%type;
19: p_add_line_1 hr_locations_all.ADDRESS_LINE_1%type;
20: p_add_line_2 hr_locations_all.ADDRESS_LINE_2%type;
21: p_add_line_3 hr_locations_all.ADDRESS_LINE_3%type;
22: p_town_or_city hr_locations_all.TOWN_OR_CITY%type;

Line 19: p_add_line_1 hr_locations_all.ADDRESS_LINE_1%type;

15: p_effecive_status varchar2(10);
16: p_lang_code varchar2(10);
17: p_loc_desc hr_locations_all.DESCRIPTION%type;
18: p_loc_style hr_locations_all.STYLE%type;
19: p_add_line_1 hr_locations_all.ADDRESS_LINE_1%type;
20: p_add_line_2 hr_locations_all.ADDRESS_LINE_2%type;
21: p_add_line_3 hr_locations_all.ADDRESS_LINE_3%type;
22: p_town_or_city hr_locations_all.TOWN_OR_CITY%type;
23: p_country hr_locations_all.COUNTRY%type;

Line 20: p_add_line_2 hr_locations_all.ADDRESS_LINE_2%type;

16: p_lang_code varchar2(10);
17: p_loc_desc hr_locations_all.DESCRIPTION%type;
18: p_loc_style hr_locations_all.STYLE%type;
19: p_add_line_1 hr_locations_all.ADDRESS_LINE_1%type;
20: p_add_line_2 hr_locations_all.ADDRESS_LINE_2%type;
21: p_add_line_3 hr_locations_all.ADDRESS_LINE_3%type;
22: p_town_or_city hr_locations_all.TOWN_OR_CITY%type;
23: p_country hr_locations_all.COUNTRY%type;
24: p_postal_code hr_locations_all.POSTAL_CODE%type;

Line 21: p_add_line_3 hr_locations_all.ADDRESS_LINE_3%type;

17: p_loc_desc hr_locations_all.DESCRIPTION%type;
18: p_loc_style hr_locations_all.STYLE%type;
19: p_add_line_1 hr_locations_all.ADDRESS_LINE_1%type;
20: p_add_line_2 hr_locations_all.ADDRESS_LINE_2%type;
21: p_add_line_3 hr_locations_all.ADDRESS_LINE_3%type;
22: p_town_or_city hr_locations_all.TOWN_OR_CITY%type;
23: p_country hr_locations_all.COUNTRY%type;
24: p_postal_code hr_locations_all.POSTAL_CODE%type;
25: p_region_1 hr_locations_all.REGION_1%type;

Line 22: p_town_or_city hr_locations_all.TOWN_OR_CITY%type;

18: p_loc_style hr_locations_all.STYLE%type;
19: p_add_line_1 hr_locations_all.ADDRESS_LINE_1%type;
20: p_add_line_2 hr_locations_all.ADDRESS_LINE_2%type;
21: p_add_line_3 hr_locations_all.ADDRESS_LINE_3%type;
22: p_town_or_city hr_locations_all.TOWN_OR_CITY%type;
23: p_country hr_locations_all.COUNTRY%type;
24: p_postal_code hr_locations_all.POSTAL_CODE%type;
25: p_region_1 hr_locations_all.REGION_1%type;
26: p_region_2 hr_locations_all.REGION_2%type;

Line 23: p_country hr_locations_all.COUNTRY%type;

19: p_add_line_1 hr_locations_all.ADDRESS_LINE_1%type;
20: p_add_line_2 hr_locations_all.ADDRESS_LINE_2%type;
21: p_add_line_3 hr_locations_all.ADDRESS_LINE_3%type;
22: p_town_or_city hr_locations_all.TOWN_OR_CITY%type;
23: p_country hr_locations_all.COUNTRY%type;
24: p_postal_code hr_locations_all.POSTAL_CODE%type;
25: p_region_1 hr_locations_all.REGION_1%type;
26: p_region_2 hr_locations_all.REGION_2%type;
27: p_region_3 hr_locations_all.REGION_3%type;

Line 24: p_postal_code hr_locations_all.POSTAL_CODE%type;

20: p_add_line_2 hr_locations_all.ADDRESS_LINE_2%type;
21: p_add_line_3 hr_locations_all.ADDRESS_LINE_3%type;
22: p_town_or_city hr_locations_all.TOWN_OR_CITY%type;
23: p_country hr_locations_all.COUNTRY%type;
24: p_postal_code hr_locations_all.POSTAL_CODE%type;
25: p_region_1 hr_locations_all.REGION_1%type;
26: p_region_2 hr_locations_all.REGION_2%type;
27: p_region_3 hr_locations_all.REGION_3%type;
28: p_tel_no_1 hr_locations_all.TELEPHONE_NUMBER_1%type;

Line 25: p_region_1 hr_locations_all.REGION_1%type;

21: p_add_line_3 hr_locations_all.ADDRESS_LINE_3%type;
22: p_town_or_city hr_locations_all.TOWN_OR_CITY%type;
23: p_country hr_locations_all.COUNTRY%type;
24: p_postal_code hr_locations_all.POSTAL_CODE%type;
25: p_region_1 hr_locations_all.REGION_1%type;
26: p_region_2 hr_locations_all.REGION_2%type;
27: p_region_3 hr_locations_all.REGION_3%type;
28: p_tel_no_1 hr_locations_all.TELEPHONE_NUMBER_1%type;
29: p_tel_no_2 hr_locations_all.TELEPHONE_NUMBER_2%type;

Line 26: p_region_2 hr_locations_all.REGION_2%type;

22: p_town_or_city hr_locations_all.TOWN_OR_CITY%type;
23: p_country hr_locations_all.COUNTRY%type;
24: p_postal_code hr_locations_all.POSTAL_CODE%type;
25: p_region_1 hr_locations_all.REGION_1%type;
26: p_region_2 hr_locations_all.REGION_2%type;
27: p_region_3 hr_locations_all.REGION_3%type;
28: p_tel_no_1 hr_locations_all.TELEPHONE_NUMBER_1%type;
29: p_tel_no_2 hr_locations_all.TELEPHONE_NUMBER_2%type;
30: p_tel_no_3 hr_locations_all.TELEPHONE_NUMBER_3%type;

Line 27: p_region_3 hr_locations_all.REGION_3%type;

23: p_country hr_locations_all.COUNTRY%type;
24: p_postal_code hr_locations_all.POSTAL_CODE%type;
25: p_region_1 hr_locations_all.REGION_1%type;
26: p_region_2 hr_locations_all.REGION_2%type;
27: p_region_3 hr_locations_all.REGION_3%type;
28: p_tel_no_1 hr_locations_all.TELEPHONE_NUMBER_1%type;
29: p_tel_no_2 hr_locations_all.TELEPHONE_NUMBER_2%type;
30: p_tel_no_3 hr_locations_all.TELEPHONE_NUMBER_3%type;
31: p_loc_info_13 hr_locations_all.LOC_INFORMATION13%type;

Line 28: p_tel_no_1 hr_locations_all.TELEPHONE_NUMBER_1%type;

24: p_postal_code hr_locations_all.POSTAL_CODE%type;
25: p_region_1 hr_locations_all.REGION_1%type;
26: p_region_2 hr_locations_all.REGION_2%type;
27: p_region_3 hr_locations_all.REGION_3%type;
28: p_tel_no_1 hr_locations_all.TELEPHONE_NUMBER_1%type;
29: p_tel_no_2 hr_locations_all.TELEPHONE_NUMBER_2%type;
30: p_tel_no_3 hr_locations_all.TELEPHONE_NUMBER_3%type;
31: p_loc_info_13 hr_locations_all.LOC_INFORMATION13%type;
32: p_loc_info_14 hr_locations_all.LOC_INFORMATION14%type;

Line 29: p_tel_no_2 hr_locations_all.TELEPHONE_NUMBER_2%type;

25: p_region_1 hr_locations_all.REGION_1%type;
26: p_region_2 hr_locations_all.REGION_2%type;
27: p_region_3 hr_locations_all.REGION_3%type;
28: p_tel_no_1 hr_locations_all.TELEPHONE_NUMBER_1%type;
29: p_tel_no_2 hr_locations_all.TELEPHONE_NUMBER_2%type;
30: p_tel_no_3 hr_locations_all.TELEPHONE_NUMBER_3%type;
31: p_loc_info_13 hr_locations_all.LOC_INFORMATION13%type;
32: p_loc_info_14 hr_locations_all.LOC_INFORMATION14%type;
33: p_loc_info_15 hr_locations_all.LOC_INFORMATION15%type;

Line 30: p_tel_no_3 hr_locations_all.TELEPHONE_NUMBER_3%type;

26: p_region_2 hr_locations_all.REGION_2%type;
27: p_region_3 hr_locations_all.REGION_3%type;
28: p_tel_no_1 hr_locations_all.TELEPHONE_NUMBER_1%type;
29: p_tel_no_2 hr_locations_all.TELEPHONE_NUMBER_2%type;
30: p_tel_no_3 hr_locations_all.TELEPHONE_NUMBER_3%type;
31: p_loc_info_13 hr_locations_all.LOC_INFORMATION13%type;
32: p_loc_info_14 hr_locations_all.LOC_INFORMATION14%type;
33: p_loc_info_15 hr_locations_all.LOC_INFORMATION15%type;
34: p_loc_info_16 hr_locations_all.LOC_INFORMATION16%type;

Line 31: p_loc_info_13 hr_locations_all.LOC_INFORMATION13%type;

27: p_region_3 hr_locations_all.REGION_3%type;
28: p_tel_no_1 hr_locations_all.TELEPHONE_NUMBER_1%type;
29: p_tel_no_2 hr_locations_all.TELEPHONE_NUMBER_2%type;
30: p_tel_no_3 hr_locations_all.TELEPHONE_NUMBER_3%type;
31: p_loc_info_13 hr_locations_all.LOC_INFORMATION13%type;
32: p_loc_info_14 hr_locations_all.LOC_INFORMATION14%type;
33: p_loc_info_15 hr_locations_all.LOC_INFORMATION15%type;
34: p_loc_info_16 hr_locations_all.LOC_INFORMATION16%type;
35: p_loc_info_17 hr_locations_all.LOC_INFORMATION17%type;

Line 32: p_loc_info_14 hr_locations_all.LOC_INFORMATION14%type;

28: p_tel_no_1 hr_locations_all.TELEPHONE_NUMBER_1%type;
29: p_tel_no_2 hr_locations_all.TELEPHONE_NUMBER_2%type;
30: p_tel_no_3 hr_locations_all.TELEPHONE_NUMBER_3%type;
31: p_loc_info_13 hr_locations_all.LOC_INFORMATION13%type;
32: p_loc_info_14 hr_locations_all.LOC_INFORMATION14%type;
33: p_loc_info_15 hr_locations_all.LOC_INFORMATION15%type;
34: p_loc_info_16 hr_locations_all.LOC_INFORMATION16%type;
35: p_loc_info_17 hr_locations_all.LOC_INFORMATION17%type;
36: p_loc_info_18 hr_locations_all.LOC_INFORMATION18%type;

Line 33: p_loc_info_15 hr_locations_all.LOC_INFORMATION15%type;

29: p_tel_no_2 hr_locations_all.TELEPHONE_NUMBER_2%type;
30: p_tel_no_3 hr_locations_all.TELEPHONE_NUMBER_3%type;
31: p_loc_info_13 hr_locations_all.LOC_INFORMATION13%type;
32: p_loc_info_14 hr_locations_all.LOC_INFORMATION14%type;
33: p_loc_info_15 hr_locations_all.LOC_INFORMATION15%type;
34: p_loc_info_16 hr_locations_all.LOC_INFORMATION16%type;
35: p_loc_info_17 hr_locations_all.LOC_INFORMATION17%type;
36: p_loc_info_18 hr_locations_all.LOC_INFORMATION18%type;
37: p_loc_info_19 hr_locations_all.LOC_INFORMATION19%type;

Line 34: p_loc_info_16 hr_locations_all.LOC_INFORMATION16%type;

30: p_tel_no_3 hr_locations_all.TELEPHONE_NUMBER_3%type;
31: p_loc_info_13 hr_locations_all.LOC_INFORMATION13%type;
32: p_loc_info_14 hr_locations_all.LOC_INFORMATION14%type;
33: p_loc_info_15 hr_locations_all.LOC_INFORMATION15%type;
34: p_loc_info_16 hr_locations_all.LOC_INFORMATION16%type;
35: p_loc_info_17 hr_locations_all.LOC_INFORMATION17%type;
36: p_loc_info_18 hr_locations_all.LOC_INFORMATION18%type;
37: p_loc_info_19 hr_locations_all.LOC_INFORMATION19%type;
38: p_loc_info_20 hr_locations_all.LOC_INFORMATION20%type;

Line 35: p_loc_info_17 hr_locations_all.LOC_INFORMATION17%type;

31: p_loc_info_13 hr_locations_all.LOC_INFORMATION13%type;
32: p_loc_info_14 hr_locations_all.LOC_INFORMATION14%type;
33: p_loc_info_15 hr_locations_all.LOC_INFORMATION15%type;
34: p_loc_info_16 hr_locations_all.LOC_INFORMATION16%type;
35: p_loc_info_17 hr_locations_all.LOC_INFORMATION17%type;
36: p_loc_info_18 hr_locations_all.LOC_INFORMATION18%type;
37: p_loc_info_19 hr_locations_all.LOC_INFORMATION19%type;
38: p_loc_info_20 hr_locations_all.LOC_INFORMATION20%type;
39:

Line 36: p_loc_info_18 hr_locations_all.LOC_INFORMATION18%type;

32: p_loc_info_14 hr_locations_all.LOC_INFORMATION14%type;
33: p_loc_info_15 hr_locations_all.LOC_INFORMATION15%type;
34: p_loc_info_16 hr_locations_all.LOC_INFORMATION16%type;
35: p_loc_info_17 hr_locations_all.LOC_INFORMATION17%type;
36: p_loc_info_18 hr_locations_all.LOC_INFORMATION18%type;
37: p_loc_info_19 hr_locations_all.LOC_INFORMATION19%type;
38: p_loc_info_20 hr_locations_all.LOC_INFORMATION20%type;
39:
40: l_record_counter Number :=0;

Line 37: p_loc_info_19 hr_locations_all.LOC_INFORMATION19%type;

33: p_loc_info_15 hr_locations_all.LOC_INFORMATION15%type;
34: p_loc_info_16 hr_locations_all.LOC_INFORMATION16%type;
35: p_loc_info_17 hr_locations_all.LOC_INFORMATION17%type;
36: p_loc_info_18 hr_locations_all.LOC_INFORMATION18%type;
37: p_loc_info_19 hr_locations_all.LOC_INFORMATION19%type;
38: p_loc_info_20 hr_locations_all.LOC_INFORMATION20%type;
39:
40: l_record_counter Number :=0;
41: l_file_counter Number :=0;

Line 38: p_loc_info_20 hr_locations_all.LOC_INFORMATION20%type;

34: p_loc_info_16 hr_locations_all.LOC_INFORMATION16%type;
35: p_loc_info_17 hr_locations_all.LOC_INFORMATION17%type;
36: p_loc_info_18 hr_locations_all.LOC_INFORMATION18%type;
37: p_loc_info_19 hr_locations_all.LOC_INFORMATION19%type;
38: p_loc_info_20 hr_locations_all.LOC_INFORMATION20%type;
39:
40: l_record_counter Number :=0;
41: l_file_counter Number :=0;
42: r Number :=1;

Line 82: hr_locations_all hloc,hr_locations_all_tl tl

78: LOC_INFORMATION18,
79: LOC_INFORMATION19,
80: LOC_INFORMATION20
81: from
82: hr_locations_all hloc,hr_locations_all_tl tl
83: where tl.location_id = hloc.location_id
84: and nvl(inactive_date,to_date('31/12/4712','DD/MM/YYYY')) > sysdate
85: union
86: select hloc.BUSINESS_GROUP_ID,

Line 114: hr_locations_all hloc,hr_locations_all_tl tl

110: LOC_INFORMATION18,
111: LOC_INFORMATION19,
112: LOC_INFORMATION20
113: from
114: hr_locations_all hloc,hr_locations_all_tl tl
115: where tl.location_id = hloc.location_id
116: and inactive_date is not null
117: order by business_group_id,location_id ;
118: