1 PACKAGE OZF_Reason_PVT as
2 /* $Header: ozfvreas.pls 120.1 2005/06/30 23:43:30 appldev ship $ */
3 -- Start of Comments
4 -- Package name : OZF_Reason_PVT
5 -- Purpose :
6 -- History : 30-AUG-2001 MCHANG Add one more column: REASON_TYPE VARCHAR2(30)
7 -- 28-OCT-2002 UPOLURI Add one more column: ORDER_TYPE_ID NUMBER
8 -- History : 28-SEP-2003 ANUJGUPT Add one more column: PARTNER_ACCESS_FLAG VARCHAR2(1)
9 -- History : 22-Jun-2005 KDHULIPA Add one more column: INVOICING_REASON_CODE VARCHAR2(30)
10 -- NOTE :
11 -- End of Comments
12
13 -- Default number of records fetch per call
14 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
15 -- *******************************************************
16 -- Start of Comments
17 -- -------------------------------------------------------
18 -- Record name:reason_Rec_Type
19 -- -------------------------------------------------------
20 -- Parameters:
21 -- REASON_CODE_ID
22 -- OBJECT_VERSION_NUMBER
23 -- LAST_UPDATE_DATE
24 -- LAST_UPDATED_BY
25 -- CREATION_DATE
26 -- CREATED_BY
27 -- LAST_UPDATE_LOGIN
28 -- REASON_CODE
29 -- START_DATE_ACTIVE
30 -- END_DATE_ACTIVE
31 -- ATTRIBUTE_CATEGORY
32 -- ATTRIBUTE1
33 -- ATTRIBUTE2
34 -- ATTRIBUTE3
35 -- ATTRIBUTE4
36 -- ATTRIBUTE5
37 -- ATTRIBUTE6
38 -- ATTRIBUTE7
39 -- ATTRIBUTE8
40 -- ATTRIBUTE9
41 -- ATTRIBUTE10
42 -- ATTRIBUTE11
43 -- ATTRIBUTE12
44 -- ATTRIBUTE13
45 -- ATTRIBUTE14
46 -- ATTRIBUTE15
47 -- ORG_ID
48 -- REASON_TYPE
49 -- ADJUSTMENT_REASON_CODE
50 -- INVOICING_REASON_CODE
51 --
52 -- Required:
53 -- Defaults:
54 -- Note: This is automatic generated record definition, it includes all columns
55 -- defined in the table, developer must manually add or delete some of the attributes.
56 --
57 -- End of Comments
58
59 TYPE action_Rec_Type IS RECORD
60 (
61 REASON_TYPE_ID NUMBER,
62 OBJECT_VERSION_NUMBER NUMBER,
63 REASON_CODE_ID NUMBER,
64 TASK_TEMPLATE_GROUP_ID NUMBER,
65 ACTIVE_FLAG VARCHAR2(1),
66 DEFAULT_FLAG VARCHAR2(1)
67 );
68
69 G_MISS_action_REC action_Rec_Type;
70
71 TYPE action_Tbl_Type IS TABLE OF action_Rec_Type;
72 G_MISS_action_TBL action_Tbl_Type;
73
74 TYPE reason_Rec_Type IS RECORD
75 (
76 REASON_CODE_ID NUMBER ,
77 OBJECT_VERSION_NUMBER NUMBER ,
78 LAST_UPDATE_DATE DATE ,
79 LAST_UPDATED_BY NUMBER ,
80 CREATION_DATE DATE ,
81 CREATED_BY NUMBER ,
82 LAST_UPDATE_LOGIN NUMBER ,
83 REASON_CODE VARCHAR2(30) ,
84 START_DATE_ACTIVE DATE ,
85 END_DATE_ACTIVE DATE ,
86 ATTRIBUTE_CATEGORY VARCHAR2(30) ,
87 ATTRIBUTE1 VARCHAR2(150),
88 ATTRIBUTE2 VARCHAR2(150),
89 ATTRIBUTE3 VARCHAR2(150),
90 ATTRIBUTE4 VARCHAR2(150),
91 ATTRIBUTE5 VARCHAR2(150),
92 ATTRIBUTE6 VARCHAR2(150),
93 ATTRIBUTE7 VARCHAR2(150),
94 ATTRIBUTE8 VARCHAR2(150),
95 ATTRIBUTE9 VARCHAR2(150),
96 ATTRIBUTE10 VARCHAR2(150),
97 ATTRIBUTE11 VARCHAR2(150),
98 ATTRIBUTE12 VARCHAR2(150),
99 ATTRIBUTE13 VARCHAR2(150),
100 ATTRIBUTE14 VARCHAR2(150),
101 ATTRIBUTE15 VARCHAR2(150),
102 NAME VARCHAR2(80) ,
103 DESCRIPTION VARCHAR2(2000) ,
104 ORG_ID NUMBER ,
105 REASON_TYPE VARCHAR2(30),
106 ADJUSTMENT_REASON_CODE VARCHAR2(30),
107 INVOICING_REASON_CODE VARCHAR2 (30),
108 ORDER_TYPE_ID NUMBER ,
109 PARTNER_ACCESS_FLAG VARCHAR2(1)
110 );
111
112 G_MISS_reason_REC reason_Rec_Type;
113 TYPE reason_Tbl_Type IS TABLE OF reason_Rec_Type;
114 G_MISS_reason_TBL reason_Tbl_Type;
115
116 -- *******************************************************
117 -- Start of Comments
118 -- *******************************************************
119 -- API Name: Create_reason
120 -- Type : Private
121 -- Pre-Req :
122 -- Parameters:
123 -- IN
124 -- p_api_version_number IN NUMBER Required
125 -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE
126 -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE
127 -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL
128 -- P_reason_Rec IN reason_Rec_Type Required
129 --
130 -- OUT:
131 -- x_return_status OUT VARCHAR2
132 -- x_msg_count OUT NUMBER
133 -- x_msg_data OUT VARCHAR2
134 -- Version : Current version 1.0
135 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
136 -- and basic operation, developer must manually add parameters and business logic as necessary.
137 --
138 -- End of Comments
139 --
140 PROCEDURE Create_reason(
141 P_Api_Version_Number IN NUMBER,
142 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
143 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
144 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
145
146 X_Return_Status OUT NOCOPY VARCHAR2,
147 X_Msg_Count OUT NOCOPY NUMBER,
148 X_Msg_Data OUT NOCOPY VARCHAR2,
149
150 P_reason_Rec IN reason_Rec_Type := G_MISS_reason_REC,
151 X_REASON_CODE_ID OUT NOCOPY NUMBER
152 );
153
154 -- *******************************************************
155 -- Start of Comments
156 -- *******************************************************
157 -- API Name: Update_reason
158 -- Type : Private
159 -- Pre-Req :
160 -- Parameters:
161 -- IN
162 -- p_api_version_number IN NUMBER Required
163 -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE
164 -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE
165 -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL
166 -- P_reason_Rec IN reason_Rec_Type Required
167 --
168 -- OUT:
169 -- x_return_status OUT VARCHAR2
170 -- x_msg_count OUT NUMBER
171 -- x_msg_data OUT VARCHAR2
172 -- Version : Current version 1.0
173 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
174 -- and basic operation, developer must manually add parameters and business logic as necessary.
175 --
176 -- End of Comments
177 --
178 PROCEDURE Update_reason(
179 P_Api_Version_Number IN NUMBER,
180 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
181 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
182 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
183
184 X_Return_Status OUT NOCOPY VARCHAR2,
185 X_Msg_Count OUT NOCOPY NUMBER,
186 X_Msg_Data OUT NOCOPY VARCHAR2,
187
188 P_reason_Rec IN reason_Rec_Type,
189 X_Object_Version_Number OUT NOCOPY NUMBER
190 );
191
192 -- *******************************************************
193 -- Start of Comments
194 -- *******************************************************
195 -- API Name: Delete_reason
196 -- Type : Private
197 -- Pre-Req :
198 -- Parameters:
199 -- IN
200 -- p_api_version_number IN NUMBER Required
201 -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE
202 -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE
203 -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL
204 -- p_REASON_CODE_ID IN NUMBER
205 -- p_object_version_number IN NUMBER Optional Default=NULL
206 --
207 -- OUT:
208 -- x_return_status OUT VARCHAR2
209 -- x_msg_count OUT NUMBER
210 -- x_msg_data OUT VARCHAR2
211 -- Version : Current version 1.0
212 -- Note: This automatic generated procedure definition, it
213 -- includes standard IN/OUT parameters and basic operation,
214 -- developer must manually add parameters and business
215 -- logic as necessary.
216 --
217 -- End of Comments
218 --
219 PROCEDURE Delete_reason(
220 P_Api_Version_Number IN NUMBER,
221 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
222 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
223 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
224 X_Return_Status OUT NOCOPY VARCHAR2,
225 X_Msg_Count OUT NOCOPY NUMBER,
226 X_Msg_Data OUT NOCOPY VARCHAR2,
227 P_REASON_CODE_ID IN NUMBER,
228 P_Object_Version_Number IN NUMBER
229 );
230
231 -- *******************************************************
232 -- Start of Comments
233 -- *******************************************************
234 -- API Name: Update_actions
235 -- Type : Private
236 -- Pre-Req :
237 -- Parameters:
238 -- IN
239 -- p_api_version_number IN NUMBER Required
240 -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE
241 -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE
242 -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL
243 -- p_action_Tbl IN action_Tbl_Type
244 --
245 -- OUT:
246 -- x_return_status OUT VARCHAR2
247 -- x_msg_count OUT NUMBER
248 -- x_msg_data OUT VARCHAR2
249 -- Version : Current version 1.0
250 -- Note: This automatic generated procedure definition, it
251 -- includes standard IN/OUT parameters and basic operation,
252 -- developer must manually add parameters and business
253 -- logic as necessary.
254 --
255 -- End of Comments
256 --
257 PROCEDURE Update_actions(
258 P_Api_Version_Number IN NUMBER,
259 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
260 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
261 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
262 X_Return_Status OUT NOCOPY VARCHAR2,
263 X_Msg_Count OUT NOCOPY NUMBER,
264 X_Msg_Data OUT NOCOPY VARCHAR2,
265 P_action_Tbl IN action_Tbl_Type
266 );
267
268 -- *******************************************************
269 -- Start of Comments
270 -- *******************************************************
271 -- API Name: Delete_action
272 -- Type : Private
273 -- Pre-Req :
274 -- Parameters:
275 -- IN
276 -- p_api_version_number IN NUMBER Required
277 -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE
278 -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE
279 -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL
280 -- p_reason_type_id IN NUMBER
281 -- p_object_version_number IN NUMBER
282 --
283 -- OUT:
284 -- x_return_status OUT VARCHAR2
285 -- x_msg_count OUT NUMBER
286 -- x_msg_data OUT VARCHAR2
287 -- Version : Current version 1.0
288 -- Note: This automatic generated procedure definition, it
289 -- includes standard IN/OUT parameters and basic operation,
290 -- developer must manually add parameters and business
291 -- logic as necessary.
292 --
293 -- End of Comments
294 --
295 PROCEDURE Delete_action(
296 P_Api_Version_Number IN NUMBER,
297 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
298 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
299 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
300 X_Return_Status OUT NOCOPY VARCHAR2,
301 X_Msg_Count OUT NOCOPY NUMBER,
302 X_Msg_Data OUT NOCOPY VARCHAR2,
303 P_reason_type_id IN NUMBER,
304 p_object_version_number IN NUMBER
305 );
306
307
308 -- *******************************************************
309 -- Start of Comments
310 -- *******************************************************
311 -- API Name: Check_unique_Action
312 -- Type : Private
313 -- Pre-Req :
314 -- Parameters:
315 -- IN
316 -- P_action_Rec IN action_Rec_Type Required
317 -- p_validation_mode IN VARCHAR2 Optional Default=JTF_PLSQL_API.g_create
318 --
319 -- OUT:
320 -- x_return_status OUT VARCHAR2
321 --
322 -- Version : Current version 1.0
323 -- Description : Checks the uniqueness of the action record for a reason.
324 --
325 -- End of Comments
329 x_return_status OUT NOCOPY VARCHAR2
326 PROCEDURE Check_unique_Action(
327 P_action_Rec IN action_Rec_Type,
328 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
330 );
331
332 -- Start of Comments
333 --
334 -- Record level validation procedures
335 --
336 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
337 -- For create: G_CREATE, for update: G_UPDATE
338 -- Note: 1. This is automated generated item level validation procedure.
339 -- The actual validation detail is needed to be added.
340 -- 2. Developer can manually added inter-field level validation.
341 -- End of Comments
342
343 PROCEDURE Validate_reason_rec(
344 P_Api_Version_Number IN NUMBER,
345 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
346 X_Return_Status OUT NOCOPY VARCHAR2,
347 X_Msg_Count OUT NOCOPY NUMBER,
348 X_Msg_Data OUT NOCOPY VARCHAR2,
349 P_reason_Rec IN reason_Rec_Type
350 );
351
352 -- Start of Comments
353 --
354 -- validation procedures
355 --
356 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
357 -- For create: G_CREATE, for update: G_UPDATE
358 -- Note: 1. This is automated generated item level validation procedure.
359 -- The actual validation detail is needed to be added.
360 -- 2. We can also validate table instead of record.
361 -- There will be an option for user to choose.
362 -- End of Comments
363
364 PROCEDURE Validate_reason(
365 P_Api_Version_Number IN NUMBER,
366 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
367 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
368 P_reason_Rec IN reason_Rec_Type,
369 X_Return_Status OUT NOCOPY VARCHAR2,
370 X_Msg_Count OUT NOCOPY NUMBER,
371 X_Msg_Data OUT NOCOPY VARCHAR2
372 );
373
374 ---------------------------------------------------------------------
375 -- PROCEDURE
376 -- Complete_Claim_Rec
377 --
378 -- PURPOSE
379 -- For Update_Claim, some attributes may be passed in as
380 -- FND_API.g_miss_char/num/date if the user doesn't want to
381 -- update those attributes. This procedure will replace the
382 -- "g_miss" attributes with current database values.
383 --
384 -- PARAMETERS
385 -- p_claim_rec : the record which may contain attributes as
386 -- FND_API.g_miss_char/num/date
387 -- x_complete_rec: the complete record after all "g_miss" items
388 -- have been replaced by current database values
389 ---------------------------------------------------------------------
390 PROCEDURE Complete_Reason_Rec (
391 p_reason_rec IN reason_Rec_Type
392 ,x_complete_rec OUT NOCOPY reason_Rec_Type
393 ,x_return_status OUT NOCOPY varchar2
394 );
395
396 End OZF_Reason_PVT;
397