DBA Data[Home] [Help]

APPS.ASO_TAX_DETAILS_PKG dependencies on ASO_UTILITY_PVT

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

116: OBJECT_VERSION_NUMBER,
117: TAX_RATE_ID
118: ) VALUES (
119: px_TAX_DETAIL_ID,
120: ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
121: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
122: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
123: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
124: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),

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

118: ) VALUES (
119: px_TAX_DETAIL_ID,
120: ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
121: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
122: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
123: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
124: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
125: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
126: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),

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

124: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
125: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
126: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
127: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
128: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),
129: decode( p_QUOTE_HEADER_ID, FND_API.G_MISS_NUM, NULL, p_QUOTE_HEADER_ID),
130: decode( p_QUOTE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_QUOTE_LINE_ID),
131: decode( p_QUOTE_SHIPMENT_ID, FND_API.G_MISS_NUM, NULL, p_QUOTE_SHIPMENT_ID),
132: decode( p_ORIG_TAX_CODE, FND_API.G_MISS_CHAR, NULL, p_ORIG_TAX_CODE),

Line 135: ASO_UTILITY_PVT.decode( p_TAX_DATE, FND_API.G_MISS_DATE, NULL, p_TAX_DATE),

131: decode( p_QUOTE_SHIPMENT_ID, FND_API.G_MISS_NUM, NULL, p_QUOTE_SHIPMENT_ID),
132: decode( p_ORIG_TAX_CODE, FND_API.G_MISS_CHAR, NULL, p_ORIG_TAX_CODE),
133: decode( p_TAX_CODE, FND_API.G_MISS_CHAR, NULL, p_TAX_CODE),
134: decode( p_TAX_RATE, FND_API.G_MISS_NUM, NULL, p_TAX_RATE),
135: ASO_UTILITY_PVT.decode( p_TAX_DATE, FND_API.G_MISS_DATE, NULL, p_TAX_DATE),
136: decode( p_TAX_AMOUNT, FND_API.G_MISS_NUM, NULL, p_TAX_AMOUNT),
137: decode( p_TAX_EXEMPT_FLAG, FND_API.G_MISS_CHAR, NULL, p_TAX_EXEMPT_FLAG),
138: decode( p_TAX_EXEMPT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_TAX_EXEMPT_NUMBER),
139: decode( p_TAX_EXEMPT_REASON_CODE, FND_API.G_MISS_CHAR, NULL, p_TAX_EXEMPT_REASON_CODE),

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

215: IS
216: BEGIN
217: Update ASO_TAX_DETAILS
218: SET
219: /* CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
220: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),*/
221: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
222: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
223: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),

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

217: Update ASO_TAX_DETAILS
218: SET
219: /* CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
220: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),*/
221: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
222: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
223: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
224: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
225: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),

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

223: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
224: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
225: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
226: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
227: PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
228: QUOTE_HEADER_ID = decode( p_QUOTE_HEADER_ID, FND_API.G_MISS_NUM, QUOTE_HEADER_ID, p_QUOTE_HEADER_ID),
229: QUOTE_LINE_ID = decode( p_QUOTE_LINE_ID, FND_API.G_MISS_NUM, QUOTE_LINE_ID, p_QUOTE_LINE_ID),
230: QUOTE_SHIPMENT_ID = decode( p_QUOTE_SHIPMENT_ID, FND_API.G_MISS_NUM, QUOTE_SHIPMENT_ID, p_QUOTE_SHIPMENT_ID),
231: ORIG_TAX_CODE = decode( p_ORIG_TAX_CODE, FND_API.G_MISS_CHAR, ORIG_TAX_CODE, p_ORIG_TAX_CODE),

Line 234: TAX_DATE = ASO_UTILITY_PVT.decode( p_TAX_DATE, FND_API.G_MISS_DATE, TAX_DATE, p_TAX_DATE),

230: QUOTE_SHIPMENT_ID = decode( p_QUOTE_SHIPMENT_ID, FND_API.G_MISS_NUM, QUOTE_SHIPMENT_ID, p_QUOTE_SHIPMENT_ID),
231: ORIG_TAX_CODE = decode( p_ORIG_TAX_CODE, FND_API.G_MISS_CHAR, ORIG_TAX_CODE, p_ORIG_TAX_CODE),
232: TAX_CODE = decode( p_TAX_CODE, FND_API.G_MISS_CHAR, TAX_CODE, p_TAX_CODE),
233: TAX_RATE = decode( p_TAX_RATE, FND_API.G_MISS_NUM, TAX_RATE, p_TAX_RATE),
234: TAX_DATE = ASO_UTILITY_PVT.decode( p_TAX_DATE, FND_API.G_MISS_DATE, TAX_DATE, p_TAX_DATE),
235: TAX_AMOUNT = decode( p_TAX_AMOUNT, FND_API.G_MISS_NUM, TAX_AMOUNT, p_TAX_AMOUNT),
236: TAX_EXEMPT_FLAG = decode( p_TAX_EXEMPT_FLAG, FND_API.G_MISS_CHAR, TAX_EXEMPT_FLAG, p_TAX_EXEMPT_FLAG),
237: TAX_EXEMPT_NUMBER = decode( p_TAX_EXEMPT_NUMBER, FND_API.G_MISS_CHAR, TAX_EXEMPT_NUMBER, p_TAX_EXEMPT_NUMBER),
238: TAX_EXEMPT_REASON_CODE = decode( p_TAX_EXEMPT_REASON_CODE, FND_API.G_MISS_CHAR, TAX_EXEMPT_REASON_CODE, p_TAX_EXEMPT_REASON_CODE),