APPS.OKC_TEMPLATE_USAGES_PVT dependencies on OKC_ALLOWED_TMPL_USAGES

Line 2325: FROM OKC_ALLOWED_TMPL_USAGES

2321: E_Resource_Busy EXCEPTION;
2322: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2323: CURSOR lock_csr IS
2324: SELECT template_id
2325: FROM OKC_ALLOWED_TMPL_USAGES
2326: WHERE TEMPLATE_ID = p_old_template_id
2327: FOR UPDATE OF template_id NOWAIT;
2328: BEGIN
2329: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2341: UPDATE okc_allowed_tmpl_usages

2337: --------------------------------------------
2338: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2339: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1300: Updating the Set');
2340: END IF;
2341: UPDATE okc_allowed_tmpl_usages
2342: SET template_id = p_new_template_id ,
2343: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
2344: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2345: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

Line 2385: FROM OKC_ALLOWED_TMPL_USAGES

2381: E_Resource_Busy EXCEPTION;
2382: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2383: CURSOR lock_csr IS
2384: SELECT rowid
2385: FROM OKC_ALLOWED_TMPL_USAGES
2386: WHERE TEMPLATE_ID = p_template_id
2387: FOR UPDATE NOWAIT;
2388: BEGIN
2389: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2402: FROM OKC_ALLOWED_TMPL_USAGES

2398: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2399: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: Deleting the Set');
2400: END IF;
2401: DELETE
2402: FROM OKC_ALLOWED_TMPL_USAGES
2403: WHERE TEMPLATE_ID = p_template_id;
2404: --------------------------------------------
2405: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2406: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: Leaving Delete_Set');