APPS.ARP_PROCESS_BR_HEADER dependencies on AR_TRANSACTION_HISTORY

Line 40: l_trh_rec ar_transaction_history%ROWTYPE;

36: p_gl_date IN DATE,
37: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
38: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type) IS
39:
40: l_trh_rec ar_transaction_history%ROWTYPE;
41: l_transaction_history_id ar_transaction_history.transaction_history_id%TYPE;
42: BEGIN
43:
44: IF PG_DEBUG in ('Y', 'C') THEN

Line 41: l_transaction_history_id ar_transaction_history.transaction_history_id%TYPE;

37: p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
38: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type) IS
39:
40: l_trh_rec ar_transaction_history%ROWTYPE;
41: l_transaction_history_id ar_transaction_history.transaction_history_id%TYPE;
42: BEGIN
43:
44: IF PG_DEBUG in ('Y', 'C') THEN
45: arp_util.debug('delete_transaction: ' || 'arp_process_br_header.insert_header()+');

Line 225: FROM ar_transaction_history

221: /*Bug7484811, Called ARP_XLA_EVENTS.delete_event to delete XLA record. */
222: BEGIN
223: SELECT transaction_history_id
224: INTO l_transaction_history_id
225: FROM ar_transaction_history
226: WHERE customer_trx_id = p_customer_trx_id
227: AND current_record_flag = 'Y';
228:
229: EXCEPTION

Line 395: from ar_transaction_history th

391: | Cursor for all transaction history rows that have accounting |
392: +----------------------------------------------------------------*/
393: CURSOR transaction_history_cur IS
394: select th.transaction_history_id
395: from ar_transaction_history th
396: where customer_trx_id = p_customer_trx_id
397: and postable_flag = 'Y';
398:
399: transaction_history_rec transaction_history_cur%ROWTYPE;