1 PACKAGE IBY_PP_MLSUTL_PVT AUTHID CURRENT_USER AS
2 /* $Header: ibyppmus.pls 120.10.12010000.1 2008/07/28 05:42:00 appldev ship $ */
3
4
5 -- validation sets
6
7 procedure VAL_SET_INSERT_ROW (
8 X_ROWID in out NOCOPY VARCHAR2,
9 X_VALIDATION_SET_CODE in VARCHAR2,
10 X_VALIDATION_LEVEL_CODE in VARCHAR2,
11 X_VALIDATION_CODE_PACKAGE in VARCHAR2,
12 X_VALIDATION_CODE_ENTRY_POINT in VARCHAR2,
13 X_VALIDATION_CODE_LANGUAGE in VARCHAR2,
14 X_OBJECT_VERSION_NUMBER in NUMBER,
15 X_VALIDATION_SET_DISPLAY_NAME in VARCHAR2,
16 X_CREATION_DATE in DATE,
17 X_CREATED_BY in NUMBER,
18 X_LAST_UPDATE_DATE in DATE,
19 X_LAST_UPDATED_BY in NUMBER,
20 X_LAST_UPDATE_LOGIN in NUMBER);
21
22 procedure VAL_SET_UPDATE_ROW (
23 X_VALIDATION_SET_CODE in VARCHAR2,
24 X_VALIDATION_LEVEL_CODE in VARCHAR2,
25 X_VALIDATION_CODE_PACKAGE in VARCHAR2,
26 X_VALIDATION_CODE_ENTRY_POINT in VARCHAR2,
27 X_VALIDATION_CODE_LANGUAGE in VARCHAR2,
28 X_OBJECT_VERSION_NUMBER in NUMBER,
29 X_VALIDATION_SET_DISPLAY_NAME in VARCHAR2,
30 X_LAST_UPDATE_DATE in DATE,
31 X_LAST_UPDATED_BY in NUMBER,
32 X_LAST_UPDATE_LOGIN in NUMBER
33 );
34
35 procedure VAL_SET_DELETE_ROW (
36 X_VALIDATION_SET_CODE in VARCHAR2
37 );
38
39 procedure VAL_SET_ADD_LANGUAGE;
40
41 procedure VAL_SET_LOAD_ROW (
42 X_VALIDATION_SET_CODE in VARCHAR2,
43 X_VALIDATION_LEVEL_CODE in VARCHAR2,
44 X_VALIDATION_CODE_PACKAGE in VARCHAR2,
45 X_VALIDATION_CODE_ENTRY_POINT in VARCHAR2,
46 X_VALIDATION_CODE_LANGUAGE in VARCHAR2,
47 X_OBJECT_VERSION_NUMBER in NUMBER,
48 X_VALIDATION_SET_DISPLAY_NAME in VARCHAR2,
49 X_LAST_UPDATE_DATE in DATE,
50 X_OWNER in VARCHAR2);
51
52 procedure VAL_SET_TRANSLATE_ROW (
53 X_VALIDATION_SET_CODE in VARCHAR2,
54 X_OBJECT_VERSION_NUMBER in NUMBER,
55 X_VALIDATION_SET_DISPLAY_NAME in VARCHAR2,
56 X_LAST_UPDATE_DATE in DATE,
57 X_OWNER in VARCHAR2);
58
59
60 -- validation set parameters
61
62 procedure VAL_PARAM_INSERT_ROW (
63 X_ROWID in out NOCOPY VARCHAR2,
64 X_VALIDATION_SET_CODE in VARCHAR2,
65 X_VALIDATION_PARAMETER_CODE in VARCHAR2,
66 X_VALIDATION_PARAMETER_TYPE in VARCHAR2,
67 X_VALIDATION_PARAM_DISPLAY_ORD in NUMBER,
68 X_OBJECT_VERSION_NUMBER in NUMBER,
69 X_VALIDATION_PARAM_DISPLAY_NAM in VARCHAR2,
70 X_CREATION_DATE in DATE,
71 X_CREATED_BY in NUMBER,
72 X_LAST_UPDATE_DATE in DATE,
73 X_LAST_UPDATED_BY in NUMBER,
74 X_LAST_UPDATE_LOGIN in NUMBER
75 );
76
77 procedure VAL_PARAM_UPDATE_ROW (
78 X_VALIDATION_SET_CODE in VARCHAR2,
79 X_VALIDATION_PARAMETER_CODE in VARCHAR2,
80 X_VALIDATION_PARAMETER_TYPE in VARCHAR2,
81 X_VALIDATION_PARAM_DISPLAY_ORD in NUMBER,
82 X_OBJECT_VERSION_NUMBER in NUMBER,
83 X_VALIDATION_PARAM_DISPLAY_NAM in VARCHAR2,
84 X_LAST_UPDATE_DATE in DATE,
85 X_LAST_UPDATED_BY in NUMBER,
86 X_LAST_UPDATE_LOGIN in NUMBER
87 );
88
89 procedure VAL_PARAM_DELETE_ROW (
90 X_VALIDATION_SET_CODE in VARCHAR2,
91 X_VALIDATION_PARAMETER_CODE in VARCHAR2
92 );
93
94 procedure VAL_PARAM_ADD_LANGUAGE;
95
96 procedure VAL_PARAM_LOAD_ROW (
97 X_VALIDATION_SET_CODE in VARCHAR2,
98 X_VALIDATION_PARAMETER_CODE in VARCHAR2,
99 X_VALIDATION_PARAMETER_TYPE in VARCHAR2,
100 X_VALIDATION_PARAM_DISPLAY_ORD in NUMBER,
101 X_OBJECT_VERSION_NUMBER in NUMBER,
102 X_VALIDATION_PARAM_DISPLAY_NAM in VARCHAR2,
103 X_LAST_UPDATE_DATE in DATE,
104 X_OWNER in VARCHAR2);
105
106 procedure VAL_PARAM_TRANSLATE_ROW (
107 X_VALIDATION_SET_CODE in VARCHAR2,
108 X_VALIDATION_PARAMETER_CODE in VARCHAR2,
109 X_OBJECT_VERSION_NUMBER in NUMBER,
110 X_VALIDATION_PARAM_DISPLAY_NAM in VARCHAR2,
111 X_LAST_UPDATE_DATE in DATE,
112 X_OWNER in VARCHAR2);
113
114
115 -- transmission protocols
116
117 procedure TRANS_PROT_INSERT_ROW (
118 X_ROWID in out NOCOPY VARCHAR2,
119 X_TRANSMIT_PROTOCOL_CODE in VARCHAR2,
120 X_OBJECT_VERSION_NUMBER in NUMBER,
121 X_TRANSMIT_CODE_LANGUAGE in VARCHAR2,
122 X_TRANSMIT_CODE_PACKAGE in VARCHAR2,
123 X_TRANSMIT_CODE_ENTRY_POINT in VARCHAR2,
124 X_TRANSMIT_PROTOCOL_NAME in VARCHAR2,
125 X_CREATION_DATE in DATE,
126 X_CREATED_BY in NUMBER,
127 X_LAST_UPDATE_DATE in DATE,
128 X_LAST_UPDATED_BY in NUMBER,
129 X_LAST_UPDATE_LOGIN in NUMBER);
130
131 procedure TRANS_PROT_UPDATE_ROW (
132 X_TRANSMIT_PROTOCOL_CODE in VARCHAR2,
133 X_OBJECT_VERSION_NUMBER in NUMBER,
134 X_TRANSMIT_CODE_LANGUAGE in VARCHAR2,
135 X_TRANSMIT_CODE_PACKAGE in VARCHAR2,
136 X_TRANSMIT_CODE_ENTRY_POINT in VARCHAR2,
137 X_TRANSMIT_PROTOCOL_NAME in VARCHAR2,
138 X_LAST_UPDATE_DATE in DATE,
139 X_LAST_UPDATED_BY in NUMBER,
140 X_LAST_UPDATE_LOGIN in NUMBER
141 );
142
143 procedure TRANS_PROT_DELETE_ROW (
144 X_TRANSMIT_PROTOCOL_CODE in VARCHAR2
145 );
146
147 procedure TRANS_PROT_ADD_LANGUAGE;
148
149 procedure TRANS_PROT_LOAD_ROW (
150 X_TRANSMIT_PROTOCOL_CODE in VARCHAR2,
151 X_OBJECT_VERSION_NUMBER in NUMBER,
152 X_TRANSMIT_CODE_LANGUAGE in VARCHAR2,
153 X_TRANSMIT_CODE_PACKAGE in VARCHAR2,
154 X_TRANSMIT_CODE_ENTRY_POINT in VARCHAR2,
155 X_TRANSMIT_PROTOCOL_NAME in VARCHAR2,
156 X_LAST_UPDATE_DATE in DATE,
157 X_OWNER in VARCHAR2);
158
159 procedure TRANS_PROT_TRANSLATE_ROW (
160 X_TRANSMIT_PROTOCOL_CODE in VARCHAR2,
161 X_OBJECT_VERSION_NUMBER in NUMBER,
162 X_TRANSMIT_PROTOCOL_NAME in VARCHAR2,
163 X_LAST_UPDATE_DATE in DATE,
164 X_OWNER in VARCHAR2);
165
166
167 -- transmission parameters
168
169 procedure TRANS_PARAM_INSERT_ROW (
170 X_ROWID in out NOCOPY VARCHAR2,
171 X_TRANSMIT_PROTOCOL_CODE in VARCHAR2,
172 X_TRANSMIT_PARAMETER_CODE in VARCHAR2,
173 X_TRANSMIT_PARAMETER_TYPE in VARCHAR2,
174 X_MANDATORY_FLAG in VARCHAR2,
175 X_DISPLAY_ORDER in NUMBER,
176 X_DYNAMIC_FLAG in VARCHAR2,
177 X_DYN_CODE_LANGUAGE in VARCHAR2,
178 X_DYN_CODE_PACKAGE in VARCHAR2,
179 X_DYN_CODE_ENTRY_POINT in VARCHAR2,
180 X_SECURED_FLAG in VARCHAR2,
181 X_OBJECT_VERSION_NUMBER in NUMBER,
182 X_TRANSMIT_PARAMETER_NAME in VARCHAR2,
183 X_CREATION_DATE in DATE,
184 X_CREATED_BY in NUMBER,
185 X_LAST_UPDATE_DATE in DATE,
186 X_LAST_UPDATED_BY in NUMBER,
187 X_LAST_UPDATE_LOGIN in NUMBER);
188
189 procedure TRANS_PARAM_UPDATE_ROW (
190 X_TRANSMIT_PROTOCOL_CODE in VARCHAR2,
191 X_TRANSMIT_PARAMETER_CODE in VARCHAR2,
192 X_TRANSMIT_PARAMETER_TYPE in VARCHAR2,
193 X_MANDATORY_FLAG in VARCHAR2,
194 X_DISPLAY_ORDER in NUMBER,
195 X_DYNAMIC_FLAG in VARCHAR2,
196 X_DYN_CODE_LANGUAGE in VARCHAR2,
197 X_DYN_CODE_PACKAGE in VARCHAR2,
198 X_DYN_CODE_ENTRY_POINT in VARCHAR2,
199 X_SECURED_FLAG in VARCHAR2,
200 X_OBJECT_VERSION_NUMBER in NUMBER,
201 X_TRANSMIT_PARAMETER_NAME in VARCHAR2,
202 X_LAST_UPDATE_DATE in DATE,
203 X_LAST_UPDATED_BY in NUMBER,
204 X_LAST_UPDATE_LOGIN in NUMBER
205 );
206
207 procedure TRANS_PARAM_DELETE_ROW (
208 X_TRANSMIT_PROTOCOL_CODE in VARCHAR2,
209 X_TRANSMIT_PARAMETER_CODE in VARCHAR2
210 );
211
212 procedure TRANS_PARAM_ADD_LANGUAGE;
213
214 procedure TRANS_PARAM_LOAD_ROW (
215 X_TRANSMIT_PROTOCOL_CODE in VARCHAR2,
216 X_TRANSMIT_PARAMETER_CODE in VARCHAR2,
217 X_TRANSMIT_PARAMETER_TYPE in VARCHAR2,
218 X_MANDATORY_FLAG in VARCHAR2,
219 X_DISPLAY_ORDER in NUMBER,
220 X_DYNAMIC_FLAG in VARCHAR2,
221 X_DYN_CODE_LANGUAGE in VARCHAR2,
222 X_DYN_CODE_PACKAGE in VARCHAR2,
223 X_DYN_CODE_ENTRY_POINT in VARCHAR2,
224 X_SECURED_FLAG in VARCHAR2,
225 X_OBJECT_VERSION_NUMBER in NUMBER,
226 X_TRANSMIT_PARAMETER_NAME in VARCHAR2,
227 X_LAST_UPDATE_DATE in DATE,
228 X_OWNER in VARCHAR2);
229
230 procedure TRANS_PARAM_TRANSLATE_ROW (
231 X_TRANSMIT_PROTOCOL_CODE in VARCHAR2,
232 X_TRANSMIT_PARAMETER_CODE in VARCHAR2,
233 X_OBJECT_VERSION_NUMBER in NUMBER,
234 X_TRANSMIT_PARAMETER_NAME in VARCHAR2,
235 X_LAST_UPDATE_DATE in DATE,
236 X_OWNER in VARCHAR2);
237
238
239 -- transmission configurations
240
241 procedure TRANS_CONFIG_INSERT_ROW (
242 X_ROWID in out NOCOPY VARCHAR2,
243 X_TRANSMIT_CONFIGURATION_ID in NUMBER,
244 X_OBJECT_VERSION_NUMBER in NUMBER,
245 X_TUNNELING_TRANS_CONFIG_ID in NUMBER,
246 X_TRANSMIT_PROTOCOL_CODE in VARCHAR2,
247 X_INACTIVE_DATE in DATE,
248 X_TRANSMIT_CONFIGURATION_NAME in VARCHAR2,
249 X_CREATION_DATE in DATE,
250 X_CREATED_BY in NUMBER,
251 X_LAST_UPDATE_DATE in DATE,
252 X_LAST_UPDATED_BY in NUMBER,
253 X_LAST_UPDATE_LOGIN in NUMBER);
254
255 procedure TRANS_CONFIG_UPDATE_ROW (
256 X_TRANSMIT_CONFIGURATION_ID in NUMBER,
257 X_OBJECT_VERSION_NUMBER in NUMBER,
258 X_TUNNELING_TRANS_CONFIG_ID in NUMBER,
259 X_TRANSMIT_PROTOCOL_CODE in VARCHAR2,
260 X_INACTIVE_DATE in DATE,
261 X_TRANSMIT_CONFIGURATION_NAME in VARCHAR2,
262 X_LAST_UPDATE_DATE in DATE,
263 X_LAST_UPDATED_BY in NUMBER,
264 X_LAST_UPDATE_LOGIN in NUMBER
265 );
266
267 procedure TRANS_CONFIG_DELETE_ROW (
268 X_TRANSMIT_CONFIGURATION_ID in NUMBER
269 );
270
271 procedure TRANS_CONFIG_ADD_LANGUAGE;
272
273 END IBY_PP_MLSUTL_PVT;