eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_DELIVERY_DETAILS_PUB dependencies on FND_API

Line 55: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

51:
52: PROCEDURE detail_to_delivery(
53: -- Standard parameters
54: p_api_version IN NUMBER,
55: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
56: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
57: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
58: x_return_status OUT NOCOPY VARCHAR2,
59: x_msg_count OUT NOCOPY NUMBER,

Line 56: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

52: PROCEDURE detail_to_delivery(
53: -- Standard parameters
54: p_api_version IN NUMBER,
55: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
56: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
57: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
58: x_return_status OUT NOCOPY VARCHAR2,
59: x_msg_count OUT NOCOPY NUMBER,
60: x_msg_data OUT NOCOPY VARCHAR2,

Line 57: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

53: -- Standard parameters
54: p_api_version IN NUMBER,
55: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
56: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
57: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
58: x_return_status OUT NOCOPY VARCHAR2,
59: x_msg_count OUT NOCOPY NUMBER,
60: x_msg_data OUT NOCOPY VARCHAR2,
61:

Line 65: p_delivery_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

61:
62: -- program specific parameters
63: p_TabOfDelDets IN ID_TAB_TYPE,
64: p_action IN VARCHAR2,
65: p_delivery_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
66: p_delivery_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
67: );
68:
69:

Line 66: p_delivery_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

62: -- program specific parameters
63: p_TabOfDelDets IN ID_TAB_TYPE,
64: p_action IN VARCHAR2,
65: p_delivery_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
66: p_delivery_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
67: );
68:
69:
70: -- ----------------------------------------------------------------------

Line 99: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

95: */
96: PROCEDURE split_line(
97: -- Standard parameters
98: p_api_version IN NUMBER,
99: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
100: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
101: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
102: x_return_status OUT NOCOPY VARCHAR2,
103: x_msg_count OUT NOCOPY NUMBER,

Line 100: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

96: PROCEDURE split_line(
97: -- Standard parameters
98: p_api_version IN NUMBER,
99: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
100: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
101: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
102: x_return_status OUT NOCOPY VARCHAR2,
103: x_msg_count OUT NOCOPY NUMBER,
104: x_msg_data OUT NOCOPY VARCHAR2,

Line 101: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

97: -- Standard parameters
98: p_api_version IN NUMBER,
99: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
100: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
101: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
102: x_return_status OUT NOCOPY VARCHAR2,
103: x_msg_count OUT NOCOPY NUMBER,
104: x_msg_data OUT NOCOPY VARCHAR2,
105:

Line 116: source_header_id NUMBER DEFAULT FND_API.G_MISS_NUM,

112:
113:
114: --bug 1747202: default these attributes so they won't be updated.
115: TYPE ChangedAttributeRecType IS RECORD (
116: source_header_id NUMBER DEFAULT FND_API.G_MISS_NUM,
117: source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
118: sold_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
119: customer_number NUMBER DEFAULT FND_API.G_MISS_NUM,
120: sold_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 117: source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,

113:
114: --bug 1747202: default these attributes so they won't be updated.
115: TYPE ChangedAttributeRecType IS RECORD (
116: source_header_id NUMBER DEFAULT FND_API.G_MISS_NUM,
117: source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
118: sold_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
119: customer_number NUMBER DEFAULT FND_API.G_MISS_NUM,
120: sold_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
121: ship_from_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 118: sold_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,

114: --bug 1747202: default these attributes so they won't be updated.
115: TYPE ChangedAttributeRecType IS RECORD (
116: source_header_id NUMBER DEFAULT FND_API.G_MISS_NUM,
117: source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
118: sold_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
119: customer_number NUMBER DEFAULT FND_API.G_MISS_NUM,
120: sold_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
121: ship_from_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
122: ship_from_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,

Line 119: customer_number NUMBER DEFAULT FND_API.G_MISS_NUM,

115: TYPE ChangedAttributeRecType IS RECORD (
116: source_header_id NUMBER DEFAULT FND_API.G_MISS_NUM,
117: source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
118: sold_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
119: customer_number NUMBER DEFAULT FND_API.G_MISS_NUM,
120: sold_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
121: ship_from_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
122: ship_from_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
123: ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 120: sold_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,

116: source_header_id NUMBER DEFAULT FND_API.G_MISS_NUM,
117: source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
118: sold_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
119: customer_number NUMBER DEFAULT FND_API.G_MISS_NUM,
120: sold_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
121: ship_from_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
122: ship_from_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
123: ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
124: ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,

Line 121: ship_from_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,

117: source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
118: sold_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
119: customer_number NUMBER DEFAULT FND_API.G_MISS_NUM,
120: sold_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
121: ship_from_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
122: ship_from_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
123: ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
124: ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
125: ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 122: ship_from_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,

118: sold_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
119: customer_number NUMBER DEFAULT FND_API.G_MISS_NUM,
120: sold_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
121: ship_from_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
122: ship_from_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
123: ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
124: ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
125: ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
126: deliver_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 123: ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,

119: customer_number NUMBER DEFAULT FND_API.G_MISS_NUM,
120: sold_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
121: ship_from_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
122: ship_from_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
123: ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
124: ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
125: ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
126: deliver_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
127: deliver_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,

Line 124: ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,

120: sold_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
121: ship_from_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
122: ship_from_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
123: ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
124: ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
125: ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
126: deliver_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
127: deliver_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
128: deliver_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 125: ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,

121: ship_from_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
122: ship_from_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
123: ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
124: ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
125: ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
126: deliver_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
127: deliver_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
128: deliver_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
129: intmed_ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 126: deliver_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,

122: ship_from_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
123: ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
124: ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
125: ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
126: deliver_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
127: deliver_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
128: deliver_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
129: intmed_ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
130: intmed_ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,

Line 127: deliver_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,

123: ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
124: ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
125: ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
126: deliver_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
127: deliver_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
128: deliver_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
129: intmed_ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
130: intmed_ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
131: intmed_ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 128: deliver_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,

124: ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
125: ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
126: deliver_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
127: deliver_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
128: deliver_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
129: intmed_ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
130: intmed_ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
131: intmed_ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
132: ship_tolerance_above NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 129: intmed_ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,

125: ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
126: deliver_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
127: deliver_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
128: deliver_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
129: intmed_ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
130: intmed_ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
131: intmed_ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
132: ship_tolerance_above NUMBER DEFAULT FND_API.G_MISS_NUM,
133: ship_tolerance_below NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 130: intmed_ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,

126: deliver_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
127: deliver_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
128: deliver_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
129: intmed_ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
130: intmed_ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
131: intmed_ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
132: ship_tolerance_above NUMBER DEFAULT FND_API.G_MISS_NUM,
133: ship_tolerance_below NUMBER DEFAULT FND_API.G_MISS_NUM,
134: ordered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 131: intmed_ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,

127: deliver_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
128: deliver_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
129: intmed_ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
130: intmed_ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
131: intmed_ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
132: ship_tolerance_above NUMBER DEFAULT FND_API.G_MISS_NUM,
133: ship_tolerance_below NUMBER DEFAULT FND_API.G_MISS_NUM,
134: ordered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
135: ordered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, /* added for OPM*/

Line 132: ship_tolerance_above NUMBER DEFAULT FND_API.G_MISS_NUM,

128: deliver_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
129: intmed_ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
130: intmed_ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
131: intmed_ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
132: ship_tolerance_above NUMBER DEFAULT FND_API.G_MISS_NUM,
133: ship_tolerance_below NUMBER DEFAULT FND_API.G_MISS_NUM,
134: ordered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
135: ordered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, /* added for OPM*/
136: order_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,

Line 133: ship_tolerance_below NUMBER DEFAULT FND_API.G_MISS_NUM,

129: intmed_ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
130: intmed_ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
131: intmed_ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
132: ship_tolerance_above NUMBER DEFAULT FND_API.G_MISS_NUM,
133: ship_tolerance_below NUMBER DEFAULT FND_API.G_MISS_NUM,
134: ordered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
135: ordered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, /* added for OPM*/
136: order_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
137: ordered_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR, /* added for OPM*/

Line 134: ordered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,

130: intmed_ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
131: intmed_ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
132: ship_tolerance_above NUMBER DEFAULT FND_API.G_MISS_NUM,
133: ship_tolerance_below NUMBER DEFAULT FND_API.G_MISS_NUM,
134: ordered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
135: ordered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, /* added for OPM*/
136: order_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
137: ordered_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR, /* added for OPM*/
138: -- HW OPMCONV -changed size of grade to 150

Line 135: ordered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, /* added for OPM*/

131: intmed_ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
132: ship_tolerance_above NUMBER DEFAULT FND_API.G_MISS_NUM,
133: ship_tolerance_below NUMBER DEFAULT FND_API.G_MISS_NUM,
134: ordered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
135: ordered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, /* added for OPM*/
136: order_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
137: ordered_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR, /* added for OPM*/
138: -- HW OPMCONV -changed size of grade to 150
139: preferred_grade VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR, /* added for OPM */

Line 136: order_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,

132: ship_tolerance_above NUMBER DEFAULT FND_API.G_MISS_NUM,
133: ship_tolerance_below NUMBER DEFAULT FND_API.G_MISS_NUM,
134: ordered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
135: ordered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, /* added for OPM*/
136: order_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
137: ordered_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR, /* added for OPM*/
138: -- HW OPMCONV -changed size of grade to 150
139: preferred_grade VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR, /* added for OPM */
140: ordered_qty_unit_of_measure VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,

Line 137: ordered_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR, /* added for OPM*/

133: ship_tolerance_below NUMBER DEFAULT FND_API.G_MISS_NUM,
134: ordered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
135: ordered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, /* added for OPM*/
136: order_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
137: ordered_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR, /* added for OPM*/
138: -- HW OPMCONV -changed size of grade to 150
139: preferred_grade VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR, /* added for OPM */
140: ordered_qty_unit_of_measure VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
141: ordered_qty_unit_of_measure2 VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR, /* added for OPM*/

Line 139: preferred_grade VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR, /* added for OPM */

135: ordered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, /* added for OPM*/
136: order_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
137: ordered_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR, /* added for OPM*/
138: -- HW OPMCONV -changed size of grade to 150
139: preferred_grade VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR, /* added for OPM */
140: ordered_qty_unit_of_measure VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
141: ordered_qty_unit_of_measure2 VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR, /* added for OPM*/
142: subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
143: revision VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,

Line 140: ordered_qty_unit_of_measure VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,

136: order_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
137: ordered_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR, /* added for OPM*/
138: -- HW OPMCONV -changed size of grade to 150
139: preferred_grade VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR, /* added for OPM */
140: ordered_qty_unit_of_measure VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
141: ordered_qty_unit_of_measure2 VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR, /* added for OPM*/
142: subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
143: revision VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
144: -- HW OPMCONV - Increase the size of lot_number

Line 141: ordered_qty_unit_of_measure2 VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR, /* added for OPM*/

137: ordered_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR, /* added for OPM*/
138: -- HW OPMCONV -changed size of grade to 150
139: preferred_grade VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR, /* added for OPM */
140: ordered_qty_unit_of_measure VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
141: ordered_qty_unit_of_measure2 VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR, /* added for OPM*/
142: subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
143: revision VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
144: -- HW OPMCONV - Increase the size of lot_number
145: lot_number VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,

Line 142: subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,

138: -- HW OPMCONV -changed size of grade to 150
139: preferred_grade VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR, /* added for OPM */
140: ordered_qty_unit_of_measure VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
141: ordered_qty_unit_of_measure2 VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR, /* added for OPM*/
142: subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
143: revision VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
144: -- HW OPMCONV - Increase the size of lot_number
145: lot_number VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
146: -- HW OPMCONV - No need for sublot_number

Line 143: revision VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,

139: preferred_grade VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR, /* added for OPM */
140: ordered_qty_unit_of_measure VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
141: ordered_qty_unit_of_measure2 VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR, /* added for OPM*/
142: subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
143: revision VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
144: -- HW OPMCONV - Increase the size of lot_number
145: lot_number VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
146: -- HW OPMCONV - No need for sublot_number
147: --sublot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

Line 145: lot_number VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,

141: ordered_qty_unit_of_measure2 VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR, /* added for OPM*/
142: subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
143: revision VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
144: -- HW OPMCONV - Increase the size of lot_number
145: lot_number VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
146: -- HW OPMCONV - No need for sublot_number
147: --sublot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
148: customer_requested_lot_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
149: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

Line 147: --sublot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

143: revision VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
144: -- HW OPMCONV - Increase the size of lot_number
145: lot_number VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
146: -- HW OPMCONV - No need for sublot_number
147: --sublot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
148: customer_requested_lot_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
149: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
150: locator_id NUMBER DEFAULT FND_API.G_MISS_NUM,
151: date_requested DATE DEFAULT FND_API.G_MISS_DATE,

Line 148: customer_requested_lot_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,

144: -- HW OPMCONV - Increase the size of lot_number
145: lot_number VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
146: -- HW OPMCONV - No need for sublot_number
147: --sublot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
148: customer_requested_lot_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
149: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
150: locator_id NUMBER DEFAULT FND_API.G_MISS_NUM,
151: date_requested DATE DEFAULT FND_API.G_MISS_DATE,
152: date_scheduled DATE DEFAULT FND_API.G_MISS_DATE,

Line 149: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

145: lot_number VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
146: -- HW OPMCONV - No need for sublot_number
147: --sublot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
148: customer_requested_lot_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
149: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
150: locator_id NUMBER DEFAULT FND_API.G_MISS_NUM,
151: date_requested DATE DEFAULT FND_API.G_MISS_DATE,
152: date_scheduled DATE DEFAULT FND_API.G_MISS_DATE,
153: master_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 150: locator_id NUMBER DEFAULT FND_API.G_MISS_NUM,

146: -- HW OPMCONV - No need for sublot_number
147: --sublot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
148: customer_requested_lot_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
149: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
150: locator_id NUMBER DEFAULT FND_API.G_MISS_NUM,
151: date_requested DATE DEFAULT FND_API.G_MISS_DATE,
152: date_scheduled DATE DEFAULT FND_API.G_MISS_DATE,
153: master_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
154: detail_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 151: date_requested DATE DEFAULT FND_API.G_MISS_DATE,

147: --sublot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
148: customer_requested_lot_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
149: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
150: locator_id NUMBER DEFAULT FND_API.G_MISS_NUM,
151: date_requested DATE DEFAULT FND_API.G_MISS_DATE,
152: date_scheduled DATE DEFAULT FND_API.G_MISS_DATE,
153: master_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
154: detail_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
155: shipping_method_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

Line 152: date_scheduled DATE DEFAULT FND_API.G_MISS_DATE,

148: customer_requested_lot_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
149: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
150: locator_id NUMBER DEFAULT FND_API.G_MISS_NUM,
151: date_requested DATE DEFAULT FND_API.G_MISS_DATE,
152: date_scheduled DATE DEFAULT FND_API.G_MISS_DATE,
153: master_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
154: detail_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
155: shipping_method_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
156: carrier_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 153: master_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,

149: serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
150: locator_id NUMBER DEFAULT FND_API.G_MISS_NUM,
151: date_requested DATE DEFAULT FND_API.G_MISS_DATE,
152: date_scheduled DATE DEFAULT FND_API.G_MISS_DATE,
153: master_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
154: detail_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
155: shipping_method_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
156: carrier_id NUMBER DEFAULT FND_API.G_MISS_NUM,
157: freight_terms_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

Line 154: detail_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,

150: locator_id NUMBER DEFAULT FND_API.G_MISS_NUM,
151: date_requested DATE DEFAULT FND_API.G_MISS_DATE,
152: date_scheduled DATE DEFAULT FND_API.G_MISS_DATE,
153: master_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
154: detail_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
155: shipping_method_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
156: carrier_id NUMBER DEFAULT FND_API.G_MISS_NUM,
157: freight_terms_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
158: freight_terms_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

Line 155: shipping_method_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

151: date_requested DATE DEFAULT FND_API.G_MISS_DATE,
152: date_scheduled DATE DEFAULT FND_API.G_MISS_DATE,
153: master_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
154: detail_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
155: shipping_method_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
156: carrier_id NUMBER DEFAULT FND_API.G_MISS_NUM,
157: freight_terms_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
158: freight_terms_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
159: freight_carrier_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

Line 156: carrier_id NUMBER DEFAULT FND_API.G_MISS_NUM,

152: date_scheduled DATE DEFAULT FND_API.G_MISS_DATE,
153: master_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
154: detail_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
155: shipping_method_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
156: carrier_id NUMBER DEFAULT FND_API.G_MISS_NUM,
157: freight_terms_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
158: freight_terms_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
159: freight_carrier_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
160: shipment_priority_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

Line 157: freight_terms_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

153: master_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
154: detail_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
155: shipping_method_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
156: carrier_id NUMBER DEFAULT FND_API.G_MISS_NUM,
157: freight_terms_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
158: freight_terms_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
159: freight_carrier_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
160: shipment_priority_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
161: fob_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

Line 158: freight_terms_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

154: detail_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
155: shipping_method_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
156: carrier_id NUMBER DEFAULT FND_API.G_MISS_NUM,
157: freight_terms_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
158: freight_terms_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
159: freight_carrier_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
160: shipment_priority_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
161: fob_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
162: fob_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

Line 159: freight_carrier_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

155: shipping_method_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
156: carrier_id NUMBER DEFAULT FND_API.G_MISS_NUM,
157: freight_terms_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
158: freight_terms_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
159: freight_carrier_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
160: shipment_priority_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
161: fob_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
162: fob_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
163: dep_plan_required_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,

Line 160: shipment_priority_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

156: carrier_id NUMBER DEFAULT FND_API.G_MISS_NUM,
157: freight_terms_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
158: freight_terms_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
159: freight_carrier_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
160: shipment_priority_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
161: fob_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
162: fob_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
163: dep_plan_required_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
164: customer_prod_seq VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,

Line 161: fob_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

157: freight_terms_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
158: freight_terms_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
159: freight_carrier_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
160: shipment_priority_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
161: fob_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
162: fob_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
163: dep_plan_required_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
164: customer_prod_seq VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
165: customer_dock_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

Line 162: fob_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

158: freight_terms_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
159: freight_carrier_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
160: shipment_priority_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
161: fob_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
162: fob_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
163: dep_plan_required_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
164: customer_prod_seq VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
165: customer_dock_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
166: gross_weight NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 163: dep_plan_required_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,

159: freight_carrier_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
160: shipment_priority_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
161: fob_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
162: fob_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
163: dep_plan_required_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
164: customer_prod_seq VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
165: customer_dock_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
166: gross_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
167: net_weight NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 164: customer_prod_seq VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,

160: shipment_priority_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
161: fob_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
162: fob_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
163: dep_plan_required_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
164: customer_prod_seq VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
165: customer_dock_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
166: gross_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
167: net_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
168: weight_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,

Line 165: customer_dock_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

161: fob_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
162: fob_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
163: dep_plan_required_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
164: customer_prod_seq VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
165: customer_dock_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
166: gross_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
167: net_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
168: weight_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
169: weight_uom_desc VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,

Line 166: gross_weight NUMBER DEFAULT FND_API.G_MISS_NUM,

162: fob_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
163: dep_plan_required_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
164: customer_prod_seq VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
165: customer_dock_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
166: gross_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
167: net_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
168: weight_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
169: weight_uom_desc VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
170: volume NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 167: net_weight NUMBER DEFAULT FND_API.G_MISS_NUM,

163: dep_plan_required_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
164: customer_prod_seq VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
165: customer_dock_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
166: gross_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
167: net_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
168: weight_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
169: weight_uom_desc VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
170: volume NUMBER DEFAULT FND_API.G_MISS_NUM,
171: volume_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,

Line 168: weight_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,

164: customer_prod_seq VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
165: customer_dock_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
166: gross_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
167: net_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
168: weight_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
169: weight_uom_desc VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
170: volume NUMBER DEFAULT FND_API.G_MISS_NUM,
171: volume_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
172: volume_uom_desc VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,

Line 169: weight_uom_desc VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,

165: customer_dock_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
166: gross_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
167: net_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
168: weight_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
169: weight_uom_desc VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
170: volume NUMBER DEFAULT FND_API.G_MISS_NUM,
171: volume_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
172: volume_uom_desc VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
173: top_model_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 170: volume NUMBER DEFAULT FND_API.G_MISS_NUM,

166: gross_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
167: net_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
168: weight_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
169: weight_uom_desc VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
170: volume NUMBER DEFAULT FND_API.G_MISS_NUM,
171: volume_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
172: volume_uom_desc VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
173: top_model_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
174: ship_set_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 171: volume_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,

167: net_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
168: weight_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
169: weight_uom_desc VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
170: volume NUMBER DEFAULT FND_API.G_MISS_NUM,
171: volume_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
172: volume_uom_desc VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
173: top_model_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
174: ship_set_id NUMBER DEFAULT FND_API.G_MISS_NUM,
175: ato_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 172: volume_uom_desc VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,

168: weight_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
169: weight_uom_desc VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
170: volume NUMBER DEFAULT FND_API.G_MISS_NUM,
171: volume_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
172: volume_uom_desc VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
173: top_model_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
174: ship_set_id NUMBER DEFAULT FND_API.G_MISS_NUM,
175: ato_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
176: arrival_set_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 173: top_model_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,

169: weight_uom_desc VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
170: volume NUMBER DEFAULT FND_API.G_MISS_NUM,
171: volume_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
172: volume_uom_desc VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
173: top_model_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
174: ship_set_id NUMBER DEFAULT FND_API.G_MISS_NUM,
175: ato_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
176: arrival_set_id NUMBER DEFAULT FND_API.G_MISS_NUM,
177: ship_model_complete_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,

Line 174: ship_set_id NUMBER DEFAULT FND_API.G_MISS_NUM,

170: volume NUMBER DEFAULT FND_API.G_MISS_NUM,
171: volume_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
172: volume_uom_desc VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
173: top_model_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
174: ship_set_id NUMBER DEFAULT FND_API.G_MISS_NUM,
175: ato_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
176: arrival_set_id NUMBER DEFAULT FND_API.G_MISS_NUM,
177: ship_model_complete_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
178: cust_po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,

Line 175: ato_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,

171: volume_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
172: volume_uom_desc VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
173: top_model_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
174: ship_set_id NUMBER DEFAULT FND_API.G_MISS_NUM,
175: ato_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
176: arrival_set_id NUMBER DEFAULT FND_API.G_MISS_NUM,
177: ship_model_complete_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
178: cust_po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
179: released_status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,

Line 176: arrival_set_id NUMBER DEFAULT FND_API.G_MISS_NUM,

172: volume_uom_desc VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
173: top_model_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
174: ship_set_id NUMBER DEFAULT FND_API.G_MISS_NUM,
175: ato_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
176: arrival_set_id NUMBER DEFAULT FND_API.G_MISS_NUM,
177: ship_model_complete_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
178: cust_po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
179: released_status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
180: packing_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,

Line 177: ship_model_complete_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,

173: top_model_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
174: ship_set_id NUMBER DEFAULT FND_API.G_MISS_NUM,
175: ato_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
176: arrival_set_id NUMBER DEFAULT FND_API.G_MISS_NUM,
177: ship_model_complete_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
178: cust_po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
179: released_status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
180: packing_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
181: shipping_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,

Line 178: cust_po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,

174: ship_set_id NUMBER DEFAULT FND_API.G_MISS_NUM,
175: ato_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
176: arrival_set_id NUMBER DEFAULT FND_API.G_MISS_NUM,
177: ship_model_complete_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
178: cust_po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
179: released_status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
180: packing_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
181: shipping_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
182: container_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

Line 179: released_status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,

175: ato_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
176: arrival_set_id NUMBER DEFAULT FND_API.G_MISS_NUM,
177: ship_model_complete_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
178: cust_po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
179: released_status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
180: packing_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
181: shipping_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
182: container_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
183: container_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,

Line 180: packing_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,

176: arrival_set_id NUMBER DEFAULT FND_API.G_MISS_NUM,
177: ship_model_complete_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
178: cust_po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
179: released_status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
180: packing_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
181: shipping_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
182: container_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
183: container_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
184: delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 181: shipping_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,

177: ship_model_complete_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
178: cust_po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
179: released_status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
180: packing_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
181: shipping_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
182: container_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
183: container_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
184: delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
185: shipped_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 182: container_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

178: cust_po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
179: released_status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
180: packing_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
181: shipping_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
182: container_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
183: container_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
184: delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
185: shipped_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
186: cycle_count_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 183: container_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,

179: released_status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
180: packing_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
181: shipping_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
182: container_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
183: container_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
184: delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
185: shipped_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
186: cycle_count_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
187: shipped_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, /* Bug 3055126 */

Line 184: delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,

180: packing_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
181: shipping_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
182: container_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
183: container_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
184: delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
185: shipped_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
186: cycle_count_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
187: shipped_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, /* Bug 3055126 */
188: cycle_count_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, /* Bug 3055126 */

Line 185: shipped_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,

181: shipping_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
182: container_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
183: container_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
184: delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
185: shipped_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
186: cycle_count_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
187: shipped_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, /* Bug 3055126 */
188: cycle_count_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, /* Bug 3055126 */
189: tracking_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

Line 186: cycle_count_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,

182: container_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
183: container_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
184: delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
185: shipped_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
186: cycle_count_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
187: shipped_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, /* Bug 3055126 */
188: cycle_count_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, /* Bug 3055126 */
189: tracking_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
190: attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR, /* Bug 3105907 */

Line 187: shipped_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, /* Bug 3055126 */

183: container_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
184: delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
185: shipped_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
186: cycle_count_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
187: shipped_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, /* Bug 3055126 */
188: cycle_count_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, /* Bug 3055126 */
189: tracking_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
190: attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR, /* Bug 3105907 */
191: attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 188: cycle_count_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, /* Bug 3055126 */

184: delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
185: shipped_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
186: cycle_count_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
187: shipped_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, /* Bug 3055126 */
188: cycle_count_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, /* Bug 3055126 */
189: tracking_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
190: attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR, /* Bug 3105907 */
191: attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
192: attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 189: tracking_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

185: shipped_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
186: cycle_count_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
187: shipped_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, /* Bug 3055126 */
188: cycle_count_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, /* Bug 3055126 */
189: tracking_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
190: attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR, /* Bug 3105907 */
191: attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
192: attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
193: attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 190: attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR, /* Bug 3105907 */

186: cycle_count_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
187: shipped_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, /* Bug 3055126 */
188: cycle_count_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, /* Bug 3055126 */
189: tracking_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
190: attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR, /* Bug 3105907 */
191: attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
192: attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
193: attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
194: attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 191: attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

187: shipped_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, /* Bug 3055126 */
188: cycle_count_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, /* Bug 3055126 */
189: tracking_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
190: attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR, /* Bug 3105907 */
191: attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
192: attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
193: attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
194: attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
195: attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 192: attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

188: cycle_count_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, /* Bug 3055126 */
189: tracking_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
190: attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR, /* Bug 3105907 */
191: attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
192: attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
193: attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
194: attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
195: attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
196: attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 193: attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

189: tracking_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
190: attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR, /* Bug 3105907 */
191: attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
192: attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
193: attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
194: attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
195: attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
196: attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
197: attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 194: attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

190: attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR, /* Bug 3105907 */
191: attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
192: attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
193: attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
194: attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
195: attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
196: attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
197: attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
198: attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 195: attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

191: attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
192: attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
193: attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
194: attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
195: attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
196: attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
197: attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
198: attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
199: attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 196: attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

192: attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
193: attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
194: attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
195: attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
196: attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
197: attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
198: attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
199: attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
200: attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 197: attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

193: attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
194: attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
195: attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
196: attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
197: attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
198: attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
199: attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
200: attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
201: attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 198: attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

194: attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
195: attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
196: attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
197: attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
198: attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
199: attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
200: attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
201: attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
202: attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 199: attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

195: attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
196: attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
197: attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
198: attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
199: attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
200: attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
201: attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
202: attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
203: attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 200: attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

196: attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
197: attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
198: attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
199: attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
200: attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
201: attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
202: attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
203: attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
204: attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 201: attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

197: attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
198: attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
199: attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
200: attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
201: attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
202: attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
203: attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
204: attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
205: attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 202: attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

198: attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
199: attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
200: attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
201: attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
202: attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
203: attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
204: attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
205: attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
206: to_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

Line 203: attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

199: attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
200: attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
201: attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
202: attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
203: attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
204: attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
205: attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
206: to_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
207: -- Bug 3723831 :tp attributes also part of the public API update_shipping_attributes

Line 204: attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

200: attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
201: attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
202: attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
203: attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
204: attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
205: attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
206: to_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
207: -- Bug 3723831 :tp attributes also part of the public API update_shipping_attributes
208: tp_attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 205: attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

201: attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
202: attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
203: attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
204: attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
205: attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
206: to_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
207: -- Bug 3723831 :tp attributes also part of the public API update_shipping_attributes
208: tp_attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
209: tp_attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 206: to_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

202: attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
203: attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
204: attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
205: attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
206: to_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
207: -- Bug 3723831 :tp attributes also part of the public API update_shipping_attributes
208: tp_attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
209: tp_attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
210: tp_attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 208: tp_attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

204: attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
205: attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
206: to_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
207: -- Bug 3723831 :tp attributes also part of the public API update_shipping_attributes
208: tp_attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
209: tp_attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
210: tp_attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
211: tp_attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
212: tp_attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 209: tp_attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

205: attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
206: to_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
207: -- Bug 3723831 :tp attributes also part of the public API update_shipping_attributes
208: tp_attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
209: tp_attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
210: tp_attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
211: tp_attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
212: tp_attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
213: tp_attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 210: tp_attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

206: to_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
207: -- Bug 3723831 :tp attributes also part of the public API update_shipping_attributes
208: tp_attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
209: tp_attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
210: tp_attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
211: tp_attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
212: tp_attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
213: tp_attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
214: tp_attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 211: tp_attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

207: -- Bug 3723831 :tp attributes also part of the public API update_shipping_attributes
208: tp_attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
209: tp_attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
210: tp_attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
211: tp_attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
212: tp_attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
213: tp_attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
214: tp_attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
215: tp_attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 212: tp_attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

208: tp_attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
209: tp_attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
210: tp_attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
211: tp_attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
212: tp_attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
213: tp_attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
214: tp_attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
215: tp_attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
216: tp_attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 213: tp_attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

209: tp_attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
210: tp_attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
211: tp_attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
212: tp_attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
213: tp_attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
214: tp_attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
215: tp_attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
216: tp_attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
217: tp_attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 214: tp_attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

210: tp_attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
211: tp_attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
212: tp_attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
213: tp_attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
214: tp_attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
215: tp_attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
216: tp_attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
217: tp_attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
218: tp_attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 215: tp_attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

211: tp_attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
212: tp_attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
213: tp_attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
214: tp_attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
215: tp_attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
216: tp_attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
217: tp_attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
218: tp_attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
219: tp_attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 216: tp_attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

212: tp_attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
213: tp_attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
214: tp_attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
215: tp_attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
216: tp_attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
217: tp_attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
218: tp_attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
219: tp_attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
220: tp_attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 217: tp_attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

213: tp_attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
214: tp_attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
215: tp_attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
216: tp_attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
217: tp_attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
218: tp_attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
219: tp_attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
220: tp_attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
221: tp_attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 218: tp_attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

214: tp_attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
215: tp_attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
216: tp_attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
217: tp_attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
218: tp_attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
219: tp_attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
220: tp_attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
221: tp_attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
222: tp_attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 219: tp_attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

215: tp_attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
216: tp_attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
217: tp_attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
218: tp_attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
219: tp_attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
220: tp_attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
221: tp_attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
222: tp_attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
223: tp_attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 220: tp_attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

216: tp_attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
217: tp_attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
218: tp_attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
219: tp_attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
220: tp_attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
221: tp_attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
222: tp_attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
223: tp_attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
224: -- J: W/V Changes

Line 221: tp_attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

217: tp_attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
218: tp_attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
219: tp_attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
220: tp_attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
221: tp_attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
222: tp_attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
223: tp_attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
224: -- J: W/V Changes
225: filled_volume NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 222: tp_attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

218: tp_attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
219: tp_attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
220: tp_attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
221: tp_attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
222: tp_attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
223: tp_attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
224: -- J: W/V Changes
225: filled_volume NUMBER DEFAULT FND_API.G_MISS_NUM,
226: -- Bug 4146352 : Added seal_code and load_seq_number

Line 223: tp_attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

219: tp_attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
220: tp_attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
221: tp_attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
222: tp_attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
223: tp_attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
224: -- J: W/V Changes
225: filled_volume NUMBER DEFAULT FND_API.G_MISS_NUM,
226: -- Bug 4146352 : Added seal_code and load_seq_number
227: seal_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

Line 225: filled_volume NUMBER DEFAULT FND_API.G_MISS_NUM,

221: tp_attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
222: tp_attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
223: tp_attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
224: -- J: W/V Changes
225: filled_volume NUMBER DEFAULT FND_API.G_MISS_NUM,
226: -- Bug 4146352 : Added seal_code and load_seq_number
227: seal_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
228: load_seq_number NUMBER DEFAULT FND_API.G_MISS_NUM
229: );

Line 227: seal_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

223: tp_attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
224: -- J: W/V Changes
225: filled_volume NUMBER DEFAULT FND_API.G_MISS_NUM,
226: -- Bug 4146352 : Added seal_code and load_seq_number
227: seal_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
228: load_seq_number NUMBER DEFAULT FND_API.G_MISS_NUM
229: );
230:
231: TYPE ChangedAttributeTabType IS TABLE OF ChangedAttributeRecType

Line 228: load_seq_number NUMBER DEFAULT FND_API.G_MISS_NUM

224: -- J: W/V Changes
225: filled_volume NUMBER DEFAULT FND_API.G_MISS_NUM,
226: -- Bug 4146352 : Added seal_code and load_seq_number
227: seal_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
228: load_seq_number NUMBER DEFAULT FND_API.G_MISS_NUM
229: );
230:
231: TYPE ChangedAttributeTabType IS TABLE OF ChangedAttributeRecType
232: INDEX BY BINARY_INTEGER;

Line 244: -- initializes its attributes to the default FND_API_G values.

240:
241: -- Procedure Init_Changed_Attribute_Rec
242: -- Parameter p_init_rec record that needs to be initialized.
243: -- This procedure takes in a record of ChangedAttributeRecType and
244: -- initializes its attributes to the default FND_API_G values.
245:
246: /*#
247: * This procedure takes in a record of ChangedAttributeRecType and
248: * initializes its attributes to the default FND_API_G values.

Line 248: * initializes its attributes to the default FND_API_G values.

244: -- initializes its attributes to the default FND_API_G values.
245:
246: /*#
247: * This procedure takes in a record of ChangedAttributeRecType and
248: * initializes its attributes to the default FND_API_G values.
249: * Usually, it is called before Update_Shipping_Attributes
250: * to make sure the default value are set properly.
251: * @param p_init_rec record of ChangedAttributeRecType with the delivery line attibutes to be changed
252: * @param x_return_status return status of the API

Line 396: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

392: * @rep:displayname Autocreate Deliveries
393: */
394: PROCEDURE Autocreate_Deliveries(
395: p_api_version_number IN NUMBER
396: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
397: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
398: , x_return_status OUT NOCOPY VARCHAR2
399: , x_msg_count OUT NOCOPY NUMBER
400: , x_msg_data OUT NOCOPY VARCHAR2

Line 397: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

393: */
394: PROCEDURE Autocreate_Deliveries(
395: p_api_version_number IN NUMBER
396: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
397: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
398: , x_return_status OUT NOCOPY VARCHAR2
399: , x_msg_count OUT NOCOPY NUMBER
400: , x_msg_data OUT NOCOPY VARCHAR2
401: , p_line_rows IN WSH_UTIL_CORE.id_tab_type

Line 424: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

420: * @rep:displayname Autocreate Trip
421: */
422: PROCEDURE Autocreate_del_trip(
423: p_api_version_number IN NUMBER
424: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
425: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
426: , x_return_status OUT NOCOPY VARCHAR2
427: , x_msg_count OUT NOCOPY NUMBER
428: , x_msg_data OUT NOCOPY VARCHAR2

Line 425: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

421: */
422: PROCEDURE Autocreate_del_trip(
423: p_api_version_number IN NUMBER
424: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
425: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
426: , x_return_status OUT NOCOPY VARCHAR2
427: , x_msg_count OUT NOCOPY NUMBER
428: , x_msg_data OUT NOCOPY VARCHAR2
429: , p_line_rows IN WSH_UTIL_CORE.id_tab_type