APPS.RCV_TRANSACTION_SV dependencies on HR_LOCATIONS

Line 176: x_location_code hr_locations_all.location_code%TYPE;

172:
173: /** PO UTF8 Column Expansion Project 9/23/2002 tpoon **/
174: /** Changed x_location_code to use %TYPE **/
175: -- x_location_code VARCHAR2(30);
176: x_location_code hr_locations_all.location_code%TYPE;
177:
178: /* bug2199615 */
179: x_oe_line_id NUMBER;
180: BEGIN

Line 201: FROM hr_locations

197: WHERE location_id = x_location_id;
198: ELSE /* not a drop ship */
199: SELECT location_code
200: INTO x_location_code
201: FROM hr_locations
202: WHERE location_id = x_location_id;
203: END IF;
204:
205: RETURN (x_location_code);

Line 214: from hr_locations

210: BEGIN
211: if (x_oe_line_id IS NOT NULL) THEN
212: select location_code
213: into x_location_code
214: from hr_locations
215: where location_id = x_location_id;
216: RETURN(x_location_code);
217: end if;
218: END;

Line 373: from hr_locations

369: begin
370: if x_deliver_to_location_id is not null then--Bug#6497729
371: select 'Check to see if deliver_to_location_id is valid'
372: INTO x_del_loc_val
373: from hr_locations
374: WHERE nvl(inventory_organization_id,x_org_id) = x_org_id
375: AND (inactive_date IS NULL
376: OR
377: inactive_date > x_date)

Line 408: from hr_locations

404: begin
405: if x_location_id is not null then--Bug#6497729
406: select 'Check to see if location_id is valid'
407: into x_loc_val
408: from hr_locations
409: WHERE nvl(inventory_organization_id,x_org_id) = x_org_id
410: AND receiving_site_flag = 'Y'
411: AND (inactive_date IS NULL
412: OR