APPS.OKC_TERMS_COPY_GRP dependencies on OKC_TERMS_TEMPLATES_ALL

Line 589: SELECT * FROM OKC_TERMS_TEMPLATES_ALL

585: l_dummy VARCHAR2(1) :='?';
586: l_deliverables_exist VARCHAR2(100);
587:
588: CURSOR l_get_tmpl_csr IS
589: SELECT * FROM OKC_TERMS_TEMPLATES_ALL
590: WHERE template_id=p_template_id;
591:
592: CURSOR l_check_tmpl_name_csr(b_org_id NUMBER) IS
593: SELECT 'x' FROM OKC_TERMS_TEMPLATES_ALL

Line 593: SELECT 'x' FROM OKC_TERMS_TEMPLATES_ALL

589: SELECT * FROM OKC_TERMS_TEMPLATES_ALL
590: WHERE template_id=p_template_id;
591:
592: CURSOR l_check_tmpl_name_csr(b_org_id NUMBER) IS
593: SELECT 'x' FROM OKC_TERMS_TEMPLATES_ALL
594: WHERE org_id=b_org_id
595: AND template_name=p_tmpl_name;
596:
597: l_tmpl_rec l_get_tmpl_csr%ROWTYPE;

Line 1232: SELECT * FROM OKC_TERMS_TEMPLATES_ALL

1228: l_document_type OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE%TYPE := OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE;
1229: l_copy_deliverables VARCHAR2(1);
1230:
1231: CURSOR l_get_tmpl_csr IS
1232: SELECT * FROM OKC_TERMS_TEMPLATES_ALL
1233: WHERE template_id=p_template_id;
1234:
1235: l_tmpl_rec l_get_tmpl_csr%ROWTYPE;
1236: BEGIN