DBA Data[Home] [Help]

PACKAGE: APPS.IBY_PP_MLSUTL_PVT

Source


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;