DBA Data[Home] [Help]

APPS.ASO_SUP_TEMPLATE_PKG dependencies on ASO_UTILITY_PVT

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

204: -- added new column as per bug 2940126
205: update ASO_SUP_TEMPLATE_B
206: set
207: last_updated_by = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
208: last_update_date = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
209: last_update_login = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
210: template_level = decode(P_TEMPLATE_LEVEL,FND_API.G_MISS_CHAR, template_level,P_TEMPLATE_LEVEL),
211: template_context = decode(P_TEMPLATE_CONTEXT,FND_API.G_MISS_CHAR,template_context,P_TEMPLATE_CONTEXT),
212: context = decode(P_context,FND_API.G_MISS_CHAR,context,P_context),

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

239: update ASO_SUP_TEMPLATE_TL
240: set
241: TEMPLATE_NAME = decode(P_TEMPLATE_NAME,FND_API.G_MISS_CHAR,template_name,P_TEMPLATE_NAME),
242: DESCRIPTION = decode(P_DESCRIPTION,FND_API.G_MISS_CHAR,description,P_DESCRIPTION),
243: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
244: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
245: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
246: SOURCE_LANG = userenv('LANG')
247: where TEMPLATE_ID = P_TEMPLATE_ID