APPS.OKC_NUMBER_SCHEME_GRP dependencies on OKC_SECTIONS_B

Line 396: SELECT ID,'SECTION' TYPE,section_sequence display_sequence from okc_sections_b

392:
393: procedure section_numbering(p_doc_type varchar2,p_doc_id NUMBER,p_level NUMBER,p_parent_label VARCHAR2,p_scn_id NUMBER) IS
394:
395: cursor l_get_child_csr IS
396: SELECT ID,'SECTION' TYPE,section_sequence display_sequence from okc_sections_b
397: where scn_id=p_scn_id
398: and document_type=p_doc_type
399: and document_id = p_doc_id
400: AND nvl(amendment_operation_code,'?') <> 'DELETED'

Line 725: SELECT ID,section_sequence from okc_sections_b

721: l_api_version NUMBER :=1;
722: l_api_name VARCHAR2(30) := 'apply_numbering_scheme';
723:
724: cursor l_get_child_csr IS
725: SELECT ID,section_sequence from okc_sections_b
726: where document_type = p_doc_type
727: AND document_id = p_doc_id
728: AND SCN_ID IS NULL
729: AND nvl(amendment_operation_code,'?') <> 'DELETED'

Line 864: -- update okc_sections_b

860: END IF;
861:
862: --IF l_dtl_count = 0 THEN
863: -- do bulk update on sections and articles records
864: -- update okc_sections_b
865: UPDATE okc_sections_b
866: SET label = NULL
867: WHERE document_type = p_doc_type
868: AND document_id = p_doc_id ;

Line 865: UPDATE okc_sections_b

861:
862: --IF l_dtl_count = 0 THEN
863: -- do bulk update on sections and articles records
864: -- update okc_sections_b
865: UPDATE okc_sections_b
866: SET label = NULL
867: WHERE document_type = p_doc_type
868: AND document_id = p_doc_id ;
869: