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 265: p_cancel_reason IN PO_LINES.cancel_reason%TYPE,

261: p_doc_shipment_num IN NUMBER,
262: p_source IN VARCHAR2,
263: p_action IN VARCHAR2,
264: p_action_date IN DATE,
265: p_cancel_reason IN PO_LINES.cancel_reason%TYPE,
266: p_cancel_reqs_flag IN VARCHAR2,
267: p_print_flag IN VARCHAR2,
268: p_note_to_vendor IN PO_HEADERS.note_to_vendor%TYPE,
269: p_use_gldate IN VARCHAR2,

Line 1008: FROM po_lines pol

1004:
1005: IF (p_doc_line_id IS NULL) THEN
1006: SELECT pol.po_line_id
1007: INTO x_doc_line_id
1008: FROM po_lines pol
1009: WHERE pol.po_header_id = x_doc_id AND
1010: pol.line_num = p_doc_line_num;
1011: ELSE
1012: SELECT 'Exists'

Line 1014: FROM po_lines pol

1010: pol.line_num = p_doc_line_num;
1011: ELSE
1012: SELECT 'Exists'
1013: INTO l_exists
1014: FROM po_lines pol
1015: WHERE pol.po_line_id = x_doc_line_id AND
1016: pol.po_header_id = x_doc_id;
1017: END IF; --
1018:

Line 1230: po_lines pol

1226: -- SQL Join: po_line_id
1227: SELECT poll.line_location_id
1228: INTO x_doc_line_loc_id
1229: FROM po_line_locations poll,
1230: po_lines pol
1231: WHERE poll.po_release_id = x_doc_id AND
1232: poll.po_header_id = l_release_po_header_id AND
1233: poll.po_line_id = pol.po_line_id AND
1234: poll.shipment_num = p_doc_shipment_num AND