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
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);
1275: WHERE lookup_type = 'OKC_ARTICLE_ADOPTION_TYPE'
1276: AND lookup_code = cp_adoption_type;
1277:
1278:
1279: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1280: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
1281:
1282: BEGIN
1283: IF (l_debug = 'Y') THEN
1276: AND lookup_code = cp_adoption_type;
1277:
1278:
1279: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1280: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
1281:
1282: BEGIN
1283: IF (l_debug = 'Y') THEN
1284: okc_debug.log('100: Entered auto_adoption for new org.', 2);