[Home] [Help]
PACKAGE: APPS.CSF_DEBRIEF_PVT
Source
1 PACKAGE CSF_DEBRIEF_PVT as
2 /* $Header: csfvdbfs.pls 120.3.12000000.2 2007/07/27 16:05:52 hhaugeru 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
131 G_MISS_DEBRIEF_LINE_REC DEBRIEF_LINE_Rec_Type;
132 TYPE DEBRIEF_LINE_Tbl_Type IS TABLE OF DEBRIEF_LINE_Rec_Type
133 INDEX BY BINARY_INTEGER;
134 G_MISS_DEBRIEF_LINE_TBL DEBRIEF_LINE_Tbl_Type;
135
136 -- API Name: Create_debrief
137 -- Type : Private
138
139 PROCEDURE Create_debrief(
140 P_Api_Version_Number IN NUMBER,
141 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
142 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
143 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
144 P_DEBRIEF_Rec IN DEBRIEF_Rec_Type := G_MISS_DEBRIEF_REC,
145 P_DEBRIEF_LINE_tbl IN DEBRIEF_LINE_tbl_type
146 := G_MISS_DEBRIEF_LINE_tbl,
147 x_DEBRIEF_HEADER_ID OUT NOCOPY NUMBER,
148 X_Return_Status OUT NOCOPY VARCHAR2,
149 X_Msg_Count OUT NOCOPY NUMBER,
150 X_Msg_Data OUT NOCOPY VARCHAR2
151 );
152
153 -- API Name: Update_debrief
154
155 PROCEDURE Update_debrief(
156 P_Api_Version_Number IN NUMBER,
157 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
158 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
159 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
160 P_debrief_Rec IN debrief_Rec_Type,
161 X_Return_Status OUT NOCOPY VARCHAR2,
162 X_Msg_Count OUT NOCOPY NUMBER,
163 X_Msg_Data OUT NOCOPY VARCHAR2
164 );
165
166
167 PROCEDURE Create_debrief_lines(
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_Upd_tskassgnstatus IN VARCHAR2 DEFAULT NULL,
172 P_Task_Assignment_status IN VARCHAR2 DEFAULT NULL,
173 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
174 P_DEBRIEF_LINE_tbl IN DEBRIEF_LINE_tbl_type,
175 -- DEFAULT G_MISS_DEBRIEF_LINE_tbl,
176 P_DEBRIEF_HEADER_ID IN NUMBER ,
177 P_SOURCE_OBJECT_TYPE_CODE IN VARCHAR2,
178 X_Return_Status OUT NOCOPY VARCHAR2,
179 X_Msg_Count OUT NOCOPY NUMBER,
180 X_Msg_Data OUT NOCOPY VARCHAR2
181 ) ;
182
183
184 PROCEDURE Update_debrief_line(
185 P_Api_Version_Number IN NUMBER,
186 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
187 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
188 P_Upd_tskassgnstatus IN VARCHAR2 DEFAULT NULL,
189 P_Task_Assignment_status IN VARCHAR2 DEFAULT NULL,
190 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
191 P_DEBRIEF_LINE_Rec IN OUT NOCOPY DEBRIEF_LINE_Rec_type,
192 X_Return_Status OUT NOCOPY VARCHAR2,
193 X_Msg_Count OUT NOCOPY NUMBER,
194 X_Msg_Data OUT NOCOPY VARCHAR2
195 ) ;
196
197 PROCEDURE Validate_Task_Assignment_ID (
198 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
199 P_Validation_mode IN VARCHAR2,
200 P_TASK_Assignment_ID IN NUMBER,
201 X_Return_Status OUT NOCOPY VARCHAR2,
202 X_Msg_Count OUT NOCOPY NUMBER,
203 X_Msg_Data OUT NOCOPY VARCHAR2
204 );
205
206 PROCEDURE Validate_Debrief_Date (
207 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
208 P_Validation_mode IN VARCHAR2,
209 P_Debrief_Date IN DATE,
210 X_Return_Status OUT NOCOPY VARCHAR2,
211 X_Msg_Count OUT NOCOPY NUMBER,
212 X_Msg_Data OUT NOCOPY VARCHAR2
213 );
214
215 PROCEDURE Validate_Service_Date (
216 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
217 P_Service_Date IN DATE,
218 X_Return_Status OUT NOCOPY VARCHAR2,
219 X_Msg_Count OUT NOCOPY NUMBER,
220 X_Msg_Data OUT NOCOPY VARCHAR2
221 );
222
223 PROCEDURE Validate_DEBRIEF_LINE_NUMBER (
224 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
225 P_Validation_mode IN VARCHAR2,
226 P_DEBRIEF_LINE_NUMBER IN NUMBER,
227 X_Return_Status OUT NOCOPY VARCHAR2,
228 X_Msg_Count OUT NOCOPY NUMBER,
229 X_Msg_Data OUT NOCOPY VARCHAR2
230 );
231
232 PROCEDURE Validate_BUSINESS_PROCESS_ID (
233 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
234 P_BUSINESS_PROCESS_ID IN NUMBER,
235 X_Return_Status OUT NOCOPY VARCHAR2,
236 X_Msg_Count OUT NOCOPY NUMBER,
237 X_Msg_Data OUT NOCOPY VARCHAR2
238 );
239 PROCEDURE Validate_TRANSACTION_TYPE_ID (
240 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
241 P_TRANSACTION_TYPE_ID IN NUMBER,
242 X_Return_Status OUT NOCOPY VARCHAR2,
243 X_Msg_Count OUT NOCOPY NUMBER,
244 X_Msg_Data OUT NOCOPY VARCHAR2
245 );
246
247
248 PROCEDURE Validate_Inventory_Item_ID (
249 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
250 p_organization_id IN NUMBER,
251 P_Inventory_Item_ID IN NUMBER,
252 X_Return_Status OUT NOCOPY VARCHAR2,
253 X_Msg_Count OUT NOCOPY NUMBER,
254 X_Msg_Data OUT NOCOPY VARCHAR2 );
255
256 PROCEDURE Validate_Instance_ID (
257 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
258 P_Instance_ID IN NUMBER,
262
259 X_Return_Status OUT NOCOPY VARCHAR2,
260 X_Msg_Count OUT NOCOPY NUMBER,
261 X_Msg_Data OUT NOCOPY VARCHAR2 );
263
264 PROCEDURE Validate_Debrief_Header_ID (
265 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
266 P_Debrief_Header_ID IN NUMBER,
267 X_Return_Status OUT NOCOPY VARCHAR2,
268 X_Msg_Count OUT NOCOPY NUMBER,
269 X_Msg_Data OUT NOCOPY VARCHAR2);
270 PROCEDURE Validate_Task_Assignment_Satus(
271 P_Api_Version_Number IN NUMBER,
272 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
273 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
274 P_Task_Assignment_status IN VARCHAR2 DEFAULT NULL,
275 X_TA_STATUS_ID OUT NOCOPY NUMBER,
276 X_Return_Status OUT NOCOPY VARCHAR2,
277 X_Msg_Count OUT NOCOPY NUMBER,
278 X_Msg_Data OUT NOCOPY VARCHAR2
279 );
280 Function IS_DEBRIEF_HEADER_REC_MISSING(P_DEBRIEF_REC DEBRIEF_REC_TYPE) Return BOOLEAN ;
281
282 Procedure CREATE_INTERACTION(P_Api_Version_Number IN NUMBER,
283 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
284 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
285 P_TASK_ASSIGNMENT_ID IN NUMBER,
286 P_DEBRIEF_HEADER_ID IN NUMBER,
287 P_MEDIA_ID IN NUMBER,
288 P_ACTION_ID IN NUMBER,
289 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
290 X_Msg_Count OUT NOCOPY NUMBER,
291 X_Msg_Data OUT NOCOPY VARCHAR2) ;
292
293 PROCEDURE validate_subinventory_code (
294 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
295 p_organization_id IN number,
296 p_subinventory_code in varchar2,
297 X_Return_Status OUT NOCOPY VARCHAR2,
298 X_Msg_Count OUT NOCOPY NUMBER,
299 X_Msg_Data OUT NOCOPY VARCHAR2
300 );
301
302 PROCEDURE UPDATE_TASK_ACTUAL_DATES (
303 p_task_id IN NUMBER,
304 p_actual_start_date IN DATE,
305 p_actual_end_date IN DATE,
306 x_return_status OUT NOCOPY VARCHAR2,
307 x_msg_count OUT NOCOPY NUMBER,
308 x_msg_data OUT NOCOPY VARCHAR2
309 ) ;
310
311 procedure update_actual_times (
312 p_task_assignment_id in number,
313 x_return_status out nocopy varchar2,
314 x_msg_count out nocopy number,
315 x_msg_data out nocopy varchar2);
316
317 PROCEDURE UPDATE_ACTUAL_TIMES (
318 p_debrief_header_id in number,
319 p_start_date in date,
320 p_end_date in date,
321 x_return_status out nocopy varchar2,
322 x_msg_count out nocopy number,
323 x_msg_data out nocopy varchar2
324 ) ;
325 PROCEDURE VALIDATE_COUNTERS (
326 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
327 p_task_id in number,
328 p_incident_id in number,
329 x_return_status out nocopy varchar2,
330 x_msg_count out nocopy number,
331 x_msg_data out nocopy varchar2
332 ) ;
333
334 PROCEDURE VALIDATE_LABOR_TIMES (
335 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
336 P_api_version_number In number,
337 p_resource_type_code in Varchar2,
338 p_resource_id in Number,
339 p_debrief_line_id in Number,
340 p_labor_start_date in Date,
341 p_labor_end_date in Date,
342 x_return_status out nocopy varchar2,
343 x_msg_count out nocopy number,
344 x_msg_data out nocopy varchar2,
345 x_debrief_number out nocopy number,
346 x_task_number out nocopy varchar2
347 ) ;
348
349 PROCEDURE TASK_ASSIGNMENT_PRE_DELETE(
350 x_return_status out nocopy varchar2);
351
352
353 PROCEDURE CLOSE_DEBRIEF (
354 p_task_assignment_id in number,
355 x_return_status out nocopy varchar2,
356 x_msg_count out nocopy number,
357 x_msg_data out nocopy varchar2
358 ) ;
359
360
361 -- When the labor line is deleted or updated, this procedure will update the task and task assignment details with actual start and end date
362
363 PROCEDURE update_task_actuals (
364 p_debrief_header_id in number,
365 x_return_status out nocopy varchar2,
366 x_msg_count out nocopy number,
367 x_msg_data out nocopy varchar2) ;
368
369 Procedure validate_travel_times(p_actual_travel_start_time date,
370 p_actual_travel_end_time date,
371 p_task_assignment_id NUMBER,
372 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
376
373 X_Return_Status OUT NOCOPY VARCHAR2,
374 X_Msg_Count OUT NOCOPY NUMBER,
375 X_Msg_Data OUT NOCOPY VARCHAR2);
377 END CSF_DEBRIEF_PVT;
378
379
380
381