DBA Data[Home] [Help]

APPS.PO_DOCUMENT_LOCK_GRP dependencies on STANDARD

Line 25: -- If FND_API.G_TRUE, the API will initialize the standard API message list.

21: --IN:
22: --p_api_version
23: -- API version number expected by the caller
24: --p_init_msg_list
25: -- If FND_API.G_TRUE, the API will initialize the standard API message list.
26: --p_document_type
27: -- type of document to lock: 'PO', 'PA', or 'RELEASE'
28: --p_document_id
29: -- ID of the document to lock - po_header_id for POs and PAs;

Line 69: AND NVL(PLL.shipment_type, 'STANDARD') IN ('STANDARD', 'PLANNED', 'PREPAYMENT')

65: AND POH.po_header_id = POL.po_header_id (+) -- JOIN
66: AND POL.po_line_id = PLL.po_line_id (+) -- JOIN
67: -- Need NVL(..) because we cannot use (+) with the IN operator:
68: -- : Include PREPAYMENT shipment_types in locking.
69: AND NVL(PLL.shipment_type, 'STANDARD') IN ('STANDARD', 'PLANNED', 'PREPAYMENT')
70: AND PLL.line_location_id = POD.line_location_id (+) -- JOIN
71: FOR UPDATE NOWAIT;
72:
73: -- SQL What: Locks the header and all the lines and price breaks of the PA.

Line 113: -- Standard API initialization:

109: 'Entering ' || l_api_name );
110: END IF;
111: END IF;
112:
113: -- Standard API initialization:
114: IF NOT FND_API.compatible_api_call ( l_api_version, p_api_version,
115: l_api_name, G_PKG_NAME ) THEN
116: RAISE FND_API.g_exc_unexpected_error;
117: END IF;

Line 135: AND type_lookup_code IN ('STANDARD','PLANNED');

131: SELECT 1
132: INTO l_dummy
133: FROM po_headers
134: WHERE po_header_id = p_document_id
135: AND type_lookup_code IN ('STANDARD','PLANNED');
136: EXCEPTION
137: WHEN no_data_found THEN
138: FND_MESSAGE.set_name('PO', 'PO_INVALID_DOC_IDS');
139: FND_MSG_PUB.add;