1 PACKAGE IES_DEPLOYED_SCRIPTS_PVT AUTHID CURRENT_USER AS
2 /* $Header: iesvidss.pls 115.8 2002/12/09 21:13:38 appldev ship $ */
3
4 PROCEDURE Insert_Deployed_Scripts
5 ( p_api_version IN NUMBER := 1 ,
6 p_init_msg_list IN VARCHAR2 := 'DUMMY VAL' ,
7 p_commit IN VARCHAR2 := 'DUMMY VAL' ,
8 p_validation_level IN NUMBER := 1 ,
9 x_return_status OUT NOCOPY VARCHAR2 ,
10 x_msg_count OUT NOCOPY NUMBER ,
11 x_msg_data OUT NOCOPY VARCHAR2 ,
12 p_created_by IN NUMBER ,
13 p_dscript_lang_id IN NUMBER ,
14 p_panel_table_id IN NUMBER ,
15 p_question_table_id IN NUMBER ,
16 p_dscript_name IN VARCHAR2 ,
17 p_active_status IN NUMBER ,
18 p_application_id IN NUMBER ,
19 p_function_id IN NUMBER ,
20 p_script_type IN VARCHAR2 ,
21 p_description IN VARCHAR2 ,
22 x_dscript_id OUT NOCOPY NUMBER
23 );
24
25 PROCEDURE Update_Deployed_Scripts
26 ( p_api_version IN NUMBER := 1 ,
27 p_init_msg_list IN VARCHAR2 := 'DUMMY VAL' ,
28 p_commit IN VARCHAR2 := 'DUMMY VAL' ,
29 p_validation_level IN NUMBER := 1 ,
30 x_return_status OUT NOCOPY VARCHAR2 ,
31 x_msg_count OUT NOCOPY NUMBER ,
32 x_msg_data OUT NOCOPY VARCHAR2 ,
33 p_dscript_id IN NUMBER ,
34 p_last_updated_by IN NUMBER ,
35 p_dscript_lang_id IN NUMBER ,
36 p_panel_table_id IN NUMBER ,
37 p_question_table_id IN NUMBER ,
38 p_dscript_name IN VARCHAR2 ,
39 p_active_status IN NUMBER ,
40 p_application_id IN NUMBER ,
41 p_function_id IN NUMBER ,
42 p_script_type IN VARCHAR2 ,
43 p_description IN VARCHAR2 ,
44 x_dscript_id OUT NOCOPY NUMBER
45 );
46
47 PROCEDURE Delete_Deployed_Scripts
48 ( p_api_version IN NUMBER := 1,
49 p_init_msg_list IN VARCHAR2 := 'DUMMY VAL',
50 p_commit IN VARCHAR2 := 'DUMMY VAL',
51 p_validation_level IN NUMBER := 1,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2,
55 p_dscript_id IN NUMBER
56 );
57
58 END;