DBA Data[Home] [Help]

APPS.AR_DEPOSIT_VAL_PVT dependencies on RA_CUSTOMER_TRX

Line 208: ra_customer_trx.invoice_currency_code%TYPE)

204: RAISE;
205: END Validate_Exchange_Rate;
206:
207: FUNCTION Is_currency_valid(p_currency_code IN
208: ra_customer_trx.invoice_currency_code%TYPE)
209: RETURN VARCHAR2 IS
210: l_currency_valid VARCHAR2(1);
211: BEGIN
212: arp_util.debug('AR_DEPOSIT_VAL_PVT.Is_currency_valid () +');

Line 232: p_currency_code in ra_customer_trx.invoice_currency_code%TYPE,

228: raise;
229: END Is_currency_valid;
230:
231: PROCEDURE Validate_Currency(
232: p_currency_code in ra_customer_trx.invoice_currency_code%TYPE,
233: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%TYPE,
234: p_exchange_rate IN ra_customer_trx.exchange_rate%TYPE,
235: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
236: p_return_status OUT NOCOPY VARCHAR2) IS

Line 233: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%TYPE,

229: END Is_currency_valid;
230:
231: PROCEDURE Validate_Currency(
232: p_currency_code in ra_customer_trx.invoice_currency_code%TYPE,
233: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%TYPE,
234: p_exchange_rate IN ra_customer_trx.exchange_rate%TYPE,
235: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
236: p_return_status OUT NOCOPY VARCHAR2) IS
237: BEGIN

Line 234: p_exchange_rate IN ra_customer_trx.exchange_rate%TYPE,

230:
231: PROCEDURE Validate_Currency(
232: p_currency_code in ra_customer_trx.invoice_currency_code%TYPE,
233: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%TYPE,
234: p_exchange_rate IN ra_customer_trx.exchange_rate%TYPE,
235: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
236: p_return_status OUT NOCOPY VARCHAR2) IS
237: BEGIN
238: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 320: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,

316: PROCEDURE Validate_Deposit(
317: p_batch_source_id IN ra_batch_sources.batch_source_id%type,
318: p_deposit_date IN date,
319: p_gl_date IN date,
320: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
321: p_amount IN ra_customer_trx_lines.extended_amount%type,
322: p_currency_code IN ra_customer_trx.invoice_currency_code%TYPE,
323: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%TYPE,
324: p_exchange_rate IN ra_customer_trx.exchange_rate%TYPE,

Line 321: p_amount IN ra_customer_trx_lines.extended_amount%type,

317: p_batch_source_id IN ra_batch_sources.batch_source_id%type,
318: p_deposit_date IN date,
319: p_gl_date IN date,
320: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
321: p_amount IN ra_customer_trx_lines.extended_amount%type,
322: p_currency_code IN ra_customer_trx.invoice_currency_code%TYPE,
323: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%TYPE,
324: p_exchange_rate IN ra_customer_trx.exchange_rate%TYPE,
325: p_exchange_rate_date IN ra_customer_trx.exchange_date%TYPE,

Line 322: p_currency_code IN ra_customer_trx.invoice_currency_code%TYPE,

318: p_deposit_date IN date,
319: p_gl_date IN date,
320: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
321: p_amount IN ra_customer_trx_lines.extended_amount%type,
322: p_currency_code IN ra_customer_trx.invoice_currency_code%TYPE,
323: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%TYPE,
324: p_exchange_rate IN ra_customer_trx.exchange_rate%TYPE,
325: p_exchange_rate_date IN ra_customer_trx.exchange_date%TYPE,
326: p_printing_option IN VARCHAR2,

Line 323: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%TYPE,

319: p_gl_date IN date,
320: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
321: p_amount IN ra_customer_trx_lines.extended_amount%type,
322: p_currency_code IN ra_customer_trx.invoice_currency_code%TYPE,
323: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%TYPE,
324: p_exchange_rate IN ra_customer_trx.exchange_rate%TYPE,
325: p_exchange_rate_date IN ra_customer_trx.exchange_date%TYPE,
326: p_printing_option IN VARCHAR2,
327: p_status_trx IN VARCHAR2,

Line 324: p_exchange_rate IN ra_customer_trx.exchange_rate%TYPE,

320: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
321: p_amount IN ra_customer_trx_lines.extended_amount%type,
322: p_currency_code IN ra_customer_trx.invoice_currency_code%TYPE,
323: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%TYPE,
324: p_exchange_rate IN ra_customer_trx.exchange_rate%TYPE,
325: p_exchange_rate_date IN ra_customer_trx.exchange_date%TYPE,
326: p_printing_option IN VARCHAR2,
327: p_status_trx IN VARCHAR2,
328: p_default_tax_exempt_flag IN VARCHAR2,

Line 325: p_exchange_rate_date IN ra_customer_trx.exchange_date%TYPE,

321: p_amount IN ra_customer_trx_lines.extended_amount%type,
322: p_currency_code IN ra_customer_trx.invoice_currency_code%TYPE,
323: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%TYPE,
324: p_exchange_rate IN ra_customer_trx.exchange_rate%TYPE,
325: p_exchange_rate_date IN ra_customer_trx.exchange_date%TYPE,
326: p_printing_option IN VARCHAR2,
327: p_status_trx IN VARCHAR2,
328: p_default_tax_exempt_flag IN VARCHAR2,
329: p_financial_charges IN VARCHAR2 DEFAULT NULL,