APPS.OKC_K_ENTITY_LOCKS_GRP dependencies on FND_PROFILE

Line 5: := NVL (fnd_profile.VALUE ('AFLOG_ENABLED'), 'N');

1: PACKAGE BODY okc_k_entity_locks_grp
2: /* $Header: OKCGELKB.pls 120.2.12020000.6 2013/03/26 08:51:55 skavutha ship $ */
3: AS
4: l_debug VARCHAR2 (1)
5: := NVL (fnd_profile.VALUE ('AFLOG_ENABLED'), 'N');
6: ---------------------------------------------------------------------------
7: -- GLOBAL MESSAGE CONSTANTS
8: ---------------------------------------------------------------------------
9: g_fnd_app CONSTANT VARCHAR2 (200) := okc_api.g_fnd_app;

Line 1575: IF nvl(fnd_profile.value('OKC_USE_CONTRACTS_RULES_ENGINE'), 'N') = 'Y' THEN --okc rules engine

1571:
1572: --------------------------------------------
1573: -- Delete configuration data
1574: --------------------------------------------
1575: IF nvl(fnd_profile.value('OKC_USE_CONTRACTS_RULES_ENGINE'), 'N') = 'Y' THEN --okc rules engine
1576:
1577: --deleting the responses
1578: DELETE FROM okc_xprt_doc_ques_response
1579: WHERE doc_id = p_target_document_id

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

1631: end if;
1632: -----------------------------------------------------
1633: -- Copy the configuration data from the Src to target
1634: -----------------------------------------------------
1635: IF nvl(fnd_profile.value('OKC_USE_CONTRACTS_RULES_ENGINE'), 'N') = 'Y' THEN
1636: --okc rules engine
1637: --copying responses from the base document
1638: INSERT INTO okc_xprt_doc_ques_response(doc_question_response_id, doc_id, doc_type, question_id, response)
1639: (SELECT okc_xprt_doc_ques_response_s.NEXTVAL, p_target_document_id, p_target_document_type, question_id, response