APPS.PO_DOCUMENT_UPDATE_GRP dependencies on PO_HEADERS

Line 163: from po_headers

159: --
160: CURSOR l_po_header_csr (p_po_number VARCHAR2) IS
161: select po_header_id, revision_num,
162: NVL(authorization_status, 'INCOMPLETE'), type_lookup_code
163: from po_headers
164: where segment1 = p_PO_NUMBER
165: and type_lookup_code IN ('STANDARD', 'BLANKET', 'PLANNED');
166:
167: CURSOR l_po_release_csr (p_po_header_id NUMBER, p_release_number NUMBER) IS

Line 197: l_po_header_id PO_HEADERS.po_header_id%TYPE;

193:
194: l_header_table_name VARCHAR2(30);
195: l_changes PO_CHANGES_REC_TYPE;
196: l_new_shipment_price PO_LINE_LOCATIONS.price_override%TYPE;
197: l_po_header_id PO_HEADERS.po_header_id%TYPE;
198: l_po_release_id PO_RELEASES.po_release_id%TYPE;
199: l_po_line_id PO_LINES.po_line_id%TYPE;
200: l_line_location_id PO_LINE_LOCATIONS.line_location_id%TYPE;
201: l_revision_num PO_HEADERS.revision_num%TYPE;

Line 201: l_revision_num PO_HEADERS.revision_num%TYPE;

197: l_po_header_id PO_HEADERS.po_header_id%TYPE;
198: l_po_release_id PO_RELEASES.po_release_id%TYPE;
199: l_po_line_id PO_LINES.po_line_id%TYPE;
200: l_line_location_id PO_LINE_LOCATIONS.line_location_id%TYPE;
201: l_revision_num PO_HEADERS.revision_num%TYPE;
202: l_authorization_status PO_HEADERS.authorization_status%TYPE;
203: l_document_subtype PO_HEADERS.type_lookup_code%TYPE;
204: l_launch_approvals_flag VARCHAR2(1);
205: l_shipment_count NUMBER;

Line 202: l_authorization_status PO_HEADERS.authorization_status%TYPE;

198: l_po_release_id PO_RELEASES.po_release_id%TYPE;
199: l_po_line_id PO_LINES.po_line_id%TYPE;
200: l_line_location_id PO_LINE_LOCATIONS.line_location_id%TYPE;
201: l_revision_num PO_HEADERS.revision_num%TYPE;
202: l_authorization_status PO_HEADERS.authorization_status%TYPE;
203: l_document_subtype PO_HEADERS.type_lookup_code%TYPE;
204: l_launch_approvals_flag VARCHAR2(1);
205: l_shipment_count NUMBER;
206: l_buyer_id PO_HEADERS.agent_id%TYPE;

Line 203: l_document_subtype PO_HEADERS.type_lookup_code%TYPE;

199: l_po_line_id PO_LINES.po_line_id%TYPE;
200: l_line_location_id PO_LINE_LOCATIONS.line_location_id%TYPE;
201: l_revision_num PO_HEADERS.revision_num%TYPE;
202: l_authorization_status PO_HEADERS.authorization_status%TYPE;
203: l_document_subtype PO_HEADERS.type_lookup_code%TYPE;
204: l_launch_approvals_flag VARCHAR2(1);
205: l_shipment_count NUMBER;
206: l_buyer_id PO_HEADERS.agent_id%TYPE;
207:

Line 206: l_buyer_id PO_HEADERS.agent_id%TYPE;

202: l_authorization_status PO_HEADERS.authorization_status%TYPE;
203: l_document_subtype PO_HEADERS.type_lookup_code%TYPE;
204: l_launch_approvals_flag VARCHAR2(1);
205: l_shipment_count NUMBER;
206: l_buyer_id PO_HEADERS.agent_id%TYPE;
207:
208: l_return_status VARCHAR2(1);
209: l_secondary_quantity PO_LINES.SECONDARY_QUANTITY%TYPE := p_secondary_qty; --
210: l_preferred_grade MTL_GRADES.grade_Code%TYPE := p_preferred_grade; --

Line 265: p_table_name => 'PO_HEADERS',

261: PO_DOCUMENT_UPDATE_PVT.add_error (
262: p_api_errors => x_api_errors,
263: x_return_status => l_return_status,
264: p_message_name => 'PO_INVALID_DOC_IDS',
265: p_table_name => 'PO_HEADERS',
266: p_column_name => 'PO_HEADER_ID'
267: );
268: x_result := 0;
269: CLOSE l_po_header_csr;

Line 311: l_header_table_name := 'PO_HEADERS';

307: --
308:
309: -- Check if the document is one of the supported types.
310: IF (l_po_release_id IS NULL) THEN -- PO/PA
311: l_header_table_name := 'PO_HEADERS';
312: IF l_document_subtype NOT IN ('STANDARD', 'PLANNED') THEN
313: PO_DOCUMENT_UPDATE_PVT.add_error (
314: p_api_errors => x_api_errors,
315: x_return_status => l_return_status,