APPS.ARP_BR_ALLOC_WRAPPER_PKG dependencies on RA_CUSTOMER_TRX

Line 20: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,

16: PROCEDURE Get_Assign_Rate_Alloc_Tax(
17: p_mode IN VARCHAR2 ,
18: p_ae_doc_rec IN ae_doc_rec_type ,
19: p_ae_event_rec IN ae_event_rec_type ,
20: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,
21: p_ae_sys_rec IN ae_sys_rec_type ,
22: p_ae_rule_rec IN OUT NOCOPY ae_rule_rec_type ,
23: p_app_rec IN OUT NOCOPY ar_receivable_applications%ROWTYPE,
24: p_adj_rec IN OUT NOCOPY ar_adjustments%ROWTYPE );

Line 38: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,

34: p_ae_doc_rec IN ae_doc_rec_type ,
35: p_ae_event_rec IN ae_event_rec_type ,
36: p_ae_rule_rec IN ae_rule_rec_type ,
37: p_app_rec IN ar_receivable_applications%ROWTYPE ,
38: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,
39: p_adj_rec IN ar_adjustments%ROWTYPE ,
40: p_ae_sys_rec IN ae_sys_rec_type ,
41: p_ae_ctr IN OUT NOCOPY BINARY_INTEGER ,
42: p_ae_line_tbl IN OUT NOCOPY ae_line_tbl_type) IS

Line 206: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,

202: PROCEDURE Get_Assign_Rate_Alloc_Tax(
203: p_mode IN VARCHAR2 ,
204: p_ae_doc_rec IN ae_doc_rec_type ,
205: p_ae_event_rec IN ae_event_rec_type ,
206: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,
207: p_ae_sys_rec IN ae_sys_rec_type ,
208: p_ae_rule_rec IN OUT NOCOPY ae_rule_rec_type ,
209: p_app_rec IN OUT NOCOPY ar_receivable_applications%ROWTYPE,
210: p_adj_rec IN OUT NOCOPY ar_adjustments%ROWTYPE ) IS

Line 233: FROM ra_customer_trx_lines ctl,

229: nvl(adj.line_adjusted,0) br_adj_line_amt ,
230: nvl(adj.tax_adjusted,0) br_adj_tax_amt ,
231: nvl(adj.freight_adjusted,0) br_adj_frt_amt ,
232: nvl(adj.receivables_charges_adjusted,0) br_adj_chrg_amt
233: FROM ra_customer_trx_lines ctl,
234: ar_adjustments adj,
235: ra_customer_trx ct
236: WHERE ctl.customer_trx_id = p_customer_trx_id
237: AND ctl.br_adjustment_id = adj.adjustment_id

Line 235: ra_customer_trx ct

231: nvl(adj.freight_adjusted,0) br_adj_frt_amt ,
232: nvl(adj.receivables_charges_adjusted,0) br_adj_chrg_amt
233: FROM ra_customer_trx_lines ctl,
234: ar_adjustments adj,
235: ra_customer_trx ct
236: WHERE ctl.customer_trx_id = p_customer_trx_id
237: AND ctl.br_adjustment_id = adj.adjustment_id
238: AND ct.customer_trx_id = ctl.br_ref_customer_trx_id
239: AND adj.status = 'A'

Line 249: invoice_currency_code ra_customer_trx.invoice_currency_code%TYPE,

245: br_ref_customer_trx_id NUMBER,
246: br_ref_payment_schedule_id NUMBER,
247: drawee_id NUMBER,
248: drawee_site_use_id NUMBER,
249: invoice_currency_code ra_customer_trx.invoice_currency_code%TYPE,
250: exchange_rate NUMBER,
251: exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE,
252: exchange_date DATE,
253: trx_date DATE,

Line 251: exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE,

247: drawee_id NUMBER,
248: drawee_site_use_id NUMBER,
249: invoice_currency_code ra_customer_trx.invoice_currency_code%TYPE,
250: exchange_rate NUMBER,
251: exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE,
252: exchange_date DATE,
253: trx_date DATE,
254: bill_to_customer_id NUMBER,
255: bill_to_site_use_id NUMBER,

Line 323: l_cust_inv_rec ra_customer_trx%ROWTYPE;

319: l_line_run_pro_acctd_amt_tot NUMBER := 0;
320: l_frt_run_pro_amt_tot NUMBER := 0;
321: l_frt_run_pro_acctd_amt_tot NUMBER := 0;
322:
323: l_cust_inv_rec ra_customer_trx%ROWTYPE;
324:
325: BEGIN
326:
327: IF PG_DEBUG in ('Y', 'C') THEN