1 PACKAGE FUN_RULE_OBJECTS_PKG AUTHID CURRENT_USER AS
2 /*$Header: FUNXTMRULROBTBS.pls 120.4 2006/01/10 12:16:42 ammishra noship $ */
3
4 PROCEDURE INSERT_ROW (
5 X_ROWID IN OUT NOCOPY VARCHAR2,
6 X_RULE_OBJECT_ID IN NUMBER,
7 X_APPLICATION_ID IN NUMBER,
8 X_RULE_OBJECT_NAME IN VARCHAR2,
9 X_RESULT_TYPE IN VARCHAR2,
10 X_REQUIRED_FLAG IN VARCHAR2,
11 X_USE_DEFAULT_VALUE_FLAG IN VARCHAR2,
12 X_DEFAULT_APPLICATION_ID IN NUMBER,
13 X_DEFAULT_VALUE IN VARCHAR2,
14 X_FLEX_VALUE_SET_ID IN NUMBER,
15 X_FLEXFIELD_NAME IN VARCHAR2,
16 X_FLEXFIELD_APP_SHORT_NAME IN VARCHAR2,
17 X_MULTI_RULE_RESULT_FLAG IN VARCHAR2,
18 X_CREATED_BY_MODULE IN VARCHAR2,
19 X_USER_RULE_OBJECT_NAME IN VARCHAR2,
20 X_DESCRIPTION IN VARCHAR2,
21 X_USE_INSTANCE_FLAG IN VARCHAR2 DEFAULT NULL,
22 X_INSTANCE_LABEL IN VARCHAR2 DEFAULT NULL,
23 X_PARENT_RULE_OBJECT_ID IN NUMBER DEFAULT NULL,
24 X_ORG_ID IN NUMBER DEFAULT NULL,
25 X_CREATION_DATE IN DATE DEFAULT NULL,
26 X_CREATED_BY IN NUMBER DEFAULT NULL,
27 X_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
28 X_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
29 X_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
30 );
31
32 PROCEDURE INSERT_ROW (
33 X_ROWID IN OUT NOCOPY VARCHAR2,
34 X_RULE_OBJECT_ID IN NUMBER,
35 X_APPLICATION_ID IN NUMBER,
36 X_RULE_OBJECT_NAME IN VARCHAR2,
37 X_RESULT_TYPE IN VARCHAR2,
38 X_REQUIRED_FLAG IN VARCHAR2,
39 X_USE_DEFAULT_VALUE_FLAG IN VARCHAR2,
40 X_FLEX_VALUE_SET_ID IN NUMBER,
41 X_FLEXFIELD_NAME IN VARCHAR2,
42 X_FLEXFIELD_APP_SHORT_NAME IN VARCHAR2,
43 X_MULTI_RULE_RESULT_FLAG IN VARCHAR2,
44 X_CREATED_BY_MODULE IN VARCHAR2,
45 X_USER_RULE_OBJECT_NAME IN VARCHAR2,
46 X_DESCRIPTION IN VARCHAR2,
47 X_USE_INSTANCE_FLAG IN VARCHAR2 DEFAULT NULL,
48 X_INSTANCE_LABEL IN VARCHAR2 DEFAULT NULL,
49 X_PARENT_RULE_OBJECT_ID IN NUMBER DEFAULT NULL,
50 X_ORG_ID IN NUMBER DEFAULT NULL,
51 X_CREATION_DATE IN DATE DEFAULT NULL,
52 X_CREATED_BY IN NUMBER DEFAULT NULL,
53 X_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
54 X_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
55 X_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
56 );
57
58 PROCEDURE INSERT_ROW (
59 X_ROWID IN OUT NOCOPY VARCHAR2,
60 X_RULE_OBJECT_ID IN NUMBER,
61 X_APPLICATION_ID IN NUMBER,
62 X_RULE_OBJECT_NAME IN VARCHAR2,
63 X_DEFAULT_APPLICATION_ID IN NUMBER,
64 X_DEFAULT_VALUE IN VARCHAR2,
65 X_CREATION_DATE IN DATE DEFAULT NULL,
66 X_CREATED_BY IN NUMBER DEFAULT NULL,
67 X_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
68 X_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
69 X_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
70 );
71
72 PROCEDURE LOCK_ROW (
73 X_RULE_OBJECT_ID IN NUMBER,
74 X_OBJECT_VERSION_NUMBER IN NUMBER
75 );
76
77 PROCEDURE UPDATE_ROW (
78 X_RULE_OBJECT_ID IN NUMBER,
79 X_APPLICATION_ID IN NUMBER,
80 X_RULE_OBJECT_NAME IN VARCHAR2,
81 X_RESULT_TYPE IN VARCHAR2,
82 X_REQUIRED_FLAG IN VARCHAR2,
83 X_USE_DEFAULT_VALUE_FLAG IN VARCHAR2,
84 X_DEFAULT_APPLICATION_ID IN NUMBER,
85 X_DEFAULT_VALUE IN VARCHAR2,
86 X_FLEX_VALUE_SET_ID IN NUMBER,
87 X_FLEXFIELD_NAME IN VARCHAR2,
88 X_FLEXFIELD_APP_SHORT_NAME IN VARCHAR2,
89 X_MULTI_RULE_RESULT_FLAG IN VARCHAR2,
90 X_OBJECT_VERSION_NUMBER IN NUMBER,
91 X_CREATED_BY_MODULE IN VARCHAR2,
92 X_USER_RULE_OBJECT_NAME IN VARCHAR2,
93 X_DESCRIPTION IN VARCHAR2,
94 X_USE_INSTANCE_FLAG IN VARCHAR2 DEFAULT NULL,
95 X_INSTANCE_LABEL IN VARCHAR2 DEFAULT NULL,
96 X_PARENT_RULE_OBJECT_ID IN NUMBER DEFAULT NULL,
97 X_ORG_ID IN NUMBER DEFAULT NULL,
98 X_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
99 X_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
100 X_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
101 );
102
103 procedure UPDATE_ROW (
104 X_APPLICATION_ID in NUMBER,
105 X_RULE_OBJECT_ID in NUMBER,
106 X_RULE_OBJECT_NAME in VARCHAR2,
107 X_RESULT_TYPE in VARCHAR2,
108 X_REQUIRED_FLAG in VARCHAR2,
109 X_USE_DEFAULT_VALUE_FLAG IN VARCHAR2,
110 X_FLEX_VALUE_SET_ID in NUMBER,
111 X_FLEXFIELD_NAME in VARCHAR2,
112 X_FLEXFIELD_APP_SHORT_NAME in VARCHAR2,
113 X_MULTI_RULE_RESULT_FLAG in VARCHAR2,
114 X_CREATED_BY_MODULE in VARCHAR2,
115 X_USER_RULE_OBJECT_NAME in VARCHAR2,
116 X_DESCRIPTION in VARCHAR2,
117 X_USE_INSTANCE_FLAG IN VARCHAR2 DEFAULT NULL,
118 X_INSTANCE_LABEL IN VARCHAR2 DEFAULT NULL,
119 X_PARENT_RULE_OBJECT_ID IN NUMBER DEFAULT NULL,
120 X_ORG_ID IN NUMBER DEFAULT NULL,
121 X_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
122 X_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
123 X_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
124 );
125
126 procedure UPDATE_ROW (
127 X_APPLICATION_ID in NUMBER,
128 X_RULE_OBJECT_ID in NUMBER,
129 X_DEFAULT_APPLICATION_ID in NUMBER,
130 X_DEFAULT_VALUE in VARCHAR2,
131 X_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
132 X_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
133 X_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
134 );
135
136 PROCEDURE Select_Row (
137 X_RULE_OBJECT_NAME IN OUT NOCOPY VARCHAR2,
138 X_RULE_OBJECT_ID OUT NOCOPY NUMBER,
139 X_APPLICATION_ID IN OUT NOCOPY NUMBER,
140 X_USER_RULE_OBJECT_NAME OUT NOCOPY VARCHAR2,
141 X_DESCRIPTION OUT NOCOPY VARCHAR2,
142 X_RESULT_TYPE OUT NOCOPY VARCHAR2,
143 X_REQUIRED_FLAG OUT NOCOPY VARCHAR2,
144 X_USE_DEFAULT_VALUE_FLAG OUT NOCOPY VARCHAR2,
145 X_DEFAULT_APPLICATION_ID OUT NOCOPY NUMBER,
146 X_DEFAULT_VALUE OUT NOCOPY VARCHAR2,
147 X_FLEX_VALUE_SET_ID OUT NOCOPY NUMBER,
148 X_FLEXFIELD_NAME OUT NOCOPY VARCHAR2,
149 X_FLEXFIELD_APP_SHORT_NAME OUT NOCOPY VARCHAR2,
150 X_MULTI_RULE_RESULT_FLAG OUT NOCOPY VARCHAR2,
151 X_CREATED_BY_MODULE OUT NOCOPY VARCHAR2,
152 X_USE_INSTANCE_FLAG OUT NOCOPY VARCHAR2,
153 X_INSTANCE_LABEL OUT NOCOPY VARCHAR2,
154 X_PARENT_RULE_OBJECT_ID OUT NOCOPY NUMBER,
155 X_ORG_ID OUT NOCOPY NUMBER
156 );
157
158 PROCEDURE Select_Row_Rob_Id (
159 X_RULE_OBJECT_NAME OUT NOCOPY VARCHAR2,
160 X_RULE_OBJECT_ID IN OUT NOCOPY NUMBER,
161 X_APPLICATION_ID OUT NOCOPY NUMBER,
162 X_USER_RULE_OBJECT_NAME OUT NOCOPY VARCHAR2,
163 X_DESCRIPTION OUT NOCOPY VARCHAR2,
164 X_RESULT_TYPE OUT NOCOPY VARCHAR2,
165 X_REQUIRED_FLAG OUT NOCOPY VARCHAR2,
166 X_USE_DEFAULT_VALUE_FLAG OUT NOCOPY VARCHAR2,
167 X_DEFAULT_APPLICATION_ID OUT NOCOPY NUMBER,
168 X_DEFAULT_VALUE OUT NOCOPY VARCHAR2,
169 X_FLEX_VALUE_SET_ID OUT NOCOPY NUMBER,
170 X_FLEXFIELD_NAME OUT NOCOPY VARCHAR2,
171 X_FLEXFIELD_APP_SHORT_NAME OUT NOCOPY VARCHAR2,
172 X_MULTI_RULE_RESULT_FLAG OUT NOCOPY VARCHAR2,
173 X_CREATED_BY_MODULE OUT NOCOPY VARCHAR2,
174 X_USE_INSTANCE_FLAG OUT NOCOPY VARCHAR2,
175 X_INSTANCE_LABEL OUT NOCOPY VARCHAR2,
176 X_PARENT_RULE_OBJECT_ID OUT NOCOPY NUMBER,
177 X_ORG_ID OUT NOCOPY NUMBER
178 );
179
180 PROCEDURE DELETE_ROW (
181 X_RULE_OBJECT_NAME IN VARCHAR2,
182 X_APPLICATION_ID IN NUMBER
183 );
184
185 PROCEDURE DELETE_ROW (
186 X_RULE_OBJECT_ID IN NUMBER
187 );
188
189 procedure ADD_LANGUAGE;
190
191 procedure LOAD_ROW (
192 X_APP_SHORT_NAME in VARCHAR2,
193 X_RULE_OBJECT_NAME in VARCHAR2,
194 X_RESULT_TYPE in VARCHAR2,
195 X_REQUIRED_FLAG in VARCHAR2,
196 X_USE_DEFAULT_VALUE_FLAG IN VARCHAR2,
197 X_DEFAULT_APP_SHORT_NAME in VARCHAR2,
198 X_DEFAULT_VALUE in VARCHAR2,
199 X_FLEX_VALUE_SET_NAME in VARCHAR2,
200 X_FLEXFIELD_NAME in VARCHAR2,
201 X_FLEXFIELD_APP_SHORT_NAME in VARCHAR2,
202 X_MULTI_RULE_RESULT_FLAG in VARCHAR2,
203 X_USER_RULE_OBJECT_NAME in VARCHAR2,
204 X_DESCRIPTION in VARCHAR2,
205 X_USE_INSTANCE_FLAG IN VARCHAR2 DEFAULT NULL,
206 X_OWNER IN VARCHAR2,
207 X_LAST_UPDATE_DATE IN VARCHAR2,
208 X_ATT_OWNER IN VARCHAR2,
209 X_ATT_LAST_UPDATE_DATE IN VARCHAR2,
210 X_CUSTOM_MODE IN VARCHAR2);
211
212 procedure LOAD_ROW (
213 X_APP_SHORT_NAME in VARCHAR2,
214 X_RULE_OBJECT_NAME in VARCHAR2,
215 X_RESULT_TYPE in VARCHAR2,
216 X_REQUIRED_FLAG in VARCHAR2,
217 X_USE_DEFAULT_VALUE_FLAG IN VARCHAR2,
218 X_FLEX_VALUE_SET_NAME in VARCHAR2,
219 X_FLEXFIELD_NAME in VARCHAR2,
220 X_FLEXFIELD_APP_SHORT_NAME in VARCHAR2,
221 X_MULTI_RULE_RESULT_FLAG in VARCHAR2,
222 X_USER_RULE_OBJECT_NAME in VARCHAR2,
223 X_DESCRIPTION in VARCHAR2,
224 X_USE_INSTANCE_FLAG IN VARCHAR2 DEFAULT NULL,
225 X_OWNER IN VARCHAR2,
226 X_LAST_UPDATE_DATE IN VARCHAR2,
227 X_CUSTOM_MODE IN VARCHAR2);
228
229
230 procedure LOAD_ROW (
231 X_APP_SHORT_NAME in VARCHAR2,
232 X_RULE_OBJECT_NAME in VARCHAR2,
233 X_DEFAULT_APP_SHORT_NAME in VARCHAR2,
234 X_DEFAULT_VALUE in VARCHAR2,
235 X_OWNER IN VARCHAR2,
236 X_LAST_UPDATE_DATE IN VARCHAR2,
237 X_CUSTOM_MODE IN VARCHAR2);
238
239 PROCEDURE TRANSLATE_ROW(
240 X_APP_SHORT_NAME in VARCHAR2,
241 X_RULE_OBJECT_NAME in VARCHAR2,
242 X_OWNER in VARCHAR2,
243 X_USER_RULE_OBJECT_NAME in VARCHAR2,
244 X_DESCRIPTION in VARCHAR2,
245 X_CUSTOM_MODE in VARCHAR2,
246 X_LAST_UPDATE_DATE in VARCHAR2
247 );
248
249 END FUN_RULE_OBJECTS_PKG;
[Home] [Help]