APPS.OKC_REVIEW_UPLD_TERMS_PVT dependencies on OKC_TEMPLATE_USAGES

Line 1944: select doc_numbering_scheme from okc_template_usages

1940: START WITH new_parent_id is null
1941: ORDER SIBLINGS BY review_upld_terms_id;
1942:
1943: cursor current_num_scheme is
1944: select doc_numbering_scheme from okc_template_usages
1945: where document_type = p_document_type and
1946: document_id = p_document_id;
1947:
1948: CURSOR is_article_ibr (p_review_upld_terms_id NUMBER) is

Line 2521: OKC_TEMPLATE_USAGES_GRP.update_template_usages(

2517: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2518: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14600: Before delete on Review Tables');
2519: END IF;
2520:
2521: OKC_TEMPLATE_USAGES_GRP.update_template_usages(
2522: p_api_version => l_api_version,
2523: p_init_msg_list => p_init_msg_list ,
2524: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2525: p_commit => FND_API.G_FALSE,

Line 2838: l_doc_num_scheme OKC_TEMPLATE_USAGES.DOC_NUMBERING_SCHEME%TYPE;

2834: l_clause_title FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
2835: l_section_title FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
2836: l_clause_counter NUMBER;
2837: l_section_counter NUMBER;
2838: l_doc_num_scheme OKC_TEMPLATE_USAGES.DOC_NUMBERING_SCHEME%TYPE;
2839: l_user_access VARCHAR2(30);
2840: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2841: l_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
2842: l_count NUMBER;

Line 3049: select doc_numbering_scheme from okc_template_usages

3045: document_id = p_document_id and
3046: object_title is null
3047: and object_type IN ('ARTICLE', 'SECTION');
3048: cursor current_num_scheme is
3049: select doc_numbering_scheme from okc_template_usages
3050: where document_type = p_document_type and
3051: document_id = p_document_id;
3052:
3053:

Line 3979: OKC_TEMPLATE_USAGES_GRP.update_template_usages(

3975: set warning_message_count = upd_csr.err_warn_count
3976: where review_upld_terms_id = upd_csr.review_upld_terms_id;
3977: end if;
3978: end loop;
3979: OKC_TEMPLATE_USAGES_GRP.update_template_usages(
3980: p_api_version => l_api_version,
3981: p_init_msg_list => p_init_msg_list ,
3982: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3983: p_commit => FND_API.G_FALSE,