DBA Data[Home] [Help]

APPS.PO_LINE_LOCATIONS_SV7 dependencies on PO_HEADERS

Line 573: from po_headers poh,

569: /* Get the header and line values from the database */
570: BEGIN
571: select poh.start_date, poh.end_date, pol.expiration_date
572: into l_header_start_date, l_header_end_date, l_exp_date
573: from po_headers poh,
574: po_lines pol
575: where poh.po_header_id = x_po_header_id
576: and pol.po_line_id = x_po_line_id;
577: EXCEPTION

Line 944: x_valid :=po_headers_sv6.val_lookup_code(

940: END IF;
941:
942: IF (x_qty_rcv_exception_code is not null) THEN
943: x_progress := '220';
944: x_valid :=po_headers_sv6.val_lookup_code(
945: x_qty_rcv_exception_code,
946: 'RECEIVING CONTROL LEVEL');
947: IF (x_valid = FALSE) THEN
948: po_interface_errors_sv1.handle_interface_errors(