APPS.OKC_NUMBER_SCHEME_GRP dependencies on OKC_K_ARTICLES_B

Line 403: SELECT ID,'ARTICLE' TYPE,display_sequence display_sequence from okc_k_ARTICLES_b

399: and document_id = p_doc_id
400: AND nvl(amendment_operation_code,'?') <> 'DELETED'
401: AND nvl(summary_amend_operation_code,'?') <> 'DELETED'
402: UNION
403: SELECT ID,'ARTICLE' TYPE,display_sequence display_sequence from okc_k_ARTICLES_b
404: where scn_id=p_scn_id
405: and document_type=p_doc_type
406: and document_id = p_doc_id
407: AND nvl(amendment_operation_code,'?') <> 'DELETED'

Line 747: FROM okc_k_articles_b

743: where document_type=p_doc_type and document_id=p_doc_id;
744:
745: CURSOR l_get_art_csr IS
746: SELECT id,object_version_number
747: FROM okc_k_articles_b
748: WHERE document_type=p_doc_type
749: AND document_id=p_doc_id
750: AND nvl(amendment_operation_code,'?') <> 'DELETED'
751: AND nvl(summary_amend_operation_code,'?') <> 'DELETED'

Line 870: -- update okc_k_articles_b

866: SET label = NULL
867: WHERE document_type = p_doc_type
868: AND document_id = p_doc_id ;
869:
870: -- update okc_k_articles_b
871: UPDATE okc_k_articles_b
872: SET label = NULL
873: WHERE document_type = p_doc_type
874: AND document_id = p_doc_id ;

Line 871: UPDATE okc_k_articles_b

867: WHERE document_type = p_doc_type
868: AND document_id = p_doc_id ;
869:
870: -- update okc_k_articles_b
871: UPDATE okc_k_articles_b
872: SET label = NULL
873: WHERE document_type = p_doc_type
874: AND document_id = p_doc_id ;
875: