[Home] [Help]
PACKAGE: APPS.CSF_DEBRIEF_LINES_PKG
Source
1 PACKAGE CSF_DEBRIEF_LINES_PKG AUTHID CURRENT_USER as
2 /* $Header: csftdbls.pls 120.8.12020000.3 2013/04/09 09:41:22 shadas ship $ */
3 -- Start of Comments
4 -- Package name : CSF_DEBRIEF_LINES_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9 TYPE internal_user_hooks_rec IS RECORD
10 (
11 DEBRIEF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
12 DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
13 DEBRIEF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
14 SERVICE_DATE DATE := FND_API.G_MISS_DATE,
15 BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,
16 TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
17 INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
18 INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
19 ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
20 RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
21 ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
22 RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
23 ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
24 RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
25 PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
26 REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
27 STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,
28 ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
29 ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
30 ITEM_LOTNUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
31 UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
32 QUANTITY NUMBER := FND_API.G_MISS_NUM,
33 -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,
34 RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
35 DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
36 MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
37 LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
38 EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
39 LABOR_START_DATE DATE := FND_API.G_MISS_DATE,
40 LABOR_END_DATE DATE := FND_API.G_MISS_DATE,
41 STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
42 ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
43 EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
44 CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
45 DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
46 CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
47 CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
48 CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
49 CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
50 IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
51 IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
52 IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
53 SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
54 SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
55 SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
56 ERROR_TEXT VARCHAR2(2000):= FND_API.G_MISS_CHAR,
57 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
58 CREATION_DATE DATE := FND_API.G_MISS_DATE,
59 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
60 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
61 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
62 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
78 RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
79 TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
80 RETURN_DATE DATE := FND_API.G_MISS_DATE,
81 MATERIAL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM
82 );
83 user_hooks_rec CSF_DEBRIEF_LINES_PKG.internal_user_hooks_rec ;
84 PROCEDURE Insert_Row_Forms(
85 px_DEBRIEF_LINE_ID IN OUT NOCOPY NUMBER,
86 p_DEBRIEF_HEADER_ID NUMBER,
87 p_DEBRIEF_LINE_NUMBER NUMBER,
88 p_SERVICE_DATE DATE,
89 p_BUSINESS_PROCESS_ID NUMBER,
90 p_TXN_BILLING_TYPE_ID NUMBER,
91 p_INVENTORY_ITEM_ID NUMBER,
92 p_INSTANCE_ID NUMBER,
93 p_ISSUING_INVENTORY_ORG_ID NUMBER,
94 p_RECEIVING_INVENTORY_ORG_ID NUMBER,
95 p_ISSUING_SUB_INVENTORY_CODE VARCHAR2,
96 p_RECEIVING_SUB_INVENTORY_CODE VARCHAR2,
97 p_ISSUING_LOCATOR_ID NUMBER,
98 p_RECEIVING_LOCATOR_ID NUMBER,
99 p_PARENT_PRODUCT_ID NUMBER,
100 p_REMOVED_PRODUCT_ID NUMBER,
101 p_STATUS_OF_RECEIVED_PART VARCHAR2,
102 p_ITEM_SERIAL_NUMBER VARCHAR2,
103 p_ITEM_REVISION VARCHAR2,
104 p_ITEM_LOTNUMBER VARCHAR2,
105 p_UOM_CODE VARCHAR2,
106 p_QUANTITY NUMBER,
107 p_RMA_HEADER_ID NUMBER,
108 p_DISPOSITION_CODE VARCHAR2,
109 p_MATERIAL_REASON_CODE VARCHAR2,
110 p_LABOR_REASON_CODE VARCHAR2,
111 p_EXPENSE_REASON_CODE VARCHAR2,
112 p_LABOR_START_DATE DATE,
113 p_LABOR_END_DATE DATE,
114 p_STARTING_MILEAGE NUMBER,
115 p_ENDING_MILEAGE NUMBER,
116 p_EXPENSE_AMOUNT NUMBER,
117 p_CURRENCY_CODE VARCHAR2,
118 p_DEBRIEF_LINE_STATUS_ID NUMBER,
119 p_RETURN_REASON_CODE VARCHAR2,
120 p_CHANNEL_CODE VARCHAR2,
121 p_CHARGE_UPLOAD_STATUS VARCHAR2,
122 p_CHARGE_UPLOAD_MSG_CODE VARCHAR2,
123 p_CHARGE_UPLOAD_MESSAGE VARCHAR2,
124 p_IB_UPDATE_STATUS VARCHAR2,
125 p_IB_UPDATE_MSG_CODE VARCHAR2,
126 p_IB_UPDATE_MESSAGE VARCHAR2,
127 p_SPARE_UPDATE_STATUS VARCHAR2,
128 p_SPARE_UPDATE_MSG_CODE VARCHAR2,
129 p_SPARE_UPDATE_MESSAGE VARCHAR2,
130 p_CREATED_BY NUMBER,
131 p_CREATION_DATE DATE,
132 p_LAST_UPDATED_BY NUMBER,
133 p_LAST_UPDATE_DATE DATE,
134 p_LAST_UPDATE_LOGIN NUMBER,
135 p_ATTRIBUTE1 VARCHAR2,
136 p_ATTRIBUTE2 VARCHAR2,
137 p_ATTRIBUTE3 VARCHAR2,
138 p_ATTRIBUTE4 VARCHAR2,
139 p_ATTRIBUTE5 VARCHAR2,
140 p_ATTRIBUTE6 VARCHAR2,
141 p_ATTRIBUTE7 VARCHAR2,
142 p_ATTRIBUTE8 VARCHAR2,
143 p_ATTRIBUTE9 VARCHAR2,
144 p_ATTRIBUTE10 VARCHAR2,
145 p_ATTRIBUTE11 VARCHAR2,
146 p_ATTRIBUTE12 VARCHAR2,
147 p_ATTRIBUTE13 VARCHAR2,
148 p_ATTRIBUTE14 VARCHAR2,
149 p_ATTRIBUTE15 VARCHAR2,
150 p_ATTRIBUTE_CATEGORY VARCHAR2,
151 P_TRANSACTION_TYPE_ID NUMBER,
152 P_RETURN_DATE DATE,
153 p_DML_mode VARCHAR2);
154
155 PROCEDURE Insert_Row(
156 px_DEBRIEF_LINE_ID IN OUT NOCOPY NUMBER,
157 p_DEBRIEF_HEADER_ID NUMBER,
158 p_DEBRIEF_LINE_NUMBER NUMBER,
159 p_SERVICE_DATE DATE,
160 p_BUSINESS_PROCESS_ID NUMBER,
161 p_TXN_BILLING_TYPE_ID NUMBER,
162 p_INVENTORY_ITEM_ID NUMBER,
163 p_INSTANCE_ID NUMBER,
164 p_ISSUING_INVENTORY_ORG_ID NUMBER,
165 p_RECEIVING_INVENTORY_ORG_ID NUMBER,
166 p_ISSUING_SUB_INVENTORY_CODE VARCHAR2,
167 p_RECEIVING_SUB_INVENTORY_CODE VARCHAR2,
168 p_ISSUING_LOCATOR_ID NUMBER,
169 p_RECEIVING_LOCATOR_ID NUMBER,
170 p_PARENT_PRODUCT_ID NUMBER,
171 p_REMOVED_PRODUCT_ID NUMBER,
172 p_STATUS_OF_RECEIVED_PART VARCHAR2,
173 p_ITEM_SERIAL_NUMBER VARCHAR2,
174 p_ITEM_REVISION VARCHAR2,
175 p_ITEM_LOTNUMBER VARCHAR2,
176 p_UOM_CODE VARCHAR2,
177 p_QUANTITY NUMBER,
178 p_RMA_HEADER_ID NUMBER,
179 p_DISPOSITION_CODE VARCHAR2,
180 p_MATERIAL_REASON_CODE VARCHAR2,
181 p_LABOR_REASON_CODE VARCHAR2,
182 p_EXPENSE_REASON_CODE VARCHAR2,
183 p_LABOR_START_DATE DATE,
184 p_LABOR_END_DATE DATE,
185 p_STARTING_MILEAGE NUMBER,
186 p_ENDING_MILEAGE NUMBER,
187 p_EXPENSE_AMOUNT NUMBER,
188 p_CURRENCY_CODE VARCHAR2,
189 p_DEBRIEF_LINE_STATUS_ID NUMBER,
190 p_RETURN_REASON_CODE VARCHAR2,
191 p_CHANNEL_CODE VARCHAR2,
192 p_CHARGE_UPLOAD_STATUS VARCHAR2,
193 p_CHARGE_UPLOAD_MSG_CODE VARCHAR2,
194 p_CHARGE_UPLOAD_MESSAGE VARCHAR2,
195 p_IB_UPDATE_STATUS VARCHAR2,
196 p_IB_UPDATE_MSG_CODE VARCHAR2,
197 p_IB_UPDATE_MESSAGE VARCHAR2,
198 p_SPARE_UPDATE_STATUS VARCHAR2,
199 p_SPARE_UPDATE_MSG_CODE VARCHAR2,
200 p_SPARE_UPDATE_MESSAGE VARCHAR2,
201 p_CREATED_BY NUMBER,
202 p_CREATION_DATE DATE,
203 p_LAST_UPDATED_BY NUMBER,
204 p_LAST_UPDATE_DATE DATE,
205 p_LAST_UPDATE_LOGIN NUMBER,
206 p_ATTRIBUTE1 VARCHAR2,
207 p_ATTRIBUTE2 VARCHAR2,
208 p_ATTRIBUTE3 VARCHAR2,
209 p_ATTRIBUTE4 VARCHAR2,
210 p_ATTRIBUTE5 VARCHAR2,
211 p_ATTRIBUTE6 VARCHAR2,
212 p_ATTRIBUTE7 VARCHAR2,
213 p_ATTRIBUTE8 VARCHAR2,
214 p_ATTRIBUTE9 VARCHAR2,
215 p_ATTRIBUTE10 VARCHAR2,
216 p_ATTRIBUTE11 VARCHAR2,
217 p_ATTRIBUTE12 VARCHAR2,
218 p_ATTRIBUTE13 VARCHAR2,
219 p_ATTRIBUTE14 VARCHAR2,
220 p_ATTRIBUTE15 VARCHAR2,
221 p_ATTRIBUTE_CATEGORY VARCHAR2,
222 P_TRANSACTION_TYPE_ID NUMBER,
223 p_RETURN_DATE DATE,
224 p_DML_mode VARCHAR2 default NULL, --added for bug 6914559
225
226 p_usage_type varchar2 default fnd_api.g_miss_char,
227 p_dest_organization_id number default fnd_api.g_miss_num,
228 p_dest_subinventory_name varchar2 default fnd_api.g_miss_char,
229 p_carrier_code varchar2 default fnd_api.g_miss_char,
230 p_shipping_method varchar2 default fnd_api.g_miss_char,
231 p_shipment_number varchar2 default fnd_api.g_miss_char,
232 p_waybill varchar2 default fnd_api.g_miss_char,
233 p_material_transaction_id number default fnd_api.g_miss_num,
234
235 p_expenditure_org_id number default fnd_api.g_miss_num,
236 p_project_id number default fnd_api.g_miss_num,
237 p_project_task_id number default fnd_api.g_miss_num
238 );
239
240 PROCEDURE Update_Row_Forms(
241 p_DEBRIEF_LINE_ID NUMBER,
242 p_DEBRIEF_HEADER_ID NUMBER default fnd_api.g_miss_num,
243 p_DEBRIEF_LINE_NUMBER NUMBER default fnd_api.g_miss_num,
244 p_SERVICE_DATE DATE default fnd_api.g_miss_date,
245 p_BUSINESS_PROCESS_ID NUMBER default fnd_api.g_miss_num,
246 p_TXN_BILLING_TYPE_ID NUMBER default fnd_api.g_miss_num,
247 p_INVENTORY_ITEM_ID NUMBER default fnd_api.g_miss_num,
248 p_INSTANCE_ID NUMBER default fnd_api.g_miss_num,
249 p_ISSUING_INVENTORY_ORG_ID NUMBER default fnd_api.g_miss_num,
250 p_RECEIVING_INVENTORY_ORG_ID NUMBER default fnd_api.g_miss_num,
251 p_ISSUING_SUB_INVENTORY_CODE VARCHAR2 default fnd_api.g_miss_char,
252 p_RECEIVING_SUB_INVENTORY_CODE VARCHAR2 default fnd_api.g_miss_char,
253 p_ISSUING_LOCATOR_ID NUMBER default fnd_api.g_miss_num,
254 p_RECEIVING_LOCATOR_ID NUMBER default fnd_api.g_miss_num,
255 p_PARENT_PRODUCT_ID NUMBER default fnd_api.g_miss_num,
256 p_REMOVED_PRODUCT_ID NUMBER default fnd_api.g_miss_num,
257 p_STATUS_OF_RECEIVED_PART VARCHAR2 default fnd_api.g_miss_char,
258 p_ITEM_SERIAL_NUMBER VARCHAR2 default fnd_api.g_miss_char,
259 p_ITEM_REVISION VARCHAR2 default fnd_api.g_miss_char,
260 p_ITEM_LOTNUMBER VARCHAR2 default fnd_api.g_miss_char,
261 p_UOM_CODE VARCHAR2 default fnd_api.g_miss_char,
262 p_QUANTITY NUMBER default fnd_api.g_miss_num,
263 p_RMA_HEADER_ID NUMBER default fnd_api.g_miss_num,
264 p_DISPOSITION_CODE VARCHAR2 default fnd_api.g_miss_char,
265 p_MATERIAL_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
269 p_LABOR_END_DATE DATE default fnd_api.g_miss_date,
266 p_LABOR_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
267 p_EXPENSE_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
268 p_LABOR_START_DATE DATE default fnd_api.g_miss_date,
270 p_STARTING_MILEAGE NUMBER default fnd_api.g_miss_num,
271 p_ENDING_MILEAGE NUMBER default fnd_api.g_miss_num,
272 p_EXPENSE_AMOUNT NUMBER default fnd_api.g_miss_num,
273 p_CURRENCY_CODE VARCHAR2 default fnd_api.g_miss_char,
274 p_DEBRIEF_LINE_STATUS_ID NUMBER default fnd_api.g_miss_num,
275 p_RETURN_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
276 p_CHANNEL_CODE VARCHAR2 default fnd_api.g_miss_char,
277 p_CHARGE_UPLOAD_STATUS VARCHAR2 default fnd_api.g_miss_char,
278 p_CHARGE_UPLOAD_MSG_CODE VARCHAR2 default fnd_api.g_miss_char,
279 p_CHARGE_UPLOAD_MESSAGE VARCHAR2 default fnd_api.g_miss_char,
280 p_IB_UPDATE_STATUS VARCHAR2 default fnd_api.g_miss_char,
281 p_IB_UPDATE_MSG_CODE VARCHAR2 default fnd_api.g_miss_char,
282 p_IB_UPDATE_MESSAGE VARCHAR2 default fnd_api.g_miss_char,
283 p_SPARE_UPDATE_STATUS VARCHAR2 default fnd_api.g_miss_char,
284 p_SPARE_UPDATE_MSG_CODE VARCHAR2 default fnd_api.g_miss_char,
285 p_SPARE_UPDATE_MESSAGE VARCHAR2 default fnd_api.g_miss_char,
286 p_error_text VARCHAR2 default fnd_api.g_miss_char,
287 p_CREATED_BY NUMBER default fnd_api.g_miss_num,
288 p_CREATION_DATE DATE default fnd_api.g_miss_date,
289 p_LAST_UPDATED_BY NUMBER default fnd_api.g_miss_num,
290 p_LAST_UPDATE_DATE DATE default fnd_api.g_miss_date,
291 p_LAST_UPDATE_LOGIN NUMBER default fnd_api.g_miss_num,
292 p_ATTRIBUTE1 VARCHAR2 default fnd_api.g_miss_char,
293 p_ATTRIBUTE2 VARCHAR2 default fnd_api.g_miss_char,
294 p_ATTRIBUTE3 VARCHAR2 default fnd_api.g_miss_char,
295 p_ATTRIBUTE4 VARCHAR2 default fnd_api.g_miss_char,
296 p_ATTRIBUTE5 VARCHAR2 default fnd_api.g_miss_char,
297 p_ATTRIBUTE6 VARCHAR2 default fnd_api.g_miss_char,
298 p_ATTRIBUTE7 VARCHAR2 default fnd_api.g_miss_char,
299 p_ATTRIBUTE8 VARCHAR2 default fnd_api.g_miss_char,
300 p_ATTRIBUTE9 VARCHAR2 default fnd_api.g_miss_char,
301 p_ATTRIBUTE10 VARCHAR2 default fnd_api.g_miss_char,
302 p_ATTRIBUTE11 VARCHAR2 default fnd_api.g_miss_char,
303 p_ATTRIBUTE12 VARCHAR2 default fnd_api.g_miss_char,
304 p_ATTRIBUTE13 VARCHAR2 default fnd_api.g_miss_char,
305 p_ATTRIBUTE14 VARCHAR2 default fnd_api.g_miss_char,
306 p_ATTRIBUTE15 VARCHAR2 default fnd_api.g_miss_char,
307 p_ATTRIBUTE_CATEGORY VARCHAR2 default fnd_api.g_miss_char,
308 P_TRANSACTION_TYPE_ID NUMBER default fnd_api.g_miss_num,
309 p_RETURN_DATE DATE DEFAULT fnd_api.g_miss_date,
310 p_DML_mode VARCHAR2 default NULL
311 );
312
313 PROCEDURE Update_Row(
314 p_DEBRIEF_LINE_ID NUMBER,
315 p_DEBRIEF_HEADER_ID NUMBER default fnd_api.g_miss_num,
316 p_DEBRIEF_LINE_NUMBER NUMBER default fnd_api.g_miss_num,
317 p_SERVICE_DATE DATE default fnd_api.g_miss_date,
318 p_BUSINESS_PROCESS_ID NUMBER default fnd_api.g_miss_num,
319 p_TXN_BILLING_TYPE_ID NUMBER default fnd_api.g_miss_num,
320 p_INVENTORY_ITEM_ID NUMBER default fnd_api.g_miss_num,
321 p_INSTANCE_ID NUMBER default fnd_api.g_miss_num,
322 p_ISSUING_INVENTORY_ORG_ID NUMBER default fnd_api.g_miss_num,
323 p_RECEIVING_INVENTORY_ORG_ID NUMBER default fnd_api.g_miss_num,
324 p_ISSUING_SUB_INVENTORY_CODE VARCHAR2 default fnd_api.g_miss_char,
325 p_RECEIVING_SUB_INVENTORY_CODE VARCHAR2 default fnd_api.g_miss_char,
326 p_ISSUING_LOCATOR_ID NUMBER default fnd_api.g_miss_num,
327 p_RECEIVING_LOCATOR_ID NUMBER default fnd_api.g_miss_num,
328 p_PARENT_PRODUCT_ID NUMBER default fnd_api.g_miss_num,
329 p_REMOVED_PRODUCT_ID NUMBER default fnd_api.g_miss_num,
330 p_STATUS_OF_RECEIVED_PART VARCHAR2 default fnd_api.g_miss_char,
331 p_ITEM_SERIAL_NUMBER VARCHAR2 default fnd_api.g_miss_char,
332 p_ITEM_REVISION VARCHAR2 default fnd_api.g_miss_char,
333 p_ITEM_LOTNUMBER VARCHAR2 default fnd_api.g_miss_char,
334 p_UOM_CODE VARCHAR2 default fnd_api.g_miss_char,
335 p_QUANTITY NUMBER default fnd_api.g_miss_num,
336 p_RMA_HEADER_ID NUMBER default fnd_api.g_miss_num,
337 p_DISPOSITION_CODE VARCHAR2 default fnd_api.g_miss_char,
338 p_MATERIAL_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
339 p_LABOR_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
340 p_EXPENSE_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
341 p_LABOR_START_DATE DATE default fnd_api.g_miss_date,
342 p_LABOR_END_DATE DATE default fnd_api.g_miss_date,
343 p_STARTING_MILEAGE NUMBER default fnd_api.g_miss_num,
344 p_ENDING_MILEAGE NUMBER default fnd_api.g_miss_num,
345 p_EXPENSE_AMOUNT NUMBER default fnd_api.g_miss_num,
346 p_CURRENCY_CODE VARCHAR2 default fnd_api.g_miss_char,
347 p_DEBRIEF_LINE_STATUS_ID NUMBER default fnd_api.g_miss_num,
348 p_RETURN_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
349 p_CHANNEL_CODE VARCHAR2 default fnd_api.g_miss_char,
353 p_IB_UPDATE_STATUS VARCHAR2 default fnd_api.g_miss_char,
350 p_CHARGE_UPLOAD_STATUS VARCHAR2 default fnd_api.g_miss_char,
351 p_CHARGE_UPLOAD_MSG_CODE VARCHAR2 default fnd_api.g_miss_char,
352 p_CHARGE_UPLOAD_MESSAGE VARCHAR2 default fnd_api.g_miss_char,
354 p_IB_UPDATE_MSG_CODE VARCHAR2 default fnd_api.g_miss_char,
355 p_IB_UPDATE_MESSAGE VARCHAR2 default fnd_api.g_miss_char,
356 p_SPARE_UPDATE_STATUS VARCHAR2 default fnd_api.g_miss_char,
357 p_SPARE_UPDATE_MSG_CODE VARCHAR2 default fnd_api.g_miss_char,
358 p_SPARE_UPDATE_MESSAGE VARCHAR2 default fnd_api.g_miss_char,
359 p_error_text VARCHAR2 default fnd_api.g_miss_char,
360 p_CREATED_BY NUMBER default fnd_api.g_miss_num,
361 p_CREATION_DATE DATE default fnd_api.g_miss_date,
362 p_LAST_UPDATED_BY NUMBER default fnd_api.g_miss_num,
363 p_LAST_UPDATE_DATE DATE default fnd_api.g_miss_date,
364 p_LAST_UPDATE_LOGIN NUMBER default fnd_api.g_miss_num,
365 p_ATTRIBUTE1 VARCHAR2 default fnd_api.g_miss_char,
366 p_ATTRIBUTE2 VARCHAR2 default fnd_api.g_miss_char,
367 p_ATTRIBUTE3 VARCHAR2 default fnd_api.g_miss_char,
368 p_ATTRIBUTE4 VARCHAR2 default fnd_api.g_miss_char,
369 p_ATTRIBUTE5 VARCHAR2 default fnd_api.g_miss_char,
370 p_ATTRIBUTE6 VARCHAR2 default fnd_api.g_miss_char,
371 p_ATTRIBUTE7 VARCHAR2 default fnd_api.g_miss_char,
372 p_ATTRIBUTE8 VARCHAR2 default fnd_api.g_miss_char,
373 p_ATTRIBUTE9 VARCHAR2 default fnd_api.g_miss_char,
374 p_ATTRIBUTE10 VARCHAR2 default fnd_api.g_miss_char,
375 p_ATTRIBUTE11 VARCHAR2 default fnd_api.g_miss_char,
376 p_ATTRIBUTE12 VARCHAR2 default fnd_api.g_miss_char,
377 p_ATTRIBUTE13 VARCHAR2 default fnd_api.g_miss_char,
378 p_ATTRIBUTE14 VARCHAR2 default fnd_api.g_miss_char,
379 p_ATTRIBUTE15 VARCHAR2 default fnd_api.g_miss_char,
380 p_ATTRIBUTE_CATEGORY VARCHAR2 default fnd_api.g_miss_char,
381 P_TRANSACTION_TYPE_ID NUMBER default fnd_api.g_miss_num,
382 p_RETURN_DATE DATE DEFAULT fnd_api.g_miss_date,
383 p_DML_mode VARCHAR2 default NULL, --added for bug 6914559
384
385 p_usage_type varchar2 default fnd_api.g_miss_char,
386 p_dest_organization_id number default fnd_api.g_miss_num,
387 p_dest_subinventory_name varchar2 default fnd_api.g_miss_char,
388 p_carrier_code varchar2 default fnd_api.g_miss_char,
389 p_shipping_method varchar2 default fnd_api.g_miss_char,
390 p_shipment_number varchar2 default fnd_api.g_miss_char,
391 p_waybill VARCHAR2 DEFAULT
392 fnd_api.g_miss_char,
393 p_material_transaction_id number default fnd_api.g_miss_num,
394
395 p_expenditure_org_id number default fnd_api.g_miss_num,
396 p_project_id number default fnd_api.g_miss_num,
397 p_project_task_id number default fnd_api.g_miss_num
398 );
399
400 PROCEDURE Lock_Row(
401 p_DEBRIEF_LINE_ID NUMBER,
402 p_DEBRIEF_HEADER_ID NUMBER,
403 p_DEBRIEF_LINE_NUMBER NUMBER,
404 p_SERVICE_DATE DATE,
405 p_BUSINESS_PROCESS_ID NUMBER,
406 p_TXN_BILLING_TYPE_ID NUMBER,
407 p_INVENTORY_ITEM_ID NUMBER,
408 p_INSTANCE_ID NUMBER,
409 p_ISSUING_INVENTORY_ORG_ID NUMBER,
410 p_RECEIVING_INVENTORY_ORG_ID NUMBER,
411 p_ISSUING_SUB_INVENTORY_CODE VARCHAR2,
412 p_RECEIVING_SUB_INVENTORY_CODE VARCHAR2,
413 p_ISSUING_LOCATOR_ID NUMBER,
414 p_RECEIVING_LOCATOR_ID NUMBER,
415 p_PARENT_PRODUCT_ID NUMBER,
416 p_REMOVED_PRODUCT_ID NUMBER,
417 p_STATUS_OF_RECEIVED_PART VARCHAR2,
418 p_ITEM_SERIAL_NUMBER VARCHAR2,
419 p_ITEM_REVISION VARCHAR2,
420 p_ITEM_LOTNUMBER VARCHAR2,
421 p_UOM_CODE VARCHAR2,
422 p_QUANTITY NUMBER,
423 p_RMA_HEADER_ID NUMBER,
424 p_DISPOSITION_CODE VARCHAR2,
425 p_MATERIAL_REASON_CODE VARCHAR2,
426 p_LABOR_REASON_CODE VARCHAR2,
427 p_EXPENSE_REASON_CODE VARCHAR2,
428 p_LABOR_START_DATE DATE,
429 p_LABOR_END_DATE DATE,
430 p_STARTING_MILEAGE NUMBER,
431 p_ENDING_MILEAGE NUMBER,
432 p_EXPENSE_AMOUNT NUMBER,
433 p_CURRENCY_CODE VARCHAR2,
434 p_DEBRIEF_LINE_STATUS_ID NUMBER,
435 p_RETURN_REASON_CODE VARCHAR2,
436 p_CHANNEL_CODE VARCHAR2,
437 p_CHARGE_UPLOAD_STATUS VARCHAR2,
438 p_CHARGE_UPLOAD_MSG_CODE VARCHAR2,
439 p_CHARGE_UPLOAD_MESSAGE VARCHAR2,
440 p_IB_UPDATE_STATUS VARCHAR2,
441 p_IB_UPDATE_MSG_CODE VARCHAR2,
442 p_IB_UPDATE_MESSAGE VARCHAR2,
443 p_SPARE_UPDATE_STATUS VARCHAR2,
444 p_SPARE_UPDATE_MSG_CODE VARCHAR2,
445 p_SPARE_UPDATE_MESSAGE VARCHAR2,
446 p_CREATED_BY NUMBER,
450 p_LAST_UPDATE_LOGIN NUMBER,
447 p_CREATION_DATE DATE,
448 p_LAST_UPDATED_BY NUMBER,
449 p_LAST_UPDATE_DATE DATE,
451 p_ATTRIBUTE1 VARCHAR2,
452 p_ATTRIBUTE2 VARCHAR2,
453 p_ATTRIBUTE3 VARCHAR2,
454 p_ATTRIBUTE4 VARCHAR2,
455 p_ATTRIBUTE5 VARCHAR2,
456 p_ATTRIBUTE6 VARCHAR2,
457 p_ATTRIBUTE7 VARCHAR2,
458 p_ATTRIBUTE8 VARCHAR2,
459 p_ATTRIBUTE9 VARCHAR2,
460 p_ATTRIBUTE10 VARCHAR2,
461 p_ATTRIBUTE11 VARCHAR2,
462 p_ATTRIBUTE12 VARCHAR2,
463 p_ATTRIBUTE13 VARCHAR2,
464 p_ATTRIBUTE14 VARCHAR2,
465 p_ATTRIBUTE15 VARCHAR2,
466 p_ATTRIBUTE_CATEGORY VARCHAR2,
467 P_TRANSACTION_TYPE_ID NUMBER,
468 p_RETURN_DATE DATE);
469
470 PROCEDURE Delete_Row(
471 p_DEBRIEF_LINE_ID NUMBER,
472 p_DML_mode VARCHAR2 default NULL --added for bug 6914559
473 );
474
475 FUNCTION GET_RESOURCE_NAME(
476 p_resource_id number,
477 p_resource_type varchar2)
478 RETURN varchar2;
479 END CSF_DEBRIEF_LINES_PKG;
480