APPS.OKC_TERMS_TMPL_APPROVAL_GRP dependencies on OKC_TERMS_TEMPLATES

Line 32: G_TEMPLATE_MISS_REC OKC_TERMS_TEMPLATES_PVT.template_rec_type;

28: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
29: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
30: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
31: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
32: G_TEMPLATE_MISS_REC OKC_TERMS_TEMPLATES_PVT.template_rec_type;
33:
34: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
35: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
36: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;

Line 94: FROM okc_terms_templates

90: l_dummy_var VARCHAR2(1);
91:
92: CURSOR tmpl_csr(pc_template_id NUMBER) IS
93: SELECT object_version_number
94: FROM okc_terms_templates
95: WHERE template_id = pc_template_id;
96:
97: CURSOR article_exists_cur IS
98: SELECT 1