APPS.OKC_UTIL dependencies on OKC_TERMS_TEMPLATES_ALL

Line 3322: SELECT TEMPLATE_ID FROM okc_terms_templates_all

3318: CURSOR get_doc_usage_crs IS
3319: SELECT TEMPLATE_ID FROM okc_template_usages_v
3320: WHERE document_type = x_doc_type AND document_id = x_doc_id ;
3321: CURSOR get_apps_upg_tmpl_id_crs IS
3322: SELECT TEMPLATE_ID FROM okc_terms_templates_all
3323: WHERE template_name = l_tmpl_name and org_id=l_org_id;
3324: BEGIN
3325: IF (l_debug = 'Y') THEN
3326: okc_debug.log('11400: Entering Prepare_Contract_Terms ', 2);

Line 3360: SELECT OKC_TERMS_TEMPLATES_ALL_S.NEXTVAL

3356: FETCH get_apps_upg_tmpl_id_crs INTO l_tmpl_id;
3357: CLOSE get_apps_upg_tmpl_id_crs;
3358:
3359: IF l_tmpl_id IS NULL THEN
3360: SELECT OKC_TERMS_TEMPLATES_ALL_S.NEXTVAL
3361: INTO l_tmpl_id FROM DUAL;
3362: INSERT INTO OKC_TERMS_TEMPLATES_ALL(
3363: TEMPLATE_NAME,
3364: TEMPLATE_ID,

Line 3362: INSERT INTO OKC_TERMS_TEMPLATES_ALL(

3358:
3359: IF l_tmpl_id IS NULL THEN
3360: SELECT OKC_TERMS_TEMPLATES_ALL_S.NEXTVAL
3361: INTO l_tmpl_id FROM DUAL;
3362: INSERT INTO OKC_TERMS_TEMPLATES_ALL(
3363: TEMPLATE_NAME,
3364: TEMPLATE_ID,
3365: WORKING_COPY_FLAG,
3366: INTENT,