APPS.OKC_UTIL dependencies on OKC_TERMS_TEMPLATES_ALL

Line 3310: SELECT TEMPLATE_ID FROM okc_terms_templates_all

3306: CURSOR get_doc_usage_crs IS
3307: SELECT TEMPLATE_ID FROM okc_template_usages_v
3308: WHERE document_type = x_doc_type AND document_id = x_doc_id ;
3309: CURSOR get_apps_upg_tmpl_id_crs IS
3310: SELECT TEMPLATE_ID FROM okc_terms_templates_all
3311: WHERE template_name = l_tmpl_name and org_id=l_org_id;
3312: BEGIN
3313: IF (l_debug = 'Y') THEN
3314: okc_debug.log('11400: Entering Prepare_Contract_Terms ', 2);

Line 3348: SELECT OKC_TERMS_TEMPLATES_ALL_S.NEXTVAL

3344: FETCH get_apps_upg_tmpl_id_crs INTO l_tmpl_id;
3345: CLOSE get_apps_upg_tmpl_id_crs;
3346:
3347: IF l_tmpl_id IS NULL THEN
3348: SELECT OKC_TERMS_TEMPLATES_ALL_S.NEXTVAL
3349: INTO l_tmpl_id FROM DUAL;
3350: INSERT INTO OKC_TERMS_TEMPLATES_ALL(
3351: TEMPLATE_NAME,
3352: TEMPLATE_ID,

Line 3350: INSERT INTO OKC_TERMS_TEMPLATES_ALL(

3346:
3347: IF l_tmpl_id IS NULL THEN
3348: SELECT OKC_TERMS_TEMPLATES_ALL_S.NEXTVAL
3349: INTO l_tmpl_id FROM DUAL;
3350: INSERT INTO OKC_TERMS_TEMPLATES_ALL(
3351: TEMPLATE_NAME,
3352: TEMPLATE_ID,
3353: WORKING_COPY_FLAG,
3354: INTENT,