DBA Data[Home] [Help]

APPS.OKC_REP_SEARCH_UTIL_PVT dependencies on STANDARD

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

757: WHERE lookup_type = l_lookup_type
758: AND lookup_code = p_status_code;
759: ELSE
760: -- If the document type code is PA_BLANKET or PA_CONTRACT
761: -- or PO_STANDARD, then the lookup type is
762: -- AUTHORIZATION_STATUS
763: IF ((p_doc_type_code = 'PA_BLANKET') OR
764: (p_doc_type_code = 'PA_CONTRACT') OR
765: (p_doc_type_code = 'PO_STANDARD'))

Line 765: (p_doc_type_code = 'PO_STANDARD'))

761: -- or PO_STANDARD, then the lookup type is
762: -- AUTHORIZATION_STATUS
763: IF ((p_doc_type_code = 'PA_BLANKET') OR
764: (p_doc_type_code = 'PA_CONTRACT') OR
765: (p_doc_type_code = 'PO_STANDARD'))
766: THEN
767: l_lookup_type := 'AUTHORIZATION STATUS';
768: -- Else, the document type code is REP_% and the lookup
769: -- type is OKC_REP_CONTRACT_STATUSES.

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

1223: END IF;
1224: CLOSE rep_status_csr;
1225:
1226: ELSIF ((p_document_type='PA_BLANKET') OR (p_document_type='PA_CONTRACT')
1227: OR (p_document_type='PO_STANDARD')) THEN
1228: OPEN po_status_csr;
1229: FETCH po_status_csr INTO l_contract_status_code;
1230: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1231: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

1538: END IF;
1539: CLOSE rep_org_csr;
1540:
1541: ELSIF ((p_document_type='PA_BLANKET') OR (p_document_type='PA_CONTRACT')
1542: OR (p_document_type='PO_STANDARD')) THEN
1543: OPEN po_org_csr;
1544: FETCH po_org_csr INTO l_org_id;
1545: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1546: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,