1 PACKAGE OZF_Na_Rule_Header_PVT AS
2 /* $Header: ozfvnars.pls 120.0 2005/06/01 00:14:36 appldev noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_Na_Rule_Header_PVT
7 -- Purpose
8 --
9 -- History
10 -- -- Thu Nov 20 2003:6/35 PM RSSHARMA Added function get_rule_name
11 -- NOTE
12 --
13 -- This Api is generated with Latest version of
14 -- Rosetta, where g_miss indicates NULL and
15 -- NULL indicates missing value. Rosetta Version 1.55
16 -- End of Comments
17 -- ===============================================================
18
19 -- Default number of records fetch per call
20 -- G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
21 --===================================================================
22 -- Start of Comments
23 -- -------------------------------------------------------
24 -- Record name
25 -- na_rule_header_rec_type
26 -- -------------------------------------------------------
27 -- Parameters:
28 -- na_rule_header_id
29 -- user_status_id
30 -- status_code
31 -- start_date
32 -- end_date
33 -- object_version_number
34 -- creation_date
35 -- created_by
36 -- last_update_date
37 -- last_updated_by
38 -- last_update_login
39 --
40 -- Required
41 --
42 -- Defaults
43 --
44 -- Note: This is automatic generated record definition, it includes all columns
45 -- defined in the table, developer must manually add or delete some of the attributes.
46 --
47 -- End of Comments
48
49 --===================================================================
50 TYPE na_rule_header_rec_type IS RECORD
51 (
52 na_rule_header_id NUMBER,
53 user_status_id NUMBER,
54 status_code VARCHAR2(30),
55 start_date DATE,
56 end_date DATE,
57 object_version_number NUMBER,
58 creation_date DATE,
59 created_by NUMBER,
60 last_update_date DATE,
61 last_updated_by NUMBER,
62 last_update_login NUMBER,
63 name VARCHAR2(4000) := FND_API.G_MISS_CHAR,
64 description VARCHAR2(4000):= FND_API.G_MISS_CHAR
65 );
66
67 g_miss_na_rule_header_rec na_rule_header_rec_type := NULL;
68 TYPE na_rule_header_tbl_type IS TABLE OF na_rule_header_rec_type INDEX BY BINARY_INTEGER;
69 g_miss_na_rule_header_tbl na_rule_header_tbl_type;
70
71 -- ==============================================================================
72 -- Start of Comments
73 -- ==============================================================================
74 -- API Name
75 -- Create_Na_Rule_Header
76 -- Type
77 -- Private
78 -- Pre-Req
79 --
80 -- Parameters
81 --
82 -- IN
83 -- p_api_version_number IN NUMBER Required
84 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
85 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
86 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
87 -- p_na_rule_header_rec IN na_rule_header_rec_type Required
88 --
89 -- OUT
90 -- x_return_status OUT VARCHAR2
91 -- x_msg_count OUT NUMBER
92 -- x_msg_data OUT VARCHAR2
93 -- Version : Current version 1.0
94 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
95 -- and basic operation, developer must manually add parameters and business logic as necessary.
96 --
97 -- History
98 --
99 -- NOTE
100 --
101 -- End of Comments
102 -- ==============================================================================
103
104 PROCEDURE Create_Na_Rule_Header(
105 p_api_version_number IN NUMBER,
106 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107 p_commit IN VARCHAR2 := FND_API.G_FALSE,
108 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER,
112 x_msg_data OUT NOCOPY VARCHAR2,
113
114 p_na_rule_header_rec IN na_rule_header_rec_type := g_miss_na_rule_header_rec,
115 x_na_rule_header_id OUT NOCOPY NUMBER
116 );
117
118 -- ==============================================================================
119 -- Start of Comments
120 -- ==============================================================================
121 -- API Name
122 -- Update_Na_Rule_Header
123 -- Type
124 -- Private
125 -- Pre-Req
126 --
127 -- Parameters
128 --
129 -- IN
130 -- p_api_version_number IN NUMBER Required
131 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
132 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
133 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
134 -- p_na_rule_header_rec IN na_rule_header_rec_type Required
135 --
136 -- OUT
137 -- x_return_status OUT VARCHAR2
138 -- x_msg_count OUT NUMBER
139 -- x_msg_data OUT VARCHAR2
140 -- Version : Current version 1.0
141 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
142 -- and basic operation, developer must manually add parameters and business logic as necessary.
143 --
144 -- History
145 --
146 -- NOTE
147 --
148 -- End of Comments
149 -- ==============================================================================
150
151 PROCEDURE Update_Na_Rule_Header(
152 p_api_version_number IN NUMBER,
153 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
154 p_commit IN VARCHAR2 := FND_API.G_FALSE,
155 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
156
157 x_return_status OUT NOCOPY VARCHAR2,
158 x_msg_count OUT NOCOPY NUMBER,
159 x_msg_data OUT NOCOPY VARCHAR2,
160
161 p_na_rule_header_rec IN na_rule_header_rec_type
162 );
163
164 -- ==============================================================================
165 -- Start of Comments
166 -- ==============================================================================
167 -- API Name
168 -- Delete_Na_Rule_Header
169 -- Type
170 -- Private
171 -- Pre-Req
172 --
173 -- Parameters
174 --
175 -- IN
176 -- p_api_version_number IN NUMBER Required
177 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
178 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
179 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
180 -- p_na_rule_header_id IN NUMBER
181 -- p_object_version_number IN NUMBER Optional Default = NULL
182 --
183 -- OUT
184 -- x_return_status OUT VARCHAR2
185 -- x_msg_count OUT NUMBER
186 -- x_msg_data OUT VARCHAR2
187 -- Version : Current version 1.0
188 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
189 -- and basic operation, developer must manually add parameters and business logic as necessary.
190 --
191 -- History
192 --
193 -- NOTE
194 --
195 -- End of Comments
196 -- ==============================================================================
197
198 PROCEDURE Delete_Na_Rule_Header(
199 p_api_version_number IN NUMBER,
200 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
201 p_commit IN VARCHAR2 := FND_API.G_FALSE,
202 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
203 x_return_status OUT NOCOPY VARCHAR2,
204 x_msg_count OUT NOCOPY NUMBER,
205 x_msg_data OUT NOCOPY VARCHAR2,
206 p_na_rule_header_id IN NUMBER,
207 p_object_version_number IN NUMBER
208 );
209
210 -- ==============================================================================
211 -- Start of Comments
212 -- ==============================================================================
213 -- API Name
214 -- Lock_Na_Rule_Header
215 -- Type
216 -- Private
217 -- Pre-Req
218 --
219 -- Parameters
220 --
221 -- IN
222 -- p_api_version_number IN NUMBER Required
223 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
224 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
225 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
226 -- p_na_rule_header_rec IN na_rule_header_rec_type Required
227 --
228 -- OUT
229 -- x_return_status OUT VARCHAR2
230 -- x_msg_count OUT NUMBER
231 -- x_msg_data OUT VARCHAR2
232 -- Version : Current version 1.0
233 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
234 -- and basic operation, developer must manually add parameters and business logic as necessary.
235 --
236 -- History
237 --
238 -- NOTE
239 --
240 -- End of Comments
241 -- ==============================================================================
242
243 PROCEDURE Lock_Na_Rule_Header(
244 p_api_version_number IN NUMBER,
245 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
246
247 x_return_status OUT NOCOPY VARCHAR2,
248 x_msg_count OUT NOCOPY NUMBER,
249 x_msg_data OUT NOCOPY VARCHAR2,
250
251 p_na_rule_header_id IN NUMBER,
252 p_object_version IN NUMBER
253 );
254
255
256 -- ==============================================================================
257 -- Start of Comments
258 -- ==============================================================================
259 -- API Name
260 -- Validate_Na_Rule_Header
261 --
262 -- Version : Current version 1.0
263 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
264 -- For create: G_CREATE, for update: G_UPDATE
265 -- Note: 1. This is automated generated item level validation procedure.
266 -- The actual validation detail is needed to be added.
267 -- 2. We can also validate table instead of record. There will be an option for user to choose.
268 --
269 -- History
270 --
271 -- NOTE
272 --
273 -- End of Comments
274 -- ==============================================================================
275
276
277 PROCEDURE Validate_Na_Rule_Header(
278 p_api_version_number IN NUMBER,
279 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
280 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
281 p_na_rule_header_rec IN na_rule_header_rec_type,
282 p_validation_mode IN VARCHAR2,
283 x_return_status OUT NOCOPY VARCHAR2,
284 x_msg_count OUT NOCOPY NUMBER,
285 x_msg_data OUT NOCOPY VARCHAR2
286 );
287
288 -- ==============================================================================
289 -- Start of Comments
290 -- ==============================================================================
291 -- API Name
292 -- Na_Rule_Header_Items
293 --
294 -- Version : Current version 1.0
295 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
296 -- For create: G_CREATE, for update: G_UPDATE
297 -- Note: 1. This is automated generated item level validation procedure.
298 -- The actual validation detail is needed to be added.
299 -- 2. Validate the unique keys, lookups here
300 --
301 -- History
302 --
303 -- NOTE
304 --
305 -- End of Comments
306 -- ==============================================================================
307
308
309 PROCEDURE check_Na_Rule_Hdr_Items (
310 P_na_rule_header_rec IN na_rule_header_rec_type,
311 p_validation_mode IN VARCHAR2,
312 x_return_status OUT NOCOPY VARCHAR2
313 );
314
315 -- ==============================================================================
316 -- Start of Comments
317 -- ==============================================================================
318 -- API Name
319 -- Validate_Na_Rule_Header_Rec
320 --
321 -- Version : Current version 1.0
322 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
323 -- For create: G_CREATE, for update: G_UPDATE
324 -- Note: 1. This is automated generated item level validation procedure.
325 -- The actual validation detail is needed to be added.
326 -- 2. Developer can manually added inter-field level validation.
327 --
328 -- History
329 --
330 -- NOTE
331 --
332 -- End of Comments
333 -- ==============================================================================
334
335
336 PROCEDURE Validate_Na_Rule_Header_Rec (
337 p_api_version_number IN NUMBER,
338 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
339 x_return_status OUT NOCOPY VARCHAR2,
340 x_msg_count OUT NOCOPY NUMBER,
341 x_msg_data OUT NOCOPY VARCHAR2,
342 p_na_rule_header_rec IN na_rule_header_rec_type
343 );
344
345 FUNCTION get_rule_name(p_na_rule_header_id IN NUMBER)
346 RETURN VARCHAR2 ;
347 END OZF_Na_Rule_Header_PVT;