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.34.12020000.9 2013/01/10 20:02:10 hvaladip 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: TYPE hz_customer_prof_cach is table of hz_customer_profiles.cons_bill_level%TYPE

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: TYPE hz_customer_prof_cach is table of hz_customer_profiles.cons_bill_level%TYPE
10: INDEX BY BINARY_INTEGER;
11:

Line 426: from ra_customer_trx trx,

422: decode(ap.cons_bill_level,
423: 'ACCOUNT', nvl(ap.standard_terms, -93),
424: 'SITE', nvl(nvl(sp.standard_terms, ap.standard_terms), -95)
425: , -91)))) new_term_id, trx.customer_trx_id
426: from ra_customer_trx trx,
427: ra_cust_trx_types tt,
428: hz_customer_profiles ap,
429: hz_cust_site_uses su,
430: ra_terms_b sut,

Line 512: UPDATE ra_customer_trx trx

508:
509: /* Bulk update of transaction terms
510: NOTE: This excludes those in error or null */
511: FORALL i IN t_trx_id.FIRST..t_trx_id.LAST
512: UPDATE ra_customer_trx trx
513: SET term_id = t_term_id(i)
514: WHERE trx.customer_trx_id = t_trx_id(i)
515: AND NVL(t_term_id(i), -99) > 0;
516:

Line 550: FROM RA_CUSTOMER_TRX_LINES line

546: -93,l_msg_93,
547: -94,l_msg_94,
548: -95,l_msg_95),
549: line.org_id
550: FROM RA_CUSTOMER_TRX_LINES line
551: WHERE line.customer_trx_id = t_trx_id(err)
552: AND t_term_id(err) < 0;
553:
554: l_rows_rejected := SQL%ROWCOUNT;