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_APXVDRAL_XMLP_PKG dependencies on HR_LOCATIONS

Line 93: FROM_ADDRESS_LINE1 HR_LOCATIONS.ADDRESS_LINE_1%TYPE;

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

Line 94: FROM_ADDRESS_LINE2 HR_LOCATIONS.ADDRESS_LINE_2%TYPE;

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

Line 95: FROM_ADDRESS_LINE3 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;

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

Line 96: FROM_CITY HR_LOCATIONS.TOWN_OR_CITY%TYPE;

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

Line 97: FROM_STATE HR_LOCATIONS.REGION_3%TYPE;

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

Line 98: FROM_ZIP HR_LOCATIONS.POSTAL_CODE%TYPE;

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

Line 99: LOCATION_ID HR_LOCATIONS.LOCATION_ID%TYPE;

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

Line 124: HR_LOCATIONS L

120: ,1
121: ,20)
122: INTO FROM_ADDRESS_LINE1,FROM_ADDRESS_LINE2,FROM_ADDRESS_LINE3,FROM_CITY,FROM_STATE,FROM_ZIP
123: FROM
124: HR_LOCATIONS L
125: WHERE L.LOCATION_CODE = P_LOCATION_CODE;
126: C_FROM_ADD_LINE_1 := FROM_ADDRESS_LINE1;
127: C_FROM_ADD_LINE_2 := FROM_ADDRESS_LINE2;
128: C_FROM_ADD_LINE_3 := FROM_ADDRESS_LINE3;