APPS.ECE_PO_ARCHIVE_PKG dependencies on PO_DOCUMENT_TYPES

Line 51: -- archive_external_revision code in PO_DOCUMENT_TYPES

47: -- If the archiving was successfull return.
48: -- else rollback to the savepoint and set p_error_code and return.
49: --
50: -- Conditions for archiving:
51: -- archive_external_revision code in PO_DOCUMENT_TYPES
52: -- (PRINT or APPROVE) of given document type must be the same
53: -- as process (PRINT or APPROVE).
54: -- Note: Routine does NOT do a commit, this must be done in the calling
55: -- routine!

Line 67: l_when_to_archive PO_DOCUMENT_TYPES.ARCHIVE_EXTERNAL_REVISION_CODE%TYPE;

63: P_ERROR_CODE OUT NOCOPY NUMBER,
64: P_ERROR_BUF OUT NOCOPY VARCHAR2,
65: P_ERROR_STACK OUT NOCOPY VARCHAR2)
66: IS
67: l_when_to_archive PO_DOCUMENT_TYPES.ARCHIVE_EXTERNAL_REVISION_CODE%TYPE;
68: l_return_status VARCHAR2(1);
69: l_msg_count NUMBER;
70: l_msg_data VARCHAR2(2000);
71:

Line 95: FROM PO_DOCUMENT_TYPES

91: -- if archiving is neccesary for this document.
92:
93: SELECT ARCHIVE_EXTERNAL_REVISION_CODE
94: INTO l_when_to_archive
95: FROM PO_DOCUMENT_TYPES
96: WHERE DOCUMENT_TYPE_CODE = p_document_type
97: AND DOCUMENT_SUBTYPE = p_document_subtype;
98:
99: -- Check if we need to archive the document.