DBA Data[Home] [Help]

APPS.XDP_TYPES dependencies on FND_API

Line 297: order_number VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,

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',

Line 303: account_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

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,

Line 304: cust_account_id NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 305: due_date DATE DEFAULT FND_API.G_MISS_DATE,

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,

Line 306: customer_required_date DATE DEFAULT FND_API.G_MISS_DATE,

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,

Line 307: order_type VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,

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,

Line 308: order_source VARCHAR2(40) 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,
312: next_order_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 309: org_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,

Line 310: related_order_id NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 311: previous_order_id NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 312: next_order_id NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 313: order_ref_name VARCHAR2(80) 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,
317: order_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,

Line 314: order_ref_value VARCHAR2(300) 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,

Line 315: order_comments VARCHAR2(4000) 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,

Line 316: 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,
320: completion_date DATE DEFAULT FND_API.G_MISS_DATE,

Line 317: order_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,

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,

Line 318: fulfillment_status VARCHAR2(40) 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,
322: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 319: fulfillment_result VARCHAR2(4000) 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,
323: customer_name VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,

Line 320: completion_date DATE DEFAULT FND_API.G_MISS_DATE,

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,

Line 321: actual_fulfillment_date DATE DEFAULT FND_API.G_MISS_DATE,

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,

Line 322: customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 323: customer_name VARCHAR2(80) 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,

Line 324: telephone_number VARCHAR2(40) 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,

Line 325: attribute_category VARCHAR2(30) 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,

Line 326: attribute1 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,

Line 327: attribute2 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,

Line 328: attribute3 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,

Line 329: attribute4 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,

Line 330: attribute5 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,

Line 331: attribute6 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,

Line 332: attribute7 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,

Line 333: attribute8 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,

Line 334: attribute9 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,

Line 335: attribute10 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,

Line 336: attribute11 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,

Line 337: attribute12 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,

Line 338: attribute13 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,

Line 339: attribute14 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,

Line 340: attribute15 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,

Line 341: attribute16 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

Line 342: attribute17 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: );

Line 343: attribute18 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: );
347:

Line 344: attribute19 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:
348: G_MISS_SERVICE_ORDER_HEADER SERVICE_ORDER_HEADER;

Line 345: attribute20 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;
349: -- Modified by SXBANERJ 07/05. Parent_line_Id, Is_virtual_Flag and Attribute_Category

Line 353: line_number NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 354: line_source VARCHAR2(30) 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,

Line 355: inventory_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 356: service_item_name VARCHAR2(40) 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,

Line 357: version VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,

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,

Line 358: action_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

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',

Line 359: organization_code VARCHAR2(4) 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',
363: ib_source_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 360: organization_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,

Line 361: site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,

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',

Line 363: ib_source_id NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 364: required_fulfillment_date DATE DEFAULT FND_API.G_MISS_DATE,

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,

Line 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',

Line 369: bundle_sequence NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 371: due_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,

Line 373: customer_required_date DATE DEFAULT FND_API.G_MISS_DATE,

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,

Line 374: starting_number 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,

Line 375: ending_number NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 376: line_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 377: workitem_id NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 378: line_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,

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',

Line 379: completion_date DATE DEFAULT FND_API.G_MISS_DATE,

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,

Line 380: actual_fulfillment_date DATE DEFAULT FND_API.G_MISS_DATE,

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,

Line 381: parent_line_number 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,
385: attribute2 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,

Line 383: attribute_category VARCHAR2(30) 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,

Line 384: attribute1 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,

Line 385: attribute2 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,

Line 386: attribute3 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,

Line 387: attribute4 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,

Line 388: attribute5 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,

Line 389: attribute6 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,

Line 390: attribute7 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,

Line 391: attribute8 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,

Line 392: attribute9 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,

Line 393: attribute10 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,

Line 394: attribute11 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,

Line 395: attribute12 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,

Line 396: attribute13 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,

Line 397: attribute14 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,

Line 398: attribute15 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,

Line 399: attribute16 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

Line 400: attribute17 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: );

Line 401: attribute18 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: );
405:

Line 402: attribute19 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:
406: -- list of order line items

Line 403: attribute20 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
407: TYPE SERVICE_ORDER_LINE_LIST IS TABLE OF SERVICE_LINE_ITEM

Line 416: parameter_name VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,

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;

Line 417: parameter_value VARCHAR2(4000) DEFAULT FND_API.G_MISS_CHAR

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;

Line 426: line_number NUMBER DEFAULT FND_API.G_MISS_NUM,

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: );

Line 427: parameter_name VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,

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

Line 428: parameter_value VARCHAR2(4000) DEFAULT FND_API.G_MISS_CHAR,

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;

Line 429: parameter_ref_value VARCHAR2(4000) DEFAULT FND_API.G_MISS_CHAR

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;

Line 438: order_id NUMBER DEFAULT FND_API.G_MISS_NUM,

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,

Line 439: order_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,

Line 440: order_number VARCHAR2(40) 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,

Line 442: fulfillment_status VARCHAR2(40) DEFAULT FND_API.G_MISS_CHAR,

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: );

Line 443: fulfillment_result VARCHAR2(4000) DEFAULT FND_API.G_MISS_CHAR,

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:

Line 444: completion_date DATE DEFAULT FND_API.G_MISS_DATE,

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

Line 445: actual_fulfillment_date DATE DEFAULT FND_API.G_MISS_DATE

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