APPS.OKC_TERMS_UTIL_PVT dependencies on OKC_ALLOWED_TMPL_USAGES

Line 66: FROM OKC_ALLOWED_TMPL_USAGES

62:
63:
64: CURSOR l_get_rec IS
65: SELECT allowed_tmpl_usages_id,object_version_number
66: FROM OKC_ALLOWED_TMPL_USAGES
67: WHERE TEMPLATE_ID = p_template_id;
68: BEGIN
69:
70: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 76: OKC_ALLOWED_TMPL_USAGES_GRP.Delete_Allowed_Tmpl_Usages(

72: END IF;
73:
74: FOR cr IN l_get_rec LOOP
75:
76: OKC_ALLOWED_TMPL_USAGES_GRP.Delete_Allowed_Tmpl_Usages(
77: p_api_version => 1,
78: p_init_msg_list => FND_API.G_FALSE,
79: p_commit => FND_API.G_FALSE,
80: x_return_status => x_return_status,

Line 147: FROM OKC_ALLOWED_TMPL_USAGES

143: ) IS
144: l_api_name CONSTANT VARCHAR2(30) := 'Update_Allowed_Tmpl_Usages_Id';
145: CURSOR l_get_rec IS
146: SELECT allowed_tmpl_usages_id,object_version_number,document_type,default_yn
147: FROM OKC_ALLOWED_TMPL_USAGES
148: WHERE TEMPLATE_ID = p_old_template_id;
149: BEGIN
150: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
151: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1100: Entered Update_Allowed_Tmpl_Usages_Id');

Line 157: OKC_ALLOWED_TMPL_USAGES_GRP.update_Allowed_Tmpl_Usages(

153: END IF;
154:
155: FOR cr in l_get_rec LOOP
156:
157: OKC_ALLOWED_TMPL_USAGES_GRP.update_Allowed_Tmpl_Usages(
158: p_api_version => 1,
159: p_init_msg_list => FND_API.G_FALSE,
160: p_commit => FND_API.G_FALSE,
161: x_return_status => x_return_status,

Line 318: -- Delete the record from OKC_ALLOWED_TMPL_USAGES_V

314: RAISE FND_API.G_EXC_ERROR;
315: END IF;
316:
317: --------------------------------------------
318: -- Delete the record from OKC_ALLOWED_TMPL_USAGES_V
319: --------------------------------------------
320: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
321: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3300: Delete each record from OKC_ALLOWED_TMPL_USAGES_V in a loop');
322: END IF;

Line 321: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3300: Delete each record from OKC_ALLOWED_TMPL_USAGES_V in a loop');

317: --------------------------------------------
318: -- Delete the record from OKC_ALLOWED_TMPL_USAGES_V
319: --------------------------------------------
320: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
321: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3300: Delete each record from OKC_ALLOWED_TMPL_USAGES_V in a loop');
322: END IF;
323: --------------------------------------------
324: ALLOWED_TMPL_USAGES_Delete_Set(
325: x_return_status => x_return_status,

Line 818: FROM OKC_ALLOWED_TMPL_USAGES

814: WHERE template_id=p_template_id;
815:
816: CURSOR atu_csr IS
817: SELECT template_id, document_type
818: FROM OKC_ALLOWED_TMPL_USAGES
819: WHERE TEMPLATE_ID = l_base_template_id;
820:
821: CURSOR kart_csr IS
822: SELECT id, object_version_number

Line 1911: FROM okc_allowed_tmpl_usages

1907: WHERE template_id = p_template_id
1908: AND working_copy_flag = 'Y'
1909: UNION ALL
1910: SELECT 1
1911: FROM okc_allowed_tmpl_usages
1912: WHERE template_id = p_template_id
1913: UNION ALL
1914: SELECT 1
1915: FROM okc_k_articles_b

Line 3120: okc_allowed_tmpl_usages a, okc_terms_templates_all b

3116:
3117: cursor l_get_dflt_tmpl_dtls_csr is
3118: select a.template_id, b.template_name
3119: from
3120: okc_allowed_tmpl_usages a, okc_terms_templates_all b
3121: where a.template_id = b.template_id
3122: and a.default_yn = 'Y'
3123: and b.status_code = 'APPROVED'
3124: and a.document_type = p_document_type