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

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

246: HEADER_PAYNOW_CHARGES
247:
248: ) VALUES (
249: px_QUOTE_HEADER_ID,
250: ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
251: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
252: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
253: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
254: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),

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

248: ) VALUES (
249: px_QUOTE_HEADER_ID,
250: ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
251: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
252: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
253: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
254: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
255: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
256: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),

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

254: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
255: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
256: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
257: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
258: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),
259: decode( p_ORG_ID, FND_API.G_MISS_NUM, NULL, p_ORG_ID),
260: decode( p_QUOTE_NAME, FND_API.G_MISS_CHAR, NULL, p_QUOTE_NAME),
261: decode( p_QUOTE_NUMBER, FND_API.G_MISS_NUM, NULL, p_QUOTE_NUMBER),
262: decode( p_QUOTE_VERSION, FND_API.G_MISS_NUM, NULL, p_QUOTE_VERSION),

Line 265: ASO_UTILITY_PVT.decode( p_QUOTE_EXPIRATION_DATE, FND_API.G_MISS_DATE, NULL, p_QUOTE_EXPIRATION_DATE),

261: decode( p_QUOTE_NUMBER, FND_API.G_MISS_NUM, NULL, p_QUOTE_NUMBER),
262: decode( p_QUOTE_VERSION, FND_API.G_MISS_NUM, NULL, p_QUOTE_VERSION),
263: decode( p_QUOTE_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_QUOTE_STATUS_ID),
264: decode( p_QUOTE_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_QUOTE_SOURCE_CODE),
265: ASO_UTILITY_PVT.decode( p_QUOTE_EXPIRATION_DATE, FND_API.G_MISS_DATE, NULL, p_QUOTE_EXPIRATION_DATE),
266: ASO_UTILITY_PVT.decode( p_PRICE_FROZEN_DATE, FND_API.G_MISS_DATE, NULL, p_PRICE_FROZEN_DATE),
267: decode( p_QUOTE_PASSWORD, FND_API.G_MISS_CHAR, NULL, p_QUOTE_PASSWORD),
268: decode( p_ORIGINAL_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_ORIGINAL_SYSTEM_REFERENCE),
269: decode( p_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_PARTY_ID),

Line 266: ASO_UTILITY_PVT.decode( p_PRICE_FROZEN_DATE, FND_API.G_MISS_DATE, NULL, p_PRICE_FROZEN_DATE),

262: decode( p_QUOTE_VERSION, FND_API.G_MISS_NUM, NULL, p_QUOTE_VERSION),
263: decode( p_QUOTE_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_QUOTE_STATUS_ID),
264: decode( p_QUOTE_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_QUOTE_SOURCE_CODE),
265: ASO_UTILITY_PVT.decode( p_QUOTE_EXPIRATION_DATE, FND_API.G_MISS_DATE, NULL, p_QUOTE_EXPIRATION_DATE),
266: ASO_UTILITY_PVT.decode( p_PRICE_FROZEN_DATE, FND_API.G_MISS_DATE, NULL, p_PRICE_FROZEN_DATE),
267: decode( p_QUOTE_PASSWORD, FND_API.G_MISS_CHAR, NULL, p_QUOTE_PASSWORD),
268: decode( p_ORIGINAL_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_ORIGINAL_SYSTEM_REFERENCE),
269: decode( p_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_PARTY_ID),
270: decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_CUST_ACCOUNT_ID),

Line 280: ASO_UTILITY_PVT.decode( p_ORDERED_DATE, FND_API.G_MISS_DATE, NULL, p_ORDERED_DATE),

276: decode( p_ORIG_MKTG_SOURCE_CODE_ID, FND_API.G_MISS_NUM, NULL, p_ORIG_MKTG_SOURCE_CODE_ID),
277: decode( p_MARKETING_SOURCE_CODE_ID, FND_API.G_MISS_NUM, NULL, p_MARKETING_SOURCE_CODE_ID),
278: decode( p_ORDER_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_ORDER_TYPE_ID),
279: decode( p_QUOTE_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, p_QUOTE_CATEGORY_CODE),
280: ASO_UTILITY_PVT.decode( p_ORDERED_DATE, FND_API.G_MISS_DATE, NULL, p_ORDERED_DATE),
281: decode( p_ACCOUNTING_RULE_ID, FND_API.G_MISS_NUM, NULL, p_ACCOUNTING_RULE_ID),
282: decode( p_INVOICING_RULE_ID, FND_API.G_MISS_NUM, NULL, p_INVOICING_RULE_ID),
283: decode( p_EMPLOYEE_PERSON_ID, FND_API.G_MISS_NUM, NULL, p_EMPLOYEE_PERSON_ID),
284: decode( p_PRICE_LIST_ID, FND_API.G_MISS_NUM, NULL, p_PRICE_LIST_ID),

Line 296: ASO_UTILITY_PVT.decode( p_EXCHANGE_RATE_DATE, FND_API.G_MISS_DATE, NULL, p_EXCHANGE_RATE_DATE),

292: decode( p_TOTAL_QUOTE_PRICE, FND_API.G_MISS_NUM, NULL, p_TOTAL_QUOTE_PRICE),
293: decode( p_PAYMENT_AMOUNT, FND_API.G_MISS_NUM, NULL, p_PAYMENT_AMOUNT),
294: decode( p_EXCHANGE_RATE, FND_API.G_MISS_NUM, NULL, p_EXCHANGE_RATE),
295: decode( p_EXCHANGE_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_EXCHANGE_TYPE_CODE),
296: ASO_UTILITY_PVT.decode( p_EXCHANGE_RATE_DATE, FND_API.G_MISS_DATE, NULL, p_EXCHANGE_RATE_DATE),
297: decode( p_CONTRACT_ID, FND_API.G_MISS_NUM, NULL, p_CONTRACT_ID),
298: decode( p_SALES_CHANNEL_CODE, FND_API.G_MISS_CHAR, NULL, p_SALES_CHANNEL_CODE),
299: decode( p_ORDER_ID, FND_API.G_MISS_NUM, NULL, p_ORDER_ID),
300: decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_RESOURCE_ID),

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

475: IS
476: BEGIN
477: Update ASO_QUOTE_HEADERS_ALL
478: SET
479: /* CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
480: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),*/
481: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
482: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
483: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),

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

477: Update ASO_QUOTE_HEADERS_ALL
478: SET
479: /* CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
480: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),*/
481: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
482: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
483: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
484: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
485: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),

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

483: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
484: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
485: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
486: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
487: PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
488: ORG_ID = decode( p_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, p_ORG_ID),
489: QUOTE_NAME = decode( p_QUOTE_NAME, FND_API.G_MISS_CHAR, QUOTE_NAME, p_QUOTE_NAME),
490: QUOTE_NUMBER = decode( p_QUOTE_NUMBER, FND_API.G_MISS_NUM, QUOTE_NUMBER, p_QUOTE_NUMBER),
491: QUOTE_VERSION = decode( p_QUOTE_VERSION, FND_API.G_MISS_NUM, QUOTE_VERSION, p_QUOTE_VERSION),

Line 494: QUOTE_EXPIRATION_DATE = ASO_UTILITY_PVT.decode( p_QUOTE_EXPIRATION_DATE, FND_API.G_MISS_DATE, QUOTE_EXPIRATION_DATE, p_QUOTE_EXPIRATION_DATE),

490: QUOTE_NUMBER = decode( p_QUOTE_NUMBER, FND_API.G_MISS_NUM, QUOTE_NUMBER, p_QUOTE_NUMBER),
491: QUOTE_VERSION = decode( p_QUOTE_VERSION, FND_API.G_MISS_NUM, QUOTE_VERSION, p_QUOTE_VERSION),
492: QUOTE_STATUS_ID = decode( p_QUOTE_STATUS_ID, FND_API.G_MISS_NUM, QUOTE_STATUS_ID, p_QUOTE_STATUS_ID),
493: QUOTE_SOURCE_CODE = decode( p_QUOTE_SOURCE_CODE, FND_API.G_MISS_CHAR, QUOTE_SOURCE_CODE, p_QUOTE_SOURCE_CODE),
494: QUOTE_EXPIRATION_DATE = ASO_UTILITY_PVT.decode( p_QUOTE_EXPIRATION_DATE, FND_API.G_MISS_DATE, QUOTE_EXPIRATION_DATE, p_QUOTE_EXPIRATION_DATE),
495: PRICE_FROZEN_DATE = ASO_UTILITY_PVT.decode( p_PRICE_FROZEN_DATE, FND_API.G_MISS_DATE, PRICE_FROZEN_DATE, p_PRICE_FROZEN_DATE),
496: QUOTE_PASSWORD = decode( p_QUOTE_PASSWORD, FND_API.G_MISS_CHAR, QUOTE_PASSWORD, p_QUOTE_PASSWORD),
497: ORIGINAL_SYSTEM_REFERENCE = decode( p_ORIGINAL_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIGINAL_SYSTEM_REFERENCE, p_ORIGINAL_SYSTEM_REFERENCE),
498: PARTY_ID = decode( p_PARTY_ID, FND_API.G_MISS_NUM, PARTY_ID, p_PARTY_ID),

Line 495: PRICE_FROZEN_DATE = ASO_UTILITY_PVT.decode( p_PRICE_FROZEN_DATE, FND_API.G_MISS_DATE, PRICE_FROZEN_DATE, p_PRICE_FROZEN_DATE),

491: QUOTE_VERSION = decode( p_QUOTE_VERSION, FND_API.G_MISS_NUM, QUOTE_VERSION, p_QUOTE_VERSION),
492: QUOTE_STATUS_ID = decode( p_QUOTE_STATUS_ID, FND_API.G_MISS_NUM, QUOTE_STATUS_ID, p_QUOTE_STATUS_ID),
493: QUOTE_SOURCE_CODE = decode( p_QUOTE_SOURCE_CODE, FND_API.G_MISS_CHAR, QUOTE_SOURCE_CODE, p_QUOTE_SOURCE_CODE),
494: QUOTE_EXPIRATION_DATE = ASO_UTILITY_PVT.decode( p_QUOTE_EXPIRATION_DATE, FND_API.G_MISS_DATE, QUOTE_EXPIRATION_DATE, p_QUOTE_EXPIRATION_DATE),
495: PRICE_FROZEN_DATE = ASO_UTILITY_PVT.decode( p_PRICE_FROZEN_DATE, FND_API.G_MISS_DATE, PRICE_FROZEN_DATE, p_PRICE_FROZEN_DATE),
496: QUOTE_PASSWORD = decode( p_QUOTE_PASSWORD, FND_API.G_MISS_CHAR, QUOTE_PASSWORD, p_QUOTE_PASSWORD),
497: ORIGINAL_SYSTEM_REFERENCE = decode( p_ORIGINAL_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIGINAL_SYSTEM_REFERENCE, p_ORIGINAL_SYSTEM_REFERENCE),
498: PARTY_ID = decode( p_PARTY_ID, FND_API.G_MISS_NUM, PARTY_ID, p_PARTY_ID),
499: CUST_ACCOUNT_ID = decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID),

Line 509: ORDERED_DATE = ASO_UTILITY_PVT.decode( p_ORDERED_DATE, FND_API.G_MISS_DATE, ORDERED_DATE, p_ORDERED_DATE),

505: ORIG_MKTG_SOURCE_CODE_ID = decode( p_ORIG_MKTG_SOURCE_CODE_ID, FND_API.G_MISS_NUM, ORIG_MKTG_SOURCE_CODE_ID, p_ORIG_MKTG_SOURCE_CODE_ID),
506: MARKETING_SOURCE_CODE_ID = decode( p_MARKETING_SOURCE_CODE_ID, FND_API.G_MISS_NUM, MARKETING_SOURCE_CODE_ID, p_MARKETING_SOURCE_CODE_ID),
507: ORDER_TYPE_ID = decode( p_ORDER_TYPE_ID, FND_API.G_MISS_NUM, ORDER_TYPE_ID, p_ORDER_TYPE_ID),
508: QUOTE_CATEGORY_CODE = decode( p_QUOTE_CATEGORY_CODE, FND_API.G_MISS_CHAR, QUOTE_CATEGORY_CODE, p_QUOTE_CATEGORY_CODE),
509: ORDERED_DATE = ASO_UTILITY_PVT.decode( p_ORDERED_DATE, FND_API.G_MISS_DATE, ORDERED_DATE, p_ORDERED_DATE),
510: ACCOUNTING_RULE_ID = decode( p_ACCOUNTING_RULE_ID, FND_API.G_MISS_NUM, ACCOUNTING_RULE_ID, p_ACCOUNTING_RULE_ID),
511: INVOICING_RULE_ID = decode( p_INVOICING_RULE_ID, FND_API.G_MISS_NUM, INVOICING_RULE_ID, p_INVOICING_RULE_ID),
512: EMPLOYEE_PERSON_ID = decode( p_EMPLOYEE_PERSON_ID, FND_API.G_MISS_NUM, EMPLOYEE_PERSON_ID, p_EMPLOYEE_PERSON_ID),
513: PRICE_LIST_ID = decode( p_PRICE_LIST_ID, FND_API.G_MISS_NUM, PRICE_LIST_ID, p_PRICE_LIST_ID),

Line 525: EXCHANGE_RATE_DATE = ASO_UTILITY_PVT.decode( p_EXCHANGE_RATE_DATE, FND_API.G_MISS_DATE, EXCHANGE_RATE_DATE, p_EXCHANGE_RATE_DATE),

521: TOTAL_QUOTE_PRICE = decode( p_TOTAL_QUOTE_PRICE, FND_API.G_MISS_NUM, TOTAL_QUOTE_PRICE, p_TOTAL_QUOTE_PRICE),
522: PAYMENT_AMOUNT = decode( p_PAYMENT_AMOUNT, FND_API.G_MISS_NUM, PAYMENT_AMOUNT, p_PAYMENT_AMOUNT),
523: EXCHANGE_RATE = decode( p_EXCHANGE_RATE, FND_API.G_MISS_NUM, EXCHANGE_RATE, p_EXCHANGE_RATE),
524: EXCHANGE_TYPE_CODE = decode( p_EXCHANGE_TYPE_CODE, FND_API.G_MISS_CHAR, EXCHANGE_TYPE_CODE, p_EXCHANGE_TYPE_CODE),
525: EXCHANGE_RATE_DATE = ASO_UTILITY_PVT.decode( p_EXCHANGE_RATE_DATE, FND_API.G_MISS_DATE, EXCHANGE_RATE_DATE, p_EXCHANGE_RATE_DATE),
526: CONTRACT_ID = decode( p_CONTRACT_ID, FND_API.G_MISS_NUM, CONTRACT_ID, p_CONTRACT_ID),
527: SALES_CHANNEL_CODE = decode( p_SALES_CHANNEL_CODE, FND_API.G_MISS_CHAR, SALES_CHANNEL_CODE, p_SALES_CHANNEL_CODE),
528: ORDER_ID = decode( p_ORDER_ID, FND_API.G_MISS_NUM, ORDER_ID, p_ORDER_ID),
529: RESOURCE_ID = decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, RESOURCE_ID, p_RESOURCE_ID),