1 PACKAGE csfw_debrief_pub AS
2 /*$Header: csfwdbfs.pls 120.6.12000000.3 2007/07/05 09:09:12 htank 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_debrief_line_id OUT NOCOPY NUMBER,
25 p_error_id OUT NOCOPY NUMBER,
26 p_error OUT NOCOPY VARCHAR2
27
28 ) ;
29
30 PROCEDURE Update_debrief_Labor_line(
31 p_debrief_line_id IN NUMBER,
32 p_labor_start_date IN DATE,
33 p_labor_end_date IN DATE,
34 p_service_date IN DATE,
35 p_txn_billing_type_id IN NUMBER,
36 p_inventory_item_id IN NUMBER,
37 p_business_process_id IN NUMBER,
38 p_charge_Entry IN VARCHAR2,
39 p_incident_id IN NUMBER,
40 p_txnTypeId IN NUMBER,
41 p_quantity IN NUMBER,
42 p_uom IN VARCHAR2,
43 p_justificationCode IN VARCHAR2,
44 p_error_id OUT NOCOPY NUMBER,
45 p_error OUT NOCOPY VARCHAR2
46 );
47
48
49 PROCEDURE Create_Expense_Line
50 ( p_debrief_header_id IN NUMBER,
51 p_txn_billing_type_id IN NUMBER,
52 p_inventory_item_id IN NUMBER,
53 p_business_process_id IN NUMBER,
54 p_charge_Entry IN VARCHAR2,
55 p_incident_id IN NUMBER,
56 p_expense_amount IN NUMBER,
57 p_currency_code IN VARCHAR2,
58 p_txnTypeId IN NUMBER,
59 p_justificationCode IN VARCHAR2,
60 p_quantity IN NUMBER,
61 p_uom_code IN VARCHAR2,
62 p_debrief_line_id OUT NOCOPY NUMBER,
63 p_error_id OUT NOCOPY NUMBER,
64 p_error OUT NOCOPY VARCHAR2
65 ) ;
66
67 PROCEDURE Update_debrief_Expense_line(
68 p_debrief_line_id IN NUMBER,
69 p_expense_amount IN NUMBER,
70 p_currency_code IN VARCHAR2,
71 p_txn_billing_type_id IN NUMBER,
72 p_inventory_item_id IN NUMBER,
73 p_business_process_id IN NUMBER,
74 p_charge_Entry IN VARCHAR2,
75 p_incident_id IN NUMBER,
76 p_txnTypeId IN NUMBER,
77 p_justificationCode IN VARCHAR2,
78 p_quantity IN NUMBER,
79 p_uom_code IN VARCHAR2,
80 p_error_id OUT NOCOPY NUMBER,
81 p_error OUT NOCOPY VARCHAR2
82 );
83
84
85 PROCEDURE SAVE_DEBRIEF_MATERIAL_LINE (
86 p_taskid IN VARCHAR2,
87 p_taskassignmentid IN VARCHAR2,
88 p_incidentid IN VARCHAR2,
89 p_partyid IN VARCHAR2,
90 p_dbfNr IN VARCHAR2,
91 p_billingTypeId IN VARCHAR2,
92 p_txnTypeId IN VARCHAR2,
93 p_orderCategoryCode IN VARCHAR2,
94 p_txnTypeName IN VARCHAR2,
95 p_itemId IN VARCHAR2,
96 p_revisionFlag IN VARCHAR2,
97 p_businessProcessId IN VARCHAR2,
98 p_subTypeId IN VARCHAR2,
99 p_updateIBFlag IN VARCHAR2,
100 p_srcChangeOwner IN VARCHAR2,
101 p_srcChangeOwnerToCode IN VARCHAR2,
102 p_srcReferenceReqd IN VARCHAR2,
103 p_srcReturnReqd IN VARCHAR2,
104 p_parentReferenceReqd IN VARCHAR2,
105 p_srcStatusId IN VARCHAR2,
106 p_srcStatusName IN VARCHAR2,
107 p_csiTxnTypeId IN VARCHAR2,
108 p_subInv IN VARCHAR2,
109 p_orgId IN VARCHAR2,
110 p_serviceDate IN VARCHAR2,
111 p_qty IN VARCHAR2,
112 p_chgFlag IN VARCHAR2,
113 p_ibFlag IN VARCHAR2,
114 p_invFlag IN VARCHAR2,
115 p_reasonCd IN VARCHAR2,
116 p_instanceId IN VARCHAR2,
117 p_parentProductId IN VARCHAR2,
118 p_partStatusCd IN VARCHAR2,
119 p_recoveredPartId IN VARCHAR2,
120 p_retReasonCd IN VARCHAR2,
121 p_serialNr IN VARCHAR2,
122 p_lotNr IN VARCHAR2,
123 p_revisionNr IN VARCHAR2,
124 p_locatorId IN VARCHAR2,
125 p_UOM IN VARCHAR2,
126 p_updateFlag IN Number,
127 p_dbfLineId IN Number,
128 p_ret_dbfLine_id OUT NOCOPY NUMBER,
129 p_error_id OUT NOCOPY NUMBER,
130 p_error OUT NOCOPY VARCHAR2,
131 p_return_date IN VARCHAR2
132 );
133
134
135 FUNCTION validate_labor_time(
136 p_resource_type_code in Varchar2,
137 p_resource_id in Number,
138 p_debrief_line_id in Number,
139 p_labor_start_date in Date,
140 p_labor_end_date in Date
141 )
142 return varchar;
143
144
145
146 /*
147 PROCEDURE UPDATE_CHARGES(
148 p_dbfLineId in number,
149 p_incidentId in number,
150 p_error out NOCOPY varchar2,
151 p_error_id out NOCOPY number
152 );
153 PROCEDURE UPDATE_IB
154 (
155 p_dbfLineId in number,
156 p_incidentId in number,
157 p_error_id out NOCOPY number,
158 p_error out NOCOPY varchar2
159 ) ;
160 PROCEDURE UPDATE_SPARES(
161 p_dbfLineId in number,
162 p_dbfNr in varchar2,
163 p_error_id out NOCOPY number,
164 p_error out NOCOPY varchar2
165 );
166 */
167
168 /* Updates info for travel debrief */
169 PROCEDURE Create_Travel_Debrief
170 ( p_task_assignment_id IN NUMBER
171 , p_debrief_header_id IN NUMBER
172 , p_start_date IN DATE
173 , p_end_date IN DATE
174 , p_distance IN NUMBER
175 , p_error_id OUT NOCOPY NUMBER
176 , p_error OUT NOCOPY VARCHAR2
177 );
178
179 -- For Debrief Header DFF
180 PROCEDURE Update_Debrief_Header
181 ( p_DEBRIEF_ID IN NUMBER,
182 p_DEBRIEF_NUMBER IN VARCHAR2 default FND_API.G_MISS_CHAR,
183 p_DEBRIEF_DATE IN DATE default FND_API.G_MISS_DATE,
184 p_DEBRIEF_STATUS_ID IN NUMBER default FND_API.G_MISS_NUM,
185 p_TASK_ASSIGNMENT_ID IN NUMBER default FND_API.G_MISS_NUM,
186 p_CREATED_BY IN NUMBER default FND_API.G_MISS_NUM,
187 p_CREATION_DATE IN DATE default FND_API.G_MISS_DATE,
188 p_LAST_UPDATED_BY IN NUMBER default FND_API.G_MISS_NUM,
189 p_LAST_UPDATE_DATE IN DATE default FND_API.G_MISS_DATE,
190 p_LAST_UPDATE_LOGIN IN NUMBER default FND_API.G_MISS_NUM,
191 p_ATTRIBUTE1 IN VARCHAR2,
192 p_ATTRIBUTE2 IN VARCHAR2,
193 p_ATTRIBUTE3 IN VARCHAR2,
194 p_ATTRIBUTE4 IN VARCHAR2,
195 p_ATTRIBUTE5 IN VARCHAR2,
196 p_ATTRIBUTE6 IN VARCHAR2,
197 p_ATTRIBUTE7 IN VARCHAR2,
198 p_ATTRIBUTE8 IN VARCHAR2,
199 p_ATTRIBUTE9 IN VARCHAR2,
200 p_ATTRIBUTE10 IN VARCHAR2,
201 p_ATTRIBUTE11 IN VARCHAR2,
202 p_ATTRIBUTE12 IN VARCHAR2,
203 p_ATTRIBUTE13 IN VARCHAR2,
204 p_ATTRIBUTE14 IN VARCHAR2,
205 p_ATTRIBUTE15 IN VARCHAR2,
206 p_ATTRIBUTE_CATEGORY IN VARCHAR2,
207 p_return_status OUT NOCOPY VARCHAR2,
208 p_error_count OUT NOCOPY NUMBER,
209 p_error OUT NOCOPY VARCHAR2
210 );
211
212 END csfw_debrief_pub;
213