APPS.PO_DOCUMENT_ARCHIVE_GRP dependencies on PO_DOCUMENT_TYPES

Line 202: l_when_to_archive PO_DOCUMENT_TYPES.archive_external_revision_code%TYPE;

198: IS
199: l_api_name CONSTANT varchar2(30) := 'ARCHIVE_PO';
200: l_api_version CONSTANT NUMBER := 1.0;
201: l_progress VARCHAR2(3);
202: l_when_to_archive PO_DOCUMENT_TYPES.archive_external_revision_code%TYPE;
203: BEGIN
204:
205: -- Initialize OUT parameters
206: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 224: FROM po_document_types

220: l_progress := '010';
221: -- Check if we need to archive the document
222: SELECT archive_external_revision_code
223: INTO l_when_to_archive
224: FROM po_document_types
225: WHERE document_type_code = p_document_type
226: AND document_subtype = p_document_subtype;
227:
228: l_progress := '020';