38: --
39: -- 115.23 05/20/2005 vparvath R12 development: adding new api update_ro_status
40:
41: TYPE REPLN_Rec_Type IS RECORD(
42: REPAIR_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
43: INCIDENT_ID NUMBER := FND_API.G_MISS_NUM,
44: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
45: CUSTOMER_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
46: UNIT_OF_MEASURE VARCHAR2(3) := FND_API.G_MISS_CHAR,
39: -- 115.23 05/20/2005 vparvath R12 development: adding new api update_ro_status
40:
41: TYPE REPLN_Rec_Type IS RECORD(
42: REPAIR_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
43: INCIDENT_ID NUMBER := FND_API.G_MISS_NUM,
44: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
45: CUSTOMER_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
46: UNIT_OF_MEASURE VARCHAR2(3) := FND_API.G_MISS_CHAR,
47: REPAIR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
40:
41: TYPE REPLN_Rec_Type IS RECORD(
42: REPAIR_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
43: INCIDENT_ID NUMBER := FND_API.G_MISS_NUM,
44: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
45: CUSTOMER_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
46: UNIT_OF_MEASURE VARCHAR2(3) := FND_API.G_MISS_CHAR,
47: REPAIR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
48: -- RESOURCE_GROUP Added by Vijay 10/28/2004
41: TYPE REPLN_Rec_Type IS RECORD(
42: REPAIR_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
43: INCIDENT_ID NUMBER := FND_API.G_MISS_NUM,
44: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
45: CUSTOMER_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
46: UNIT_OF_MEASURE VARCHAR2(3) := FND_API.G_MISS_CHAR,
47: REPAIR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
48: -- RESOURCE_GROUP Added by Vijay 10/28/2004
49: RESOURCE_GROUP NUMBER := FND_API.G_MISS_NUM, -- swai: bug 7565999, revert change for FP bug#5197546
42: REPAIR_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
43: INCIDENT_ID NUMBER := FND_API.G_MISS_NUM,
44: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
45: CUSTOMER_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
46: UNIT_OF_MEASURE VARCHAR2(3) := FND_API.G_MISS_CHAR,
47: REPAIR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
48: -- RESOURCE_GROUP Added by Vijay 10/28/2004
49: RESOURCE_GROUP NUMBER := FND_API.G_MISS_NUM, -- swai: bug 7565999, revert change for FP bug#5197546
50: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
43: INCIDENT_ID NUMBER := FND_API.G_MISS_NUM,
44: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
45: CUSTOMER_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
46: UNIT_OF_MEASURE VARCHAR2(3) := FND_API.G_MISS_CHAR,
47: REPAIR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
48: -- RESOURCE_GROUP Added by Vijay 10/28/2004
49: RESOURCE_GROUP NUMBER := FND_API.G_MISS_NUM, -- swai: bug 7565999, revert change for FP bug#5197546
50: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
51: PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
45: CUSTOMER_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
46: UNIT_OF_MEASURE VARCHAR2(3) := FND_API.G_MISS_CHAR,
47: REPAIR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
48: -- RESOURCE_GROUP Added by Vijay 10/28/2004
49: RESOURCE_GROUP NUMBER := FND_API.G_MISS_NUM, -- swai: bug 7565999, revert change for FP bug#5197546
50: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
51: PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
52: TASK_ID NUMBER := FND_API.G_MISS_NUM,
53: UNIT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR, -- rfieldma, prj integration
46: UNIT_OF_MEASURE VARCHAR2(3) := FND_API.G_MISS_CHAR,
47: REPAIR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
48: -- RESOURCE_GROUP Added by Vijay 10/28/2004
49: RESOURCE_GROUP NUMBER := FND_API.G_MISS_NUM, -- swai: bug 7565999, revert change for FP bug#5197546
50: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
51: PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
52: TASK_ID NUMBER := FND_API.G_MISS_NUM,
53: UNIT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR, -- rfieldma, prj integration
54: CONTRACT_LINE_ID NUMBER := FND_API.G_MISS_NUM,
47: REPAIR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
48: -- RESOURCE_GROUP Added by Vijay 10/28/2004
49: RESOURCE_GROUP NUMBER := FND_API.G_MISS_NUM, -- swai: bug 7565999, revert change for FP bug#5197546
50: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
51: PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
52: TASK_ID NUMBER := FND_API.G_MISS_NUM,
53: UNIT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR, -- rfieldma, prj integration
54: CONTRACT_LINE_ID NUMBER := FND_API.G_MISS_NUM,
55: AUTO_PROCESS_RMA VARCHAR2(1) := FND_API.G_MISS_CHAR,
48: -- RESOURCE_GROUP Added by Vijay 10/28/2004
49: RESOURCE_GROUP NUMBER := FND_API.G_MISS_NUM, -- swai: bug 7565999, revert change for FP bug#5197546
50: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
51: PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
52: TASK_ID NUMBER := FND_API.G_MISS_NUM,
53: UNIT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR, -- rfieldma, prj integration
54: CONTRACT_LINE_ID NUMBER := FND_API.G_MISS_NUM,
55: AUTO_PROCESS_RMA VARCHAR2(1) := FND_API.G_MISS_CHAR,
56: REPAIR_MODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
49: RESOURCE_GROUP NUMBER := FND_API.G_MISS_NUM, -- swai: bug 7565999, revert change for FP bug#5197546
50: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
51: PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
52: TASK_ID NUMBER := FND_API.G_MISS_NUM,
53: UNIT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR, -- rfieldma, prj integration
54: CONTRACT_LINE_ID NUMBER := FND_API.G_MISS_NUM,
55: AUTO_PROCESS_RMA VARCHAR2(1) := FND_API.G_MISS_CHAR,
56: REPAIR_MODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
50: RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
51: PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
52: TASK_ID NUMBER := FND_API.G_MISS_NUM,
53: UNIT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR, -- rfieldma, prj integration
54: CONTRACT_LINE_ID NUMBER := FND_API.G_MISS_NUM,
55: AUTO_PROCESS_RMA VARCHAR2(1) := FND_API.G_MISS_CHAR,
56: REPAIR_MODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
58: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
51: PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
52: TASK_ID NUMBER := FND_API.G_MISS_NUM,
53: UNIT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR, -- rfieldma, prj integration
54: CONTRACT_LINE_ID NUMBER := FND_API.G_MISS_NUM,
55: AUTO_PROCESS_RMA VARCHAR2(1) := FND_API.G_MISS_CHAR,
56: REPAIR_MODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
58: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
59: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
52: TASK_ID NUMBER := FND_API.G_MISS_NUM,
53: UNIT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR, -- rfieldma, prj integration
54: CONTRACT_LINE_ID NUMBER := FND_API.G_MISS_NUM,
55: AUTO_PROCESS_RMA VARCHAR2(1) := FND_API.G_MISS_CHAR,
56: REPAIR_MODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
58: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
59: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
60: STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
53: UNIT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR, -- rfieldma, prj integration
54: CONTRACT_LINE_ID NUMBER := FND_API.G_MISS_NUM,
55: AUTO_PROCESS_RMA VARCHAR2(1) := FND_API.G_MISS_CHAR,
56: REPAIR_MODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
58: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
59: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
60: STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: STATUS_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: CONTRACT_LINE_ID NUMBER := FND_API.G_MISS_NUM,
55: AUTO_PROCESS_RMA VARCHAR2(1) := FND_API.G_MISS_CHAR,
56: REPAIR_MODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
58: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
59: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
60: STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: STATUS_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: DATE_CLOSED DATE := FND_API.G_MISS_DATE,
55: AUTO_PROCESS_RMA VARCHAR2(1) := FND_API.G_MISS_CHAR,
56: REPAIR_MODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
58: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
59: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
60: STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: STATUS_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: DATE_CLOSED DATE := FND_API.G_MISS_DATE,
63: APPROVAL_REQUIRED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
56: REPAIR_MODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
58: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
59: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
60: STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: STATUS_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: DATE_CLOSED DATE := FND_API.G_MISS_DATE,
63: APPROVAL_REQUIRED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
64: APPROVAL_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
58: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
59: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
60: STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: STATUS_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: DATE_CLOSED DATE := FND_API.G_MISS_DATE,
63: APPROVAL_REQUIRED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
64: APPROVAL_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: ITEM_REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
59: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
60: STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: STATUS_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: DATE_CLOSED DATE := FND_API.G_MISS_DATE,
63: APPROVAL_REQUIRED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
64: APPROVAL_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: PROMISE_DATE DATE := FND_API.G_MISS_DATE,
59: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM,
60: STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: STATUS_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: DATE_CLOSED DATE := FND_API.G_MISS_DATE,
63: APPROVAL_REQUIRED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
64: APPROVAL_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: PROMISE_DATE DATE := FND_API.G_MISS_DATE,
67: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: STATUS_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: DATE_CLOSED DATE := FND_API.G_MISS_DATE,
63: APPROVAL_REQUIRED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
64: APPROVAL_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: PROMISE_DATE DATE := FND_API.G_MISS_DATE,
67: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: STATUS_REASON_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: DATE_CLOSED DATE := FND_API.G_MISS_DATE,
63: APPROVAL_REQUIRED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
64: APPROVAL_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: PROMISE_DATE DATE := FND_API.G_MISS_DATE,
67: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: DATE_CLOSED DATE := FND_API.G_MISS_DATE,
63: APPROVAL_REQUIRED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
64: APPROVAL_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: PROMISE_DATE DATE := FND_API.G_MISS_DATE,
67: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: APPROVAL_REQUIRED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
64: APPROVAL_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: PROMISE_DATE DATE := FND_API.G_MISS_DATE,
67: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: APPROVAL_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: PROMISE_DATE DATE := FND_API.G_MISS_DATE,
67: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: PROMISE_DATE DATE := FND_API.G_MISS_DATE,
67: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: PROMISE_DATE DATE := FND_API.G_MISS_DATE,
67: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: QUANTITY NUMBER := FND_API.G_MISS_NUM,
76: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: QUANTITY NUMBER := FND_API.G_MISS_NUM,
84: QUANTITY_IN_WIP NUMBER := FND_API.G_MISS_NUM,
77: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: QUANTITY NUMBER := FND_API.G_MISS_NUM,
84: QUANTITY_IN_WIP NUMBER := FND_API.G_MISS_NUM,
85: QUANTITY_RCVD NUMBER := FND_API.G_MISS_NUM,
78: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: QUANTITY NUMBER := FND_API.G_MISS_NUM,
84: QUANTITY_IN_WIP NUMBER := FND_API.G_MISS_NUM,
85: QUANTITY_RCVD NUMBER := FND_API.G_MISS_NUM,
86: QUANTITY_SHIPPED NUMBER := FND_API.G_MISS_NUM,
79: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: QUANTITY NUMBER := FND_API.G_MISS_NUM,
84: QUANTITY_IN_WIP NUMBER := FND_API.G_MISS_NUM,
85: QUANTITY_RCVD NUMBER := FND_API.G_MISS_NUM,
86: QUANTITY_SHIPPED NUMBER := FND_API.G_MISS_NUM,
87: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: QUANTITY NUMBER := FND_API.G_MISS_NUM,
84: QUANTITY_IN_WIP NUMBER := FND_API.G_MISS_NUM,
85: QUANTITY_RCVD NUMBER := FND_API.G_MISS_NUM,
86: QUANTITY_SHIPPED NUMBER := FND_API.G_MISS_NUM,
87: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
88: DEFAULT_PO_NUM VARCHAR2(80) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: QUANTITY NUMBER := FND_API.G_MISS_NUM,
84: QUANTITY_IN_WIP NUMBER := FND_API.G_MISS_NUM,
85: QUANTITY_RCVD NUMBER := FND_API.G_MISS_NUM,
86: QUANTITY_SHIPPED NUMBER := FND_API.G_MISS_NUM,
87: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
88: DEFAULT_PO_NUM VARCHAR2(80) := FND_API.G_MISS_CHAR,
89: REPAIR_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
82: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: QUANTITY NUMBER := FND_API.G_MISS_NUM,
84: QUANTITY_IN_WIP NUMBER := FND_API.G_MISS_NUM,
85: QUANTITY_RCVD NUMBER := FND_API.G_MISS_NUM,
86: QUANTITY_SHIPPED NUMBER := FND_API.G_MISS_NUM,
87: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
88: DEFAULT_PO_NUM VARCHAR2(80) := FND_API.G_MISS_CHAR,
89: REPAIR_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
90: RO_TXN_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
83: QUANTITY NUMBER := FND_API.G_MISS_NUM,
84: QUANTITY_IN_WIP NUMBER := FND_API.G_MISS_NUM,
85: QUANTITY_RCVD NUMBER := FND_API.G_MISS_NUM,
86: QUANTITY_SHIPPED NUMBER := FND_API.G_MISS_NUM,
87: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
88: DEFAULT_PO_NUM VARCHAR2(80) := FND_API.G_MISS_CHAR,
89: REPAIR_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
90: RO_TXN_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
91: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
84: QUANTITY_IN_WIP NUMBER := FND_API.G_MISS_NUM,
85: QUANTITY_RCVD NUMBER := FND_API.G_MISS_NUM,
86: QUANTITY_SHIPPED NUMBER := FND_API.G_MISS_NUM,
87: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
88: DEFAULT_PO_NUM VARCHAR2(80) := FND_API.G_MISS_CHAR,
89: REPAIR_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
90: RO_TXN_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
91: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
92: ORIGINAL_SOURCE_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: QUANTITY_RCVD NUMBER := FND_API.G_MISS_NUM,
86: QUANTITY_SHIPPED NUMBER := FND_API.G_MISS_NUM,
87: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
88: DEFAULT_PO_NUM VARCHAR2(80) := FND_API.G_MISS_CHAR,
89: REPAIR_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
90: RO_TXN_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
91: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
92: ORIGINAL_SOURCE_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
93: ORIGINAL_SOURCE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
86: QUANTITY_SHIPPED NUMBER := FND_API.G_MISS_NUM,
87: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
88: DEFAULT_PO_NUM VARCHAR2(80) := FND_API.G_MISS_CHAR,
89: REPAIR_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
90: RO_TXN_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
91: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
92: ORIGINAL_SOURCE_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
93: ORIGINAL_SOURCE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
94: ORIGINAL_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
87: CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
88: DEFAULT_PO_NUM VARCHAR2(80) := FND_API.G_MISS_CHAR,
89: REPAIR_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
90: RO_TXN_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
91: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
92: ORIGINAL_SOURCE_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
93: ORIGINAL_SOURCE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
94: ORIGINAL_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
95: PRICE_LIST_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
88: DEFAULT_PO_NUM VARCHAR2(80) := FND_API.G_MISS_CHAR,
89: REPAIR_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
90: RO_TXN_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
91: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
92: ORIGINAL_SOURCE_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
93: ORIGINAL_SOURCE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
94: ORIGINAL_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
95: PRICE_LIST_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
96: SUPERCESSION_INV_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
89: REPAIR_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
90: RO_TXN_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
91: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
92: ORIGINAL_SOURCE_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
93: ORIGINAL_SOURCE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
94: ORIGINAL_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
95: PRICE_LIST_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
96: SUPERCESSION_INV_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
97: FLOW_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
90: RO_TXN_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
91: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
92: ORIGINAL_SOURCE_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
93: ORIGINAL_SOURCE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
94: ORIGINAL_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
95: PRICE_LIST_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
96: SUPERCESSION_INV_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
97: FLOW_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
98: FLOW_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
91: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
92: ORIGINAL_SOURCE_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
93: ORIGINAL_SOURCE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
94: ORIGINAL_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
95: PRICE_LIST_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
96: SUPERCESSION_INV_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
97: FLOW_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
98: FLOW_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: FLOW_STATUS VARCHAR2(80) := FND_API.G_MISS_CHAR,
92: ORIGINAL_SOURCE_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
93: ORIGINAL_SOURCE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
94: ORIGINAL_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
95: PRICE_LIST_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
96: SUPERCESSION_INV_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
97: FLOW_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
98: FLOW_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: FLOW_STATUS VARCHAR2(80) := FND_API.G_MISS_CHAR,
100: INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
93: ORIGINAL_SOURCE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
94: ORIGINAL_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
95: PRICE_LIST_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
96: SUPERCESSION_INV_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
97: FLOW_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
98: FLOW_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: FLOW_STATUS VARCHAR2(80) := FND_API.G_MISS_CHAR,
100: INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
101: -- swai: bug 4666344 added problem description
94: ORIGINAL_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
95: PRICE_LIST_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
96: SUPERCESSION_INV_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
97: FLOW_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
98: FLOW_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: FLOW_STATUS VARCHAR2(80) := FND_API.G_MISS_CHAR,
100: INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
101: -- swai: bug 4666344 added problem description
102: PROBLEM_DESCRIPTION VARCHAR(240):= FND_API.G_MISS_CHAR,
95: PRICE_LIST_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
96: SUPERCESSION_INV_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
97: FLOW_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
98: FLOW_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: FLOW_STATUS VARCHAR2(80) := FND_API.G_MISS_CHAR,
100: INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
101: -- swai: bug 4666344 added problem description
102: PROBLEM_DESCRIPTION VARCHAR(240):= FND_API.G_MISS_CHAR,
103: RO_PRIORITY_CODE VARCHAR(80):= FND_API.G_MISS_CHAR, -- swai: R12
96: SUPERCESSION_INV_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
97: FLOW_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
98: FLOW_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: FLOW_STATUS VARCHAR2(80) := FND_API.G_MISS_CHAR,
100: INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
101: -- swai: bug 4666344 added problem description
102: PROBLEM_DESCRIPTION VARCHAR(240):= FND_API.G_MISS_CHAR,
103: RO_PRIORITY_CODE VARCHAR(80):= FND_API.G_MISS_CHAR, -- swai: R12
104: RESOLVE_BY_DATE DATE := FND_API.G_MISS_DATE, -- rfieldma: 5355051
98: FLOW_STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: FLOW_STATUS VARCHAR2(80) := FND_API.G_MISS_CHAR,
100: INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
101: -- swai: bug 4666344 added problem description
102: PROBLEM_DESCRIPTION VARCHAR(240):= FND_API.G_MISS_CHAR,
103: RO_PRIORITY_CODE VARCHAR(80):= FND_API.G_MISS_CHAR, -- swai: R12
104: RESOLVE_BY_DATE DATE := FND_API.G_MISS_DATE, -- rfieldma: 5355051
105: BULLETIN_CHECK_DATE DATE := FND_API.G_MISS_DATE,
106: ESCALATION_CODE VARCHAR(30) := FND_API.G_MISS_CHAR,
99: FLOW_STATUS VARCHAR2(80) := FND_API.G_MISS_CHAR,
100: INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
101: -- swai: bug 4666344 added problem description
102: PROBLEM_DESCRIPTION VARCHAR(240):= FND_API.G_MISS_CHAR,
103: RO_PRIORITY_CODE VARCHAR(80):= FND_API.G_MISS_CHAR, -- swai: R12
104: RESOLVE_BY_DATE DATE := FND_API.G_MISS_DATE, -- rfieldma: 5355051
105: BULLETIN_CHECK_DATE DATE := FND_API.G_MISS_DATE,
106: ESCALATION_CODE VARCHAR(30) := FND_API.G_MISS_CHAR,
107: RO_WARRANTY_STATUS_CODE VARCHAR(30) := FND_API.G_MISS_CHAR,
100: INVENTORY_ORG_ID NUMBER := FND_API.G_MISS_NUM,
101: -- swai: bug 4666344 added problem description
102: PROBLEM_DESCRIPTION VARCHAR(240):= FND_API.G_MISS_CHAR,
103: RO_PRIORITY_CODE VARCHAR(80):= FND_API.G_MISS_CHAR, -- swai: R12
104: RESOLVE_BY_DATE DATE := FND_API.G_MISS_DATE, -- rfieldma: 5355051
105: BULLETIN_CHECK_DATE DATE := FND_API.G_MISS_DATE,
106: ESCALATION_CODE VARCHAR(30) := FND_API.G_MISS_CHAR,
107: RO_WARRANTY_STATUS_CODE VARCHAR(30) := FND_API.G_MISS_CHAR,
108: REPAIR_YIELD_QUANTITY NUMBER := FND_API.G_MISS_NUM, --bug#6692459
101: -- swai: bug 4666344 added problem description
102: PROBLEM_DESCRIPTION VARCHAR(240):= FND_API.G_MISS_CHAR,
103: RO_PRIORITY_CODE VARCHAR(80):= FND_API.G_MISS_CHAR, -- swai: R12
104: RESOLVE_BY_DATE DATE := FND_API.G_MISS_DATE, -- rfieldma: 5355051
105: BULLETIN_CHECK_DATE DATE := FND_API.G_MISS_DATE,
106: ESCALATION_CODE VARCHAR(30) := FND_API.G_MISS_CHAR,
107: RO_WARRANTY_STATUS_CODE VARCHAR(30) := FND_API.G_MISS_CHAR,
108: REPAIR_YIELD_QUANTITY NUMBER := FND_API.G_MISS_NUM, --bug#6692459
109: ATTRIBUTE16 VARCHAR2(150) := FND_API.G_MISS_CHAR, -- SUBHAT, DFF CHANGES(bug#7497907)
102: PROBLEM_DESCRIPTION VARCHAR(240):= FND_API.G_MISS_CHAR,
103: RO_PRIORITY_CODE VARCHAR(80):= FND_API.G_MISS_CHAR, -- swai: R12
104: RESOLVE_BY_DATE DATE := FND_API.G_MISS_DATE, -- rfieldma: 5355051
105: BULLETIN_CHECK_DATE DATE := FND_API.G_MISS_DATE,
106: ESCALATION_CODE VARCHAR(30) := FND_API.G_MISS_CHAR,
107: RO_WARRANTY_STATUS_CODE VARCHAR(30) := FND_API.G_MISS_CHAR,
108: REPAIR_YIELD_QUANTITY NUMBER := FND_API.G_MISS_NUM, --bug#6692459
109: ATTRIBUTE16 VARCHAR2(150) := FND_API.G_MISS_CHAR, -- SUBHAT, DFF CHANGES(bug#7497907)
110: ATTRIBUTE17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
103: RO_PRIORITY_CODE VARCHAR(80):= FND_API.G_MISS_CHAR, -- swai: R12
104: RESOLVE_BY_DATE DATE := FND_API.G_MISS_DATE, -- rfieldma: 5355051
105: BULLETIN_CHECK_DATE DATE := FND_API.G_MISS_DATE,
106: ESCALATION_CODE VARCHAR(30) := FND_API.G_MISS_CHAR,
107: RO_WARRANTY_STATUS_CODE VARCHAR(30) := FND_API.G_MISS_CHAR,
108: REPAIR_YIELD_QUANTITY NUMBER := FND_API.G_MISS_NUM, --bug#6692459
109: ATTRIBUTE16 VARCHAR2(150) := FND_API.G_MISS_CHAR, -- SUBHAT, DFF CHANGES(bug#7497907)
110: ATTRIBUTE17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
111: ATTRIBUTE18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
104: RESOLVE_BY_DATE DATE := FND_API.G_MISS_DATE, -- rfieldma: 5355051
105: BULLETIN_CHECK_DATE DATE := FND_API.G_MISS_DATE,
106: ESCALATION_CODE VARCHAR(30) := FND_API.G_MISS_CHAR,
107: RO_WARRANTY_STATUS_CODE VARCHAR(30) := FND_API.G_MISS_CHAR,
108: REPAIR_YIELD_QUANTITY NUMBER := FND_API.G_MISS_NUM, --bug#6692459
109: ATTRIBUTE16 VARCHAR2(150) := FND_API.G_MISS_CHAR, -- SUBHAT, DFF CHANGES(bug#7497907)
110: ATTRIBUTE17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
111: ATTRIBUTE18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
112: ATTRIBUTE19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
105: BULLETIN_CHECK_DATE DATE := FND_API.G_MISS_DATE,
106: ESCALATION_CODE VARCHAR(30) := FND_API.G_MISS_CHAR,
107: RO_WARRANTY_STATUS_CODE VARCHAR(30) := FND_API.G_MISS_CHAR,
108: REPAIR_YIELD_QUANTITY NUMBER := FND_API.G_MISS_NUM, --bug#6692459
109: ATTRIBUTE16 VARCHAR2(150) := FND_API.G_MISS_CHAR, -- SUBHAT, DFF CHANGES(bug#7497907)
110: ATTRIBUTE17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
111: ATTRIBUTE18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
112: ATTRIBUTE19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
113: ATTRIBUTE20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
106: ESCALATION_CODE VARCHAR(30) := FND_API.G_MISS_CHAR,
107: RO_WARRANTY_STATUS_CODE VARCHAR(30) := FND_API.G_MISS_CHAR,
108: REPAIR_YIELD_QUANTITY NUMBER := FND_API.G_MISS_NUM, --bug#6692459
109: ATTRIBUTE16 VARCHAR2(150) := FND_API.G_MISS_CHAR, -- SUBHAT, DFF CHANGES(bug#7497907)
110: ATTRIBUTE17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
111: ATTRIBUTE18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
112: ATTRIBUTE19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
113: ATTRIBUTE20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
114: ATTRIBUTE21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
107: RO_WARRANTY_STATUS_CODE VARCHAR(30) := FND_API.G_MISS_CHAR,
108: REPAIR_YIELD_QUANTITY NUMBER := FND_API.G_MISS_NUM, --bug#6692459
109: ATTRIBUTE16 VARCHAR2(150) := FND_API.G_MISS_CHAR, -- SUBHAT, DFF CHANGES(bug#7497907)
110: ATTRIBUTE17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
111: ATTRIBUTE18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
112: ATTRIBUTE19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
113: ATTRIBUTE20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
114: ATTRIBUTE21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
115: ATTRIBUTE22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
108: REPAIR_YIELD_QUANTITY NUMBER := FND_API.G_MISS_NUM, --bug#6692459
109: ATTRIBUTE16 VARCHAR2(150) := FND_API.G_MISS_CHAR, -- SUBHAT, DFF CHANGES(bug#7497907)
110: ATTRIBUTE17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
111: ATTRIBUTE18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
112: ATTRIBUTE19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
113: ATTRIBUTE20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
114: ATTRIBUTE21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
115: ATTRIBUTE22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
116: ATTRIBUTE23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
109: ATTRIBUTE16 VARCHAR2(150) := FND_API.G_MISS_CHAR, -- SUBHAT, DFF CHANGES(bug#7497907)
110: ATTRIBUTE17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
111: ATTRIBUTE18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
112: ATTRIBUTE19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
113: ATTRIBUTE20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
114: ATTRIBUTE21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
115: ATTRIBUTE22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
116: ATTRIBUTE23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
117: ATTRIBUTE24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
110: ATTRIBUTE17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
111: ATTRIBUTE18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
112: ATTRIBUTE19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
113: ATTRIBUTE20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
114: ATTRIBUTE21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
115: ATTRIBUTE22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
116: ATTRIBUTE23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
117: ATTRIBUTE24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
118: ATTRIBUTE25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
111: ATTRIBUTE18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
112: ATTRIBUTE19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
113: ATTRIBUTE20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
114: ATTRIBUTE21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
115: ATTRIBUTE22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
116: ATTRIBUTE23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
117: ATTRIBUTE24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
118: ATTRIBUTE25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
119: ATTRIBUTE26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
112: ATTRIBUTE19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
113: ATTRIBUTE20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
114: ATTRIBUTE21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
115: ATTRIBUTE22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
116: ATTRIBUTE23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
117: ATTRIBUTE24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
118: ATTRIBUTE25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
119: ATTRIBUTE26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
120: ATTRIBUTE27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
113: ATTRIBUTE20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
114: ATTRIBUTE21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
115: ATTRIBUTE22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
116: ATTRIBUTE23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
117: ATTRIBUTE24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
118: ATTRIBUTE25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
119: ATTRIBUTE26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
120: ATTRIBUTE27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
121: ATTRIBUTE28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
114: ATTRIBUTE21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
115: ATTRIBUTE22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
116: ATTRIBUTE23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
117: ATTRIBUTE24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
118: ATTRIBUTE25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
119: ATTRIBUTE26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
120: ATTRIBUTE27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
121: ATTRIBUTE28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: ATTRIBUTE29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
115: ATTRIBUTE22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
116: ATTRIBUTE23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
117: ATTRIBUTE24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
118: ATTRIBUTE25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
119: ATTRIBUTE26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
120: ATTRIBUTE27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
121: ATTRIBUTE28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: ATTRIBUTE29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
123: ATTRIBUTE30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
116: ATTRIBUTE23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
117: ATTRIBUTE24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
118: ATTRIBUTE25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
119: ATTRIBUTE26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
120: ATTRIBUTE27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
121: ATTRIBUTE28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: ATTRIBUTE29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
123: ATTRIBUTE30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
124: RETURN_ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR, -- returns management fields. 12.2, subhat
117: ATTRIBUTE24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
118: ATTRIBUTE25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
119: ATTRIBUTE26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
120: ATTRIBUTE27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
121: ATTRIBUTE28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: ATTRIBUTE29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
123: ATTRIBUTE30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
124: RETURN_ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR, -- returns management fields. 12.2, subhat
125: RETURN_ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
118: ATTRIBUTE25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
119: ATTRIBUTE26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
120: ATTRIBUTE27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
121: ATTRIBUTE28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: ATTRIBUTE29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
123: ATTRIBUTE30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
124: RETURN_ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR, -- returns management fields. 12.2, subhat
125: RETURN_ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
126: RETURN_ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
119: ATTRIBUTE26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
120: ATTRIBUTE27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
121: ATTRIBUTE28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: ATTRIBUTE29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
123: ATTRIBUTE30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
124: RETURN_ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR, -- returns management fields. 12.2, subhat
125: RETURN_ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
126: RETURN_ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
127: RETURN_ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
120: ATTRIBUTE27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
121: ATTRIBUTE28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: ATTRIBUTE29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
123: ATTRIBUTE30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
124: RETURN_ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR, -- returns management fields. 12.2, subhat
125: RETURN_ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
126: RETURN_ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
127: RETURN_ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
128: RETURN_ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
121: ATTRIBUTE28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: ATTRIBUTE29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
123: ATTRIBUTE30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
124: RETURN_ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR, -- returns management fields. 12.2, subhat
125: RETURN_ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
126: RETURN_ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
127: RETURN_ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
128: RETURN_ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129: RETURN_ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: ATTRIBUTE29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
123: ATTRIBUTE30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
124: RETURN_ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR, -- returns management fields. 12.2, subhat
125: RETURN_ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
126: RETURN_ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
127: RETURN_ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
128: RETURN_ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129: RETURN_ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: RETURN_ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
123: ATTRIBUTE30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
124: RETURN_ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR, -- returns management fields. 12.2, subhat
125: RETURN_ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
126: RETURN_ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
127: RETURN_ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
128: RETURN_ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129: RETURN_ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: RETURN_ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: RETURN_ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
124: RETURN_ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR, -- returns management fields. 12.2, subhat
125: RETURN_ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
126: RETURN_ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
127: RETURN_ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
128: RETURN_ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129: RETURN_ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: RETURN_ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: RETURN_ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: RETURN_ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
125: RETURN_ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
126: RETURN_ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
127: RETURN_ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
128: RETURN_ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129: RETURN_ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: RETURN_ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: RETURN_ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: RETURN_ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: RETURN_ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
126: RETURN_ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
127: RETURN_ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
128: RETURN_ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129: RETURN_ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: RETURN_ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: RETURN_ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: RETURN_ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: RETURN_ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: RETURN_ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
127: RETURN_ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
128: RETURN_ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129: RETURN_ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: RETURN_ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: RETURN_ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: RETURN_ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: RETURN_ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: RETURN_ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: RETURN_ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
128: RETURN_ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129: RETURN_ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: RETURN_ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: RETURN_ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: RETURN_ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: RETURN_ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: RETURN_ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: RETURN_ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: RETURN_ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129: RETURN_ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: RETURN_ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: RETURN_ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: RETURN_ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: RETURN_ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: RETURN_ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: RETURN_ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: RETURN_ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: RETURN_ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: RETURN_ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: RETURN_ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: RETURN_ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: RETURN_ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: RETURN_ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: RETURN_ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: RETURN_ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: RETURN_ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: RETURN_ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: RETURN_ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: RETURN_ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: RETURN_ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: RETURN_ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: RETURN_ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: RETURN_ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: RETURN_ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: RETURN_ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: RETURN_ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: RETURN_ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: RETURN_ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: RETURN_ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: RETURN_ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: RETURN_ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: RETURN_ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: RETURN_ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: RETURN_ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: RETURN_ATTRIBUTE16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: RETURN_ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: RETURN_ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: RETURN_ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: RETURN_ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: RETURN_ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: RETURN_ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: RETURN_ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: RETURN_ATTRIBUTE16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: RETURN_ATTRIBUTE17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: RETURN_ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: RETURN_ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: RETURN_ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: RETURN_ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: RETURN_ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: RETURN_ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: RETURN_ATTRIBUTE16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: RETURN_ATTRIBUTE17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: RETURN_ATTRIBUTE18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: RETURN_ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: RETURN_ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: RETURN_ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: RETURN_ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: RETURN_ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: RETURN_ATTRIBUTE16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: RETURN_ATTRIBUTE17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: RETURN_ATTRIBUTE18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: RETURN_ATTRIBUTE19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: RETURN_ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: RETURN_ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: RETURN_ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: RETURN_ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: RETURN_ATTRIBUTE16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: RETURN_ATTRIBUTE17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: RETURN_ATTRIBUTE18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: RETURN_ATTRIBUTE19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: RETURN_ATTRIBUTE20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: RETURN_ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: RETURN_ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: RETURN_ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: RETURN_ATTRIBUTE16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: RETURN_ATTRIBUTE17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: RETURN_ATTRIBUTE18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: RETURN_ATTRIBUTE19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: RETURN_ATTRIBUTE20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: RETURN_ATTRIBUTE21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: RETURN_ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: RETURN_ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: RETURN_ATTRIBUTE16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: RETURN_ATTRIBUTE17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: RETURN_ATTRIBUTE18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: RETURN_ATTRIBUTE19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: RETURN_ATTRIBUTE20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: RETURN_ATTRIBUTE21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: RETURN_ATTRIBUTE22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: RETURN_ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: RETURN_ATTRIBUTE16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: RETURN_ATTRIBUTE17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: RETURN_ATTRIBUTE18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: RETURN_ATTRIBUTE19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: RETURN_ATTRIBUTE20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: RETURN_ATTRIBUTE21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: RETURN_ATTRIBUTE22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: RETURN_ATTRIBUTE23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: RETURN_ATTRIBUTE16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: RETURN_ATTRIBUTE17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: RETURN_ATTRIBUTE18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: RETURN_ATTRIBUTE19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: RETURN_ATTRIBUTE20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: RETURN_ATTRIBUTE21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: RETURN_ATTRIBUTE22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: RETURN_ATTRIBUTE23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: RETURN_ATTRIBUTE24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: RETURN_ATTRIBUTE17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: RETURN_ATTRIBUTE18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: RETURN_ATTRIBUTE19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: RETURN_ATTRIBUTE20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: RETURN_ATTRIBUTE21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: RETURN_ATTRIBUTE22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: RETURN_ATTRIBUTE23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: RETURN_ATTRIBUTE24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: RETURN_ATTRIBUTE25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: RETURN_ATTRIBUTE18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: RETURN_ATTRIBUTE19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: RETURN_ATTRIBUTE20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: RETURN_ATTRIBUTE21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: RETURN_ATTRIBUTE22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: RETURN_ATTRIBUTE23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: RETURN_ATTRIBUTE24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: RETURN_ATTRIBUTE25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: RETURN_ATTRIBUTE26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: RETURN_ATTRIBUTE19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: RETURN_ATTRIBUTE20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: RETURN_ATTRIBUTE21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: RETURN_ATTRIBUTE22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: RETURN_ATTRIBUTE23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: RETURN_ATTRIBUTE24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: RETURN_ATTRIBUTE25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: RETURN_ATTRIBUTE26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: RETURN_ATTRIBUTE27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: RETURN_ATTRIBUTE20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: RETURN_ATTRIBUTE21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: RETURN_ATTRIBUTE22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: RETURN_ATTRIBUTE23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: RETURN_ATTRIBUTE24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: RETURN_ATTRIBUTE25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: RETURN_ATTRIBUTE26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: RETURN_ATTRIBUTE27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: RETURN_ATTRIBUTE28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: RETURN_ATTRIBUTE21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: RETURN_ATTRIBUTE22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: RETURN_ATTRIBUTE23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: RETURN_ATTRIBUTE24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: RETURN_ATTRIBUTE25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: RETURN_ATTRIBUTE26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: RETURN_ATTRIBUTE27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: RETURN_ATTRIBUTE28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: RETURN_ATTRIBUTE29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: RETURN_ATTRIBUTE22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: RETURN_ATTRIBUTE23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: RETURN_ATTRIBUTE24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: RETURN_ATTRIBUTE25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: RETURN_ATTRIBUTE26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: RETURN_ATTRIBUTE27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: RETURN_ATTRIBUTE28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: RETURN_ATTRIBUTE29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: RETURN_ATTRIBUTE30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: RETURN_ATTRIBUTE23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: RETURN_ATTRIBUTE24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: RETURN_ATTRIBUTE25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: RETURN_ATTRIBUTE26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: RETURN_ATTRIBUTE27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: RETURN_ATTRIBUTE28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: RETURN_ATTRIBUTE29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: RETURN_ATTRIBUTE30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: WAYBILL_NO VARCHAR2(30) := FND_API.G_MISS_CHAR,
148: RETURN_ATTRIBUTE24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: RETURN_ATTRIBUTE25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: RETURN_ATTRIBUTE26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: RETURN_ATTRIBUTE27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: RETURN_ATTRIBUTE28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: RETURN_ATTRIBUTE29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: RETURN_ATTRIBUTE30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: WAYBILL_NO VARCHAR2(30) := FND_API.G_MISS_CHAR,
156: RETURN_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
149: RETURN_ATTRIBUTE25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: RETURN_ATTRIBUTE26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: RETURN_ATTRIBUTE27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: RETURN_ATTRIBUTE28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: RETURN_ATTRIBUTE29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: RETURN_ATTRIBUTE30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: WAYBILL_NO VARCHAR2(30) := FND_API.G_MISS_CHAR,
156: RETURN_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
157: PARENT_REPAIR_LINE_ID NUMBER := FND_API.G_MISS_NUM --bug#13698799 auto create ro, parent ro
150: RETURN_ATTRIBUTE26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: RETURN_ATTRIBUTE27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: RETURN_ATTRIBUTE28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: RETURN_ATTRIBUTE29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: RETURN_ATTRIBUTE30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: WAYBILL_NO VARCHAR2(30) := FND_API.G_MISS_CHAR,
156: RETURN_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
157: PARENT_REPAIR_LINE_ID NUMBER := FND_API.G_MISS_NUM --bug#13698799 auto create ro, parent ro
158: );
151: RETURN_ATTRIBUTE27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: RETURN_ATTRIBUTE28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: RETURN_ATTRIBUTE29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: RETURN_ATTRIBUTE30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: WAYBILL_NO VARCHAR2(30) := FND_API.G_MISS_CHAR,
156: RETURN_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
157: PARENT_REPAIR_LINE_ID NUMBER := FND_API.G_MISS_NUM --bug#13698799 auto create ro, parent ro
158: );
159: --
152: RETURN_ATTRIBUTE28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: RETURN_ATTRIBUTE29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: RETURN_ATTRIBUTE30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: WAYBILL_NO VARCHAR2(30) := FND_API.G_MISS_CHAR,
156: RETURN_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
157: PARENT_REPAIR_LINE_ID NUMBER := FND_API.G_MISS_NUM --bug#13698799 auto create ro, parent ro
158: );
159: --
160: G_MISS_REPLN_REC REPLN_Rec_Type;
153: RETURN_ATTRIBUTE29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: RETURN_ATTRIBUTE30 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: WAYBILL_NO VARCHAR2(30) := FND_API.G_MISS_CHAR,
156: RETURN_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
157: PARENT_REPAIR_LINE_ID NUMBER := FND_API.G_MISS_NUM --bug#13698799 auto create ro, parent ro
158: );
159: --
160: G_MISS_REPLN_REC REPLN_Rec_Type;
161: --
162: TYPE REPLN_Tbl_Type IS TABLE OF REPLN_Rec_Type INDEX BY BINARY_INTEGER;
163:
164: -- bug#12884352
165: TYPE Repair_Type_Rec_Type IS RECORD(
166: repair_line_id NUMBER := FND_API.G_MISS_NUM,
167: from_repair_type_id NUMBER := FND_API.G_MISS_NUM,
168: to_repair_type_id NUMBER := FND_API.G_MISS_NUM,
169: common_flow_status_id NUMBER := FND_API.G_MISS_NUM,
170: reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
163:
164: -- bug#12884352
165: TYPE Repair_Type_Rec_Type IS RECORD(
166: repair_line_id NUMBER := FND_API.G_MISS_NUM,
167: from_repair_type_id NUMBER := FND_API.G_MISS_NUM,
168: to_repair_type_id NUMBER := FND_API.G_MISS_NUM,
169: common_flow_status_id NUMBER := FND_API.G_MISS_NUM,
170: reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
171: object_version_number NUMBER := FND_API.G_MISS_NUM
164: -- bug#12884352
165: TYPE Repair_Type_Rec_Type IS RECORD(
166: repair_line_id NUMBER := FND_API.G_MISS_NUM,
167: from_repair_type_id NUMBER := FND_API.G_MISS_NUM,
168: to_repair_type_id NUMBER := FND_API.G_MISS_NUM,
169: common_flow_status_id NUMBER := FND_API.G_MISS_NUM,
170: reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
171: object_version_number NUMBER := FND_API.G_MISS_NUM
172: );
165: TYPE Repair_Type_Rec_Type IS RECORD(
166: repair_line_id NUMBER := FND_API.G_MISS_NUM,
167: from_repair_type_id NUMBER := FND_API.G_MISS_NUM,
168: to_repair_type_id NUMBER := FND_API.G_MISS_NUM,
169: common_flow_status_id NUMBER := FND_API.G_MISS_NUM,
170: reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
171: object_version_number NUMBER := FND_API.G_MISS_NUM
172: );
173:
166: repair_line_id NUMBER := FND_API.G_MISS_NUM,
167: from_repair_type_id NUMBER := FND_API.G_MISS_NUM,
168: to_repair_type_id NUMBER := FND_API.G_MISS_NUM,
169: common_flow_status_id NUMBER := FND_API.G_MISS_NUM,
170: reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
171: object_version_number NUMBER := FND_API.G_MISS_NUM
172: );
173:
174: --
167: from_repair_type_id NUMBER := FND_API.G_MISS_NUM,
168: to_repair_type_id NUMBER := FND_API.G_MISS_NUM,
169: common_flow_status_id NUMBER := FND_API.G_MISS_NUM,
170: reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
171: object_version_number NUMBER := FND_API.G_MISS_NUM
172: );
173:
174: --
175: G_MISS_REPLN_TBL REPLN_Tbl_Type;
180: -- Pre-Req : None
181: -- Parameters:
182: -- IN
183: -- p_api_version_number IN NUMBER Required
184: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
185: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
186: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
187: -- p_repair_line_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
188: -- P_REPLN_Rec IN CSD_REPAIRS_PUB.REPLN_Rec_Type Required
181: -- Parameters:
182: -- IN
183: -- p_api_version_number IN NUMBER Required
184: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
185: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
186: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
187: -- p_repair_line_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
188: -- P_REPLN_Rec IN CSD_REPAIRS_PUB.REPLN_Rec_Type Required
189: -- p_create_default_logistics IN VARCHAR2 Optional Default = N
182: -- IN
183: -- p_api_version_number IN NUMBER Required
184: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
185: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
186: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
187: -- p_repair_line_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
188: -- P_REPLN_Rec IN CSD_REPAIRS_PUB.REPLN_Rec_Type Required
189: -- p_create_default_logistics IN VARCHAR2 Optional Default = N
190: --
183: -- p_api_version_number IN NUMBER Required
184: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
185: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
186: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
187: -- p_repair_line_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
188: -- P_REPLN_Rec IN CSD_REPAIRS_PUB.REPLN_Rec_Type Required
189: -- p_create_default_logistics IN VARCHAR2 Optional Default = N
190: --
191: -- OUT:
223: * @rep:lifecycle active
224: * @rep:displayname Create Repair Order
225: */
226: PROCEDURE Create_Repair_Order(P_Api_Version_Number IN NUMBER,
227: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
228: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
229: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
230: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
231: P_REPLN_Rec IN CSD_REPAIRS_PUB.REPLN_Rec_Type,
224: * @rep:displayname Create Repair Order
225: */
226: PROCEDURE Create_Repair_Order(P_Api_Version_Number IN NUMBER,
227: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
228: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
229: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
230: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
231: P_REPLN_Rec IN CSD_REPAIRS_PUB.REPLN_Rec_Type,
232: p_create_default_logistics IN VARCHAR2 := 'N',
225: */
226: PROCEDURE Create_Repair_Order(P_Api_Version_Number IN NUMBER,
227: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
228: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
229: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
230: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
231: P_REPLN_Rec IN CSD_REPAIRS_PUB.REPLN_Rec_Type,
232: p_create_default_logistics IN VARCHAR2 := 'N',
233: X_REPAIR_LINE_ID OUT NOCOPY NUMBER,
226: PROCEDURE Create_Repair_Order(P_Api_Version_Number IN NUMBER,
227: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
228: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
229: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
230: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
231: P_REPLN_Rec IN CSD_REPAIRS_PUB.REPLN_Rec_Type,
232: p_create_default_logistics IN VARCHAR2 := 'N',
233: X_REPAIR_LINE_ID OUT NOCOPY NUMBER,
234: X_REPAIR_NUMBER OUT NOCOPY VARCHAR2,
242: -- Pre-Req : None
243: -- Parameters:
244: -- IN
245: -- p_api_version_number IN NUMBER Required
246: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
247: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
248: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
249: -- p_repair_line_id IN NUMBER Required
250: -- P_REPLN_Rec IN CSD_REPAIRS_PUB.REPLN_Rec_Type Required
243: -- Parameters:
244: -- IN
245: -- p_api_version_number IN NUMBER Required
246: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
247: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
248: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
249: -- p_repair_line_id IN NUMBER Required
250: -- P_REPLN_Rec IN CSD_REPAIRS_PUB.REPLN_Rec_Type Required
251: --
244: -- IN
245: -- p_api_version_number IN NUMBER Required
246: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
247: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
248: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
249: -- p_repair_line_id IN NUMBER Required
250: -- P_REPLN_Rec IN CSD_REPAIRS_PUB.REPLN_Rec_Type Required
251: --
252: -- OUT:
257: -- Version : Current Version 1.0
258: -- Initial Version 1.0
259: --
260: PROCEDURE Update_Repair_Order(P_Api_Version_Number IN NUMBER,
261: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
262: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
263: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
264: p_repair_line_id IN NUMBER,
265: P_REPLN_Rec IN OUT NOCOPY CSD_REPAIRS_PUB.REPLN_Rec_Type,
258: -- Initial Version 1.0
259: --
260: PROCEDURE Update_Repair_Order(P_Api_Version_Number IN NUMBER,
261: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
262: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
263: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
264: p_repair_line_id IN NUMBER,
265: P_REPLN_Rec IN OUT NOCOPY CSD_REPAIRS_PUB.REPLN_Rec_Type,
266: X_Return_Status OUT NOCOPY VARCHAR2,
259: --
260: PROCEDURE Update_Repair_Order(P_Api_Version_Number IN NUMBER,
261: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
262: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
263: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
264: p_repair_line_id IN NUMBER,
265: P_REPLN_Rec IN OUT NOCOPY CSD_REPAIRS_PUB.REPLN_Rec_Type,
266: X_Return_Status OUT NOCOPY VARCHAR2,
267: X_Msg_Count OUT NOCOPY NUMBER,
269:
270: -- bug#12884352
271: PROCEDURE Update_Repair_Type (
272: p_api_version IN NUMBER,
273: p_commit IN VARCHAR2 := fnd_api.g_false,
274: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
275: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
276: x_return_status OUT NOCOPY VARCHAR2,
277: x_msg_count OUT NOCOPY NUMBER,
270: -- bug#12884352
271: PROCEDURE Update_Repair_Type (
272: p_api_version IN NUMBER,
273: p_commit IN VARCHAR2 := fnd_api.g_false,
274: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
275: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
276: x_return_status OUT NOCOPY VARCHAR2,
277: x_msg_count OUT NOCOPY NUMBER,
278: x_msg_data OUT NOCOPY VARCHAR2,
271: PROCEDURE Update_Repair_Type (
272: p_api_version IN NUMBER,
273: p_commit IN VARCHAR2 := fnd_api.g_false,
274: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
275: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
276: x_return_status OUT NOCOPY VARCHAR2,
277: x_msg_count OUT NOCOPY NUMBER,
278: x_msg_data OUT NOCOPY VARCHAR2,
279: p_repair_type_rec IN CSD_REPAIRS_PUB.Repair_Type_Rec_Type,