APPS.OKC_REP_UTIL_PVT dependencies on FND_PROFILE

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

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

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

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

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

447: SELECT NULL
448: FROM okc_bus_doc_types_b
449: WHERE document_type = p_contract_type
450: AND ((is_sales_workbench() = 'N'
451: AND (INSTR( FND_PROFILE.VALUE('OKC_REP_INTENTS'), intent) <> 0
452: OR FND_PROFILE.VALUE('OKC_REP_INTENTS') IS NULL)
453: )
454: OR (is_sales_workbench() = 'Y'
455: AND intent IN ('S', 'O')

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

448: FROM okc_bus_doc_types_b
449: WHERE document_type = p_contract_type
450: AND ((is_sales_workbench() = 'N'
451: AND (INSTR( FND_PROFILE.VALUE('OKC_REP_INTENTS'), intent) <> 0
452: OR FND_PROFILE.VALUE('OKC_REP_INTENTS') IS NULL)
453: )
454: OR (is_sales_workbench() = 'Y'
455: AND intent IN ('S', 'O')
456: )

Line 3835: FND_PROFILE.GET(NAME => l_auto_number_option, VAL => l_auto_number_yn);

3831: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3832: 'Checking if user enters contract number');
3833: END IF;
3834: --Checking profile option value
3835: FND_PROFILE.GET(NAME => l_auto_number_option, VAL => l_auto_number_yn);
3836: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3837: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3838: 'Profile OKC_REP_AUTO_CON_NUMBER value is: '||l_auto_number_yn);
3839: END IF;

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

7351: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
7352: 'checking security profile - ASO_ENABLE_SECURITY_CHECK');
7353: END IF;
7354:
7355: FND_PROFILE.GET(NAME => G_SALES_QUOTE_SEC_PROFILE, VAL => l_check_security_access);
7356: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7357: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
7358: 'Profile ASO_ENABLE_SECURITY_CHECK value is: '||l_check_security_access);
7359: END IF;