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: BEGIN

Line 917: l_memo_line_type ar_memo_lines.line_type%type;

913: l_uncr_line_amount number;
914: l_uncr_tax_amount number;
915: l_uncr_freight_amount number;
916: l_line_count number;
917: l_memo_line_type ar_memo_lines.line_type%type;
918: l_tax_count number;
919: l_freight_count number;
920: l_freight_type varchar2(1);
921: l_freight_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;

Line 937: ar_memo_lines ml

933: l_line_count,
934: l_memo_line_type
935: FROM ar_net_revenue_amount nra,
936: ra_customer_trx_lines ctl,
937: ar_memo_lines ml
938: WHERE nra.customer_trx_id = p_prev_ct_id
939: AND ctl.customer_trx_line_id = nra.customer_trx_line_id
940: AND ctl.memo_line_id = ml.memo_line_id (+)
941: AND decode(p_prev_ctl_id,

Line 1197: l_memo_line_type ar_memo_lines.line_type%type;

1193: l_line_rec ra_customer_trx_lines%rowtype;
1194:
1195: l_freight_type varchar2(1);
1196: l_freight_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;
1197: l_memo_line_type ar_memo_lines.line_type%type;
1198:
1199: l_uncr_line_amount number;
1200: l_uncr_tax_amount number;
1201: l_uncr_freight_amount number;

Line 2603: p_memo_line_type IN ar_memo_lines.line_type%type,

2599: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
2600: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
2601: p_line_percent IN number,
2602: p_freight_percent IN number,
2603: p_memo_line_type IN ar_memo_lines.line_type%type,
2604: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
2605: p_currency_code IN fnd_currencies.currency_code%type,
2606: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
2607: p_compute_tax IN varchar2,

Line 2634: l_memo_line_type ar_memo_lines.line_type%type;

2630: l_trx_balance_due number;
2631: l_line_balance_due number;
2632: l_tax_balance_due number;
2633: l_freight_balance_due number;
2634: l_memo_line_type ar_memo_lines.line_type%type;
2635: l_freight_type varchar2(1);
2636: l_freight_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;
2637:
2638: l_result integer;

Line 3143: p_memo_line_type IN ar_memo_lines.line_type%type,

3139: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
3140: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
3141: p_line_percent IN number,
3142: p_freight_percent IN number,
3143: p_memo_line_type IN ar_memo_lines.line_type%type,
3144: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
3145: p_currency_code IN fnd_currencies.currency_code%type,
3146: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
3147: p_exchange_rate IN ra_customer_trx.exchange_rate%type,

Line 3165: l_memo_line_type ar_memo_lines.line_type%type;

3161: l_line_amt_chng_flag boolean;
3162: l_frt_amt_chng_flag boolean;
3163: l_tax_amt_chng_flag boolean;
3164:
3165: l_memo_line_type ar_memo_lines.line_type%type;
3166: l_frt_type varchar2(1);
3167: l_prev_frt_ctlid ra_customer_trx_lines.customer_trx_line_id%type;
3168:
3169: l_uncr_line_amount number;