[Home] [Help]
1: PACKAGE BODY OKC_ADOPTIONS_GRP AS
2: /* $Header: OKCGADPB.pls 120.0 2005/05/25 19:10:15 appldev noship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:
6: ---------------------------------------------------------------------------
7: -- GLOBAL MESSAGE CONSTANTS
8: ---------------------------------------------------------------------------
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:
34: ---------------------------------------
35: -- PROCEDURE check adoption details --
36: ---------------------------------------
54: l_api_version CONSTANT NUMBER := 1;
55: l_api_name CONSTANT VARCHAR2(30) := 'g_check_adoption';
56: l_lcz_article_id NUMBER;
57:
58: l_global_org_id NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
59: l_local_article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE;
60: l_adp_row_notfound BOOLEAN := FALSE;
61: l_lcz_row_notfound BOOLEAN := FALSE;
62: l_row_found BOOLEAN := FALSE;
796: l_return_status VARCHAR2(1);
797: l_local_article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE;
798: l_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;
799: l_adoption_status OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE;
800: l_GLOBAL_ORG_ID NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
801: TYPE l_org_id_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
802: TYPE l_adoption_type_list IS TABLE OF FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
803: TYPE l_notifier_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORG_INFORMATION2%TYPE INDEX BY BINARY_INTEGER;
804: TYPE l_adoption_status_list IS TABLE OF OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE INDEX BY BINARY_INTEGER;
1192: l_adoption_type_meaning FND_LOOKUPS.MEANING%TYPE;
1193: l_organization_name HR_ORGANIZATION_UNITS.NAME%TYPE;
1194:
1195: l_prev_article_id OKC_ARTICLES_ALL.ARTICLE_ID%TYPE;
1196: l_GLOBAL_ORG_ID NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
1197: TYPE l_adoption_type_list IS TABLE OF FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
1198: TYPE l_adoption_status_list IS TABLE OF OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE INDEX BY BINARY_INTEGER;
1199: TYPE l_adp_record_status_list IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
1200: TYPE l_article_version_id_list IS TABLE OF OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER ;
1289: l_count_ver_adopted := 0;
1290: l_count_ver_available := 0;
1291: -- The org being passed cannot be a global org.
1292:
1293: l_GLOBAL_ORG_ID := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
1294: if p_org_id = l_GLOBAL_ORG_ID or p_org_id = -99 Then
1295: FND_MESSAGE.SET_NAME(G_APP_NAME, 'OKC_ADOPT_INVALID_ORG');
1296: FND_MSG_PUB.add;
1297: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(1, p_encoded =>FND_API.G_FALSE ));