[Home] [Help]
PACKAGE: APPS.CSD_PROCESS_PVT
Source
1 package CSD_PROCESS_PVT AUTHID CURRENT_USER as
2 /* $Header: csdvints.pls 120.15.12000000.4 2007/06/27 22:49:41 swai ship $ */
3
4 /*--------------------------------------------------*/
5 /* Record name: TASK_ACTIVITY_REC */
6 /* description : Record used for logging the */
7 /* task update activity */
8 /* */
9 /*--------------------------------------------------*/
10
11 TYPE TASK_ACTIVITY_REC IS RECORD
12 (
13 TASK_ID NUMBER,
14 REPAIR_LINE_ID NUMBER ,
15 NEW_RESOURCE_ID NUMBER ,
16 NEW_RESOURCE_TYPE_CODE VARCHAR2(30) ,
17 NEW_RESOURCE_NAME VARCHAR2(250) ,
18 OLD_RESOURCE_ID NUMBER ,
19 OLD_RESOURCE_TYPE_CODE VARCHAR2(30) ,
20 OLD_RESOURCE_NAME VARCHAR2 (250) ,
21 NEW_OWNER_ID NUMBER ,
22 NEW_OWNER_TYPE_CODE VARCHAR2 (30) ,
23 NEW_OWNER_NAME VARCHAR2 (250),
24 OLD_OWNER_ID NUMBER ,
25 OLD_OWNER_TYPE_CODE VARCHAR2 (30) ,
26 OLD_OWNER_NAME VARCHAR2 (250),
27 NEW_STATUS_ID NUMBER ,
28 NEW_STATUS VARCHAR2 (30),
29 OLD_STATUS_ID NUMBER ,
30 OLD_STATUS VARCHAR2 (30)
31
32 );
33
34 /*--------------------------------------------------*/
35 /* Record name: OM_INTERFACE_REC */
36 /* description : Record used for interfacing the */
37 /* product transaction lines */
38 /* */
39 /*--------------------------------------------------*/
40
41 TYPE OM_INTERFACE_REC IS RECORD
42 (
43 INCIDENT_ID NUMBER := FND_API.G_MISS_NUM,
44 PARTY_ID NUMBER := FND_API.G_MISS_NUM,
45 ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
46 ORG_ID NUMBER := FND_API.G_MISS_NUM,
47 ORDER_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
48 ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
49 PICKING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
50 PICK_FROM_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
51 DEF_STAGING_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
52 SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
53 SHIPPED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
54 LOCATOR_ID NUMBER := FND_API.G_MISS_NUM
55 );
56
57
58 /*--------------------------------------------------*/
59 /* Record name: SERVICE_REQUEST_REC */
60 /* description : Record used for service record */
61 /* */
62 /*--------------------------------------------------*/
63
64 TYPE service_request_rec IS RECORD
65 (
66 request_date DATE := FND_API.G_MISS_DATE,
67 type_id NUMBER := FND_API.G_MISS_NUM,
68 type_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
69 status_id NUMBER := FND_API.G_MISS_NUM,
70 status_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
71 severity_id NUMBER := FND_API.G_MISS_NUM,
72 severity_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
73 urgency_id NUMBER := FND_API.G_MISS_NUM,
74 urgency_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
75 closed_date DATE := FND_API.G_MISS_DATE,
76 owner_id NUMBER := FND_API.G_MISS_NUM,
77 owner_group_id NUMBER := FND_API.G_MISS_NUM,
78 publish_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
79 summary VARCHAR2(240):= FND_API.G_MISS_CHAR,
80 caller_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
81 customer_id NUMBER := FND_API.G_MISS_NUM,
82 customer_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
83 employee_id NUMBER := FND_API.G_MISS_NUM,
84 employee_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
85 verify_cp_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
86 customer_product_id NUMBER := FND_API.G_MISS_NUM,
87 cp_ref_number NUMBER := FND_API.G_MISS_NUM,
88 inventory_item_id NUMBER := FND_API.G_MISS_NUM,
89 inventory_org_id NUMBER := FND_API.G_MISS_NUM,
90 current_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
91 original_order_number NUMBER := FND_API.G_MISS_NUM,
92 purchase_order_num VARCHAR2(50) := FND_API.G_MISS_CHAR,
93 problem_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
94 exp_resolution_date DATE := FND_API.G_MISS_DATE,
95 bill_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
96 ship_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
97 contract_id NUMBER := FND_API.G_MISS_NUM,
98 account_id NUMBER := FND_API.G_MISS_NUM,
99 resource_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
100 cust_po_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
101 cp_revision_id NUMBER := FND_API.G_MISS_NUM,
102 inv_item_revision VARCHAR2(3) := FND_API.G_MISS_CHAR,
103 sr_contact_point_id NUMBER := FND_API.G_MISS_NUM,
104 party_id NUMBER := FND_API.G_MISS_NUM,
105 contact_point_id NUMBER := FND_API.G_MISS_NUM,
106 contact_point_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
107 primary_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
108 contact_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
109 sr_creation_channel VARCHAR2(50) := FND_API.G_MISS_CHAR,
110 incident_number VARCHAR2(64) := NULL, -- swai: FP 5157216
111 /*Fixed for bug#5589395 below column added for DFF on SR*/
112 external_context VARCHAR2(30):=NULL,
113 external_attribute_1 VARCHAR2(150):=NULL,
114 external_attribute_2 VARCHAR2(150):=NULL,
115 external_attribute_3 VARCHAR2(150):=NULL,
116 external_attribute_4 VARCHAR2(150):=NULL,
117 external_attribute_5 VARCHAR2(150):=NULL,
118 external_attribute_6 VARCHAR2(150):=NULL,
119 external_attribute_7 VARCHAR2(150):=NULL,
120 external_attribute_8 VARCHAR2(150):=NULL,
121 external_attribute_9 VARCHAR2(150):=NULL,
122 external_attribute_10 VARCHAR2(150):=NULL,
123 external_attribute_11 VARCHAR2(150):=NULL,
124 external_attribute_12 VARCHAR2(150):=NULL,
125 external_attribute_13 VARCHAR2(150):=NULL,
126 external_attribute_14 VARCHAR2(150):=NULL,
127 external_attribute_15 VARCHAR2(150):=NULL
128 );
129
130
131
132 /*--------------------------------------------------*/
133 /* Record name: PRODUCT_TXN_REC */
134 /* description : Record used for product txn */
135 /* */
136 /*--------------------------------------------------*/
137
138 /** ------------------------------------------------------------------------------------**/
139 /** In release 11.5.10, 13 new columns were added to table csd_product_transactions **/
140 /** They are source_serial_number, source_Instance_number and these columns are added **/
141 /** to the product_txn_rec and existing columns(serial_number and instance_number **/
142 /** are commented. **/
143 /** Columns Order_Header_Id and Order_Line_Id were added to table csd_product_transactions **/
144 /** table but they are not included in product_txn_rec definition as there are **/
145 /** existing columns in record definition with same name. **/
146 /** 9 Columns are added to the definition of product_Txn_rec record and they are as **/
147 /** follows (non_source_serial_number, non_source_ib_Ref_number, req_header_id, **/
148 /** req_line_id , locator_id, sub_inventory_rcvd, lot_number_rcvd **/
149 /** prd_txn_Qty_received and prd_txn_qty_shipped **/
150 /** ------------------------------------------------------------------------------------**/
151
152
153 TYPE PRODUCT_TXN_REC IS RECORD
154 (
155 product_transaction_id NUMBER := FND_API.G_MISS_NUM,
156 repair_line_id NUMBER := FND_API.G_MISS_NUM,
157 estimate_detail_id NUMBER := FND_API.G_MISS_NUM,
158 action_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
159 action_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
160 incident_id NUMBER := FND_API.G_MISS_NUM,
161 transaction_type_id NUMBER := FND_API.G_MISS_NUM,
162 business_process_id NUMBER := FND_API.G_MISS_NUM,
163 txn_billing_type_id NUMBER := FND_API.G_MISS_NUM,
164 original_source_id NUMBER := FND_API.G_MISS_NUM,
165 source_id NUMBER := FND_API.G_MISS_NUM,
166 line_type_id NUMBER := FND_API.G_MISS_NUM,
167 order_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
168 status VARCHAR2(30) := FND_API.G_MISS_CHAR,
169 currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
170 line_category_code VARCHAR2(6) := FND_API.G_MISS_CHAR,
171 unit_of_measure_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
172 inventory_item_id NUMBER := FND_API.G_MISS_NUM,
173 revision VARCHAR2(10) := FND_API.G_MISS_CHAR,
174 quantity NUMBER := FND_API.G_MISS_NUM,
175 -- ( comented serial_number as it is replaced by Source_Serial_Number 11.5.10
176 -- serial_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
177 -- (commented shipped_serial_number it is no more used from 11.5.10
178 -- shipped_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
179 lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR, -- fix for bug#4625226
180 -- (Commented instance_id as it is replaced by Source_instance_id 11.5.10
181 -- instance_id NUMBER := FND_API.G_MISS_NUM,
182 -- (commented instance number) as it is replaced by Source_instance_number 11.5.10
183 -- instance_number NUMBER := FND_API.G_MISS_NUM,
184 price_list_id NUMBER := FND_API.G_MISS_NUM,
185 contract_id NUMBER := FND_API.G_MISS_NUM,
186 coverage_id NUMBER := FND_API.G_MISS_NUM,
187 coverage_txn_group_id NUMBER := FND_API.G_MISS_NUM,
188 coverage_bill_rate_id NUMBER := FND_API.G_MISS_NUM,
189 order_header_id NUMBER := FND_API.G_MISS_NUM,
190 order_line_id NUMBER := FND_API.G_MISS_NUM,
191 sub_inventory VARCHAR2(30) := FND_API.G_MISS_CHAR,
192 organization_id NUMBER := FND_API.G_MISS_NUM,
193 invoice_to_org_id NUMBER := FND_API.G_MISS_NUM,
194 ship_to_org_id NUMBER := FND_API.G_MISS_NUM,
195 no_charge_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
196 after_warranty_cost NUMBER := FND_API.G_MISS_NUM,
197 add_to_order_flag VARCHAR2(1) := 'F',
198 new_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
199 interface_to_om_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
200 book_sales_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
201 release_sales_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
202 ship_sales_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
203 prod_txn_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
204 prod_txn_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
205 process_txn_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
206 return_reason VARCHAR2(30) := FND_API.G_MISS_CHAR,
207 return_by_date DATE := FND_API.G_MISS_DATE,
208 last_update_date DATE := FND_API.G_MISS_DATE,
209 creation_date DATE := FND_API.G_MISS_DATE,
210 last_updated_by NUMBER := FND_API.G_MISS_NUM,
211 created_by NUMBER := FND_API.G_MISS_NUM,
212 last_update_login NUMBER := FND_API.G_MISS_NUM,
213 attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214 attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215 attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216 attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217 attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218 attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219 attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
220 attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
221 attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
222 attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
223 attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
224 attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
225 attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
226 attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
227 attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
228 context VARCHAR2(30) := FND_API.G_MISS_CHAR,
229 object_version_number NUMBER := FND_API.G_MISS_NUM,
230 security_group_id NUMBER := FND_API.G_MISS_NUM,
231 po_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
232 -- Following columns are added as part of 11.5.10 release enhancments
233 -- Non source columns will be used only when repair type in
234 --(Replacement, Exchange and Advance Exchange)
235 non_source_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
236 non_source_instance_Number VARCHAR2(30) := NULL ,
237 non_source_instance_id NUMBER := FND_API.G_MISS_NUM,
238 source_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
239 -- Since instance_number is defined as Number in Charges Record assigning NULL -- value instead of G_MISS_CHAR when initialized. saupadhy Sep-12-2003
240 source_instance_number VARCHAR2(30) := NULL,
241 source_instance_id NUMBER := FND_API.G_MISS_NUM,
242 -- Requisition columns are used only for internal RO
243 req_header_id NUMBER := FND_API.G_MISS_NUM,
244 req_line_id NUMBER := FND_API.G_MISS_NUM,
245 -- Quantity received against RMA or internal so.
246 prd_txn_qty_received NUMBER := FND_API.G_MISS_NUM,
250 sub_inventory_rcvd VARCHAR2(30) := FND_API.G_MISS_CHAR,
247 -- Quantity shipped against SHIP line or internal so.
248 prd_txn_qty_shipped NUMBER := FND_API.G_MISS_NUM,
249 -- sub_inventory_rcvd column used by Internal repair order
251 -- Lot_number_Rcvd column used by Internal repair order
252 lot_number_rcvd VARCHAR2(80) := FND_API.G_MISS_CHAR, -- fix for bug#4625226
253 -- This column is used only by both regular and internal ROs, if item is locator controlled
254 locator_id NUMBER := FND_API.G_MISS_NUM,
255 charge_line_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
256 -- Add_to_Order_Id column is used by regular RO only
257 add_to_order_id NUMBER := FND_API.G_MISS_NUM,
258 --Add below col for r12
259 picking_rule_id NUMBER,
260 --R12 changes for contracts re arch
261 contract_line_id NUMBER,
262 rate_type_code VARCHAR2(40), -- This is added because charges
263 -- table has this column, this may not be used.
264 -- inventory_org changes , vijay Jan 28, 2006
265 inventory_org_id NUMBER,
266 --taklam add column for project integration
267 project_id NUMBER := FND_API.G_MISS_NUM,
268 task_id NUMBER := FND_API.G_MISS_NUM,
269 unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
270 -- swai: bug 5931926 - 3rd party logistics for 12.0.2
271 bill_to_party_id NUMBER := FND_API.G_MISS_NUM,
272 bill_to_account_id NUMBER := FND_API.G_MISS_NUM,
273 ship_to_party_id NUMBER := FND_API.G_MISS_NUM,
274 ship_to_account_id NUMBER := FND_API.G_MISS_NUM,
275 -- swai: bug 6148019 internal PO Number
276 internal_po_header_id NUMBER := FND_API.G_MISS_NUM
277 );
278
279 TYPE PRODUCT_TXN_TBL IS TABLE OF PRODUCT_TXN_REC INDEX BY BINARY_INTEGER;
280
281 -- HZ Wrappers: swai - updated to use TCA v2 records
282
283 FUNCTION GET_ORG_REC_TYPE RETURN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE;
284 FUNCTION GET_GROUP_REC_TYPE RETURN HZ_PARTY_V2PUB.GROUP_REC_TYPE;
285 FUNCTION GET_PARTY_REC_TYPE RETURN HZ_PARTY_V2PUB.PARTY_REC_TYPE;
286 FUNCTION GET_PERSON_REC_TYPE RETURN HZ_PARTY_V2PUB.PERSON_REC_TYPE;
287 FUNCTION GET_CONTACT_POINTS_REC_TYPE RETURN HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
288 FUNCTION GET_EDI_REC_TYPE RETURN HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
289 FUNCTION GET_PHONE_REC_TYPE RETURN HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
290 FUNCTION GET_EMAIL_REC_TYPE RETURN HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
291 FUNCTION GET_TELEX_REC_TYPE RETURN HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
292 FUNCTION GET_WEB_REC_TYPE RETURN HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;
293 FUNCTION GET_ACCOUNT_REC_TYPE RETURN HZ_CUST_ACCOUNT_V2PUB.CUST_ACCOUNT_REC_TYPE;
294 FUNCTION GET_PARTY_REL_REC_TYPE RETURN HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE;
295 FUNCTION GET_ORG_CONTACT_REC_TYPE RETURN HZ_PARTY_CONTACT_V2PUB.ORG_CONTACT_REC_TYPE;
296 FUNCTION GET_PARTY_SITE_REC_TYPE RETURN HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE;
297 FUNCTION GET_PARTY_SITE_USE_REC_TYPE RETURN HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE;
298 FUNCTION GET_CUST_PROFILE_REC_TYPE RETURN HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
299
300
301 -- travi changes
302 /*-------------------------------------------------------*/
303 /* Record name: CREATE_TASK_REC_TYPE */
304 /* description : Record used for Task Creation or Update */
305 /* the Task called from Depot Repair Repair Forms */
306 /*-------------------------------------------------------*/
307 TYPE CREATE_TASK_REC_TYPE IS RECORD
308 (
309 TASK_ID NUMBER := FND_API.G_MISS_NUM,
310 TASK_NAME VARCHAR2(80) := FND_API.G_MISS_CHAR,
311 TASK_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
312 DESCRIPTION VARCHAR2(4000) := FND_API.G_MISS_CHAR,
313 TASK_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
314 TASK_PRIORITY_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
315 TASK_PRIORITY_ID NUMBER := FND_API.G_MISS_NUM,
316 OWNER_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
317 OWNER_ID NUMBER := FND_API.G_MISS_NUM,
318 OWNER_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
319 ASSIGNED_BY_ID NUMBER := FND_API.G_MISS_NUM,
320 CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
321 CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
322 ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
323 PLANNED_START_DATE DATE := FND_API.G_MISS_DATE,
324 PLANNED_END_DATE DATE := FND_API.G_MISS_DATE,
325 SCHEDULED_START_DATE DATE := FND_API.G_MISS_DATE,
326 SCHEDULED_END_DATE DATE := FND_API.G_MISS_DATE,
327 ACTUAL_START_DATE DATE := FND_API.G_MISS_DATE,
328 ACTUAL_END_DATE DATE := FND_API.G_MISS_DATE,
329 TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
330 SOURCE_OBJECT_TYPE_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
331 SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
332 SOURCE_OBJECT_NAME VARCHAR2(80) := FND_API.G_MISS_CHAR,
333 DURATION NUMBER := FND_API.G_MISS_NUM,
334 DURATION_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
335 PLANNED_EFFORT NUMBER := FND_API.G_MISS_NUM,
336 PLANNED_EFFORT_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
337 ACTUAL_EFFORT NUMBER := FND_API.G_MISS_NUM,
338 ACTUAL_EFFORT_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
342 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
339 PRIVATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
340 PUBLISH_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
341 RESTRICT_CLOSURE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
343 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
344 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
345 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
346 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
347 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
348 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
349 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
350 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
351 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
352 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
353 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
354 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
355 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
356 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
357 ATTRIBUTE_CATEGORY VARCHAR2(150) := FND_API.G_MISS_CHAR,
358 BOUND_MODE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
359 SOFT_BOUND_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
360 PARENT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
361 ESCALATION_LEVEL VARCHAR2(30) := FND_API.G_MISS_CHAR,
362 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
363 );
364
365 /*---------------------------------------------------*/
366 /* Function to Return the Record Type for Creating / */
367 /* Updating the Task called from Depot Repair Forms */
368 /*---------------------------------------------------*/
369 FUNCTION GET_CREATE_TASK_REC_TYPE RETURN CSD_PROCESS_PVT.CREATE_TASK_REC_TYPE;
370
371
372 /*---------------------------------------------------*/
373 /* Record name: address_rec_type */
374 /* description : Record used for address creation */
375 /* Record Type for Creating / Updating the Customer */
376 /* Address called from Depot Repair Repair Forms */
377 /*---------------------------------------------------*/
378 TYPE address_rec_type IS RECORD
379 (
380 location_id NUMBER := FND_API.G_MISS_NUM,
381 address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
382 address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
383 address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
384 address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
385 city VARCHAR2(60) := FND_API.G_MISS_CHAR,
386 state VARCHAR2(60) := FND_API.G_MISS_CHAR,
387 postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
388 province VARCHAR2(60) := FND_API.G_MISS_CHAR,
389 county VARCHAR2(60) := FND_API.G_MISS_CHAR,
390 country VARCHAR2(60) := FND_API.G_MISS_CHAR,
391 language VARCHAR2(4) := FND_API.G_MISS_CHAR,
392 position VARCHAR2(50) := FND_API.G_MISS_CHAR,
393 address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
394 postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
395 delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
396 location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
397 -- address_error_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
398 clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
399 short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
400 description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
401 sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
402 sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
403 address_effective_date DATE := FND_API.G_MISS_DATE,
404 address_expiration_date DATE := FND_API.G_MISS_DATE,
405 address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
406 /* swai: unused TCA fields per bug #2863096, but still avail in TCA */
407 po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
408 house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
409 street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
410 street VARCHAR2(50) := FND_API.G_MISS_CHAR,
411 street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
412 floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
413 suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
414 /* swai: obsoleted TCA v1 fields
415 apartment_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
416 apartment_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
417 secondary_suffix_element VARCHAR2(240) := FND_API.G_MISS_CHAR,
418 rural_route_type VARCHAR2(50) := FND_API.G_MISS_CHAR,
419 rural_route_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
420 building VARCHAR2(50) := FND_API.G_MISS_CHAR,
421 room VARCHAR2(50) := FND_API.G_MISS_CHAR,
422 time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,
423 post_office VARCHAR2(50) := FND_API.G_MISS_CHAR,
427 wh_update_date DATE := FND_API.G_MISS_DATE
424 dodaac VARCHAR2(6) := FND_API.G_MISS_CHAR,
425 trailing_directory_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
426 life_cycle_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
428 */
429 /* swai: new TCA v2 fields */
430 timezone_id NUMBER := FND_API.G_MISS_NUM,
431 created_by_module VARCHAR2(150) := 'CSDSR',
432 application_id NUMBER := 516,
433 actual_content_source VARCHAR2(30) := FND_API.G_MISS_CHAR
434 );
435
436
437 /*---------------------------------------------------*/
438 /* R12 Quality Integration */
439 /* Record name: repair_task_type */
440 /* description : Record used for updating Depot task table */
441 /* Record Type for Creating / Updating the Quality */
442 /* specifc data called from Depot Repair Repair Forms */
443 /*---------------------------------------------------*/
444 TYPE REPAIR_TASK_REC IS RECORD
445 (
446 REPAIR_TASK_ID NUMBER,
447 TASK_ID NUMBER,
448 REPAIR_LINE_ID NUMBER ,
449 CONTEXT_VALUES VARCHAR2(10000),
450 ORG_ID NUMBER,
451 OBJECT_VERSION_NUMBER NUMBER
452
453 );
454
455 /*--------------------------------------------------*/
456 /* Function to Return the Record Type for Creating */
457 /* / Updating the Customer Address called from Depot*/
458 /* Repair Repair Forms */
459 /*--------------------------------------------------*/
460 FUNCTION GET_ADDRESS_REC_TYPE RETURN CSD_PROCESS_PVT.ADDRESS_REC_TYPE;
461
462 -- travi changes
463
464
465 /*--------------------------------------------------*/
466 /* procedure name: process_service_request */
467 /* description : procedure used to create/update */
468 /* service requests */
469 /* */
470 /*--------------------------------------------------*/
471
472 procedure PROCESS_SERVICE_REQUEST
473 ( p_api_version IN NUMBER,
474 p_commit IN VARCHAR2 := fnd_api.g_false,
475 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
476 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
477 p_action IN VARCHAR2,
478 p_incident_id IN NUMBER := NULL,
479 p_service_request_rec IN CSD_PROCESS_PVT.SERVICE_REQUEST_REC,
480 p_notes_tbl IN CS_SERVICEREQUEST_PUB.NOTES_TABLE ,
481 x_incident_id OUT NOCOPY NUMBER,
482 x_incident_number OUT NOCOPY VARCHAR2,
483 x_return_status OUT NOCOPY VARCHAR2,
484 x_msg_count OUT NOCOPY NUMBER,
485 x_msg_data OUT NOCOPY VARCHAR2 );
486
487 /*--------------------------------------------------*/
488 /* procedure name: process_service_request */
489 /* description : procedure used to create/update */
490 /* service requests */
491 /* */
492 /*--------------------------------------------------*/
493
494 procedure PROCESS_SERVICE_REQUEST
495 ( p_api_version IN NUMBER,
496 p_commit IN VARCHAR2 := fnd_api.g_false,
497 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
498 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
499 p_action IN VARCHAR2,
500 p_incident_id IN NUMBER := NULL,
501 p_service_request_rec IN CSD_PROCESS_PVT.SERVICE_REQUEST_REC,
502 x_incident_id OUT NOCOPY NUMBER,
503 x_incident_number OUT NOCOPY VARCHAR2,
504 x_return_status OUT NOCOPY VARCHAR2,
505 x_msg_count OUT NOCOPY NUMBER,
506 x_msg_data OUT NOCOPY VARCHAR2 );
507
508
509 /*--------------------------------------------------*/
510 /* procedure name: process_charge_lines */
511 /* description : procedure used to create/update */
512 /* delete charge lines */
513 /* */
514 /*--------------------------------------------------*/
515
516 procedure PROCESS_CHARGE_LINES
517 ( p_api_version IN NUMBER,
518 p_commit IN VARCHAR2 := fnd_api.g_false,
519 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
520 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
521 p_action IN VARCHAR2,
522 p_Charges_Rec IN Cs_Charge_Details_Pub.Charges_Rec_Type,
523 x_estimate_detail_id OUT NOCOPY NUMBER,
524 x_return_status OUT NOCOPY VARCHAR2,
525 x_msg_count OUT NOCOPY NUMBER,
526 x_msg_data OUT NOCOPY VARCHAR2 );
527
528
529 /*--------------------------------------------------*/
530 /* procedure name: apply_contract */
531 /* description : procedure used to apply contract */
532 /* */
533 /*--------------------------------------------------*/
534
535 procedure APPLY_CONTRACT
536 ( p_api_version IN NUMBER,
537 p_commit IN VARCHAR2 := fnd_api.g_false,
538 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
539 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
540 p_incident_id IN NUMBER,
544
541 x_return_status OUT NOCOPY VARCHAR2,
542 x_msg_count OUT NOCOPY NUMBER,
543 x_msg_data OUT NOCOPY VARCHAR2);
545 /*--------------------------------------------------*/
546 /* procedure name: ship_sales_order */
547 /* description : procedure used to ship */
548 /* sales Order */
549 /* */
550 /*--------------------------------------------------*/
551
552 procedure SHIP_SALES_ORDER
553 ( p_api_version IN NUMBER,
554 p_commit IN VARCHAR2 := fnd_api.g_false,
555 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
556 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
557 p_delivery_id IN OUT NOCOPY NUMBER,
558 x_return_status OUT NOCOPY VARCHAR2,
559 x_msg_count OUT NOCOPY NUMBER,
560 x_msg_data OUT NOCOPY VARCHAR2 );
561
562
563 /*--------------------------------------------------*/
564 /* procedure name: process_sales_order */
565 /* description : procedure used to create/book */
566 /* release and ship sales Order */
567 /* */
568 /*--------------------------------------------------*/
569
570 procedure PROCESS_SALES_ORDER
571 ( p_api_version IN NUMBER,
572 p_commit IN VARCHAR2 := fnd_api.g_false,
573 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
574 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
575 p_action IN VARCHAR2,
576 /*Fixed for bug#4433942 added product
577 txn record as in parameter
578 */
579 p_product_txn_rec IN PRODUCT_TXN_REC default null,
580 p_order_rec IN OUT NOCOPY OM_INTERFACE_REC,
581 x_return_status OUT NOCOPY VARCHAR2,
582 x_msg_count OUT NOCOPY NUMBER,
583 x_msg_data OUT NOCOPY VARCHAR2 );
584
585 /*--------------------------------------------------*/
586 /* procedure name: create_product_txn */
587 /* description : procedure used to create */
588 /* product transaction lines */
589 /* */
590 /*--------------------------------------------------*/
591
592 procedure CREATE_PRODUCT_TXN
593 ( p_api_version IN NUMBER,
594 p_commit IN VARCHAR2 := fnd_api.g_false,
595 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
596 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
597 x_product_txn_rec IN OUT NOCOPY PRODUCT_TXN_REC,
598 x_return_status OUT NOCOPY VARCHAR2,
599 x_msg_count OUT NOCOPY NUMBER,
600 x_msg_data OUT NOCOPY VARCHAR2 );
601
602 /*---------------------------------------------------*/
603 /* Procedure Name: Create_ext_prod_txn */
604 /* description : This procedure will take additional */
605 /* parameter and skip creating charge */
606 /* line based on the param
607 /*---------------------------------------------------*/
608 procedure CREATE_EXT_PROD_TXN
609 ( p_api_version IN NUMBER,
610 p_commit IN VARCHAR2 ,
611 p_init_msg_list IN VARCHAR2 ,
612 p_validation_level IN NUMBER ,
613 p_create_charge_lines IN VARCHAR2,
614 x_product_txn_rec IN OUT NOCOPY PRODUCT_TXN_REC,
615 x_return_status OUT NOCOPY VARCHAR2,
616 x_msg_count OUT NOCOPY NUMBER,
617 x_msg_data OUT NOCOPY VARCHAR2 );
618
619
620 /*--------------------------------------------------*/
621 /* procedure name: update_product_txn */
622 /* description : procedure used to update */
623 /* product transaction lines */
624 /* */
625 /*--------------------------------------------------*/
626
627 procedure UPDATE_PRODUCT_TXN
628 ( p_api_version IN NUMBER,
629 p_commit IN VARCHAR2 := fnd_api.g_false,
630 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
631 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
632 x_product_txn_rec IN OUT NOCOPY PRODUCT_TXN_REC,
633 x_return_status OUT NOCOPY VARCHAR2,
634 x_msg_count OUT NOCOPY NUMBER,
635 x_msg_data OUT NOCOPY VARCHAR2 );
636
637
638 /*--------------------------------------------------*/
639 /* procedure name: delete_product_txn */
640 /* description : procedure used to delete */
641 /* product transaction lines */
642 /* */
643 /*--------------------------------------------------*/
644
645 Procedure DELETE_PRODUCT_TXN
646 ( p_api_version IN NUMBER,
647 p_commit IN VARCHAR2 := fnd_api.g_false,
648 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
649 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
650 p_product_txn_id IN NUMBER,
651 x_return_status OUT NOCOPY VARCHAR2,
652 x_msg_count OUT NOCOPY NUMBER,
653 x_msg_data OUT NOCOPY VARCHAR2 );
654
658 /* default product transaction lines */
655 /*--------------------------------------------------*/
656 /* procedure name: create_default_prod_txn */
657 /* description : procedure used to create */
659 /* */
660 /*--------------------------------------------------*/
661
662 procedure CREATE_DEFAULT_PROD_TXN
663 ( p_api_version IN NUMBER,
664 p_commit IN VARCHAR2 := fnd_api.g_false,
665 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
666 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
667 p_repair_line_id IN NUMBER,
668 x_return_status OUT NOCOPY VARCHAR2,
669 x_msg_count OUT NOCOPY NUMBER,
670 x_msg_data OUT NOCOPY VARCHAR2 );
671
672
673 -- travi changes
674
675 /*-----------------------------------------------------------------------------------------------------------*/
676 /* procedure name: create_task */
677 /* description : procedure used to create task */
678 /* Called from : Depot Repair Form to Create Task */
679 /* Input Parm : p_api_version NUMBER Required Api Version number */
680 /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
681 /* default value is fnd_api.g_false */
682 /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
683 /* fnd_api.g_false */
684 /* p_validation_level NUMBER Optional API uses this parameter to determine which */
685 /* validation steps must be done and which steps */
686 /* should be skipped. */
687 /* CREATE_TASK_REC_TYPE RECORD Required Columns are in the Record CREATE_TASK_REC_TYPE */
688 /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
689 /* fnd_api.g_ret_sts_success (success) */
690 /* fnd_api.g_ret_sts_error (error) */
691 /* fnd_api.g_ret_sts_unexp_error (unexpected) */
692 /* x_msg_count NUMBER Number of messages in the message stack */
693 /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
694 /* x_task_id NUMBER Task Id of the created Task */
695 /*-----------------------------------------------------------------------------------------------------------*/
696 procedure CREATE_TASK
697 ( p_api_version IN NUMBER,
698 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
699 p_commit IN VARCHAR2 := fnd_api.g_false,
700 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
701 p_create_task_rec IN CREATE_TASK_REC_TYPE,
702 x_return_status OUT NOCOPY VARCHAR2,
703 x_msg_count OUT NOCOPY NUMBER,
704 x_msg_data OUT NOCOPY VARCHAR2,
705 x_task_id OUT NOCOPY NUMBER
706 );
707
708 /*-----------------------------------------------------------------------------------------------------------*/
709 /* procedure name: update_task */
710 /* description : procedure used to update task */
711 /* Called from : Depot Repair Form to Create Task */
712 /* Input Parm : p_api_version NUMBER Required Api Version number */
713 /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
714 /* default value is fnd_api.g_false */
715 /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
716 /* fnd_api.g_false */
717 /* p_validation_level NUMBER Optional API uses this parameter to determine which */
718 /* validation steps must be done and which steps */
719 /* should be skipped. */
720 /* CREATE_TASK_REC_TYPE RECORD Required Columns are in the Record CREATE_TASK_REC_TYPE */
721 /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
722 /* fnd_api.g_ret_sts_success (success) */
723 /* fnd_api.g_ret_sts_error (error) */
724 /* fnd_api.g_ret_sts_unexp_error (unexpected) */
728
725 /* x_msg_count NUMBER Number of messages in the message stack */
726 /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
727 /*-----------------------------------------------------------------------------------------------------------*/
729 procedure UPDATE_TASK
730 ( p_api_version IN NUMBER,
731 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
732 p_commit IN VARCHAR2 := fnd_api.g_false,
733 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
734 p_create_task_rec IN CREATE_TASK_REC_TYPE,
735 x_return_status OUT NOCOPY VARCHAR2,
736 x_msg_count OUT NOCOPY NUMBER,
737 x_msg_data OUT NOCOPY VARCHAR2
738 );
739
740
741 /*-----------------------------------------------------------------------------------------------------------*/
742 /* procedure name: create_address */
743 /* description : procedure to create Address for the Contact */
744 /* Called from : Depot Repair Form to Create Address */
745 /* Input Parm : p_address_rec RECORD Required Record ADDRESS_REC_TYPE */
746 /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
747 /* fnd_api.g_ret_sts_success (success) */
748 /* fnd_api.g_ret_sts_error (error) */
749 /* fnd_api.g_ret_sts_unexp_error (unexpected) */
750 /* x_msg_count NUMBER Number of messages in the message stack */
751 /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
752 /* x_location_id NUMBER Location ID of the Contacts address created */
753 /*-----------------------------------------------------------------------------------------------------------*/
754 procedure CREATE_ADDRESS
755 (
756 p_address_rec IN ADDRESS_REC_TYPE,
757 x_msg_count OUT NOCOPY NUMBER,
758 x_msg_data OUT NOCOPY VARCHAR2,
759 x_return_status OUT NOCOPY VARCHAR2,
760 x_location_id OUT NOCOPY NUMBER);
761
762
763 /*-----------------------------------------------------------------------------------------------------------*/
764 /* procedure name: Create_repair_task_hist */
765 /* description : procedure used to create Repair Order history */
766 /* for task creation */
767 /* Called from : Depot Repair Form to Create Address */
768 /* Input Parm : p_api_version NUMBER Required Api Version number */
769 /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
770 /* default value is fnd_api.g_false */
771 /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
772 /* fnd_api.g_false */
773 /* p_validation_level NUMBER Optional API uses this parameter to determine which */
774 /* validation steps must be done and which steps */
775 /* should be skipped. */
776 /* p_task_id NUMBER Required Task Id */
777 /* p_repair_line_id NUMBER Required Repair_line_id */
778 /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
779 /* fnd_api.g_ret_sts_success (success) */
780 /* fnd_api.g_ret_sts_error (error) */
781 /* fnd_api.g_ret_sts_unexp_error (unexpected) */
782 /* x_msg_count NUMBER Number of messages in the message stack */
783 /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
784 /*-----------------------------------------------------------------------------------------------------------*/
785
786 PROCEDURE Create_repair_task_hist
787 ( p_api_version IN NUMBER,
788 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
789 p_commit IN VARCHAR2 := fnd_api.g_false,
790 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
791 p_task_id IN NUMBER,
792 p_repair_line_id IN NUMBER,
793 x_return_status OUT NOCOPY VARCHAR2,
794 x_msg_count OUT NOCOPY NUMBER,
795 x_msg_data OUT NOCOPY VARCHAR2
796 );
797
798 /*-----------------------------------------------------------------------------------------------------------*/
799 /* procedure name: Create_repair_task_hist */
800 /* description : procedure used to create Repair Order history */
801 /* for task creation */
802 /* Called from : Depot Repair Form to Create Address */
803 /* Input Parm : p_api_version NUMBER Required Api Version number */
804 /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
805 /* default value is fnd_api.g_false */
806 /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
807 /* fnd_api.g_false */
808 /* p_validation_level NUMBER Optional API uses this parameter to determine which */
809 /* validation steps must be done and which steps */
810 /* should be skipped.
811 /* p_task_activity_rec CSD_PROCESS_PVT.TASK_ACTIVITY_REC Used for logging task activity */
812 /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
813 /* fnd_api.g_ret_sts_success (success) */
814 /* fnd_api.g_ret_sts_error (error) */
815 /* fnd_api.g_ret_sts_unexp_error (unexpected) */
816 /* x_msg_count NUMBER Number of messages in the message stack */
817 /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
818 /*-----------------------------------------------------------------------------------------------------------*/
819
820 PROCEDURE Create_repair_task_hist
821 ( p_api_version IN NUMBER,
822 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
823 p_commit IN VARCHAR2 := fnd_api.g_false,
824 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
825 p_task_activity_rec IN CSD_PROCESS_PVT.TASK_ACTIVITY_REC,
826 x_return_status OUT NOCOPY VARCHAR2,
827 x_msg_count OUT NOCOPY NUMBER,
828 x_msg_data OUT NOCOPY VARCHAR2
829 );
830
831
832 /*-----------------------------------------------------------------------------------------------------------*/
833 /* procedure name: Update_repair_task_hist */
834 /* description : procedure used to Update Repair Order history */
835 /* for task creation */
836 /* Called from : Depot Repair Form to update to Repair history */
837 /* Input Parm : p_api_version NUMBER Required Api Version number */
838 /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
839 /* default value is fnd_api.g_false */
840 /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
841 /* fnd_api.g_false */
842 /* p_validation_level NUMBER Optional API uses this parameter to determine which */
843 /* validation steps must be done and which steps */
844 /* should be skipped. */
845 /* p_task_acticity_rec TASK_ACTIVITY_REC Required Used to log activity */
846 /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
847 /* fnd_api.g_ret_sts_success (success) */
848 /* fnd_api.g_ret_sts_error (error) */
849 /* fnd_api.g_ret_sts_unexp_error (unexpected) */
850 /* x_msg_count NUMBER Number of messages in the message stack */
851 /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
855 PROCEDURE Update_repair_task_hist
852 /*-----------------------------------------------------------------------------------------------------------*/
853
854 /*
856 ( p_api_version IN NUMBER,
857 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
858 p_commit IN VARCHAR2 := fnd_api.g_false,
859 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
860 p_task_id IN NUMBER,
861 p_repair_line_id IN NUMBER,
862 x_return_status OUT NOCOPY VARCHAR2,
863 x_msg_count OUT NOCOPY NUMBER,
864 x_msg_data OUT NOCOPY VARCHAR2
865 );*/
866 --sangiguptask
867 /*-----------------------------------------------------------------------------------------------------------*/
868 /* procedure name: Update_repair_task_hist */
869 /* description : procedure used to Update Repair Order history */
870 /* for task creation */
871 /* Called from : Depot Repair Form to update to Repair history */
872 /* Input Parm : p_api_version NUMBER Required Api Version number */
873 /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
874 /* default value is fnd_api.g_false */
875 /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
876 /* fnd_api.g_false */
877 /* p_validation_level NUMBER Optional API uses this parameter to determine which */
878 /* validation steps must be done and which steps */
879 /* should be skipped. */
880 /* p_activity_rec TASK_ACTIVITY_REC Required Task activity record*/
881 /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
882 /* fnd_api.g_ret_sts_success (success) */
883 /* fnd_api.g_ret_sts_error (error) */
884 /* fnd_api.g_ret_sts_unexp_error (unexpected) */
885 /* x_msg_count NUMBER Number of messages in the message stack */
886 /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
887 /*-----------------------------------------------------------------------------------------------------------*/
888
889 PROCEDURE Update_repair_task_hist
890 ( p_api_version IN NUMBER,
891 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
892 p_commit IN VARCHAR2 := fnd_api.g_false,
893 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
894 p_task_activity_rec IN CSD_PROCESS_PVT.TASK_ACTIVITY_REC,
895 x_return_status OUT NOCOPY VARCHAR2,
896 x_msg_count OUT NOCOPY NUMBER,
897 x_msg_data OUT NOCOPY VARCHAR2
898 );
899 -- travi changes
900
901 /*----------------------------------------------------------------*/
902 /* procedure name: Close_Status */
903 /* description : procedure used to Close RO /Group RO and SR */
904 /*----------------------------------------------------------------*/
905
906 PROCEDURE Close_status
907 ( p_api_version IN NUMBER,
908 p_commit IN VARCHAR2 := fnd_api.g_false,
909 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
910 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
911 p_incident_id IN NUMBER,
912 p_repair_line_id IN NUMBER,
913 x_return_status OUT NOCOPY VARCHAR2,
914 x_msg_count OUT NOCOPY NUMBER,
915 x_msg_data OUT NOCOPY VARCHAR2
916 );
917
918 /*---------------------------------------------------------------*/
919 /* procedure name: Check_Service_Request */
920 /* Description: procedure used to find if there are unasigned */
921 /* RMA/SO lines for the given service request */
922 /*---------------------------------------------------------------*/
923 PROCEDURE Check_Service_Request
924 ( p_api_version IN NUMBER,
925 p_commit IN VARCHAR2 := fnd_api.g_false,
926 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
927 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
928 p_incident_id IN NUMBER,
929 x_link_mode OUT NOCOPY NUMBER,
930 x_return_status OUT NOCOPY VARCHAR2,
931 x_msg_count OUT NOCOPY NUMBER,
932 x_msg_data OUT NOCOPY VARCHAR2
933 );
934
935 /*---------------------------------------------------------------*/
936 /* procedure name: Update_Line_Txn_Source */
937 /* Description: procedure used to update the source_code and */
938 /* source_id of the line transaction */
939 /*---------------------------------------------------------------*/
940 PROCEDURE Update_Line_Txn_Source
941 ( p_api_version IN NUMBER,
942 p_commit IN VARCHAR2,
946 p_estimate_detail_line_id IN NUMBER,
943 p_init_msg_list IN VARCHAR2,
944 p_validation_level IN NUMBER,
945 p_incident_id IN NUMBER,
947 p_repair_line_id IN NUMBER,
948 x_return_status OUT NOCOPY VARCHAR2,
949 x_msg_count OUT NOCOPY NUMBER,
950 x_msg_data OUT NOCOPY VARCHAR2
951 );
952
953
954 /*---------------------------------------------------------------------------------*/
955 /* procedure name: Update_iro_product_txn */
956 /* Description: procedure used to update the product transaction */
957 /* table and process pick release and shipping */
958 /* transactions for internal ROs. */
959 /* p_api_version Standard in parameter */
960 /* p_commit Standard in parameter */
961 /* p_init_msg_list Standard in parameter */
962 /* p_validation_level Standard in parameter */
963 /* x_return_status Standard Out parameter */
964 /* x_msg_count Standard in parameter */
965 /* x_msg_data Standard in parameter , */
966 /* x_product_txn_rec in out record variable of type */
967 /* csd_process_pvt.product_txn_rec ) ; */
968 /*---------------------------------------------------------------------------------*/
969 Procedure update_iro_product_txn
970 ( p_api_version in number,
971 p_commit in varchar2 ,
972 p_init_msg_list in varchar2 ,
973 p_validation_level in number ,
974 x_product_txn_rec in out nocopy csd_process_pvt.product_txn_rec ,
975 x_return_status out nocopy varchar2,
976 x_msg_count out nocopy number,
977 x_msg_data out nocopy varchar2 );
978
979
980 /******************* ************* **********************/
981 /*------------------------------------------------------*/
982 /* - Add Logistics_KeyAttr_Rec_Type */
983 /*------------------------------------------------------*/
984 /* Record name: Logistics_KeyAttr_Rec_Type */
985 /* description: Record used for returning entities */
986 /* for a given repair line id */
987 /* */
988 /*------------------------------------------------------*/
989 Type Logistics_KeyAttr_Rec_Type IS Record
990 ( Product_Transaction_Id NUMBER, -- Primary Key for table csd_product_Transactions table.
991 Estimate_Detail_id NUMBER, -- Primary Key for table cs_estimate_Details
992 Order_Header_Id NUMBER, -- Primar key for oe_order_headers_all
993 Order_Line_Id NUMBER) ; -- Primary Key for oe_Order_Lines_all
994
995 TYPE Logistics_KeyAttr_Tbl_Type IS TABLE OF Logistics_KeyAttr_Rec_Type INDEX BY BINARY_INTEGER;
996 /***************** ************* ************************/
997
998
999
1000 -- Bug# 3877328 forward porting bug
1001 /*----------------------------------------------------------------------*/
1002 /* procedure name: create_default_prod_txn_wrapr */
1003 /* description : Is a wrapper procedure which does validations before */
1004 /* calling procedure create_default_prod_txn. */
1005 /* This API will have same parameters as procedure */
1006 /* create_default_prod_txn. After successful validation */
1007 /* wrapper API will pass same input parameters. */
1008 /**************** ************* *****************************************/
1009 /* - Add Logistics_KeyAttr_Tbl_Type
1010 /*----------------------------------------------------------------------*/
1011 procedure CREATE_DEFAULT_PROD_TXN_wrapr
1012 ( p_api_version IN NUMBER,
1013 p_commit IN VARCHAR2,
1014 p_init_msg_list IN VARCHAR2,
1015 p_validation_level IN NUMBER,
1016 p_repair_line_id IN NUMBER,
1017 x_return_status OUT NOCOPY VARCHAR2,
1018 x_msg_count OUT NOCOPY NUMBER,
1019 x_msg_data OUT NOCOPY VARCHAR2,
1020 x_Logistics_KeyAttr_Tbl OUT NOCOPY CSD_PROCESS_PVT.Logistics_KeyAttr_Tbl_Type );
1021
1022 /*-----------------------------------------------------------------------------------------------------------*/
1023 /* R12 Quality Integration */
1024 /* procedure name: create_repair_task */
1025 /* description : procedure used to create DR specific tasks in Depot tables */
1026 /* Called from : Depot Repair Form to Create Task */
1027 /* Input Parm : p_api_version NUMBER Required Api Version number */
1028 /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
1029 /* default value is fnd_api.g_false */
1030 /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
1031 /* fnd_api.g_false */
1035 /* p_CREATE_REPAIR_TASK_REC RECORD Required Columns are in the Record CREATE_REPAIR_TASK_REC_TYPE */
1032 /* p_validation_level NUMBER Optional API uses this parameter to determine which */
1033 /* validation steps must be done and which steps */
1034 /* should be skipped. */
1036 /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
1037 /* fnd_api.g_ret_sts_success (success) */
1038 /* fnd_api.g_ret_sts_error (error) */
1039 /* fnd_api.g_ret_sts_unexp_error (unexpected) */
1040 /* x_msg_count NUMBER Number of messages in the message stack */
1041 /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
1042 /* x_repair_task_id NUMBER Task Id of the created Task */
1043 /*-----------------------------------------------------------------------------------------------------------*/
1044 procedure CREATE_REPAIR_TASK
1045 ( p_api_version IN NUMBER,
1046 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1047 p_commit IN VARCHAR2 := fnd_api.g_false,
1048 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1049 p_create_repair_task_rec IN REPAIR_TASK_REC,
1050 x_return_status OUT NOCOPY VARCHAR2,
1051 x_msg_count OUT NOCOPY NUMBER,
1052 x_msg_data OUT NOCOPY VARCHAR2,
1053 x_repair_task_id OUT NOCOPY NUMBER
1054 );
1055
1056 /*-----------------------------------------------------------------------------------------------------------*/
1057 /* R12 Quality Integration */
1058 /* procedure name: update_repair_task */
1059 /* description : procedure used to update DR specifc task in Depot tables */
1060 /* Called from : Depot Repair Form to Update DR specifc Task */
1061 /* Input Parm : p_api_version NUMBER Required Api Version number */
1062 /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
1063 /* default value is fnd_api.g_false */
1064 /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
1065 /* fnd_api.g_false */
1066 /* p_validation_level NUMBER Optional API uses this parameter to determine which */
1067 /* validation steps must be done and which steps */
1068 /* should be skipped. */
1069 /* CREATE_REPAIR_TASK_REC RECORD Required Columns are in the Record CREATE_REPAIR_TASK_REC_TYPE */
1070 /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
1071 /* fnd_api.g_ret_sts_success (success) */
1072 /* fnd_api.g_ret_sts_error (error) */
1073 /* fnd_api.g_ret_sts_unexp_error (unexpected) */
1074 /* x_msg_count NUMBER Number of messages in the message stack */
1075 /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
1076 /*-----------------------------------------------------------------------------------------------------------*/
1077
1078 procedure UPDATE_REPAIR_TASK
1079 ( p_api_version IN NUMBER,
1080 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1081 p_commit IN VARCHAR2 := fnd_api.g_false,
1082 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1083 p_update_repair_task_rec IN REPAIR_TASK_REC,
1084 x_return_status OUT NOCOPY VARCHAR2,
1085 x_msg_count OUT NOCOPY NUMBER,
1086 x_msg_data OUT NOCOPY VARCHAR2
1087 );
1088 /*---------------------------------------------------*/
1089 /* Function to Return the Record Type for Creating / */
1090 /* Updating the Repair Task called from Depot Repair Forms */
1091 /*---------------------------------------------------*/
1092 FUNCTION GET_REPAIR_TASK_REC RETURN CSD_PROCESS_PVT.REPAIR_TASK_REC;
1093 G_DEPOT_REPAIR_TXN_NUMBER CONSTANT NUMBER := 2005;
1094
1095 END CSD_PROCESS_PVT;