[Home] [Help]
PACKAGE: APPS.CSF_DEBRIEF_LINES_PKG
Source
1 PACKAGE CSF_DEBRIEF_LINES_PKG AUTHID CURRENT_USER as
2 /* $Header: csftdbls.pls 120.1.12010000.2 2008/08/05 18:24:39 syenduri 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
82 );
83 user_hooks_rec CSF_DEBRIEF_LINES_PKG.internal_user_hooks_rec ;
84 PROCEDURE Insert_Row(
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 default NULL --added for bug 6914559
154 );
155
156 PROCEDURE Update_Row(
157 p_DEBRIEF_LINE_ID NUMBER,
158 p_DEBRIEF_HEADER_ID NUMBER default fnd_api.g_miss_num,
159 p_DEBRIEF_LINE_NUMBER NUMBER default fnd_api.g_miss_num,
160 p_SERVICE_DATE DATE default fnd_api.g_miss_date,
161 p_BUSINESS_PROCESS_ID NUMBER default fnd_api.g_miss_num,
162 p_TXN_BILLING_TYPE_ID NUMBER default fnd_api.g_miss_num,
163 p_INVENTORY_ITEM_ID NUMBER default fnd_api.g_miss_num,
164 p_INSTANCE_ID NUMBER default fnd_api.g_miss_num,
165 p_ISSUING_INVENTORY_ORG_ID NUMBER default fnd_api.g_miss_num,
166 p_RECEIVING_INVENTORY_ORG_ID NUMBER default fnd_api.g_miss_num,
167 p_ISSUING_SUB_INVENTORY_CODE VARCHAR2 default fnd_api.g_miss_char,
168 p_RECEIVING_SUB_INVENTORY_CODE VARCHAR2 default fnd_api.g_miss_char,
169 p_ISSUING_LOCATOR_ID NUMBER default fnd_api.g_miss_num,
170 p_RECEIVING_LOCATOR_ID NUMBER default fnd_api.g_miss_num,
171 p_PARENT_PRODUCT_ID NUMBER default fnd_api.g_miss_num,
172 p_REMOVED_PRODUCT_ID NUMBER default fnd_api.g_miss_num,
173 p_STATUS_OF_RECEIVED_PART VARCHAR2 default fnd_api.g_miss_char,
174 p_ITEM_SERIAL_NUMBER VARCHAR2 default fnd_api.g_miss_char,
175 p_ITEM_REVISION VARCHAR2 default fnd_api.g_miss_char,
176 p_ITEM_LOTNUMBER VARCHAR2 default fnd_api.g_miss_char,
177 p_UOM_CODE VARCHAR2 default fnd_api.g_miss_char,
178 p_QUANTITY NUMBER default fnd_api.g_miss_num,
179 p_RMA_HEADER_ID NUMBER default fnd_api.g_miss_num,
180 p_DISPOSITION_CODE VARCHAR2 default fnd_api.g_miss_char,
181 p_MATERIAL_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
182 p_LABOR_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
183 p_EXPENSE_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
184 p_LABOR_START_DATE DATE default fnd_api.g_miss_date,
185 p_LABOR_END_DATE DATE default fnd_api.g_miss_date,
186 p_STARTING_MILEAGE NUMBER default fnd_api.g_miss_num,
187 p_ENDING_MILEAGE NUMBER default fnd_api.g_miss_num,
188 p_EXPENSE_AMOUNT NUMBER default fnd_api.g_miss_num,
189 p_CURRENCY_CODE VARCHAR2 default fnd_api.g_miss_char,
190 p_DEBRIEF_LINE_STATUS_ID NUMBER default fnd_api.g_miss_num,
191 p_RETURN_REASON_CODE VARCHAR2 default fnd_api.g_miss_char,
192 p_CHANNEL_CODE VARCHAR2 default fnd_api.g_miss_char,
193 p_CHARGE_UPLOAD_STATUS VARCHAR2 default fnd_api.g_miss_char,
194 p_CHARGE_UPLOAD_MSG_CODE VARCHAR2 default fnd_api.g_miss_char,
195 p_CHARGE_UPLOAD_MESSAGE VARCHAR2 default fnd_api.g_miss_char,
196 p_IB_UPDATE_STATUS VARCHAR2 default fnd_api.g_miss_char,
197 p_IB_UPDATE_MSG_CODE VARCHAR2 default fnd_api.g_miss_char,
198 p_IB_UPDATE_MESSAGE VARCHAR2 default fnd_api.g_miss_char,
199 p_SPARE_UPDATE_STATUS VARCHAR2 default fnd_api.g_miss_char,
200 p_SPARE_UPDATE_MSG_CODE VARCHAR2 default fnd_api.g_miss_char,
201 p_SPARE_UPDATE_MESSAGE VARCHAR2 default fnd_api.g_miss_char,
202 p_error_text VARCHAR2 default fnd_api.g_miss_char,
203 p_CREATED_BY NUMBER default fnd_api.g_miss_num,
204 p_CREATION_DATE DATE default fnd_api.g_miss_date,
205 p_LAST_UPDATED_BY NUMBER default fnd_api.g_miss_num,
206 p_LAST_UPDATE_DATE DATE default fnd_api.g_miss_date,
207 p_LAST_UPDATE_LOGIN NUMBER default fnd_api.g_miss_num,
208 p_ATTRIBUTE1 VARCHAR2 default fnd_api.g_miss_char,
209 p_ATTRIBUTE2 VARCHAR2 default fnd_api.g_miss_char,
210 p_ATTRIBUTE3 VARCHAR2 default fnd_api.g_miss_char,
211 p_ATTRIBUTE4 VARCHAR2 default fnd_api.g_miss_char,
212 p_ATTRIBUTE5 VARCHAR2 default fnd_api.g_miss_char,
213 p_ATTRIBUTE6 VARCHAR2 default fnd_api.g_miss_char,
214 p_ATTRIBUTE7 VARCHAR2 default fnd_api.g_miss_char,
215 p_ATTRIBUTE8 VARCHAR2 default fnd_api.g_miss_char,
216 p_ATTRIBUTE9 VARCHAR2 default fnd_api.g_miss_char,
217 p_ATTRIBUTE10 VARCHAR2 default fnd_api.g_miss_char,
218 p_ATTRIBUTE11 VARCHAR2 default fnd_api.g_miss_char,
219 p_ATTRIBUTE12 VARCHAR2 default fnd_api.g_miss_char,
220 p_ATTRIBUTE13 VARCHAR2 default fnd_api.g_miss_char,
221 p_ATTRIBUTE14 VARCHAR2 default fnd_api.g_miss_char,
222 p_ATTRIBUTE15 VARCHAR2 default fnd_api.g_miss_char,
223 p_ATTRIBUTE_CATEGORY VARCHAR2 default fnd_api.g_miss_char,
224 P_TRANSACTION_TYPE_ID NUMBER default fnd_api.g_miss_num,
225 p_RETURN_DATE DATE default fnd_api.g_miss_date,
226 p_DML_mode VARCHAR2 default NULL --added for bug 6914559
227 );
228
229 PROCEDURE Lock_Row(
230 p_DEBRIEF_LINE_ID NUMBER,
231 p_DEBRIEF_HEADER_ID NUMBER,
232 p_DEBRIEF_LINE_NUMBER NUMBER,
233 p_SERVICE_DATE DATE,
234 p_BUSINESS_PROCESS_ID NUMBER,
235 p_TXN_BILLING_TYPE_ID NUMBER,
236 p_INVENTORY_ITEM_ID NUMBER,
237 p_INSTANCE_ID NUMBER,
238 p_ISSUING_INVENTORY_ORG_ID NUMBER,
239 p_RECEIVING_INVENTORY_ORG_ID NUMBER,
240 p_ISSUING_SUB_INVENTORY_CODE VARCHAR2,
241 p_RECEIVING_SUB_INVENTORY_CODE VARCHAR2,
242 p_ISSUING_LOCATOR_ID NUMBER,
243 p_RECEIVING_LOCATOR_ID NUMBER,
244 p_PARENT_PRODUCT_ID NUMBER,
245 p_REMOVED_PRODUCT_ID NUMBER,
246 p_STATUS_OF_RECEIVED_PART VARCHAR2,
247 p_ITEM_SERIAL_NUMBER VARCHAR2,
248 p_ITEM_REVISION VARCHAR2,
249 p_ITEM_LOTNUMBER VARCHAR2,
250 p_UOM_CODE VARCHAR2,
251 p_QUANTITY NUMBER,
252 p_RMA_HEADER_ID NUMBER,
253 p_DISPOSITION_CODE VARCHAR2,
254 p_MATERIAL_REASON_CODE VARCHAR2,
255 p_LABOR_REASON_CODE VARCHAR2,
256 p_EXPENSE_REASON_CODE VARCHAR2,
257 p_LABOR_START_DATE DATE,
258 p_LABOR_END_DATE DATE,
259 p_STARTING_MILEAGE NUMBER,
260 p_ENDING_MILEAGE NUMBER,
261 p_EXPENSE_AMOUNT NUMBER,
262 p_CURRENCY_CODE VARCHAR2,
263 p_DEBRIEF_LINE_STATUS_ID NUMBER,
264 p_RETURN_REASON_CODE VARCHAR2,
265 p_CHANNEL_CODE VARCHAR2,
266 p_CHARGE_UPLOAD_STATUS VARCHAR2,
267 p_CHARGE_UPLOAD_MSG_CODE VARCHAR2,
268 p_CHARGE_UPLOAD_MESSAGE VARCHAR2,
269 p_IB_UPDATE_STATUS VARCHAR2,
270 p_IB_UPDATE_MSG_CODE VARCHAR2,
271 p_IB_UPDATE_MESSAGE VARCHAR2,
272 p_SPARE_UPDATE_STATUS VARCHAR2,
273 p_SPARE_UPDATE_MSG_CODE VARCHAR2,
274 p_SPARE_UPDATE_MESSAGE VARCHAR2,
275 p_CREATED_BY NUMBER,
276 p_CREATION_DATE DATE,
277 p_LAST_UPDATED_BY NUMBER,
278 p_LAST_UPDATE_DATE DATE,
279 p_LAST_UPDATE_LOGIN NUMBER,
280 p_ATTRIBUTE1 VARCHAR2,
281 p_ATTRIBUTE2 VARCHAR2,
282 p_ATTRIBUTE3 VARCHAR2,
283 p_ATTRIBUTE4 VARCHAR2,
284 p_ATTRIBUTE5 VARCHAR2,
285 p_ATTRIBUTE6 VARCHAR2,
286 p_ATTRIBUTE7 VARCHAR2,
287 p_ATTRIBUTE8 VARCHAR2,
288 p_ATTRIBUTE9 VARCHAR2,
289 p_ATTRIBUTE10 VARCHAR2,
290 p_ATTRIBUTE11 VARCHAR2,
291 p_ATTRIBUTE12 VARCHAR2,
292 p_ATTRIBUTE13 VARCHAR2,
293 p_ATTRIBUTE14 VARCHAR2,
294 p_ATTRIBUTE15 VARCHAR2,
295 p_ATTRIBUTE_CATEGORY VARCHAR2,
296 P_TRANSACTION_TYPE_ID NUMBER,
297 p_RETURN_DATE DATE);
298
299 PROCEDURE Delete_Row(
300 p_DEBRIEF_LINE_ID NUMBER,
301 p_DML_mode VARCHAR2 default NULL --added for bug 6914559
302 );
303
304 FUNCTION GET_RESOURCE_NAME(
305 p_resource_id number,
306 p_resource_type varchar2)
307 RETURN varchar2;
308 END CSF_DEBRIEF_LINES_PKG;
309