293: -- From here on, all the types are used for new open interface APIs.
294:
295: TYPE SERVICE_ORDER_HEADER IS RECORD
296: (
297: order_number VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
298: order_version VARCHAR2(40) DEFAULT 1,
299: required_fulfillment_date DATE DEFAULT SYSDATE,
300: priority NUMBER DEFAULT 100,
301: jeopardy_enabled_flag VARCHAR2(1) DEFAULT 'N',
299: required_fulfillment_date DATE DEFAULT SYSDATE,
300: priority NUMBER DEFAULT 100,
301: jeopardy_enabled_flag VARCHAR2(1) DEFAULT 'N',
302: execution_mode VARCHAR2(5) DEFAULT 'ASYNC',
303: account_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
304: cust_account_id NUMBER DEFAULT FND_API.G_MISS_NUM,
305: due_date DATE DEFAULT FND_API.G_MISS_DATE,
306: customer_required_date DATE DEFAULT FND_API.G_MISS_DATE,
307: order_type VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
300: priority NUMBER DEFAULT 100,
301: jeopardy_enabled_flag VARCHAR2(1) DEFAULT 'N',
302: execution_mode VARCHAR2(5) DEFAULT 'ASYNC',
303: account_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
304: cust_account_id NUMBER DEFAULT FND_API.G_MISS_NUM,
305: due_date DATE DEFAULT FND_API.G_MISS_DATE,
306: customer_required_date DATE DEFAULT FND_API.G_MISS_DATE,
307: order_type VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
308: order_source VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
301: jeopardy_enabled_flag VARCHAR2(1) DEFAULT 'N',
302: execution_mode VARCHAR2(5) DEFAULT 'ASYNC',
303: account_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
304: cust_account_id NUMBER DEFAULT FND_API.G_MISS_NUM,
305: due_date DATE DEFAULT FND_API.G_MISS_DATE,
306: customer_required_date DATE DEFAULT FND_API.G_MISS_DATE,
307: order_type VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
308: order_source VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
309: org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
302: execution_mode VARCHAR2(5) DEFAULT 'ASYNC',
303: account_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
304: cust_account_id NUMBER DEFAULT FND_API.G_MISS_NUM,
305: due_date DATE DEFAULT FND_API.G_MISS_DATE,
306: customer_required_date DATE DEFAULT FND_API.G_MISS_DATE,
307: order_type VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
308: order_source VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
309: org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
310: related_order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
303: account_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
304: cust_account_id NUMBER DEFAULT FND_API.G_MISS_NUM,
305: due_date DATE DEFAULT FND_API.G_MISS_DATE,
306: customer_required_date DATE DEFAULT FND_API.G_MISS_DATE,
307: order_type VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
308: order_source VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
309: org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
310: related_order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
311: previous_order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
304: cust_account_id NUMBER DEFAULT FND_API.G_MISS_NUM,
305: due_date DATE DEFAULT FND_API.G_MISS_DATE,
306: customer_required_date DATE DEFAULT FND_API.G_MISS_DATE,
307: order_type VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
308: order_source VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
309: org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
310: related_order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
311: previous_order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
312: next_order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
305: due_date DATE DEFAULT FND_API.G_MISS_DATE,
306: customer_required_date DATE DEFAULT FND_API.G_MISS_DATE,
307: order_type VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
308: order_source VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
309: org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
310: related_order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
311: previous_order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
312: next_order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
313: order_ref_name VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
306: customer_required_date DATE DEFAULT FND_API.G_MISS_DATE,
307: order_type VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
308: order_source VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
309: org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
310: related_order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
311: previous_order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
312: next_order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
313: order_ref_name VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
314: order_ref_value VARCHAR2(300) DEFAULT FND_API.G_MISS_CHAR,
307: order_type VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
308: order_source VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
309: org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
310: related_order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
311: previous_order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
312: next_order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
313: order_ref_name VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
314: order_ref_value VARCHAR2(300) DEFAULT FND_API.G_MISS_CHAR,
315: order_comments VARCHAR2(4000) DEFAULT FND_API.G_MISS_CHAR,
308: order_source VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
309: org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
310: related_order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
311: previous_order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
312: next_order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
313: order_ref_name VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
314: order_ref_value VARCHAR2(300) DEFAULT FND_API.G_MISS_CHAR,
315: order_comments VARCHAR2(4000) DEFAULT FND_API.G_MISS_CHAR,
316: order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
309: org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
310: related_order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
311: previous_order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
312: next_order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
313: order_ref_name VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
314: order_ref_value VARCHAR2(300) DEFAULT FND_API.G_MISS_CHAR,
315: order_comments VARCHAR2(4000) DEFAULT FND_API.G_MISS_CHAR,
316: order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
317: order_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
310: related_order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
311: previous_order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
312: next_order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
313: order_ref_name VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
314: order_ref_value VARCHAR2(300) DEFAULT FND_API.G_MISS_CHAR,
315: order_comments VARCHAR2(4000) DEFAULT FND_API.G_MISS_CHAR,
316: order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
317: order_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
318: fulfillment_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
311: previous_order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
312: next_order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
313: order_ref_name VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
314: order_ref_value VARCHAR2(300) DEFAULT FND_API.G_MISS_CHAR,
315: order_comments VARCHAR2(4000) DEFAULT FND_API.G_MISS_CHAR,
316: order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
317: order_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
318: fulfillment_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
319: fulfillment_result VARCHAR2(4000) DEFAULT FND_API.G_MISS_CHAR,
312: next_order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
313: order_ref_name VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
314: order_ref_value VARCHAR2(300) DEFAULT FND_API.G_MISS_CHAR,
315: order_comments VARCHAR2(4000) DEFAULT FND_API.G_MISS_CHAR,
316: order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
317: order_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
318: fulfillment_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
319: fulfillment_result VARCHAR2(4000) DEFAULT FND_API.G_MISS_CHAR,
320: completion_date DATE DEFAULT FND_API.G_MISS_DATE,
313: order_ref_name VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
314: order_ref_value VARCHAR2(300) DEFAULT FND_API.G_MISS_CHAR,
315: order_comments VARCHAR2(4000) DEFAULT FND_API.G_MISS_CHAR,
316: order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
317: order_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
318: fulfillment_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
319: fulfillment_result VARCHAR2(4000) DEFAULT FND_API.G_MISS_CHAR,
320: completion_date DATE DEFAULT FND_API.G_MISS_DATE,
321: actual_fulfillment_date DATE DEFAULT FND_API.G_MISS_DATE,
314: order_ref_value VARCHAR2(300) DEFAULT FND_API.G_MISS_CHAR,
315: order_comments VARCHAR2(4000) DEFAULT FND_API.G_MISS_CHAR,
316: order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
317: order_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
318: fulfillment_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
319: fulfillment_result VARCHAR2(4000) DEFAULT FND_API.G_MISS_CHAR,
320: completion_date DATE DEFAULT FND_API.G_MISS_DATE,
321: actual_fulfillment_date DATE DEFAULT FND_API.G_MISS_DATE,
322: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
315: order_comments VARCHAR2(4000) DEFAULT FND_API.G_MISS_CHAR,
316: order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
317: order_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
318: fulfillment_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
319: fulfillment_result VARCHAR2(4000) DEFAULT FND_API.G_MISS_CHAR,
320: completion_date DATE DEFAULT FND_API.G_MISS_DATE,
321: actual_fulfillment_date DATE DEFAULT FND_API.G_MISS_DATE,
322: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
323: customer_name VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
316: order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
317: order_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
318: fulfillment_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
319: fulfillment_result VARCHAR2(4000) DEFAULT FND_API.G_MISS_CHAR,
320: completion_date DATE DEFAULT FND_API.G_MISS_DATE,
321: actual_fulfillment_date DATE DEFAULT FND_API.G_MISS_DATE,
322: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
323: customer_name VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
324: telephone_number VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
317: order_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
318: fulfillment_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
319: fulfillment_result VARCHAR2(4000) DEFAULT FND_API.G_MISS_CHAR,
320: completion_date DATE DEFAULT FND_API.G_MISS_DATE,
321: actual_fulfillment_date DATE DEFAULT FND_API.G_MISS_DATE,
322: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
323: customer_name VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
324: telephone_number VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
325: attribute_category VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
318: fulfillment_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
319: fulfillment_result VARCHAR2(4000) DEFAULT FND_API.G_MISS_CHAR,
320: completion_date DATE DEFAULT FND_API.G_MISS_DATE,
321: actual_fulfillment_date DATE DEFAULT FND_API.G_MISS_DATE,
322: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
323: customer_name VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
324: telephone_number VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
325: attribute_category VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
326: attribute1 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
319: fulfillment_result VARCHAR2(4000) DEFAULT FND_API.G_MISS_CHAR,
320: completion_date DATE DEFAULT FND_API.G_MISS_DATE,
321: actual_fulfillment_date DATE DEFAULT FND_API.G_MISS_DATE,
322: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
323: customer_name VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
324: telephone_number VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
325: attribute_category VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
326: attribute1 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
327: attribute2 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
320: completion_date DATE DEFAULT FND_API.G_MISS_DATE,
321: actual_fulfillment_date DATE DEFAULT FND_API.G_MISS_DATE,
322: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
323: customer_name VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
324: telephone_number VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
325: attribute_category VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
326: attribute1 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
327: attribute2 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
328: attribute3 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
321: actual_fulfillment_date DATE DEFAULT FND_API.G_MISS_DATE,
322: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
323: customer_name VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
324: telephone_number VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
325: attribute_category VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
326: attribute1 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
327: attribute2 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
328: attribute3 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
329: attribute4 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
322: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
323: customer_name VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
324: telephone_number VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
325: attribute_category VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
326: attribute1 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
327: attribute2 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
328: attribute3 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
329: attribute4 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
330: attribute5 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
323: customer_name VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
324: telephone_number VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
325: attribute_category VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
326: attribute1 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
327: attribute2 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
328: attribute3 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
329: attribute4 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
330: attribute5 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
331: attribute6 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
324: telephone_number VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
325: attribute_category VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
326: attribute1 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
327: attribute2 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
328: attribute3 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
329: attribute4 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
330: attribute5 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
331: attribute6 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
332: attribute7 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
325: attribute_category VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
326: attribute1 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
327: attribute2 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
328: attribute3 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
329: attribute4 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
330: attribute5 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
331: attribute6 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
332: attribute7 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
333: attribute8 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
326: attribute1 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
327: attribute2 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
328: attribute3 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
329: attribute4 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
330: attribute5 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
331: attribute6 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
332: attribute7 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
333: attribute8 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
334: attribute9 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
327: attribute2 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
328: attribute3 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
329: attribute4 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
330: attribute5 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
331: attribute6 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
332: attribute7 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
333: attribute8 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
334: attribute9 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
335: attribute10 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
328: attribute3 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
329: attribute4 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
330: attribute5 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
331: attribute6 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
332: attribute7 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
333: attribute8 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
334: attribute9 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
335: attribute10 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
336: attribute11 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
329: attribute4 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
330: attribute5 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
331: attribute6 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
332: attribute7 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
333: attribute8 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
334: attribute9 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
335: attribute10 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
336: attribute11 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
337: attribute12 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
330: attribute5 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
331: attribute6 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
332: attribute7 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
333: attribute8 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
334: attribute9 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
335: attribute10 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
336: attribute11 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
337: attribute12 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
338: attribute13 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
331: attribute6 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
332: attribute7 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
333: attribute8 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
334: attribute9 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
335: attribute10 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
336: attribute11 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
337: attribute12 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
338: attribute13 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
339: attribute14 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
332: attribute7 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
333: attribute8 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
334: attribute9 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
335: attribute10 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
336: attribute11 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
337: attribute12 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
338: attribute13 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
339: attribute14 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
340: attribute15 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
333: attribute8 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
334: attribute9 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
335: attribute10 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
336: attribute11 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
337: attribute12 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
338: attribute13 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
339: attribute14 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
340: attribute15 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
341: attribute16 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
334: attribute9 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
335: attribute10 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
336: attribute11 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
337: attribute12 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
338: attribute13 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
339: attribute14 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
340: attribute15 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
341: attribute16 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
342: attribute17 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
335: attribute10 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
336: attribute11 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
337: attribute12 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
338: attribute13 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
339: attribute14 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
340: attribute15 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
341: attribute16 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
342: attribute17 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
343: attribute18 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
336: attribute11 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
337: attribute12 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
338: attribute13 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
339: attribute14 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
340: attribute15 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
341: attribute16 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
342: attribute17 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
343: attribute18 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
344: attribute19 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
337: attribute12 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
338: attribute13 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
339: attribute14 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
340: attribute15 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
341: attribute16 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
342: attribute17 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
343: attribute18 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
344: attribute19 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
345: attribute20 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR
338: attribute13 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
339: attribute14 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
340: attribute15 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
341: attribute16 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
342: attribute17 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
343: attribute18 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
344: attribute19 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
345: attribute20 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR
346: );
339: attribute14 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
340: attribute15 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
341: attribute16 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
342: attribute17 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
343: attribute18 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
344: attribute19 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
345: attribute20 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR
346: );
347:
340: attribute15 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
341: attribute16 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
342: attribute17 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
343: attribute18 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
344: attribute19 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
345: attribute20 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR
346: );
347:
348: G_MISS_SERVICE_ORDER_HEADER SERVICE_ORDER_HEADER;
341: attribute16 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
342: attribute17 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
343: attribute18 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
344: attribute19 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
345: attribute20 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR
346: );
347:
348: G_MISS_SERVICE_ORDER_HEADER SERVICE_ORDER_HEADER;
349: -- Modified by SXBANERJ 07/05. Parent_line_Id, Is_virtual_Flag and Attribute_Category
349: -- Modified by SXBANERJ 07/05. Parent_line_Id, Is_virtual_Flag and Attribute_Category
350:
351: TYPE SERVICE_LINE_ITEM IS RECORD
352: (
353: line_number NUMBER DEFAULT FND_API.G_MISS_NUM,
354: line_source VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
355: inventory_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
356: service_item_name VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
357: version VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
350:
351: TYPE SERVICE_LINE_ITEM IS RECORD
352: (
353: line_number NUMBER DEFAULT FND_API.G_MISS_NUM,
354: line_source VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
355: inventory_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
356: service_item_name VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
357: version VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
358: action_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
351: TYPE SERVICE_LINE_ITEM IS RECORD
352: (
353: line_number NUMBER DEFAULT FND_API.G_MISS_NUM,
354: line_source VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
355: inventory_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
356: service_item_name VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
357: version VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
358: action_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
359: organization_code VARCHAR2(4) DEFAULT FND_API.G_MISS_CHAR,
352: (
353: line_number NUMBER DEFAULT FND_API.G_MISS_NUM,
354: line_source VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
355: inventory_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
356: service_item_name VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
357: version VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
358: action_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
359: organization_code VARCHAR2(4) DEFAULT FND_API.G_MISS_CHAR,
360: organization_id NUMBER DEFAULT FND_API.G_MISS_NUM,
353: line_number NUMBER DEFAULT FND_API.G_MISS_NUM,
354: line_source VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
355: inventory_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
356: service_item_name VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
357: version VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
358: action_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
359: organization_code VARCHAR2(4) DEFAULT FND_API.G_MISS_CHAR,
360: organization_id NUMBER DEFAULT FND_API.G_MISS_NUM,
361: site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
354: line_source VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
355: inventory_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
356: service_item_name VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
357: version VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
358: action_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
359: organization_code VARCHAR2(4) DEFAULT FND_API.G_MISS_CHAR,
360: organization_id NUMBER DEFAULT FND_API.G_MISS_NUM,
361: site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
362: ib_source VARCHAR2(20) DEFAULT 'NONE',
355: inventory_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
356: service_item_name VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
357: version VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
358: action_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
359: organization_code VARCHAR2(4) DEFAULT FND_API.G_MISS_CHAR,
360: organization_id NUMBER DEFAULT FND_API.G_MISS_NUM,
361: site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
362: ib_source VARCHAR2(20) DEFAULT 'NONE',
363: ib_source_id NUMBER DEFAULT FND_API.G_MISS_NUM,
356: service_item_name VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
357: version VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
358: action_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
359: organization_code VARCHAR2(4) DEFAULT FND_API.G_MISS_CHAR,
360: organization_id NUMBER DEFAULT FND_API.G_MISS_NUM,
361: site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
362: ib_source VARCHAR2(20) DEFAULT 'NONE',
363: ib_source_id NUMBER DEFAULT FND_API.G_MISS_NUM,
364: required_fulfillment_date DATE DEFAULT FND_API.G_MISS_DATE,
357: version VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
358: action_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
359: organization_code VARCHAR2(4) DEFAULT FND_API.G_MISS_CHAR,
360: organization_id NUMBER DEFAULT FND_API.G_MISS_NUM,
361: site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
362: ib_source VARCHAR2(20) DEFAULT 'NONE',
363: ib_source_id NUMBER DEFAULT FND_API.G_MISS_NUM,
364: required_fulfillment_date DATE DEFAULT FND_API.G_MISS_DATE,
365: fulfillment_required_flag VARCHAR2(1) DEFAULT 'Y',
359: organization_code VARCHAR2(4) DEFAULT FND_API.G_MISS_CHAR,
360: organization_id NUMBER DEFAULT FND_API.G_MISS_NUM,
361: site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
362: ib_source VARCHAR2(20) DEFAULT 'NONE',
363: ib_source_id NUMBER DEFAULT FND_API.G_MISS_NUM,
364: required_fulfillment_date DATE DEFAULT FND_API.G_MISS_DATE,
365: fulfillment_required_flag VARCHAR2(1) DEFAULT 'Y',
366: is_package_flag VARCHAR2(1) DEFAULT 'N',
367: fulfillment_sequence NUMBER DEFAULT 0,
360: organization_id NUMBER DEFAULT FND_API.G_MISS_NUM,
361: site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
362: ib_source VARCHAR2(20) DEFAULT 'NONE',
363: ib_source_id NUMBER DEFAULT FND_API.G_MISS_NUM,
364: required_fulfillment_date DATE DEFAULT FND_API.G_MISS_DATE,
365: fulfillment_required_flag VARCHAR2(1) DEFAULT 'Y',
366: is_package_flag VARCHAR2(1) DEFAULT 'N',
367: fulfillment_sequence NUMBER DEFAULT 0,
368: bundle_id NUMBER DEFAULT FND_API.G_MISS_NUM,
364: required_fulfillment_date DATE DEFAULT FND_API.G_MISS_DATE,
365: fulfillment_required_flag VARCHAR2(1) DEFAULT 'Y',
366: is_package_flag VARCHAR2(1) DEFAULT 'N',
367: fulfillment_sequence NUMBER DEFAULT 0,
368: bundle_id NUMBER DEFAULT FND_API.G_MISS_NUM,
369: bundle_sequence NUMBER DEFAULT FND_API.G_MISS_NUM,
370: priority NUMBER DEFAULT 100,
371: due_date DATE DEFAULT FND_API.G_MISS_DATE,
372: jeopardy_enabled_flag VARCHAR2(1) DEFAULT 'N',
365: fulfillment_required_flag VARCHAR2(1) DEFAULT 'Y',
366: is_package_flag VARCHAR2(1) DEFAULT 'N',
367: fulfillment_sequence NUMBER DEFAULT 0,
368: bundle_id NUMBER DEFAULT FND_API.G_MISS_NUM,
369: bundle_sequence NUMBER DEFAULT FND_API.G_MISS_NUM,
370: priority NUMBER DEFAULT 100,
371: due_date DATE DEFAULT FND_API.G_MISS_DATE,
372: jeopardy_enabled_flag VARCHAR2(1) DEFAULT 'N',
373: customer_required_date DATE DEFAULT FND_API.G_MISS_DATE,
367: fulfillment_sequence NUMBER DEFAULT 0,
368: bundle_id NUMBER DEFAULT FND_API.G_MISS_NUM,
369: bundle_sequence NUMBER DEFAULT FND_API.G_MISS_NUM,
370: priority NUMBER DEFAULT 100,
371: due_date DATE DEFAULT FND_API.G_MISS_DATE,
372: jeopardy_enabled_flag VARCHAR2(1) DEFAULT 'N',
373: customer_required_date DATE DEFAULT FND_API.G_MISS_DATE,
374: starting_number NUMBER DEFAULT FND_API.G_MISS_NUM,
375: ending_number NUMBER DEFAULT FND_API.G_MISS_NUM,
369: bundle_sequence NUMBER DEFAULT FND_API.G_MISS_NUM,
370: priority NUMBER DEFAULT 100,
371: due_date DATE DEFAULT FND_API.G_MISS_DATE,
372: jeopardy_enabled_flag VARCHAR2(1) DEFAULT 'N',
373: customer_required_date DATE DEFAULT FND_API.G_MISS_DATE,
374: starting_number NUMBER DEFAULT FND_API.G_MISS_NUM,
375: ending_number NUMBER DEFAULT FND_API.G_MISS_NUM,
376: line_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
377: workitem_id NUMBER DEFAULT FND_API.G_MISS_NUM,
370: priority NUMBER DEFAULT 100,
371: due_date DATE DEFAULT FND_API.G_MISS_DATE,
372: jeopardy_enabled_flag VARCHAR2(1) DEFAULT 'N',
373: customer_required_date DATE DEFAULT FND_API.G_MISS_DATE,
374: starting_number NUMBER DEFAULT FND_API.G_MISS_NUM,
375: ending_number NUMBER DEFAULT FND_API.G_MISS_NUM,
376: line_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
377: workitem_id NUMBER DEFAULT FND_API.G_MISS_NUM,
378: line_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
371: due_date DATE DEFAULT FND_API.G_MISS_DATE,
372: jeopardy_enabled_flag VARCHAR2(1) DEFAULT 'N',
373: customer_required_date DATE DEFAULT FND_API.G_MISS_DATE,
374: starting_number NUMBER DEFAULT FND_API.G_MISS_NUM,
375: ending_number NUMBER DEFAULT FND_API.G_MISS_NUM,
376: line_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
377: workitem_id NUMBER DEFAULT FND_API.G_MISS_NUM,
378: line_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
379: completion_date DATE DEFAULT FND_API.G_MISS_DATE,
372: jeopardy_enabled_flag VARCHAR2(1) DEFAULT 'N',
373: customer_required_date DATE DEFAULT FND_API.G_MISS_DATE,
374: starting_number NUMBER DEFAULT FND_API.G_MISS_NUM,
375: ending_number NUMBER DEFAULT FND_API.G_MISS_NUM,
376: line_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
377: workitem_id NUMBER DEFAULT FND_API.G_MISS_NUM,
378: line_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
379: completion_date DATE DEFAULT FND_API.G_MISS_DATE,
380: actual_fulfillment_date DATE DEFAULT FND_API.G_MISS_DATE,
373: customer_required_date DATE DEFAULT FND_API.G_MISS_DATE,
374: starting_number NUMBER DEFAULT FND_API.G_MISS_NUM,
375: ending_number NUMBER DEFAULT FND_API.G_MISS_NUM,
376: line_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
377: workitem_id NUMBER DEFAULT FND_API.G_MISS_NUM,
378: line_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
379: completion_date DATE DEFAULT FND_API.G_MISS_DATE,
380: actual_fulfillment_date DATE DEFAULT FND_API.G_MISS_DATE,
381: parent_line_number NUMBER DEFAULT FND_API.G_MISS_NUM,
374: starting_number NUMBER DEFAULT FND_API.G_MISS_NUM,
375: ending_number NUMBER DEFAULT FND_API.G_MISS_NUM,
376: line_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
377: workitem_id NUMBER DEFAULT FND_API.G_MISS_NUM,
378: line_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
379: completion_date DATE DEFAULT FND_API.G_MISS_DATE,
380: actual_fulfillment_date DATE DEFAULT FND_API.G_MISS_DATE,
381: parent_line_number NUMBER DEFAULT FND_API.G_MISS_NUM,
382: is_virtual_line_flag VARCHAR2(1) DEFAULT 'N',
375: ending_number NUMBER DEFAULT FND_API.G_MISS_NUM,
376: line_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
377: workitem_id NUMBER DEFAULT FND_API.G_MISS_NUM,
378: line_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
379: completion_date DATE DEFAULT FND_API.G_MISS_DATE,
380: actual_fulfillment_date DATE DEFAULT FND_API.G_MISS_DATE,
381: parent_line_number NUMBER DEFAULT FND_API.G_MISS_NUM,
382: is_virtual_line_flag VARCHAR2(1) DEFAULT 'N',
383: attribute_category VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
376: line_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
377: workitem_id NUMBER DEFAULT FND_API.G_MISS_NUM,
378: line_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
379: completion_date DATE DEFAULT FND_API.G_MISS_DATE,
380: actual_fulfillment_date DATE DEFAULT FND_API.G_MISS_DATE,
381: parent_line_number NUMBER DEFAULT FND_API.G_MISS_NUM,
382: is_virtual_line_flag VARCHAR2(1) DEFAULT 'N',
383: attribute_category VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
384: attribute1 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
377: workitem_id NUMBER DEFAULT FND_API.G_MISS_NUM,
378: line_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
379: completion_date DATE DEFAULT FND_API.G_MISS_DATE,
380: actual_fulfillment_date DATE DEFAULT FND_API.G_MISS_DATE,
381: parent_line_number NUMBER DEFAULT FND_API.G_MISS_NUM,
382: is_virtual_line_flag VARCHAR2(1) DEFAULT 'N',
383: attribute_category VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
384: attribute1 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
385: attribute2 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
379: completion_date DATE DEFAULT FND_API.G_MISS_DATE,
380: actual_fulfillment_date DATE DEFAULT FND_API.G_MISS_DATE,
381: parent_line_number NUMBER DEFAULT FND_API.G_MISS_NUM,
382: is_virtual_line_flag VARCHAR2(1) DEFAULT 'N',
383: attribute_category VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
384: attribute1 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
385: attribute2 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
386: attribute3 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
387: attribute4 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
380: actual_fulfillment_date DATE DEFAULT FND_API.G_MISS_DATE,
381: parent_line_number NUMBER DEFAULT FND_API.G_MISS_NUM,
382: is_virtual_line_flag VARCHAR2(1) DEFAULT 'N',
383: attribute_category VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
384: attribute1 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
385: attribute2 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
386: attribute3 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
387: attribute4 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
388: attribute5 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
381: parent_line_number NUMBER DEFAULT FND_API.G_MISS_NUM,
382: is_virtual_line_flag VARCHAR2(1) DEFAULT 'N',
383: attribute_category VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
384: attribute1 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
385: attribute2 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
386: attribute3 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
387: attribute4 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
388: attribute5 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
389: attribute6 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
382: is_virtual_line_flag VARCHAR2(1) DEFAULT 'N',
383: attribute_category VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
384: attribute1 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
385: attribute2 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
386: attribute3 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
387: attribute4 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
388: attribute5 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
389: attribute6 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
390: attribute7 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
383: attribute_category VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
384: attribute1 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
385: attribute2 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
386: attribute3 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
387: attribute4 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
388: attribute5 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
389: attribute6 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
390: attribute7 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
391: attribute8 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
384: attribute1 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
385: attribute2 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
386: attribute3 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
387: attribute4 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
388: attribute5 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
389: attribute6 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
390: attribute7 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
391: attribute8 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
392: attribute9 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
385: attribute2 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
386: attribute3 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
387: attribute4 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
388: attribute5 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
389: attribute6 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
390: attribute7 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
391: attribute8 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
392: attribute9 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
393: attribute10 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
386: attribute3 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
387: attribute4 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
388: attribute5 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
389: attribute6 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
390: attribute7 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
391: attribute8 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
392: attribute9 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
393: attribute10 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
394: attribute11 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
387: attribute4 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
388: attribute5 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
389: attribute6 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
390: attribute7 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
391: attribute8 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
392: attribute9 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
393: attribute10 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
394: attribute11 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
395: attribute12 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
388: attribute5 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
389: attribute6 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
390: attribute7 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
391: attribute8 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
392: attribute9 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
393: attribute10 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
394: attribute11 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
395: attribute12 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
396: attribute13 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
389: attribute6 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
390: attribute7 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
391: attribute8 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
392: attribute9 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
393: attribute10 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
394: attribute11 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
395: attribute12 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
396: attribute13 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
397: attribute14 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
390: attribute7 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
391: attribute8 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
392: attribute9 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
393: attribute10 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
394: attribute11 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
395: attribute12 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
396: attribute13 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
397: attribute14 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
398: attribute15 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
391: attribute8 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
392: attribute9 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
393: attribute10 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
394: attribute11 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
395: attribute12 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
396: attribute13 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
397: attribute14 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
398: attribute15 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
399: attribute16 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
392: attribute9 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
393: attribute10 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
394: attribute11 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
395: attribute12 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
396: attribute13 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
397: attribute14 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
398: attribute15 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
399: attribute16 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
400: attribute17 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
393: attribute10 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
394: attribute11 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
395: attribute12 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
396: attribute13 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
397: attribute14 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
398: attribute15 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
399: attribute16 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
400: attribute17 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
401: attribute18 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
394: attribute11 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
395: attribute12 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
396: attribute13 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
397: attribute14 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
398: attribute15 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
399: attribute16 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
400: attribute17 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
401: attribute18 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
402: attribute19 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
395: attribute12 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
396: attribute13 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
397: attribute14 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
398: attribute15 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
399: attribute16 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
400: attribute17 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
401: attribute18 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
402: attribute19 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
403: attribute20 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR
396: attribute13 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
397: attribute14 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
398: attribute15 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
399: attribute16 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
400: attribute17 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
401: attribute18 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
402: attribute19 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
403: attribute20 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR
404: );
397: attribute14 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
398: attribute15 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
399: attribute16 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
400: attribute17 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
401: attribute18 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
402: attribute19 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
403: attribute20 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR
404: );
405:
398: attribute15 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
399: attribute16 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
400: attribute17 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
401: attribute18 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
402: attribute19 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
403: attribute20 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR
404: );
405:
406: -- list of order line items
399: attribute16 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
400: attribute17 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
401: attribute18 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
402: attribute19 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
403: attribute20 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR
404: );
405:
406: -- list of order line items
407: TYPE SERVICE_ORDER_LINE_LIST IS TABLE OF SERVICE_LINE_ITEM
412:
413:
414: TYPE SERVICE_ORDER_PARAM IS RECORD
415: (
416: parameter_name VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
417: parameter_value VARCHAR2(4000) DEFAULT FND_API.G_MISS_CHAR
418: );
419: TYPE SERVICE_ORDER_PARAM_LIST IS TABLE OF SERVICE_ORDER_PARAM
420: INDEX BY BINARY_INTEGER;
413:
414: TYPE SERVICE_ORDER_PARAM IS RECORD
415: (
416: parameter_name VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
417: parameter_value VARCHAR2(4000) DEFAULT FND_API.G_MISS_CHAR
418: );
419: TYPE SERVICE_ORDER_PARAM_LIST IS TABLE OF SERVICE_ORDER_PARAM
420: INDEX BY BINARY_INTEGER;
421: G_MISS_ORDER_PARAMETER SERVICE_ORDER_PARAM;
422: G_MISS_ORDER_PARAM_LIST SERVICE_ORDER_PARAM_LIST;
423:
424: TYPE SERVICE_LINE_PARAM IS RECORD
425: (
426: line_number NUMBER DEFAULT FND_API.G_MISS_NUM,
427: parameter_name VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
428: parameter_value VARCHAR2(4000) DEFAULT FND_API.G_MISS_CHAR,
429: parameter_ref_value VARCHAR2(4000) DEFAULT FND_API.G_MISS_CHAR
430: );
423:
424: TYPE SERVICE_LINE_PARAM IS RECORD
425: (
426: line_number NUMBER DEFAULT FND_API.G_MISS_NUM,
427: parameter_name VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
428: parameter_value VARCHAR2(4000) DEFAULT FND_API.G_MISS_CHAR,
429: parameter_ref_value VARCHAR2(4000) DEFAULT FND_API.G_MISS_CHAR
430: );
431: TYPE SERVICE_LINE_PARAM_LIST IS TABLE OF SERVICE_LINE_PARAM
424: TYPE SERVICE_LINE_PARAM IS RECORD
425: (
426: line_number NUMBER DEFAULT FND_API.G_MISS_NUM,
427: parameter_name VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
428: parameter_value VARCHAR2(4000) DEFAULT FND_API.G_MISS_CHAR,
429: parameter_ref_value VARCHAR2(4000) DEFAULT FND_API.G_MISS_CHAR
430: );
431: TYPE SERVICE_LINE_PARAM_LIST IS TABLE OF SERVICE_LINE_PARAM
432: INDEX BY BINARY_INTEGER;
425: (
426: line_number NUMBER DEFAULT FND_API.G_MISS_NUM,
427: parameter_name VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
428: parameter_value VARCHAR2(4000) DEFAULT FND_API.G_MISS_CHAR,
429: parameter_ref_value VARCHAR2(4000) DEFAULT FND_API.G_MISS_CHAR
430: );
431: TYPE SERVICE_LINE_PARAM_LIST IS TABLE OF SERVICE_LINE_PARAM
432: INDEX BY BINARY_INTEGER;
433: G_MISS_LINE_PARAM SERVICE_LINE_PARAM;
434: G_MISS_LINE_PARAM_LIST SERVICE_LINE_PARAM_LIST;
435:
436: TYPE SERVICE_ORDER_STATUS IS RECORD
437: (
438: order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
439: order_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
440: order_number VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
441: order_version VARCHAR2(40) DEFAULT 1,
442: fulfillment_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
435:
436: TYPE SERVICE_ORDER_STATUS IS RECORD
437: (
438: order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
439: order_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
440: order_number VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
441: order_version VARCHAR2(40) DEFAULT 1,
442: fulfillment_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
443: fulfillment_result VARCHAR2(4000) DEFAULT FND_API.G_MISS_CHAR,
436: TYPE SERVICE_ORDER_STATUS IS RECORD
437: (
438: order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
439: order_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
440: order_number VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
441: order_version VARCHAR2(40) DEFAULT 1,
442: fulfillment_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
443: fulfillment_result VARCHAR2(4000) DEFAULT FND_API.G_MISS_CHAR,
444: completion_date DATE DEFAULT FND_API.G_MISS_DATE,
438: order_id NUMBER DEFAULT FND_API.G_MISS_NUM,
439: order_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
440: order_number VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
441: order_version VARCHAR2(40) DEFAULT 1,
442: fulfillment_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
443: fulfillment_result VARCHAR2(4000) DEFAULT FND_API.G_MISS_CHAR,
444: completion_date DATE DEFAULT FND_API.G_MISS_DATE,
445: actual_fulfillment_date DATE DEFAULT FND_API.G_MISS_DATE
446: );
439: order_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
440: order_number VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
441: order_version VARCHAR2(40) DEFAULT 1,
442: fulfillment_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
443: fulfillment_result VARCHAR2(4000) DEFAULT FND_API.G_MISS_CHAR,
444: completion_date DATE DEFAULT FND_API.G_MISS_DATE,
445: actual_fulfillment_date DATE DEFAULT FND_API.G_MISS_DATE
446: );
447:
440: order_number VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
441: order_version VARCHAR2(40) DEFAULT 1,
442: fulfillment_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
443: fulfillment_result VARCHAR2(4000) DEFAULT FND_API.G_MISS_CHAR,
444: completion_date DATE DEFAULT FND_API.G_MISS_DATE,
445: actual_fulfillment_date DATE DEFAULT FND_API.G_MISS_DATE
446: );
447:
448: -- Added by SXBANERJ 07/05/2001
441: order_version VARCHAR2(40) DEFAULT 1,
442: fulfillment_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,
443: fulfillment_result VARCHAR2(4000) DEFAULT FND_API.G_MISS_CHAR,
444: completion_date DATE DEFAULT FND_API.G_MISS_DATE,
445: actual_fulfillment_date DATE DEFAULT FND_API.G_MISS_DATE
446: );
447:
448: -- Added by SXBANERJ 07/05/2001
449: -- Table of Primitives used for bulk inserts