[Home] [Help]
188: cp_global_org_id IN NUMBER) IS
189: SELECT 1
190: FROM OKC_ARTICLES_ALL ARTL
191: WHERE ARTL.ORG_ID = cp_local_org_id
192: AND ARTL.STANDARD_YN = 'Y'
193: AND ARTL.ARTICLE_TITLE = ( SELECT ARTG.ARTICLE_TITLE
194: FROM OKC_ARTICLES_ALL ARTG
195: WHERE ARTG.ARTICLE_ID = cp_global_article_id
196: AND ARTG.ORG_ID = cp_global_org_id
193: AND ARTL.ARTICLE_TITLE = ( SELECT ARTG.ARTICLE_TITLE
194: FROM OKC_ARTICLES_ALL ARTG
195: WHERE ARTG.ARTICLE_ID = cp_global_article_id
196: AND ARTG.ORG_ID = cp_global_org_id
197: AND ARTG.STANDARD_YN= 'Y');
198:
199:
200: l_latest_ver_adp_rec l_latest_ver_adp_csr%ROWTYPE;
201: l_latest_ver_lcz_rec l_latest_ver_lcz_csr%ROWTYPE;
207: okc_debug.log('100: Entered check_adoption with parameters: ' || p_global_article_version_id ||'*'|| p_adoption_type ||'*'|| p_local_org_id, 2);
208: END IF;
209: x_earlier_local_version_id := NULL;
210:
211: -- Standard Start of API savepoint
212: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
214: END IF;
215: -- Initialize message list if p_init_msg_list is set to TRUE.
461: okc_debug.log('100: Entered delete_adoption', 2);
462: END IF;
463: x_return_status := FND_API.G_RET_STS_SUCCESS;
464:
465: -- Standard Start of API savepoint
466: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
468: END IF;
469: -- Initialize message list if p_init_msg_list is set to TRUE.
595: IF (l_debug = 'Y') THEN
596: okc_debug.log('100: Entered create_adoption', 2);
597: END IF;
598:
599: -- Standard Start of API savepoint
600: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
602: END IF;
603: -- Initialize message list if p_init_msg_list is set to TRUE.
877: cp_global_org_id IN NUMBER) IS
878: SELECT 1
879: FROM OKC_ARTICLES_ALL ARTL
880: WHERE ARTL.ORG_ID = cp_local_org_id
881: AND ARTL.STANDARD_YN= 'Y'
882: AND ARTL.ARTICLE_TITLE = ( SELECT ARTG.ARTICLE_TITLE
883: FROM OKC_ARTICLES_ALL ARTG
884: WHERE ARTG.ARTICLE_ID = cp_global_article_id
885: AND ARTG.ORG_ID = cp_global_org_id
882: AND ARTL.ARTICLE_TITLE = ( SELECT ARTG.ARTICLE_TITLE
883: FROM OKC_ARTICLES_ALL ARTG
884: WHERE ARTG.ARTICLE_ID = cp_global_article_id
885: AND ARTG.ORG_ID = cp_global_org_id
886: AND ARTG.STANDARD_YN='Y');
887: l_user_id NUMBER := FND_GLOBAL.USER_ID;
888: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
889:
890: BEGIN
891: IF (l_debug = 'Y') THEN
892: okc_debug.log('100: Entered create_adoption', 2);
893: END IF;
894:
895: -- Standard Start of API savepoint
896: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
898: END IF;
899: -- Initialize message list if p_init_msg_list is set to TRUE.
1115: end if;
1116: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1117: return;
1118: END IF;
1119: -- Standard check of p_commit
1120: IF FND_API.To_Boolean( p_commit ) THEN
1121: COMMIT WORK;
1122: END IF;
1123: -- Standard call to get message count and if count is 1, get message info.
1119: -- Standard check of p_commit
1120: IF FND_API.To_Boolean( p_commit ) THEN
1121: COMMIT WORK;
1122: END IF;
1123: -- Standard call to get message count and if count is 1, get message info.
1124: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,p_encoded=> 'F', p_data => x_msg_data );
1125:
1126: IF (l_debug = 'Y') THEN
1127: okc_debug.log('200: Leaving check adoption', 2);
1265: SELECT '1'
1266: FROM OKC_ARTICLES_ALL
1267: WHERE org_id = cp_local_org_id
1268: AND article_title = cp_article_title
1269: AND standard_yn = 'Y';
1270:
1271: CURSOR l_adoption_type_meaning_csr (
1272: cp_adoption_type IN VARCHAR2) IS
1273: SELECT meaning