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.AP_APXVDLET_XMLP_PKG dependencies on HR_LOCATIONS

Line 96: FROM_ADDRESS_LINE1 HR_LOCATIONS.ADDRESS_LINE_1%TYPE;

92: FUNCTION BEFOREREPORT RETURN BOOLEAN IS
93: BEGIN
94: DECLARE
95: INIT_FAILURE EXCEPTION;
96: FROM_ADDRESS_LINE1 HR_LOCATIONS.ADDRESS_LINE_1%TYPE;
97: FROM_ADDRESS_LINE2 HR_LOCATIONS.ADDRESS_LINE_2%TYPE;
98: FROM_ADDRESS_LINE3 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;
99: FROM_CITY HR_LOCATIONS.TOWN_OR_CITY%TYPE;
100: FROM_STATE HR_LOCATIONS.REGION_3%TYPE;

Line 97: FROM_ADDRESS_LINE2 HR_LOCATIONS.ADDRESS_LINE_2%TYPE;

93: BEGIN
94: DECLARE
95: INIT_FAILURE EXCEPTION;
96: FROM_ADDRESS_LINE1 HR_LOCATIONS.ADDRESS_LINE_1%TYPE;
97: FROM_ADDRESS_LINE2 HR_LOCATIONS.ADDRESS_LINE_2%TYPE;
98: FROM_ADDRESS_LINE3 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;
99: FROM_CITY HR_LOCATIONS.TOWN_OR_CITY%TYPE;
100: FROM_STATE HR_LOCATIONS.REGION_3%TYPE;
101: FROM_ZIP HR_LOCATIONS.POSTAL_CODE%TYPE;

Line 98: FROM_ADDRESS_LINE3 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;

94: DECLARE
95: INIT_FAILURE EXCEPTION;
96: FROM_ADDRESS_LINE1 HR_LOCATIONS.ADDRESS_LINE_1%TYPE;
97: FROM_ADDRESS_LINE2 HR_LOCATIONS.ADDRESS_LINE_2%TYPE;
98: FROM_ADDRESS_LINE3 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;
99: FROM_CITY HR_LOCATIONS.TOWN_OR_CITY%TYPE;
100: FROM_STATE HR_LOCATIONS.REGION_3%TYPE;
101: FROM_ZIP HR_LOCATIONS.POSTAL_CODE%TYPE;
102: LOCATION_ID HR_LOCATIONS.LOCATION_ID%TYPE;

Line 99: FROM_CITY HR_LOCATIONS.TOWN_OR_CITY%TYPE;

95: INIT_FAILURE EXCEPTION;
96: FROM_ADDRESS_LINE1 HR_LOCATIONS.ADDRESS_LINE_1%TYPE;
97: FROM_ADDRESS_LINE2 HR_LOCATIONS.ADDRESS_LINE_2%TYPE;
98: FROM_ADDRESS_LINE3 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;
99: FROM_CITY HR_LOCATIONS.TOWN_OR_CITY%TYPE;
100: FROM_STATE HR_LOCATIONS.REGION_3%TYPE;
101: FROM_ZIP HR_LOCATIONS.POSTAL_CODE%TYPE;
102: LOCATION_ID HR_LOCATIONS.LOCATION_ID%TYPE;
103: DISP_RETURN_DATE VARCHAR2(30);

Line 100: FROM_STATE HR_LOCATIONS.REGION_3%TYPE;

96: FROM_ADDRESS_LINE1 HR_LOCATIONS.ADDRESS_LINE_1%TYPE;
97: FROM_ADDRESS_LINE2 HR_LOCATIONS.ADDRESS_LINE_2%TYPE;
98: FROM_ADDRESS_LINE3 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;
99: FROM_CITY HR_LOCATIONS.TOWN_OR_CITY%TYPE;
100: FROM_STATE HR_LOCATIONS.REGION_3%TYPE;
101: FROM_ZIP HR_LOCATIONS.POSTAL_CODE%TYPE;
102: LOCATION_ID HR_LOCATIONS.LOCATION_ID%TYPE;
103: DISP_RETURN_DATE VARCHAR2(30);
104: BEGIN

Line 101: FROM_ZIP HR_LOCATIONS.POSTAL_CODE%TYPE;

97: FROM_ADDRESS_LINE2 HR_LOCATIONS.ADDRESS_LINE_2%TYPE;
98: FROM_ADDRESS_LINE3 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;
99: FROM_CITY HR_LOCATIONS.TOWN_OR_CITY%TYPE;
100: FROM_STATE HR_LOCATIONS.REGION_3%TYPE;
101: FROM_ZIP HR_LOCATIONS.POSTAL_CODE%TYPE;
102: LOCATION_ID HR_LOCATIONS.LOCATION_ID%TYPE;
103: DISP_RETURN_DATE VARCHAR2(30);
104: BEGIN
105: SELECT

Line 102: LOCATION_ID HR_LOCATIONS.LOCATION_ID%TYPE;

98: FROM_ADDRESS_LINE3 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;
99: FROM_CITY HR_LOCATIONS.TOWN_OR_CITY%TYPE;
100: FROM_STATE HR_LOCATIONS.REGION_3%TYPE;
101: FROM_ZIP HR_LOCATIONS.POSTAL_CODE%TYPE;
102: LOCATION_ID HR_LOCATIONS.LOCATION_ID%TYPE;
103: DISP_RETURN_DATE VARCHAR2(30);
104: BEGIN
105: SELECT
106: SUBSTR(L.ADDRESS_LINE_1

Line 133: HR_LOCATIONS L

129: ,FROM_CITY
130: ,FROM_STATE
131: ,FROM_ZIP
132: FROM
133: HR_LOCATIONS L
134: WHERE L.LOCATION_ID = P_LOCATION_ID;
135: C_FROM_ADD_LINE_1 := FROM_ADDRESS_LINE1;
136: C_FROM_ADD_LINE_2 := FROM_ADDRESS_LINE2;
137: C_FROM_ADD_LINE_3 := FROM_ADDRESS_LINE3;