eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_ARTICLES_GRP dependencies on FND_PROFILE

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

1: PACKAGE BODY OKC_ARTICLES_GRP AS
2: /* $Header: OKCGARTB.pls 120.6 2006/09/06 00:37:07 rvohra noship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5: G_GLOBAL_ORG_ID NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
6: G_profile_doc_seq VARCHAR2(1) := fnd_profile.value('UNIQUE:SEQ_NUMBERS');
7: G_doc_category_code VARCHAR2(30) := substr(Fnd_Profile.Value('OKC_ARTICLE_DOC_SEQ_CATEGORY'),1,30) ;
8:

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

1: PACKAGE BODY OKC_ARTICLES_GRP AS
2: /* $Header: OKCGARTB.pls 120.6 2006/09/06 00:37:07 rvohra noship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5: G_GLOBAL_ORG_ID NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
6: G_profile_doc_seq VARCHAR2(1) := fnd_profile.value('UNIQUE:SEQ_NUMBERS');
7: G_doc_category_code VARCHAR2(30) := substr(Fnd_Profile.Value('OKC_ARTICLE_DOC_SEQ_CATEGORY'),1,30) ;
8:
9: ---------------------------------------------------------------------------

Line 6: G_profile_doc_seq VARCHAR2(1) := fnd_profile.value('UNIQUE:SEQ_NUMBERS');

2: /* $Header: OKCGARTB.pls 120.6 2006/09/06 00:37:07 rvohra noship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5: G_GLOBAL_ORG_ID NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
6: G_profile_doc_seq VARCHAR2(1) := fnd_profile.value('UNIQUE:SEQ_NUMBERS');
7: G_doc_category_code VARCHAR2(30) := substr(Fnd_Profile.Value('OKC_ARTICLE_DOC_SEQ_CATEGORY'),1,30) ;
8:
9: ---------------------------------------------------------------------------
10: -- GLOBAL MESSAGE CONSTANTS

Line 7: G_doc_category_code VARCHAR2(30) := substr(Fnd_Profile.Value('OKC_ARTICLE_DOC_SEQ_CATEGORY'),1,30) ;

3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5: G_GLOBAL_ORG_ID NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
6: G_profile_doc_seq VARCHAR2(1) := fnd_profile.value('UNIQUE:SEQ_NUMBERS');
7: G_doc_category_code VARCHAR2(30) := substr(Fnd_Profile.Value('OKC_ARTICLE_DOC_SEQ_CATEGORY'),1,30) ;
8:
9: ---------------------------------------------------------------------------
10: -- GLOBAL MESSAGE CONSTANTS
11: ---------------------------------------------------------------------------

Line 653: G_profile_doc_seq := fnd_profile.value('UNIQUE:SEQ_NUMBERS');

649: --with session context that API is called
650: --For performance, following steps are executed only when this is called from UI
651: --as user may change responsibility or org frequently during same session
652: IF p_seq_type_info_only = 'Y' THEN
653: G_profile_doc_seq := fnd_profile.value('UNIQUE:SEQ_NUMBERS');
654: G_doc_category_code := substr(Fnd_Profile.Value('OKC_ARTICLE_DOC_SEQ_CATEGORY'),1,30) ;
655: -- MOAC
656: G_CURRENT_ORG_ID := mo_global.get_current_org_id();
657: /*

Line 654: G_doc_category_code := substr(Fnd_Profile.Value('OKC_ARTICLE_DOC_SEQ_CATEGORY'),1,30) ;

650: --For performance, following steps are executed only when this is called from UI
651: --as user may change responsibility or org frequently during same session
652: IF p_seq_type_info_only = 'Y' THEN
653: G_profile_doc_seq := fnd_profile.value('UNIQUE:SEQ_NUMBERS');
654: G_doc_category_code := substr(Fnd_Profile.Value('OKC_ARTICLE_DOC_SEQ_CATEGORY'),1,30) ;
655: -- MOAC
656: G_CURRENT_ORG_ID := mo_global.get_current_org_id();
657: /*
658: OPEN cur_org_csr;

Line 1296: G_doc_category_code := substr(Fnd_Profile.Value('OKC_ARTICLE_DOC_SEQ_CATEGORY'),1,30) ;

1292: -- Fix for bug# 5158268. The variable l_article_number should be initialized with p_article_number
1293: l_article_number := p_article_number;
1294: -- Generate article_number for articles based on autonumbering is required or not
1295: IF p_standard_yn = 'Y' Then
1296: G_doc_category_code := substr(Fnd_Profile.Value('OKC_ARTICLE_DOC_SEQ_CATEGORY'),1,30) ;
1297: G_profile_doc_seq := fnd_profile.value('UNIQUE:SEQ_NUMBERS');
1298: GET_ARTICLE_SEQ_NUMBER
1299: (p_article_number => p_article_number,
1300: p_seq_type_info_only => 'N',

Line 1297: G_profile_doc_seq := fnd_profile.value('UNIQUE:SEQ_NUMBERS');

1293: l_article_number := p_article_number;
1294: -- Generate article_number for articles based on autonumbering is required or not
1295: IF p_standard_yn = 'Y' Then
1296: G_doc_category_code := substr(Fnd_Profile.Value('OKC_ARTICLE_DOC_SEQ_CATEGORY'),1,30) ;
1297: G_profile_doc_seq := fnd_profile.value('UNIQUE:SEQ_NUMBERS');
1298: GET_ARTICLE_SEQ_NUMBER
1299: (p_article_number => p_article_number,
1300: p_seq_type_info_only => 'N',
1301: p_org_id => G_CURRENT_ORG_ID,

Line 3360: G_profile_doc_seq:=fnd_profile.value('UNIQUE:SEQ_NUMBERS');

3356:
3357: -- end bug fix#3680325
3358: lv_article_status := 'DRAFT';
3359: l_cz_transfer_status_flag := 'N';
3360: G_profile_doc_seq:=fnd_profile.value('UNIQUE:SEQ_NUMBERS');
3361: G_doc_category_code := substr(Fnd_Profile.Value('OKC_ARTICLE_DOC_SEQ_CATEGORY'),1,30) ;
3362:
3363: -- MOAC
3364: IF G_CURRENT_ORG_ID IS NULL Then

Line 3361: G_doc_category_code := substr(Fnd_Profile.Value('OKC_ARTICLE_DOC_SEQ_CATEGORY'),1,30) ;

3357: -- end bug fix#3680325
3358: lv_article_status := 'DRAFT';
3359: l_cz_transfer_status_flag := 'N';
3360: G_profile_doc_seq:=fnd_profile.value('UNIQUE:SEQ_NUMBERS');
3361: G_doc_category_code := substr(Fnd_Profile.Value('OKC_ARTICLE_DOC_SEQ_CATEGORY'),1,30) ;
3362:
3363: -- MOAC
3364: IF G_CURRENT_ORG_ID IS NULL Then
3365: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_NULL_ORG_ID');

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

3871: l_local_article_version_id NUMBER;
3872: i NUMBER := 0;
3873: j NUMBER := 0;
3874: l_return_status VARCHAR2(1);
3875: l_GLOBAL_ORG_ID NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
3876: TYPE l_org_id_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
3877: TYPE l_notifier_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORG_INFORMATION2%TYPE INDEX BY BINARY_INTEGER;
3878: TYPE l_adoption_status_list IS TABLE OF OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE INDEX BY BINARY_INTEGER;
3879: TYPE l_source_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.SOURCE_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;

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

4274: ) IS
4275: l_api_version CONSTANT NUMBER := 1;
4276: l_api_name CONSTANT VARCHAR2(30) := 'g_auto_adoption';
4277: j NUMBER := 0;
4278: l_GLOBAL_ORG_ID NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
4279: TYPE l_org_id_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
4280: TYPE l_article_number_list IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
4281: TYPE l_source_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.SOURCE_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
4282: TYPE l_target_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.TARGET_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;