1 PACKAGE IES_PANELS_PVT AUTHID CURRENT_USER AS
2 /* $Header: iesvieps.pls 115.9 2002/12/09 21:13:45 appldev ship $ */
3 PROCEDURE Insert_Panel
4 ( p_api_version IN NUMBER := 1 ,
5 p_init_msg_list IN VARCHAR2 := 'DUMMY VAL' ,
6 p_commit IN VARCHAR2 := 'DUMMY VAL' ,
7 p_validation_level IN NUMBER := 1 ,
8 x_return_status OUT NOCOPY VARCHAR2 ,
9 x_msg_count OUT NOCOPY NUMBER ,
10 x_msg_data OUT NOCOPY VARCHAR2 ,
11 p_created_by IN NUMBER ,
12 p_dscript_id IN NUMBER ,
13 p_panel_name IN VARCHAR2 ,
14 p_panel_uid IN VARCHAR2 ,
15 p_active_status IN NUMBER ,
16 x_panel_id OUT NOCOPY NUMBER
17 );
18
19 PROCEDURE Insert_Panel
20 ( p_api_version IN NUMBER := 1 ,
21 p_init_msg_list IN VARCHAR2 := 'DUMMY VAL' ,
22 p_commit IN VARCHAR2 := 'DUMMY VAL' ,
23 p_validation_level IN NUMBER := 1 ,
24 x_return_status OUT NOCOPY VARCHAR2 ,
25 x_msg_count OUT NOCOPY NUMBER ,
26 x_msg_data OUT NOCOPY VARCHAR2 ,
27 p_created_by IN NUMBER ,
28 p_dscript_id IN NUMBER ,
29 p_panel_name IN VARCHAR2 ,
30 p_panel_label IN VARCHAR2 ,
31 p_panel_uid IN VARCHAR2 ,
32 p_active_status IN NUMBER ,
33 x_panel_id OUT NOCOPY NUMBER
34 );
35
36 PROCEDURE Update_Panel
37 ( p_api_version IN NUMBER := 1 ,
38 p_init_msg_list IN VARCHAR2 := 'DUMMY VAL' ,
39 p_commit IN VARCHAR2 := 'DUMMY VAL' ,
40 p_validation_level IN NUMBER := 1 ,
41 x_return_status OUT NOCOPY VARCHAR2 ,
42 x_msg_count OUT NOCOPY NUMBER ,
43 x_msg_data OUT NOCOPY VARCHAR2 ,
44 p_panel_id IN NUMBER ,
45 p_last_updated_by IN NUMBER ,
46 p_panel_name IN VARCHAR2 ,
47 p_panel_uid IN VARCHAR2 ,
48 p_active_status IN NUMBER ,
49 x_panel_id OUT NOCOPY NUMBER
50 );
51
52 PROCEDURE Update_Panel
53 ( p_api_version IN NUMBER := 1 ,
54 p_init_msg_list IN VARCHAR2 := 'DUMMY VAL' ,
55 p_commit IN VARCHAR2 := 'DUMMY VAL' ,
56 p_validation_level IN NUMBER := 1 ,
57 x_return_status OUT NOCOPY VARCHAR2 ,
58 x_msg_count OUT NOCOPY NUMBER ,
59 x_msg_data OUT NOCOPY VARCHAR2 ,
60 p_panel_id IN NUMBER ,
61 p_last_updated_by IN NUMBER ,
62 p_panel_name IN VARCHAR2 ,
63 p_panel_label IN VARCHAR2 ,
64 p_panel_uid IN VARCHAR2 ,
65 p_active_status IN NUMBER ,
66 x_panel_id OUT NOCOPY NUMBER
67 );
68 END;