eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_DOCUMENT_ARCHIVE_PVT dependencies on PO_DOCUMENT_TYPES

Line 3353: l_archive_mode PO_DOCUMENT_TYPES.archive_external_revision_code%TYPE;

3349: p_doc_subtype IN VARCHAR2
3350: ) RETURN VARCHAR2
3351: IS
3352:
3353: l_archive_mode PO_DOCUMENT_TYPES.archive_external_revision_code%TYPE;
3354:
3355: BEGIN
3356:
3357: -- SQL What: Get archive mode for Standard PO, Release

Line 3362: FROM po_document_types

3358: -- SQL Why : To Determine when the document is approved
3359:
3360: SELECT nvl(archive_external_revision_code,'PRINT')
3361: INTO l_archive_mode
3362: FROM po_document_types
3363: WHERE document_type_code = p_doc_type
3364: AND document_subtype = p_doc_subtype;
3365:
3366: RETURN l_archive_mode;