APPS.IES_DEPLOYED_SCRIPTS_PVT dependencies on IES_DEPLOYED_SCRIPTS

Line 1: PACKAGE BODY IES_DEPLOYED_SCRIPTS_PVT AS

1: PACKAGE BODY IES_DEPLOYED_SCRIPTS_PVT AS
2: /* $Header: iesvidsb.pls 115.7 2002/12/09 21:13:40 appldev ship $ */
3:
4: PROCEDURE Insert_Deployed_Scripts
5: ( p_api_version IN NUMBER := 1 ,

Line 27: INSERT INTO ies_deployed_scripts ( dscript_id ,

23: IS
24: BEGIN
25: -- Standard Start of API savepoint
26: SAVEPOINT Insert_Deployed_Scripts_PVT;
27: INSERT INTO ies_deployed_scripts ( dscript_id ,
28: created_by ,
29: creation_date ,
30: dscript_lang_id ,
31: panel_table_id ,

Line 41: VALUES ( ies_deployed_scripts_s.nextval ,

37: script_type ,
38: description ,
39: dscript_file ,
40: schema_mapping )
41: VALUES ( ies_deployed_scripts_s.nextval ,
42: p_created_by ,
43: sysdate ,
44: p_dscript_lang_id ,
45: p_panel_table_id ,

Line 87: UPDATE ies_deployed_scripts

83: ) IS
84: BEGIN
85: -- Standard Start of API savepoint
86: SAVEPOINT Update_Deployed_Scripts_PVT;
87: UPDATE ies_deployed_scripts
88: SET last_updated_by = p_last_updated_by ,
89: last_update_date = sysdate ,
90: dscript_lang_id = p_dscript_lang_id ,
91: panel_table_id = p_panel_table_id ,

Line 140: delete from ies_deployed_scripts where dscript_id = p_dscript_id;

136: delete from ies_lookups where dscript_id = p_dscript_id;
137:
138: delete from ies_panels where dscript_id = p_dscript_id;
139:
140: delete from ies_deployed_scripts where dscript_id = p_dscript_id;
141:
142: x_return_status := 'S';
143:
144: EXCEPTION

Line 152: END IES_Deployed_Scripts_PVT;

148: x_msg_data := 'Error ' || TO_CHAR(SQLCODE) ||':'||SQLERRM;
149: END Delete_Deployed_Scripts;
150:
151:
152: END IES_Deployed_Scripts_PVT;