[Home] [Help]
PACKAGE: APPS.CSF_DEBRIEF_PUB
Source
1 PACKAGE CSF_DEBRIEF_PUB AUTHID CURRENT_USER as
2 -- $Header: csfpdbfs.pls 120.4.12020000.4 2013/04/09 09:40:28 shadas ship $
3 /*#
4 * This is the public interface for Debrief transactions.
5 * The interface allows upload of Material, Labor and Expense transactions.
6 * @rep:scope public
7 * @rep:product CSF
8 * @rep:displayname Debrief
9 * @rep:lifecycle active
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY CSF_TASK_DEBRIEF
12 */
13 -- Start of Comments
14 -- Package name : CSF_DEBRIEF_PUB
15 -- Purpose :
16 -- History :
17 -- NOTE :
18 -- End of Comments
19 -- Default number of records fetch per call
20
21 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
22 G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
23 G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
24 G_AUTO_DEBRIEF BOOLEAN := TRUE;
25
26 -- *******************************************************
27 -- Start of Comments
28 -- -------------------------------------------------------
29 -- Record name:DEBRIEF_Rec_Type
30 -- -------------------------------------------------------
31
32 TYPE DEBRIEF_Rec_Type IS RECORD
33 (
34 DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
35 DEBRIEF_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
36 DEBRIEF_DATE DATE := FND_API.G_MISS_DATE,
37 DEBRIEF_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
38 TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
39 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
40 CREATION_DATE DATE := FND_API.G_MISS_DATE,
41 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
42 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
43 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
44 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
45 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
46 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
47 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
48 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
49 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
50 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
51 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
52 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
53 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
54 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
56 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
60 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
61 TRAVEL_START_TIME DATE := FND_API.G_MISS_DATE,
62 TRAVEL_END_TIME DATE := FND_API.G_MISS_DATE,
63 TRAVEL_DISTANCE_IN_KM NUMBER := FND_API.G_MISS_NUM
64 );
65
66 G_MISS_DEBRIEF_REC DEBRIEF_Rec_Type;
67 TYPE DEBRIEF_Tbl_Type IS TABLE OF DEBRIEF_Rec_Type
68 INDEX BY BINARY_INTEGER;
69 G_MISS_DEBRIEF_TBL DEBRIEF_Tbl_Type;
70
71 TYPE DEBRIEF_sort_rec_type IS RECORD
72 (
73 DEBRIEF_HEADER_ID NUMBER := NULL
74 );
75
76 TYPE DEBRIEF_LINE_Rec_Type IS RECORD
77 (
78 DEBRIEF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
79 DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
80 DEBRIEF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
81 SERVICE_DATE DATE := FND_API.G_MISS_DATE,
82 BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,
83 TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
84 INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
85 INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
86 ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
87 RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
88 ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
89 RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
90 ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
91 RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
92 PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
93 REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
94 STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,
95 ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
96 ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
97 ITEM_LOTNUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
98 UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
99 QUANTITY NUMBER := FND_API.G_MISS_NUM,
100 -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,
101 RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
102 DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
103 MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
104 LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
105 EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
106 LABOR_START_DATE DATE := FND_API.G_MISS_DATE,
107 LABOR_END_DATE DATE := FND_API.G_MISS_DATE,
108 STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
109 ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
110 EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
111 CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
112 DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
113 CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
114 CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
115 CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
116 CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
117 IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
118 IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
119 IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
120 SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
121 SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
122 SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
123 ERROR_TEXT VARCHAR2(2000):= FND_API.G_MISS_CHAR,
124 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
125 CREATION_DATE DATE := FND_API.G_MISS_DATE,
126 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
127 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
128 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
129 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144 ATTRIBUTE_CATEGORY VARCHAR2(150) := FND_API.G_MISS_CHAR,
145 RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
146 TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
147 RETURN_DATE DATE := FND_API.G_MISS_DATE,
148 MATERIAL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
149 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
150
151 USAGE_TYPE VARCHAR2(10) := FND_API.G_MISS_CHAR,
152 DEST_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
153 DEST_SUBINVENTORY_NAME VARCHAR2(10) := FND_API.G_MISS_CHAR,
154 CARRIER_CODE VARCHAR2(25) := FND_API.G_MISS_CHAR,
155 SHIPPING_METHOD VARCHAR2(60) := FND_API.G_MISS_CHAR,
156 SHIPMENT_NUMBER VARCHAR2(60) := FND_API.G_MISS_CHAR,
157 WAYBILL VARCHAR2(60) := FND_API.G_MISS_CHAR,
158
159 EXPENDITURE_ORG_ID NUMBER := FND_API.G_MISS_NUM,
160 PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
161 PROJECT_TASK_ID NUMBER := FND_API.G_MISS_NUM
162 );
163
164 G_MISS_DEBRIEF_LINE_REC DEBRIEF_LINE_Rec_Type;
165 TYPE DEBRIEF_LINE_Tbl_Type IS TABLE OF DEBRIEF_LINE_Rec_Type
166 INDEX BY BINARY_INTEGER;
167 G_MISS_DEBRIEF_LINE_TBL DEBRIEF_LINE_Tbl_Type;
168
169 TYPE DEBRIEF_LINE_sort_rec_type IS RECORD
170 (
171 DEBRIEF_LINE_ID NUMBER := NULL
172 );
173
174 -- API Name: Create_Debrief
175 --
176 /*#
177 * Creates a debrief header with lines.
178 * @param p_api_version_number Specifies the version number of the API.
179 * @param p_init_msg_list Specifies if the message stack should be cleared.
180 * @param p_commit Specifies if the api should commit the transactions.
181 * @param p_debrief_rec Record with debrief header information.
182 * @param p_debrief_line_tbl List of debrief lines to be added.
183 * @param x_debrief_header_id Returns the debrief header identifier.
184 * @param x_return_status Returns the process status.
185 * @param x_msg_count Returns the number of error messages.
186 * @param x_msg_data Returns the error messages.
187 * @rep:scope public
188 * @rep:lifecycle active
189 * @rep:displayname Create Debrief Header and Lines
190 */
191 PROCEDURE Create_DEBRIEF(
192 p_api_version_number IN NUMBER,
193 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
194 p_commit IN VARCHAR2 := FND_API.G_FALSE,
195 p_debrief_rec IN DEBRIEF_Rec_Type := G_MISS_DEBRIEF_REC,
196 p_debrief_line_tbl IN DEBRIEF_LINE_tbl_type ,
197 -- DEFAULT G_MISS_DEBRIEF_LINE_tbl,
198 x_debrief_header_id OUT NOCOPY NUMBER,
199 x_return_status OUT NOCOPY VARCHAR2,
200 x_msg_count OUT NOCOPY NUMBER,
201 x_msg_data OUT NOCOPY VARCHAR2
202 );
203
204 -- Bug 12671055.
205 -- shadas - Create_Debrief overloaded procedure added for updating default dff values.
206 PROCEDURE Create_Debrief_With_Dff_Vals(
207 p_api_version_number IN NUMBER,
208 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
209 p_commit IN VARCHAR2 := FND_API.G_FALSE,
210 p_debrief_rec IN DEBRIEF_Rec_Type := G_MISS_DEBRIEF_REC,
211 p_debrief_line_tbl IN DEBRIEF_LINE_tbl_type ,
212 -- DEFAULT G_MISS_DEBRIEF_LINE_tbl,
213 x_debrief_header_id OUT NOCOPY NUMBER,
214 x_return_status OUT NOCOPY VARCHAR2,
215 x_msg_count OUT NOCOPY NUMBER,
216 x_msg_data OUT NOCOPY VARCHAR2
217 );
218
219 -- API Name: Update_debrief
220 /*#
221 * Updates an existing debrief header.
222 * @param p_api_version_number Specifies the version number of the API.
223 * @param p_init_msg_list Specifies if the message stack should be cleared.
224 * @param p_commit Specifies if the api should commit the transactions.
225 * @param p_debrief_rec Record with debrief header information.
226 * @param x_return_status Returns the process status.
227 * @param x_msg_count Returns the number of error messages.
228 * @param x_msg_data Returns the error messages.
229 * @rep:scope public
230 * @rep:lifecycle active
231 * @rep:displayname Update a Debrief Header
232 */
233 PROCEDURE Update_debrief(
234 p_api_version_number IN NUMBER,
235 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
236 p_commit IN VARCHAR2 := FND_API.G_FALSE,
237 p_debrief_rec IN DEBRIEF_Rec_Type DEFAULT G_MISS_DEBRIEF_REC,
238 x_return_status OUT NOCOPY VARCHAR2,
239 x_msg_count OUT NOCOPY NUMBER,
240 x_msg_data OUT NOCOPY VARCHAR2
241 );
242
243 -- Start Lead_Line part
244 -- API Name: Create_debrief_line
245 --
246
247 /*#
248 * Adds debrief lines to an existing debrief header
249 * @param p_api_version_number Specifies the version number of the API.
250 * @param p_init_msg_list Specifies if the message stack should be cleared.
251 * @param p_commit Specifies if the api should commit the transactions.
252 * @param p_upd_tskassgnstatus Specifies if assignment status should be changed.
253 * @param p_task_assignment_status Specifies the new assignment status.
254 * @param p_debrief_line_tbl List of debrief lines to be added.
255 * @param p_debrief_header_id Specifies the Debrief header identifier.
256 * @param p_source_object_type_code Specifies the source object type.
257 * @param x_return_status Returns the process status.
258 * @param x_msg_count Returns the number of error messages.
259 * @param x_msg_data Returns the error messages.
260 * @rep:scope public
261 * @rep:lifecycle active
262 * @rep:displayname Create Debrief Header and Lines
263 */
264 PROCEDURE Create_debrief_lines(
265 p_api_version_number IN NUMBER,
266 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
267 p_commit IN VARCHAR2 := FND_API.G_FALSE,
268 p_upd_tskassgnstatus IN VARCHAR2 DEFAULT NULL,
269 p_task_assignment_status IN VARCHAR2 DEFAULT NULL,
270 p_debrief_line_tbl IN DEBRIEF_LINE_Tbl_Type := G_MISS_DEBRIEF_LINE_Tbl,
271 p_debrief_header_id IN NUMBER,
272 p_source_object_type_code IN VARCHAR2,
273 x_return_status OUT NOCOPY VARCHAR2,
274 x_msg_count OUT NOCOPY NUMBER,
275 x_msg_data OUT NOCOPY VARCHAR2
276 );
277
278 -- API Name: Update_debrief_line
279 --
280
281 /*#
282 * Updates an existing debrief line
283 * @param p_api_version_number Specifies the version number of the API.
284 * @param p_init_msg_list Specifies if the message stack should be cleared.
285 * @param p_commit Specifies if the api should commit the transactions.
286 * @param p_upd_tskassgnstatus Specifies if assignment status should be changed.
287 * @param p_task_assignment_status Specifies the new assignment status.
288 * @param p_debrief_line_rec Record with debrief line information.
289 * @param x_return_status Returns the process status.
290 * @param x_msg_count Returns the number of error messages.
291 * @param x_msg_data Returns the error messages.
292 * @rep:scope public
293 * @rep:lifecycle active
294 * @rep:displayname Update Debrief Line
295 */
296 PROCEDURE Update_debrief_line(
297 p_api_version_number IN NUMBER,
298 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
299 p_commit IN VARCHAR2 := FND_API.G_FALSE,
300 p_upd_tskassgnstatus IN VARCHAR2 DEFAULT NULL,
301 p_task_assignment_status IN VARCHAR2 DEFAULT NULL,
302 p_debrief_line_rec IN DEBRIEF_LINE_Rec_Type,
303 x_return_status OUT NOCOPY VARCHAR2,
304 x_msg_count OUT NOCOPY NUMBER,
305 x_msg_data OUT NOCOPY VARCHAR2
306 );
307 PROCEDURE call_internal_hook (
308 p_package_name IN VARCHAR2,
309 p_api_name IN VARCHAR2,
310 p_processing_type IN VARCHAR2,
311 x_return_status OUT NOCOPY VARCHAR2
312 );
313
314 PROCEDURE set_auto_debrief (p_auto_debrief IN boolean);
315
316 End CSF_DEBRIEF_PUB;
317