APPS.OKC_TERMS_COPY_GRP dependencies on OKC_TERMS_TEMPLATES_ALL

Line 471: SELECT * FROM OKC_TERMS_TEMPLATES_ALL

467: l_dummy VARCHAR2(1) :='?';
468: l_deliverables_exist VARCHAR2(100);
469:
470: CURSOR l_get_tmpl_csr IS
471: SELECT * FROM OKC_TERMS_TEMPLATES_ALL
472: WHERE template_id=p_template_id;
473:
474: CURSOR l_check_tmpl_name_csr(b_org_id NUMBER) IS
475: SELECT 'x' FROM OKC_TERMS_TEMPLATES_ALL

Line 475: SELECT 'x' FROM OKC_TERMS_TEMPLATES_ALL

471: SELECT * FROM OKC_TERMS_TEMPLATES_ALL
472: WHERE template_id=p_template_id;
473:
474: CURSOR l_check_tmpl_name_csr(b_org_id NUMBER) IS
475: SELECT 'x' FROM OKC_TERMS_TEMPLATES_ALL
476: WHERE org_id=b_org_id
477: AND template_name=p_tmpl_name;
478:
479: l_tmpl_rec l_get_tmpl_csr%ROWTYPE;

Line 1097: SELECT * FROM OKC_TERMS_TEMPLATES_ALL

1093: l_document_type OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE%TYPE := OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE;
1094: l_copy_deliverables VARCHAR2(1);
1095:
1096: CURSOR l_get_tmpl_csr IS
1097: SELECT * FROM OKC_TERMS_TEMPLATES_ALL
1098: WHERE template_id=p_template_id;
1099:
1100: l_tmpl_rec l_get_tmpl_csr%ROWTYPE;
1101: BEGIN