[Home] [Help]
136:
137: If (l_article_id.count > 0) then
138:
139: FORALL i IN l_scn_id.FIRST..l_scn_id.LAST
140: INSERT INTO okc_terms_deviations_temp (Scn_id,
141: article_id,
142: display_sequence,
143: mandatory_flag,
144: label,
258: '240: Inserting the data in temp table as count > 0');
259: END IF;
260:
261: FORALL i IN l_expert_articles_tbl.FIRST..l_expert_articles_tbl.LAST
262: INSERT INTO okc_terms_deviations_temp (
263: article_id,
264: article_version_id,
265: source_flag)
266: VALUES
709: AND NVL(summary_amend_operation_code,'NULL') <> 'DELETED'
710: AND EXISTS (SELECT 1 FROM okc_articles_all oka
711: WHERE oka.article_id = oab.sav_sae_id
712: AND standard_YN = 'N')
713: AND NOT EXISTS (SELECT 1 from okc_terms_deviations_temp odt
714: WHERE odt.article_id = oab.orig_article_id);
715:
716:
717:
760: AND ref_article_version_id is not null
761: AND document_id = p_doc_id
762: AND document_type = p_doc_type
763: AND nvl(summary_amend_operation_code,'NULL') <> 'DELETED'
764: AND Exists ( Select 1 from okc_terms_deviations_temp odt where
765: oab.orig_article_id = odt.article_id ) ;
766: l_compare_flag := 'Y';
767:
768: elsif l_dev_cat.deviation_code = 'MISSING_EXPERT_ARTICLE' then
802: l_article_title,
803: l_display_sequence,
804: l_mandatory_flag,
805: l_orig_article_id
806: FROM okc_terms_deviations_temp otd
807: WHERE otd.source_flag = 'R'
808: AND x_include_exp = 'Y'
809: AND NOT EXISTS ( Select 1 from okc_k_articles_b oab
810: Where oab.document_type = p_doc_type
854: l_article_title,
855: l_display_sequence,
856: l_mandatory_flag,
857: l_orig_article_id
858: FROM okc_terms_deviations_temp otd
859: WHERE otd.source_flag = 'T'
860: AND otd.mandatory_flag = 'Y'
861: --Bug 4070733 Added condition to check for ammendement operation code
862: AND (NOT EXISTS ( Select 1 from okc_k_articles_b oab
907: l_article_title,
908: l_display_sequence,
909: l_mandatory_flag,
910: l_orig_article_id
911: FROM okc_terms_deviations_temp otd
912: WHERE otd.source_flag = 'T'
913: AND otd.mandatory_flag = 'N'
914: --Bug 4070733 Added condition to check for ammendement operation code
915: AND (NOT EXISTS ( Select 1 from okc_k_articles_b oab
1068: AND document_id = p_doc_id
1069: AND document_type = p_doc_type
1070: AND nvl(summary_amend_operation_code,'NULL') <> 'DELETED'
1071: AND x_include_exp = 'Y'
1072: AND NOT Exists ( Select 1 from okc_terms_deviations_temp odt
1073: Where oab.orig_article_id = odt.article_id
1074: And odt.source_flag = 'R')
1075: AND NOT EXISTS (Select 1 from okc_terms_deviations_t odt
1076: Where odt.doc_article_id = oab.sav_sae_id
1122: AND nvl(summary_amend_operation_code,'NULL') <> 'DELETED'
1123: AND EXISTS (Select 1 from okc_articles_all oaa
1124: Where oaa.article_id = oab.sav_sae_id
1125: And oaa.standard_yn = 'Y')
1126: AND NOT EXISTS (Select 1 from okc_terms_deviations_temp
1127: Where article_id = nvl(oab.orig_article_id,
1128: oab.sav_sae_id))
1129: -- Fix for bug# 4709359.
1130: AND NOT EXISTS (Select 1 from okc_terms_deviations_temp
1126: AND NOT EXISTS (Select 1 from okc_terms_deviations_temp
1127: Where article_id = nvl(oab.orig_article_id,
1128: oab.sav_sae_id))
1129: -- Fix for bug# 4709359.
1130: AND NOT EXISTS (Select 1 from okc_terms_deviations_temp
1131: Where article_id = oab.sav_sae_id)
1132: -- End of Fix for bug# 4709359.
1133: AND NOT EXISTS (Select 1 from okc_terms_deviations_t odt
1134: Where odt.doc_article_id = oab.sav_sae_id
1171: l_article_title,
1172: l_display_sequence,
1173: l_mandatory_flag,
1174: l_orig_article_id
1175: FROM okc_k_articles_b oab, okc_terms_deviations_temp odt
1176: WHERE oab.document_id = p_doc_id
1177: AND oab.document_type = p_doc_type
1178: AND oab.source_flag = odt.source_flag
1179: AND nvl(oab.summary_amend_operation_code,'NULL') <> 'DELETED'