APPS.ARP_PROCESS_CREDIT dependencies on AR_MEMO_LINES

Line 60: p_memo_line_type IN ar_memo_lines.line_type%type,

56: PROCEDURE create_salescredits(
57: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
58: p_customer_trx_line_id IN
59: ra_customer_trx_lines.customer_trx_line_id%type,
60: p_memo_line_type IN ar_memo_lines.line_type%type,
61: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
62: p_currency_code IN fnd_currencies.currency_code%type)
63: IS
64: l_line_salesrep_flag NUMBER := 0;

Line 947: l_memo_line_type ar_memo_lines.line_type%type;

943: l_uncr_line_amount number;
944: l_uncr_tax_amount number;
945: l_uncr_freight_amount number;
946: l_line_count number;
947: l_memo_line_type ar_memo_lines.line_type%type;
948: l_tax_count number;
949: l_freight_count number;
950: l_freight_type varchar2(1);
951: l_freight_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;

Line 967: ar_memo_lines ml

963: l_line_count,
964: l_memo_line_type
965: FROM ar_net_revenue_amount nra,
966: ra_customer_trx_lines ctl,
967: ar_memo_lines ml
968: WHERE nra.customer_trx_id = p_prev_ct_id
969: AND ctl.customer_trx_line_id = nra.customer_trx_line_id
970: AND ctl.memo_line_id = ml.memo_line_id (+)
971: AND decode(p_prev_ctl_id,

Line 1227: l_memo_line_type ar_memo_lines.line_type%type;

1223: l_line_rec ra_customer_trx_lines%rowtype;
1224:
1225: l_freight_type varchar2(1);
1226: l_freight_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;
1227: l_memo_line_type ar_memo_lines.line_type%type;
1228:
1229: l_uncr_line_amount number;
1230: l_uncr_tax_amount number;
1231: l_uncr_freight_amount number;

Line 2633: p_memo_line_type IN ar_memo_lines.line_type%type,

2629: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
2630: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
2631: p_line_percent IN number,
2632: p_freight_percent IN number,
2633: p_memo_line_type IN ar_memo_lines.line_type%type,
2634: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
2635: p_currency_code IN fnd_currencies.currency_code%type,
2636: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
2637: p_compute_tax IN varchar2,

Line 2664: l_memo_line_type ar_memo_lines.line_type%type;

2660: l_trx_balance_due number;
2661: l_line_balance_due number;
2662: l_tax_balance_due number;
2663: l_freight_balance_due number;
2664: l_memo_line_type ar_memo_lines.line_type%type;
2665: l_freight_type varchar2(1);
2666: l_freight_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;
2667:
2668: l_result integer;

Line 3183: p_memo_line_type IN ar_memo_lines.line_type%type,

3179: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
3180: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
3181: p_line_percent IN number,
3182: p_freight_percent IN number,
3183: p_memo_line_type IN ar_memo_lines.line_type%type,
3184: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
3185: p_currency_code IN fnd_currencies.currency_code%type,
3186: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
3187: p_exchange_rate IN ra_customer_trx.exchange_rate%type,

Line 3205: l_memo_line_type ar_memo_lines.line_type%type;

3201: l_line_amt_chng_flag boolean;
3202: l_frt_amt_chng_flag boolean;
3203: l_tax_amt_chng_flag boolean;
3204:
3205: l_memo_line_type ar_memo_lines.line_type%type;
3206: l_frt_type varchar2(1);
3207: l_prev_frt_ctlid ra_customer_trx_lines.customer_trx_line_id%type;
3208:
3209: l_uncr_line_amount number;