37: invoice_number ra_customer_trx.trx_number%TYPE,
38: line_number ra_customer_trx_lines.line_number%TYPE,
39: invoice_type VARCHAR2(100),
40: applied_amount NUMBER,
41: applied_currency fnd_currencies_vl.name%TYPE,
42: amt_applied_in_inv_curr NUMBER,
43: invoice_amount_due NUMBER,
44: invoice_currency fnd_currencies_vl.name%TYPE,
45: exchange_rate NUMBER,
40: applied_amount NUMBER,
41: applied_currency fnd_currencies_vl.name%TYPE,
42: amt_applied_in_inv_curr NUMBER,
43: invoice_amount_due NUMBER,
44: invoice_currency fnd_currencies_vl.name%TYPE,
45: exchange_rate NUMBER,
46: status VARCHAR2(1) DEFAULT 'A'
47: );
48:
52: (
53: receipt_number fv_interim_cash_receipts.receipt_number%TYPE,
54: customer_name hz_parties.party_name%TYPE,
55: receipt_amount fv_interim_cash_receipts.amount%TYPE,
56: applied_currency fnd_currencies_vl.name%TYPE,
57: actual_amount NUMBER,
58: actual_currency fnd_currencies_vl.name%TYPE,
59: total_applications NUMBER,
60: total_errors NUMBER
54: customer_name hz_parties.party_name%TYPE,
55: receipt_amount fv_interim_cash_receipts.amount%TYPE,
56: applied_currency fnd_currencies_vl.name%TYPE,
57: actual_amount NUMBER,
58: actual_currency fnd_currencies_vl.name%TYPE,
59: total_applications NUMBER,
60: total_errors NUMBER
61: );
62:
75: -- Parameters Required for CreateCash API --
76: ------------------------------------------------------------------------
77: TYPE CreateCashRecType IS RECORD
78: (
79: usr_currency_code fnd_currencies_vl.name%TYPE,
80: currency_code fnd_currencies_vl.name%TYPE,
81: usr_exchange_rate_type gl_daily_conversion_types.user_conversion_type%TYPE,
82: exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE,
83: exchange_rate ar_cash_receipts.exchange_rate%TYPE,
76: ------------------------------------------------------------------------
77: TYPE CreateCashRecType IS RECORD
78: (
79: usr_currency_code fnd_currencies_vl.name%TYPE,
80: currency_code fnd_currencies_vl.name%TYPE,
81: usr_exchange_rate_type gl_daily_conversion_types.user_conversion_type%TYPE,
82: exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE,
83: exchange_rate ar_cash_receipts.exchange_rate%TYPE,
84: exchange_rate_date ar_cash_receipts.exchange_date%TYPE,