[Home] [Help]
PACKAGE: APPS.CSF_DEBRIEF_PVT
Source
1 PACKAGE CSF_DEBRIEF_PVT AUTHID CURRENT_USER as
2 /* $Header: csfvdbfs.pls 120.13.12020000.7 2013/04/09 09:40:54 shadas ship $ */
3 -- Start of Comments
4 -- Package name : CSF_DEBRIEF_PVT
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 -- Default number of records fetch per call
11 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
12 -- *******************************************************
13 -- Start of Comments
14 -- -------------------------------------------------------
15 -- Record name:DEBRIEF_Rec_Type
16 -- -------------------------------------------------------
17
18
19 TYPE DEBRIEF_Rec_Type IS RECORD
20 (
21 DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
22 DEBRIEF_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
23 DEBRIEF_DATE DATE := FND_API.G_MISS_DATE,
24 DEBRIEF_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
25 TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
26 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
27 CREATION_DATE DATE := FND_API.G_MISS_DATE,
28 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
29 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
30 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
31 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
43 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
44 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
45 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
46 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
47 object_version_number NUMBER := FND_API.G_MISS_NUM,
48 TRAVEL_START_TIME DATE := FND_API.G_MISS_DATE,
49 TRAVEL_END_TIME DATE := FND_API.G_MISS_DATE,
50 TRAVEL_DISTANCE_IN_KM NUMBER := FND_API.G_MISS_NUM
51 );
52
53 G_MISS_DEBRIEF_REC DEBRIEF_Rec_Type;
54 TYPE DEBRIEF_Tbl_Type IS TABLE OF DEBRIEF_Rec_Type
55 INDEX BY BINARY_INTEGER;
56 G_MISS_DEBRIEF_TBL DEBRIEF_Tbl_Type;
57
58 TYPE DEBRIEF_LINE_Rec_Type IS RECORD
59 (
60 DEBRIEF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
61 DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
62 DEBRIEF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
63 SERVICE_DATE DATE := FND_API.G_MISS_DATE,
64 BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,
65 TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
66 INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
67 INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
68 ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
69 RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
70 ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
71 RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
72 ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
73 RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
74 PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
75 REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
76 STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,
77 ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
78 ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
79 ITEM_LOTNUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
80 UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
81 QUANTITY NUMBER := FND_API.G_MISS_NUM,
82 -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,
83 RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
84 DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
85 MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
86 LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
87 EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
88 LABOR_START_DATE DATE := FND_API.G_MISS_DATE,
89 LABOR_END_DATE DATE := FND_API.G_MISS_DATE,
90 STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
91 ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
92 EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
93 CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
94 DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
95 CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
96 CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
97 CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
98 CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
99 IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
100 IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
101 IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
102 SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
103 SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
104 SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
105 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
106 CREATION_DATE DATE := FND_API.G_MISS_DATE,
107 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
108 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
109 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
110 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
111 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
112 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
113 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
114 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
115 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
116 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
117 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
118 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
119 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
120 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
121 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
123 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
124 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
125 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
126 RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
127 TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
128 RETURN_DATE DATE := FND_API.G_MISS_DATE,
129
130 USAGE_TYPE VARCHAR2(10) := FND_API.G_MISS_CHAR,
131 DEST_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
132 DEST_SUBINVENTORY_NAME VARCHAR2(10) := FND_API.G_MISS_CHAR,
133 CARRIER_CODE VARCHAR2(25) := FND_API.G_MISS_CHAR,
134 SHIPPING_METHOD VARCHAR2(60) := FND_API.G_MISS_CHAR,
135 SHIPMENT_NUMBER VARCHAR2(60) := FND_API.G_MISS_CHAR,
136 WAYBILL VARCHAR2(60) := FND_API.G_MISS_CHAR,
137
138 EXPENDITURE_ORG_ID NUMBER := FND_API.G_MISS_NUM,
139 PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
140 PROJECT_TASK_ID NUMBER := FND_API.G_MISS_NUM
141 );
142
143 G_MISS_DEBRIEF_LINE_REC DEBRIEF_LINE_Rec_Type;
144 TYPE DEBRIEF_LINE_Tbl_Type IS TABLE OF DEBRIEF_LINE_Rec_Type
145 INDEX BY BINARY_INTEGER;
146 G_MISS_DEBRIEF_LINE_TBL DEBRIEF_LINE_Tbl_Type;
147
148 -- API Name: Create_debrief
149 -- Type : Private
150
151 PROCEDURE Create_debrief(
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 P_DEBRIEF_Rec IN DEBRIEF_Rec_Type := G_MISS_DEBRIEF_REC,
157 P_DEBRIEF_LINE_tbl IN DEBRIEF_LINE_tbl_type
158 := G_MISS_DEBRIEF_LINE_tbl,
159 x_DEBRIEF_HEADER_ID OUT NOCOPY NUMBER,
160 X_Return_Status OUT NOCOPY VARCHAR2,
161 X_Msg_Count OUT NOCOPY NUMBER,
162 X_Msg_Data OUT NOCOPY VARCHAR2
163 );
164
165 -- API Name: Update_debrief
166
167 PROCEDURE Update_debrief(
168 P_Api_Version_Number IN NUMBER,
169 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
170 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
171 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
172 P_debrief_Rec IN debrief_Rec_Type,
173 X_Return_Status OUT NOCOPY VARCHAR2,
174 X_Msg_Count OUT NOCOPY NUMBER,
175 X_Msg_Data OUT NOCOPY VARCHAR2
176 );
177
178
179 PROCEDURE Create_debrief_lines(
180 P_Api_Version_Number IN NUMBER,
181 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
182 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
183 P_Upd_tskassgnstatus IN VARCHAR2 DEFAULT NULL,
184 P_Task_Assignment_status IN VARCHAR2 DEFAULT NULL,
185 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
186 P_DEBRIEF_LINE_tbl IN DEBRIEF_LINE_tbl_type,
187 -- DEFAULT G_MISS_DEBRIEF_LINE_tbl,
188 P_DEBRIEF_HEADER_ID IN NUMBER ,
189 P_SOURCE_OBJECT_TYPE_CODE IN VARCHAR2,
190 X_Return_Status OUT NOCOPY VARCHAR2,
191 X_Msg_Count OUT NOCOPY NUMBER,
192 X_Msg_Data OUT NOCOPY VARCHAR2
193 ) ;
194
195
196 PROCEDURE Update_debrief_line(
197 P_Api_Version_Number IN NUMBER,
198 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
199 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
200 P_Upd_tskassgnstatus IN VARCHAR2 DEFAULT NULL,
201 P_Task_Assignment_status IN VARCHAR2 DEFAULT NULL,
202 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
203 P_DEBRIEF_LINE_Rec IN OUT NOCOPY DEBRIEF_LINE_Rec_type,
204 X_Return_Status OUT NOCOPY VARCHAR2,
205 X_Msg_Count OUT NOCOPY NUMBER,
206 X_Msg_Data OUT NOCOPY VARCHAR2
207 ) ;
208
209 PROCEDURE Validate_Task_Assignment_ID (
210 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
211 P_Validation_mode IN VARCHAR2,
212 P_TASK_Assignment_ID IN NUMBER,
213 X_Return_Status OUT NOCOPY VARCHAR2,
214 X_Msg_Count OUT NOCOPY NUMBER,
215 X_Msg_Data OUT NOCOPY VARCHAR2
216 );
217
218 PROCEDURE Validate_Debrief_Date (
219 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
220 P_Validation_mode IN VARCHAR2,
221 P_Debrief_Date IN DATE,
222 X_Return_Status OUT NOCOPY VARCHAR2,
223 X_Msg_Count OUT NOCOPY NUMBER,
224 X_Msg_Data OUT NOCOPY VARCHAR2
225 );
226
227 PROCEDURE Validate_Service_Date (
228 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
229 P_Service_Date IN DATE,
230 X_Return_Status OUT NOCOPY VARCHAR2,
231 X_Msg_Count OUT NOCOPY NUMBER,
232 X_Msg_Data OUT NOCOPY VARCHAR2
233 );
234
235 PROCEDURE Validate_DEBRIEF_LINE_NUMBER (
236 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
237 P_Validation_mode IN VARCHAR2,
238 P_DEBRIEF_LINE_NUMBER IN NUMBER,
239 X_Return_Status OUT NOCOPY VARCHAR2,
240 X_Msg_Count OUT NOCOPY NUMBER,
244 PROCEDURE Validate_BUSINESS_PROCESS_ID (
241 X_Msg_Data OUT NOCOPY VARCHAR2
242 );
243
245 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
246 P_BUSINESS_PROCESS_ID IN NUMBER,
247 X_Return_Status OUT NOCOPY VARCHAR2,
248 X_Msg_Count OUT NOCOPY NUMBER,
249 X_Msg_Data OUT NOCOPY VARCHAR2
250 );
251 PROCEDURE Validate_TRANSACTION_TYPE_ID (
252 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
253 P_TRANSACTION_TYPE_ID IN NUMBER,
254 X_Return_Status OUT NOCOPY VARCHAR2,
255 X_Msg_Count OUT NOCOPY NUMBER,
256 X_Msg_Data OUT NOCOPY VARCHAR2
257 );
258
259
260 PROCEDURE Validate_Inventory_Item_ID (
261 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
262 p_organization_id IN NUMBER,
263 P_Inventory_Item_ID IN NUMBER,
264 X_Return_Status OUT NOCOPY VARCHAR2,
265 X_Msg_Count OUT NOCOPY NUMBER,
266 X_Msg_Data OUT NOCOPY VARCHAR2 );
267
268 PROCEDURE Validate_Instance_ID (
269 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
270 P_Instance_ID IN NUMBER,
271 X_Return_Status OUT NOCOPY VARCHAR2,
272 X_Msg_Count OUT NOCOPY NUMBER,
273 X_Msg_Data OUT NOCOPY VARCHAR2 );
274
275
276 PROCEDURE Validate_Debrief_Header_ID (
277 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
278 P_Debrief_Header_ID IN NUMBER,
279 X_Return_Status OUT NOCOPY VARCHAR2,
280 X_Msg_Count OUT NOCOPY NUMBER,
281 X_Msg_Data OUT NOCOPY VARCHAR2);
282 PROCEDURE Validate_Task_Assignment_Satus(
283 P_Api_Version_Number IN NUMBER,
284 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
285 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
286 P_Task_Assignment_status IN VARCHAR2 DEFAULT NULL,
287 X_TA_STATUS_ID OUT NOCOPY NUMBER,
288 X_Return_Status OUT NOCOPY VARCHAR2,
289 X_Msg_Count OUT NOCOPY NUMBER,
290 X_Msg_Data OUT NOCOPY VARCHAR2
291 );
292 Function IS_DEBRIEF_HEADER_REC_MISSING(P_DEBRIEF_REC DEBRIEF_REC_TYPE) Return BOOLEAN ;
293
294 Procedure CREATE_INTERACTION(P_Api_Version_Number IN NUMBER,
295 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
296 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
297 P_TASK_ASSIGNMENT_ID IN NUMBER,
298 P_DEBRIEF_HEADER_ID IN NUMBER,
299 P_MEDIA_ID IN NUMBER,
300 P_ACTION_ID IN NUMBER,
301 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
302 X_Msg_Count OUT NOCOPY NUMBER,
303 X_Msg_Data OUT NOCOPY VARCHAR2) ;
304
305 PROCEDURE validate_subinventory_code (
306 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
307 p_organization_id IN number,
308 p_subinventory_code in varchar2,
309 X_Return_Status OUT NOCOPY VARCHAR2,
310 X_Msg_Count OUT NOCOPY NUMBER,
311 X_Msg_Data OUT NOCOPY VARCHAR2
312 );
313
314 PROCEDURE UPDATE_TASK_ACTUAL_DATES (
315 p_task_id IN NUMBER,
316 p_actual_start_date IN DATE,
317 p_actual_end_date IN DATE,
318 x_return_status OUT NOCOPY VARCHAR2,
319 x_msg_count OUT NOCOPY NUMBER,
320 x_msg_data OUT NOCOPY VARCHAR2
321 ) ;
322
323 procedure update_actual_times (
324 p_task_assignment_id in number,
325 x_return_status out nocopy varchar2,
326 x_msg_count out nocopy number,
327 x_msg_data out nocopy varchar2);
328
329 PROCEDURE UPDATE_ACTUAL_TIMES (
330 p_debrief_header_id in number,
331 p_start_date in date,
332 p_end_date in date,
333 x_return_status out nocopy varchar2,
334 x_msg_count out nocopy number,
335 x_msg_data out nocopy varchar2
336 ) ;
337 PROCEDURE VALIDATE_COUNTERS (
338 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
339 p_task_id in number,
340 p_incident_id in number,
341 x_return_status out nocopy varchar2,
342 x_msg_count out nocopy number,
343 x_msg_data out nocopy varchar2
344 ) ;
345
346 PROCEDURE VALIDATE_LABOR_TIMES (
347 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
348 P_api_version_number In number,
349 p_resource_type_code in Varchar2,
350 p_resource_id in Number,
351 p_debrief_line_id in Number,
352 p_labor_start_date in Date,
353 p_labor_end_date in Date,
354 p_task_id in Number default -9999,
355 x_return_status out nocopy varchar2,
356 x_msg_count out nocopy number,
357 x_msg_data out nocopy varchar2,
358 x_debrief_number out nocopy number,
359 x_task_number out nocopy varchar2
360 ) ;
361
362 PROCEDURE TASK_ASSIGNMENT_PRE_UPDATE(
363 x_return_status out nocopy varchar2);
364
365 PROCEDURE TASK_ASSIGNMENT_PRE_DELETE(
366 x_return_status out nocopy varchar2);
367
368 PROCEDURE TASK_ASSIGNMENT_POST_UPDATE(
369 x_return_status out nocopy varchar2);
370
371 function labor_auto_create(p_task_assignment_id in number) return varchar2;
372
373 PROCEDURE CLOSE_DEBRIEF (
374 p_task_assignment_id in number,
375 x_return_status out nocopy varchar2,
376 x_msg_count out nocopy number,
377 x_msg_data out nocopy varchar2
378 ) ;
379
380
381 -- When the labor line is deleted or updated, this procedure will update the task and task assignment details with actual start and end date
382
383 PROCEDURE update_task_actuals (
384 p_debrief_header_id in number,
385 x_return_status out nocopy varchar2,
386 x_msg_count out nocopy number,
387 x_msg_data out nocopy varchar2) ;
388
389 Procedure validate_travel_times(p_actual_travel_start_time date,
390 p_actual_travel_end_time date,
391 p_task_assignment_id NUMBER,
392 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
393 X_Return_Status OUT NOCOPY VARCHAR2,
394 X_Msg_Count OUT NOCOPY NUMBER,
395 X_Msg_Data OUT NOCOPY VARCHAR2);
396
397 function serial_number_control_code(
398 p_organization_id number,
399 p_inventory_item_id number,
400 p_transaction_type_id number)
401 return number;
402
403 END CSF_DEBRIEF_PVT;
404