808: END IF;
809:
810: IF ProfileValue <> 'N' THEN
811: return ' OKC_BUS_DOC_TYPES_SEC.DOCUMENT_TYPE_CLASS IN (''SOURCING'',''PO'') AND
812: OKC_BUS_DOC_TYPES_SEC.DOCUMENT_TYPE IN (''PA_BLANKET'',''PA_CONTRACT'',''PO_STANDARD'',
813: ''PA_BLANKET_MOD'',''PA_CONTRACT_MOD'',''PO_STANDARD_MOD'',''SOLICITATION_RESPONSE'')';
814: ELSE
815: return ' OKC_BUS_DOC_TYPES_SEC.DOCUMENT_TYPE_CLASS IN (''SOURCING'',''PO'') AND
816: OKC_BUS_DOC_TYPES_SEC.DOCUMENT_TYPE IN (''PA_BLANKET'',''PA_CONTRACT'',''PO_STANDARD'',
809:
810: IF ProfileValue <> 'N' THEN
811: return ' OKC_BUS_DOC_TYPES_SEC.DOCUMENT_TYPE_CLASS IN (''SOURCING'',''PO'') AND
812: OKC_BUS_DOC_TYPES_SEC.DOCUMENT_TYPE IN (''PA_BLANKET'',''PA_CONTRACT'',''PO_STANDARD'',
813: ''PA_BLANKET_MOD'',''PA_CONTRACT_MOD'',''PO_STANDARD_MOD'',''SOLICITATION_RESPONSE'')';
814: ELSE
815: return ' OKC_BUS_DOC_TYPES_SEC.DOCUMENT_TYPE_CLASS IN (''SOURCING'',''PO'') AND
816: OKC_BUS_DOC_TYPES_SEC.DOCUMENT_TYPE IN (''PA_BLANKET'',''PA_CONTRACT'',''PO_STANDARD'',
817: ''AUCTION_RESPONSE'',''RFI_RESPONSE'',''RFQ_RESPONSE'')';
812: OKC_BUS_DOC_TYPES_SEC.DOCUMENT_TYPE IN (''PA_BLANKET'',''PA_CONTRACT'',''PO_STANDARD'',
813: ''PA_BLANKET_MOD'',''PA_CONTRACT_MOD'',''PO_STANDARD_MOD'',''SOLICITATION_RESPONSE'')';
814: ELSE
815: return ' OKC_BUS_DOC_TYPES_SEC.DOCUMENT_TYPE_CLASS IN (''SOURCING'',''PO'') AND
816: OKC_BUS_DOC_TYPES_SEC.DOCUMENT_TYPE IN (''PA_BLANKET'',''PA_CONTRACT'',''PO_STANDARD'',
817: ''AUCTION_RESPONSE'',''RFI_RESPONSE'',''RFQ_RESPONSE'')';
818: END IF;
819: ELSE
820: return ' 1=1 ';