[Home] [Help]
800: l_std_yn VARCHAR2(3) := 'Y';
801: l_intent VARCHAR2(1);
802: l_txt CLOB;
803: CURSOR art_id_crs (p_id NUMBER) IS
804: SELECT t.sav_sae_id, t.article_version_id, a.standard_yn
805: FROM okc_terms_articles_v t, okc_articles_all a
806: WHERE t.id=p_id AND t.sav_sae_id=a.article_id;
807: CURSOR l_get_intent_csr(p_doc_type VARCHAR2) IS
808: SELECT intent FROM OKC_BUS_DOC_TYPES_B
856: x_msg_data => x_msg_data,
857:
858: p_article_title => p_catv_rec.name,
859: p_article_number => NULL,
860: p_standard_yn => 'N',
861: p_article_intent => l_intent,
862: p_article_language => USERENV('LANG'),
863: p_article_type => p_catv_rec.sbt_code,
864: p_orig_system_reference_code => p_catv_rec.orig_system_reference_code,
928: x_msg_data => x_msg_data,
929: p_article_id => l_art_id,
930: p_article_title => p_catv_rec.name,
931: p_article_number => NULL,
932: p_standard_yn => NULL,
933: p_article_intent => NULL,
934: p_article_language => NULL,
935: p_article_type => p_catv_rec.sbt_code,
936: p_orig_system_reference_code => NULL,
977: END IF;
978:
979: END IF;
980:
981: -- Standard call to get message count and if count is 1, get message info.
982: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
983:
984: IF (l_debug = 'Y') THEN
985: okc_debug.log('900: Leaving Process_Non_Std_Article.', 2);
1326:
1327: IF (gi_catv_rec.TEXT IS NOT NULL OR gi_catv_rec.sav_sae_id IS NULL
1328: OR gi_catv_rec.cat_type = 'NSD' OR gi_catv_rec.document_type LIKE 'OKE%') THEN
1329: IF (gi_catv_rec.name IS NULL) THEN
1330: gi_catv_rec.name := 'NONSTANDARD';
1331: END IF;
1332: IF (gi_catv_rec.cat_type = 'STA' and gi_catv_rec.document_type LIKE 'OKE%') THEN
1333: gi_catv_rec.orig_system_reference_code := 'OKE';
1334: END IF;