APPS.IES_DEPL_SCRIPT_PKG dependencies on IES_DEPLOYED_SCRIPTS

Line 20: FROM ies_deployed_scripts

16: l_script_id NUMBER;
17: BEGIN
18: SELECT dscript_id
19: INTO l_script_id
20: FROM ies_deployed_scripts
21: WHERE dscript_name = p_script_name
22: AND dscript_lang_id = (SELECT language_id
23: FROM fnd_languages
24: WHERE nls_language = p_script_language)

Line 68: EXECUTE IMMEDIATE 'UPDATE ies_deployed_scripts SET lock_status = 1 '||

64: x_return_status := FND_API.G_RET_STS_SUCCESS;
65:
66: BEGIN
67: -- API body
68: EXECUTE IMMEDIATE 'UPDATE ies_deployed_scripts SET lock_status = 1 '||
69: 'WHERE DSCRIPT_ID = :dscriptId' USING p_dscript_id;
70:
71: EXCEPTION
72: WHEN OTHERS THEN

Line 184: FROM ies_deployed_scripts

180: x_return_status := FND_API.G_RET_STS_SUCCESS;
181: BEGIN
182: SELECT dscript_id
183: INTO l_dscript_id
184: FROM ies_deployed_scripts
185: WHERE dscript_name = (SELECT dscript_name
186: FROM ies_deployed_scripts
187: WHERE dscript_id = p_dscript_id)
188: AND dscript_lang_id = (SELECT dscript_lang_id

Line 186: FROM ies_deployed_scripts

182: SELECT dscript_id
183: INTO l_dscript_id
184: FROM ies_deployed_scripts
185: WHERE dscript_name = (SELECT dscript_name
186: FROM ies_deployed_scripts
187: WHERE dscript_id = p_dscript_id)
188: AND dscript_lang_id = (SELECT dscript_lang_id
189: FROM ies_deployed_scripts
190: WHERE dscript_id = p_dscript_id)

Line 189: FROM ies_deployed_scripts

185: WHERE dscript_name = (SELECT dscript_name
186: FROM ies_deployed_scripts
187: WHERE dscript_id = p_dscript_id)
188: AND dscript_lang_id = (SELECT dscript_lang_id
189: FROM ies_deployed_scripts
190: WHERE dscript_id = p_dscript_id)
191: AND active_status = 1;
192:
193: lock_deployed_script(p_api_version ,