DBA Data[Home] [Help]

APPS.OKC_REP_SEARCH_UTIL_PVT dependencies on STANDARD

Line 755: -- or PO_STANDARD, then the lookup type is

751: WHERE lookup_type = l_lookup_type
752: AND lookup_code = p_status_code;
753: ELSE
754: -- If the document type code is PA_BLANKET or PA_CONTRACT
755: -- or PO_STANDARD, then the lookup type is
756: -- AUTHORIZATION_STATUS
757: IF ((p_doc_type_code = 'PA_BLANKET') OR
758: (p_doc_type_code = 'PA_CONTRACT') OR
759: (p_doc_type_code = 'PO_STANDARD'))

Line 759: (p_doc_type_code = 'PO_STANDARD'))

755: -- or PO_STANDARD, then the lookup type is
756: -- AUTHORIZATION_STATUS
757: IF ((p_doc_type_code = 'PA_BLANKET') OR
758: (p_doc_type_code = 'PA_CONTRACT') OR
759: (p_doc_type_code = 'PO_STANDARD'))
760: THEN
761: l_lookup_type := 'AUTHORIZATION STATUS';
762: -- Else, the document type code is REP_% and the lookup
763: -- type is OKC_REP_CONTRACT_STATUSES.

Line 1221: OR (p_document_type='PO_STANDARD')) THEN

1217: END IF;
1218: CLOSE rep_status_csr;
1219:
1220: ELSIF ((p_document_type='PA_BLANKET') OR (p_document_type='PA_CONTRACT')
1221: OR (p_document_type='PO_STANDARD')) THEN
1222: OPEN po_status_csr;
1223: FETCH po_status_csr INTO l_contract_status_code;
1224: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1225: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,