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 11: p_bg_id hr_locations_all.business_group_id%type;

7: PROCEDURE HR_LOCATION_INITIAL_LOAD(errbuf OUT NOCOPY VARCHAR2
8: ,retcode OUT NOCOPY VARCHAR2)
9: is
10:
11: p_bg_id hr_locations_all.business_group_id%type;
12: p_loc_id hr_locations_all.LOCATION_ID%type;
13: p_active_date varchar2(10);
14: p_effecive_status varchar2(10);
15: p_lang_code varchar2(10);

Line 12: p_loc_id hr_locations_all.LOCATION_ID%type;

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

Line 16: p_loc_desc hr_locations_all.DESCRIPTION%type;

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

Line 17: p_loc_style hr_locations_all.STYLE%type;

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

Line 18: p_add_line_1 hr_locations_all.ADDRESS_LINE_1%type;

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

Line 19: p_add_line_2 hr_locations_all.ADDRESS_LINE_2%type;

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

Line 20: p_add_line_3 hr_locations_all.ADDRESS_LINE_3%type;

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

Line 21: p_town_or_city hr_locations_all.TOWN_OR_CITY%type;

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

Line 22: p_country hr_locations_all.COUNTRY%type;

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

Line 23: p_postal_code hr_locations_all.POSTAL_CODE%type;

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

Line 24: p_region_1 hr_locations_all.REGION_1%type;

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

Line 25: p_region_2 hr_locations_all.REGION_2%type;

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

Line 26: p_region_3 hr_locations_all.REGION_3%type;

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

Line 27: p_tel_no_1 hr_locations_all.TELEPHONE_NUMBER_1%type;

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

Line 28: p_tel_no_2 hr_locations_all.TELEPHONE_NUMBER_2%type;

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

Line 29: p_tel_no_3 hr_locations_all.TELEPHONE_NUMBER_3%type;

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

Line 30: p_loc_info_13 hr_locations_all.LOC_INFORMATION13%type;

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

Line 31: p_loc_info_14 hr_locations_all.LOC_INFORMATION14%type;

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

Line 32: p_loc_info_15 hr_locations_all.LOC_INFORMATION15%type;

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

Line 33: p_loc_info_16 hr_locations_all.LOC_INFORMATION16%type;

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

Line 34: p_loc_info_17 hr_locations_all.LOC_INFORMATION17%type;

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

Line 35: p_loc_info_18 hr_locations_all.LOC_INFORMATION18%type;

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

Line 36: p_loc_info_19 hr_locations_all.LOC_INFORMATION19%type;

32: p_loc_info_15 hr_locations_all.LOC_INFORMATION15%type;
33: p_loc_info_16 hr_locations_all.LOC_INFORMATION16%type;
34: p_loc_info_17 hr_locations_all.LOC_INFORMATION17%type;
35: p_loc_info_18 hr_locations_all.LOC_INFORMATION18%type;
36: p_loc_info_19 hr_locations_all.LOC_INFORMATION19%type;
37: p_loc_info_20 hr_locations_all.LOC_INFORMATION20%type;
38:
39:
40: /*CURSOR TO FETCH THE LOCATION DETAILS*/

Line 37: p_loc_info_20 hr_locations_all.LOC_INFORMATION20%type;

33: p_loc_info_16 hr_locations_all.LOC_INFORMATION16%type;
34: p_loc_info_17 hr_locations_all.LOC_INFORMATION17%type;
35: p_loc_info_18 hr_locations_all.LOC_INFORMATION18%type;
36: p_loc_info_19 hr_locations_all.LOC_INFORMATION19%type;
37: p_loc_info_20 hr_locations_all.LOC_INFORMATION20%type;
38:
39:
40: /*CURSOR TO FETCH THE LOCATION DETAILS*/
41: cursor CSR_LOC_INITIAL_LOAD is

Line 70: hr_locations_all hloc,hr_locations_all_tl tl

66: LOC_INFORMATION18,
67: LOC_INFORMATION19,
68: LOC_INFORMATION20
69: from
70: hr_locations_all hloc,hr_locations_all_tl tl
71: where tl.location_id = hloc.location_id
72: and nvl(inactive_date,to_date('31/12/4712','DD/MM/YYYY')) > sysdate
73: union
74: select hloc.BUSINESS_GROUP_ID,

Line 102: hr_locations_all hloc,hr_locations_all_tl tl

98: LOC_INFORMATION18,
99: LOC_INFORMATION19,
100: LOC_INFORMATION20
101: from
102: hr_locations_all hloc,hr_locations_all_tl tl
103: where tl.location_id = hloc.location_id
104: and inactive_date is not null
105: order by business_group_id,location_id ;
106: