DBA Data[Home] [Help]

APPS.PO_DOCUMENT_UPDATE_GRP dependencies on STANDARD

Line 44: -- Standard API initialization:

40: ) IS
41: l_api_name CONSTANT VARCHAR(30) := 'UPDATE_DOCUMENT';
42: l_api_version CONSTANT NUMBER := 1.0;
43: BEGIN
44: -- Standard API initialization:
45: IF NOT FND_API.Compatible_API_Call ( l_api_version, p_api_version,
46: l_api_name, g_pkg_name ) THEN
47: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
48: END IF;

Line 165: and type_lookup_code IN ('STANDARD', 'BLANKET', 'PLANNED');

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
168: select po_release_id, revision_num,
169: NVL(authorization_status, 'INCOMPLETE'), release_type

Line 312: IF l_document_subtype NOT IN ('STANDARD', 'PLANNED') THEN

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,
316: p_message_name => l_message_name, --

Line 482: -- Shipments of standard/planned POs do not have prices.

478: END IF; -- p_release_number
479:
480: l_progress := '100';
481:
482: -- Shipments of standard/planned POs do not have prices.
483: -- However, for backward compatibility, if the caller requests
484: -- a shipment price change, we will automatically convert it
485: -- to a line price change if the line has only one shipment.
486: IF (p_release_number IS NULL)

Line 487: AND (l_document_subtype IN ('STANDARD', 'PLANNED'))

483: -- However, for backward compatibility, if the caller requests
484: -- a shipment price change, we will automatically convert it
485: -- to a line price change if the line has only one shipment.
486: IF (p_release_number IS NULL)
487: AND (l_document_subtype IN ('STANDARD', 'PLANNED'))
488: AND (p_new_price IS NOT NULL) THEN
489:
490: -- SQL What: Returns the number of shipments on this line.
491: SELECT count(*)

Line 517: ELSE -- not a standard or planned PO

513: p_po_line_id => l_po_line_id,
514: p_unit_price => p_new_price
515: );
516: l_new_shipment_price := NULL; -- Do not add a shipment price change.
517: ELSE -- not a standard or planned PO
518: l_new_shipment_price := p_new_price;
519: END IF; -- standard or planned PO with new price
520:
521: l_progress := '110';

Line 519: END IF; -- standard or planned PO with new price

515: );
516: l_new_shipment_price := NULL; -- Do not add a shipment price change.
517: ELSE -- not a standard or planned PO
518: l_new_shipment_price := p_new_price;
519: END IF; -- standard or planned PO with new price
520:
521: l_progress := '110';
522:
523: -- Add a shipment change.

Line 756: -- Standard API initialization:

752: l_progress VARCHAR2(3) := '000';
753: BEGIN
754: x_return_status := FND_API.G_RET_STS_SUCCESS;
755:
756: -- Standard API initialization:
757: IF NOT FND_API.compatible_api_call (
758: p_current_version_number => l_api_version,
759: p_caller_version_number => p_api_version,
760: p_api_name => l_proc_name,