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.14 2011/07/12 10:13:56 serukull ship $ */
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.14 2011/07/12 10:13:56 serukull ship $ */
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.14 2011/07/12 10:13:56 serukull ship $ */
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 664: G_profile_doc_seq := fnd_profile.value('UNIQUE:SEQ_NUMBERS');

660: --with session context that API is called
661: --For performance, following steps are executed only when this is called from UI
662: --as user may change responsibility or org frequently during same session
663: IF p_seq_type_info_only = 'Y' THEN
664: G_profile_doc_seq := fnd_profile.value('UNIQUE:SEQ_NUMBERS');
665: G_doc_category_code := substr(Fnd_Profile.Value('OKC_ARTICLE_DOC_SEQ_CATEGORY'),1,30) ;
666: -- MOAC
667: G_CURRENT_ORG_ID := mo_global.get_current_org_id();
668: /*

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

661: --For performance, following steps are executed only when this is called from UI
662: --as user may change responsibility or org frequently during same session
663: IF p_seq_type_info_only = 'Y' THEN
664: G_profile_doc_seq := fnd_profile.value('UNIQUE:SEQ_NUMBERS');
665: G_doc_category_code := substr(Fnd_Profile.Value('OKC_ARTICLE_DOC_SEQ_CATEGORY'),1,30) ;
666: -- MOAC
667: G_CURRENT_ORG_ID := mo_global.get_current_org_id();
668: /*
669: OPEN cur_org_csr;

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

1319: -- Fix for bug# 5158268. The variable l_article_number should be initialized with p_article_number
1320: l_article_number := p_article_number;
1321: -- Generate article_number for articles based on autonumbering is required or not
1322: IF p_standard_yn = 'Y' Then
1323: G_doc_category_code := substr(Fnd_Profile.Value('OKC_ARTICLE_DOC_SEQ_CATEGORY'),1,30) ;
1324: G_profile_doc_seq := fnd_profile.value('UNIQUE:SEQ_NUMBERS');
1325: GET_ARTICLE_SEQ_NUMBER
1326: (p_article_number => p_article_number,
1327: p_seq_type_info_only => 'N',

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

1320: l_article_number := p_article_number;
1321: -- Generate article_number for articles based on autonumbering is required or not
1322: IF p_standard_yn = 'Y' Then
1323: G_doc_category_code := substr(Fnd_Profile.Value('OKC_ARTICLE_DOC_SEQ_CATEGORY'),1,30) ;
1324: G_profile_doc_seq := fnd_profile.value('UNIQUE:SEQ_NUMBERS');
1325: GET_ARTICLE_SEQ_NUMBER
1326: (p_article_number => p_article_number,
1327: p_seq_type_info_only => 'N',
1328: p_org_id => G_CURRENT_ORG_ID,

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

3477:
3478: -- end bug fix#3680325
3479: lv_article_status := 'DRAFT';
3480: l_cz_transfer_status_flag := 'N';
3481: G_profile_doc_seq:=fnd_profile.value('UNIQUE:SEQ_NUMBERS');
3482: G_doc_category_code := substr(Fnd_Profile.Value('OKC_ARTICLE_DOC_SEQ_CATEGORY'),1,30) ;
3483:
3484: -- MOAC
3485: IF G_CURRENT_ORG_ID IS NULL Then

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

3478: -- end bug fix#3680325
3479: lv_article_status := 'DRAFT';
3480: l_cz_transfer_status_flag := 'N';
3481: G_profile_doc_seq:=fnd_profile.value('UNIQUE:SEQ_NUMBERS');
3482: G_doc_category_code := substr(Fnd_Profile.Value('OKC_ARTICLE_DOC_SEQ_CATEGORY'),1,30) ;
3483:
3484: -- MOAC
3485: IF G_CURRENT_ORG_ID IS NULL Then
3486: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_NULL_ORG_ID');

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

4038: l_local_article_version_id NUMBER;
4039: i NUMBER := 0;
4040: j NUMBER := 0;
4041: l_return_status VARCHAR2(1);
4042: l_GLOBAL_ORG_ID NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
4043: TYPE l_org_id_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
4044: TYPE l_notifier_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORG_INFORMATION2%TYPE INDEX BY BINARY_INTEGER;
4045: TYPE l_adoption_status_list IS TABLE OF OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE INDEX BY BINARY_INTEGER;
4046: TYPE l_source_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.SOURCE_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;

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

4441: ) IS
4442: l_api_version CONSTANT NUMBER := 1;
4443: l_api_name CONSTANT VARCHAR2(30) := 'g_auto_adoption';
4444: j NUMBER := 0;
4445: l_GLOBAL_ORG_ID NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
4446: TYPE l_org_id_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
4447: TYPE l_article_number_list IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
4448: TYPE l_source_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.SOURCE_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
4449: TYPE l_target_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.TARGET_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;