[Home] [Help]
PACKAGE: APPS.CSF_DEBRIEF_PUB
Source
1 PACKAGE CSF_DEBRIEF_PUB AUTHID CURRENT_USER as
2 -- $Header: csfpdbfs.pls 120.2 2007/12/11 22:42:54 hhaugeru 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
25 -- *******************************************************
26 -- Start of Comments
27 -- -------------------------------------------------------
28 -- Record name:DEBRIEF_Rec_Type
29 -- -------------------------------------------------------
30
31 TYPE DEBRIEF_Rec_Type IS RECORD
32 (
33 DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
34 DEBRIEF_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
35 DEBRIEF_DATE DATE := FND_API.G_MISS_DATE,
36 DEBRIEF_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
37 TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
38 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
39 CREATION_DATE DATE := FND_API.G_MISS_DATE,
40 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
41 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
42 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
43 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
44 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
45 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
46 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
47 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
48 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
49 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
50 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
51 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
52 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
53 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
54 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
56 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
59 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
60 TRAVEL_START_TIME DATE := FND_API.G_MISS_DATE,
61 TRAVEL_END_TIME DATE := FND_API.G_MISS_DATE,
62 TRAVEL_DISTANCE_IN_KM NUMBER := FND_API.G_MISS_NUM
63 );
64
65 G_MISS_DEBRIEF_REC DEBRIEF_Rec_Type;
66 TYPE DEBRIEF_Tbl_Type IS TABLE OF DEBRIEF_Rec_Type
67 INDEX BY BINARY_INTEGER;
68 G_MISS_DEBRIEF_TBL DEBRIEF_Tbl_Type;
69
70 TYPE DEBRIEF_sort_rec_type IS RECORD
71 (
72 DEBRIEF_HEADER_ID NUMBER := NULL
73 );
74
75 TYPE DEBRIEF_LINE_Rec_Type IS RECORD
76 (
77 DEBRIEF_LINE_ID NUMBER := FND_API.G_MISS_NUM,
78 DEBRIEF_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
79 DEBRIEF_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
80 SERVICE_DATE DATE := FND_API.G_MISS_DATE,
81 BUSINESS_PROCESS_ID NUMBER := FND_API.G_MISS_NUM,
82 TXN_BILLING_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
83 INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
84 INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
85 ISSUING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
86 RECEIVING_INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
87 ISSUING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
88 RECEIVING_SUB_INVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
89 ISSUING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
90 RECEIVING_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
91 PARENT_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
92 REMOVED_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
93 STATUS_OF_RECEIVED_PART VARCHAR2(30) := FND_API.G_MISS_CHAR,
94 ITEM_SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
95 ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
96 ITEM_LOTNUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
97 UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
98 QUANTITY NUMBER := FND_API.G_MISS_NUM,
99 -- RMA_NUMBER NUMBER := FND_API.G_MISS_NUM,
100 RMA_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
101 DISPOSITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
102 MATERIAL_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
103 LABOR_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
104 EXPENSE_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
105 LABOR_START_DATE DATE := FND_API.G_MISS_DATE,
106 LABOR_END_DATE DATE := FND_API.G_MISS_DATE,
107 STARTING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
108 ENDING_MILEAGE NUMBER := FND_API.G_MISS_NUM,
109 EXPENSE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
110 CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
111 DEBRIEF_LINE_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
112 CHANNEL_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
113 CHARGE_UPLOAD_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
114 CHARGE_UPLOAD_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
115 CHARGE_UPLOAD_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
116 IB_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
117 IB_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
118 IB_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
119 SPARE_UPDATE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
120 SPARE_UPDATE_MSG_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
121 SPARE_UPDATE_MESSAGE VARCHAR2(240) := FND_API.G_MISS_CHAR,
122 ERROR_TEXT VARCHAR2(2000):= FND_API.G_MISS_CHAR,
123 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
124 CREATION_DATE DATE := FND_API.G_MISS_DATE,
125 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
126 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
127 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
128 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
144 RETURN_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
145 TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
146 RETURN_DATE DATE := FND_API.G_MISS_DATE,
147 MATERIAL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
148 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
149 );
150
151 G_MISS_DEBRIEF_LINE_REC DEBRIEF_LINE_Rec_Type;
152 TYPE DEBRIEF_LINE_Tbl_Type IS TABLE OF DEBRIEF_LINE_Rec_Type
153 INDEX BY BINARY_INTEGER;
154 G_MISS_DEBRIEF_LINE_TBL DEBRIEF_LINE_Tbl_Type;
155
156 TYPE DEBRIEF_LINE_sort_rec_type IS RECORD
157 (
158 DEBRIEF_LINE_ID NUMBER := NULL
159 );
160
161 -- API Name: Create_Debrief
162 --
163 /*#
164 * Creates a debrief header with lines.
165 * @param p_api_version_number Specifies the version number of the API.
166 * @param p_init_msg_list Specifies if the message stack should be cleared.
167 * @param p_commit Specifies if the api should commit the transactions.
168 * @param p_debrief_rec Record with debrief header information.
169 * @param p_debrief_line_tbl List of debrief lines to be added.
170 * @param x_debrief_header_id Returns the debrief header identifier.
171 * @param x_return_status Returns the process status.
172 * @param x_msg_count Returns the number of error messages.
173 * @param x_msg_data Returns the error messages.
174 * @rep:scope public
175 * @rep:lifecycle active
176 * @rep:displayname Create Debrief Header and Lines
177 */
178 PROCEDURE Create_DEBRIEF(
179 p_api_version_number IN NUMBER,
180 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
181 p_commit IN VARCHAR2 := FND_API.G_FALSE,
182 p_debrief_rec IN DEBRIEF_Rec_Type := G_MISS_DEBRIEF_REC,
183 p_debrief_line_tbl IN DEBRIEF_LINE_tbl_type ,
184 -- DEFAULT G_MISS_DEBRIEF_LINE_tbl,
185 x_debrief_header_id OUT NOCOPY NUMBER,
186 x_return_status OUT NOCOPY VARCHAR2,
187 x_msg_count OUT NOCOPY NUMBER,
188 x_msg_data OUT NOCOPY VARCHAR2
189 );
190
191
192 -- API Name: Update_debrief
193 /*#
194 * Updates an existing debrief header.
195 * @param p_api_version_number Specifies the version number of the API.
196 * @param p_init_msg_list Specifies if the message stack should be cleared.
197 * @param p_commit Specifies if the api should commit the transactions.
198 * @param p_debrief_rec Record with debrief header information.
199 * @param x_return_status Returns the process status.
200 * @param x_msg_count Returns the number of error messages.
201 * @param x_msg_data Returns the error messages.
202 * @rep:scope public
203 * @rep:lifecycle active
204 * @rep:displayname Update a Debrief Header
205 */
206 PROCEDURE Update_debrief(
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 DEFAULT G_MISS_DEBRIEF_REC,
211 x_return_status OUT NOCOPY VARCHAR2,
212 x_msg_count OUT NOCOPY NUMBER,
213 x_msg_data OUT NOCOPY VARCHAR2
214 );
215
216 -- Start Lead_Line part
217 -- API Name: Create_debrief_line
218 --
219
220 /*#
221 * Adds debrief lines to 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_upd_tskassgnstatus Specifies if assignment status should be changed.
226 * @param p_task_assignment_status Specifies the new assignment status.
227 * @param p_debrief_line_tbl List of debrief lines to be added.
228 * @param p_debrief_header_id Specifies the Debrief header identifier.
229 * @param p_source_object_type_code Specifies the source object type.
230 * @param x_return_status Returns the process status.
231 * @param x_msg_count Returns the number of error messages.
232 * @param x_msg_data Returns the error messages.
233 * @rep:scope public
234 * @rep:lifecycle active
235 * @rep:displayname Create Debrief Header and Lines
236 */
237 PROCEDURE Create_debrief_lines(
238 p_api_version_number IN NUMBER,
239 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
240 p_commit IN VARCHAR2 := FND_API.G_FALSE,
241 p_upd_tskassgnstatus IN VARCHAR2 DEFAULT NULL,
242 p_task_assignment_status IN VARCHAR2 DEFAULT NULL,
243 p_debrief_line_tbl IN DEBRIEF_LINE_Tbl_Type := G_MISS_DEBRIEF_LINE_Tbl,
244 p_debrief_header_id IN NUMBER,
245 p_source_object_type_code IN VARCHAR2,
246 x_return_status OUT NOCOPY VARCHAR2,
247 x_msg_count OUT NOCOPY NUMBER,
248 x_msg_data OUT NOCOPY VARCHAR2
249 );
250
251 -- API Name: Update_debrief_line
252 --
253
254 /*#
255 * Updates an existing debrief line
256 * @param p_api_version_number Specifies the version number of the API.
257 * @param p_init_msg_list Specifies if the message stack should be cleared.
258 * @param p_commit Specifies if the api should commit the transactions.
259 * @param p_upd_tskassgnstatus Specifies if assignment status should be changed.
260 * @param p_task_assignment_status Specifies the new assignment status.
261 * @param p_debrief_line_rec Record with debrief line information.
262 * @param x_return_status Returns the process status.
263 * @param x_msg_count Returns the number of error messages.
264 * @param x_msg_data Returns the error messages.
265 * @rep:scope public
266 * @rep:lifecycle active
267 * @rep:displayname Update Debrief Line
268 */
269 PROCEDURE Update_debrief_line(
270 p_api_version_number IN NUMBER,
271 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
272 p_commit IN VARCHAR2 := FND_API.G_FALSE,
273 p_upd_tskassgnstatus IN VARCHAR2 DEFAULT NULL,
274 p_task_assignment_status IN VARCHAR2 DEFAULT NULL,
275 p_debrief_line_rec IN DEBRIEF_LINE_Rec_Type,
276 x_return_status OUT NOCOPY VARCHAR2,
277 x_msg_count OUT NOCOPY NUMBER,
278 x_msg_data OUT NOCOPY VARCHAR2
279 );
280 PROCEDURE call_internal_hook (
281 p_package_name IN VARCHAR2,
282 p_api_name IN VARCHAR2,
283 p_processing_type IN VARCHAR2,
284 x_return_status OUT NOCOPY VARCHAR2
285 );
286
287 End CSF_DEBRIEF_PUB;
288