APPS.OKC_TERMS_TMPL_APPROVAL_PVT dependencies on FND_PROFILE

Line 47: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

43: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
44: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
45:
46:
47: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
48:
49: CURSOR tmpl_csr(cp_template_id IN NUMBER, cp_object_version_number IN NUMBER) IS
50: SELECT okc_template_wf_keys_s1.NEXTVAL WF_SEQUENCE,
51: tmpl.template_id,

Line 961: SELECT fnd_profile.Value('OKC_USE_CONTRACTS_RULES_ENGINE') INTO l_okc_rules_engine FROM dual;

957:
958:
959: IF (l_expert_enabled = 'Y') THEN
960:
961: SELECT fnd_profile.Value('OKC_USE_CONTRACTS_RULES_ENGINE') INTO l_okc_rules_engine FROM dual;
962:
963: fnd_file.put_line(FND_FILE.LOG,'Using OKC Rules Engine'||l_okc_rules_engine);
964:
965: IF Nvl(l_okc_rules_engine,'N') = 'N' THEN

Line 1803: global_org_id NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);

1799: organization Wf_Engine.NameTabTyp;
1800: organization_list Wf_Engine.NumTabTyp;
1801: notified Wf_Engine.NameTabTyp;
1802: notified_list Wf_Engine.TextTabTyp;
1803: global_org_id NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
1804: counter NUMBER;
1805:
1806: BEGIN
1807: counter := 0;

Line 2048: GLOBAL_ORG_ID NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);

2044: template_id NUMBER;
2045: wf_seq_id NUMBER;
2046: current_org_id NUMBER;
2047: l_rowfound BOOLEAN := FALSE;
2048: GLOBAL_ORG_ID NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
2049: l_dummy NUMBER;
2050: l_org_count NUMBER;
2051:
2052: CURSOR global_articles_csr(cp_template_id in number,cp_wf_seq_id IN NUMBER) IS