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 326: -- Delete the record from OKC_ALLOWED_TMPL_USAGES_V

322: RAISE FND_API.G_EXC_ERROR;
323: END IF;
324:
325: --------------------------------------------
326: -- Delete the record from OKC_ALLOWED_TMPL_USAGES_V
327: --------------------------------------------
328: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
329: 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');
330: END IF;

Line 329: 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');

325: --------------------------------------------
326: -- Delete the record from OKC_ALLOWED_TMPL_USAGES_V
327: --------------------------------------------
328: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
329: 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');
330: END IF;
331: --------------------------------------------
332: ALLOWED_TMPL_USAGES_Delete_Set(
333: x_return_status => x_return_status,

Line 859: FROM OKC_ALLOWED_TMPL_USAGES

855: WHERE template_id=p_template_id;
856:
857: CURSOR atu_csr IS
858: SELECT template_id, document_type
859: FROM OKC_ALLOWED_TMPL_USAGES
860: WHERE TEMPLATE_ID = l_base_template_id;
861:
862: CURSOR kart_csr IS
863: SELECT id, object_version_number

Line 1953: FROM okc_allowed_tmpl_usages

1949: WHERE template_id = p_template_id
1950: AND working_copy_flag = 'Y'
1951: UNION ALL
1952: SELECT 1
1953: FROM okc_allowed_tmpl_usages
1954: WHERE template_id = p_template_id
1955: UNION ALL
1956: SELECT 1
1957: FROM okc_k_articles_b

Line 3162: okc_allowed_tmpl_usages a, okc_terms_templates_all b

3158:
3159: cursor l_get_dflt_tmpl_dtls_csr is
3160: select a.template_id, b.template_name
3161: from
3162: okc_allowed_tmpl_usages a, okc_terms_templates_all b
3163: where a.template_id = b.template_id
3164: and a.default_yn = 'Y'
3165: and b.status_code = 'APPROVED'
3166: and a.document_type = p_document_type