DBA Data[Home] [Help]

APPS.PO_DOCUMENT_UPDATE_GRP dependencies on STANDARD

Line 43: -- Standard API initialization:

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 754: -- Standard API initialization:

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