1 PACKAGE IES_QUESTIONS_PVT AUTHID CURRENT_USER AS
2 /* $Header: iesvieqs.pls 120.0 2005/06/03 07:45:33 appldev noship $ */
3
4 PROCEDURE Insert_Question
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_panel_id IN NUMBER ,
14 p_lookup_id IN NUMBER ,
15 p_node_name IN VARCHAR2 ,
16 p_node_uid IN VARCHAR2 ,
17 p_active_status IN NUMBER ,
18 x_question_id OUT NOCOPY NUMBER
19 );
20
21 PROCEDURE Insert_Question
22 ( p_api_version IN NUMBER := 1 ,
23 p_init_msg_list IN VARCHAR2 := 'DUMMY VAL' ,
24 p_commit IN VARCHAR2 := 'DUMMY VAL' ,
25 p_validation_level IN NUMBER := 1 ,
26 x_return_status OUT NOCOPY VARCHAR2 ,
27 x_msg_count OUT NOCOPY NUMBER ,
28 x_msg_data OUT NOCOPY VARCHAR2 ,
29 p_created_by IN NUMBER ,
30 p_panel_id IN NUMBER ,
31 p_question_type_id IN NUMBER ,
32 p_lookup_id IN NUMBER ,
33 p_node_name IN VARCHAR2 ,
34 p_node_uid IN VARCHAR2 ,
35 p_question_label IN VARCHAR2 ,
36 p_active_status IN NUMBER ,
37 x_question_id OUT NOCOPY NUMBER
38 );
39
40 PROCEDURE Insert_Question
41 ( p_api_version IN NUMBER := 1 ,
42 p_init_msg_list IN VARCHAR2 := 'DUMMY VAL' ,
43 p_commit IN VARCHAR2 := 'DUMMY VAL' ,
44 p_validation_level IN NUMBER := 1 ,
45 x_return_status OUT NOCOPY VARCHAR2 ,
46 x_msg_count OUT NOCOPY NUMBER ,
47 x_msg_data OUT NOCOPY VARCHAR2 ,
48 p_created_by IN NUMBER ,
49 p_panel_id IN NUMBER ,
50 p_question_type_id IN NUMBER ,
51 p_lookup_id IN NUMBER ,
52 p_node_name IN VARCHAR2 ,
53 p_node_uid IN VARCHAR2 ,
54 p_question_label IN VARCHAR2 ,
55 p_active_status IN NUMBER ,
56 p_question_order IN NUMBER ,
57 x_question_id OUT NOCOPY NUMBER
58 );
59
60
61 PROCEDURE Update_Question
62 ( p_api_version IN NUMBER := 1 ,
63 p_init_msg_list IN VARCHAR2 := 'DUMMY VAL' ,
64 p_commit IN VARCHAR2 := 'DUMMY VAL' ,
65 p_validation_level IN NUMBER := 1 ,
66 x_return_status OUT NOCOPY VARCHAR2 ,
67 x_msg_count OUT NOCOPY NUMBER ,
68 x_msg_data OUT NOCOPY VARCHAR2 ,
69 p_question_id IN NUMBER ,
70 p_lookup_id IN NUMBER ,
71 p_last_updated_by IN NUMBER ,
72 p_node_name IN VARCHAR2 ,
73 p_node_uid IN VARCHAR2 ,
74 p_active_status IN NUMBER ,
75 x_question_id OUT NOCOPY NUMBER
76 );
77
78 PROCEDURE Update_Question
79 ( p_api_version IN NUMBER := 1 ,
80 p_init_msg_list IN VARCHAR2 := 'DUMMY VAL' ,
81 p_commit IN VARCHAR2 := 'DUMMY VAL' ,
82 p_validation_level IN NUMBER := 1 ,
83 x_return_status OUT NOCOPY VARCHAR2 ,
84 x_msg_count OUT NOCOPY NUMBER ,
85 x_msg_data OUT NOCOPY VARCHAR2 ,
86 p_question_id IN NUMBER ,
87 p_question_type_id IN NUMBER ,
88 p_lookup_id IN NUMBER ,
89 p_last_updated_by IN NUMBER ,
90 p_node_name IN VARCHAR2 ,
91 p_node_uid IN VARCHAR2 ,
92 p_question_label IN VARCHAR2 ,
93 p_active_status IN NUMBER ,
94 x_question_id OUT NOCOPY NUMBER
95 );
96
97 PROCEDURE Update_Question
98 ( p_api_version IN NUMBER := 1 ,
99 p_init_msg_list IN VARCHAR2 := 'DUMMY VAL' ,
100 p_commit IN VARCHAR2 := 'DUMMY VAL' ,
101 p_validation_level IN NUMBER := 1 ,
102 x_return_status OUT NOCOPY VARCHAR2 ,
103 x_msg_count OUT NOCOPY NUMBER ,
104 x_msg_data OUT NOCOPY VARCHAR2 ,
105 p_question_id IN NUMBER ,
106 p_question_type_id IN NUMBER ,
107 p_lookup_id IN NUMBER ,
108 p_last_updated_by IN NUMBER ,
109 p_node_name IN VARCHAR2 ,
110 p_node_uid IN VARCHAR2 ,
111 p_question_label IN VARCHAR2 ,
112 p_active_status IN NUMBER ,
113 p_question_order IN NUMBER ,
114 x_question_id OUT NOCOPY NUMBER
115 );
116
117 END;
[Home] [Help]