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

Line 498: l_loc_id hr_locations.location_id%TYPE;

494: ------------------------------------------------------------------------------------*/
495:
496: FUNCTION get_location(p_assignment_id in per_assignments_f.assignment_id%TYPE)
497: RETURN VARCHAR2 IS
498: l_loc_id hr_locations.location_id%TYPE;
499: l_add_1 varchar2(240); --hr_locations.address_line_1%TYPE;
500: l_add_2 varchar2(240); --hr_locations.address_line_2%TYPE;
501: l_add_3 varchar2(240); --hr_locations.address_line_3%TYPE;
502: l_town hr_locations.town_or_city%TYPE;

Line 499: l_add_1 varchar2(240); --hr_locations.address_line_1%TYPE;

495:
496: FUNCTION get_location(p_assignment_id in per_assignments_f.assignment_id%TYPE)
497: RETURN VARCHAR2 IS
498: l_loc_id hr_locations.location_id%TYPE;
499: l_add_1 varchar2(240); --hr_locations.address_line_1%TYPE;
500: l_add_2 varchar2(240); --hr_locations.address_line_2%TYPE;
501: l_add_3 varchar2(240); --hr_locations.address_line_3%TYPE;
502: l_town hr_locations.town_or_city%TYPE;
503: l_country hr_locations.country%TYPE;

Line 500: l_add_2 varchar2(240); --hr_locations.address_line_2%TYPE;

496: FUNCTION get_location(p_assignment_id in per_assignments_f.assignment_id%TYPE)
497: RETURN VARCHAR2 IS
498: l_loc_id hr_locations.location_id%TYPE;
499: l_add_1 varchar2(240); --hr_locations.address_line_1%TYPE;
500: l_add_2 varchar2(240); --hr_locations.address_line_2%TYPE;
501: l_add_3 varchar2(240); --hr_locations.address_line_3%TYPE;
502: l_town hr_locations.town_or_city%TYPE;
503: l_country hr_locations.country%TYPE;
504: l_post hr_locations.postal_code%TYPE;

Line 501: l_add_3 varchar2(240); --hr_locations.address_line_3%TYPE;

497: RETURN VARCHAR2 IS
498: l_loc_id hr_locations.location_id%TYPE;
499: l_add_1 varchar2(240); --hr_locations.address_line_1%TYPE;
500: l_add_2 varchar2(240); --hr_locations.address_line_2%TYPE;
501: l_add_3 varchar2(240); --hr_locations.address_line_3%TYPE;
502: l_town hr_locations.town_or_city%TYPE;
503: l_country hr_locations.country%TYPE;
504: l_post hr_locations.postal_code%TYPE;
505: l_loc varchar2(861);

Line 502: l_town hr_locations.town_or_city%TYPE;

498: l_loc_id hr_locations.location_id%TYPE;
499: l_add_1 varchar2(240); --hr_locations.address_line_1%TYPE;
500: l_add_2 varchar2(240); --hr_locations.address_line_2%TYPE;
501: l_add_3 varchar2(240); --hr_locations.address_line_3%TYPE;
502: l_town hr_locations.town_or_city%TYPE;
503: l_country hr_locations.country%TYPE;
504: l_post hr_locations.postal_code%TYPE;
505: l_loc varchar2(861);
506: l_org_id hr_organization_units.organization_id%type;

Line 503: l_country hr_locations.country%TYPE;

499: l_add_1 varchar2(240); --hr_locations.address_line_1%TYPE;
500: l_add_2 varchar2(240); --hr_locations.address_line_2%TYPE;
501: l_add_3 varchar2(240); --hr_locations.address_line_3%TYPE;
502: l_town hr_locations.town_or_city%TYPE;
503: l_country hr_locations.country%TYPE;
504: l_post hr_locations.postal_code%TYPE;
505: l_loc varchar2(861);
506: l_org_id hr_organization_units.organization_id%type;
507: l_sqlcode number;

Line 504: l_post hr_locations.postal_code%TYPE;

500: l_add_2 varchar2(240); --hr_locations.address_line_2%TYPE;
501: l_add_3 varchar2(240); --hr_locations.address_line_3%TYPE;
502: l_town hr_locations.town_or_city%TYPE;
503: l_country hr_locations.country%TYPE;
504: l_post hr_locations.postal_code%TYPE;
505: l_loc varchar2(861);
506: l_org_id hr_organization_units.organization_id%type;
507: l_sqlcode number;
508: l_mssg varchar2(100);

Line 520: FROM hr_locations LOC WHERE LOC.location_id =

516: rpad(nvl(LOC.country, 'XXXXXX'), 60, ' ') country,
517: rpad(nvl(LOC.postal_code, 'XXXXXX'), 30, ' ') postal_code
518: -- INTO l_loc_id, l_add_1, l_add_2, l_add_3, l_town , l_country, l_post
519: -- INTO location_table
520: FROM hr_locations LOC WHERE LOC.location_id =
521: (select ORG.location_id
522: FROM hr_organization_units ORG WHERE ORG.organization_id = c_org_id);
523:
524: