[Home] [Help]
PACKAGE: APPS.ICX_QUESTIONS_ADMIN
Source
1 package icx_questions_admin AUTHID CURRENT_USER as
2 /* $Header: ICXQUADS.pls 115.1 1999/12/09 22:54:04 pkm ship $ */
3
4 /*===========================================================================
5
6 Function FIND_QUESTIONS
7
8 Purpose Search For Questions based on a variety of context
9
10 ============================================================================*/
11 procedure FIND_QUESTIONS;
12
13 /*===========================================================================
14
15 Function DISPLAY_QUESTIONS
16
17 Purpose Display a list of existing questions based on the
18 query criteria provided
19
20 ============================================================================*/
21 procedure DISPLAY_QUESTIONS
22 (
23 P_APPLICATION_SHORT_NAME IN VARCHAR2 DEFAULT NULL,
24 P_QUESTION_CODE IN VARCHAR2 DEFAULT NULL,
25 P_QUESTION IN VARCHAR2 DEFAULT NULL
26 );
27
28
29 /*===========================================================================
30
31 Function EDIT_QUESTION
32
33 Purpose Edit a question code or content
34
35 ============================================================================*/
36 procedure EDIT_QUESTION
37 (
38 P_APPLICATION_ID IN VARCHAR2 DEFAULT NULL,
39 P_APPLICATION_SHORT_NAME IN VARCHAR2 DEFAULT NULL,
40 P_QUESTION_CODE IN VARCHAR2 DEFAULT NULL,
41 P_ERROR_MESSAGE IN VARCHAR2 DEFAULT NULL,
42 P_QUESTION IN VARCHAR2 DEFAULT NULL,
43 P_FIND_CRITERIA IN VARCHAR2 DEFAULT NULL,
44 P_INSERT IN VARCHAR2 DEFAULT NULL
45 );
46
47 /*===========================================================================
48
49 Function INSERT_QUESTION
50
51 Purpose Insert a new question
52
53 ============================================================================*/
54 procedure INSERT_QUESTION
55 (
56 P_APPLICATION_ID IN VARCHAR2 DEFAULT NULL,
57 P_QUESTION_CODE IN VARCHAR2 DEFAULT NULL,
58 P_APPLICATION_SHORT_NAME IN VARCHAR2 DEFAULT NULL,
59 P_QUESTION IN VARCHAR2 DEFAULT NULL,
60 P_FIND_CRITERIA IN VARCHAR2 DEFAULT NULL
61 );
62
63 /*===========================================================================
64
65 Function UPDATE_QUESTION
66
67 Purpose Phyically update the question content
68
69 ============================================================================*/
70 procedure UPDATE_QUESTION
71 (
72 P_APPLICATION_ID IN VARCHAR2 DEFAULT NULL,
73 P_QUESTION_CODE IN VARCHAR2 DEFAULT NULL,
74 P_APPLICATION_SHORT_NAME IN VARCHAR2 DEFAULT NULL,
75 P_QUESTION IN VARCHAR2 DEFAULT NULL,
76 P_FIND_CRITERIA IN VARCHAR2 DEFAULT NULL
77 );
78
79 /*===========================================================================
80
81 Function question_confirm_delete
82
83 Purpose Confirm the delete of the question content
84
85 ============================================================================*/
86 procedure question_confirm_delete
87 (p_application_id IN VARCHAR2 DEFAULT NULL,
88 p_question_code IN VARCHAR2 DEFAULT NULL,
89 p_find_criteria IN VARCHAR2 DEFAULT NULL
90 );
91
92 /*===========================================================================
93
94 Function DELETE_QUESTION
95
96 Purpose Delete a new question
97
98 ============================================================================*/
99 procedure DELETE_QUESTION
100 (
101 P_APPLICATION_ID IN VARCHAR2 DEFAULT NULL,
102 P_QUESTION_CODE IN VARCHAR2 DEFAULT NULL,
103 P_FIND_CRITERIA IN VARCHAR2 DEFAULT NULL
104 );
105
106
107 /*===========================================================================
108
109 Function DISPLAY_FUNCTIONS
110
111 Purpose Display a list of existing questions based on the query criteria provided
112
113 ============================================================================*/
114 procedure DISPLAY_FUNCTIONS
115 (
116 P_QUESTION_CODE IN VARCHAR2 DEFAULT NULL,
117 P_FIND_CRITERIA IN VARCHAR2 DEFAULT NULL
118
119 );
120
121 /*===========================================================================
122
123 Function application_LOV
124
125 Purpose Create the data for the applications list of values
126
127 ============================================================================*/
128 procedure application_LOV (
129 p_mode in varchar2,
130 p_lov_name in varchar2,
131 p_start_row in number,
132 p_max_rows in number,
133 p_hidden_value in out varchar2,
134 p_display_value in out varchar2,
135 p_result out number);
136
137
138 /*===========================================================================
139
140 Function EDIT_FUNCTION
141
142 Purpose Edit function content
143
144 ============================================================================*/
145 procedure EDIT_FUNCTION
146 (
147 P_QUESTION_CODE IN VARCHAR2 DEFAULT NULL,
148 P_FUNCTION_ID IN VARCHAR2 DEFAULT NULL,
149 P_FUNCTION_NAME IN VARCHAR2 DEFAULT NULL,
150 P_INSERT IN VARCHAR2 DEFAULT NULL,
151 P_ERROR_MESSAGE IN VARCHAR2 DEFAULT NULL,
152 P_FIND_CRITERIA IN VARCHAR2 DEFAULT NULL
153 );
154
155
156 /*===========================================================================
157
158 Function FUNCTION_LOV
159
160 Purpose Create the data for the function list of values
161
162 ============================================================================*/
163 procedure function_lov (
164 p_mode in varchar2,
165 p_lov_name in varchar2,
166 p_start_row in number,
167 p_max_rows in number,
168 p_hidden_value in out varchar2,
169 p_display_value in out varchar2,
170 p_result out number);
171
172 /*===========================================================================
173
174 Function INSERT_FUNCTION
175
176 Purpose Insert an existing function
177
178 ============================================================================*/
179 procedure INSERT_FUNCTION
180 (
181 P_FUNCTION_ID IN VARCHAR2 DEFAULT NULL,
182 P_OLD_FUNCTION_NAME IN VARCHAR2 DEFAULT NULL,
183 P_FUNCTION_NAME IN VARCHAR2 DEFAULT NULL,
184 P_USER_FUNCTION_NAME IN VARCHAR2 DEFAULT NULL,
185 P_QUESTION_CODE IN VARCHAR2 DEFAULT NULL,
186 P_FIND_CRITERIA IN VARCHAR2 DEFAULT NULL
187 );
188
189 /*===========================================================================
190
191 Function UPDATE_FUNCTION
192
193 Purpose Update an existing function
194
195 ============================================================================*/
196 procedure UPDATE_FUNCTION
197 (
198 P_FUNCTION_ID IN VARCHAR2 DEFAULT NULL,
199 P_OLD_FUNCTION_NAME IN VARCHAR2 DEFAULT NULL,
200 P_FUNCTION_NAME IN VARCHAR2 DEFAULT NULL,
201 p_USER_FUNCTION_NAME IN VARCHAR2 DEFAULT NULL,
202 P_QUESTION_CODE IN VARCHAR2 DEFAULT NULL,
203 P_FIND_CRITERIA IN VARCHAR2 DEFAULT NULL
204 );
205
206 /*===========================================================================
207
208 Function DELETE_FUNCTION
209
210 Purpose Delete an existing function
211
212 ============================================================================*/
213
214 procedure DELETE_FUNCTION
215 (
216 P_FUNCTION_ID IN VARCHAR2 DEFAULT NULL,
217 P_FUNCTION_NAME IN VARCHAR2 DEFAULT NULL,
218 P_QUESTION_CODE IN VARCHAR2 DEFAULT NULL,
219 P_FIND_CRITERIA IN VARCHAR2 DEFAULT NULL
220 );
221
222 end icx_questions_admin;