APPS.PO_COPYDOC_S4 dependencies on PO_LINE_LOCATIONS

Line 26: x_po_shipment_record IN OUT NOCOPY PO_LINE_LOCATIONS%ROWTYPE,

22: p_copy_price IN BOOLEAN,
23: p_online_report_id IN NUMBER,
24: p_line_num IN NUMBER,
25: p_item_id IN NUMBER, -- Bug 3433867
26: x_po_shipment_record IN OUT NOCOPY PO_LINE_LOCATIONS%ROWTYPE,
27: x_sequence IN OUT NOCOPY NUMBER,
28: x_return_code OUT NOCOPY NUMBER,
29: p_is_complex_work_po IN BOOLEAN --
30: ) IS

Line 36: l_orig_po_header_id po_line_locations.po_header_id%TYPE := NULL;

32: COPYDOC_SHIPMENT_FAILURE EXCEPTION;
33: l_progress VARCHAR2(4) := NULL;
34: l_internal_return_code NUMBER := NULL;
35: l_quotation_class_code VARCHAR2(10) := NULL;
36: l_orig_po_header_id po_line_locations.po_header_id%TYPE := NULL;
37: l_orig_po_line_id po_line_locations.po_line_id%TYPE := NULL;
38: l_vendor_id NUMBER := NULL;
39: l_vendor_site_id NUMBER := NULL;
40: l_invoice_match_option VARCHAR2(25) := NULL;

Line 37: l_orig_po_line_id po_line_locations.po_line_id%TYPE := NULL;

33: l_progress VARCHAR2(4) := NULL;
34: l_internal_return_code NUMBER := NULL;
35: l_quotation_class_code VARCHAR2(10) := NULL;
36: l_orig_po_header_id po_line_locations.po_header_id%TYPE := NULL;
37: l_orig_po_line_id po_line_locations.po_line_id%TYPE := NULL;
38: l_vendor_id NUMBER := NULL;
39: l_vendor_site_id NUMBER := NULL;
40: l_invoice_match_option VARCHAR2(25) := NULL;
41: l_price_from_line po_lines.unit_price%TYPE := NULL;

Line 67: PO_LINE_LOCATIONS_ALL.transaction_flow_header_id%TYPE;

63: l_item_id po_lines.item_id%TYPE := null;
64:
65: --< Shared Proc FPJ Start >
66: l_transaction_flow_header_id
67: PO_LINE_LOCATIONS_ALL.transaction_flow_header_id%TYPE;
68: l_is_valid BOOLEAN;
69: l_in_current_sob BOOLEAN;
70: l_check_txn_flow BOOLEAN;
71: l_return_status VARCHAR2(1);

Line 115: -- bug877084: don't need to override in po_line_locations

111: ' online_report ID: '||p_online_report_id);
112: END IF;
113:
114: /* store original document info into the "FROM" fields of current doc */
115: -- bug877084: don't need to override in po_line_locations
116:
117: SELECT po_header_id, po_line_id
118: INTO l_orig_po_header_id, l_orig_po_line_id
119: FROM po_line_locations

Line 119: FROM po_line_locations

115: -- bug877084: don't need to override in po_line_locations
116:
117: SELECT po_header_id, po_line_id
118: INTO l_orig_po_header_id, l_orig_po_line_id
119: FROM po_line_locations
120: WHERE line_location_id = p_orig_line_location_id;
121:
122: -- Bug 2761415 START
123: -- Moved bug fix 2473335 here, since invoice/receipt close tolerance

Line 545: SELECT po_line_locations_s.nextval

541: --< Shared Proc FPJ End >
542:
543: l_progress := '019';
544: BEGIN
545: SELECT po_line_locations_s.nextval
546: INTO x_po_shipment_record.line_location_id
547: FROM SYS.DUAL;
548: EXCEPTION
549: WHEN OTHERS THEN