[Home] [Help]
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 );
25:
26: PROCEDURE Assign_Ael_Elements(
27: p_mode IN VARCHAR2 ,
28: 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
43:
43:
44: l_ae_doc_rec ae_doc_rec_type;
45: l_ae_rule_rec ae_rule_rec_type;
46: l_app_rec ar_receivable_applications%ROWTYPE;
47: l_adj_rec ar_adjustments%ROWTYPE;
48:
49: BEGIN
50:
51: IF PG_DEBUG in ('Y', 'C') THEN
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
211:
212: CURSOR get_assignments(p_customer_trx_id IN NUMBER) is
213: SELECT ctl.customer_trx_id br_cust_trx_id ,
214: ctl.customer_trx_line_id br_customer_trx_line_id ,
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
238: AND ct.customer_trx_id = ctl.br_ref_customer_trx_id