DBA Data[Home] [Help]

APPS.OKC_TERMS_UTIL_GRP dependencies on FND_PROFILE

Line 390: IF nvl(fnd_profile.value('OKC_USE_CONTRACTS_RULES_ENGINE'), 'N') = 'Y' THEN

386: DELETE FROM OKC_TEMPLATE_USAGES_H
387: WHERE document_type=l_doc_type_tbl(i)
388: and document_id=l_doc_id_tbl(i);
389:
390: IF nvl(fnd_profile.value('OKC_USE_CONTRACTS_RULES_ENGINE'), 'N') = 'Y' THEN
391: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST
392: DELETE FROM OKC_XPRT_DOC_QUES_RESPONSE
393: WHERE doc_type=l_doc_type_tbl(i)
394: and doc_id=l_doc_id_tbl(i);

Line 3919: RETURN nvl(fnd_profile.VALUE_SPECIFIC(name => 'OKC_RUN_DEVREP_ON_APPROVAL',application_id => l_application_id),'N');

3915:
3916: IF l_autogen_deviations_flag IS NOT NULL THEN
3917: RETURN l_autogen_deviations_flag;
3918: ELSE
3919: RETURN nvl(fnd_profile.VALUE_SPECIFIC(name => 'OKC_RUN_DEVREP_ON_APPROVAL',application_id => l_application_id),'N');
3920: END IF;
3921:
3922: EXCEPTION
3923: WHEN OTHERS THEN