DBA Data[Home] [Help]

APPS.ARP_CORRECT_CC_ERRORS dependencies on ARPT_SQL_FUNC_UTIL

Line 575: ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CC_TRX_CATEGORY',p_cc_trx_category),

571: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.clear_invoice_pay_info()+' );
572: END IF;
573: SELECT NVL(trx.cc_error_code,'Unknown'),
574: NVL(trx.cc_error_text,'Unknown Error'),
575: ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CC_TRX_CATEGORY',p_cc_trx_category),
576: trx.trx_number,
577: trx.invoice_currency_code,
578: trx.trx_date,
579: party.party_name,

Line 2348: ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CC_TRX_CATEGORY',cr.type),

2344: END LOOP;
2345: /*Collect the info to pass to events */
2346: Select NVL(cr.cc_error_code,'Unknown'),
2347: NVL(cr.cc_error_text,'Unknown Error'),
2348: ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CC_TRX_CATEGORY',cr.type),
2349: cr.receipt_number,
2350: cr.currency_code,
2351: cr.amount,
2352: cr.receipt_date,