APPS.ARP_CTL_PKG dependencies on FND_CURRENCIES

Line 129: l_precision FND_CURRENCIES.precision%type;

125: RETURN NUMBER
126: IS
127: l_tax_recoverable ra_customer_trx_lines.tax_recoverable%type;
128: l_total_tax_recoverable ra_customer_trx_lines.tax_recoverable%type;
129: l_precision FND_CURRENCIES.precision%type;
130: l_mau FND_CURRENCIES.minimum_accountable_unit%type;
131: l_tax_amount ra_customer_trx_lines.extended_amount%type;
132:
133: BEGIN

Line 130: l_mau FND_CURRENCIES.minimum_accountable_unit%type;

126: IS
127: l_tax_recoverable ra_customer_trx_lines.tax_recoverable%type;
128: l_total_tax_recoverable ra_customer_trx_lines.tax_recoverable%type;
129: l_precision FND_CURRENCIES.precision%type;
130: l_mau FND_CURRENCIES.minimum_accountable_unit%type;
131: l_tax_amount ra_customer_trx_lines.extended_amount%type;
132:
133: BEGIN
134: IF PG_DEBUG in ('Y', 'C') THEN

Line 193: FND_CURRENCIES CUR

189: CUR.minimum_accountable_unit
190: into l_precision,
191: l_mau
192: from RA_CUSTOMER_TRX TRX,
193: FND_CURRENCIES CUR
194: where TRX.customer_trx_id = p_customer_trx_id
195: and TRX.invoice_currency_code = CUR.currency_code;
196:
197: l_tax_amount := p_tax_amount * (l_tax_recoverable / l_total_tax_recoverable);

Line 1405: fnd_currencies.currency_code%type,

1401: p_where1 IN number,
1402: p_line_type IN
1403: ra_customer_trx_lines.line_type%type,
1404: p_currency_code IN
1405: fnd_currencies.currency_code%type,
1406: p_line_rec IN ra_customer_trx_lines%rowtype)
1407: IS
1408:
1409: l_count number;

Line 3475: p_currency_code IN fnd_currencies.currency_code%type

3471:
3472: PROCEDURE update_p( p_line_rec IN ra_customer_trx_lines%rowtype,
3473: p_customer_trx_line_id IN
3474: ra_customer_trx_lines.customer_trx_line_id%type,
3475: p_currency_code IN fnd_currencies.currency_code%type
3476: DEFAULT NULL ) IS
3477:
3478: l_currency_code fnd_currencies.currency_code%type;
3479:

Line 3478: l_currency_code fnd_currencies.currency_code%type;

3474: ra_customer_trx_lines.customer_trx_line_id%type,
3475: p_currency_code IN fnd_currencies.currency_code%type
3476: DEFAULT NULL ) IS
3477:
3478: l_currency_code fnd_currencies.currency_code%type;
3479:
3480: BEGIN
3481:
3482: IF PG_DEBUG in ('Y', 'C') THEN

Line 3572: p_currency_code IN fnd_currencies.currency_code%type

3568: p_customer_trx_id IN
3569: ra_customer_trx_lines.customer_trx_id%type,
3570: p_line_type IN
3571: ra_customer_trx_lines.line_type%type default null,
3572: p_currency_code IN fnd_currencies.currency_code%type
3573: DEFAULT NULL) IS
3574:
3575: l_where varchar2(500);
3576: l_currency_code fnd_currencies.currency_code%type;

Line 3576: l_currency_code fnd_currencies.currency_code%type;

3572: p_currency_code IN fnd_currencies.currency_code%type
3573: DEFAULT NULL) IS
3574:
3575: l_where varchar2(500);
3576: l_currency_code fnd_currencies.currency_code%type;
3577:
3578: BEGIN
3579:
3580: IF PG_DEBUG in ('Y', 'C') THEN

Line 5440: p_currency_code IN fnd_currencies.currency_code%type,

5436: p_line_type IN ra_customer_trx_lines.line_type%type,
5437: p_line_percent IN number,
5438: p_uncredited_amount IN ra_customer_trx_lines.extended_amount%type,
5439: p_credit_amount IN ra_customer_trx_lines.extended_amount%type,
5440: p_currency_code IN fnd_currencies.currency_code%type,
5441: p_tax_amount IN ra_customer_trx_lines.extended_amount%type)
5442: IS
5443: l_rows_inserted number;
5444: --{BUG#3339072

Line 6076: p_currency_code IN fnd_currencies.currency_code%type)

6072: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
6073: p_line_type IN ra_customer_trx_lines.line_type%type,
6074: p_uncredited_amount IN ra_customer_trx_lines.extended_amount%type,
6075: p_credit_amount IN ra_customer_trx_lines.extended_amount%type,
6076: p_currency_code IN fnd_currencies.currency_code%type)
6077: IS
6078: l_rows_updated number;
6079: --{BUG#3339072
6080: l_ctl_key_list gl_ca_utility_pkg.r_key_value_arr;