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_QUOTE_STATUS_PKG dependencies on ASO_UTILITY_PVT

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

111: ATTRIBUTE19,
112: ATTRIBUTE20
113: ) VALUES (
114: px_QUOTE_STATUS_ID,
115: ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
116: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
117: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
118: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
119: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),

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

114: px_QUOTE_STATUS_ID,
115: ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
116: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
117: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
118: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
119: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
120: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
121: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
122: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),

Line 123: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),

119: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
120: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
121: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
122: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
123: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),
124: decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
125: decode( p_UPDATE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL, p_UPDATE_ALLOWED_FLAG),
126: decode( p_AUTO_VERSION_FLAG, FND_API.G_MISS_CHAR, NULL, p_AUTO_VERSION_FLAG),
127: decode( p_USER_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_USER_MAINTAINABLE_FLAG),

Line 128: ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_START_DATE), FND_API.G_MISS_DATE, NULL, trunc(p_EFFECTIVE_START_DATE)),

124: decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
125: decode( p_UPDATE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL, p_UPDATE_ALLOWED_FLAG),
126: decode( p_AUTO_VERSION_FLAG, FND_API.G_MISS_CHAR, NULL, p_AUTO_VERSION_FLAG),
127: decode( p_USER_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_USER_MAINTAINABLE_FLAG),
128: ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_START_DATE), FND_API.G_MISS_DATE, NULL, trunc(p_EFFECTIVE_START_DATE)),
129: ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_END_DATE), FND_API.G_MISS_DATE, NULL, trunc(p_EFFECTIVE_END_DATE)),
130: decode( p_ALLOW_LOV_TO_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_LOV_TO_FLAG),
131: decode( p_ALLOW_LOV_FROM_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_LOV_FROM_FLAG),
132: decode( p_ALLOW_NEW_TO_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_NEW_TO_FLAG),

Line 129: ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_END_DATE), FND_API.G_MISS_DATE, NULL, trunc(p_EFFECTIVE_END_DATE)),

125: decode( p_UPDATE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL, p_UPDATE_ALLOWED_FLAG),
126: decode( p_AUTO_VERSION_FLAG, FND_API.G_MISS_CHAR, NULL, p_AUTO_VERSION_FLAG),
127: decode( p_USER_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_USER_MAINTAINABLE_FLAG),
128: ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_START_DATE), FND_API.G_MISS_DATE, NULL, trunc(p_EFFECTIVE_START_DATE)),
129: ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_END_DATE), FND_API.G_MISS_DATE, NULL, trunc(p_EFFECTIVE_END_DATE)),
130: decode( p_ALLOW_LOV_TO_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_LOV_TO_FLAG),
131: decode( p_ALLOW_LOV_FROM_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_LOV_FROM_FLAG),
132: decode( p_ALLOW_NEW_TO_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_NEW_TO_FLAG),
133: decode( p_ALLOW_NEW_FROM_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_NEW_FROM_FLAG),

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

172: LANGUAGE,
173: SOURCE_LANG
174: ) select
175: px_QUOTE_STATUS_ID,
176: ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
177: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
178: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
179: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
180: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),

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

175: px_QUOTE_STATUS_ID,
176: ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
177: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
178: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
179: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
180: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
181: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
182: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
183: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),

Line 184: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),

180: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
181: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
182: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
183: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
184: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),
185: decode( p_meaning, FND_API.G_MISS_CHAR, NULL, p_meaning),
186: decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description),
187: L.LANGUAGE_CODE,
188: userenv('LANG')

Line 247: CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),

243: IS
244: BEGIN
245: Update ASO_QUOTE_STATUSES_B
246: SET
247: CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
248: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
249: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
250: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
251: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),

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

246: SET
247: CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
248: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
249: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
250: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
251: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
252: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
253: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
254: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),

Line 255: PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),

251: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
252: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
253: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
254: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
255: PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
256: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),
257: UPDATE_ALLOWED_FLAG = decode( p_UPDATE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, UPDATE_ALLOWED_FLAG, p_UPDATE_ALLOWED_FLAG),
258: AUTO_VERSION_FLAG = decode( p_AUTO_VERSION_FLAG, FND_API.G_MISS_CHAR, AUTO_VERSION_FLAG, p_AUTO_VERSION_FLAG),
259: USER_MAINTAINABLE_FLAG = decode( p_USER_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, USER_MAINTAINABLE_FLAG, p_USER_MAINTAINABLE_FLAG),

Line 260: EFFECTIVE_START_DATE = ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_START_DATE), FND_API.G_MISS_DATE, EFFECTIVE_START_DATE, trunc(p_EFFECTIVE_START_DATE)),

256: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),
257: UPDATE_ALLOWED_FLAG = decode( p_UPDATE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, UPDATE_ALLOWED_FLAG, p_UPDATE_ALLOWED_FLAG),
258: AUTO_VERSION_FLAG = decode( p_AUTO_VERSION_FLAG, FND_API.G_MISS_CHAR, AUTO_VERSION_FLAG, p_AUTO_VERSION_FLAG),
259: USER_MAINTAINABLE_FLAG = decode( p_USER_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, USER_MAINTAINABLE_FLAG, p_USER_MAINTAINABLE_FLAG),
260: EFFECTIVE_START_DATE = ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_START_DATE), FND_API.G_MISS_DATE, EFFECTIVE_START_DATE, trunc(p_EFFECTIVE_START_DATE)),
261:
262: EFFECTIVE_END_DATE = ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_END_DATE), FND_API.G_MISS_DATE, EFFECTIVE_END_DATE,trunc(p_EFFECTIVE_END_DATE)),
263: ALLOW_LOV_TO_FLAG = decode( p_ALLOW_LOV_TO_FLAG, FND_API.G_MISS_CHAR, ALLOW_LOV_TO_FLAG, p_ALLOW_LOV_TO_FLAG),
264: ALLOW_LOV_FROM_FLAG = decode( p_ALLOW_LOV_FROM_FLAG, FND_API.G_MISS_CHAR, ALLOW_LOV_FROM_FLAG, p_ALLOW_LOV_FROM_FLAG),

Line 262: EFFECTIVE_END_DATE = ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_END_DATE), FND_API.G_MISS_DATE, EFFECTIVE_END_DATE,trunc(p_EFFECTIVE_END_DATE)),

258: AUTO_VERSION_FLAG = decode( p_AUTO_VERSION_FLAG, FND_API.G_MISS_CHAR, AUTO_VERSION_FLAG, p_AUTO_VERSION_FLAG),
259: USER_MAINTAINABLE_FLAG = decode( p_USER_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, USER_MAINTAINABLE_FLAG, p_USER_MAINTAINABLE_FLAG),
260: EFFECTIVE_START_DATE = ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_START_DATE), FND_API.G_MISS_DATE, EFFECTIVE_START_DATE, trunc(p_EFFECTIVE_START_DATE)),
261:
262: EFFECTIVE_END_DATE = ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_END_DATE), FND_API.G_MISS_DATE, EFFECTIVE_END_DATE,trunc(p_EFFECTIVE_END_DATE)),
263: ALLOW_LOV_TO_FLAG = decode( p_ALLOW_LOV_TO_FLAG, FND_API.G_MISS_CHAR, ALLOW_LOV_TO_FLAG, p_ALLOW_LOV_TO_FLAG),
264: ALLOW_LOV_FROM_FLAG = decode( p_ALLOW_LOV_FROM_FLAG, FND_API.G_MISS_CHAR, ALLOW_LOV_FROM_FLAG, p_ALLOW_LOV_FROM_FLAG),
265: ALLOW_NEW_TO_FLAG = decode( p_ALLOW_NEW_TO_FLAG, FND_API.G_MISS_CHAR, ALLOW_NEW_TO_FLAG, p_ALLOW_NEW_TO_FLAG),
266: ALLOW_NEW_FROM_FLAG = decode( p_ALLOW_NEW_FROM_FLAG, FND_API.G_MISS_CHAR, ALLOW_NEW_FROM_FLAG, p_ALLOW_NEW_FROM_FLAG),

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

296: update ASO_QUOTE_STATUSES_TL set
297: MEANING = decode( p_MEANING, FND_API.G_MISS_CHAR, meaning, p_MEANING),
298: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, meaning, p_DESCRIPTION),
299: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
300: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
301: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
302: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
303: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
304: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),

Line 305: PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),

301: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
302: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
303: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
304: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
305: PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
306: SOURCE_LANG = userenv('LANG')
307: where QUOTE_STATUS_ID = P_QUOTE_STATUS_ID
308: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
309: