APPS.PO_DOCUMENT_ARCHIVE_GRP dependencies on PO_DOCUMENT_TYPES

Line 203: l_when_to_archive PO_DOCUMENT_TYPES.archive_external_revision_code%TYPE;

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

Line 225: FROM po_document_types

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