[Home] [Help]
803: l_std_yn VARCHAR2(3) := 'Y';
804: l_intent VARCHAR2(1);
805: l_txt CLOB;
806: CURSOR art_id_crs (p_id NUMBER) IS
807: SELECT t.sav_sae_id, t.article_version_id, a.standard_yn
808: FROM okc_terms_articles_v t, okc_articles_all a
809: WHERE t.id=p_id AND t.sav_sae_id=a.article_id;
810: CURSOR l_get_intent_csr(p_doc_type VARCHAR2) IS
811: SELECT intent FROM OKC_BUS_DOC_TYPES_B
859: x_msg_data => x_msg_data,
860:
861: p_article_title => p_catv_rec.name,
862: p_article_number => NULL,
863: p_standard_yn => 'N',
864: p_article_intent => l_intent,
865: p_article_language => USERENV('LANG'),
866: p_article_type => p_catv_rec.sbt_code,
867: p_orig_system_reference_code => p_catv_rec.orig_system_reference_code,
931: x_msg_data => x_msg_data,
932: p_article_id => l_art_id,
933: p_article_title => p_catv_rec.name,
934: p_article_number => NULL,
935: p_standard_yn => NULL,
936: p_article_intent => NULL,
937: p_article_language => NULL,
938: p_article_type => p_catv_rec.sbt_code,
939: p_orig_system_reference_code => NULL,
980: END IF;
981:
982: END IF;
983:
984: -- Standard call to get message count and if count is 1, get message info.
985: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
986:
987: IF (l_debug = 'Y') THEN
988: okc_debug.log('900: Leaving Process_Non_Std_Article.', 2);
1333:
1334: IF (gi_catv_rec.TEXT IS NOT NULL OR gi_catv_rec.sav_sae_id IS NULL
1335: OR gi_catv_rec.cat_type = 'NSD' OR gi_catv_rec.document_type LIKE 'OKE%') THEN
1336: IF (gi_catv_rec.name IS NULL) THEN
1337: gi_catv_rec.name := 'NONSTANDARD';
1338: END IF;
1339: IF (gi_catv_rec.cat_type = 'STA' and gi_catv_rec.document_type LIKE 'OKE%') THEN
1340: gi_catv_rec.orig_system_reference_code := 'OKE';
1341: END IF;