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: REPAIR_YIELD_QUANTITY NUMBER := FND_API.G_MISS_NUM, --bug#6692459
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: REPAIR_YIELD_QUANTITY NUMBER := FND_API.G_MISS_NUM, --bug#6692459
108: ATTRIBUTE16 VARCHAR2(150) := FND_API.G_MISS_CHAR, -- SUBHAT, DFF CHANGES(bug#7497907)
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: REPAIR_YIELD_QUANTITY NUMBER := FND_API.G_MISS_NUM, --bug#6692459
108: ATTRIBUTE16 VARCHAR2(150) := FND_API.G_MISS_CHAR, -- SUBHAT, DFF CHANGES(bug#7497907)
109: ATTRIBUTE17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
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: REPAIR_YIELD_QUANTITY NUMBER := FND_API.G_MISS_NUM, --bug#6692459
108: ATTRIBUTE16 VARCHAR2(150) := FND_API.G_MISS_CHAR, -- SUBHAT, DFF CHANGES(bug#7497907)
109: ATTRIBUTE17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
110: ATTRIBUTE18 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: REPAIR_YIELD_QUANTITY NUMBER := FND_API.G_MISS_NUM, --bug#6692459
108: ATTRIBUTE16 VARCHAR2(150) := FND_API.G_MISS_CHAR, -- SUBHAT, DFF CHANGES(bug#7497907)
109: ATTRIBUTE17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
110: ATTRIBUTE18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
111: ATTRIBUTE19 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: REPAIR_YIELD_QUANTITY NUMBER := FND_API.G_MISS_NUM, --bug#6692459
108: ATTRIBUTE16 VARCHAR2(150) := FND_API.G_MISS_CHAR, -- SUBHAT, DFF CHANGES(bug#7497907)
109: ATTRIBUTE17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
110: ATTRIBUTE18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
111: ATTRIBUTE19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
112: ATTRIBUTE20 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: REPAIR_YIELD_QUANTITY NUMBER := FND_API.G_MISS_NUM, --bug#6692459
108: ATTRIBUTE16 VARCHAR2(150) := FND_API.G_MISS_CHAR, -- SUBHAT, DFF CHANGES(bug#7497907)
109: ATTRIBUTE17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
110: ATTRIBUTE18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
111: ATTRIBUTE19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
112: ATTRIBUTE20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
113: ATTRIBUTE21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
106: ESCALATION_CODE VARCHAR(30) := FND_API.G_MISS_CHAR,
107: REPAIR_YIELD_QUANTITY NUMBER := FND_API.G_MISS_NUM, --bug#6692459
108: ATTRIBUTE16 VARCHAR2(150) := FND_API.G_MISS_CHAR, -- SUBHAT, DFF CHANGES(bug#7497907)
109: ATTRIBUTE17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
110: ATTRIBUTE18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
111: ATTRIBUTE19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
112: ATTRIBUTE20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
113: ATTRIBUTE21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
114: ATTRIBUTE22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
107: REPAIR_YIELD_QUANTITY NUMBER := FND_API.G_MISS_NUM, --bug#6692459
108: ATTRIBUTE16 VARCHAR2(150) := FND_API.G_MISS_CHAR, -- SUBHAT, DFF CHANGES(bug#7497907)
109: ATTRIBUTE17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
110: ATTRIBUTE18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
111: ATTRIBUTE19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
112: ATTRIBUTE20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
113: ATTRIBUTE21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
114: ATTRIBUTE22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
115: ATTRIBUTE23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
108: ATTRIBUTE16 VARCHAR2(150) := FND_API.G_MISS_CHAR, -- SUBHAT, DFF CHANGES(bug#7497907)
109: ATTRIBUTE17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
110: ATTRIBUTE18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
111: ATTRIBUTE19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
112: ATTRIBUTE20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
113: ATTRIBUTE21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
114: ATTRIBUTE22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
115: ATTRIBUTE23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
116: ATTRIBUTE24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
109: ATTRIBUTE17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
110: ATTRIBUTE18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
111: ATTRIBUTE19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
112: ATTRIBUTE20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
113: ATTRIBUTE21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
114: ATTRIBUTE22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
115: ATTRIBUTE23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
116: ATTRIBUTE24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
117: ATTRIBUTE25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
110: ATTRIBUTE18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
111: ATTRIBUTE19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
112: ATTRIBUTE20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
113: ATTRIBUTE21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
114: ATTRIBUTE22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
115: ATTRIBUTE23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
116: ATTRIBUTE24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
117: ATTRIBUTE25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
118: ATTRIBUTE26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
111: ATTRIBUTE19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
112: ATTRIBUTE20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
113: ATTRIBUTE21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
114: ATTRIBUTE22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
115: ATTRIBUTE23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
116: ATTRIBUTE24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
117: ATTRIBUTE25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
118: ATTRIBUTE26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
119: ATTRIBUTE27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
112: ATTRIBUTE20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
113: ATTRIBUTE21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
114: ATTRIBUTE22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
115: ATTRIBUTE23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
116: ATTRIBUTE24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
117: ATTRIBUTE25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
118: ATTRIBUTE26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
119: ATTRIBUTE27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
120: ATTRIBUTE28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
113: ATTRIBUTE21 VARCHAR2(150) := FND_API.G_MISS_CHAR,
114: ATTRIBUTE22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
115: ATTRIBUTE23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
116: ATTRIBUTE24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
117: ATTRIBUTE25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
118: ATTRIBUTE26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
119: ATTRIBUTE27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
120: ATTRIBUTE28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
121: ATTRIBUTE29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
114: ATTRIBUTE22 VARCHAR2(150) := FND_API.G_MISS_CHAR,
115: ATTRIBUTE23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
116: ATTRIBUTE24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
117: ATTRIBUTE25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
118: ATTRIBUTE26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
119: ATTRIBUTE27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
120: ATTRIBUTE28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
121: ATTRIBUTE29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: ATTRIBUTE30 VARCHAR2(150) := FND_API.G_MISS_CHAR
115: ATTRIBUTE23 VARCHAR2(150) := FND_API.G_MISS_CHAR,
116: ATTRIBUTE24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
117: ATTRIBUTE25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
118: ATTRIBUTE26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
119: ATTRIBUTE27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
120: ATTRIBUTE28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
121: ATTRIBUTE29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: ATTRIBUTE30 VARCHAR2(150) := FND_API.G_MISS_CHAR
123: );
116: ATTRIBUTE24 VARCHAR2(150) := FND_API.G_MISS_CHAR,
117: ATTRIBUTE25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
118: ATTRIBUTE26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
119: ATTRIBUTE27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
120: ATTRIBUTE28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
121: ATTRIBUTE29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: ATTRIBUTE30 VARCHAR2(150) := FND_API.G_MISS_CHAR
123: );
124: --
117: ATTRIBUTE25 VARCHAR2(150) := FND_API.G_MISS_CHAR,
118: ATTRIBUTE26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
119: ATTRIBUTE27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
120: ATTRIBUTE28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
121: ATTRIBUTE29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: ATTRIBUTE30 VARCHAR2(150) := FND_API.G_MISS_CHAR
123: );
124: --
125: G_MISS_REPLN_REC REPLN_Rec_Type;
118: ATTRIBUTE26 VARCHAR2(150) := FND_API.G_MISS_CHAR,
119: ATTRIBUTE27 VARCHAR2(150) := FND_API.G_MISS_CHAR,
120: ATTRIBUTE28 VARCHAR2(150) := FND_API.G_MISS_CHAR,
121: ATTRIBUTE29 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: ATTRIBUTE30 VARCHAR2(150) := FND_API.G_MISS_CHAR
123: );
124: --
125: G_MISS_REPLN_REC REPLN_Rec_Type;
126: --
135: -- Pre-Req : None
136: -- Parameters:
137: -- IN
138: -- p_api_version_number IN NUMBER Required
139: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
140: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
141: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
142: -- p_repair_line_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
143: -- P_REPLN_Rec IN CSD_REPAIRS_PUB.REPLN_Rec_Type Required
136: -- Parameters:
137: -- IN
138: -- p_api_version_number IN NUMBER Required
139: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
140: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
141: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
142: -- p_repair_line_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
143: -- P_REPLN_Rec IN CSD_REPAIRS_PUB.REPLN_Rec_Type Required
144: -- p_create_default_logistics IN VARCHAR2 Optional Default = N
137: -- IN
138: -- p_api_version_number IN NUMBER Required
139: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
140: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
141: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
142: -- p_repair_line_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
143: -- P_REPLN_Rec IN CSD_REPAIRS_PUB.REPLN_Rec_Type Required
144: -- p_create_default_logistics IN VARCHAR2 Optional Default = N
145: --
138: -- p_api_version_number IN NUMBER Required
139: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
140: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
141: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
142: -- p_repair_line_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
143: -- P_REPLN_Rec IN CSD_REPAIRS_PUB.REPLN_Rec_Type Required
144: -- p_create_default_logistics IN VARCHAR2 Optional Default = N
145: --
146: -- OUT:
178: * @rep:lifecycle active
179: * @rep:displayname Create Repair Order
180: */
181: PROCEDURE Create_Repair_Order(P_Api_Version_Number IN NUMBER,
182: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
183: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
184: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
185: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
186: P_REPLN_Rec IN CSD_REPAIRS_PUB.REPLN_Rec_Type,
179: * @rep:displayname Create Repair Order
180: */
181: PROCEDURE Create_Repair_Order(P_Api_Version_Number IN NUMBER,
182: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
183: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
184: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
185: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
186: P_REPLN_Rec IN CSD_REPAIRS_PUB.REPLN_Rec_Type,
187: p_create_default_logistics IN VARCHAR2 := 'N',
180: */
181: PROCEDURE Create_Repair_Order(P_Api_Version_Number IN NUMBER,
182: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
183: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
184: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
185: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
186: P_REPLN_Rec IN CSD_REPAIRS_PUB.REPLN_Rec_Type,
187: p_create_default_logistics IN VARCHAR2 := 'N',
188: X_REPAIR_LINE_ID OUT NOCOPY NUMBER,
181: PROCEDURE Create_Repair_Order(P_Api_Version_Number IN NUMBER,
182: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
183: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
184: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
185: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
186: P_REPLN_Rec IN CSD_REPAIRS_PUB.REPLN_Rec_Type,
187: p_create_default_logistics IN VARCHAR2 := 'N',
188: X_REPAIR_LINE_ID OUT NOCOPY NUMBER,
189: X_REPAIR_NUMBER OUT NOCOPY VARCHAR2,
197: -- Pre-Req : None
198: -- Parameters:
199: -- IN
200: -- p_api_version_number IN NUMBER Required
201: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
202: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
203: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
204: -- p_repair_line_id IN NUMBER Required
205: -- P_REPLN_Rec IN CSD_REPAIRS_PUB.REPLN_Rec_Type Required
198: -- Parameters:
199: -- IN
200: -- p_api_version_number IN NUMBER Required
201: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
202: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
203: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
204: -- p_repair_line_id IN NUMBER Required
205: -- P_REPLN_Rec IN CSD_REPAIRS_PUB.REPLN_Rec_Type Required
206: --
199: -- IN
200: -- p_api_version_number IN NUMBER Required
201: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
202: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
203: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
204: -- p_repair_line_id IN NUMBER Required
205: -- P_REPLN_Rec IN CSD_REPAIRS_PUB.REPLN_Rec_Type Required
206: --
207: -- OUT:
212: -- Version : Current Version 1.0
213: -- Initial Version 1.0
214: --
215: PROCEDURE Update_Repair_Order(P_Api_Version_Number IN NUMBER,
216: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
217: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
218: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
219: p_repair_line_id IN NUMBER,
220: P_REPLN_Rec IN OUT NOCOPY CSD_REPAIRS_PUB.REPLN_Rec_Type,
213: -- Initial Version 1.0
214: --
215: PROCEDURE Update_Repair_Order(P_Api_Version_Number IN NUMBER,
216: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
217: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
218: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
219: p_repair_line_id IN NUMBER,
220: P_REPLN_Rec IN OUT NOCOPY CSD_REPAIRS_PUB.REPLN_Rec_Type,
221: X_Return_Status OUT NOCOPY VARCHAR2,
214: --
215: PROCEDURE Update_Repair_Order(P_Api_Version_Number IN NUMBER,
216: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
217: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
218: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
219: p_repair_line_id IN NUMBER,
220: P_REPLN_Rec IN OUT NOCOPY CSD_REPAIRS_PUB.REPLN_Rec_Type,
221: X_Return_Status OUT NOCOPY VARCHAR2,
222: X_Msg_Count OUT NOCOPY NUMBER,