APPS.PO_DOCUMENT_CONTROL_GRP dependencies on PO_LINES

Line 48: p_cancel_reason IN PO_LINES.cancel_reason%TYPE,

44: p_doc_shipment_num IN NUMBER,
45: p_source IN VARCHAR2,
46: p_action IN VARCHAR2,
47: p_action_date IN DATE,
48: p_cancel_reason IN PO_LINES.cancel_reason%TYPE,
49: p_cancel_reqs_flag IN VARCHAR2,
50: p_print_flag IN VARCHAR2,
51: p_note_to_vendor IN PO_HEADERS.note_to_vendor%TYPE,
52: p_use_gldate IN VARCHAR2 --

Line 611: FROM po_lines pol

607:
608: IF (p_doc_line_id IS NULL) THEN
609: SELECT pol.po_line_id
610: INTO x_doc_line_id
611: FROM po_lines pol
612: WHERE pol.po_header_id = x_doc_id AND
613: pol.line_num = p_doc_line_num;
614: ELSE
615: SELECT 'Exists'

Line 617: FROM po_lines pol

613: pol.line_num = p_doc_line_num;
614: ELSE
615: SELECT 'Exists'
616: INTO l_exists
617: FROM po_lines pol
618: WHERE pol.po_line_id = x_doc_line_id AND
619: pol.po_header_id = x_doc_id;
620: END IF; --
621:

Line 833: po_lines pol

829: -- SQL Join: po_line_id
830: SELECT poll.line_location_id
831: INTO x_doc_line_loc_id
832: FROM po_line_locations poll,
833: po_lines pol
834: WHERE poll.po_release_id = x_doc_id AND
835: poll.po_header_id = l_release_po_header_id AND
836: poll.po_line_id = pol.po_line_id AND
837: poll.shipment_num = p_doc_shipment_num AND