APPS.PO_AUTO_HEADER_PROCESS_PVT dependencies on HR_LOCATIONS_ALL

Line 708: x_location_code hr_locations_all.location_code%TYPE;

704: */
705: x_emp_id NUMBER;
706: x_emp_name per_employees_current_x.full_name%TYPE;
707: x_location_id NUMBER;
708: x_location_code hr_locations_all.location_code%TYPE;
709: x_is_buyer BOOLEAN := FALSE;
710: x_emp_flag BOOLEAN := FALSE;
711: x_fnd_user BOOLEAN := FALSE;
712: /* bug 12987412*/

Line 1015: from hr_locations_all

1011: 2. validate ship to location and bill to location
1012: ARGS: IN OUT : x_headers PO_AUTOCREATE_TYPES.headers_rec_type -Record variable to hold the header info
1013: NOTE: Use the following check to validate ship_to and bill_to locations:
1014: select 'Y' into x_is_valid
1015: from hr_locations_all
1016: where location_id = x_valid_ship_to/ x_valid_bill_to
1017: and NVL(ship_to_site_flag, 'N') = 'Y'
1018: and NVL(trunc(inactive_date),trunc(SYSDATE)+1) > trunc(SYSDATE);
1019: ==============================================================================*/

Line 1048: FROM hr_locations_all

1044: l_progress:= '010';
1045: BEGIN
1046: SELECT 'Y'
1047: INTO x_is_valid
1048: FROM hr_locations_all
1049: WHERE location_id = x_valid_ship_to
1050: AND NVL(ship_to_site_flag, 'N') = 'Y'
1051: AND NVL(TRUNC(inactive_date),TRUNC(SYSDATE)+1) > TRUNC(SYSDATE);
1052: EXCEPTION

Line 1074: FROM hr_locations_all

1070: l_progress:= '020';
1071: BEGIN
1072: SELECT 'Y'
1073: INTO x_is_valid
1074: FROM hr_locations_all
1075: WHERE location_id = x_valid_bill_to
1076: AND NVL(bill_to_site_flag, 'N') = 'Y' --bug 4229954
1077: AND NVL(TRUNC(inactive_date),TRUNC(SYSDATE)+1) > TRUNC(SYSDATE);
1078: EXCEPTION