[Home] [Help]
PACKAGE: APPS.CN_RULEATTRIBUTE_PUB_VUHK
Source
1 PACKAGE CN_RULEATTRIBUTE_PUB_VUHK AUTHID CURRENT_USER as
2 -- $Header: cniratrs.pls 120.1 2005/06/20 18:30:15 appldev ship $
3
4 -------------------------------------------------------------------------------------+
5 -- Start of comments
6 -- API name : create_ruleattribute_pre
7 -- Type : Public.
8 -- Pre-reqs : None.
9 -- Usage : Customization before creating a rule attribute
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 : p_ruleattribute_rec IN CN_RuleAttribute_PUB.RuleAttribute_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_ruleattribute_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_RuleAttribute_rec IN CN_RuleAttribute_PUB.RuleAttribute_rec_type
47 );
48
49 -------------------------------------------------------------------------------------+
50 -- Start of comments
51 -- API name : create_ruleattribute_post
52 -- Type : Public.
53 -- Pre-reqs : None.
54 -- Usage : Customization before creating a rule attribute
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 : p_ruleattribute_rec IN CN_RuleAttribute_PUB.RuleAttribute_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_ruleattribute_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_RuleAttribute_rec IN CN_RuleAttribute_PUB.RuleAttribute_rec_type
92 );
93
94 -------------------------------------------------------------------------------------+
95 -- Start of comments
96 -- API name : update_ruleattribute_pre
97 -- Type : Public.
98 -- Pre-reqs : None.
99 -- Usage : Customization before updating a rule attribute
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 : p_old_ruleattribute_rec IN CN_RuleAttribute_PUB.RuleAttribute_rec_type
115 -- IN : p_ruleattribute_rec IN CN_RuleAttribute_PUB.RuleAttribute_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_ruleattribute_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_RuleAttribute_rec IN CN_RuleAttribute_PUB.RuleAttribute_rec_type,
138 p_RuleAttribute_rec IN CN_RuleAttribute_PUB.RuleAttribute_rec_type
139 );
140
141
142 -------------------------------------------------------------------------------------+
143 -- Start of comments
144 -- API name : update_ruleattribute_post
145 -- Type : Public.
146 -- Pre-reqs : None.
147 -- Usage : Customization before updating a rule attribute
148 --
149 -- Desc :
150 --
151 -- Parameters :
152 -- IN : p_api_version IN NUMBER Required
153 -- p_init_msg_list IN VARCHAR2 Optional
154 -- Default = FND_API.G_FALSE
155 -- p_commit IN VARCHAR2 Optional
156 -- Default = FND_API.G_FALSE
157 -- p_validation_level IN NUMBER Optional
158 -- Default = FND_API.G_VALID_LEVEL_FULL
159 -- OUT : x_return_status OUT VARCHAR2(1)
160 -- x_msg_count OUT NUMBER
161 -- x_msg_data OUT VARCHAR2(2000)
162 -- IN : p_old_ruleattribute_rec IN CN_RuleAttribute_PUB.RuleAttribute_rec_type
163 -- IN : p_ruleattribute_rec IN CN_RuleAttribute_PUB.RuleAttribute_rec_type
164 --
165 -- OUT : x_loading_status OUT VARCHAR2(50)
166 -- Detailed error code returned from procedure.
167 --
168 --
169 -- Version : Current version 1.0
170 -- Initial version 1.0
171 --
172 -- Notes :
173 --
174 -- End of comments
175 --------------------------------------------------------------------------------------+
176
177 PROCEDURE update_ruleattribute_post
178 ( p_api_version IN NUMBER,
179 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
180 p_commit IN VARCHAR2 := FND_API.G_FALSE,
181 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
182 x_return_status OUT NOCOPY VARCHAR2,
183 x_msg_count OUT NOCOPY NUMBER,
184 x_msg_data OUT NOCOPY VARCHAR2,
185 x_loading_status OUT NOCOPY VARCHAR2,
186 p_old_RuleAttribute_rec IN CN_RuleAttribute_PUB.RuleAttribute_rec_type,
187 p_RuleAttribute_rec IN CN_RuleAttribute_PUB.RuleAttribute_rec_type
188 );
189
190
191 -------------------------------------------------------------------------------------+
192 -- Start of comments
193 -- API name : delete_ruleattribute_pre
194 -- Type : Public.
195 -- Pre-reqs : None.
196 -- Usage : Customization before deleting a rule attribute
197 --
198 -- Desc :
199 --
200 -- Parameters :
201 -- IN : p_api_version IN NUMBER Required
202 -- p_init_msg_list IN VARCHAR2 Optional
203 -- Default = FND_API.G_FALSE
204 -- p_commit IN VARCHAR2 Optional
205 -- Default = FND_API.G_FALSE
206 -- p_validation_level IN NUMBER Optional
207 -- Default = FND_API.G_VALID_LEVEL_FULL
208 -- OUT : x_return_status OUT VARCHAR2(1)
209 -- x_msg_count OUT NUMBER
210 -- x_msg_data OUT VARCHAR2(2000)
211 -- IN : p_ruleattribute_rec IN CN_RuleAttribute_PUB.RuleAttribute_rec_type
212 --
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_ruleattribute_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_ruleattribute_rec IN CN_RuleAttribute_PUB.ruleattribute_rec_type
234 );
235
236
237 -------------------------------------------------------------------------------------+
238 -- Start of comments
239 -- API name : delete_ruleattribute_post
240 -- Type : Public.
241 -- Pre-reqs : None.
242 -- Usage : Customization before deleting a rule attribute
243 --
244 -- Desc :
245 --
246 -- Parameters :
247 -- IN : p_api_version IN NUMBER Required
248 -- p_init_msg_list IN VARCHAR2 Optional
249 -- Default = FND_API.G_FALSE
250 -- p_commit IN VARCHAR2 Optional
251 -- Default = FND_API.G_FALSE
252 -- p_validation_level IN NUMBER Optional
253 -- Default = FND_API.G_VALID_LEVEL_FULL
254 -- OUT : x_return_status OUT VARCHAR2(1)
255 -- x_msg_count OUT NUMBER
256 -- x_msg_data OUT VARCHAR2(2000)
257 -- IN : p_ruleattribute_rec IN CN_RuleAttribute_PUB.RuleAttribute_rec_type
258 --
259 -- OUT : x_loading_status OUT VARCHAR2(50)
260 -- Detailed error code returned from procedure.
261 --
262 --
263 -- Version : Current version 1.0
264 -- Initial version 1.0
265 --
266 -- Notes :
267 --
268 -- End of comments
269 --------------------------------------------------------------------------------------+
270 PROCEDURE delete_ruleattribute_post
271 ( p_api_version IN NUMBER,
272 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
273 p_commit IN VARCHAR2 := FND_API.G_FALSE,
274 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
275 x_return_status OUT NOCOPY VARCHAR2,
276 x_msg_count OUT NOCOPY NUMBER,
277 x_msg_data OUT NOCOPY VARCHAR2,
278 x_loading_status OUT NOCOPY VARCHAR2,
279 p_ruleattribute_rec IN CN_RuleAttribute_PUB.ruleattribute_rec_type
280 );
281
282
283 --------------------------------------------------------------------------------------+
284 -- Start of comments
285 -- API name : ok_to_generate_msg
286 -- Type : Public.
287 -- Pre-reqs : None.
288 -- Usage : Function to decide whether message needs to be generated
289 --
290 -- Desc :
291 --
292 -- Parameters :
293 -- IN :
294 -- OUT :
295 -- Version : Current version 1.0
296 -- Initial version 1.0
297 --
298 -- End of comments
299 --------------------------------------------------------------------------------------+
300 FUNCTION ok_to_generate_msg
301 (p_ruleattribute_rec IN CN_RuleAttribute_PUB.ruleattribute_rec_type)
302 -- (p_rule_name IN cn_rules.name%TYPE)
303 RETURN BOOLEAN;
304
305
306 END CN_RULEATTRIBUTE_PUB_VUHK;