APPS.PO_DOCUMENT_UPDATE_GRP dependencies on PO_HEADERS

Line 161: from po_headers

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

Line 195: l_po_header_id PO_HEADERS.po_header_id%TYPE;

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

Line 199: l_revision_num PO_HEADERS.revision_num%TYPE;

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

Line 200: l_authorization_status PO_HEADERS.authorization_status%TYPE;

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

Line 201: l_document_subtype PO_HEADERS.type_lookup_code%TYPE;

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

Line 204: l_buyer_id PO_HEADERS.agent_id%TYPE;

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

Line 263: p_table_name => 'PO_HEADERS',

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

Line 309: l_header_table_name := 'PO_HEADERS';

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