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

Line 225: -- IN : p_location_id hr_locations.location_id --

221: -- Access : Private --
222: -- Description : This procedure gets the gre location details --
223: -- --
224: -- Parameters : --
225: -- IN : p_location_id hr_locations.location_id --
226: -- : p_concatenate VARCHAR2 --
227: -- p_field VARCHAR2 --
228: --------------------------------------------------------------------------
229: FUNCTION get_location_details ( p_location_id IN hr_locations.location_id%TYPE

Line 229: FUNCTION get_location_details ( p_location_id IN hr_locations.location_id%TYPE

225: -- IN : p_location_id hr_locations.location_id --
226: -- : p_concatenate VARCHAR2 --
227: -- p_field VARCHAR2 --
228: --------------------------------------------------------------------------
229: FUNCTION get_location_details ( p_location_id IN hr_locations.location_id%TYPE
230: , p_concatenate IN VARCHAR2 DEFAULT 'N'
231: , p_field IN VARCHAR2 DEFAULT NULL
232: )
233: RETURN VARCHAR2

Line 247: FROM hr_locations hr_loc

243: , hr_general.decode_lookup('IN_STATES',hr_loc.loc_information16)
244: , hr_general.decode_lookup('PER_US_COUNTRY_CODE',hr_loc.country)
245: , hr_loc.postal_code
246: , hr_loc.loc_information16
247: FROM hr_locations hr_loc
248: WHERE location_id = p_location_id;
249:
250: l_procedure VARCHAR2(100);
251: l_location_address1 hr_locations.address_line_1%TYPE;

Line 251: l_location_address1 hr_locations.address_line_1%TYPE;

247: FROM hr_locations hr_loc
248: WHERE location_id = p_location_id;
249:
250: l_procedure VARCHAR2(100);
251: l_location_address1 hr_locations.address_line_1%TYPE;
252: l_location_address2 hr_locations.address_line_2%TYPE;
253: l_location_address3 hr_locations.address_line_3%TYPE;
254: l_location_address4 hr_locations.loc_information14%TYPE;
255: l_location_city hr_locations.loc_information15%TYPE;

Line 252: l_location_address2 hr_locations.address_line_2%TYPE;

248: WHERE location_id = p_location_id;
249:
250: l_procedure VARCHAR2(100);
251: l_location_address1 hr_locations.address_line_1%TYPE;
252: l_location_address2 hr_locations.address_line_2%TYPE;
253: l_location_address3 hr_locations.address_line_3%TYPE;
254: l_location_address4 hr_locations.loc_information14%TYPE;
255: l_location_city hr_locations.loc_information15%TYPE;
256: l_location_state hr_locations.loc_information16%TYPE;

Line 253: l_location_address3 hr_locations.address_line_3%TYPE;

249:
250: l_procedure VARCHAR2(100);
251: l_location_address1 hr_locations.address_line_1%TYPE;
252: l_location_address2 hr_locations.address_line_2%TYPE;
253: l_location_address3 hr_locations.address_line_3%TYPE;
254: l_location_address4 hr_locations.loc_information14%TYPE;
255: l_location_city hr_locations.loc_information15%TYPE;
256: l_location_state hr_locations.loc_information16%TYPE;
257: l_location_country hr_locations.country%TYPE;

Line 254: l_location_address4 hr_locations.loc_information14%TYPE;

250: l_procedure VARCHAR2(100);
251: l_location_address1 hr_locations.address_line_1%TYPE;
252: l_location_address2 hr_locations.address_line_2%TYPE;
253: l_location_address3 hr_locations.address_line_3%TYPE;
254: l_location_address4 hr_locations.loc_information14%TYPE;
255: l_location_city hr_locations.loc_information15%TYPE;
256: l_location_state hr_locations.loc_information16%TYPE;
257: l_location_country hr_locations.country%TYPE;
258: l_location_zipcode hr_locations.postal_code%TYPE;

Line 255: l_location_city hr_locations.loc_information15%TYPE;

251: l_location_address1 hr_locations.address_line_1%TYPE;
252: l_location_address2 hr_locations.address_line_2%TYPE;
253: l_location_address3 hr_locations.address_line_3%TYPE;
254: l_location_address4 hr_locations.loc_information14%TYPE;
255: l_location_city hr_locations.loc_information15%TYPE;
256: l_location_state hr_locations.loc_information16%TYPE;
257: l_location_country hr_locations.country%TYPE;
258: l_location_zipcode hr_locations.postal_code%TYPE;
259: l_state_code hr_locations.loc_information16%TYPE;

Line 256: l_location_state hr_locations.loc_information16%TYPE;

252: l_location_address2 hr_locations.address_line_2%TYPE;
253: l_location_address3 hr_locations.address_line_3%TYPE;
254: l_location_address4 hr_locations.loc_information14%TYPE;
255: l_location_city hr_locations.loc_information15%TYPE;
256: l_location_state hr_locations.loc_information16%TYPE;
257: l_location_country hr_locations.country%TYPE;
258: l_location_zipcode hr_locations.postal_code%TYPE;
259: l_state_code hr_locations.loc_information16%TYPE;
260: l_details VARCHAR2(1000);

Line 257: l_location_country hr_locations.country%TYPE;

253: l_location_address3 hr_locations.address_line_3%TYPE;
254: l_location_address4 hr_locations.loc_information14%TYPE;
255: l_location_city hr_locations.loc_information15%TYPE;
256: l_location_state hr_locations.loc_information16%TYPE;
257: l_location_country hr_locations.country%TYPE;
258: l_location_zipcode hr_locations.postal_code%TYPE;
259: l_state_code hr_locations.loc_information16%TYPE;
260: l_details VARCHAR2(1000);
261:

Line 258: l_location_zipcode hr_locations.postal_code%TYPE;

254: l_location_address4 hr_locations.loc_information14%TYPE;
255: l_location_city hr_locations.loc_information15%TYPE;
256: l_location_state hr_locations.loc_information16%TYPE;
257: l_location_country hr_locations.country%TYPE;
258: l_location_zipcode hr_locations.postal_code%TYPE;
259: l_state_code hr_locations.loc_information16%TYPE;
260: l_details VARCHAR2(1000);
261:
262: BEGIN

Line 259: l_state_code hr_locations.loc_information16%TYPE;

255: l_location_city hr_locations.loc_information15%TYPE;
256: l_location_state hr_locations.loc_information16%TYPE;
257: l_location_country hr_locations.country%TYPE;
258: l_location_zipcode hr_locations.postal_code%TYPE;
259: l_state_code hr_locations.loc_information16%TYPE;
260: l_details VARCHAR2(1000);
261:
262: BEGIN
263: g_debug := hr_utility.debug_enabled;

Line 367: l_location_address1 hr_locations.address_line_1%TYPE;

363: FROM per_addresses pad
364: WHERE pad.address_id = p_address_id;
365:
366: l_procedure VARCHAR2(100);
367: l_location_address1 hr_locations.address_line_1%TYPE;
368: l_location_address2 hr_locations.address_line_2%TYPE;
369: l_location_address3 hr_locations.address_line_3%TYPE;
370: l_location_address4 hr_locations.loc_information14%TYPE;
371: l_location_city hr_locations.loc_information15%TYPE;

Line 368: l_location_address2 hr_locations.address_line_2%TYPE;

364: WHERE pad.address_id = p_address_id;
365:
366: l_procedure VARCHAR2(100);
367: l_location_address1 hr_locations.address_line_1%TYPE;
368: l_location_address2 hr_locations.address_line_2%TYPE;
369: l_location_address3 hr_locations.address_line_3%TYPE;
370: l_location_address4 hr_locations.loc_information14%TYPE;
371: l_location_city hr_locations.loc_information15%TYPE;
372: l_location_state hr_locations.loc_information16%TYPE;

Line 369: l_location_address3 hr_locations.address_line_3%TYPE;

365:
366: l_procedure VARCHAR2(100);
367: l_location_address1 hr_locations.address_line_1%TYPE;
368: l_location_address2 hr_locations.address_line_2%TYPE;
369: l_location_address3 hr_locations.address_line_3%TYPE;
370: l_location_address4 hr_locations.loc_information14%TYPE;
371: l_location_city hr_locations.loc_information15%TYPE;
372: l_location_state hr_locations.loc_information16%TYPE;
373: l_location_country hr_locations.country%TYPE;

Line 370: l_location_address4 hr_locations.loc_information14%TYPE;

366: l_procedure VARCHAR2(100);
367: l_location_address1 hr_locations.address_line_1%TYPE;
368: l_location_address2 hr_locations.address_line_2%TYPE;
369: l_location_address3 hr_locations.address_line_3%TYPE;
370: l_location_address4 hr_locations.loc_information14%TYPE;
371: l_location_city hr_locations.loc_information15%TYPE;
372: l_location_state hr_locations.loc_information16%TYPE;
373: l_location_country hr_locations.country%TYPE;
374: l_location_zipcode hr_locations.postal_code%TYPE;

Line 371: l_location_city hr_locations.loc_information15%TYPE;

367: l_location_address1 hr_locations.address_line_1%TYPE;
368: l_location_address2 hr_locations.address_line_2%TYPE;
369: l_location_address3 hr_locations.address_line_3%TYPE;
370: l_location_address4 hr_locations.loc_information14%TYPE;
371: l_location_city hr_locations.loc_information15%TYPE;
372: l_location_state hr_locations.loc_information16%TYPE;
373: l_location_country hr_locations.country%TYPE;
374: l_location_zipcode hr_locations.postal_code%TYPE;
375: l_details VARCHAR2(1000);

Line 372: l_location_state hr_locations.loc_information16%TYPE;

368: l_location_address2 hr_locations.address_line_2%TYPE;
369: l_location_address3 hr_locations.address_line_3%TYPE;
370: l_location_address4 hr_locations.loc_information14%TYPE;
371: l_location_city hr_locations.loc_information15%TYPE;
372: l_location_state hr_locations.loc_information16%TYPE;
373: l_location_country hr_locations.country%TYPE;
374: l_location_zipcode hr_locations.postal_code%TYPE;
375: l_details VARCHAR2(1000);
376:

Line 373: l_location_country hr_locations.country%TYPE;

369: l_location_address3 hr_locations.address_line_3%TYPE;
370: l_location_address4 hr_locations.loc_information14%TYPE;
371: l_location_city hr_locations.loc_information15%TYPE;
372: l_location_state hr_locations.loc_information16%TYPE;
373: l_location_country hr_locations.country%TYPE;
374: l_location_zipcode hr_locations.postal_code%TYPE;
375: l_details VARCHAR2(1000);
376:
377: BEGIN

Line 374: l_location_zipcode hr_locations.postal_code%TYPE;

370: l_location_address4 hr_locations.loc_information14%TYPE;
371: l_location_city hr_locations.loc_information15%TYPE;
372: l_location_state hr_locations.loc_information16%TYPE;
373: l_location_country hr_locations.country%TYPE;
374: l_location_zipcode hr_locations.postal_code%TYPE;
375: l_details VARCHAR2(1000);
376:
377: BEGIN
378: g_debug := hr_utility.debug_enabled;