APPS.PO_LOCATIONS_S dependencies on HR_LOCATIONS

Line 37: FROM hr_locations_all

33:
34: begin
35: SELECT ship_to_location_id
36: INTO X_ship_to_loc_id
37: FROM hr_locations_all
38: WHERE location_id = X_deliver_to_loc_id;
39:
40: exception
41: --bug 1942696 hr_location changes to reflect the new view

Line 56: FROM hr_locations_all

52:
53: begin
54: SELECT location_id
55: INTO X_location_id_v
56: FROM hr_locations_all
57: WHERE location_id = X_ship_to_loc_id
58: AND sysdate < nvl(inactive_date, sysdate + 1);
59: exception
60: when no_data_found then

Line 112: FROM HR_LOCATIONS_ALL

108:
109: begin
110: SELECT 'location_ok'
111: INTO x_status
112: FROM HR_LOCATIONS_ALL
113: WHERE LOCATION_ID = x_location_id
114: AND NVL(INVENTORY_ORGANIZATION_ID, x_organization_id) = x_organization_id
115: AND NVL(INACTIVE_DATE, SYSDATE+1) > SYSDATE;
116:

Line 163: from hr_locations

159: select location_code,
160: inventory_organization_id
161: into X_loc_dsp,
162: X_org_id
163: from hr_locations
164: where location_id = X_temp_loc_id;
165:
166: exception
167: when no_data_found then

Line 241: FROM hr_locations hrl,

237: x_org_code := NULL;
238:
239: SELECT hrl.inventory_organization_id
240: INTO x_org_id
241: FROM hr_locations hrl,
242: org_organization_definitions ood
243: WHERE ood.organization_id = hrl.inventory_organization_id
244: AND ood.set_of_books_id = x_sob_id
245: AND hrl.location_id = x_location_id;

Line 343: FROM hr_locations hrl

339:
340:
341: SELECT hrl.location_code
342: INTO x_location_code
343: FROM hr_locations hrl
344: WHERE hrl.location_id = x_location_id;
345:
346:
347: exception

Line 378: p_location_id IN HR_LOCATIONS.location_id%TYPE

374: -- EXCEPTIONS : -
375: --=============================================================================
376: FUNCTION get_location_code
377: (
378: p_location_id IN HR_LOCATIONS.location_id%TYPE
379: )
380: RETURN HR_LOCATIONS.location_code%TYPE
381: IS
382: x_location_code HR_LOCATIONS.location_code%TYPE;

Line 380: RETURN HR_LOCATIONS.location_code%TYPE

376: FUNCTION get_location_code
377: (
378: p_location_id IN HR_LOCATIONS.location_id%TYPE
379: )
380: RETURN HR_LOCATIONS.location_code%TYPE
381: IS
382: x_location_code HR_LOCATIONS.location_code%TYPE;
383: BEGIN
384:

Line 382: x_location_code HR_LOCATIONS.location_code%TYPE;

378: p_location_id IN HR_LOCATIONS.location_id%TYPE
379: )
380: RETURN HR_LOCATIONS.location_code%TYPE
381: IS
382: x_location_code HR_LOCATIONS.location_code%TYPE;
383: BEGIN
384:
385: get_location_code( p_location_id, x_location_code );
386:

Line 419: FROM HR_LOCATIONS_ALL

415:
416: begin
417: SELECT 'Y'
418: INTO X_valid_loc
419: FROM HR_LOCATIONS_ALL
420: WHERE LOCATION_ID = x_location_id
421: AND NVL(SHIP_TO_SITE_FLAG,'N') = 'Y'
422: AND NVL(INVENTORY_ORGANIZATION_ID, X_organization_id) = X_organization_id
423: AND NVL(INACTIVE_DATE, SYSDATE+1) > SYSDATE;

Line 476: FROM HR_LOCATIONS_ALL

472:
473: begin
474: SELECT 'Y'
475: INTO X_valid_loc
476: FROM HR_LOCATIONS_ALL
477: WHERE LOCATION_ID = x_location_id
478: AND NVL(RECEIVING_SITE_FLAG,'N') = 'Y'
479: AND NVL(INVENTORY_ORGANIZATION_ID, X_organization_id) = X_organization_id
480: AND NVL(INACTIVE_DATE, SYSDATE+1) > SYSDATE;

Line 528: sql_str := 'SELECT location_code, location_id FROM hr_locations WHERE ';

524: loc_code_null BOOLEAN := TRUE;
525: loc_id_null BOOLEAN := TRUE;
526:
527: BEGIN
528: sql_str := 'SELECT location_code, location_id FROM hr_locations WHERE ';
529:
530: IF p_loc_record.location_code IS NULL and
531: p_loc_record.location_id IS NULL THEN
532: p_loc_record.error_record.error_status := 'W';

Line 690: X_sql_str := 'select inactive_date,receiving_site_flag,inventory_organization_id from hr_locations where ';

686: X_sysdate DATE := sysdate;
687:
688: BEGIN
689:
690: X_sql_str := 'select inactive_date,receiving_site_flag,inventory_organization_id from hr_locations where ';
691:
692: IF p_loc_record.location_code IS NULL and
693: p_loc_record.location_id IS NULL THEN
694: