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.ARP_PROCESS_MISC_RECEIPTS dependencies on AR_CASH_RECEIPT_HISTORY

Line 64: | ar_cash_receipt_history as rows from the |

60: | updated for the history record while a Misc |
61: | receipt is updated
62: | 14-OCT-04 JBECKETT Bug 3911642: Check for unposted entries |
63: | is on ar_misc_cash_distributions not |
64: | ar_cash_receipt_history as rows from the |
65: | former are deleted/recreated. |
66: | 20-MAY-05 JBECKETT Added p_legal_entity_id for R12 LE uptake |
67: +===========================================================================*/
68:

Line 185: l_crh_rec ar_cash_receipt_history%ROWTYPE;

181: p_gl_tax_acct IN VARCHAR2, /* Bug fix 2300268 */
182: p_legal_entity_id IN NUMBER ) IS
183:
184: l_cr_rec ar_cash_receipts%ROWTYPE;
185: l_crh_rec ar_cash_receipt_history%ROWTYPE;
186: l_dist_rec ar_distributions%ROWTYPE;
187: l_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
188: l_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;
189: l_override_dummy ar_cash_receipts.override_remit_account_flag%TYPE;

Line 187: l_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;

183:
184: l_cr_rec ar_cash_receipts%ROWTYPE;
185: l_crh_rec ar_cash_receipt_history%ROWTYPE;
186: l_dist_rec ar_distributions%ROWTYPE;
187: l_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
188: l_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;
189: l_override_dummy ar_cash_receipts.override_remit_account_flag%TYPE;
190: l_dummy NUMBER;
191: l_source_type ar_distributions.source_type%TYPE;

Line 188: l_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;

184: l_cr_rec ar_cash_receipts%ROWTYPE;
185: l_crh_rec ar_cash_receipt_history%ROWTYPE;
186: l_dist_rec ar_distributions%ROWTYPE;
187: l_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
188: l_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;
189: l_override_dummy ar_cash_receipts.override_remit_account_flag%TYPE;
190: l_dummy NUMBER;
191: l_source_type ar_distributions.source_type%TYPE;
192: l_creation_status ar_cash_receipt_history.status%TYPE;

Line 192: l_creation_status ar_cash_receipt_history.status%TYPE;

188: l_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;
189: l_override_dummy ar_cash_receipts.override_remit_account_flag%TYPE;
190: l_dummy NUMBER;
191: l_source_type ar_distributions.source_type%TYPE;
192: l_creation_status ar_cash_receipt_history.status%TYPE;
193: l_old_distribution_set_id ar_cash_receipts.distribution_set_id%TYPE;
194: l_dist_set_changed_flag BOOLEAN;
195: l_amount_changed_flag BOOLEAN;
196: l_gl_date_changed_flag BOOLEAN;

Line 199: l_rev_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

195: l_amount_changed_flag BOOLEAN;
196: l_gl_date_changed_flag BOOLEAN;
197: l_receipt_date_changed_flag BOOLEAN;
198: l_old_receivables_trx_id ar_receivables_trx.receivables_trx_id%TYPE;
199: l_rev_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
200: l_ae_doc_rec l_ae_doc_rec_type;
201: l_posted ar_cash_receipt_history.posting_control_id%TYPE;
202: l_unposted_count NUMBER;
203:

Line 201: l_posted ar_cash_receipt_history.posting_control_id%TYPE;

197: l_receipt_date_changed_flag BOOLEAN;
198: l_old_receivables_trx_id ar_receivables_trx.receivables_trx_id%TYPE;
199: l_rev_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
200: l_ae_doc_rec l_ae_doc_rec_type;
201: l_posted ar_cash_receipt_history.posting_control_id%TYPE;
202: l_unposted_count NUMBER;
203:
204: BEGIN
205:

Line 597: ar_cash_receipt_history crh_current,

593: p_new_status_dsp,
594: p_new_state,
595: p_new_state_dsp
596: FROM
597: ar_cash_receipt_history crh_current,
598: ar_cash_receipts cr,
599: ar_lookups l_cr_status,
600: ar_lookups l_crh_status
601: WHERE

Line 744: l_creation_status ar_cash_receipt_history.status%TYPE;

740: p_gl_tax_acct IN VARCHAR2 , /* Bug fix 2300268 */
741: p_crh_id OUT NOCOPY NUMBER, /* Bug fix 2742388 */
742: p_legal_entity_id IN NUMBER,
743: p_payment_trxn_extension_id IN ar_cash_receipts.payment_trxn_extension_id%TYPE ) IS
744: l_creation_status ar_cash_receipt_history.status%TYPE;
745: l_cr_rec ar_cash_receipts%ROWTYPE;
746: l_crh_rec ar_cash_receipt_history%ROWTYPE;
747: l_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;
748: l_source_type ar_distributions.source_type%TYPE;

Line 746: l_crh_rec ar_cash_receipt_history%ROWTYPE;

742: p_legal_entity_id IN NUMBER,
743: p_payment_trxn_extension_id IN ar_cash_receipts.payment_trxn_extension_id%TYPE ) IS
744: l_creation_status ar_cash_receipt_history.status%TYPE;
745: l_cr_rec ar_cash_receipts%ROWTYPE;
746: l_crh_rec ar_cash_receipt_history%ROWTYPE;
747: l_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;
748: l_source_type ar_distributions.source_type%TYPE;
749: l_override_remit_account_flag
750: ar_receipt_method_accounts.override_remit_account_flag%TYPE;

Line 747: l_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;

743: p_payment_trxn_extension_id IN ar_cash_receipts.payment_trxn_extension_id%TYPE ) IS
744: l_creation_status ar_cash_receipt_history.status%TYPE;
745: l_cr_rec ar_cash_receipts%ROWTYPE;
746: l_crh_rec ar_cash_receipt_history%ROWTYPE;
747: l_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;
748: l_source_type ar_distributions.source_type%TYPE;
749: l_override_remit_account_flag
750: ar_receipt_method_accounts.override_remit_account_flag%TYPE;
751: l_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;

Line 751: l_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;

747: l_ccid ar_cash_receipt_history.account_code_combination_id%TYPE;
748: l_source_type ar_distributions.source_type%TYPE;
749: l_override_remit_account_flag
750: ar_receipt_method_accounts.override_remit_account_flag%TYPE;
751: l_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
752: l_dummy NUMBER;
753: l_ae_doc_rec l_ae_doc_rec_type;
754: l_called_from_api varchar2(1);
755: l_legal_entity_id NUMBER;