[Home] [Help]
PACKAGE: APPS.CSD_PROCESS_PVT
Source
1 package CSD_PROCESS_PVT AUTHID CURRENT_USER as
2 /* $Header: csdvints.pls 120.20 2011/04/12 17:42:42 subhat 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,
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
250 sub_inventory_rcvd VARCHAR2(30) := FND_API.G_MISS_CHAR,
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,
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,
342 ATTRIBUTE1 VARCHAR2(150) := 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,
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,
427 wh_update_date DATE := FND_API.G_MISS_DATE
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,
541 x_return_status OUT NOCOPY VARCHAR2,
542 x_msg_count OUT NOCOPY NUMBER,
543 x_msg_data OUT NOCOPY VARCHAR2);
544
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
655 /*--------------------------------------------------*/
656 /* procedure name: create_default_prod_txn */
657 /* description : procedure used to create */
658 /* default product transaction lines */
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 p_create_thirdpty_line IN VARCHAR2 := fnd_api.g_false,
669 p_return_reason_code IN VARCHAR2 := NULL,
670 p_invoice_to_org_id IN NUMBER := NULL,
671 p_ship_to_org_id IN NUMBER := NULL,
672 x_return_status OUT NOCOPY VARCHAR2,
673 x_msg_count OUT NOCOPY NUMBER,
674 x_msg_data OUT NOCOPY VARCHAR2 );
675
676
677 -- travi changes
678
679 /*-----------------------------------------------------------------------------------------------------------*/
680 /* procedure name: create_task */
681 /* description : procedure used to create task */
682 /* Called from : Depot Repair Form to Create Task */
683 /* Input Parm : p_api_version NUMBER Required Api Version number */
684 /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
685 /* default value is fnd_api.g_false */
686 /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
687 /* fnd_api.g_false */
688 /* p_validation_level NUMBER Optional API uses this parameter to determine which */
689 /* validation steps must be done and which steps */
690 /* should be skipped. */
691 /* CREATE_TASK_REC_TYPE RECORD Required Columns are in the Record CREATE_TASK_REC_TYPE */
692 /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
693 /* fnd_api.g_ret_sts_success (success) */
694 /* fnd_api.g_ret_sts_error (error) */
695 /* fnd_api.g_ret_sts_unexp_error (unexpected) */
696 /* x_msg_count NUMBER Number of messages in the message stack */
697 /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
698 /* x_task_id NUMBER Task Id of the created Task */
699 /*-----------------------------------------------------------------------------------------------------------*/
700 procedure CREATE_TASK
701 ( p_api_version IN NUMBER,
702 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
703 p_commit IN VARCHAR2 := fnd_api.g_false,
704 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
705 p_create_task_rec IN CREATE_TASK_REC_TYPE,
706 x_return_status OUT NOCOPY VARCHAR2,
707 x_msg_count OUT NOCOPY NUMBER,
708 x_msg_data OUT NOCOPY VARCHAR2,
709 x_task_id OUT NOCOPY NUMBER
710 );
711
712 /*-----------------------------------------------------------------------------------------------------------*/
713 /* procedure name: update_task */
714 /* description : procedure used to update task */
715 /* Called from : Depot Repair Form to Create Task */
716 /* Input Parm : p_api_version NUMBER Required Api Version number */
717 /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
718 /* default value is fnd_api.g_false */
719 /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
720 /* fnd_api.g_false */
721 /* p_validation_level NUMBER Optional API uses this parameter to determine which */
722 /* validation steps must be done and which steps */
723 /* should be skipped. */
724 /* CREATE_TASK_REC_TYPE RECORD Required Columns are in the Record CREATE_TASK_REC_TYPE */
725 /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
726 /* fnd_api.g_ret_sts_success (success) */
727 /* fnd_api.g_ret_sts_error (error) */
728 /* fnd_api.g_ret_sts_unexp_error (unexpected) */
729 /* x_msg_count NUMBER Number of messages in the message stack */
730 /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
731 /*-----------------------------------------------------------------------------------------------------------*/
732
733 procedure UPDATE_TASK
734 ( p_api_version IN NUMBER,
735 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
736 p_commit IN VARCHAR2 := fnd_api.g_false,
737 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
738 p_create_task_rec IN CREATE_TASK_REC_TYPE,
739 x_return_status OUT NOCOPY VARCHAR2,
740 x_msg_count OUT NOCOPY NUMBER,
741 x_msg_data OUT NOCOPY VARCHAR2
742 );
743
744
745 /*-----------------------------------------------------------------------------------------------------------*/
746 /* procedure name: create_address */
747 /* description : procedure to create Address for the Contact */
748 /* Called from : Depot Repair Form to Create Address */
749 /* Input Parm : p_address_rec RECORD Required Record ADDRESS_REC_TYPE */
750 /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
751 /* fnd_api.g_ret_sts_success (success) */
752 /* fnd_api.g_ret_sts_error (error) */
753 /* fnd_api.g_ret_sts_unexp_error (unexpected) */
754 /* x_msg_count NUMBER Number of messages in the message stack */
755 /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
756 /* x_location_id NUMBER Location ID of the Contacts address created */
757 /*-----------------------------------------------------------------------------------------------------------*/
758 procedure CREATE_ADDRESS
759 (
760 p_address_rec IN ADDRESS_REC_TYPE,
761 x_msg_count OUT NOCOPY NUMBER,
762 x_msg_data OUT NOCOPY VARCHAR2,
763 x_return_status OUT NOCOPY VARCHAR2,
764 x_location_id OUT NOCOPY NUMBER);
765
766
767 /*-----------------------------------------------------------------------------------------------------------*/
768 /* procedure name: Create_repair_task_hist */
769 /* description : procedure used to create Repair Order history */
770 /* for task creation */
771 /* Called from : Depot Repair Form to Create Address */
772 /* Input Parm : p_api_version NUMBER Required Api Version number */
773 /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
774 /* default value is fnd_api.g_false */
775 /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
776 /* fnd_api.g_false */
777 /* p_validation_level NUMBER Optional API uses this parameter to determine which */
778 /* validation steps must be done and which steps */
779 /* should be skipped. */
780 /* p_task_id NUMBER Required Task Id */
781 /* p_repair_line_id NUMBER Required Repair_line_id */
782 /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
783 /* fnd_api.g_ret_sts_success (success) */
784 /* fnd_api.g_ret_sts_error (error) */
785 /* fnd_api.g_ret_sts_unexp_error (unexpected) */
786 /* x_msg_count NUMBER Number of messages in the message stack */
787 /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
788 /*-----------------------------------------------------------------------------------------------------------*/
789
790 PROCEDURE Create_repair_task_hist
791 ( p_api_version IN NUMBER,
792 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
793 p_commit IN VARCHAR2 := fnd_api.g_false,
794 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
795 p_task_id IN NUMBER,
796 p_repair_line_id IN NUMBER,
797 x_return_status OUT NOCOPY VARCHAR2,
798 x_msg_count OUT NOCOPY NUMBER,
799 x_msg_data OUT NOCOPY VARCHAR2
800 );
801
802 /*-----------------------------------------------------------------------------------------------------------*/
803 /* procedure name: Create_repair_task_hist */
804 /* description : procedure used to create Repair Order history */
805 /* for task creation */
806 /* Called from : Depot Repair Form to Create Address */
807 /* Input Parm : p_api_version NUMBER Required Api Version number */
808 /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
809 /* default value is fnd_api.g_false */
810 /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
811 /* fnd_api.g_false */
812 /* p_validation_level NUMBER Optional API uses this parameter to determine which */
813 /* validation steps must be done and which steps */
814 /* should be skipped.
815 /* p_task_activity_rec CSD_PROCESS_PVT.TASK_ACTIVITY_REC Used for logging task activity */
816 /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
817 /* fnd_api.g_ret_sts_success (success) */
818 /* fnd_api.g_ret_sts_error (error) */
819 /* fnd_api.g_ret_sts_unexp_error (unexpected) */
820 /* x_msg_count NUMBER Number of messages in the message stack */
821 /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
822 /*-----------------------------------------------------------------------------------------------------------*/
823
824 PROCEDURE Create_repair_task_hist
825 ( p_api_version IN NUMBER,
826 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
827 p_commit IN VARCHAR2 := fnd_api.g_false,
828 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
829 p_task_activity_rec IN CSD_PROCESS_PVT.TASK_ACTIVITY_REC,
830 x_return_status OUT NOCOPY VARCHAR2,
831 x_msg_count OUT NOCOPY NUMBER,
832 x_msg_data OUT NOCOPY VARCHAR2
833 );
834
835
836 /*-----------------------------------------------------------------------------------------------------------*/
837 /* procedure name: Update_repair_task_hist */
838 /* description : procedure used to Update Repair Order history */
839 /* for task creation */
840 /* Called from : Depot Repair Form to update to Repair history */
841 /* Input Parm : p_api_version NUMBER Required Api Version number */
842 /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
843 /* default value is fnd_api.g_false */
844 /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
845 /* fnd_api.g_false */
846 /* p_validation_level NUMBER Optional API uses this parameter to determine which */
847 /* validation steps must be done and which steps */
848 /* should be skipped. */
849 /* p_task_acticity_rec TASK_ACTIVITY_REC Required Used to log activity */
850 /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
851 /* fnd_api.g_ret_sts_success (success) */
852 /* fnd_api.g_ret_sts_error (error) */
853 /* fnd_api.g_ret_sts_unexp_error (unexpected) */
854 /* x_msg_count NUMBER Number of messages in the message stack */
855 /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
856 /*-----------------------------------------------------------------------------------------------------------*/
857
858 /*
859 PROCEDURE Update_repair_task_hist
860 ( p_api_version IN NUMBER,
861 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
862 p_commit IN VARCHAR2 := fnd_api.g_false,
863 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
864 p_task_id IN NUMBER,
865 p_repair_line_id IN NUMBER,
866 x_return_status OUT NOCOPY VARCHAR2,
867 x_msg_count OUT NOCOPY NUMBER,
868 x_msg_data OUT NOCOPY VARCHAR2
869 );*/
870 --sangiguptask
871 /*-----------------------------------------------------------------------------------------------------------*/
872 /* procedure name: Update_repair_task_hist */
873 /* description : procedure used to Update Repair Order history */
874 /* for task creation */
875 /* Called from : Depot Repair Form to update to Repair history */
876 /* Input Parm : p_api_version NUMBER Required Api Version number */
877 /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
878 /* default value is fnd_api.g_false */
879 /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
880 /* fnd_api.g_false */
881 /* p_validation_level NUMBER Optional API uses this parameter to determine which */
882 /* validation steps must be done and which steps */
883 /* should be skipped. */
884 /* p_activity_rec TASK_ACTIVITY_REC Required Task activity record*/
885 /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
886 /* fnd_api.g_ret_sts_success (success) */
887 /* fnd_api.g_ret_sts_error (error) */
888 /* fnd_api.g_ret_sts_unexp_error (unexpected) */
889 /* x_msg_count NUMBER Number of messages in the message stack */
890 /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
891 /*-----------------------------------------------------------------------------------------------------------*/
892
893 PROCEDURE Update_repair_task_hist
894 ( p_api_version IN NUMBER,
895 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
896 p_commit IN VARCHAR2 := fnd_api.g_false,
897 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
898 p_task_activity_rec IN CSD_PROCESS_PVT.TASK_ACTIVITY_REC,
899 x_return_status OUT NOCOPY VARCHAR2,
900 x_msg_count OUT NOCOPY NUMBER,
901 x_msg_data OUT NOCOPY VARCHAR2
902 );
903 -- travi changes
904
905 /*----------------------------------------------------------------*/
906 /* procedure name: Close_Status */
907 /* description : procedure used to Close RO /Group RO and SR */
908 /*----------------------------------------------------------------*/
909
910 PROCEDURE Close_status
911 ( p_api_version IN NUMBER,
912 p_commit IN VARCHAR2 := fnd_api.g_false,
913 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
914 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
915 p_incident_id IN NUMBER,
916 p_repair_line_id IN NUMBER,
917 x_return_status OUT NOCOPY VARCHAR2,
918 x_msg_count OUT NOCOPY NUMBER,
919 x_msg_data OUT NOCOPY VARCHAR2
920 );
921
922 /*---------------------------------------------------------------*/
923 /* procedure name: Check_Service_Request */
924 /* Description: procedure used to find if there are unasigned */
925 /* RMA/SO lines for the given service request */
926 /*---------------------------------------------------------------*/
927 PROCEDURE Check_Service_Request
928 ( p_api_version IN NUMBER,
929 p_commit IN VARCHAR2 := fnd_api.g_false,
930 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
931 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
932 p_incident_id IN NUMBER,
933 x_link_mode OUT NOCOPY NUMBER,
934 x_return_status OUT NOCOPY VARCHAR2,
935 x_msg_count OUT NOCOPY NUMBER,
936 x_msg_data OUT NOCOPY VARCHAR2
937 );
938
939 /*---------------------------------------------------------------*/
940 /* procedure name: Update_Line_Txn_Source */
941 /* Description: procedure used to update the source_code and */
942 /* source_id of the line transaction */
943 /*---------------------------------------------------------------*/
944 PROCEDURE Update_Line_Txn_Source
945 ( p_api_version IN NUMBER,
946 p_commit IN VARCHAR2,
947 p_init_msg_list IN VARCHAR2,
948 p_validation_level IN NUMBER,
949 p_incident_id IN NUMBER,
950 p_estimate_detail_line_id IN NUMBER,
951 p_repair_line_id IN NUMBER,
952 x_return_status OUT NOCOPY VARCHAR2,
953 x_msg_count OUT NOCOPY NUMBER,
954 x_msg_data OUT NOCOPY VARCHAR2
955 );
956
957
958 /*---------------------------------------------------------------------------------*/
959 /* procedure name: Update_iro_product_txn */
960 /* Description: procedure used to update the product transaction */
961 /* table and process pick release and shipping */
962 /* transactions for internal ROs. */
963 /* p_api_version Standard in parameter */
964 /* p_commit Standard in parameter */
965 /* p_init_msg_list Standard in parameter */
966 /* p_validation_level Standard in parameter */
967 /* x_return_status Standard Out parameter */
968 /* x_msg_count Standard in parameter */
969 /* x_msg_data Standard in parameter , */
970 /* x_product_txn_rec in out record variable of type */
971 /* csd_process_pvt.product_txn_rec ) ; */
972 /*---------------------------------------------------------------------------------*/
973 Procedure update_iro_product_txn
974 ( p_api_version in number,
975 p_commit in varchar2 ,
976 p_init_msg_list in varchar2 ,
977 p_validation_level in number ,
978 x_product_txn_rec in out nocopy csd_process_pvt.product_txn_rec ,
979 x_return_status out nocopy varchar2,
980 x_msg_count out nocopy number,
981 x_msg_data out nocopy varchar2 );
982
983
984 /******************* ************* **********************/
985 /*------------------------------------------------------*/
986 /* - Add Logistics_KeyAttr_Rec_Type */
987 /*------------------------------------------------------*/
988 /* Record name: Logistics_KeyAttr_Rec_Type */
989 /* description: Record used for returning entities */
990 /* for a given repair line id */
991 /* */
992 /*------------------------------------------------------*/
993 Type Logistics_KeyAttr_Rec_Type IS Record
994 ( Product_Transaction_Id NUMBER, -- Primary Key for table csd_product_Transactions table.
995 Estimate_Detail_id NUMBER, -- Primary Key for table cs_estimate_Details
996 Order_Header_Id NUMBER, -- Primar key for oe_order_headers_all
997 Order_Line_Id NUMBER) ; -- Primary Key for oe_Order_Lines_all
998
999 TYPE Logistics_KeyAttr_Tbl_Type IS TABLE OF Logistics_KeyAttr_Rec_Type INDEX BY BINARY_INTEGER;
1000 /***************** ************* ************************/
1001
1002
1003
1004 -- Bug# 3877328 forward porting bug
1005 /*----------------------------------------------------------------------*/
1006 /* procedure name: create_default_prod_txn_wrapr */
1007 /* description : Is a wrapper procedure which does validations before */
1008 /* calling procedure create_default_prod_txn. */
1009 /* This API will have same parameters as procedure */
1010 /* create_default_prod_txn. After successful validation */
1011 /* wrapper API will pass same input parameters. */
1012 /**************** ************* *****************************************/
1013 /* - Add Logistics_KeyAttr_Tbl_Type
1014 /*----------------------------------------------------------------------*/
1015 procedure CREATE_DEFAULT_PROD_TXN_wrapr
1016 ( p_api_version IN NUMBER,
1017 p_commit IN VARCHAR2,
1018 p_init_msg_list IN VARCHAR2,
1019 p_validation_level IN NUMBER,
1020 p_repair_line_id IN NUMBER,
1021 x_return_status OUT NOCOPY VARCHAR2,
1022 x_msg_count OUT NOCOPY NUMBER,
1023 x_msg_data OUT NOCOPY VARCHAR2,
1024 x_Logistics_KeyAttr_Tbl OUT NOCOPY CSD_PROCESS_PVT.Logistics_KeyAttr_Tbl_Type );
1025
1026 /*-----------------------------------------------------------------------------------------------------------*/
1027 /* R12 Quality Integration */
1028 /* procedure name: create_repair_task */
1029 /* description : procedure used to create DR specific tasks in Depot tables */
1030 /* Called from : Depot Repair Form to Create Task */
1031 /* Input Parm : p_api_version NUMBER Required Api Version number */
1032 /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
1033 /* default value is fnd_api.g_false */
1034 /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
1035 /* fnd_api.g_false */
1036 /* p_validation_level NUMBER Optional API uses this parameter to determine which */
1037 /* validation steps must be done and which steps */
1038 /* should be skipped. */
1039 /* p_CREATE_REPAIR_TASK_REC RECORD Required Columns are in the Record CREATE_REPAIR_TASK_REC_TYPE */
1040 /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
1041 /* fnd_api.g_ret_sts_success (success) */
1042 /* fnd_api.g_ret_sts_error (error) */
1043 /* fnd_api.g_ret_sts_unexp_error (unexpected) */
1044 /* x_msg_count NUMBER Number of messages in the message stack */
1045 /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
1046 /* x_repair_task_id NUMBER Task Id of the created Task */
1047 /*-----------------------------------------------------------------------------------------------------------*/
1048 procedure CREATE_REPAIR_TASK
1049 ( p_api_version IN NUMBER,
1050 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1051 p_commit IN VARCHAR2 := fnd_api.g_false,
1052 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1053 p_create_repair_task_rec IN REPAIR_TASK_REC,
1054 x_return_status OUT NOCOPY VARCHAR2,
1055 x_msg_count OUT NOCOPY NUMBER,
1056 x_msg_data OUT NOCOPY VARCHAR2,
1057 x_repair_task_id OUT NOCOPY NUMBER
1058 );
1059
1060 /*-----------------------------------------------------------------------------------------------------------*/
1061 /* R12 Quality Integration */
1062 /* procedure name: update_repair_task */
1063 /* description : procedure used to update DR specifc task in Depot tables */
1064 /* Called from : Depot Repair Form to Update DR specifc Task */
1065 /* Input Parm : p_api_version NUMBER Required Api Version number */
1066 /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
1067 /* default value is fnd_api.g_false */
1068 /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
1069 /* fnd_api.g_false */
1070 /* p_validation_level NUMBER Optional API uses this parameter to determine which */
1071 /* validation steps must be done and which steps */
1072 /* should be skipped. */
1073 /* CREATE_REPAIR_TASK_REC RECORD Required Columns are in the Record CREATE_REPAIR_TASK_REC_TYPE */
1074 /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
1075 /* fnd_api.g_ret_sts_success (success) */
1076 /* fnd_api.g_ret_sts_error (error) */
1077 /* fnd_api.g_ret_sts_unexp_error (unexpected) */
1078 /* x_msg_count NUMBER Number of messages in the message stack */
1079 /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
1080 /*-----------------------------------------------------------------------------------------------------------*/
1081
1082 procedure UPDATE_REPAIR_TASK
1083 ( p_api_version IN NUMBER,
1084 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1085 p_commit IN VARCHAR2 := fnd_api.g_false,
1086 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1087 p_update_repair_task_rec IN REPAIR_TASK_REC,
1088 x_return_status OUT NOCOPY VARCHAR2,
1089 x_msg_count OUT NOCOPY NUMBER,
1090 x_msg_data OUT NOCOPY VARCHAR2
1091 );
1092 /*---------------------------------------------------*/
1093 /* Function to Return the Record Type for Creating / */
1094 /* Updating the Repair Task called from Depot Repair Forms */
1095 /*---------------------------------------------------*/
1096 FUNCTION GET_REPAIR_TASK_REC RETURN CSD_PROCESS_PVT.REPAIR_TASK_REC;
1097 G_DEPOT_REPAIR_TXN_NUMBER CONSTANT NUMBER := 2005;
1098
1099 END CSD_PROCESS_PVT;