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

Line 54: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE,

50:
51: pr_site_loc_rec pr_site_loc_rec_type;
52:
53: TYPE pr_org_loc_rec_type is RECORD(
54: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE,
55: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
56: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
57: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
58: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,

Line 55: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,

51: pr_site_loc_rec pr_site_loc_rec_type;
52:
53: TYPE pr_org_loc_rec_type is RECORD(
54: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE,
55: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
56: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
57: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
58: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
59: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,

Line 56: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,

52:
53: TYPE pr_org_loc_rec_type is RECORD(
54: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE,
55: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
56: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
57: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
58: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
59: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
60: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,

Line 57: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,

53: TYPE pr_org_loc_rec_type is RECORD(
54: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE,
55: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
56: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
57: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
58: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
59: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
60: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
61: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,

Line 58: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,

54: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE,
55: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
56: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
57: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
58: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
59: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
60: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
61: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
62: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,

Line 59: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,

55: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
56: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
57: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
58: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
59: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
60: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
61: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
62: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
63: TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE,

Line 60: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,

56: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
57: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
58: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
59: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
60: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
61: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
62: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
63: TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE,
64: TELEPHONE_NUMBER_2 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_2%TYPE,

Line 61: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,

57: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
58: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
59: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
60: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
61: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
62: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
63: TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE,
64: TELEPHONE_NUMBER_2 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_2%TYPE,
65: TELEPHONE_NUMBER_3 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_3%TYPE,

Line 62: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,

58: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
59: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
60: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
61: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
62: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
63: TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE,
64: TELEPHONE_NUMBER_2 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_2%TYPE,
65: TELEPHONE_NUMBER_3 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_3%TYPE,
66: STYLE HR_LOCATIONS_ALL.STYLE%TYPE,

Line 63: TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE,

59: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
60: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
61: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
62: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
63: TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE,
64: TELEPHONE_NUMBER_2 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_2%TYPE,
65: TELEPHONE_NUMBER_3 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_3%TYPE,
66: STYLE HR_LOCATIONS_ALL.STYLE%TYPE,
67: LOCATION_ID HR_LOCATIONS_ALL.LOCATION_ID%TYPE -- bug fix 4417523

Line 64: TELEPHONE_NUMBER_2 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_2%TYPE,

60: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
61: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
62: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
63: TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE,
64: TELEPHONE_NUMBER_2 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_2%TYPE,
65: TELEPHONE_NUMBER_3 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_3%TYPE,
66: STYLE HR_LOCATIONS_ALL.STYLE%TYPE,
67: LOCATION_ID HR_LOCATIONS_ALL.LOCATION_ID%TYPE -- bug fix 4417523
68: -- ORGANIZATION_ID NUMBER

Line 65: TELEPHONE_NUMBER_3 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_3%TYPE,

61: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
62: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
63: TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE,
64: TELEPHONE_NUMBER_2 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_2%TYPE,
65: TELEPHONE_NUMBER_3 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_3%TYPE,
66: STYLE HR_LOCATIONS_ALL.STYLE%TYPE,
67: LOCATION_ID HR_LOCATIONS_ALL.LOCATION_ID%TYPE -- bug fix 4417523
68: -- ORGANIZATION_ID NUMBER
69: );

Line 66: STYLE HR_LOCATIONS_ALL.STYLE%TYPE,

62: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
63: TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE,
64: TELEPHONE_NUMBER_2 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_2%TYPE,
65: TELEPHONE_NUMBER_3 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_3%TYPE,
66: STYLE HR_LOCATIONS_ALL.STYLE%TYPE,
67: LOCATION_ID HR_LOCATIONS_ALL.LOCATION_ID%TYPE -- bug fix 4417523
68: -- ORGANIZATION_ID NUMBER
69: );
70:

Line 67: LOCATION_ID HR_LOCATIONS_ALL.LOCATION_ID%TYPE -- bug fix 4417523

63: TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE,
64: TELEPHONE_NUMBER_2 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_2%TYPE,
65: TELEPHONE_NUMBER_3 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_3%TYPE,
66: STYLE HR_LOCATIONS_ALL.STYLE%TYPE,
67: LOCATION_ID HR_LOCATIONS_ALL.LOCATION_ID%TYPE -- bug fix 4417523
68: -- ORGANIZATION_ID NUMBER
69: );
70:
71: pr_org_loc_rec pr_org_loc_rec_type;

Line 580: from hr_locations_all loc,

576: loc.TELEPHONE_NUMBER_2,
577: loc.TELEPHONE_NUMBER_3,
578: loc.STYLE,
579: loc.LOCATION_ID
580: from hr_locations_all loc,
581: fnd_descr_flex_contexts fnd
582: where loc.location_id = c_location_id
583: AND loc.style = fnd.descriptive_flex_context_code
584: AND fnd.application_id = 800 -- Application_short_name 'PER'