APPS.RCV_TRANSACTION_SV dependencies on HR_LOCATIONS

Line 164: x_location_code hr_locations_all.location_code%TYPE;

160:
161: /** PO UTF8 Column Expansion Project 9/23/2002 tpoon **/
162: /** Changed x_location_code to use %TYPE **/
163: -- x_location_code VARCHAR2(30);
164: x_location_code hr_locations_all.location_code%TYPE;
165:
166: /* bug2199615 */
167: x_oe_line_id NUMBER;
168: BEGIN

Line 189: FROM hr_locations

185: WHERE location_id = x_location_id;
186: ELSE /* not a drop ship */
187: SELECT location_code
188: INTO x_location_code
189: FROM hr_locations
190: WHERE location_id = x_location_id;
191: END IF;
192:
193: RETURN (x_location_code);

Line 202: from hr_locations

198: BEGIN
199: if (x_oe_line_id IS NOT NULL) THEN
200: select location_code
201: into x_location_code
202: from hr_locations
203: where location_id = x_location_id;
204: RETURN(x_location_code);
205: end if;
206: END;

Line 350: from hr_locations

346: begin
347: if x_deliver_to_location_id is not null then--Bug#6497729
348: select 'Check to see if deliver_to_location_id is valid'
349: INTO x_del_loc_val
350: from hr_locations
351: WHERE nvl(inventory_organization_id,x_org_id) = x_org_id
352: AND (inactive_date IS NULL
353: OR
354: inactive_date > x_date)

Line 385: from hr_locations

381: begin
382: if x_location_id is not null then--Bug#6497729
383: select 'Check to see if location_id is valid'
384: into x_loc_val
385: from hr_locations
386: WHERE nvl(inventory_organization_id,x_org_id) = x_org_id
387: AND receiving_site_flag = 'Y'
388: AND (inactive_date IS NULL
389: OR