APPS.OKC_REVIEW_UPLD_TERMS_PVT dependencies on OKC_TEMPLATE_USAGES

Line 1980: select doc_numbering_scheme from okc_template_usages

1976: ORDER SIBLINGS BY review_upld_terms_id;
1977:
1978:
1979: cursor current_num_scheme is
1980: select doc_numbering_scheme from okc_template_usages
1981: where document_type = p_document_type and
1982: document_id = p_document_id;
1983:
1984: CURSOR is_article_ibr (p_review_upld_terms_id NUMBER) is

Line 2623: OKC_TEMPLATE_USAGES_GRP.update_template_usages(

2619: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2620: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14600: Before delete on Review Tables');
2621: END IF;
2622:
2623: OKC_TEMPLATE_USAGES_GRP.update_template_usages(
2624: p_api_version => l_api_version,
2625: p_init_msg_list => p_init_msg_list ,
2626: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2627: p_commit => FND_API.G_FALSE,

Line 2947: l_doc_num_scheme OKC_TEMPLATE_USAGES.DOC_NUMBERING_SCHEME%TYPE;

2943: l_clause_title FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
2944: l_section_title FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
2945: l_clause_counter NUMBER;
2946: l_section_counter NUMBER;
2947: l_doc_num_scheme OKC_TEMPLATE_USAGES.DOC_NUMBERING_SCHEME%TYPE;
2948: l_user_access VARCHAR2(30);
2949: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2950: l_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
2951: l_count NUMBER;

Line 3158: select doc_numbering_scheme from okc_template_usages

3154: document_id = p_document_id and
3155: object_title is null
3156: and object_type IN ('ARTICLE', 'SECTION');
3157: cursor current_num_scheme is
3158: select doc_numbering_scheme from okc_template_usages
3159: where document_type = p_document_type and
3160: document_id = p_document_id;
3161:
3162:

Line 4140: OKC_TEMPLATE_USAGES_GRP.update_template_usages(

4136: set warning_message_count = upd_csr.err_warn_count
4137: where review_upld_terms_id = upd_csr.review_upld_terms_id;
4138: end if;
4139: end loop;
4140: OKC_TEMPLATE_USAGES_GRP.update_template_usages(
4141: p_api_version => l_api_version,
4142: p_init_msg_list => p_init_msg_list ,
4143: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4144: p_commit => FND_API.G_FALSE,