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 1754: global_org_id NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);

1750: organization Wf_Engine.NameTabTyp;
1751: organization_list Wf_Engine.NumTabTyp;
1752: notified Wf_Engine.NameTabTyp;
1753: notified_list Wf_Engine.TextTabTyp;
1754: global_org_id NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
1755: counter NUMBER;
1756:
1757: BEGIN
1758: counter := 0;

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

1995: template_id NUMBER;
1996: wf_seq_id NUMBER;
1997: current_org_id NUMBER;
1998: l_rowfound BOOLEAN := FALSE;
1999: GLOBAL_ORG_ID NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
2000: l_dummy NUMBER;
2001:
2002: CURSOR global_articles_csr(cp_template_id in number,cp_wf_seq_id IN NUMBER) IS
2003: SELECT 1