1 PACKAGE csfw_debrief_pub AUTHID CURRENT_USER AS
2 /*$Header: csfwdbfs.pls 120.10.12020000.3 2013/04/09 09:40:14 shadas ship $*/
3 PROCEDURE Create_Debrief_header
4 ( p_task_assignment_id IN NUMBER
5 , p_error_id OUT NOCOPY NUMBER
6 , p_error OUT NOCOPY VARCHAR2
7 , p_debrief_header_id OUT NOCOPY NUMBER
8 ) ;
9
10 PROCEDURE Create_Labor_Line
11 ( p_debrief_header_id IN NUMBER,
12 p_labor_start_date IN DATE,
13 p_labor_end_date IN DATE,
14 p_service_date IN DATE,
15 p_txn_billing_type_id IN NUMBER,
16 p_inventory_item_id IN NUMBER,
17 p_business_process_id IN NUMBER,
18 p_charge_Entry IN VARCHAR2,
19 p_incident_id IN NUMBER,
20 p_txnTypeId IN NUMBER,
21 p_quantity IN NUMBER,
22 p_uom IN VARCHAR2,
23 p_justificationCode IN VARCHAR2,
24 p_return_reason_code IN VARCHAR2,
25 p_debrief_line_id OUT NOCOPY NUMBER,
26 p_error_id OUT NOCOPY NUMBER,
27 p_error OUT NOCOPY VARCHAR2,
28 p_attribute1 IN VARCHAR2 DEFAULT '$$#@',
29 p_attribute2 IN VARCHAR2 DEFAULT '$$#@',
30 p_attribute3 IN VARCHAR2 DEFAULT '$$#@',
31 p_attribute4 IN VARCHAR2 DEFAULT '$$#@',
32 p_attribute5 IN VARCHAR2 DEFAULT '$$#@',
33 p_attribute6 IN VARCHAR2 DEFAULT '$$#@',
34 p_attribute7 IN VARCHAR2 DEFAULT '$$#@',
35 p_attribute8 IN VARCHAR2 DEFAULT '$$#@',
36 p_attribute9 IN VARCHAR2 DEFAULT '$$#@',
37 p_attribute10 IN VARCHAR2 DEFAULT '$$#@',
38 p_attribute11 IN VARCHAR2 DEFAULT '$$#@',
39 p_attribute12 IN VARCHAR2 DEFAULT '$$#@',
40 p_attribute13 IN VARCHAR2 DEFAULT '$$#@',
41 p_attribute14 IN VARCHAR2 DEFAULT '$$#@',
42 p_attribute15 IN VARCHAR2 DEFAULT '$$#@',
43 p_attribute_category IN VARCHAR2 DEFAULT '$$#@',
44
45 p_expenditure_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
46 p_project_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
47 p_project_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
48 ) ;
49
50 PROCEDURE Update_debrief_Labor_line(
51 p_debrief_line_id IN NUMBER,
52 p_labor_start_date IN DATE,
53 p_labor_end_date IN DATE,
54 p_service_date IN DATE,
55 p_txn_billing_type_id IN NUMBER,
56 p_inventory_item_id IN NUMBER,
57 p_business_process_id IN NUMBER,
58 p_charge_Entry IN VARCHAR2,
59 p_incident_id IN NUMBER,
60 p_txnTypeId IN NUMBER,
61 p_quantity IN NUMBER,
62 p_uom IN VARCHAR2,
63 p_justificationCode IN VARCHAR2,
64 p_return_reason_code IN VARCHAR2,
65 p_error_id OUT NOCOPY NUMBER,
66 p_error OUT NOCOPY VARCHAR2,
67 p_attribute1 IN VARCHAR2 DEFAULT '$$#@',
68 p_attribute2 IN VARCHAR2 DEFAULT '$$#@',
69 p_attribute3 IN VARCHAR2 DEFAULT '$$#@',
70 p_attribute4 IN VARCHAR2 DEFAULT '$$#@',
71 p_attribute5 IN VARCHAR2 DEFAULT '$$#@',
72 p_attribute6 IN VARCHAR2 DEFAULT '$$#@',
73 p_attribute7 IN VARCHAR2 DEFAULT '$$#@',
74 p_attribute8 IN VARCHAR2 DEFAULT '$$#@',
75 p_attribute9 IN VARCHAR2 DEFAULT '$$#@',
76 p_attribute10 IN VARCHAR2 DEFAULT '$$#@',
77 p_attribute11 IN VARCHAR2 DEFAULT '$$#@',
78 p_attribute12 IN VARCHAR2 DEFAULT '$$#@',
79 p_attribute13 IN VARCHAR2 DEFAULT '$$#@',
80 p_attribute14 IN VARCHAR2 DEFAULT '$$#@',
81 p_attribute15 IN VARCHAR2 DEFAULT '$$#@',
82 p_attribute_category IN VARCHAR2 DEFAULT '$$#@',
83
84 p_expenditure_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
85 p_project_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
86 p_project_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
87 );
88
89
90 PROCEDURE Create_Expense_Line
91 ( p_debrief_header_id IN NUMBER,
92 p_txn_billing_type_id IN NUMBER,
93 p_inventory_item_id IN NUMBER,
94 p_business_process_id IN NUMBER,
95 p_charge_Entry IN VARCHAR2,
96 p_incident_id IN NUMBER,
97 p_expense_amount IN NUMBER,
98 p_currency_code IN VARCHAR2,
99 p_txnTypeId IN NUMBER,
100 p_justificationCode IN VARCHAR2,
101 p_return_reason_code IN VARCHAR2,
102 p_quantity IN NUMBER,
103 p_uom_code IN VARCHAR2,
104 p_debrief_line_id OUT NOCOPY NUMBER,
105 p_error_id OUT NOCOPY NUMBER,
106 p_error OUT NOCOPY VARCHAR2,
107 p_attribute1 IN VARCHAR2 DEFAULT '$$#@',
108 p_attribute2 IN VARCHAR2 DEFAULT '$$#@',
109 p_attribute3 IN VARCHAR2 DEFAULT '$$#@',
110 p_attribute4 IN VARCHAR2 DEFAULT '$$#@',
111 p_attribute5 IN VARCHAR2 DEFAULT '$$#@',
112 p_attribute6 IN VARCHAR2 DEFAULT '$$#@',
113 p_attribute7 IN VARCHAR2 DEFAULT '$$#@',
114 p_attribute8 IN VARCHAR2 DEFAULT '$$#@',
115 p_attribute9 IN VARCHAR2 DEFAULT '$$#@',
116 p_attribute10 IN VARCHAR2 DEFAULT '$$#@',
117 p_attribute11 IN VARCHAR2 DEFAULT '$$#@',
118 p_attribute12 IN VARCHAR2 DEFAULT '$$#@',
119 p_attribute13 IN VARCHAR2 DEFAULT '$$#@',
120 p_attribute14 IN VARCHAR2 DEFAULT '$$#@',
121 p_attribute15 IN VARCHAR2 DEFAULT '$$#@',
122 p_attribute_category IN VARCHAR2 DEFAULT '$$#@',
123
124 p_expenditure_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
125 p_project_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
126 p_project_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
127 ) ;
128
129 PROCEDURE Update_debrief_Expense_line(
130 p_debrief_line_id IN NUMBER,
131 p_expense_amount IN NUMBER,
132 p_currency_code IN VARCHAR2,
133 p_txn_billing_type_id IN NUMBER,
134 p_inventory_item_id IN NUMBER,
135 p_business_process_id IN NUMBER,
136 p_charge_Entry IN VARCHAR2,
137 p_incident_id IN NUMBER,
138 p_txnTypeId IN NUMBER,
139 p_justificationCode IN VARCHAR2,
140 p_return_reason_code IN VARCHAR2,
141 p_quantity IN NUMBER,
142 p_uom_code IN VARCHAR2,
143 p_error_id OUT NOCOPY NUMBER,
144 p_error OUT NOCOPY VARCHAR2,
145 p_attribute1 IN VARCHAR2 DEFAULT '$$#@',
146 p_attribute2 IN VARCHAR2 DEFAULT '$$#@',
147 p_attribute3 IN VARCHAR2 DEFAULT '$$#@',
148 p_attribute4 IN VARCHAR2 DEFAULT '$$#@',
149 p_attribute5 IN VARCHAR2 DEFAULT '$$#@',
150 p_attribute6 IN VARCHAR2 DEFAULT '$$#@',
151 p_attribute7 IN VARCHAR2 DEFAULT '$$#@',
152 p_attribute8 IN VARCHAR2 DEFAULT '$$#@',
153 p_attribute9 IN VARCHAR2 DEFAULT '$$#@',
154 p_attribute10 IN VARCHAR2 DEFAULT '$$#@',
155 p_attribute11 IN VARCHAR2 DEFAULT '$$#@',
156 p_attribute12 IN VARCHAR2 DEFAULT '$$#@',
157 p_attribute13 IN VARCHAR2 DEFAULT '$$#@',
158 p_attribute14 IN VARCHAR2 DEFAULT '$$#@',
159 p_attribute15 IN VARCHAR2 DEFAULT '$$#@',
160 p_attribute_category IN VARCHAR2 DEFAULT '$$#@',
161
162 p_expenditure_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
163 p_project_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
164 p_project_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
165 );
166
167
168 PROCEDURE SAVE_DEBRIEF_MATERIAL_LINE (
169 p_taskid IN VARCHAR2,
170 p_taskassignmentid IN VARCHAR2,
171 p_incidentid IN VARCHAR2,
172 p_partyid IN VARCHAR2,
173 p_dbfNr IN VARCHAR2,
174 p_billingTypeId IN VARCHAR2,
175 p_txnTypeId IN VARCHAR2,
176 p_orderCategoryCode IN VARCHAR2,
177 p_txnTypeName IN VARCHAR2,
178 p_itemId IN VARCHAR2,
179 p_revisionFlag IN VARCHAR2,
180 p_businessProcessId IN VARCHAR2,
181 p_subTypeId IN VARCHAR2,
182 p_updateIBFlag IN VARCHAR2,
183 p_srcChangeOwner IN VARCHAR2,
184 p_srcChangeOwnerToCode IN VARCHAR2,
185 p_srcReferenceReqd IN VARCHAR2,
186 p_srcReturnReqd IN VARCHAR2,
187 p_parentReferenceReqd IN VARCHAR2,
188 p_srcStatusId IN VARCHAR2,
189 p_srcStatusName IN VARCHAR2,
190 p_csiTxnTypeId IN VARCHAR2,
191 p_subInv IN VARCHAR2,
192 p_orgId IN VARCHAR2,
193 p_serviceDate IN VARCHAR2,
194 p_qty IN VARCHAR2,
195 p_chgFlag IN VARCHAR2,
196 p_ibFlag IN VARCHAR2,
197 p_invFlag IN VARCHAR2,
198 p_reasonCd IN VARCHAR2,
199 p_instanceId IN VARCHAR2,
200 p_parentProductId IN VARCHAR2,
201 p_partStatusCd IN VARCHAR2,
202 p_recoveredPartId IN VARCHAR2,
203 p_retReasonCd IN VARCHAR2,
204 p_serialNr IN VARCHAR2,
205 p_lotNr IN VARCHAR2,
206 p_revisionNr IN VARCHAR2,
207 p_locatorId IN VARCHAR2,
208 p_UOM IN VARCHAR2,
209 p_updateFlag IN Number,
210 p_dbfLineId IN Number,
211 p_ret_dbfLine_id OUT NOCOPY NUMBER,
212 p_error_id OUT NOCOPY NUMBER,
213 p_error OUT NOCOPY VARCHAR2,
214 p_return_date IN VARCHAR2,
215
216 p_usage_type IN VARCHAR2,
217 p_dest_organization_id IN NUMBER,
218 p_dest_subinventory_name IN VARCHAR2,
219 p_carrier_code IN VARCHAR2,
220 p_shipping_method IN VARCHAR2,
221 p_shipment_number IN VARCHAR2,
222 p_waybill IN VARCHAR2,
223 p_attribute1 IN VARCHAR2 DEFAULT '$$#@',
224 p_attribute2 IN VARCHAR2 DEFAULT '$$#@',
225 p_attribute3 IN VARCHAR2 DEFAULT '$$#@',
226 p_attribute4 IN VARCHAR2 DEFAULT '$$#@',
227 p_attribute5 IN VARCHAR2 DEFAULT '$$#@',
228 p_attribute6 IN VARCHAR2 DEFAULT '$$#@',
229 p_attribute7 IN VARCHAR2 DEFAULT '$$#@',
230 p_attribute8 IN VARCHAR2 DEFAULT '$$#@',
231 p_attribute9 IN VARCHAR2 DEFAULT '$$#@',
232 p_attribute10 IN VARCHAR2 DEFAULT '$$#@',
233 p_attribute11 IN VARCHAR2 DEFAULT '$$#@',
234 p_attribute12 IN VARCHAR2 DEFAULT '$$#@',
235 p_attribute13 IN VARCHAR2 DEFAULT '$$#@',
236 p_attribute14 IN VARCHAR2 DEFAULT '$$#@',
237 p_attribute15 IN VARCHAR2 DEFAULT '$$#@',
238 p_attribute_category IN VARCHAR2 DEFAULT '$$#@',
239
240 p_expenditure_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
241 p_project_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
242 p_project_task_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
243 );
244
245
246 FUNCTION validate_labor_time(
247 p_resource_type_code in Varchar2,
248 p_resource_id in Number,
249 p_debrief_line_id in Number,
250 p_labor_start_date in Date,
251 p_labor_end_date in Date
252 )
253 return varchar;
254
255
256
257 /*
258 PROCEDURE UPDATE_CHARGES(
259 p_dbfLineId in number,
260 p_incidentId in number,
261 p_error out NOCOPY varchar2,
262 p_error_id out NOCOPY number
263 );
264 PROCEDURE UPDATE_IB
265 (
266 p_dbfLineId in number,
267 p_incidentId in number,
268 p_error_id out NOCOPY number,
269 p_error out NOCOPY varchar2
270 ) ;
271 PROCEDURE UPDATE_SPARES(
272 p_dbfLineId in number,
273 p_dbfNr in varchar2,
274 p_error_id out NOCOPY number,
275 p_error out NOCOPY varchar2
276 );
277 */
278
279 /* Updates info for travel debrief */
280 PROCEDURE Create_Travel_Debrief
281 ( p_task_assignment_id IN NUMBER
282 , p_debrief_header_id IN NUMBER
283 , p_start_date IN DATE
284 , p_end_date IN DATE
285 , p_distance IN NUMBER
286 , p_error_id OUT NOCOPY NUMBER
287 , p_error OUT NOCOPY VARCHAR2
288 );
289
290 -- For Debrief Header DFF
291 PROCEDURE Update_Debrief_Header
292 ( p_DEBRIEF_ID IN NUMBER,
293 p_DEBRIEF_NUMBER IN VARCHAR2 default FND_API.G_MISS_CHAR,
294 p_DEBRIEF_DATE IN DATE default FND_API.G_MISS_DATE,
295 p_DEBRIEF_STATUS_ID IN NUMBER default FND_API.G_MISS_NUM,
296 p_TASK_ASSIGNMENT_ID IN NUMBER default FND_API.G_MISS_NUM,
297 p_CREATED_BY IN NUMBER default FND_API.G_MISS_NUM,
298 p_CREATION_DATE IN DATE default FND_API.G_MISS_DATE,
299 p_LAST_UPDATED_BY IN NUMBER default FND_API.G_MISS_NUM,
300 p_LAST_UPDATE_DATE IN DATE default FND_API.G_MISS_DATE,
301 p_LAST_UPDATE_LOGIN IN NUMBER default FND_API.G_MISS_NUM,
302 p_ATTRIBUTE1 IN VARCHAR2,
303 p_ATTRIBUTE2 IN VARCHAR2,
304 p_ATTRIBUTE3 IN VARCHAR2,
305 p_ATTRIBUTE4 IN VARCHAR2,
306 p_ATTRIBUTE5 IN VARCHAR2,
307 p_ATTRIBUTE6 IN VARCHAR2,
308 p_ATTRIBUTE7 IN VARCHAR2,
309 p_ATTRIBUTE8 IN VARCHAR2,
310 p_ATTRIBUTE9 IN VARCHAR2,
311 p_ATTRIBUTE10 IN VARCHAR2,
312 p_ATTRIBUTE11 IN VARCHAR2,
313 p_ATTRIBUTE12 IN VARCHAR2,
314 p_ATTRIBUTE13 IN VARCHAR2,
315 p_ATTRIBUTE14 IN VARCHAR2,
316 p_ATTRIBUTE15 IN VARCHAR2,
317 p_ATTRIBUTE_CATEGORY IN VARCHAR2,
318 p_return_status OUT NOCOPY VARCHAR2,
319 p_error_count OUT NOCOPY NUMBER,
320 p_error OUT NOCOPY VARCHAR2
321 );
322
323 END csfw_debrief_pub;
324