[Home] [Help]
825: AND document_id = p_template_id;
826:
827: CURSOR sect_csr IS
828: SELECT id, object_version_number
829: FROM okc_sections_b
830: WHERE document_type=G_TMPL_DOC_TYPE
831: AND document_id = p_template_id;
832:
833: BEGIN
1567: l_sequence NUMBER;
1568:
1569: Cursor l_get_max_seq_csr IS
1570: SELECT nvl(max(section_sequence),0)+10
1571: FROM OKC_SECTIONS_B
1572: WHERE DOCUMENT_TYPE= p_doc_type
1573: AND DOCUMENT_ID = p_doc_id
1574: AND SCN_ID IS NULL;
1575:
1590: -- Initialize API return status to success
1591: x_return_status := G_RET_STS_SUCCESS;
1592:
1593: --------------------------------------------
1594: -- Call Simple API of okc_sections_b with following input
1595: -- doc_type=p_doc_type, doc_id=p_doc_id, scn_code=G_UNASSIGNED_SECTION_CODE,
1596: -- heading = < get meaning of G_UNASSIGNED_SECTION_CODE by quering fnd_lookups>.
1597: -- Set x_scn_id to id returned by simpel API.
1598: --------------------------------------------
2077: AND (kart.amendment_operation_code IS NOT NULL OR
2078: kart.summary_amend_operation_code IS NOT NULL)
2079: UNION ALL
2080: SELECT 1
2081: FROM okc_sections_b scn,
2082: okc_template_usages usg
2083: WHERE usg.document_type = p_document_type
2084: AND usg.document_id = p_document_id
2085: AND NVL(usg.contract_source_code,'STRUCTURED') = 'STRUCTURED'
2259: FUNCTION get_section_label(p_scn_id IN NUMBER)
2260: RETURN Varchar2 IS
2261: CURSOR csr_section_label IS
2262: SELECT heading
2263: FROM okc_sections_b
2264: WHERE id = p_scn_id;
2265:
2266: l_label VARCHAR2(240);
2267:
2393: RETURN VARCHAR2 IS
2394:
2395: -- Fix for Bug 5377982
2396: -- l_name varchar2(80) := null;
2397: l_name OKC_SECTIONS_B.HEADING%TYPE := null;
2398:
2399:
2400:
2401: cursor section_cur(l_section_id NUMBER) is
2398:
2399:
2400:
2401: cursor section_cur(l_section_id NUMBER) is
2402: select HEADING FROM OKC_SECTIONS_B WHERE ID = l_section_id ;
2403:
2404: cursor section_for_article_id(l_article_id NUMBER) is
2405: select HEADING FROM OKC_SECTIONS_B WHERE ID = (select scn_id from okc_k_articles_b where id = l_article_id) ;
2406:
2401: cursor section_cur(l_section_id NUMBER) is
2402: select HEADING FROM OKC_SECTIONS_B WHERE ID = l_section_id ;
2403:
2404: cursor section_for_article_id(l_article_id NUMBER) is
2405: select HEADING FROM OKC_SECTIONS_B WHERE ID = (select scn_id from okc_k_articles_b where id = l_article_id) ;
2406:
2407:
2408: BEGIN
2409:
3307: 'S' If the scn_id is NOT deleted and exists
3308: */
3309: CURSOR csr_check_section IS
3310: SELECT amendment_operation_code,summary_amend_operation_code
3311: FROM okc_sections_b
3312: WHERE id = p_scn_id;
3313: l_api_name CONSTANT VARCHAR2(30) := 'is_section_deleted';
3314: l_amendment_operation_code VARCHAR2(30);
3315: l_summary_amend_operation_code VARCHAR2(30);
3796: IS
3797: l_api_name CONSTANT VARCHAR2(30) := 'create_tmpl_clauses_to_submit';
3798: l_effective_date DATE;
3799: l_article_id OKC.OKC_ARTICLES_ALL.ARTICLE_ID%TYPE;
3800: l_section_name OKC.OKC_SECTIONS_B.HEADING%TYPE;
3801: l_article_label OKC.OKC_SECTIONS_B.LABEL%TYPE;
3802: l_multiple_sections VARCHAR2(1);
3803: l_return_status VARCHAR2(1);
3804: l_start_date OKC.OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
3797: l_api_name CONSTANT VARCHAR2(30) := 'create_tmpl_clauses_to_submit';
3798: l_effective_date DATE;
3799: l_article_id OKC.OKC_ARTICLES_ALL.ARTICLE_ID%TYPE;
3800: l_section_name OKC.OKC_SECTIONS_B.HEADING%TYPE;
3801: l_article_label OKC.OKC_SECTIONS_B.LABEL%TYPE;
3802: l_multiple_sections VARCHAR2(1);
3803: l_return_status VARCHAR2(1);
3804: l_start_date OKC.OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
3805: l_end_date OKC.OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
3834: */
3835:
3836: CURSOR sec_name_csr (cp_template_id NUMBER, cp_article_id NUMBER)IS
3837: SELECT osb.heading, nvl(oka.label, '-98766554433.77'),osb.label section_label
3838: FROM okc_sections_b osb,okc_k_articles_b oka
3839: WHERE oka.document_id = cp_template_id
3840: AND oka.sav_sae_id = cp_article_id
3841: AND oka.scn_id = osb.id
3842: AND rownum < 3;
3888: -- muteshev bug#4327485 end
3889:
3890: TYPE draft_articles_tbl_type is TABLE of draft_articles_csr%ROWTYPE INDEX BY BINARY_INTEGER;
3891: TYPE sec_details_tbl_type is TABLE of sec_name_csr%ROWTYPE INDEX BY BINARY_INTEGER ;
3892: TYPE section_label_tbl_type IS TABLE of OKC_SECTIONS_B.LABEL%TYPE INDEX BY BINARY_INTEGER ;
3893: TYPE article_id_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
3894: TYPE article_version_id_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER ;
3895: TYPE section_name_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.SECTION_NAME%TYPE INDEX BY BINARY_INTEGER ;
3896: TYPE article_label_tbl_type IS TABLE of OKC_TMPL_DRAFT_CLAUSES.ARTICLE_LABEL%TYPE INDEX BY BINARY_INTEGER ;
4968: AND DOCUMENT_ID=p_document_id;
4969:
4970: Cursor l_get_max_scn_date_csr IS
4971: SELECT max(Nvl(LAST_UPDATE_DATE,CREATION_DATE))
4972: FROM OKC_SECTIONS_B
4973: WHERE DOCUMENT_TYPE=p_document_type
4974: AND DOCUMENT_ID=p_document_id;
4975:
4976: Cursor l_get_max_var_date_csr IS