[Home] [Help]
129: function get_PricingArrangementBase(p_clause_type VARCHAR2) return varchar2 IS
130: l_clause_exists varchar2(1);
131: CURSOR csr_clause_exists(clause_t VARCHAR2) IS
132: SELECT 'Y' FROM dual
133: WHERE EXISTS (SELECT 1 FROM okc_k_articles_b kartb, okc_articles_all art
134: WHERE kartb.sav_sae_id = art.article_id
135: AND article_number = clause_t);
136: begin
137: l_temp_attr := p_clause_type;
211:
212: l_clause_exists varchar2(10);
213: cursor csr_check_clauses is
214: SELECT 'true' FROM (
215: SELECT Count(DISTINCT art.article_title) AS articles FROM okc_k_articles_b kartb, okc_article_versions ver, okc_articles_all art
216: WHERE kartb.article_version_id = ver.article_version_id
217: AND kartb.sav_Sae_id = art.article_id
218: AND ver.article_id = art.article_id
219: AND kartb.document_id in
691: FUNCTION is_contingencyContract(p_doc_id NUMBER,p_doc_type varchar2) RETURN varchar2 AS
692:
693: CURSOR c IS
694: SELECT 'true'
695: FROM okc_k_articles_b kartb, okc_articles_all art
696: WHERE kartb.sav_sae_id = art.article_id
697: AND kartb.document_id = p_doc_id
698: AND kartb.document_type = p_doc_type
699: AND art.article_number = '252.232-7011';
713: FUNCTION is_EmergencyRequestContract(p_doc_id NUMBER,p_doc_type varchar2) RETURN varchar2 AS
714:
715: CURSOR c IS
716: SELECT 'true'
717: FROM okc_k_articles_b kartb, okc_articles_all art
718: WHERE kartb.sav_sae_id = art.article_id
719: AND kartb.document_id = p_doc_id
720: AND kartb.document_type = p_doc_type
721: AND art.article_number IN ('252.225-7997 (DEV)','252.232-7011','252.237-7023');
734: FUNCTION get_miscclausetext(p_scn_id NUMBER) RETURN CLOB AS
735:
736: CURSOR c2 IS
737: SELECT article_text
738: FROM okc_k_articles_b kartb, okc_articles_all art, okc_article_versions ver
739: WHERE kartb.document_type = DOCUMENTTYPE
740: AND kartb.document_id = decode(ISMOD,'N',DOCUMENTID,DRAFTID)
741: AND kartb.sav_sae_id = art.article_id
742: AND kartb.article_version_id = ver.article_version_id
760:
761: CURSOR c2 IS
762:
763: SELECT ARTICLE_TEXT
764: FROM okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver
765: WHERE kartb.sav_sae_id = art.article_id
766: AND art.article_id = ver.article_id
767: AND document_id = Decode(isMod,'N',DOCUMENTID,'Y',DRAFTID,DOCUMENTID)
768: AND kartb.document_type = DOCUMENTTYPE
1112:
1113:
1114: CURSOR c_misctext_base IS
1115: SELECT (SELECT heading FROM okc_sections_b WHERE id = kartb.scn_id) Section,get_miscclausetxt(scn_id,'N') MiscellaneousText
1116: FROM okc_k_articles_b kartb, okc_articles_all art, okc_article_versions ver
1117: WHERE kartb.document_id = DOCUMENTID
1118: AND kartb.sav_sae_id = art.article_id
1119: AND kartb.article_version_id = ver.article_version_id
1120: AND art.article_id = ver.article_id
1124: ORDER BY scn_id;
1125:
1126: CURSOR c_misctext_mod IS
1127: SELECT (SELECT heading FROM okc_sections_b WHERE id = kartb.scn_id) Section,get_miscclausetxt(scn_id,'Y') MiscellaneousText
1128: FROM okc_k_articles_b kartb, okc_articles_all art, okc_article_versions ver
1129: WHERE kartb.document_id = DRAFTID
1130: AND kartb.sav_sae_id = art.article_id
1131: AND kartb.article_version_id = ver.article_version_id
1132: AND art.article_id = ver.article_id
2866: Decode(art.standard_yn,'Y',decode(article_type,'FAR','http://www.arnet.gov',
2867: 'DFARS','http://www.acq.osd.mil/dpap/dars/index.html',
2868: ' '),
2869: nvl(ver.REFERENCE_SOURCE,' ')) RegulationURL
2870: FROM okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver, po_headers_merge_v poh, okc_sections_b scn
2871: WHERE
2872: poh.draft_id = p_draftid AND poh.change_status IS NOT NULL
2873: AND kartb.sav_sae_id = art.article_id
2874: AND kartb.article_version_id = ver.article_version_id
2883: Decode(art.standard_yn,'Y',decode(article_type,'FAR','http://www.arnet.gov',
2884: 'DFARS','http://www.acq.osd.mil/dpap/dars/index.html',
2885: ' '),
2886: nvl(ver.REFERENCE_SOURCE,' ')) RegulationURL
2887: FROM okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver, po_headers_merge_v poh, okc_sections_b scn
2888: WHERE
2889: poh.po_header_id = p_docid AND poh.draft_id = -1 AND poh.change_status is NULL
2890: AND kartb.sav_sae_id = art.article_id
2891: AND kartb.article_version_id = ver.article_version_id
2901: Decode(art.standard_yn,'Y',decode(article_type,'FAR','http://www.arnet.gov',
2902: 'DFARS','http://www.acq.osd.mil/dpap/dars/index.html',
2903: ' '),
2904: nvl(ver.REFERENCE_SOURCE,' ')) RegulationURL
2905: FROM okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver, po_headers_merge_v poh, okc_sections_b scn
2906: WHERE
2907: poh.po_header_id = p_docid AND poh.draft_id = -1 AND poh.change_status is NULL
2908: AND kartb.sav_sae_id = art.article_id
2909: AND kartb.article_version_id = ver.article_version_id
2918: Decode(art.standard_yn,'Y',decode(article_type,'FAR','http://www.arnet.gov',
2919: 'DFARS','http://www.acq.osd.mil/dpap/dars/index.html',
2920: ' '),
2921: nvl(ver.REFERENCE_SOURCE,' ')) RegulationURL
2922: FROM okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver, po_headers_merge_v poh, okc_sections_b scn
2923: WHERE
2924: poh.draft_id = p_draftid AND poh.change_status IS NOT NULL
2925: AND kartb.sav_sae_id = art.article_id
2926: AND kartb.article_version_id = ver.article_version_id
2952: decode(artmod.ARTICLE_NUMBER, artorig.ARTICLE_NUMBER, NULL, ' Clause Number Changed.') CHANGE2,
2953: decode(artmod.ARTICLE_TITLE, artorig.ARTICLE_TITLE, NULL, ' Clause Title Changed.') CHANGE3,
2954: decode(vermod.START_DATE, verorig.START_DATE, NULL, ' Clause Effective Date Changed.') CHANGE4,
2955: decode(dbms_lob.compare(vermod.article_text,verorig.article_text),0,NULL,' Clause Text Changed.') CHANGE5
2956: from okc_k_articles_b kartborig, okc_k_articles_b kartbmod, okc_articles_all artorig, okc_articles_all artmod, okc_article_versions verorig,
2957: okc_article_versions vermod
2958: where kartbmod.id = p_kartid
2959: and kartbmod.orig_system_reference_id1 = kartborig.id
2960: and artmod.article_id = vermod.article_id