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;

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

287: --IN:
288: -- p_api_version :
289: -- API version number expected by the caller
290: -- p_init_msg_list:
291: -- If FND_API.G_TRUE, the API will initialize the standard API message list.
292: -- po_sesiongt_key:
293: -- Docuements to be locked are manitined in po_session_gt
294: -- po_sesiongt_key is the key in po_session_gt to identify
295: -- the intended records in the table

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

354: AND POH.po_header_id =gt.char4
355: AND gt.char1 = 'PO'
356: AND POH.po_header_id = POL.po_header_id (+) -- JOIN
357: AND POL.po_line_id = PLL.po_line_id (+) -- JOIN
358: AND NVL(PLL.shipment_type, 'STANDARD') IN ('STANDARD', 'PLANNED', 'PREPAYMENT')
359: AND PLL.line_location_id = POD.line_location_id (+) -- JOIN
360: FOR UPDATE NOWAIT;
361:
362:

Line 418: -- Standard API initialization:

414: END IF;
415: END IF;
416:
417:
418: -- Standard API initialization:
419: IF NOT FND_API.compatible_api_call ( l_api_version, p_api_version,
420: d_api_name, G_PKG_NAME ) THEN
421: RAISE FND_API.g_exc_unexpected_error;
422: END IF;