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.

[Home] [Help]

APPS.PAY_IN_EOY_REPORTS dependencies on HR_LOCATIONS

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

226: -- Access : Private --
227: -- Description : This procedure gets the gre location details --
228: -- --
229: -- Parameters : --
230: -- IN : p_location_id hr_locations.location_id --
231: -- : p_concatenate VARCHAR2 --
232: -- p_field VARCHAR2 --
233: --------------------------------------------------------------------------
234: FUNCTION get_location_details ( p_location_id IN hr_locations.location_id%TYPE

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

230: -- IN : p_location_id hr_locations.location_id --
231: -- : p_concatenate VARCHAR2 --
232: -- p_field VARCHAR2 --
233: --------------------------------------------------------------------------
234: FUNCTION get_location_details ( p_location_id IN hr_locations.location_id%TYPE
235: , p_concatenate IN VARCHAR2 DEFAULT 'N'
236: , p_field IN VARCHAR2 DEFAULT NULL
237: )
238: RETURN VARCHAR2

Line 252: FROM hr_locations hr_loc

248: , hr_general.decode_lookup('IN_STATES',hr_loc.loc_information16)
249: , hr_general.decode_lookup('PER_US_COUNTRY_CODE',hr_loc.country)
250: , hr_loc.postal_code
251: , hr_loc.loc_information16
252: FROM hr_locations hr_loc
253: WHERE location_id = p_location_id;
254:
255: l_procedure VARCHAR2(100);
256: l_location_address1 hr_locations.address_line_1%TYPE;

Line 256: l_location_address1 hr_locations.address_line_1%TYPE;

252: FROM hr_locations hr_loc
253: WHERE location_id = p_location_id;
254:
255: l_procedure VARCHAR2(100);
256: l_location_address1 hr_locations.address_line_1%TYPE;
257: l_location_address2 hr_locations.address_line_2%TYPE;
258: l_location_address3 hr_locations.address_line_3%TYPE;
259: l_location_address4 hr_locations.loc_information14%TYPE;
260: l_location_city hr_locations.loc_information15%TYPE;

Line 257: l_location_address2 hr_locations.address_line_2%TYPE;

253: WHERE location_id = p_location_id;
254:
255: l_procedure VARCHAR2(100);
256: l_location_address1 hr_locations.address_line_1%TYPE;
257: l_location_address2 hr_locations.address_line_2%TYPE;
258: l_location_address3 hr_locations.address_line_3%TYPE;
259: l_location_address4 hr_locations.loc_information14%TYPE;
260: l_location_city hr_locations.loc_information15%TYPE;
261: l_location_state hr_locations.loc_information16%TYPE;

Line 258: l_location_address3 hr_locations.address_line_3%TYPE;

254:
255: l_procedure VARCHAR2(100);
256: l_location_address1 hr_locations.address_line_1%TYPE;
257: l_location_address2 hr_locations.address_line_2%TYPE;
258: l_location_address3 hr_locations.address_line_3%TYPE;
259: l_location_address4 hr_locations.loc_information14%TYPE;
260: l_location_city hr_locations.loc_information15%TYPE;
261: l_location_state hr_locations.loc_information16%TYPE;
262: l_location_country hr_locations.country%TYPE;

Line 259: l_location_address4 hr_locations.loc_information14%TYPE;

255: l_procedure VARCHAR2(100);
256: l_location_address1 hr_locations.address_line_1%TYPE;
257: l_location_address2 hr_locations.address_line_2%TYPE;
258: l_location_address3 hr_locations.address_line_3%TYPE;
259: l_location_address4 hr_locations.loc_information14%TYPE;
260: l_location_city hr_locations.loc_information15%TYPE;
261: l_location_state hr_locations.loc_information16%TYPE;
262: l_location_country hr_locations.country%TYPE;
263: l_location_zipcode hr_locations.postal_code%TYPE;

Line 260: l_location_city hr_locations.loc_information15%TYPE;

256: l_location_address1 hr_locations.address_line_1%TYPE;
257: l_location_address2 hr_locations.address_line_2%TYPE;
258: l_location_address3 hr_locations.address_line_3%TYPE;
259: l_location_address4 hr_locations.loc_information14%TYPE;
260: l_location_city hr_locations.loc_information15%TYPE;
261: l_location_state hr_locations.loc_information16%TYPE;
262: l_location_country hr_locations.country%TYPE;
263: l_location_zipcode hr_locations.postal_code%TYPE;
264: l_state_code hr_locations.loc_information16%TYPE;

Line 261: l_location_state hr_locations.loc_information16%TYPE;

257: l_location_address2 hr_locations.address_line_2%TYPE;
258: l_location_address3 hr_locations.address_line_3%TYPE;
259: l_location_address4 hr_locations.loc_information14%TYPE;
260: l_location_city hr_locations.loc_information15%TYPE;
261: l_location_state hr_locations.loc_information16%TYPE;
262: l_location_country hr_locations.country%TYPE;
263: l_location_zipcode hr_locations.postal_code%TYPE;
264: l_state_code hr_locations.loc_information16%TYPE;
265: l_details VARCHAR2(1000);

Line 262: l_location_country hr_locations.country%TYPE;

258: l_location_address3 hr_locations.address_line_3%TYPE;
259: l_location_address4 hr_locations.loc_information14%TYPE;
260: l_location_city hr_locations.loc_information15%TYPE;
261: l_location_state hr_locations.loc_information16%TYPE;
262: l_location_country hr_locations.country%TYPE;
263: l_location_zipcode hr_locations.postal_code%TYPE;
264: l_state_code hr_locations.loc_information16%TYPE;
265: l_details VARCHAR2(1000);
266:

Line 263: l_location_zipcode hr_locations.postal_code%TYPE;

259: l_location_address4 hr_locations.loc_information14%TYPE;
260: l_location_city hr_locations.loc_information15%TYPE;
261: l_location_state hr_locations.loc_information16%TYPE;
262: l_location_country hr_locations.country%TYPE;
263: l_location_zipcode hr_locations.postal_code%TYPE;
264: l_state_code hr_locations.loc_information16%TYPE;
265: l_details VARCHAR2(1000);
266:
267: BEGIN

Line 264: l_state_code hr_locations.loc_information16%TYPE;

260: l_location_city hr_locations.loc_information15%TYPE;
261: l_location_state hr_locations.loc_information16%TYPE;
262: l_location_country hr_locations.country%TYPE;
263: l_location_zipcode hr_locations.postal_code%TYPE;
264: l_state_code hr_locations.loc_information16%TYPE;
265: l_details VARCHAR2(1000);
266:
267: BEGIN
268: g_debug := hr_utility.debug_enabled;

Line 372: l_location_address1 hr_locations.address_line_1%TYPE;

368: FROM per_addresses pad
369: WHERE pad.address_id = p_address_id;
370:
371: l_procedure VARCHAR2(100);
372: l_location_address1 hr_locations.address_line_1%TYPE;
373: l_location_address2 hr_locations.address_line_2%TYPE;
374: l_location_address3 hr_locations.address_line_3%TYPE;
375: l_location_address4 hr_locations.loc_information14%TYPE;
376: l_location_city hr_locations.loc_information15%TYPE;

Line 373: l_location_address2 hr_locations.address_line_2%TYPE;

369: WHERE pad.address_id = p_address_id;
370:
371: l_procedure VARCHAR2(100);
372: l_location_address1 hr_locations.address_line_1%TYPE;
373: l_location_address2 hr_locations.address_line_2%TYPE;
374: l_location_address3 hr_locations.address_line_3%TYPE;
375: l_location_address4 hr_locations.loc_information14%TYPE;
376: l_location_city hr_locations.loc_information15%TYPE;
377: l_location_state hr_locations.loc_information16%TYPE;

Line 374: l_location_address3 hr_locations.address_line_3%TYPE;

370:
371: l_procedure VARCHAR2(100);
372: l_location_address1 hr_locations.address_line_1%TYPE;
373: l_location_address2 hr_locations.address_line_2%TYPE;
374: l_location_address3 hr_locations.address_line_3%TYPE;
375: l_location_address4 hr_locations.loc_information14%TYPE;
376: l_location_city hr_locations.loc_information15%TYPE;
377: l_location_state hr_locations.loc_information16%TYPE;
378: l_location_country hr_locations.country%TYPE;

Line 375: l_location_address4 hr_locations.loc_information14%TYPE;

371: l_procedure VARCHAR2(100);
372: l_location_address1 hr_locations.address_line_1%TYPE;
373: l_location_address2 hr_locations.address_line_2%TYPE;
374: l_location_address3 hr_locations.address_line_3%TYPE;
375: l_location_address4 hr_locations.loc_information14%TYPE;
376: l_location_city hr_locations.loc_information15%TYPE;
377: l_location_state hr_locations.loc_information16%TYPE;
378: l_location_country hr_locations.country%TYPE;
379: l_location_zipcode hr_locations.postal_code%TYPE;

Line 376: l_location_city hr_locations.loc_information15%TYPE;

372: l_location_address1 hr_locations.address_line_1%TYPE;
373: l_location_address2 hr_locations.address_line_2%TYPE;
374: l_location_address3 hr_locations.address_line_3%TYPE;
375: l_location_address4 hr_locations.loc_information14%TYPE;
376: l_location_city hr_locations.loc_information15%TYPE;
377: l_location_state hr_locations.loc_information16%TYPE;
378: l_location_country hr_locations.country%TYPE;
379: l_location_zipcode hr_locations.postal_code%TYPE;
380: l_details VARCHAR2(1000);

Line 377: l_location_state hr_locations.loc_information16%TYPE;

373: l_location_address2 hr_locations.address_line_2%TYPE;
374: l_location_address3 hr_locations.address_line_3%TYPE;
375: l_location_address4 hr_locations.loc_information14%TYPE;
376: l_location_city hr_locations.loc_information15%TYPE;
377: l_location_state hr_locations.loc_information16%TYPE;
378: l_location_country hr_locations.country%TYPE;
379: l_location_zipcode hr_locations.postal_code%TYPE;
380: l_details VARCHAR2(1000);
381:

Line 378: l_location_country hr_locations.country%TYPE;

374: l_location_address3 hr_locations.address_line_3%TYPE;
375: l_location_address4 hr_locations.loc_information14%TYPE;
376: l_location_city hr_locations.loc_information15%TYPE;
377: l_location_state hr_locations.loc_information16%TYPE;
378: l_location_country hr_locations.country%TYPE;
379: l_location_zipcode hr_locations.postal_code%TYPE;
380: l_details VARCHAR2(1000);
381:
382: BEGIN

Line 379: l_location_zipcode hr_locations.postal_code%TYPE;

375: l_location_address4 hr_locations.loc_information14%TYPE;
376: l_location_city hr_locations.loc_information15%TYPE;
377: l_location_state hr_locations.loc_information16%TYPE;
378: l_location_country hr_locations.country%TYPE;
379: l_location_zipcode hr_locations.postal_code%TYPE;
380: l_details VARCHAR2(1000);
381:
382: BEGIN
383: g_debug := hr_utility.debug_enabled;