APPS.AR_BFB_UTILS_PVT dependencies on RA_CUSTOMER_TRX

Line 5: TYPE l_trx_id_type IS TABLE OF ra_customer_trx_all.customer_trx_id%type

1: package body ar_bfb_utils_pvt as
2: /* $Header: ARBFBUTB.pls 120.10.12010000.6 2008/12/11 20:54:35 mraymond ship $ */
3:
4: /* Global table definitions */
5: TYPE l_trx_id_type IS TABLE OF ra_customer_trx_all.customer_trx_id%type
6: INDEX BY BINARY_INTEGER;
7: TYPE l_term_id_type IS TABLE OF ra_customer_trx_all.term_id%type
8: INDEX BY BINARY_INTEGER;
9:

Line 7: TYPE l_term_id_type IS TABLE OF ra_customer_trx_all.term_id%type

3:
4: /* Global table definitions */
5: TYPE l_trx_id_type IS TABLE OF ra_customer_trx_all.customer_trx_id%type
6: INDEX BY BINARY_INTEGER;
7: TYPE l_term_id_type IS TABLE OF ra_customer_trx_all.term_id%type
8: INDEX BY BINARY_INTEGER;
9:
10: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
11:

Line 343: from ra_customer_trx trx,

339: decode(ap.cons_bill_level,
340: 'ACCOUNT', nvl(ap.standard_terms, -93),
341: 'SITE', nvl(nvl(sp.standard_terms, ap.standard_terms), -95)
342: , -91)))) new_term_id, trx.customer_trx_id
343: from ra_customer_trx trx,
344: ra_cust_trx_types tt,
345: hz_customer_profiles ap,
346: hz_customer_profiles sp,
347: hz_cust_site_uses su,

Line 418: UPDATE ra_customer_trx trx

414:
415: /* Bulk update of transaction terms
416: NOTE: This excludes those in error or null */
417: FORALL i IN t_trx_id.FIRST..t_trx_id.LAST
418: UPDATE ra_customer_trx trx
419: SET term_id = t_term_id(i)
420: WHERE trx.customer_trx_id = t_trx_id(i)
421: AND NVL(t_term_id(i), -99) > 0;
422:

Line 456: FROM RA_CUSTOMER_TRX_LINES line

452: -93,l_msg_93,
453: -94,l_msg_94,
454: -95,l_msg_95),
455: line.org_id
456: FROM RA_CUSTOMER_TRX_LINES line
457: WHERE line.customer_trx_id = t_trx_id(err)
458: AND t_term_id(err) < 0;
459:
460: l_rows_rejected := SQL%ROWCOUNT;