APPS.OKC_ARTICLES_IMPORT_GRP dependencies on FND_PROFILE

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

1: PACKAGE BODY okc_articles_import_grp AS
2: /* $Header: OKCGAIMB.pls 120.28.12020000.3 2012/07/20 14:30:38 serukull ship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5: -- global array for temporary clob
6: g_temp_clob_tbl article_txt_tbl_type:= article_txt_tbl_type();
7:
8: ---------------------------------------------------------------------------

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

28:
29: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
30: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';
31: G_SQLCODE_TOKEN CONSTANT varchar2(200) := 'ERROR_CODE';
32: G_GLOBAL_ORG_ID NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
33: -- MOAC
34: -- G_CURRENT_ORG_ID NUMBER := -99;
35: G_CURRENT_ORG_ID NUMBER ;
36: G_FETCHSIZE_LIMIT NUMBER := 300;