26: -- Check for requisition document security/access control
27:
28: SELECT COUNT(1)
29: INTO X_row_exists
30: FROM PO_DOCUMENT_TYPES PODT
31: WHERE PODT.DOCUMENT_TYPE_CODE = X_doc_type
32: AND PODT.DOCUMENT_SUBTYPE = X_doc_subtype
33: AND (X_doc_agent_id = X_agent_id
34: OR (PODT.SECURITY_LEVEL_CODE = 'PUBLIC'
57: /*Bug6640107 Reverting the changes done in the previous version */
58:
59: SELECT COUNT(1)
60: INTO X_row_exists
61: FROM PO_DOCUMENT_TYPES PODT
62: WHERE PODT.DOCUMENT_TYPE_CODE = X_doc_type
63: AND PODT.DOCUMENT_SUBTYPE = X_doc_subtype
64: AND (X_doc_agent_id = X_agent_id
65: OR (PODT.SECURITY_LEVEL_CODE = 'PUBLIC'