APPS.OKC_TEMPLATE_USAGES_PVT dependencies on OKC_ALLOWED_TMPL_USAGES

Line 2280: FROM OKC_ALLOWED_TMPL_USAGES

2276: E_Resource_Busy EXCEPTION;
2277: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2278: CURSOR lock_csr IS
2279: SELECT template_id
2280: FROM OKC_ALLOWED_TMPL_USAGES
2281: WHERE TEMPLATE_ID = p_old_template_id
2282: FOR UPDATE OF template_id NOWAIT;
2283: BEGIN
2284: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2296: UPDATE okc_allowed_tmpl_usages

2292: --------------------------------------------
2293: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2294: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1300: Updating the Set');
2295: END IF;
2296: UPDATE okc_allowed_tmpl_usages
2297: SET template_id = p_new_template_id ,
2298: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
2299: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2300: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

Line 2340: FROM OKC_ALLOWED_TMPL_USAGES

2336: E_Resource_Busy EXCEPTION;
2337: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2338: CURSOR lock_csr IS
2339: SELECT rowid
2340: FROM OKC_ALLOWED_TMPL_USAGES
2341: WHERE TEMPLATE_ID = p_template_id
2342: FOR UPDATE NOWAIT;
2343: BEGIN
2344: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2357: FROM OKC_ALLOWED_TMPL_USAGES

2353: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2354: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: Deleting the Set');
2355: END IF;
2356: DELETE
2357: FROM OKC_ALLOWED_TMPL_USAGES
2358: WHERE TEMPLATE_ID = p_template_id;
2359: --------------------------------------------
2360: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2361: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: Leaving Delete_Set');