[Home] [Help]
866: AND document_id = p_template_id;
867:
868: CURSOR sect_csr IS
869: SELECT id, object_version_number
870: FROM okc_sections_b
871: WHERE document_type=G_TMPL_DOC_TYPE
872: AND document_id = p_template_id;
873:
874: BEGIN
1609: l_sequence NUMBER;
1610:
1611: Cursor l_get_max_seq_csr IS
1612: SELECT nvl(max(section_sequence),0)+10
1613: FROM OKC_SECTIONS_B
1614: WHERE DOCUMENT_TYPE= p_doc_type
1615: AND DOCUMENT_ID = p_doc_id
1616: AND SCN_ID IS NULL;
1617:
1632: -- Initialize API return status to success
1633: x_return_status := G_RET_STS_SUCCESS;
1634:
1635: --------------------------------------------
1636: -- Call Simple API of okc_sections_b with following input
1637: -- doc_type=p_doc_type, doc_id=p_doc_id, scn_code=G_UNASSIGNED_SECTION_CODE,
1638: -- heading = < get meaning of G_UNASSIGNED_SECTION_CODE by quering fnd_lookups>.
1639: -- Set x_scn_id to id returned by simpel API.
1640: --------------------------------------------
2119: AND (kart.amendment_operation_code IS NOT NULL OR
2120: kart.summary_amend_operation_code IS NOT NULL)
2121: UNION ALL
2122: SELECT 1
2123: FROM okc_sections_b scn,
2124: okc_template_usages usg
2125: WHERE usg.document_type = p_document_type
2126: AND usg.document_id = p_document_id
2127: AND NVL(usg.contract_source_code,'STRUCTURED') = 'STRUCTURED'
2301: FUNCTION get_section_label(p_scn_id IN NUMBER)
2302: RETURN Varchar2 IS
2303: CURSOR csr_section_label IS
2304: SELECT heading
2305: FROM okc_sections_b
2306: WHERE id = p_scn_id;
2307:
2308: l_label VARCHAR2(240);
2309:
2435: RETURN VARCHAR2 IS
2436:
2437: -- Fix for Bug 5377982
2438: -- l_name varchar2(80) := null;
2439: l_name OKC_SECTIONS_B.HEADING%TYPE := null;
2440:
2441:
2442:
2443: cursor section_cur(l_section_id NUMBER) is
2440:
2441:
2442:
2443: cursor section_cur(l_section_id NUMBER) is
2444: select HEADING FROM OKC_SECTIONS_B WHERE ID = l_section_id ;
2445:
2446: cursor section_for_article_id(l_article_id NUMBER) is
2447: select HEADING FROM OKC_SECTIONS_B WHERE ID = (select scn_id from okc_k_articles_b where id = l_article_id) ;
2448:
2443: cursor section_cur(l_section_id NUMBER) is
2444: select HEADING FROM OKC_SECTIONS_B WHERE ID = l_section_id ;
2445:
2446: cursor section_for_article_id(l_article_id NUMBER) is
2447: select HEADING FROM OKC_SECTIONS_B WHERE ID = (select scn_id from okc_k_articles_b where id = l_article_id) ;
2448:
2449:
2450: BEGIN
2451:
3349: 'S' If the scn_id is NOT deleted and exists
3350: */
3351: CURSOR csr_check_section IS
3352: SELECT amendment_operation_code,summary_amend_operation_code
3353: FROM okc_sections_b
3354: WHERE id = p_scn_id;
3355: l_api_name CONSTANT VARCHAR2(30) := 'is_section_deleted';
3356: l_amendment_operation_code VARCHAR2(30);
3357: l_summary_amend_operation_code VARCHAR2(30);
3845: IS
3846: l_api_name CONSTANT VARCHAR2(30) := 'create_tmpl_clauses_to_submit';
3847: l_effective_date DATE;
3848: l_article_id OKC_ARTICLES_ALL.ARTICLE_ID%TYPE;
3849: l_section_name OKC_SECTIONS_B.HEADING%TYPE;
3850: l_article_label OKC_SECTIONS_B.LABEL%TYPE;
3851: l_multiple_sections VARCHAR2(1);
3852: l_return_status VARCHAR2(1);
3853: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
3846: l_api_name CONSTANT VARCHAR2(30) := 'create_tmpl_clauses_to_submit';
3847: l_effective_date DATE;
3848: l_article_id OKC_ARTICLES_ALL.ARTICLE_ID%TYPE;
3849: l_section_name OKC_SECTIONS_B.HEADING%TYPE;
3850: l_article_label OKC_SECTIONS_B.LABEL%TYPE;
3851: l_multiple_sections VARCHAR2(1);
3852: l_return_status VARCHAR2(1);
3853: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
3854: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
3883: */
3884:
3885: CURSOR sec_name_csr (cp_template_id NUMBER, cp_article_id NUMBER)IS
3886: SELECT osb.heading, nvl(oka.label, '-98766554433.77'),osb.label section_label
3887: FROM okc_sections_b osb,okc_k_articles_b oka
3888: WHERE oka.document_id = cp_template_id
3889: AND oka.sav_sae_id = cp_article_id
3890: AND oka.scn_id = osb.id
3891: AND rownum < 3;
3937: -- muteshev bug#4327485 end
3938:
3939: TYPE draft_articles_tbl_type is TABLE of draft_articles_csr%ROWTYPE INDEX BY BINARY_INTEGER;
3940: TYPE sec_details_tbl_type is TABLE of sec_name_csr%ROWTYPE INDEX BY BINARY_INTEGER ;
3941: TYPE section_label_tbl_type IS TABLE of OKC_SECTIONS_B.LABEL%TYPE INDEX BY BINARY_INTEGER ;
3942: TYPE article_id_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
3943: TYPE article_version_id_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER ;
3944: TYPE section_name_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.SECTION_NAME%TYPE INDEX BY BINARY_INTEGER ;
3945: TYPE article_label_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_LABEL%TYPE INDEX BY BINARY_INTEGER ;
5017: AND DOCUMENT_ID=p_document_id;
5018:
5019: Cursor l_get_max_scn_date_csr IS
5020: SELECT max(Nvl(LAST_UPDATE_DATE,CREATION_DATE))
5021: FROM OKC_SECTIONS_B
5022: WHERE DOCUMENT_TYPE=p_document_type
5023: AND DOCUMENT_ID=p_document_id;
5024:
5025: Cursor l_get_max_var_date_csr IS