DBA Data[Home] [Help]

APPS.PO_HEADERS_SV6 dependencies on PO_LOOKUP_CODES

Line 327: FROM po_lookup_codes

323: x_progress := '010';
324: /* check to see if the given lookup_code and type is valid */
325: SELECT count(*)
326: INTO x_temp
327: FROM po_lookup_codes
328: WHERE lookup_type = X_lookup_type
329: AND sysdate < nvl(inactive_date, sysdate+1)
330: AND lookup_code = X_lookup_code;
331:

Line 472: l_res_shipping_control PO_LOOKUP_CODES.lookup_code%TYPE := NULL; --

468: x_res_terms number := null;
469: X_interface_line_id number := null;
470: X_error_code varchar2(30) := null;
471: X_temp_count binary_integer;
472: l_res_shipping_control PO_LOOKUP_CODES.lookup_code%TYPE := NULL; --
473:
474: BEGIN
475: X_progress := '010';
476: