76:
77: IS
78: CURSOR C2 IS SELECT ASO_SHIPMENTS_S.nextval FROM sys.dual;
79: BEGIN
80: If (px_SHIPMENT_ID IS NULL) OR (px_SHIPMENT_ID = FND_API.G_MISS_NUM) then
81: OPEN C2;
82: FETCH C2 INTO px_SHIPMENT_ID;
83: CLOSE C2;
84: End If;
144: REQUEST_DATE_TYPE,
145: DEMAND_CLASS_CODE
146: ) VALUES (
147: px_SHIPMENT_ID,
148: ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
149: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
150: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
151: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
152: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
145: DEMAND_CLASS_CODE
146: ) VALUES (
147: px_SHIPMENT_ID,
148: ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
149: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
150: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
151: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
152: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
153: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
146: ) VALUES (
147: px_SHIPMENT_ID,
148: ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
149: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
150: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
151: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
152: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
153: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
154: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
147: px_SHIPMENT_ID,
148: ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
149: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
150: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
151: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
152: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
153: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
154: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
155: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
148: ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
149: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
150: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
151: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
152: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
153: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
154: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
155: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
156: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),
149: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
150: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
151: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
152: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
153: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
154: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
155: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
156: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),
157: decode( p_QUOTE_HEADER_ID, FND_API.G_MISS_NUM, NULL, p_QUOTE_HEADER_ID),
150: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
151: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
152: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
153: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
154: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
155: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
156: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),
157: decode( p_QUOTE_HEADER_ID, FND_API.G_MISS_NUM, NULL, p_QUOTE_HEADER_ID),
158: decode( p_QUOTE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_QUOTE_LINE_ID),
151: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
152: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
153: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
154: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
155: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
156: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),
157: decode( p_QUOTE_HEADER_ID, FND_API.G_MISS_NUM, NULL, p_QUOTE_HEADER_ID),
158: decode( p_QUOTE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_QUOTE_LINE_ID),
159: ASO_UTILITY_PVT.decode( p_PROMISE_DATE, FND_API.G_MISS_DATE, NULL, p_PROMISE_DATE),
152: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
153: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
154: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
155: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
156: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),
157: decode( p_QUOTE_HEADER_ID, FND_API.G_MISS_NUM, NULL, p_QUOTE_HEADER_ID),
158: decode( p_QUOTE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_QUOTE_LINE_ID),
159: ASO_UTILITY_PVT.decode( p_PROMISE_DATE, FND_API.G_MISS_DATE, NULL, p_PROMISE_DATE),
160: ASO_UTILITY_PVT.decode( p_REQUEST_DATE, FND_API.G_MISS_DATE, NULL, p_REQUEST_DATE),
153: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
154: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
155: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
156: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),
157: decode( p_QUOTE_HEADER_ID, FND_API.G_MISS_NUM, NULL, p_QUOTE_HEADER_ID),
158: decode( p_QUOTE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_QUOTE_LINE_ID),
159: ASO_UTILITY_PVT.decode( p_PROMISE_DATE, FND_API.G_MISS_DATE, NULL, p_PROMISE_DATE),
160: ASO_UTILITY_PVT.decode( p_REQUEST_DATE, FND_API.G_MISS_DATE, NULL, p_REQUEST_DATE),
161: ASO_UTILITY_PVT.decode( p_SCHEDULE_SHIP_DATE, FND_API.G_MISS_DATE, NULL, p_SCHEDULE_SHIP_DATE),
154: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
155: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
156: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),
157: decode( p_QUOTE_HEADER_ID, FND_API.G_MISS_NUM, NULL, p_QUOTE_HEADER_ID),
158: decode( p_QUOTE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_QUOTE_LINE_ID),
159: ASO_UTILITY_PVT.decode( p_PROMISE_DATE, FND_API.G_MISS_DATE, NULL, p_PROMISE_DATE),
160: ASO_UTILITY_PVT.decode( p_REQUEST_DATE, FND_API.G_MISS_DATE, NULL, p_REQUEST_DATE),
161: ASO_UTILITY_PVT.decode( p_SCHEDULE_SHIP_DATE, FND_API.G_MISS_DATE, NULL, p_SCHEDULE_SHIP_DATE),
162: decode( p_SHIP_TO_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_TO_PARTY_SITE_ID),
155: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
156: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),
157: decode( p_QUOTE_HEADER_ID, FND_API.G_MISS_NUM, NULL, p_QUOTE_HEADER_ID),
158: decode( p_QUOTE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_QUOTE_LINE_ID),
159: ASO_UTILITY_PVT.decode( p_PROMISE_DATE, FND_API.G_MISS_DATE, NULL, p_PROMISE_DATE),
160: ASO_UTILITY_PVT.decode( p_REQUEST_DATE, FND_API.G_MISS_DATE, NULL, p_REQUEST_DATE),
161: ASO_UTILITY_PVT.decode( p_SCHEDULE_SHIP_DATE, FND_API.G_MISS_DATE, NULL, p_SCHEDULE_SHIP_DATE),
162: decode( p_SHIP_TO_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_TO_PARTY_SITE_ID),
163: decode( p_SHIP_TO_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_TO_PARTY_ID),
156: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),
157: decode( p_QUOTE_HEADER_ID, FND_API.G_MISS_NUM, NULL, p_QUOTE_HEADER_ID),
158: decode( p_QUOTE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_QUOTE_LINE_ID),
159: ASO_UTILITY_PVT.decode( p_PROMISE_DATE, FND_API.G_MISS_DATE, NULL, p_PROMISE_DATE),
160: ASO_UTILITY_PVT.decode( p_REQUEST_DATE, FND_API.G_MISS_DATE, NULL, p_REQUEST_DATE),
161: ASO_UTILITY_PVT.decode( p_SCHEDULE_SHIP_DATE, FND_API.G_MISS_DATE, NULL, p_SCHEDULE_SHIP_DATE),
162: decode( p_SHIP_TO_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_TO_PARTY_SITE_ID),
163: decode( p_SHIP_TO_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_TO_PARTY_ID),
164: decode( p_SHIP_TO_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_TO_CUST_ACCOUNT_ID),
157: decode( p_QUOTE_HEADER_ID, FND_API.G_MISS_NUM, NULL, p_QUOTE_HEADER_ID),
158: decode( p_QUOTE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_QUOTE_LINE_ID),
159: ASO_UTILITY_PVT.decode( p_PROMISE_DATE, FND_API.G_MISS_DATE, NULL, p_PROMISE_DATE),
160: ASO_UTILITY_PVT.decode( p_REQUEST_DATE, FND_API.G_MISS_DATE, NULL, p_REQUEST_DATE),
161: ASO_UTILITY_PVT.decode( p_SCHEDULE_SHIP_DATE, FND_API.G_MISS_DATE, NULL, p_SCHEDULE_SHIP_DATE),
162: decode( p_SHIP_TO_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_TO_PARTY_SITE_ID),
163: decode( p_SHIP_TO_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_TO_PARTY_ID),
164: decode( p_SHIP_TO_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_TO_CUST_ACCOUNT_ID),
165: decode( p_SHIP_PARTIAL_FLAG, FND_API.G_MISS_CHAR, NULL, p_SHIP_PARTIAL_FLAG),
158: decode( p_QUOTE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_QUOTE_LINE_ID),
159: ASO_UTILITY_PVT.decode( p_PROMISE_DATE, FND_API.G_MISS_DATE, NULL, p_PROMISE_DATE),
160: ASO_UTILITY_PVT.decode( p_REQUEST_DATE, FND_API.G_MISS_DATE, NULL, p_REQUEST_DATE),
161: ASO_UTILITY_PVT.decode( p_SCHEDULE_SHIP_DATE, FND_API.G_MISS_DATE, NULL, p_SCHEDULE_SHIP_DATE),
162: decode( p_SHIP_TO_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_TO_PARTY_SITE_ID),
163: decode( p_SHIP_TO_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_TO_PARTY_ID),
164: decode( p_SHIP_TO_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_TO_CUST_ACCOUNT_ID),
165: decode( p_SHIP_PARTIAL_FLAG, FND_API.G_MISS_CHAR, NULL, p_SHIP_PARTIAL_FLAG),
166: decode( p_SHIP_SET_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_SET_ID),
159: ASO_UTILITY_PVT.decode( p_PROMISE_DATE, FND_API.G_MISS_DATE, NULL, p_PROMISE_DATE),
160: ASO_UTILITY_PVT.decode( p_REQUEST_DATE, FND_API.G_MISS_DATE, NULL, p_REQUEST_DATE),
161: ASO_UTILITY_PVT.decode( p_SCHEDULE_SHIP_DATE, FND_API.G_MISS_DATE, NULL, p_SCHEDULE_SHIP_DATE),
162: decode( p_SHIP_TO_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_TO_PARTY_SITE_ID),
163: decode( p_SHIP_TO_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_TO_PARTY_ID),
164: decode( p_SHIP_TO_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_TO_CUST_ACCOUNT_ID),
165: decode( p_SHIP_PARTIAL_FLAG, FND_API.G_MISS_CHAR, NULL, p_SHIP_PARTIAL_FLAG),
166: decode( p_SHIP_SET_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_SET_ID),
167: decode( p_SHIP_METHOD_CODE, FND_API.G_MISS_CHAR, NULL, p_SHIP_METHOD_CODE),
160: ASO_UTILITY_PVT.decode( p_REQUEST_DATE, FND_API.G_MISS_DATE, NULL, p_REQUEST_DATE),
161: ASO_UTILITY_PVT.decode( p_SCHEDULE_SHIP_DATE, FND_API.G_MISS_DATE, NULL, p_SCHEDULE_SHIP_DATE),
162: decode( p_SHIP_TO_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_TO_PARTY_SITE_ID),
163: decode( p_SHIP_TO_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_TO_PARTY_ID),
164: decode( p_SHIP_TO_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_TO_CUST_ACCOUNT_ID),
165: decode( p_SHIP_PARTIAL_FLAG, FND_API.G_MISS_CHAR, NULL, p_SHIP_PARTIAL_FLAG),
166: decode( p_SHIP_SET_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_SET_ID),
167: decode( p_SHIP_METHOD_CODE, FND_API.G_MISS_CHAR, NULL, p_SHIP_METHOD_CODE),
168: decode( p_FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR, NULL, p_FREIGHT_TERMS_CODE),
161: ASO_UTILITY_PVT.decode( p_SCHEDULE_SHIP_DATE, FND_API.G_MISS_DATE, NULL, p_SCHEDULE_SHIP_DATE),
162: decode( p_SHIP_TO_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_TO_PARTY_SITE_ID),
163: decode( p_SHIP_TO_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_TO_PARTY_ID),
164: decode( p_SHIP_TO_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_TO_CUST_ACCOUNT_ID),
165: decode( p_SHIP_PARTIAL_FLAG, FND_API.G_MISS_CHAR, NULL, p_SHIP_PARTIAL_FLAG),
166: decode( p_SHIP_SET_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_SET_ID),
167: decode( p_SHIP_METHOD_CODE, FND_API.G_MISS_CHAR, NULL, p_SHIP_METHOD_CODE),
168: decode( p_FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR, NULL, p_FREIGHT_TERMS_CODE),
169: decode( p_FREIGHT_CARRIER_CODE, FND_API.G_MISS_CHAR, NULL, p_FREIGHT_CARRIER_CODE),
162: decode( p_SHIP_TO_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_TO_PARTY_SITE_ID),
163: decode( p_SHIP_TO_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_TO_PARTY_ID),
164: decode( p_SHIP_TO_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_TO_CUST_ACCOUNT_ID),
165: decode( p_SHIP_PARTIAL_FLAG, FND_API.G_MISS_CHAR, NULL, p_SHIP_PARTIAL_FLAG),
166: decode( p_SHIP_SET_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_SET_ID),
167: decode( p_SHIP_METHOD_CODE, FND_API.G_MISS_CHAR, NULL, p_SHIP_METHOD_CODE),
168: decode( p_FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR, NULL, p_FREIGHT_TERMS_CODE),
169: decode( p_FREIGHT_CARRIER_CODE, FND_API.G_MISS_CHAR, NULL, p_FREIGHT_CARRIER_CODE),
170: decode( p_FOB_CODE, FND_API.G_MISS_CHAR, NULL, p_FOB_CODE),
163: decode( p_SHIP_TO_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_TO_PARTY_ID),
164: decode( p_SHIP_TO_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_TO_CUST_ACCOUNT_ID),
165: decode( p_SHIP_PARTIAL_FLAG, FND_API.G_MISS_CHAR, NULL, p_SHIP_PARTIAL_FLAG),
166: decode( p_SHIP_SET_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_SET_ID),
167: decode( p_SHIP_METHOD_CODE, FND_API.G_MISS_CHAR, NULL, p_SHIP_METHOD_CODE),
168: decode( p_FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR, NULL, p_FREIGHT_TERMS_CODE),
169: decode( p_FREIGHT_CARRIER_CODE, FND_API.G_MISS_CHAR, NULL, p_FREIGHT_CARRIER_CODE),
170: decode( p_FOB_CODE, FND_API.G_MISS_CHAR, NULL, p_FOB_CODE),
171: decode( p_SHIPPING_INSTRUCTIONS, FND_API.G_MISS_CHAR, NULL, p_SHIPPING_INSTRUCTIONS),
164: decode( p_SHIP_TO_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_TO_CUST_ACCOUNT_ID),
165: decode( p_SHIP_PARTIAL_FLAG, FND_API.G_MISS_CHAR, NULL, p_SHIP_PARTIAL_FLAG),
166: decode( p_SHIP_SET_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_SET_ID),
167: decode( p_SHIP_METHOD_CODE, FND_API.G_MISS_CHAR, NULL, p_SHIP_METHOD_CODE),
168: decode( p_FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR, NULL, p_FREIGHT_TERMS_CODE),
169: decode( p_FREIGHT_CARRIER_CODE, FND_API.G_MISS_CHAR, NULL, p_FREIGHT_CARRIER_CODE),
170: decode( p_FOB_CODE, FND_API.G_MISS_CHAR, NULL, p_FOB_CODE),
171: decode( p_SHIPPING_INSTRUCTIONS, FND_API.G_MISS_CHAR, NULL, p_SHIPPING_INSTRUCTIONS),
172: decode( p_PACKING_INSTRUCTIONS, FND_API.G_MISS_CHAR, NULL, p_PACKING_INSTRUCTIONS),
165: decode( p_SHIP_PARTIAL_FLAG, FND_API.G_MISS_CHAR, NULL, p_SHIP_PARTIAL_FLAG),
166: decode( p_SHIP_SET_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_SET_ID),
167: decode( p_SHIP_METHOD_CODE, FND_API.G_MISS_CHAR, NULL, p_SHIP_METHOD_CODE),
168: decode( p_FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR, NULL, p_FREIGHT_TERMS_CODE),
169: decode( p_FREIGHT_CARRIER_CODE, FND_API.G_MISS_CHAR, NULL, p_FREIGHT_CARRIER_CODE),
170: decode( p_FOB_CODE, FND_API.G_MISS_CHAR, NULL, p_FOB_CODE),
171: decode( p_SHIPPING_INSTRUCTIONS, FND_API.G_MISS_CHAR, NULL, p_SHIPPING_INSTRUCTIONS),
172: decode( p_PACKING_INSTRUCTIONS, FND_API.G_MISS_CHAR, NULL, p_PACKING_INSTRUCTIONS),
173: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
166: decode( p_SHIP_SET_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_SET_ID),
167: decode( p_SHIP_METHOD_CODE, FND_API.G_MISS_CHAR, NULL, p_SHIP_METHOD_CODE),
168: decode( p_FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR, NULL, p_FREIGHT_TERMS_CODE),
169: decode( p_FREIGHT_CARRIER_CODE, FND_API.G_MISS_CHAR, NULL, p_FREIGHT_CARRIER_CODE),
170: decode( p_FOB_CODE, FND_API.G_MISS_CHAR, NULL, p_FOB_CODE),
171: decode( p_SHIPPING_INSTRUCTIONS, FND_API.G_MISS_CHAR, NULL, p_SHIPPING_INSTRUCTIONS),
172: decode( p_PACKING_INSTRUCTIONS, FND_API.G_MISS_CHAR, NULL, p_PACKING_INSTRUCTIONS),
173: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
174: decode( p_RESERVED_QUANTITY, FND_API.G_MISS_CHAR, NULL, p_RESERVED_QUANTITY),
167: decode( p_SHIP_METHOD_CODE, FND_API.G_MISS_CHAR, NULL, p_SHIP_METHOD_CODE),
168: decode( p_FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR, NULL, p_FREIGHT_TERMS_CODE),
169: decode( p_FREIGHT_CARRIER_CODE, FND_API.G_MISS_CHAR, NULL, p_FREIGHT_CARRIER_CODE),
170: decode( p_FOB_CODE, FND_API.G_MISS_CHAR, NULL, p_FOB_CODE),
171: decode( p_SHIPPING_INSTRUCTIONS, FND_API.G_MISS_CHAR, NULL, p_SHIPPING_INSTRUCTIONS),
172: decode( p_PACKING_INSTRUCTIONS, FND_API.G_MISS_CHAR, NULL, p_PACKING_INSTRUCTIONS),
173: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
174: decode( p_RESERVED_QUANTITY, FND_API.G_MISS_CHAR, NULL, p_RESERVED_QUANTITY),
175: decode( p_RESERVATION_ID, FND_API.G_MISS_NUM, NULL, p_RESERVATION_ID),
168: decode( p_FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR, NULL, p_FREIGHT_TERMS_CODE),
169: decode( p_FREIGHT_CARRIER_CODE, FND_API.G_MISS_CHAR, NULL, p_FREIGHT_CARRIER_CODE),
170: decode( p_FOB_CODE, FND_API.G_MISS_CHAR, NULL, p_FOB_CODE),
171: decode( p_SHIPPING_INSTRUCTIONS, FND_API.G_MISS_CHAR, NULL, p_SHIPPING_INSTRUCTIONS),
172: decode( p_PACKING_INSTRUCTIONS, FND_API.G_MISS_CHAR, NULL, p_PACKING_INSTRUCTIONS),
173: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
174: decode( p_RESERVED_QUANTITY, FND_API.G_MISS_CHAR, NULL, p_RESERVED_QUANTITY),
175: decode( p_RESERVATION_ID, FND_API.G_MISS_NUM, NULL, p_RESERVATION_ID),
176: decode( p_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_ORDER_LINE_ID),
169: decode( p_FREIGHT_CARRIER_CODE, FND_API.G_MISS_CHAR, NULL, p_FREIGHT_CARRIER_CODE),
170: decode( p_FOB_CODE, FND_API.G_MISS_CHAR, NULL, p_FOB_CODE),
171: decode( p_SHIPPING_INSTRUCTIONS, FND_API.G_MISS_CHAR, NULL, p_SHIPPING_INSTRUCTIONS),
172: decode( p_PACKING_INSTRUCTIONS, FND_API.G_MISS_CHAR, NULL, p_PACKING_INSTRUCTIONS),
173: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
174: decode( p_RESERVED_QUANTITY, FND_API.G_MISS_CHAR, NULL, p_RESERVED_QUANTITY),
175: decode( p_RESERVATION_ID, FND_API.G_MISS_NUM, NULL, p_RESERVATION_ID),
176: decode( p_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_ORDER_LINE_ID),
177: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
170: decode( p_FOB_CODE, FND_API.G_MISS_CHAR, NULL, p_FOB_CODE),
171: decode( p_SHIPPING_INSTRUCTIONS, FND_API.G_MISS_CHAR, NULL, p_SHIPPING_INSTRUCTIONS),
172: decode( p_PACKING_INSTRUCTIONS, FND_API.G_MISS_CHAR, NULL, p_PACKING_INSTRUCTIONS),
173: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
174: decode( p_RESERVED_QUANTITY, FND_API.G_MISS_CHAR, NULL, p_RESERVED_QUANTITY),
175: decode( p_RESERVATION_ID, FND_API.G_MISS_NUM, NULL, p_RESERVATION_ID),
176: decode( p_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_ORDER_LINE_ID),
177: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
178: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
171: decode( p_SHIPPING_INSTRUCTIONS, FND_API.G_MISS_CHAR, NULL, p_SHIPPING_INSTRUCTIONS),
172: decode( p_PACKING_INSTRUCTIONS, FND_API.G_MISS_CHAR, NULL, p_PACKING_INSTRUCTIONS),
173: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
174: decode( p_RESERVED_QUANTITY, FND_API.G_MISS_CHAR, NULL, p_RESERVED_QUANTITY),
175: decode( p_RESERVATION_ID, FND_API.G_MISS_NUM, NULL, p_RESERVATION_ID),
176: decode( p_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_ORDER_LINE_ID),
177: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
178: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
179: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
172: decode( p_PACKING_INSTRUCTIONS, FND_API.G_MISS_CHAR, NULL, p_PACKING_INSTRUCTIONS),
173: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
174: decode( p_RESERVED_QUANTITY, FND_API.G_MISS_CHAR, NULL, p_RESERVED_QUANTITY),
175: decode( p_RESERVATION_ID, FND_API.G_MISS_NUM, NULL, p_RESERVATION_ID),
176: decode( p_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_ORDER_LINE_ID),
177: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
178: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
179: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
180: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
173: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
174: decode( p_RESERVED_QUANTITY, FND_API.G_MISS_CHAR, NULL, p_RESERVED_QUANTITY),
175: decode( p_RESERVATION_ID, FND_API.G_MISS_NUM, NULL, p_RESERVATION_ID),
176: decode( p_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_ORDER_LINE_ID),
177: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
178: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
179: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
180: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
181: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
174: decode( p_RESERVED_QUANTITY, FND_API.G_MISS_CHAR, NULL, p_RESERVED_QUANTITY),
175: decode( p_RESERVATION_ID, FND_API.G_MISS_NUM, NULL, p_RESERVATION_ID),
176: decode( p_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_ORDER_LINE_ID),
177: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
178: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
179: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
180: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
181: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
182: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
175: decode( p_RESERVATION_ID, FND_API.G_MISS_NUM, NULL, p_RESERVATION_ID),
176: decode( p_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_ORDER_LINE_ID),
177: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
178: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
179: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
180: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
181: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
182: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
183: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
176: decode( p_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_ORDER_LINE_ID),
177: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
178: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
179: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
180: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
181: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
182: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
183: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
184: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
177: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
178: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
179: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
180: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
181: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
182: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
183: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
184: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
185: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
178: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
179: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
180: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
181: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
182: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
183: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
184: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
185: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
186: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
179: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
180: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
181: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
182: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
183: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
184: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
185: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
186: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
187: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
180: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
181: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
182: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
183: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
184: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
185: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
186: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
187: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
188: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
181: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
182: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
183: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
184: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
185: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
186: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
187: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
188: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
189: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
182: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
183: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
184: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
185: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
186: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
187: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
188: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
189: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
190: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
183: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
184: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
185: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
186: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
187: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
188: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
189: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
190: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
191: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
184: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
185: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
186: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
187: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
188: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
189: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
190: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
191: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
192: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
185: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
186: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
187: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
188: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
189: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
190: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
191: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
192: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
193: decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16),
186: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
187: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
188: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
189: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
190: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
191: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
192: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
193: decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16),
194: decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17),
187: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
188: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
189: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
190: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
191: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
192: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
193: decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16),
194: decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17),
195: decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18),
188: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
189: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
190: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
191: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
192: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
193: decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16),
194: decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17),
195: decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18),
196: decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19),
189: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
190: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
191: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
192: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
193: decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16),
194: decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17),
195: decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18),
196: decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19),
197: decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20),
190: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
191: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
192: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
193: decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16),
194: decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17),
195: decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18),
196: decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19),
197: decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20),
198: decode( p_SHIPMENT_PRIORITY_CODE, FND_API.G_MISS_CHAR, NULL, p_SHIPMENT_PRIORITY_CODE),
191: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
192: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
193: decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16),
194: decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17),
195: decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18),
196: decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19),
197: decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20),
198: decode( p_SHIPMENT_PRIORITY_CODE, FND_API.G_MISS_CHAR, NULL, p_SHIPMENT_PRIORITY_CODE),
199: decode( p_SHIP_QUOTE_PRICE, FND_API.G_MISS_NUM, NULL, p_SHIP_QUOTE_PRICE),
192: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
193: decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16),
194: decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17),
195: decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18),
196: decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19),
197: decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20),
198: decode( p_SHIPMENT_PRIORITY_CODE, FND_API.G_MISS_CHAR, NULL, p_SHIPMENT_PRIORITY_CODE),
199: decode( p_SHIP_QUOTE_PRICE, FND_API.G_MISS_NUM, NULL, p_SHIP_QUOTE_PRICE),
200: decode( p_SHIP_FROM_ORG_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_FROM_ORG_ID),
193: decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16),
194: decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17),
195: decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18),
196: decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19),
197: decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20),
198: decode( p_SHIPMENT_PRIORITY_CODE, FND_API.G_MISS_CHAR, NULL, p_SHIPMENT_PRIORITY_CODE),
199: decode( p_SHIP_QUOTE_PRICE, FND_API.G_MISS_NUM, NULL, p_SHIP_QUOTE_PRICE),
200: decode( p_SHIP_FROM_ORG_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_FROM_ORG_ID),
201: decode( p_SHIP_TO_CUST_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_TO_CUST_PARTY_ID),
194: decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17),
195: decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18),
196: decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19),
197: decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20),
198: decode( p_SHIPMENT_PRIORITY_CODE, FND_API.G_MISS_CHAR, NULL, p_SHIPMENT_PRIORITY_CODE),
199: decode( p_SHIP_QUOTE_PRICE, FND_API.G_MISS_NUM, NULL, p_SHIP_QUOTE_PRICE),
200: decode( p_SHIP_FROM_ORG_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_FROM_ORG_ID),
201: decode( p_SHIP_TO_CUST_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_TO_CUST_PARTY_ID),
202: decode( p_SHIP_METHOD_CODE_FROM, FND_API.G_MISS_CHAR, NULL, p_SHIP_METHOD_CODE_FROM),
195: decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18),
196: decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19),
197: decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20),
198: decode( p_SHIPMENT_PRIORITY_CODE, FND_API.G_MISS_CHAR, NULL, p_SHIPMENT_PRIORITY_CODE),
199: decode( p_SHIP_QUOTE_PRICE, FND_API.G_MISS_NUM, NULL, p_SHIP_QUOTE_PRICE),
200: decode( p_SHIP_FROM_ORG_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_FROM_ORG_ID),
201: decode( p_SHIP_TO_CUST_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_TO_CUST_PARTY_ID),
202: decode( p_SHIP_METHOD_CODE_FROM, FND_API.G_MISS_CHAR, NULL, p_SHIP_METHOD_CODE_FROM),
203: decode( p_FREIGHT_TERMS_CODE_FROM, FND_API.G_MISS_CHAR, NULL, p_FREIGHT_TERMS_CODE_FROM),
196: decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19),
197: decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20),
198: decode( p_SHIPMENT_PRIORITY_CODE, FND_API.G_MISS_CHAR, NULL, p_SHIPMENT_PRIORITY_CODE),
199: decode( p_SHIP_QUOTE_PRICE, FND_API.G_MISS_NUM, NULL, p_SHIP_QUOTE_PRICE),
200: decode( p_SHIP_FROM_ORG_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_FROM_ORG_ID),
201: decode( p_SHIP_TO_CUST_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_TO_CUST_PARTY_ID),
202: decode( p_SHIP_METHOD_CODE_FROM, FND_API.G_MISS_CHAR, NULL, p_SHIP_METHOD_CODE_FROM),
203: decode( p_FREIGHT_TERMS_CODE_FROM, FND_API.G_MISS_CHAR, NULL, p_FREIGHT_TERMS_CODE_FROM),
204: decode ( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,1,NULL,1, p_OBJECT_VERSION_NUMBER),
197: decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20),
198: decode( p_SHIPMENT_PRIORITY_CODE, FND_API.G_MISS_CHAR, NULL, p_SHIPMENT_PRIORITY_CODE),
199: decode( p_SHIP_QUOTE_PRICE, FND_API.G_MISS_NUM, NULL, p_SHIP_QUOTE_PRICE),
200: decode( p_SHIP_FROM_ORG_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_FROM_ORG_ID),
201: decode( p_SHIP_TO_CUST_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_TO_CUST_PARTY_ID),
202: decode( p_SHIP_METHOD_CODE_FROM, FND_API.G_MISS_CHAR, NULL, p_SHIP_METHOD_CODE_FROM),
203: decode( p_FREIGHT_TERMS_CODE_FROM, FND_API.G_MISS_CHAR, NULL, p_FREIGHT_TERMS_CODE_FROM),
204: decode ( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,1,NULL,1, p_OBJECT_VERSION_NUMBER),
205: decode ( p_REQUEST_DATE_TYPE, FND_API.G_MISS_CHAR,NULL,p_REQUEST_DATE_TYPE),
198: decode( p_SHIPMENT_PRIORITY_CODE, FND_API.G_MISS_CHAR, NULL, p_SHIPMENT_PRIORITY_CODE),
199: decode( p_SHIP_QUOTE_PRICE, FND_API.G_MISS_NUM, NULL, p_SHIP_QUOTE_PRICE),
200: decode( p_SHIP_FROM_ORG_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_FROM_ORG_ID),
201: decode( p_SHIP_TO_CUST_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_TO_CUST_PARTY_ID),
202: decode( p_SHIP_METHOD_CODE_FROM, FND_API.G_MISS_CHAR, NULL, p_SHIP_METHOD_CODE_FROM),
203: decode( p_FREIGHT_TERMS_CODE_FROM, FND_API.G_MISS_CHAR, NULL, p_FREIGHT_TERMS_CODE_FROM),
204: decode ( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,1,NULL,1, p_OBJECT_VERSION_NUMBER),
205: decode ( p_REQUEST_DATE_TYPE, FND_API.G_MISS_CHAR,NULL,p_REQUEST_DATE_TYPE),
206: decode ( p_DEMAND_CLASS_CODE, FND_API.G_MISS_CHAR,NULL, p_DEMAND_CLASS_CODE)
199: decode( p_SHIP_QUOTE_PRICE, FND_API.G_MISS_NUM, NULL, p_SHIP_QUOTE_PRICE),
200: decode( p_SHIP_FROM_ORG_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_FROM_ORG_ID),
201: decode( p_SHIP_TO_CUST_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_TO_CUST_PARTY_ID),
202: decode( p_SHIP_METHOD_CODE_FROM, FND_API.G_MISS_CHAR, NULL, p_SHIP_METHOD_CODE_FROM),
203: decode( p_FREIGHT_TERMS_CODE_FROM, FND_API.G_MISS_CHAR, NULL, p_FREIGHT_TERMS_CODE_FROM),
204: decode ( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,1,NULL,1, p_OBJECT_VERSION_NUMBER),
205: decode ( p_REQUEST_DATE_TYPE, FND_API.G_MISS_CHAR,NULL,p_REQUEST_DATE_TYPE),
206: decode ( p_DEMAND_CLASS_CODE, FND_API.G_MISS_CHAR,NULL, p_DEMAND_CLASS_CODE)
207: );
200: decode( p_SHIP_FROM_ORG_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_FROM_ORG_ID),
201: decode( p_SHIP_TO_CUST_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_TO_CUST_PARTY_ID),
202: decode( p_SHIP_METHOD_CODE_FROM, FND_API.G_MISS_CHAR, NULL, p_SHIP_METHOD_CODE_FROM),
203: decode( p_FREIGHT_TERMS_CODE_FROM, FND_API.G_MISS_CHAR, NULL, p_FREIGHT_TERMS_CODE_FROM),
204: decode ( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,1,NULL,1, p_OBJECT_VERSION_NUMBER),
205: decode ( p_REQUEST_DATE_TYPE, FND_API.G_MISS_CHAR,NULL,p_REQUEST_DATE_TYPE),
206: decode ( p_DEMAND_CLASS_CODE, FND_API.G_MISS_CHAR,NULL, p_DEMAND_CLASS_CODE)
207: );
208: End Insert_Row;
201: decode( p_SHIP_TO_CUST_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_SHIP_TO_CUST_PARTY_ID),
202: decode( p_SHIP_METHOD_CODE_FROM, FND_API.G_MISS_CHAR, NULL, p_SHIP_METHOD_CODE_FROM),
203: decode( p_FREIGHT_TERMS_CODE_FROM, FND_API.G_MISS_CHAR, NULL, p_FREIGHT_TERMS_CODE_FROM),
204: decode ( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,1,NULL,1, p_OBJECT_VERSION_NUMBER),
205: decode ( p_REQUEST_DATE_TYPE, FND_API.G_MISS_CHAR,NULL,p_REQUEST_DATE_TYPE),
206: decode ( p_DEMAND_CLASS_CODE, FND_API.G_MISS_CHAR,NULL, p_DEMAND_CLASS_CODE)
207: );
208: End Insert_Row;
209:
202: decode( p_SHIP_METHOD_CODE_FROM, FND_API.G_MISS_CHAR, NULL, p_SHIP_METHOD_CODE_FROM),
203: decode( p_FREIGHT_TERMS_CODE_FROM, FND_API.G_MISS_CHAR, NULL, p_FREIGHT_TERMS_CODE_FROM),
204: decode ( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,1,NULL,1, p_OBJECT_VERSION_NUMBER),
205: decode ( p_REQUEST_DATE_TYPE, FND_API.G_MISS_CHAR,NULL,p_REQUEST_DATE_TYPE),
206: decode ( p_DEMAND_CLASS_CODE, FND_API.G_MISS_CHAR,NULL, p_DEMAND_CLASS_CODE)
207: );
208: End Insert_Row;
209:
210: PROCEDURE Update_Row(
273: IS
274: BEGIN
275: Update ASO_SHIPMENTS
276: SET
277: /* CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
278: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),*/
279: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
280: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
281: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
274: BEGIN
275: Update ASO_SHIPMENTS
276: SET
277: /* CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
278: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),*/
279: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
280: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
281: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
282: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
275: Update ASO_SHIPMENTS
276: SET
277: /* CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
278: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),*/
279: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
280: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
281: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
282: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
283: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
276: SET
277: /* CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
278: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),*/
279: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
280: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
281: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
282: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
283: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
284: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
277: /* CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
278: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),*/
279: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
280: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
281: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
282: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
283: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
284: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
285: PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
278: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),*/
279: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
280: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
281: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
282: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
283: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
284: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
285: PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
286: QUOTE_HEADER_ID = decode( p_QUOTE_HEADER_ID, FND_API.G_MISS_NUM, QUOTE_HEADER_ID, p_QUOTE_HEADER_ID),
279: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
280: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
281: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
282: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
283: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
284: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
285: PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
286: QUOTE_HEADER_ID = decode( p_QUOTE_HEADER_ID, FND_API.G_MISS_NUM, QUOTE_HEADER_ID, p_QUOTE_HEADER_ID),
287: QUOTE_LINE_ID = decode( p_QUOTE_LINE_ID, FND_API.G_MISS_NUM, QUOTE_LINE_ID, p_QUOTE_LINE_ID),
280: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
281: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
282: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
283: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
284: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
285: PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
286: QUOTE_HEADER_ID = decode( p_QUOTE_HEADER_ID, FND_API.G_MISS_NUM, QUOTE_HEADER_ID, p_QUOTE_HEADER_ID),
287: QUOTE_LINE_ID = decode( p_QUOTE_LINE_ID, FND_API.G_MISS_NUM, QUOTE_LINE_ID, p_QUOTE_LINE_ID),
288: PROMISE_DATE = ASO_UTILITY_PVT.decode( p_PROMISE_DATE, FND_API.G_MISS_DATE, PROMISE_DATE, p_PROMISE_DATE),
281: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
282: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
283: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
284: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
285: PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
286: QUOTE_HEADER_ID = decode( p_QUOTE_HEADER_ID, FND_API.G_MISS_NUM, QUOTE_HEADER_ID, p_QUOTE_HEADER_ID),
287: QUOTE_LINE_ID = decode( p_QUOTE_LINE_ID, FND_API.G_MISS_NUM, QUOTE_LINE_ID, p_QUOTE_LINE_ID),
288: PROMISE_DATE = ASO_UTILITY_PVT.decode( p_PROMISE_DATE, FND_API.G_MISS_DATE, PROMISE_DATE, p_PROMISE_DATE),
289: REQUEST_DATE = ASO_UTILITY_PVT.decode( p_REQUEST_DATE, FND_API.G_MISS_DATE, REQUEST_DATE, p_REQUEST_DATE),
282: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
283: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
284: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
285: PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
286: QUOTE_HEADER_ID = decode( p_QUOTE_HEADER_ID, FND_API.G_MISS_NUM, QUOTE_HEADER_ID, p_QUOTE_HEADER_ID),
287: QUOTE_LINE_ID = decode( p_QUOTE_LINE_ID, FND_API.G_MISS_NUM, QUOTE_LINE_ID, p_QUOTE_LINE_ID),
288: PROMISE_DATE = ASO_UTILITY_PVT.decode( p_PROMISE_DATE, FND_API.G_MISS_DATE, PROMISE_DATE, p_PROMISE_DATE),
289: REQUEST_DATE = ASO_UTILITY_PVT.decode( p_REQUEST_DATE, FND_API.G_MISS_DATE, REQUEST_DATE, p_REQUEST_DATE),
290: SCHEDULE_SHIP_DATE = ASO_UTILITY_PVT.decode( p_SCHEDULE_SHIP_DATE, FND_API.G_MISS_DATE, SCHEDULE_SHIP_DATE, p_SCHEDULE_SHIP_DATE),
283: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
284: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
285: PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
286: QUOTE_HEADER_ID = decode( p_QUOTE_HEADER_ID, FND_API.G_MISS_NUM, QUOTE_HEADER_ID, p_QUOTE_HEADER_ID),
287: QUOTE_LINE_ID = decode( p_QUOTE_LINE_ID, FND_API.G_MISS_NUM, QUOTE_LINE_ID, p_QUOTE_LINE_ID),
288: PROMISE_DATE = ASO_UTILITY_PVT.decode( p_PROMISE_DATE, FND_API.G_MISS_DATE, PROMISE_DATE, p_PROMISE_DATE),
289: REQUEST_DATE = ASO_UTILITY_PVT.decode( p_REQUEST_DATE, FND_API.G_MISS_DATE, REQUEST_DATE, p_REQUEST_DATE),
290: SCHEDULE_SHIP_DATE = ASO_UTILITY_PVT.decode( p_SCHEDULE_SHIP_DATE, FND_API.G_MISS_DATE, SCHEDULE_SHIP_DATE, p_SCHEDULE_SHIP_DATE),
291: SHIP_TO_PARTY_SITE_ID = decode( p_SHIP_TO_PARTY_SITE_ID, FND_API.G_MISS_NUM, SHIP_TO_PARTY_SITE_ID, p_SHIP_TO_PARTY_SITE_ID),
284: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
285: PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
286: QUOTE_HEADER_ID = decode( p_QUOTE_HEADER_ID, FND_API.G_MISS_NUM, QUOTE_HEADER_ID, p_QUOTE_HEADER_ID),
287: QUOTE_LINE_ID = decode( p_QUOTE_LINE_ID, FND_API.G_MISS_NUM, QUOTE_LINE_ID, p_QUOTE_LINE_ID),
288: PROMISE_DATE = ASO_UTILITY_PVT.decode( p_PROMISE_DATE, FND_API.G_MISS_DATE, PROMISE_DATE, p_PROMISE_DATE),
289: REQUEST_DATE = ASO_UTILITY_PVT.decode( p_REQUEST_DATE, FND_API.G_MISS_DATE, REQUEST_DATE, p_REQUEST_DATE),
290: SCHEDULE_SHIP_DATE = ASO_UTILITY_PVT.decode( p_SCHEDULE_SHIP_DATE, FND_API.G_MISS_DATE, SCHEDULE_SHIP_DATE, p_SCHEDULE_SHIP_DATE),
291: SHIP_TO_PARTY_SITE_ID = decode( p_SHIP_TO_PARTY_SITE_ID, FND_API.G_MISS_NUM, SHIP_TO_PARTY_SITE_ID, p_SHIP_TO_PARTY_SITE_ID),
292: SHIP_TO_PARTY_ID = decode( p_SHIP_TO_PARTY_ID, FND_API.G_MISS_NUM, SHIP_TO_PARTY_ID, p_SHIP_TO_PARTY_ID),
285: PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
286: QUOTE_HEADER_ID = decode( p_QUOTE_HEADER_ID, FND_API.G_MISS_NUM, QUOTE_HEADER_ID, p_QUOTE_HEADER_ID),
287: QUOTE_LINE_ID = decode( p_QUOTE_LINE_ID, FND_API.G_MISS_NUM, QUOTE_LINE_ID, p_QUOTE_LINE_ID),
288: PROMISE_DATE = ASO_UTILITY_PVT.decode( p_PROMISE_DATE, FND_API.G_MISS_DATE, PROMISE_DATE, p_PROMISE_DATE),
289: REQUEST_DATE = ASO_UTILITY_PVT.decode( p_REQUEST_DATE, FND_API.G_MISS_DATE, REQUEST_DATE, p_REQUEST_DATE),
290: SCHEDULE_SHIP_DATE = ASO_UTILITY_PVT.decode( p_SCHEDULE_SHIP_DATE, FND_API.G_MISS_DATE, SCHEDULE_SHIP_DATE, p_SCHEDULE_SHIP_DATE),
291: SHIP_TO_PARTY_SITE_ID = decode( p_SHIP_TO_PARTY_SITE_ID, FND_API.G_MISS_NUM, SHIP_TO_PARTY_SITE_ID, p_SHIP_TO_PARTY_SITE_ID),
292: SHIP_TO_PARTY_ID = decode( p_SHIP_TO_PARTY_ID, FND_API.G_MISS_NUM, SHIP_TO_PARTY_ID, p_SHIP_TO_PARTY_ID),
293: SHIP_TO_CUST_ACCOUNT_ID = decode( p_SHIP_TO_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, SHIP_TO_CUST_ACCOUNT_ID, p_SHIP_TO_CUST_ACCOUNT_ID),
286: QUOTE_HEADER_ID = decode( p_QUOTE_HEADER_ID, FND_API.G_MISS_NUM, QUOTE_HEADER_ID, p_QUOTE_HEADER_ID),
287: QUOTE_LINE_ID = decode( p_QUOTE_LINE_ID, FND_API.G_MISS_NUM, QUOTE_LINE_ID, p_QUOTE_LINE_ID),
288: PROMISE_DATE = ASO_UTILITY_PVT.decode( p_PROMISE_DATE, FND_API.G_MISS_DATE, PROMISE_DATE, p_PROMISE_DATE),
289: REQUEST_DATE = ASO_UTILITY_PVT.decode( p_REQUEST_DATE, FND_API.G_MISS_DATE, REQUEST_DATE, p_REQUEST_DATE),
290: SCHEDULE_SHIP_DATE = ASO_UTILITY_PVT.decode( p_SCHEDULE_SHIP_DATE, FND_API.G_MISS_DATE, SCHEDULE_SHIP_DATE, p_SCHEDULE_SHIP_DATE),
291: SHIP_TO_PARTY_SITE_ID = decode( p_SHIP_TO_PARTY_SITE_ID, FND_API.G_MISS_NUM, SHIP_TO_PARTY_SITE_ID, p_SHIP_TO_PARTY_SITE_ID),
292: SHIP_TO_PARTY_ID = decode( p_SHIP_TO_PARTY_ID, FND_API.G_MISS_NUM, SHIP_TO_PARTY_ID, p_SHIP_TO_PARTY_ID),
293: SHIP_TO_CUST_ACCOUNT_ID = decode( p_SHIP_TO_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, SHIP_TO_CUST_ACCOUNT_ID, p_SHIP_TO_CUST_ACCOUNT_ID),
294: SHIP_PARTIAL_FLAG = decode( p_SHIP_PARTIAL_FLAG, FND_API.G_MISS_CHAR, SHIP_PARTIAL_FLAG, p_SHIP_PARTIAL_FLAG),
287: QUOTE_LINE_ID = decode( p_QUOTE_LINE_ID, FND_API.G_MISS_NUM, QUOTE_LINE_ID, p_QUOTE_LINE_ID),
288: PROMISE_DATE = ASO_UTILITY_PVT.decode( p_PROMISE_DATE, FND_API.G_MISS_DATE, PROMISE_DATE, p_PROMISE_DATE),
289: REQUEST_DATE = ASO_UTILITY_PVT.decode( p_REQUEST_DATE, FND_API.G_MISS_DATE, REQUEST_DATE, p_REQUEST_DATE),
290: SCHEDULE_SHIP_DATE = ASO_UTILITY_PVT.decode( p_SCHEDULE_SHIP_DATE, FND_API.G_MISS_DATE, SCHEDULE_SHIP_DATE, p_SCHEDULE_SHIP_DATE),
291: SHIP_TO_PARTY_SITE_ID = decode( p_SHIP_TO_PARTY_SITE_ID, FND_API.G_MISS_NUM, SHIP_TO_PARTY_SITE_ID, p_SHIP_TO_PARTY_SITE_ID),
292: SHIP_TO_PARTY_ID = decode( p_SHIP_TO_PARTY_ID, FND_API.G_MISS_NUM, SHIP_TO_PARTY_ID, p_SHIP_TO_PARTY_ID),
293: SHIP_TO_CUST_ACCOUNT_ID = decode( p_SHIP_TO_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, SHIP_TO_CUST_ACCOUNT_ID, p_SHIP_TO_CUST_ACCOUNT_ID),
294: SHIP_PARTIAL_FLAG = decode( p_SHIP_PARTIAL_FLAG, FND_API.G_MISS_CHAR, SHIP_PARTIAL_FLAG, p_SHIP_PARTIAL_FLAG),
295: SHIP_SET_ID = decode( p_SHIP_SET_ID, FND_API.G_MISS_NUM, SHIP_SET_ID, p_SHIP_SET_ID),
288: PROMISE_DATE = ASO_UTILITY_PVT.decode( p_PROMISE_DATE, FND_API.G_MISS_DATE, PROMISE_DATE, p_PROMISE_DATE),
289: REQUEST_DATE = ASO_UTILITY_PVT.decode( p_REQUEST_DATE, FND_API.G_MISS_DATE, REQUEST_DATE, p_REQUEST_DATE),
290: SCHEDULE_SHIP_DATE = ASO_UTILITY_PVT.decode( p_SCHEDULE_SHIP_DATE, FND_API.G_MISS_DATE, SCHEDULE_SHIP_DATE, p_SCHEDULE_SHIP_DATE),
291: SHIP_TO_PARTY_SITE_ID = decode( p_SHIP_TO_PARTY_SITE_ID, FND_API.G_MISS_NUM, SHIP_TO_PARTY_SITE_ID, p_SHIP_TO_PARTY_SITE_ID),
292: SHIP_TO_PARTY_ID = decode( p_SHIP_TO_PARTY_ID, FND_API.G_MISS_NUM, SHIP_TO_PARTY_ID, p_SHIP_TO_PARTY_ID),
293: SHIP_TO_CUST_ACCOUNT_ID = decode( p_SHIP_TO_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, SHIP_TO_CUST_ACCOUNT_ID, p_SHIP_TO_CUST_ACCOUNT_ID),
294: SHIP_PARTIAL_FLAG = decode( p_SHIP_PARTIAL_FLAG, FND_API.G_MISS_CHAR, SHIP_PARTIAL_FLAG, p_SHIP_PARTIAL_FLAG),
295: SHIP_SET_ID = decode( p_SHIP_SET_ID, FND_API.G_MISS_NUM, SHIP_SET_ID, p_SHIP_SET_ID),
296: SHIP_METHOD_CODE = decode( p_SHIP_METHOD_CODE, FND_API.G_MISS_CHAR, SHIP_METHOD_CODE, p_SHIP_METHOD_CODE),
289: REQUEST_DATE = ASO_UTILITY_PVT.decode( p_REQUEST_DATE, FND_API.G_MISS_DATE, REQUEST_DATE, p_REQUEST_DATE),
290: SCHEDULE_SHIP_DATE = ASO_UTILITY_PVT.decode( p_SCHEDULE_SHIP_DATE, FND_API.G_MISS_DATE, SCHEDULE_SHIP_DATE, p_SCHEDULE_SHIP_DATE),
291: SHIP_TO_PARTY_SITE_ID = decode( p_SHIP_TO_PARTY_SITE_ID, FND_API.G_MISS_NUM, SHIP_TO_PARTY_SITE_ID, p_SHIP_TO_PARTY_SITE_ID),
292: SHIP_TO_PARTY_ID = decode( p_SHIP_TO_PARTY_ID, FND_API.G_MISS_NUM, SHIP_TO_PARTY_ID, p_SHIP_TO_PARTY_ID),
293: SHIP_TO_CUST_ACCOUNT_ID = decode( p_SHIP_TO_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, SHIP_TO_CUST_ACCOUNT_ID, p_SHIP_TO_CUST_ACCOUNT_ID),
294: SHIP_PARTIAL_FLAG = decode( p_SHIP_PARTIAL_FLAG, FND_API.G_MISS_CHAR, SHIP_PARTIAL_FLAG, p_SHIP_PARTIAL_FLAG),
295: SHIP_SET_ID = decode( p_SHIP_SET_ID, FND_API.G_MISS_NUM, SHIP_SET_ID, p_SHIP_SET_ID),
296: SHIP_METHOD_CODE = decode( p_SHIP_METHOD_CODE, FND_API.G_MISS_CHAR, SHIP_METHOD_CODE, p_SHIP_METHOD_CODE),
297: FREIGHT_TERMS_CODE = decode( p_FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR, FREIGHT_TERMS_CODE, p_FREIGHT_TERMS_CODE),
290: SCHEDULE_SHIP_DATE = ASO_UTILITY_PVT.decode( p_SCHEDULE_SHIP_DATE, FND_API.G_MISS_DATE, SCHEDULE_SHIP_DATE, p_SCHEDULE_SHIP_DATE),
291: SHIP_TO_PARTY_SITE_ID = decode( p_SHIP_TO_PARTY_SITE_ID, FND_API.G_MISS_NUM, SHIP_TO_PARTY_SITE_ID, p_SHIP_TO_PARTY_SITE_ID),
292: SHIP_TO_PARTY_ID = decode( p_SHIP_TO_PARTY_ID, FND_API.G_MISS_NUM, SHIP_TO_PARTY_ID, p_SHIP_TO_PARTY_ID),
293: SHIP_TO_CUST_ACCOUNT_ID = decode( p_SHIP_TO_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, SHIP_TO_CUST_ACCOUNT_ID, p_SHIP_TO_CUST_ACCOUNT_ID),
294: SHIP_PARTIAL_FLAG = decode( p_SHIP_PARTIAL_FLAG, FND_API.G_MISS_CHAR, SHIP_PARTIAL_FLAG, p_SHIP_PARTIAL_FLAG),
295: SHIP_SET_ID = decode( p_SHIP_SET_ID, FND_API.G_MISS_NUM, SHIP_SET_ID, p_SHIP_SET_ID),
296: SHIP_METHOD_CODE = decode( p_SHIP_METHOD_CODE, FND_API.G_MISS_CHAR, SHIP_METHOD_CODE, p_SHIP_METHOD_CODE),
297: FREIGHT_TERMS_CODE = decode( p_FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR, FREIGHT_TERMS_CODE, p_FREIGHT_TERMS_CODE),
298: FREIGHT_CARRIER_CODE = decode( p_FREIGHT_CARRIER_CODE, FND_API.G_MISS_CHAR, FREIGHT_CARRIER_CODE, p_FREIGHT_CARRIER_CODE),
291: SHIP_TO_PARTY_SITE_ID = decode( p_SHIP_TO_PARTY_SITE_ID, FND_API.G_MISS_NUM, SHIP_TO_PARTY_SITE_ID, p_SHIP_TO_PARTY_SITE_ID),
292: SHIP_TO_PARTY_ID = decode( p_SHIP_TO_PARTY_ID, FND_API.G_MISS_NUM, SHIP_TO_PARTY_ID, p_SHIP_TO_PARTY_ID),
293: SHIP_TO_CUST_ACCOUNT_ID = decode( p_SHIP_TO_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, SHIP_TO_CUST_ACCOUNT_ID, p_SHIP_TO_CUST_ACCOUNT_ID),
294: SHIP_PARTIAL_FLAG = decode( p_SHIP_PARTIAL_FLAG, FND_API.G_MISS_CHAR, SHIP_PARTIAL_FLAG, p_SHIP_PARTIAL_FLAG),
295: SHIP_SET_ID = decode( p_SHIP_SET_ID, FND_API.G_MISS_NUM, SHIP_SET_ID, p_SHIP_SET_ID),
296: SHIP_METHOD_CODE = decode( p_SHIP_METHOD_CODE, FND_API.G_MISS_CHAR, SHIP_METHOD_CODE, p_SHIP_METHOD_CODE),
297: FREIGHT_TERMS_CODE = decode( p_FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR, FREIGHT_TERMS_CODE, p_FREIGHT_TERMS_CODE),
298: FREIGHT_CARRIER_CODE = decode( p_FREIGHT_CARRIER_CODE, FND_API.G_MISS_CHAR, FREIGHT_CARRIER_CODE, p_FREIGHT_CARRIER_CODE),
299: FOB_CODE = decode( p_FOB_CODE, FND_API.G_MISS_CHAR, FOB_CODE, p_FOB_CODE),
292: SHIP_TO_PARTY_ID = decode( p_SHIP_TO_PARTY_ID, FND_API.G_MISS_NUM, SHIP_TO_PARTY_ID, p_SHIP_TO_PARTY_ID),
293: SHIP_TO_CUST_ACCOUNT_ID = decode( p_SHIP_TO_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, SHIP_TO_CUST_ACCOUNT_ID, p_SHIP_TO_CUST_ACCOUNT_ID),
294: SHIP_PARTIAL_FLAG = decode( p_SHIP_PARTIAL_FLAG, FND_API.G_MISS_CHAR, SHIP_PARTIAL_FLAG, p_SHIP_PARTIAL_FLAG),
295: SHIP_SET_ID = decode( p_SHIP_SET_ID, FND_API.G_MISS_NUM, SHIP_SET_ID, p_SHIP_SET_ID),
296: SHIP_METHOD_CODE = decode( p_SHIP_METHOD_CODE, FND_API.G_MISS_CHAR, SHIP_METHOD_CODE, p_SHIP_METHOD_CODE),
297: FREIGHT_TERMS_CODE = decode( p_FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR, FREIGHT_TERMS_CODE, p_FREIGHT_TERMS_CODE),
298: FREIGHT_CARRIER_CODE = decode( p_FREIGHT_CARRIER_CODE, FND_API.G_MISS_CHAR, FREIGHT_CARRIER_CODE, p_FREIGHT_CARRIER_CODE),
299: FOB_CODE = decode( p_FOB_CODE, FND_API.G_MISS_CHAR, FOB_CODE, p_FOB_CODE),
300: SHIPPING_INSTRUCTIONS = decode( p_SHIPPING_INSTRUCTIONS, FND_API.G_MISS_CHAR, SHIPPING_INSTRUCTIONS, p_SHIPPING_INSTRUCTIONS),
293: SHIP_TO_CUST_ACCOUNT_ID = decode( p_SHIP_TO_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, SHIP_TO_CUST_ACCOUNT_ID, p_SHIP_TO_CUST_ACCOUNT_ID),
294: SHIP_PARTIAL_FLAG = decode( p_SHIP_PARTIAL_FLAG, FND_API.G_MISS_CHAR, SHIP_PARTIAL_FLAG, p_SHIP_PARTIAL_FLAG),
295: SHIP_SET_ID = decode( p_SHIP_SET_ID, FND_API.G_MISS_NUM, SHIP_SET_ID, p_SHIP_SET_ID),
296: SHIP_METHOD_CODE = decode( p_SHIP_METHOD_CODE, FND_API.G_MISS_CHAR, SHIP_METHOD_CODE, p_SHIP_METHOD_CODE),
297: FREIGHT_TERMS_CODE = decode( p_FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR, FREIGHT_TERMS_CODE, p_FREIGHT_TERMS_CODE),
298: FREIGHT_CARRIER_CODE = decode( p_FREIGHT_CARRIER_CODE, FND_API.G_MISS_CHAR, FREIGHT_CARRIER_CODE, p_FREIGHT_CARRIER_CODE),
299: FOB_CODE = decode( p_FOB_CODE, FND_API.G_MISS_CHAR, FOB_CODE, p_FOB_CODE),
300: SHIPPING_INSTRUCTIONS = decode( p_SHIPPING_INSTRUCTIONS, FND_API.G_MISS_CHAR, SHIPPING_INSTRUCTIONS, p_SHIPPING_INSTRUCTIONS),
301: PACKING_INSTRUCTIONS = decode( p_PACKING_INSTRUCTIONS, FND_API.G_MISS_CHAR, PACKING_INSTRUCTIONS, p_PACKING_INSTRUCTIONS),
294: SHIP_PARTIAL_FLAG = decode( p_SHIP_PARTIAL_FLAG, FND_API.G_MISS_CHAR, SHIP_PARTIAL_FLAG, p_SHIP_PARTIAL_FLAG),
295: SHIP_SET_ID = decode( p_SHIP_SET_ID, FND_API.G_MISS_NUM, SHIP_SET_ID, p_SHIP_SET_ID),
296: SHIP_METHOD_CODE = decode( p_SHIP_METHOD_CODE, FND_API.G_MISS_CHAR, SHIP_METHOD_CODE, p_SHIP_METHOD_CODE),
297: FREIGHT_TERMS_CODE = decode( p_FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR, FREIGHT_TERMS_CODE, p_FREIGHT_TERMS_CODE),
298: FREIGHT_CARRIER_CODE = decode( p_FREIGHT_CARRIER_CODE, FND_API.G_MISS_CHAR, FREIGHT_CARRIER_CODE, p_FREIGHT_CARRIER_CODE),
299: FOB_CODE = decode( p_FOB_CODE, FND_API.G_MISS_CHAR, FOB_CODE, p_FOB_CODE),
300: SHIPPING_INSTRUCTIONS = decode( p_SHIPPING_INSTRUCTIONS, FND_API.G_MISS_CHAR, SHIPPING_INSTRUCTIONS, p_SHIPPING_INSTRUCTIONS),
301: PACKING_INSTRUCTIONS = decode( p_PACKING_INSTRUCTIONS, FND_API.G_MISS_CHAR, PACKING_INSTRUCTIONS, p_PACKING_INSTRUCTIONS),
302: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
295: SHIP_SET_ID = decode( p_SHIP_SET_ID, FND_API.G_MISS_NUM, SHIP_SET_ID, p_SHIP_SET_ID),
296: SHIP_METHOD_CODE = decode( p_SHIP_METHOD_CODE, FND_API.G_MISS_CHAR, SHIP_METHOD_CODE, p_SHIP_METHOD_CODE),
297: FREIGHT_TERMS_CODE = decode( p_FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR, FREIGHT_TERMS_CODE, p_FREIGHT_TERMS_CODE),
298: FREIGHT_CARRIER_CODE = decode( p_FREIGHT_CARRIER_CODE, FND_API.G_MISS_CHAR, FREIGHT_CARRIER_CODE, p_FREIGHT_CARRIER_CODE),
299: FOB_CODE = decode( p_FOB_CODE, FND_API.G_MISS_CHAR, FOB_CODE, p_FOB_CODE),
300: SHIPPING_INSTRUCTIONS = decode( p_SHIPPING_INSTRUCTIONS, FND_API.G_MISS_CHAR, SHIPPING_INSTRUCTIONS, p_SHIPPING_INSTRUCTIONS),
301: PACKING_INSTRUCTIONS = decode( p_PACKING_INSTRUCTIONS, FND_API.G_MISS_CHAR, PACKING_INSTRUCTIONS, p_PACKING_INSTRUCTIONS),
302: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
303: RESERVED_QUANTITY = decode( p_RESERVED_QUANTITY, FND_API.G_MISS_CHAR, RESERVED_QUANTITY, p_RESERVED_QUANTITY),
296: SHIP_METHOD_CODE = decode( p_SHIP_METHOD_CODE, FND_API.G_MISS_CHAR, SHIP_METHOD_CODE, p_SHIP_METHOD_CODE),
297: FREIGHT_TERMS_CODE = decode( p_FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR, FREIGHT_TERMS_CODE, p_FREIGHT_TERMS_CODE),
298: FREIGHT_CARRIER_CODE = decode( p_FREIGHT_CARRIER_CODE, FND_API.G_MISS_CHAR, FREIGHT_CARRIER_CODE, p_FREIGHT_CARRIER_CODE),
299: FOB_CODE = decode( p_FOB_CODE, FND_API.G_MISS_CHAR, FOB_CODE, p_FOB_CODE),
300: SHIPPING_INSTRUCTIONS = decode( p_SHIPPING_INSTRUCTIONS, FND_API.G_MISS_CHAR, SHIPPING_INSTRUCTIONS, p_SHIPPING_INSTRUCTIONS),
301: PACKING_INSTRUCTIONS = decode( p_PACKING_INSTRUCTIONS, FND_API.G_MISS_CHAR, PACKING_INSTRUCTIONS, p_PACKING_INSTRUCTIONS),
302: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
303: RESERVED_QUANTITY = decode( p_RESERVED_QUANTITY, FND_API.G_MISS_CHAR, RESERVED_QUANTITY, p_RESERVED_QUANTITY),
304: RESERVATION_ID = decode( p_RESERVATION_ID, FND_API.G_MISS_NUM, RESERVATION_ID, p_RESERVATION_ID),
297: FREIGHT_TERMS_CODE = decode( p_FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR, FREIGHT_TERMS_CODE, p_FREIGHT_TERMS_CODE),
298: FREIGHT_CARRIER_CODE = decode( p_FREIGHT_CARRIER_CODE, FND_API.G_MISS_CHAR, FREIGHT_CARRIER_CODE, p_FREIGHT_CARRIER_CODE),
299: FOB_CODE = decode( p_FOB_CODE, FND_API.G_MISS_CHAR, FOB_CODE, p_FOB_CODE),
300: SHIPPING_INSTRUCTIONS = decode( p_SHIPPING_INSTRUCTIONS, FND_API.G_MISS_CHAR, SHIPPING_INSTRUCTIONS, p_SHIPPING_INSTRUCTIONS),
301: PACKING_INSTRUCTIONS = decode( p_PACKING_INSTRUCTIONS, FND_API.G_MISS_CHAR, PACKING_INSTRUCTIONS, p_PACKING_INSTRUCTIONS),
302: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
303: RESERVED_QUANTITY = decode( p_RESERVED_QUANTITY, FND_API.G_MISS_CHAR, RESERVED_QUANTITY, p_RESERVED_QUANTITY),
304: RESERVATION_ID = decode( p_RESERVATION_ID, FND_API.G_MISS_NUM, RESERVATION_ID, p_RESERVATION_ID),
305: ORDER_LINE_ID = decode( p_ORDER_LINE_ID, FND_API.G_MISS_NUM, ORDER_LINE_ID, p_ORDER_LINE_ID),
298: FREIGHT_CARRIER_CODE = decode( p_FREIGHT_CARRIER_CODE, FND_API.G_MISS_CHAR, FREIGHT_CARRIER_CODE, p_FREIGHT_CARRIER_CODE),
299: FOB_CODE = decode( p_FOB_CODE, FND_API.G_MISS_CHAR, FOB_CODE, p_FOB_CODE),
300: SHIPPING_INSTRUCTIONS = decode( p_SHIPPING_INSTRUCTIONS, FND_API.G_MISS_CHAR, SHIPPING_INSTRUCTIONS, p_SHIPPING_INSTRUCTIONS),
301: PACKING_INSTRUCTIONS = decode( p_PACKING_INSTRUCTIONS, FND_API.G_MISS_CHAR, PACKING_INSTRUCTIONS, p_PACKING_INSTRUCTIONS),
302: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
303: RESERVED_QUANTITY = decode( p_RESERVED_QUANTITY, FND_API.G_MISS_CHAR, RESERVED_QUANTITY, p_RESERVED_QUANTITY),
304: RESERVATION_ID = decode( p_RESERVATION_ID, FND_API.G_MISS_NUM, RESERVATION_ID, p_RESERVATION_ID),
305: ORDER_LINE_ID = decode( p_ORDER_LINE_ID, FND_API.G_MISS_NUM, ORDER_LINE_ID, p_ORDER_LINE_ID),
306: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
299: FOB_CODE = decode( p_FOB_CODE, FND_API.G_MISS_CHAR, FOB_CODE, p_FOB_CODE),
300: SHIPPING_INSTRUCTIONS = decode( p_SHIPPING_INSTRUCTIONS, FND_API.G_MISS_CHAR, SHIPPING_INSTRUCTIONS, p_SHIPPING_INSTRUCTIONS),
301: PACKING_INSTRUCTIONS = decode( p_PACKING_INSTRUCTIONS, FND_API.G_MISS_CHAR, PACKING_INSTRUCTIONS, p_PACKING_INSTRUCTIONS),
302: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
303: RESERVED_QUANTITY = decode( p_RESERVED_QUANTITY, FND_API.G_MISS_CHAR, RESERVED_QUANTITY, p_RESERVED_QUANTITY),
304: RESERVATION_ID = decode( p_RESERVATION_ID, FND_API.G_MISS_NUM, RESERVATION_ID, p_RESERVATION_ID),
305: ORDER_LINE_ID = decode( p_ORDER_LINE_ID, FND_API.G_MISS_NUM, ORDER_LINE_ID, p_ORDER_LINE_ID),
306: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
307: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
300: SHIPPING_INSTRUCTIONS = decode( p_SHIPPING_INSTRUCTIONS, FND_API.G_MISS_CHAR, SHIPPING_INSTRUCTIONS, p_SHIPPING_INSTRUCTIONS),
301: PACKING_INSTRUCTIONS = decode( p_PACKING_INSTRUCTIONS, FND_API.G_MISS_CHAR, PACKING_INSTRUCTIONS, p_PACKING_INSTRUCTIONS),
302: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
303: RESERVED_QUANTITY = decode( p_RESERVED_QUANTITY, FND_API.G_MISS_CHAR, RESERVED_QUANTITY, p_RESERVED_QUANTITY),
304: RESERVATION_ID = decode( p_RESERVATION_ID, FND_API.G_MISS_NUM, RESERVATION_ID, p_RESERVATION_ID),
305: ORDER_LINE_ID = decode( p_ORDER_LINE_ID, FND_API.G_MISS_NUM, ORDER_LINE_ID, p_ORDER_LINE_ID),
306: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
307: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
308: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
301: PACKING_INSTRUCTIONS = decode( p_PACKING_INSTRUCTIONS, FND_API.G_MISS_CHAR, PACKING_INSTRUCTIONS, p_PACKING_INSTRUCTIONS),
302: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
303: RESERVED_QUANTITY = decode( p_RESERVED_QUANTITY, FND_API.G_MISS_CHAR, RESERVED_QUANTITY, p_RESERVED_QUANTITY),
304: RESERVATION_ID = decode( p_RESERVATION_ID, FND_API.G_MISS_NUM, RESERVATION_ID, p_RESERVATION_ID),
305: ORDER_LINE_ID = decode( p_ORDER_LINE_ID, FND_API.G_MISS_NUM, ORDER_LINE_ID, p_ORDER_LINE_ID),
306: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
307: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
308: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
309: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
302: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
303: RESERVED_QUANTITY = decode( p_RESERVED_QUANTITY, FND_API.G_MISS_CHAR, RESERVED_QUANTITY, p_RESERVED_QUANTITY),
304: RESERVATION_ID = decode( p_RESERVATION_ID, FND_API.G_MISS_NUM, RESERVATION_ID, p_RESERVATION_ID),
305: ORDER_LINE_ID = decode( p_ORDER_LINE_ID, FND_API.G_MISS_NUM, ORDER_LINE_ID, p_ORDER_LINE_ID),
306: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
307: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
308: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
309: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
310: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
303: RESERVED_QUANTITY = decode( p_RESERVED_QUANTITY, FND_API.G_MISS_CHAR, RESERVED_QUANTITY, p_RESERVED_QUANTITY),
304: RESERVATION_ID = decode( p_RESERVATION_ID, FND_API.G_MISS_NUM, RESERVATION_ID, p_RESERVATION_ID),
305: ORDER_LINE_ID = decode( p_ORDER_LINE_ID, FND_API.G_MISS_NUM, ORDER_LINE_ID, p_ORDER_LINE_ID),
306: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
307: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
308: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
309: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
310: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
311: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
304: RESERVATION_ID = decode( p_RESERVATION_ID, FND_API.G_MISS_NUM, RESERVATION_ID, p_RESERVATION_ID),
305: ORDER_LINE_ID = decode( p_ORDER_LINE_ID, FND_API.G_MISS_NUM, ORDER_LINE_ID, p_ORDER_LINE_ID),
306: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
307: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
308: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
309: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
310: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
311: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
312: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
305: ORDER_LINE_ID = decode( p_ORDER_LINE_ID, FND_API.G_MISS_NUM, ORDER_LINE_ID, p_ORDER_LINE_ID),
306: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
307: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
308: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
309: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
310: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
311: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
312: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
313: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
306: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
307: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
308: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
309: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
310: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
311: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
312: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
313: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
314: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
307: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
308: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
309: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
310: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
311: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
312: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
313: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
314: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
315: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
308: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
309: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
310: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
311: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
312: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
313: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
314: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
315: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
316: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
309: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
310: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
311: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
312: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
313: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
314: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
315: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
316: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
317: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
310: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
311: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
312: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
313: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
314: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
315: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
316: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
317: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
318: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
311: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
312: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
313: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
314: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
315: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
316: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
317: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
318: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
319: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
312: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
313: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
314: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
315: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
316: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
317: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
318: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
319: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
320: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
313: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
314: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
315: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
316: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
317: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
318: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
319: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
320: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
321: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
314: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
315: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
316: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
317: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
318: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
319: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
320: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
321: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
322: ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16),
315: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
316: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
317: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
318: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
319: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
320: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
321: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
322: ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16),
323: ATTRIBUTE17 = decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, ATTRIBUTE17, p_ATTRIBUTE17),
316: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
317: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
318: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
319: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
320: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
321: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
322: ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16),
323: ATTRIBUTE17 = decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, ATTRIBUTE17, p_ATTRIBUTE17),
324: ATTRIBUTE18 = decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, ATTRIBUTE18, p_ATTRIBUTE18),
317: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
318: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
319: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
320: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
321: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
322: ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16),
323: ATTRIBUTE17 = decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, ATTRIBUTE17, p_ATTRIBUTE17),
324: ATTRIBUTE18 = decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, ATTRIBUTE18, p_ATTRIBUTE18),
325: ATTRIBUTE19 = decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, ATTRIBUTE19, p_ATTRIBUTE19),
318: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
319: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
320: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
321: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
322: ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16),
323: ATTRIBUTE17 = decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, ATTRIBUTE17, p_ATTRIBUTE17),
324: ATTRIBUTE18 = decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, ATTRIBUTE18, p_ATTRIBUTE18),
325: ATTRIBUTE19 = decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, ATTRIBUTE19, p_ATTRIBUTE19),
326: ATTRIBUTE20 = decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, ATTRIBUTE20, p_ATTRIBUTE20),
319: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
320: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
321: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
322: ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16),
323: ATTRIBUTE17 = decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, ATTRIBUTE17, p_ATTRIBUTE17),
324: ATTRIBUTE18 = decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, ATTRIBUTE18, p_ATTRIBUTE18),
325: ATTRIBUTE19 = decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, ATTRIBUTE19, p_ATTRIBUTE19),
326: ATTRIBUTE20 = decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, ATTRIBUTE20, p_ATTRIBUTE20),
327: SHIPMENT_PRIORITY_CODE = decode( p_SHIPMENT_PRIORITY_CODE, FND_API.G_MISS_CHAR, SHIPMENT_PRIORITY_CODE, p_SHIPMENT_PRIORITY_CODE),
320: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
321: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
322: ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16),
323: ATTRIBUTE17 = decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, ATTRIBUTE17, p_ATTRIBUTE17),
324: ATTRIBUTE18 = decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, ATTRIBUTE18, p_ATTRIBUTE18),
325: ATTRIBUTE19 = decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, ATTRIBUTE19, p_ATTRIBUTE19),
326: ATTRIBUTE20 = decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, ATTRIBUTE20, p_ATTRIBUTE20),
327: SHIPMENT_PRIORITY_CODE = decode( p_SHIPMENT_PRIORITY_CODE, FND_API.G_MISS_CHAR, SHIPMENT_PRIORITY_CODE, p_SHIPMENT_PRIORITY_CODE),
328: SHIP_QUOTE_PRICE = decode( p_SHIP_QUOTE_PRICE, FND_API.G_MISS_NUM, SHIP_QUOTE_PRICE, p_SHIP_QUOTE_PRICE),
321: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
322: ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16),
323: ATTRIBUTE17 = decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, ATTRIBUTE17, p_ATTRIBUTE17),
324: ATTRIBUTE18 = decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, ATTRIBUTE18, p_ATTRIBUTE18),
325: ATTRIBUTE19 = decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, ATTRIBUTE19, p_ATTRIBUTE19),
326: ATTRIBUTE20 = decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, ATTRIBUTE20, p_ATTRIBUTE20),
327: SHIPMENT_PRIORITY_CODE = decode( p_SHIPMENT_PRIORITY_CODE, FND_API.G_MISS_CHAR, SHIPMENT_PRIORITY_CODE, p_SHIPMENT_PRIORITY_CODE),
328: SHIP_QUOTE_PRICE = decode( p_SHIP_QUOTE_PRICE, FND_API.G_MISS_NUM, SHIP_QUOTE_PRICE, p_SHIP_QUOTE_PRICE),
329: SHIP_FROM_ORG_ID = decode( p_SHIP_FROM_ORG_ID, FND_API.G_MISS_NUM, SHIP_FROM_ORG_ID, p_SHIP_FROM_ORG_ID),
322: ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16),
323: ATTRIBUTE17 = decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, ATTRIBUTE17, p_ATTRIBUTE17),
324: ATTRIBUTE18 = decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, ATTRIBUTE18, p_ATTRIBUTE18),
325: ATTRIBUTE19 = decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, ATTRIBUTE19, p_ATTRIBUTE19),
326: ATTRIBUTE20 = decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, ATTRIBUTE20, p_ATTRIBUTE20),
327: SHIPMENT_PRIORITY_CODE = decode( p_SHIPMENT_PRIORITY_CODE, FND_API.G_MISS_CHAR, SHIPMENT_PRIORITY_CODE, p_SHIPMENT_PRIORITY_CODE),
328: SHIP_QUOTE_PRICE = decode( p_SHIP_QUOTE_PRICE, FND_API.G_MISS_NUM, SHIP_QUOTE_PRICE, p_SHIP_QUOTE_PRICE),
329: SHIP_FROM_ORG_ID = decode( p_SHIP_FROM_ORG_ID, FND_API.G_MISS_NUM, SHIP_FROM_ORG_ID, p_SHIP_FROM_ORG_ID),
330: SHIP_TO_CUST_PARTY_ID = decode( p_SHIP_TO_CUST_PARTY_ID, FND_API.G_MISS_NUM, SHIP_TO_CUST_PARTY_ID, p_SHIP_TO_CUST_PARTY_ID),
323: ATTRIBUTE17 = decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, ATTRIBUTE17, p_ATTRIBUTE17),
324: ATTRIBUTE18 = decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, ATTRIBUTE18, p_ATTRIBUTE18),
325: ATTRIBUTE19 = decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, ATTRIBUTE19, p_ATTRIBUTE19),
326: ATTRIBUTE20 = decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, ATTRIBUTE20, p_ATTRIBUTE20),
327: SHIPMENT_PRIORITY_CODE = decode( p_SHIPMENT_PRIORITY_CODE, FND_API.G_MISS_CHAR, SHIPMENT_PRIORITY_CODE, p_SHIPMENT_PRIORITY_CODE),
328: SHIP_QUOTE_PRICE = decode( p_SHIP_QUOTE_PRICE, FND_API.G_MISS_NUM, SHIP_QUOTE_PRICE, p_SHIP_QUOTE_PRICE),
329: SHIP_FROM_ORG_ID = decode( p_SHIP_FROM_ORG_ID, FND_API.G_MISS_NUM, SHIP_FROM_ORG_ID, p_SHIP_FROM_ORG_ID),
330: SHIP_TO_CUST_PARTY_ID = decode( p_SHIP_TO_CUST_PARTY_ID, FND_API.G_MISS_NUM, SHIP_TO_CUST_PARTY_ID, p_SHIP_TO_CUST_PARTY_ID),
331: SHIP_METHOD_CODE_FROM = decode( p_SHIP_METHOD_CODE_FROM, FND_API.G_MISS_CHAR, SHIP_METHOD_CODE_FROM, p_SHIP_METHOD_CODE_FROM),
324: ATTRIBUTE18 = decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, ATTRIBUTE18, p_ATTRIBUTE18),
325: ATTRIBUTE19 = decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, ATTRIBUTE19, p_ATTRIBUTE19),
326: ATTRIBUTE20 = decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, ATTRIBUTE20, p_ATTRIBUTE20),
327: SHIPMENT_PRIORITY_CODE = decode( p_SHIPMENT_PRIORITY_CODE, FND_API.G_MISS_CHAR, SHIPMENT_PRIORITY_CODE, p_SHIPMENT_PRIORITY_CODE),
328: SHIP_QUOTE_PRICE = decode( p_SHIP_QUOTE_PRICE, FND_API.G_MISS_NUM, SHIP_QUOTE_PRICE, p_SHIP_QUOTE_PRICE),
329: SHIP_FROM_ORG_ID = decode( p_SHIP_FROM_ORG_ID, FND_API.G_MISS_NUM, SHIP_FROM_ORG_ID, p_SHIP_FROM_ORG_ID),
330: SHIP_TO_CUST_PARTY_ID = decode( p_SHIP_TO_CUST_PARTY_ID, FND_API.G_MISS_NUM, SHIP_TO_CUST_PARTY_ID, p_SHIP_TO_CUST_PARTY_ID),
331: SHIP_METHOD_CODE_FROM = decode( p_SHIP_METHOD_CODE_FROM, FND_API.G_MISS_CHAR, SHIP_METHOD_CODE_FROM, p_SHIP_METHOD_CODE_FROM),
332: FREIGHT_TERMS_CODE_FROM = decode( p_FREIGHT_TERMS_CODE_FROM, FND_API.G_MISS_CHAR, FREIGHT_TERMS_CODE_FROM, p_FREIGHT_TERMS_CODE_FROM),
325: ATTRIBUTE19 = decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, ATTRIBUTE19, p_ATTRIBUTE19),
326: ATTRIBUTE20 = decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, ATTRIBUTE20, p_ATTRIBUTE20),
327: SHIPMENT_PRIORITY_CODE = decode( p_SHIPMENT_PRIORITY_CODE, FND_API.G_MISS_CHAR, SHIPMENT_PRIORITY_CODE, p_SHIPMENT_PRIORITY_CODE),
328: SHIP_QUOTE_PRICE = decode( p_SHIP_QUOTE_PRICE, FND_API.G_MISS_NUM, SHIP_QUOTE_PRICE, p_SHIP_QUOTE_PRICE),
329: SHIP_FROM_ORG_ID = decode( p_SHIP_FROM_ORG_ID, FND_API.G_MISS_NUM, SHIP_FROM_ORG_ID, p_SHIP_FROM_ORG_ID),
330: SHIP_TO_CUST_PARTY_ID = decode( p_SHIP_TO_CUST_PARTY_ID, FND_API.G_MISS_NUM, SHIP_TO_CUST_PARTY_ID, p_SHIP_TO_CUST_PARTY_ID),
331: SHIP_METHOD_CODE_FROM = decode( p_SHIP_METHOD_CODE_FROM, FND_API.G_MISS_CHAR, SHIP_METHOD_CODE_FROM, p_SHIP_METHOD_CODE_FROM),
332: FREIGHT_TERMS_CODE_FROM = decode( p_FREIGHT_TERMS_CODE_FROM, FND_API.G_MISS_CHAR, FREIGHT_TERMS_CODE_FROM, p_FREIGHT_TERMS_CODE_FROM),
333: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, nvl(OBJECT_VERSION_NUMBER,0)+1, nvl(p_OBJECT_VERSION_NUMBER, nvl(OBJECT_VERSION_NUMBER,0))+1),
326: ATTRIBUTE20 = decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, ATTRIBUTE20, p_ATTRIBUTE20),
327: SHIPMENT_PRIORITY_CODE = decode( p_SHIPMENT_PRIORITY_CODE, FND_API.G_MISS_CHAR, SHIPMENT_PRIORITY_CODE, p_SHIPMENT_PRIORITY_CODE),
328: SHIP_QUOTE_PRICE = decode( p_SHIP_QUOTE_PRICE, FND_API.G_MISS_NUM, SHIP_QUOTE_PRICE, p_SHIP_QUOTE_PRICE),
329: SHIP_FROM_ORG_ID = decode( p_SHIP_FROM_ORG_ID, FND_API.G_MISS_NUM, SHIP_FROM_ORG_ID, p_SHIP_FROM_ORG_ID),
330: SHIP_TO_CUST_PARTY_ID = decode( p_SHIP_TO_CUST_PARTY_ID, FND_API.G_MISS_NUM, SHIP_TO_CUST_PARTY_ID, p_SHIP_TO_CUST_PARTY_ID),
331: SHIP_METHOD_CODE_FROM = decode( p_SHIP_METHOD_CODE_FROM, FND_API.G_MISS_CHAR, SHIP_METHOD_CODE_FROM, p_SHIP_METHOD_CODE_FROM),
332: FREIGHT_TERMS_CODE_FROM = decode( p_FREIGHT_TERMS_CODE_FROM, FND_API.G_MISS_CHAR, FREIGHT_TERMS_CODE_FROM, p_FREIGHT_TERMS_CODE_FROM),
333: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, nvl(OBJECT_VERSION_NUMBER,0)+1, nvl(p_OBJECT_VERSION_NUMBER, nvl(OBJECT_VERSION_NUMBER,0))+1),
334:
327: SHIPMENT_PRIORITY_CODE = decode( p_SHIPMENT_PRIORITY_CODE, FND_API.G_MISS_CHAR, SHIPMENT_PRIORITY_CODE, p_SHIPMENT_PRIORITY_CODE),
328: SHIP_QUOTE_PRICE = decode( p_SHIP_QUOTE_PRICE, FND_API.G_MISS_NUM, SHIP_QUOTE_PRICE, p_SHIP_QUOTE_PRICE),
329: SHIP_FROM_ORG_ID = decode( p_SHIP_FROM_ORG_ID, FND_API.G_MISS_NUM, SHIP_FROM_ORG_ID, p_SHIP_FROM_ORG_ID),
330: SHIP_TO_CUST_PARTY_ID = decode( p_SHIP_TO_CUST_PARTY_ID, FND_API.G_MISS_NUM, SHIP_TO_CUST_PARTY_ID, p_SHIP_TO_CUST_PARTY_ID),
331: SHIP_METHOD_CODE_FROM = decode( p_SHIP_METHOD_CODE_FROM, FND_API.G_MISS_CHAR, SHIP_METHOD_CODE_FROM, p_SHIP_METHOD_CODE_FROM),
332: FREIGHT_TERMS_CODE_FROM = decode( p_FREIGHT_TERMS_CODE_FROM, FND_API.G_MISS_CHAR, FREIGHT_TERMS_CODE_FROM, p_FREIGHT_TERMS_CODE_FROM),
333: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, nvl(OBJECT_VERSION_NUMBER,0)+1, nvl(p_OBJECT_VERSION_NUMBER, nvl(OBJECT_VERSION_NUMBER,0))+1),
334:
335: REQUEST_DATE_TYPE = decode( p_REQUEST_DATE_TYPE, FND_API.G_MISS_CHAR, REQUEST_DATE_TYPE, p_REQUEST_DATE_TYPE),
328: SHIP_QUOTE_PRICE = decode( p_SHIP_QUOTE_PRICE, FND_API.G_MISS_NUM, SHIP_QUOTE_PRICE, p_SHIP_QUOTE_PRICE),
329: SHIP_FROM_ORG_ID = decode( p_SHIP_FROM_ORG_ID, FND_API.G_MISS_NUM, SHIP_FROM_ORG_ID, p_SHIP_FROM_ORG_ID),
330: SHIP_TO_CUST_PARTY_ID = decode( p_SHIP_TO_CUST_PARTY_ID, FND_API.G_MISS_NUM, SHIP_TO_CUST_PARTY_ID, p_SHIP_TO_CUST_PARTY_ID),
331: SHIP_METHOD_CODE_FROM = decode( p_SHIP_METHOD_CODE_FROM, FND_API.G_MISS_CHAR, SHIP_METHOD_CODE_FROM, p_SHIP_METHOD_CODE_FROM),
332: FREIGHT_TERMS_CODE_FROM = decode( p_FREIGHT_TERMS_CODE_FROM, FND_API.G_MISS_CHAR, FREIGHT_TERMS_CODE_FROM, p_FREIGHT_TERMS_CODE_FROM),
333: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, nvl(OBJECT_VERSION_NUMBER,0)+1, nvl(p_OBJECT_VERSION_NUMBER, nvl(OBJECT_VERSION_NUMBER,0))+1),
334:
335: REQUEST_DATE_TYPE = decode( p_REQUEST_DATE_TYPE, FND_API.G_MISS_CHAR, REQUEST_DATE_TYPE, p_REQUEST_DATE_TYPE),
336: DEMAND_CLASS_CODE = decode( p_DEMAND_CLASS_CODE, FND_API.G_MISS_CHAR, DEMAND_CLASS_CODE, p_DEMAND_CLASS_CODE)
329: SHIP_FROM_ORG_ID = decode( p_SHIP_FROM_ORG_ID, FND_API.G_MISS_NUM, SHIP_FROM_ORG_ID, p_SHIP_FROM_ORG_ID),
330: SHIP_TO_CUST_PARTY_ID = decode( p_SHIP_TO_CUST_PARTY_ID, FND_API.G_MISS_NUM, SHIP_TO_CUST_PARTY_ID, p_SHIP_TO_CUST_PARTY_ID),
331: SHIP_METHOD_CODE_FROM = decode( p_SHIP_METHOD_CODE_FROM, FND_API.G_MISS_CHAR, SHIP_METHOD_CODE_FROM, p_SHIP_METHOD_CODE_FROM),
332: FREIGHT_TERMS_CODE_FROM = decode( p_FREIGHT_TERMS_CODE_FROM, FND_API.G_MISS_CHAR, FREIGHT_TERMS_CODE_FROM, p_FREIGHT_TERMS_CODE_FROM),
333: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, nvl(OBJECT_VERSION_NUMBER,0)+1, nvl(p_OBJECT_VERSION_NUMBER, nvl(OBJECT_VERSION_NUMBER,0))+1),
334:
335: REQUEST_DATE_TYPE = decode( p_REQUEST_DATE_TYPE, FND_API.G_MISS_CHAR, REQUEST_DATE_TYPE, p_REQUEST_DATE_TYPE),
336: DEMAND_CLASS_CODE = decode( p_DEMAND_CLASS_CODE, FND_API.G_MISS_CHAR, DEMAND_CLASS_CODE, p_DEMAND_CLASS_CODE)
337:
331: SHIP_METHOD_CODE_FROM = decode( p_SHIP_METHOD_CODE_FROM, FND_API.G_MISS_CHAR, SHIP_METHOD_CODE_FROM, p_SHIP_METHOD_CODE_FROM),
332: FREIGHT_TERMS_CODE_FROM = decode( p_FREIGHT_TERMS_CODE_FROM, FND_API.G_MISS_CHAR, FREIGHT_TERMS_CODE_FROM, p_FREIGHT_TERMS_CODE_FROM),
333: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, nvl(OBJECT_VERSION_NUMBER,0)+1, nvl(p_OBJECT_VERSION_NUMBER, nvl(OBJECT_VERSION_NUMBER,0))+1),
334:
335: REQUEST_DATE_TYPE = decode( p_REQUEST_DATE_TYPE, FND_API.G_MISS_CHAR, REQUEST_DATE_TYPE, p_REQUEST_DATE_TYPE),
336: DEMAND_CLASS_CODE = decode( p_DEMAND_CLASS_CODE, FND_API.G_MISS_CHAR, DEMAND_CLASS_CODE, p_DEMAND_CLASS_CODE)
337:
338: where SHIPMENT_ID = p_SHIPMENT_ID;
339:
332: FREIGHT_TERMS_CODE_FROM = decode( p_FREIGHT_TERMS_CODE_FROM, FND_API.G_MISS_CHAR, FREIGHT_TERMS_CODE_FROM, p_FREIGHT_TERMS_CODE_FROM),
333: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, nvl(OBJECT_VERSION_NUMBER,0)+1, nvl(p_OBJECT_VERSION_NUMBER, nvl(OBJECT_VERSION_NUMBER,0))+1),
334:
335: REQUEST_DATE_TYPE = decode( p_REQUEST_DATE_TYPE, FND_API.G_MISS_CHAR, REQUEST_DATE_TYPE, p_REQUEST_DATE_TYPE),
336: DEMAND_CLASS_CODE = decode( p_DEMAND_CLASS_CODE, FND_API.G_MISS_CHAR, DEMAND_CLASS_CODE, p_DEMAND_CLASS_CODE)
337:
338: where SHIPMENT_ID = p_SHIPMENT_ID;
339:
340: If (SQL%NOTFOUND) then