APPS.OKC_REP_UTIL_PVT dependencies on FND_PROFILE

Line 61: AND (INSTR( FND_PROFILE.VALUE('OKC_REP_INTENTS'), intent) <> 0

57: CURSOR intents_csr(p_contract_type IN VARCHAR2) IS
58: SELECT NULL
59: FROM okc_bus_doc_types_b
60: WHERE document_type = p_contract_type
61: AND (INSTR( FND_PROFILE.VALUE('OKC_REP_INTENTS'), intent) <> 0
62: OR FND_PROFILE.VALUE('OKC_REP_INTENTS') IS NULL);
63:
64: CURSOR po_contract_csr(p_contract_id IN NUMBER, p_contract_type IN VARCHAR2) IS
65: SELECT

Line 62: OR FND_PROFILE.VALUE('OKC_REP_INTENTS') IS NULL);

58: SELECT NULL
59: FROM okc_bus_doc_types_b
60: WHERE document_type = p_contract_type
61: AND (INSTR( FND_PROFILE.VALUE('OKC_REP_INTENTS'), intent) <> 0
62: OR FND_PROFILE.VALUE('OKC_REP_INTENTS') IS NULL);
63:
64: CURSOR po_contract_csr(p_contract_id IN NUMBER, p_contract_type IN VARCHAR2) IS
65: SELECT
66: h.org_id

Line 462: AND (INSTR( FND_PROFILE.VALUE('OKC_REP_INTENTS'), intent) <> 0

458: SELECT NULL
459: FROM okc_bus_doc_types_b
460: WHERE document_type = p_contract_type
461: AND ((is_sales_workbench() = 'N'
462: AND (INSTR( FND_PROFILE.VALUE('OKC_REP_INTENTS'), intent) <> 0
463: OR FND_PROFILE.VALUE('OKC_REP_INTENTS') IS NULL)
464: )
465: OR (is_sales_workbench() = 'Y'
466: AND intent IN ('S', 'O')

Line 463: OR FND_PROFILE.VALUE('OKC_REP_INTENTS') IS NULL)

459: FROM okc_bus_doc_types_b
460: WHERE document_type = p_contract_type
461: AND ((is_sales_workbench() = 'N'
462: AND (INSTR( FND_PROFILE.VALUE('OKC_REP_INTENTS'), intent) <> 0
463: OR FND_PROFILE.VALUE('OKC_REP_INTENTS') IS NULL)
464: )
465: OR (is_sales_workbench() = 'Y'
466: AND intent IN ('S', 'O')
467: )

Line 4593: FND_PROFILE.GET(NAME => l_auto_number_option, VAL => l_auto_num_profile);

4589: END IF;
4590:
4591:
4592: --Checking profile option value
4593: FND_PROFILE.GET(NAME => l_auto_number_option, VAL => l_auto_num_profile);
4594:
4595:
4596: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4597: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 8257: FND_PROFILE.GET(NAME => G_SALES_QUOTE_SEC_PROFILE, VAL => l_check_security_access);

8253: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
8254: 'checking security profile - ASO_ENABLE_SECURITY_CHECK');
8255: END IF;
8256:
8257: FND_PROFILE.GET(NAME => G_SALES_QUOTE_SEC_PROFILE, VAL => l_check_security_access);
8258: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8259: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
8260: 'Profile ASO_ENABLE_SECURITY_CHECK value is: '||l_check_security_access);
8261: END IF;