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 3453: p_currency_code IN fnd_currencies.currency_code%type

3449:
3450: PROCEDURE update_p( p_line_rec IN ra_customer_trx_lines%rowtype,
3451: p_customer_trx_line_id IN
3452: ra_customer_trx_lines.customer_trx_line_id%type,
3453: p_currency_code IN fnd_currencies.currency_code%type
3454: DEFAULT NULL ) IS
3455:
3456: l_currency_code fnd_currencies.currency_code%type;
3457:

Line 3456: l_currency_code fnd_currencies.currency_code%type;

3452: ra_customer_trx_lines.customer_trx_line_id%type,
3453: p_currency_code IN fnd_currencies.currency_code%type
3454: DEFAULT NULL ) IS
3455:
3456: l_currency_code fnd_currencies.currency_code%type;
3457:
3458: BEGIN
3459:
3460: IF PG_DEBUG in ('Y', 'C') THEN

Line 3550: p_currency_code IN fnd_currencies.currency_code%type

3546: p_customer_trx_id IN
3547: ra_customer_trx_lines.customer_trx_id%type,
3548: p_line_type IN
3549: ra_customer_trx_lines.line_type%type default null,
3550: p_currency_code IN fnd_currencies.currency_code%type
3551: DEFAULT NULL) IS
3552:
3553: l_where varchar2(500);
3554: l_currency_code fnd_currencies.currency_code%type;

Line 3554: l_currency_code fnd_currencies.currency_code%type;

3550: p_currency_code IN fnd_currencies.currency_code%type
3551: DEFAULT NULL) IS
3552:
3553: l_where varchar2(500);
3554: l_currency_code fnd_currencies.currency_code%type;
3555:
3556: BEGIN
3557:
3558: IF PG_DEBUG in ('Y', 'C') THEN

Line 5418: p_currency_code IN fnd_currencies.currency_code%type,

5414: p_line_type IN ra_customer_trx_lines.line_type%type,
5415: p_line_percent IN number,
5416: p_uncredited_amount IN ra_customer_trx_lines.extended_amount%type,
5417: p_credit_amount IN ra_customer_trx_lines.extended_amount%type,
5418: p_currency_code IN fnd_currencies.currency_code%type,
5419: p_tax_amount IN ra_customer_trx_lines.extended_amount%type)
5420: IS
5421: l_rows_inserted number;
5422: --{BUG#3339072

Line 6160: p_currency_code IN fnd_currencies.currency_code%type)

6156: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
6157: p_line_type IN ra_customer_trx_lines.line_type%type,
6158: p_uncredited_amount IN ra_customer_trx_lines.extended_amount%type,
6159: p_credit_amount IN ra_customer_trx_lines.extended_amount%type,
6160: p_currency_code IN fnd_currencies.currency_code%type)
6161: IS
6162: l_rows_updated number;
6163: BEGIN
6164: