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;
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;
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;
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);
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
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
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
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;