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.JL_ZZ_AP_AWT_DEFAULT_PKG dependencies on HR_LOCATIONS_ALL

Line 304: -- v_location hr_locations_all.location_id%TYPE;

300: l_legal_entity_id xle_entity_profiles.legal_entity_id%TYPE;
301: */
302:
303: find_type boolean;
304: -- v_location hr_locations_all.location_id%TYPE;
305: V_FND_TYPE VARCHAR2(10); --bug 16010780
306:
307: BEGIN
308: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 465: (p_ship_to_location_id hr_locations_all.location_id%TYPE

461: The Procedure Province_zone_city is used to select region_1,region_2,town_or_city from
462: hr_locations for a ship_to_location_id.
463: -------------------------------------------------------------------*/
464: PROCEDURE Province_Zone_City
465: (p_ship_to_location_id hr_locations_all.location_id%TYPE
466: ,v_hr_zone out NOCOPY hr_locations_all.region_1%TYPE
467: ,v_hr_province out NOCOPY hr_locations_all.region_2%TYPE
468: ,v_city_code out NOCOPY hr_locations_all.town_or_city%TYPE) is
469:

Line 466: ,v_hr_zone out NOCOPY hr_locations_all.region_1%TYPE

462: hr_locations for a ship_to_location_id.
463: -------------------------------------------------------------------*/
464: PROCEDURE Province_Zone_City
465: (p_ship_to_location_id hr_locations_all.location_id%TYPE
466: ,v_hr_zone out NOCOPY hr_locations_all.region_1%TYPE
467: ,v_hr_province out NOCOPY hr_locations_all.region_2%TYPE
468: ,v_city_code out NOCOPY hr_locations_all.town_or_city%TYPE) is
469:
470: CURSOR cur_province_zone_city IS

Line 467: ,v_hr_province out NOCOPY hr_locations_all.region_2%TYPE

463: -------------------------------------------------------------------*/
464: PROCEDURE Province_Zone_City
465: (p_ship_to_location_id hr_locations_all.location_id%TYPE
466: ,v_hr_zone out NOCOPY hr_locations_all.region_1%TYPE
467: ,v_hr_province out NOCOPY hr_locations_all.region_2%TYPE
468: ,v_city_code out NOCOPY hr_locations_all.town_or_city%TYPE) is
469:
470: CURSOR cur_province_zone_city IS
471: SELECT region_1, region_2, town_or_city

Line 468: ,v_city_code out NOCOPY hr_locations_all.town_or_city%TYPE) is

464: PROCEDURE Province_Zone_City
465: (p_ship_to_location_id hr_locations_all.location_id%TYPE
466: ,v_hr_zone out NOCOPY hr_locations_all.region_1%TYPE
467: ,v_hr_province out NOCOPY hr_locations_all.region_2%TYPE
468: ,v_city_code out NOCOPY hr_locations_all.town_or_city%TYPE) is
469:
470: CURSOR cur_province_zone_city IS
471: SELECT region_1, region_2, town_or_city
472: FROM hr_locations_all

Line 472: FROM hr_locations_all

468: ,v_city_code out NOCOPY hr_locations_all.town_or_city%TYPE) is
469:
470: CURSOR cur_province_zone_city IS
471: SELECT region_1, region_2, town_or_city
472: FROM hr_locations_all
473: WHERE location_id = p_ship_to_location_id;
474: BEGIN
475: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
476: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Province_Zone_City','Start PROCEDURE Province_Zone_City');

Line 592: v_hr_zone hr_locations_all.region_1%TYPE;

588:
589:
590: v_provincial_code jl_ar_ap_provinces.province_code%TYPE;
591:
592: v_hr_zone hr_locations_all.region_1%TYPE;
593: v_hr_province hr_locations_all.region_2%TYPE;
594: v_hr_city hr_locations_all.town_or_city%TYPE;
595: -- v_hr_city_name hz_geographies.geography_name%TYPE; --Added Bug 6147511
596: v_hr_city_code hz_geographies.geography_code%TYPE; --Added Bug 11724717

Line 593: v_hr_province hr_locations_all.region_2%TYPE;

589:
590: v_provincial_code jl_ar_ap_provinces.province_code%TYPE;
591:
592: v_hr_zone hr_locations_all.region_1%TYPE;
593: v_hr_province hr_locations_all.region_2%TYPE;
594: v_hr_city hr_locations_all.town_or_city%TYPE;
595: -- v_hr_city_name hz_geographies.geography_name%TYPE; --Added Bug 6147511
596: v_hr_city_code hz_geographies.geography_code%TYPE; --Added Bug 11724717
597: pc_vendor_id number;

Line 594: v_hr_city hr_locations_all.town_or_city%TYPE;

590: v_provincial_code jl_ar_ap_provinces.province_code%TYPE;
591:
592: v_hr_zone hr_locations_all.region_1%TYPE;
593: v_hr_province hr_locations_all.region_2%TYPE;
594: v_hr_city hr_locations_all.town_or_city%TYPE;
595: -- v_hr_city_name hz_geographies.geography_name%TYPE; --Added Bug 6147511
596: v_hr_city_code hz_geographies.geography_code%TYPE; --Added Bug 11724717
597: pc_vendor_id number;
598: p_calling_sequence varchar2(2000):= 'Supp_Wh_Def_Line';