eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_APPLY_CASH_RECEIPT dependencies on AR_CASH_RECEIPTS

Line 82: exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE,

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,
85: amount ar_cash_receipts.amount%TYPE,
86: factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE,

Line 83: exchange_rate ar_cash_receipts.exchange_rate%TYPE,

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,
85: amount ar_cash_receipts.amount%TYPE,
86: factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE,
87: receipt_number ar_cash_receipts.receipt_number%TYPE,

Line 84: exchange_rate_date ar_cash_receipts.exchange_date%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,
85: amount ar_cash_receipts.amount%TYPE,
86: factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE,
87: receipt_number ar_cash_receipts.receipt_number%TYPE,
88: receipt_date ar_cash_receipts.receipt_date%type,

Line 85: amount ar_cash_receipts.amount%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,
85: amount ar_cash_receipts.amount%TYPE,
86: factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE,
87: receipt_number ar_cash_receipts.receipt_number%TYPE,
88: receipt_date ar_cash_receipts.receipt_date%type,
89: gl_date DATE,

Line 86: factor_discount_amount ar_cash_receipts.factor_discount_amount%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,
85: amount ar_cash_receipts.amount%TYPE,
86: factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE,
87: receipt_number ar_cash_receipts.receipt_number%TYPE,
88: receipt_date ar_cash_receipts.receipt_date%type,
89: gl_date DATE,
90: maturity_date DATE,

Line 87: receipt_number ar_cash_receipts.receipt_number%TYPE,

83: exchange_rate ar_cash_receipts.exchange_rate%TYPE,
84: exchange_rate_date ar_cash_receipts.exchange_date%TYPE,
85: amount ar_cash_receipts.amount%TYPE,
86: factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE,
87: receipt_number ar_cash_receipts.receipt_number%TYPE,
88: receipt_date ar_cash_receipts.receipt_date%type,
89: gl_date DATE,
90: maturity_date DATE,
91: postmark_date DATE,

Line 88: receipt_date ar_cash_receipts.receipt_date%type,

84: exchange_rate_date ar_cash_receipts.exchange_date%TYPE,
85: amount ar_cash_receipts.amount%TYPE,
86: factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE,
87: receipt_number ar_cash_receipts.receipt_number%TYPE,
88: receipt_date ar_cash_receipts.receipt_date%type,
89: gl_date DATE,
90: maturity_date DATE,
91: postmark_date DATE,
92: customer_id hz_parties.party_id%TYPE,

Line 95: customer_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE,

91: postmark_date DATE,
92: customer_id hz_parties.party_id%TYPE,
93: customer_name hz_parties.party_name%TYPE,
94: customer_number hz_cust_accounts.account_number%TYPE,
95: customer_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE,
96: customer_bank_account_num ce_bank_accounts.bank_account_num%TYPE,
97: customer_bank_account_name ce_bank_accounts.bank_account_name%TYPE,
98: location hz_cust_site_uses.location%type,
99: customer_site_use_id hz_cust_site_uses.site_use_id%TYPE,

Line 100: customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE,

96: customer_bank_account_num ce_bank_accounts.bank_account_num%TYPE,
97: customer_bank_account_name ce_bank_accounts.bank_account_name%TYPE,
98: location hz_cust_site_uses.location%type,
99: customer_site_use_id hz_cust_site_uses.site_use_id%TYPE,
100: customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE,
101: override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE,
102: remittance_bank_account_id ar_cash_receipts.remit_bank_acct_use_id%TYPE,
103: remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE,
104: remittance_bank_account_name ce_bank_accounts.bank_account_name%TYPE,

Line 101: override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE,

97: customer_bank_account_name ce_bank_accounts.bank_account_name%TYPE,
98: location hz_cust_site_uses.location%type,
99: customer_site_use_id hz_cust_site_uses.site_use_id%TYPE,
100: customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE,
101: override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE,
102: remittance_bank_account_id ar_cash_receipts.remit_bank_acct_use_id%TYPE,
103: remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE,
104: remittance_bank_account_name ce_bank_accounts.bank_account_name%TYPE,
105: deposit_date ar_cash_receipts.deposit_date%TYPE,

Line 102: remittance_bank_account_id ar_cash_receipts.remit_bank_acct_use_id%TYPE,

98: location hz_cust_site_uses.location%type,
99: customer_site_use_id hz_cust_site_uses.site_use_id%TYPE,
100: customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE,
101: override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE,
102: remittance_bank_account_id ar_cash_receipts.remit_bank_acct_use_id%TYPE,
103: remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE,
104: remittance_bank_account_name ce_bank_accounts.bank_account_name%TYPE,
105: deposit_date ar_cash_receipts.deposit_date%TYPE,
106: receipt_method_id ar_cash_receipts.receipt_method_id%TYPE,

Line 105: deposit_date ar_cash_receipts.deposit_date%TYPE,

101: override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE,
102: remittance_bank_account_id ar_cash_receipts.remit_bank_acct_use_id%TYPE,
103: remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE,
104: remittance_bank_account_name ce_bank_accounts.bank_account_name%TYPE,
105: deposit_date ar_cash_receipts.deposit_date%TYPE,
106: receipt_method_id ar_cash_receipts.receipt_method_id%TYPE,
107: receipt_method_name ar_receipt_methods.name%TYPE,
108: doc_sequence_value NUMBER,
109: -- ussgl_transaction_code ar_cash_receipts.ussgl_transaction_code%TYPE,

Line 106: receipt_method_id ar_cash_receipts.receipt_method_id%TYPE,

102: remittance_bank_account_id ar_cash_receipts.remit_bank_acct_use_id%TYPE,
103: remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE,
104: remittance_bank_account_name ce_bank_accounts.bank_account_name%TYPE,
105: deposit_date ar_cash_receipts.deposit_date%TYPE,
106: receipt_method_id ar_cash_receipts.receipt_method_id%TYPE,
107: receipt_method_name ar_receipt_methods.name%TYPE,
108: doc_sequence_value NUMBER,
109: -- ussgl_transaction_code ar_cash_receipts.ussgl_transaction_code%TYPE,
110: anticipated_clearing_date ar_cash_receipts.anticipated_clearing_date%TYPE,

Line 109: -- ussgl_transaction_code ar_cash_receipts.ussgl_transaction_code%TYPE,

105: deposit_date ar_cash_receipts.deposit_date%TYPE,
106: receipt_method_id ar_cash_receipts.receipt_method_id%TYPE,
107: receipt_method_name ar_receipt_methods.name%TYPE,
108: doc_sequence_value NUMBER,
109: -- ussgl_transaction_code ar_cash_receipts.ussgl_transaction_code%TYPE,
110: anticipated_clearing_date ar_cash_receipts.anticipated_clearing_date%TYPE,
111: called_from VARCHAR2(100),
112: attribute_rec ar_receipt_api_pub.attribute_rec_type,
113: global_attribute_rec ar_receipt_api_pub.global_attribute_rec_type,

Line 110: anticipated_clearing_date ar_cash_receipts.anticipated_clearing_date%TYPE,

106: receipt_method_id ar_cash_receipts.receipt_method_id%TYPE,
107: receipt_method_name ar_receipt_methods.name%TYPE,
108: doc_sequence_value NUMBER,
109: -- ussgl_transaction_code ar_cash_receipts.ussgl_transaction_code%TYPE,
110: anticipated_clearing_date ar_cash_receipts.anticipated_clearing_date%TYPE,
111: called_from VARCHAR2(100),
112: attribute_rec ar_receipt_api_pub.attribute_rec_type,
113: global_attribute_rec ar_receipt_api_pub.global_attribute_rec_type,
114: comments ar_receivable_applications.comments%TYPE,

Line 115: issuer_name ar_cash_receipts.issuer_name%TYPE,

111: called_from VARCHAR2(100),
112: attribute_rec ar_receipt_api_pub.attribute_rec_type,
113: global_attribute_rec ar_receipt_api_pub.global_attribute_rec_type,
114: comments ar_receivable_applications.comments%TYPE,
115: issuer_name ar_cash_receipts.issuer_name%TYPE,
116: issue_date ar_cash_receipts.issue_date%TYPE,
117: issuer_bank_branch_id ar_cash_receipts.issuer_bank_branch_id%TYPE,
118: org_id ar_Cash_receipts.org_id%TYPE
119: );

Line 116: issue_date ar_cash_receipts.issue_date%TYPE,

112: attribute_rec ar_receipt_api_pub.attribute_rec_type,
113: global_attribute_rec ar_receipt_api_pub.global_attribute_rec_type,
114: comments ar_receivable_applications.comments%TYPE,
115: issuer_name ar_cash_receipts.issuer_name%TYPE,
116: issue_date ar_cash_receipts.issue_date%TYPE,
117: issuer_bank_branch_id ar_cash_receipts.issuer_bank_branch_id%TYPE,
118: org_id ar_Cash_receipts.org_id%TYPE
119: );
120:

Line 117: issuer_bank_branch_id ar_cash_receipts.issuer_bank_branch_id%TYPE,

113: global_attribute_rec ar_receipt_api_pub.global_attribute_rec_type,
114: comments ar_receivable_applications.comments%TYPE,
115: issuer_name ar_cash_receipts.issuer_name%TYPE,
116: issue_date ar_cash_receipts.issue_date%TYPE,
117: issuer_bank_branch_id ar_cash_receipts.issuer_bank_branch_id%TYPE,
118: org_id ar_Cash_receipts.org_id%TYPE
119: );
120:
121: ------------------------------------------------------------------------

Line 118: org_id ar_Cash_receipts.org_id%TYPE

114: comments ar_receivable_applications.comments%TYPE,
115: issuer_name ar_cash_receipts.issuer_name%TYPE,
116: issue_date ar_cash_receipts.issue_date%TYPE,
117: issuer_bank_branch_id ar_cash_receipts.issuer_bank_branch_id%TYPE,
118: org_id ar_Cash_receipts.org_id%TYPE
119: );
120:
121: ------------------------------------------------------------------------
122: -- Parameters Required for ApplyCash API --

Line 126: cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE,

122: -- Parameters Required for ApplyCash API --
123: ------------------------------------------------------------------------
124: TYPE ApplyCashRecType IS RECORD
125: (
126: cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE,
127: receipt_number ar_cash_receipts.receipt_number%TYPE,
128: customer_trx_id ra_customer_trx.customer_trx_id%TYPE,
129: trx_number ra_customer_trx.trx_number%TYPE,
130: installment ar_payment_schedules.terms_sequence_number%TYPE,

Line 127: receipt_number ar_cash_receipts.receipt_number%TYPE,

123: ------------------------------------------------------------------------
124: TYPE ApplyCashRecType IS RECORD
125: (
126: cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE,
127: receipt_number ar_cash_receipts.receipt_number%TYPE,
128: customer_trx_id ra_customer_trx.customer_trx_id%TYPE,
129: trx_number ra_customer_trx.trx_number%TYPE,
130: installment ar_payment_schedules.terms_sequence_number%TYPE,
131: applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE,

Line 163: cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE,

159: -- Parameters Required for OnAccount API --
160: ------------------------------------------------------------------------
161: TYPE OnAccountRecType IS RECORD
162: (
163: cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE,
164: receipt_number ar_cash_receipts.receipt_number%TYPE,
165: amount_applied ar_receivable_applications.amount_applied%TYPE,
166: apply_date ar_receivable_applications.apply_date%TYPE,
167: apply_gl_date ar_receivable_applications.gl_date%TYPE,

Line 164: receipt_number ar_cash_receipts.receipt_number%TYPE,

160: ------------------------------------------------------------------------
161: TYPE OnAccountRecType IS RECORD
162: (
163: cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE,
164: receipt_number ar_cash_receipts.receipt_number%TYPE,
165: amount_applied ar_receivable_applications.amount_applied%TYPE,
166: apply_date ar_receivable_applications.apply_date%TYPE,
167: apply_gl_date ar_receivable_applications.gl_date%TYPE,
168: -- ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%TYPE,

Line 1790: p_CashReceiptId OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,

1786: PROCEDURE create_cash_receipt
1787: (
1788: p_BatchId IN NUMBER,
1789: p_CreateCashRec IN CreateCashRecType,
1790: p_CashReceiptId OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
1791: p_ErrorCode OUT NOCOPY VARCHAR2,
1792: p_ErrorDesc OUT NOCOPY VARCHAR2,
1793: p_ErrorLoc OUT NOCOPY VARCHAR2
1794: ) IS

Line 2042: p_CashReceiptId IN ar_cash_receipts.cash_receipt_id%TYPE,

2038: --****************************************************************************************--
2039: PROCEDURE pay_the_invoice
2040: (
2041: p_ReceiptNumber IN fv_interim_cash_receipts.receipt_number%TYPE,
2042: p_CashReceiptId IN ar_cash_receipts.cash_receipt_id%TYPE,
2043: p_InvoiceNumber IN ra_customer_trx_all.trx_number%TYPE,
2044: p_LineNumber IN ra_customer_trx_lines_all.line_number%TYPE,
2045: p_InvoiceId IN ra_customer_trx_all.customer_trx_id%TYPE,
2046: p_InvoiceLineId IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,

Line 2055: p_ReceiptDate IN ar_cash_receipts.receipt_date%TYPE,

2051: p_ExchangeRateType IN ar_batches.exchange_rate_type%TYPE,
2052: p_PaymentScheduleId IN ar_payment_schedules.payment_schedule_id%TYPE,
2053: p_InvoiceAmount IN NUMBER,
2054: p_InvoiceLineAmount IN NUMBER,
2055: p_ReceiptDate IN ar_cash_receipts.receipt_date%TYPE,
2056: p_GLDate IN DATE,
2057: -- p_USSGLTransactionCode IN ar_cash_receipts.ussgl_transaction_code%TYPE,
2058: p_org_id IN NUMBER,
2059: p_RemaingReceiptAmount IN OUT NOCOPY NUMBER,

Line 2057: -- p_USSGLTransactionCode IN ar_cash_receipts.ussgl_transaction_code%TYPE,

2053: p_InvoiceAmount IN NUMBER,
2054: p_InvoiceLineAmount IN NUMBER,
2055: p_ReceiptDate IN ar_cash_receipts.receipt_date%TYPE,
2056: p_GLDate IN DATE,
2057: -- p_USSGLTransactionCode IN ar_cash_receipts.ussgl_transaction_code%TYPE,
2058: p_org_id IN NUMBER,
2059: p_RemaingReceiptAmount IN OUT NOCOPY NUMBER,
2060: p_ErrorCode OUT NOCOPY VARCHAR2,
2061: p_ErrorDesc OUT NOCOPY VARCHAR2,

Line 2435: p_CashReceiptId IN ar_cash_receipts_all.cash_receipt_id%TYPE,

2431: --****************************************************************************************--
2432: PROCEDURE pay_debit_memos
2433: (
2434: p_ReceiptNumber IN fv_interim_cash_receipts.receipt_number%TYPE,
2435: p_CashReceiptId IN ar_cash_receipts_all.cash_receipt_id%TYPE,
2436: p_InvoiceId IN ra_customer_trx_all.customer_trx_id%TYPE,
2437: p_CurrencyCode IN fv_interim_cash_receipts.currency_code%TYPE,
2438: p_ExchangeRateDate IN ar_batches.exchange_date%TYPE,
2439: p_ExchangeRate IN ar_batches.exchange_rate%TYPE,

Line 2441: p_ReceiptDate IN ar_cash_receipts.receipt_date%TYPE,

2437: p_CurrencyCode IN fv_interim_cash_receipts.currency_code%TYPE,
2438: p_ExchangeRateDate IN ar_batches.exchange_date%TYPE,
2439: p_ExchangeRate IN ar_batches.exchange_rate%TYPE,
2440: p_ExchangeRateType IN ar_batches.exchange_rate_type%TYPE,
2441: p_ReceiptDate IN ar_cash_receipts.receipt_date%TYPE,
2442: p_gldate IN DATE,
2443: p_RemaingReceiptAmount IN OUT NOCOPY NUMBER,
2444: p_ErrorCode OUT NOCOPY VARCHAR2,
2445: p_ErrorDesc OUT NOCOPY VARCHAR2,

Line 2453: -- l_USSGLTransactionCode ar_cash_receipts.ussgl_transaction_code%TYPE;

2449:
2450: l_AmountApplied NUMBER;
2451: l_InvAmountApplied NUMBER;
2452: l_ApplyCashRec ApplyCashRecType;
2453: -- l_USSGLTransactionCode ar_cash_receipts.ussgl_transaction_code%TYPE;
2454: l_ConvertedAmountDue NUMBER;
2455: l_denominator NUMBER;
2456: l_numerator NUMBER;
2457: l_ExchangeRate ar_batches.exchange_rate%TYPE;

Line 2719: l_CashReceiptId ar_cash_receipts.cash_receipt_id%TYPE;

2715:
2716: l_SiteUseId ra_customer_trx.bill_to_site_use_id%TYPE;
2717: l_CustomerNumber hz_parties.party_id%TYPE;
2718: l_RemainingReceiptAmount fv_interim_cash_receipts.amount%TYPE;
2719: l_CashReceiptId ar_cash_receipts.cash_receipt_id%TYPE;
2720:
2721: l_CreateCashRec CreateCashRecType;
2722: l_NullCreateCashRec CreateCashRecType;
2723: l_OnAccountRec OnAccountRecType;