APPS.OKC_ARTICLES_MIGRATE_GRP dependencies on DUAL

Line 192: SELECT OKC_ARTICLES_ALL_S1.NEXTVAL FROM DUAL;

188: p_object_type IN VARCHAR2,
189: x_object_id OUT NOCOPY NUMBER
190: ) RETURN VARCHAR2 IS
191: CURSOR l_art_csr IS
192: SELECT OKC_ARTICLES_ALL_S1.NEXTVAL FROM DUAL;
193: CURSOR l_ver_csr IS
194: SELECT OKC_ARTICLE_VERSIONS_S1.NEXTVAL FROM DUAL;
195: BEGIN
196: IF (l_debug = 'Y') THEN

Line 194: SELECT OKC_ARTICLE_VERSIONS_S1.NEXTVAL FROM DUAL;

190: ) RETURN VARCHAR2 IS
191: CURSOR l_art_csr IS
192: SELECT OKC_ARTICLES_ALL_S1.NEXTVAL FROM DUAL;
193: CURSOR l_ver_csr IS
194: SELECT OKC_ARTICLE_VERSIONS_S1.NEXTVAL FROM DUAL;
195: BEGIN
196: IF (l_debug = 'Y') THEN
197: okc_debug.Log('100: Entered get_seq_id', 2);
198: END IF;

Line 1099: okc_debug.Log('400: Leaving loop for individual article processing loop : Prereq is not properly set', 2);

1095: artv_sav_release_tbl.DELETE;
1096: EXCEPTION
1097: WHEN G_EXC_PREREQ_SETUP_ERROR THEN
1098: IF (l_debug = 'Y') THEN
1099: okc_debug.Log('400: Leaving loop for individual article processing loop : Prereq is not properly set', 2);
1100: END IF;
1101: --
1102:
1103: IF l_orig_article_csr%ISOPEN THEN

Line 1113: okc_debug.Log('400: Leaving loop for individual article processing loop due to OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

1109: exit;-- exit this loop
1110:
1111: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1112: IF (l_debug = 'Y') THEN
1113: okc_debug.Log('400: Leaving loop for individual article processing loop due to OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1114: END IF;
1115: --
1116: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1117: p_msg_name => G_UNEXPECTED_ERROR,

Line 1149: okc_debug.Log('500: Leaving loop for individual article processing loop due to EXCEPTION: '||sqlerrm, 2);

1145: -- exit; -- exit this loop
1146:
1147: WHEN OTHERS THEN
1148: IF (l_debug = 'Y') THEN
1149: okc_debug.Log('500: Leaving loop for individual article processing loop due to EXCEPTION: '||sqlerrm, 2);
1150: END IF;
1151: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1152: p_msg_name => G_UNEXPECTED_ERROR,
1153: p_token1 => G_SQLCODE_TOKEN,