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 301: -- v_location hr_locations_all.location_id%TYPE;

297: FROM ap_invoices
298: WHERE invoice_id = P_Invoice_ID;
299:
300: find_type boolean;
301: -- v_location hr_locations_all.location_id%TYPE;
302: l_legal_entity_id xle_entity_profiles.legal_entity_id%TYPE;
303:
304: BEGIN
305: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 438: (p_ship_to_location_id hr_locations_all.location_id%TYPE

434: The Procedure Province_zone_city is used to select region_1,region_2,town_or_city from
435: hr_locations for a ship_to_location_id.
436: -------------------------------------------------------------------*/
437: PROCEDURE Province_Zone_City
438: (p_ship_to_location_id hr_locations_all.location_id%TYPE
439: ,v_hr_zone out NOCOPY hr_locations_all.region_1%TYPE
440: ,v_hr_province out NOCOPY hr_locations_all.region_2%TYPE
441: ,v_city_code out NOCOPY hr_locations_all.town_or_city%TYPE) is
442:

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

435: hr_locations for a ship_to_location_id.
436: -------------------------------------------------------------------*/
437: PROCEDURE Province_Zone_City
438: (p_ship_to_location_id hr_locations_all.location_id%TYPE
439: ,v_hr_zone out NOCOPY hr_locations_all.region_1%TYPE
440: ,v_hr_province out NOCOPY hr_locations_all.region_2%TYPE
441: ,v_city_code out NOCOPY hr_locations_all.town_or_city%TYPE) is
442:
443: CURSOR cur_province_zone_city IS

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

436: -------------------------------------------------------------------*/
437: PROCEDURE Province_Zone_City
438: (p_ship_to_location_id hr_locations_all.location_id%TYPE
439: ,v_hr_zone out NOCOPY hr_locations_all.region_1%TYPE
440: ,v_hr_province out NOCOPY hr_locations_all.region_2%TYPE
441: ,v_city_code out NOCOPY hr_locations_all.town_or_city%TYPE) is
442:
443: CURSOR cur_province_zone_city IS
444: SELECT region_1, region_2, town_or_city

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

437: PROCEDURE Province_Zone_City
438: (p_ship_to_location_id hr_locations_all.location_id%TYPE
439: ,v_hr_zone out NOCOPY hr_locations_all.region_1%TYPE
440: ,v_hr_province out NOCOPY hr_locations_all.region_2%TYPE
441: ,v_city_code out NOCOPY hr_locations_all.town_or_city%TYPE) is
442:
443: CURSOR cur_province_zone_city IS
444: SELECT region_1, region_2, town_or_city
445: FROM hr_locations_all

Line 445: FROM hr_locations_all

441: ,v_city_code out NOCOPY hr_locations_all.town_or_city%TYPE) is
442:
443: CURSOR cur_province_zone_city IS
444: SELECT region_1, region_2, town_or_city
445: FROM hr_locations_all
446: WHERE location_id = p_ship_to_location_id;
447: BEGIN
448: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
449: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Province_Zone_City','Start PROCEDURE Province_Zone_City');

Line 560: v_hr_zone hr_locations_all.region_1%TYPE;

556: ;
557:
558: v_provincial_code jl_ar_ap_provinces.province_code%TYPE;
559:
560: v_hr_zone hr_locations_all.region_1%TYPE;
561: v_hr_province hr_locations_all.region_2%TYPE;
562: v_hr_city hr_locations_all.town_or_city%TYPE;
563: v_hr_city_name hz_geographies.geography_name%TYPE; --Added Bug 6147511
564: pc_vendor_id number;

Line 561: v_hr_province hr_locations_all.region_2%TYPE;

557:
558: v_provincial_code jl_ar_ap_provinces.province_code%TYPE;
559:
560: v_hr_zone hr_locations_all.region_1%TYPE;
561: v_hr_province hr_locations_all.region_2%TYPE;
562: v_hr_city hr_locations_all.town_or_city%TYPE;
563: v_hr_city_name hz_geographies.geography_name%TYPE; --Added Bug 6147511
564: pc_vendor_id number;
565: p_calling_sequence varchar2(2000):= 'Supp_Wh_Def_Line';

Line 562: v_hr_city hr_locations_all.town_or_city%TYPE;

558: v_provincial_code jl_ar_ap_provinces.province_code%TYPE;
559:
560: v_hr_zone hr_locations_all.region_1%TYPE;
561: v_hr_province hr_locations_all.region_2%TYPE;
562: v_hr_city hr_locations_all.town_or_city%TYPE;
563: v_hr_city_name hz_geographies.geography_name%TYPE; --Added Bug 6147511
564: pc_vendor_id number;
565: p_calling_sequence varchar2(2000):= 'Supp_Wh_Def_Line';
566: