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

APPS.ASO_SHIPMENTS_PKG dependencies on ASO_UTILITY_PVT

Line 148: ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),

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

Line 150: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),

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

Line 156: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_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),

Line 159: ASO_UTILITY_PVT.decode( p_PROMISE_DATE, FND_API.G_MISS_DATE, NULL, p_PROMISE_DATE),

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

Line 160: ASO_UTILITY_PVT.decode( p_REQUEST_DATE, FND_API.G_MISS_DATE, NULL, p_REQUEST_DATE),

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

Line 161: ASO_UTILITY_PVT.decode( p_SCHEDULE_SHIP_DATE, FND_API.G_MISS_DATE, NULL, p_SCHEDULE_SHIP_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),
165: decode( p_SHIP_PARTIAL_FLAG, FND_API.G_MISS_CHAR, NULL, p_SHIP_PARTIAL_FLAG),

Line 277: /* CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),

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

Line 279: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

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

Line 285: PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_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),

Line 288: PROMISE_DATE = ASO_UTILITY_PVT.decode( p_PROMISE_DATE, FND_API.G_MISS_DATE, PROMISE_DATE, p_PROMISE_DATE),

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

Line 289: REQUEST_DATE = ASO_UTILITY_PVT.decode( p_REQUEST_DATE, FND_API.G_MISS_DATE, REQUEST_DATE, p_REQUEST_DATE),

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

Line 290: SCHEDULE_SHIP_DATE = ASO_UTILITY_PVT.decode( p_SCHEDULE_SHIP_DATE, FND_API.G_MISS_DATE, SCHEDULE_SHIP_DATE, p_SCHEDULE_SHIP_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),
294: SHIP_PARTIAL_FLAG = decode( p_SHIP_PARTIAL_FLAG, FND_API.G_MISS_CHAR, SHIP_PARTIAL_FLAG, p_SHIP_PARTIAL_FLAG),