[Home] [Help]
49: AND (amendment_operation_code IS NOT NULL OR amendment_description IS NOT NULL OR summary_amend_operation_code IS NOT NULL);
50:
51: CURSOR cat_crs IS
52: SELECT kart.id, kart.object_version_number,kart.amendment_operation_code,kart.summary_amend_operation_code,
53: DECODE(art.standard_yn,'N','Y',NULL) change_nonstd_yn
54: FROM okc_k_articles_b kart,okc_articles_all art
55: WHERE kart.document_type = p_doc_type AND kart.document_id = p_doc_id
56: AND kart.sav_sae_id = art.article_id
57: AND (kart.amendment_operation_code IS NOT NULL OR kart.amendment_description IS NOT NULL
54: FROM okc_k_articles_b kart,okc_articles_all art
55: WHERE kart.document_type = p_doc_type AND kart.document_id = p_doc_id
56: AND kart.sav_sae_id = art.article_id
57: AND (kart.amendment_operation_code IS NOT NULL OR kart.amendment_description IS NOT NULL
58: OR kart.summary_amend_operation_code IS NOT NULL OR art.standard_yn='N');
59:
60: CURSOR scn_incremental_crs IS
61: SELECT id, object_version_number, amendment_operation_code
62: FROM okc_sections_b
70: AND amendment_operation_code = G_AMEND_CODE_DELETED
71: AND SUMMARY_AMEND_OPERATION_CODE IS NULL;
72:
73: CURSOR cat_incremental_crs IS
74: SELECT id, kart.object_version_number, amendment_operation_code,standard_yn
75: FROM okc_k_articles_b kart,okc_articles_all
76: WHERE document_type = p_doc_type AND document_id = p_doc_id
77: AND sav_sae_id = article_id
78: AND (amendment_operation_code IS NOT NULL
75: FROM okc_k_articles_b kart,okc_articles_all
76: WHERE document_type = p_doc_type AND document_id = p_doc_id
77: AND sav_sae_id = article_id
78: AND (amendment_operation_code IS NOT NULL
79: OR standard_yn='N');
80:
81: CURSOR l_del_cat_crs IS
82: SELECT id, object_version_number
83: FROM okc_k_articles_b
359: --------------------------------------------
360: END LOOP;
361:
362: FOR cr IN cat_incremental_crs LOOP
363: select decode(cr.standard_yn,'N','Y',NULL)
364: into l_change_nonstd from dual;
365: --------------------------------------------
366: -- Update article
367: --------------------------------------------
490: AND amendment_operation_code = G_AMEND_CODE_DELETED
491: AND SUMMARY_AMEND_OPERATION_CODE IS NULL;
492:
493: CURSOR cat_crs IS
494: SELECT id, kart.object_version_number, amendment_operation_code,standard_yn
495: FROM okc_k_articles_b kart,okc_articles_all
496: WHERE document_type = p_doc_type AND document_id = p_doc_id
497: AND sav_sae_id = article_id
498: AND (amendment_operation_code IS NOT NULL
495: FROM okc_k_articles_b kart,okc_articles_all
496: WHERE document_type = p_doc_type AND document_id = p_doc_id
497: AND sav_sae_id = article_id
498: AND (amendment_operation_code IS NOT NULL
499: OR standard_yn='N');
500:
501: CURSOR l_del_cat_crs IS
502: SELECT id, object_version_number
503: FROM okc_k_articles_b
713: --------------------------------------------
714: END LOOP;
715:
716: FOR cr IN cat_crs LOOP
717: select decode(cr.standard_yn,'N','Y',NULL)
718: into l_change_nonstd from dual;
719: --------------------------------------------
720: -- Update article
721: --------------------------------------------
735: END LOOP;
736: ****************************************/
737:
738:
739: -- Standard call to get message count and if count is 1, get message info.
740: /*IF (l_debug = 'Y') THEN
741: Okc_Debug.Log('300: Leaving Version_Doc', 2);
742: END IF;*/
743:
898: RAISE FND_API.G_EXC_ERROR ;
899: END IF;
900: --------------------------------------------
901:
902: -- Standard call to get message count and if count is 1, get message info.
903: /*IF (l_debug = 'Y') THEN
904: Okc_Debug.Log('300: Leaving Restore_Doc_Version', 2);
905: END IF;*/
906:
1058: RAISE FND_API.G_EXC_ERROR ;
1059: END IF;
1060: --------------------------------------------
1061:
1062: -- Standard call to get message count and if count is 1, get message info.
1063: /*IF (l_debug = 'Y') THEN
1064: Okc_Debug.Log('300: Leaving Delete_Doc_Version', 2);
1065: END IF;*/
1066: