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.PA_LOCATION_UTILS dependencies on PA_LOCATIONS

Line 373: FROM pa_locations l,

369: INTO x_country_code,
370: x_country_name,
371: x_city,
372: x_region
373: FROM pa_locations l,
374: fnd_territories_vl t
375: WHERE t.territory_code = l.country_code
376: AND l.location_id = p_location_id ;
377:

Line 429: FROM pa_locations l

425: BEGIN
426:
427: SELECT l.location_id
428: INTO x_location_id
429: FROM pa_locations l
430: WHERE ( ( l.city = p_city)
431: OR (l.city IS NULL AND p_city IS NULL))
432: AND ( (l.region = p_region)
433: OR (l.region IS NULL AND p_region IS NULL))

Line 508: PA_LOCATIONS_PKG.INSERT_ROW (

504: , x_return_status => l_return_status );
505:
506: IF l_location_id IS NULL THEN
507:
508: PA_LOCATIONS_PKG.INSERT_ROW (
509: p_CITY => p_city
510: , p_REGION => p_region
511: , p_COUNTRY_CODE => p_country_code
512: , p_CREATION_DATE => sysdate

Line 564: FROM pa_locations l,

560: SELECT l.country_code,
561: t.territory_short_name
562: INTO x_country_code,
563: x_country_name
564: FROM pa_locations l,
565: fnd_territories_vl t
566: WHERE t.territory_code = l.country_code
567: AND l.location_id = p_location_id;
568: