[Home] [Help]
PACKAGE: APPS.CN_RULE_PUB_CUHK
Source
1 PACKAGE CN_RULE_PUB_CUHK AUTHID CURRENT_USER as
2 -- $Header: cncrules.pls 120.1 2005/06/20 17:40:39 appldev ship $
3
4 -------------------------------------------------------------------------------------+
5 -- Start of comments
6 -- API name : create_rule_pre
7 -- Type : Public.
8 -- Pre-reqs : None.
9 -- Usage : Customization before creating a rule
10 --
11 -- Desc :
12 --
13 -- Parameters :
14 -- IN : p_api_version IN NUMBER Required
15 -- p_init_msg_list IN VARCHAR2 Optional
16 -- Default = FND_API.G_FALSE
17 -- p_commit IN VARCHAR2 Optional
18 -- Default = FND_API.G_FALSE
19 -- p_validation_level IN NUMBER Optional
20 -- Default = FND_API.G_VALID_LEVEL_FULL
21 -- OUT : x_return_status OUT VARCHAR2(1)
22 -- x_msg_count OUT NUMBER
23 -- x_msg_data OUT VARCHAR2(2000)
24 -- IN OUT : p_rule_rec IN OUT CN_Rule_PUB.rule_rec_type
25 --
26 -- OUT : x_loading_status OUT VARCHAR2(50)
27 -- Detailed error code returned from procedure.
28 --
29 --
30 -- Version : Current version 1.0
31 -- Initial version 1.0
32 --
33 -- Notes :
34 --
35 -- End of comments
36 --------------------------------------------------------------------------------------+
37 PROCEDURE create_rule_pre
38 ( p_api_version IN NUMBER,
39 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
40 p_commit IN VARCHAR2 := FND_API.G_FALSE,
41 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
42 x_return_status OUT NOCOPY VARCHAR2,
43 x_msg_count OUT NOCOPY NUMBER,
44 x_msg_data OUT NOCOPY VARCHAR2,
45 x_loading_status OUT NOCOPY VARCHAR2,
46 p_rule_rec IN OUT NOCOPY CN_Rule_PUB.rule_rec_type
47 );
48
49 -------------------------------------------------------------------------------------+
50 -- Start of comments
51 -- API name : create_rule_post
52 -- Type : Public.
53 -- Pre-reqs : None.
54 -- Usage : Customization before creating a rule
55 --
56 -- Desc :
57 --
58 -- Parameters :
59 -- IN : p_api_version IN NUMBER Required
60 -- p_init_msg_list IN VARCHAR2 Optional
61 -- Default = FND_API.G_FALSE
62 -- p_commit IN VARCHAR2 Optional
63 -- Default = FND_API.G_FALSE
64 -- p_validation_level IN NUMBER Optional
65 -- Default = FND_API.G_VALID_LEVEL_FULL
66 -- OUT : x_return_status OUT VARCHAR2(1)
67 -- x_msg_count OUT NUMBER
68 -- x_msg_data OUT VARCHAR2(2000)
69 -- IN OUT : p_rule_rec IN OUT CN_Rule_PUB.rule_rec_type
70 --
71 -- OUT : x_loading_status OUT VARCHAR2(50)
72 -- Detailed error code returned from procedure.
73 --
74 --
75 -- Version : Current version 1.0
76 -- Initial version 1.0
77 --
78 -- Notes :
79 --
80 -- End of comments
81 --------------------------------------------------------------------------------------+
82 PROCEDURE create_rule_post
83 ( p_api_version IN NUMBER,
84 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
85 p_commit IN VARCHAR2 := FND_API.G_FALSE,
86 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2,
90 x_loading_status OUT NOCOPY VARCHAR2,
91 p_rule_rec IN OUT NOCOPY CN_Rule_PUB.rule_rec_type
92 );
93
94 -------------------------------------------------------------------------------------+
95 -- Start of comments
96 -- API name : update_rule_pre
97 -- Type : Public.
98 -- Pre-reqs : None.
99 -- Usage : Customization before updating a rule
100 --
101 -- Desc :
102 --
103 -- Parameters :
104 -- IN : p_api_version IN NUMBER Required
105 -- p_init_msg_list IN VARCHAR2 Optional
106 -- Default = FND_API.G_FALSE
107 -- p_commit IN VARCHAR2 Optional
108 -- Default = FND_API.G_FALSE
109 -- p_validation_level IN NUMBER Optional
110 -- Default = FND_API.G_VALID_LEVEL_FULL
111 -- OUT : x_return_status OUT VARCHAR2(1)
112 -- x_msg_count OUT NUMBER
113 -- x_msg_data OUT VARCHAR2(2000)
114 -- IN OUT : p_old_rule_id IN CN_Rule_PUB.rule_rec_type
115 -- IN OUT : p_rule_id IN CN_Rule_PUB.rule_rec_type
116 --
117 -- OUT : x_loading_status OUT VARCHAR2(50)
118 -- Detailed error code returned from procedure.
119 --
120 --
121 -- Version : Current version 1.0
122 -- Initial version 1.0
123 --
124 -- Notes :
125 --
126 -- End of comments
127 --------------------------------------------------------------------------------------+
128 PROCEDURE update_rule_pre
129 ( p_api_version IN NUMBER,
130 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
131 p_commit IN VARCHAR2 := FND_API.G_FALSE,
132 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
133 x_return_status OUT NOCOPY VARCHAR2,
134 x_msg_count OUT NOCOPY NUMBER,
135 x_msg_data OUT NOCOPY VARCHAR2,
136 x_loading_status OUT NOCOPY VARCHAR2,
137 p_old_rule_rec IN OUT NOCOPY CN_Rule_PUB.rule_rec_type,
138 p_rule_rec IN OUT NOCOPY CN_Rule_PUB.rule_rec_type
139 );
140
141 -------------------------------------------------------------------------------------+
142 -- Start of comments
143 -- API name : update_rule_post
144 -- Type : Public.
145 -- Pre-reqs : None.
146 -- Usage : Customization before updating a rule
147 --
148 -- Desc :
149 --
150 -- Parameters :
151 -- IN : p_api_version IN NUMBER Required
152 -- p_init_msg_list IN VARCHAR2 Optional
153 -- Default = FND_API.G_FALSE
154 -- p_commit IN VARCHAR2 Optional
155 -- Default = FND_API.G_FALSE
156 -- p_validation_level IN NUMBER Optional
157 -- Default = FND_API.G_VALID_LEVEL_FULL
158 -- OUT : x_return_status OUT VARCHAR2(1)
159 -- x_msg_count OUT NUMBER
160 -- x_msg_data OUT VARCHAR2(2000)
161 -- IN OUT : p_old_ruleset_id IN OUT CN_Rule_PUB.rule_rec_type
162 -- IN OUT : p_ruleset_id IN OUT CN_Rule_PUB.rule_rec_type
163 --
164 -- OUT : x_loading_status OUT VARCHAR2(50)
165 -- Detailed error code returned from procedure.
166 --
167 --
168 -- Version : Current version 1.0
169 -- Initial version 1.0
170 --
171 -- Notes :
172 --
173 -- End of comments
174 --------------------------------------------------------------------------------------+
175 PROCEDURE update_rule_post
176 ( p_api_version IN NUMBER,
177 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
178 p_commit IN VARCHAR2 := FND_API.G_FALSE,
179 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
180 x_return_status OUT NOCOPY VARCHAR2,
181 x_msg_count OUT NOCOPY NUMBER,
182 x_msg_data OUT NOCOPY VARCHAR2,
183 x_loading_status OUT NOCOPY VARCHAR2,
184 p_old_rule_rec IN OUT NOCOPY CN_Rule_PUB.rule_rec_type,
185 p_rule_rec IN OUT NOCOPY CN_Rule_PUB.rule_rec_type
186 );
187
188 -------------------------------------------------------------------------------------+
189 -- Start of comments
190 -- API name : delete_rule_pre
191 -- Type : Public.
192 -- Pre-reqs : None.
193 -- Usage : Customization before deleting a rule
194 --
195 -- Desc :
196 --
197 -- Parameters :
198 -- IN : p_api_version IN NUMBER Required
199 -- p_init_msg_list IN VARCHAR2 Optional
200 -- Default = FND_API.G_FALSE
201 -- p_commit IN VARCHAR2 Optional
202 -- Default = FND_API.G_FALSE
203 -- p_validation_level IN NUMBER Optional
204 -- Default = FND_API.G_VALID_LEVEL_FULL
205 -- : p_rule_name IN cn_rules.name%TYPE,
206 -- : p_ruleset_name IN cn_rulesets.name%TYPE,
207 -- : p_ruleset_start_date IN cn_rulesets.start_date%TYPE,
208 -- : p_ruleset_end_date IN cn_rulesets.end_date%TYPE
209 --
210 -- OUT : x_return_status OUT VARCHAR2(1)
211 -- x_msg_count OUT NUMBER
212 -- x_msg_data OUT VARCHAR2(2000)
213 -- OUT : x_loading_status OUT VARCHAR2(50)
214 -- Detailed error code returned from procedure.
215 --
216 --
217 -- Version : Current version 1.0
218 -- Initial version 1.0
219 --
220 -- Notes :
221 --
222 -- End of comments
223 --------------------------------------------------------------------------------------+
224 PROCEDURE delete_rule_pre
225 ( p_api_version IN NUMBER,
226 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
227 p_commit IN VARCHAR2 := FND_API.G_FALSE,
228 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
229 x_return_status OUT NOCOPY VARCHAR2,
230 x_msg_count OUT NOCOPY NUMBER,
231 x_msg_data OUT NOCOPY VARCHAR2,
232 x_loading_status OUT NOCOPY VARCHAR2,
233 p_rule_name IN cn_rules.name%TYPE,
234 p_ruleset_name IN cn_rulesets.name%TYPE,
235 p_ruleset_start_date IN cn_rulesets.start_date%TYPE,
236 p_ruleset_end_date IN cn_rulesets.end_date%TYPE
237 );
238
239
240 -------------------------------------------------------------------------------------+
241 -- Start of comments
242 -- API name : delete_rule_post
243 -- Type : Public.
244 -- Pre-reqs : None.
245 -- Usage : Customization before deleting a rule
246 --
247 -- Desc :
248 --
249 -- Parameters :
250 -- IN : p_api_version IN NUMBER Required
251 -- p_init_msg_list IN VARCHAR2 Optional
252 -- Default = FND_API.G_FALSE
253 -- p_commit IN VARCHAR2 Optional
254 -- Default = FND_API.G_FALSE
255 -- p_validation_level IN NUMBER Optional
256 -- Default = FND_API.G_VALID_LEVEL_FULL
257 -- : p_rule_name IN cn_rules.name%TYPE,
258 -- : p_ruleset_name IN cn_rulesets.name%TYPE,
259 -- : p_ruleset_start_date IN cn_rulesets.start_date%TYPE,
260 -- : p_ruleset_end_date IN cn_rulesets.end_date%TYPE
261 --
262 -- OUT : x_return_status OUT VARCHAR2(1)
263 -- x_msg_count OUT NUMBER
264 -- x_msg_data OUT VARCHAR2(2000)
265 -- OUT : x_loading_status OUT VARCHAR2(50)
266 -- Detailed error code returned from procedure.
267 --
268 --
269 -- Version : Current version 1.0
270 -- Initial version 1.0
271 --
272 -- Notes :
273 --
274 -- End of comments
275 --------------------------------------------------------------------------------------+
276 PROCEDURE delete_rule_post
277 ( p_api_version IN NUMBER,
278 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
279 p_commit IN VARCHAR2 := FND_API.G_FALSE,
280 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
281 x_return_status OUT NOCOPY VARCHAR2,
282 x_msg_count OUT NOCOPY NUMBER,
283 x_msg_data OUT NOCOPY VARCHAR2,
284 x_loading_status OUT NOCOPY VARCHAR2,
285 p_rule_name IN cn_rules.name%TYPE,
286 p_ruleset_name IN cn_rulesets.name%TYPE,
287 p_ruleset_start_date IN cn_rulesets.start_date%TYPE,
288 p_ruleset_end_date IN cn_rulesets.end_date%TYPE
289 );
290
291 --------------------------------------------------------------------------------------+
292 -- Start of comments
293 -- API name : ok_to_generate_msg
294 -- Type : Public.
295 -- Pre-reqs : None.
296 -- Usage : Function to decide whether message needs to be generated
297 --
298 -- Desc :
299 --
300 -- Parameters :
301 -- IN :
302 -- OUT :
303 -- Version : Current version 1.0
304 -- Initial version 1.0
305 --
306 -- End of comments
307 --------------------------------------------------------------------------------------+
308 FUNCTION ok_to_generate_msg
309 (p_rule_name IN VARCHAR2)
310 RETURN BOOLEAN;
311
312
313 END CN_RULE_PUB_CUHK;