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_APPLICATION2 dependencies on AR_RECEIVABLE_APPLICATIONS

Line 76: ar_receivable_applications.application_ref_type%TYPE,

72: p_receipt_ps_id IN NUMBER,
73: p_invoice_ps_id IN NUMBER,
74: p_ussgl_transaction_code IN VARCHAR2,
75: p_application_ref_type IN
76: ar_receivable_applications.application_ref_type%TYPE,
77: p_application_ref_id IN
78: ar_receivable_applications.application_ref_id%TYPE,
79: p_application_ref_num IN
80: ar_receivable_applications.application_ref_num%TYPE,

Line 78: ar_receivable_applications.application_ref_id%TYPE,

74: p_ussgl_transaction_code IN VARCHAR2,
75: p_application_ref_type IN
76: ar_receivable_applications.application_ref_type%TYPE,
77: p_application_ref_id IN
78: ar_receivable_applications.application_ref_id%TYPE,
79: p_application_ref_num IN
80: ar_receivable_applications.application_ref_num%TYPE,
81: p_secondary_application_ref_id IN
82: ar_receivable_applications.secondary_application_ref_id%TYPE,

Line 80: ar_receivable_applications.application_ref_num%TYPE,

76: ar_receivable_applications.application_ref_type%TYPE,
77: p_application_ref_id IN
78: ar_receivable_applications.application_ref_id%TYPE,
79: p_application_ref_num IN
80: ar_receivable_applications.application_ref_num%TYPE,
81: p_secondary_application_ref_id IN
82: ar_receivable_applications.secondary_application_ref_id%TYPE,
83: p_receivable_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
84: p_attribute_category IN VARCHAR2,

Line 82: ar_receivable_applications.secondary_application_ref_id%TYPE,

78: ar_receivable_applications.application_ref_id%TYPE,
79: p_application_ref_num IN
80: ar_receivable_applications.application_ref_num%TYPE,
81: p_secondary_application_ref_id IN
82: ar_receivable_applications.secondary_application_ref_id%TYPE,
83: p_receivable_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
84: p_attribute_category IN VARCHAR2,
85: p_attribute1 IN VARCHAR2,
86: p_attribute2 IN VARCHAR2,

Line 83: p_receivable_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,

79: p_application_ref_num IN
80: ar_receivable_applications.application_ref_num%TYPE,
81: p_secondary_application_ref_id IN
82: ar_receivable_applications.secondary_application_ref_id%TYPE,
83: p_receivable_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
84: p_attribute_category IN VARCHAR2,
85: p_attribute1 IN VARCHAR2,
86: p_attribute2 IN VARCHAR2,
87: p_attribute3 IN VARCHAR2,

Line 127: ar_receivable_applications.application_ref_id%TYPE,

123: p_customer_trx_line_id IN NUMBER,
124: p_module_name IN VARCHAR2,
125: p_module_version IN VARCHAR2,
126: x_application_ref_id OUT NOCOPY
127: ar_receivable_applications.application_ref_id%TYPE,
128: x_application_ref_num OUT NOCOPY
129: ar_receivable_applications.application_ref_num%TYPE,
130: x_return_status OUT NOCOPY VARCHAR2,
131: x_msg_count OUT NOCOPY NUMBER,

Line 129: ar_receivable_applications.application_ref_num%TYPE,

125: p_module_version IN VARCHAR2,
126: x_application_ref_id OUT NOCOPY
127: ar_receivable_applications.application_ref_id%TYPE,
128: x_application_ref_num OUT NOCOPY
129: ar_receivable_applications.application_ref_num%TYPE,
130: x_return_status OUT NOCOPY VARCHAR2,
131: x_msg_count OUT NOCOPY NUMBER,
132: x_msg_data OUT NOCOPY VARCHAR2,
133: p_acctd_amount_applied_to OUT NOCOPY NUMBER,

Line 136: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE,

132: x_msg_data OUT NOCOPY VARCHAR2,
133: p_acctd_amount_applied_to OUT NOCOPY NUMBER,
134: p_acctd_amount_applied_from OUT NOCOPY NUMBER,
135: p_amount_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,
136: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE,
137: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
138: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE,
139: p_applied_rec_app_id IN ar_receivable_applications.applied_rec_app_id%TYPE,
140: x_claim_reason_name OUT NOCOPY VARCHAR2) IS

Line 137: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,

133: p_acctd_amount_applied_to OUT NOCOPY NUMBER,
134: p_acctd_amount_applied_from OUT NOCOPY NUMBER,
135: p_amount_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,
136: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE,
137: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
138: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE,
139: p_applied_rec_app_id IN ar_receivable_applications.applied_rec_app_id%TYPE,
140: x_claim_reason_name OUT NOCOPY VARCHAR2) IS
141:

Line 138: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE,

134: p_acctd_amount_applied_from OUT NOCOPY NUMBER,
135: p_amount_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,
136: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE,
137: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
138: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE,
139: p_applied_rec_app_id IN ar_receivable_applications.applied_rec_app_id%TYPE,
140: x_claim_reason_name OUT NOCOPY VARCHAR2) IS
141:
142: l_rec_ra_rec ar_receivable_applications%ROWTYPE;

Line 139: p_applied_rec_app_id IN ar_receivable_applications.applied_rec_app_id%TYPE,

135: p_amount_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,
136: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE,
137: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
138: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE,
139: p_applied_rec_app_id IN ar_receivable_applications.applied_rec_app_id%TYPE,
140: x_claim_reason_name OUT NOCOPY VARCHAR2) IS
141:
142: l_rec_ra_rec ar_receivable_applications%ROWTYPE;
143: l_currency_code ar_cash_receipts.currency_code%TYPE;

Line 142: l_rec_ra_rec ar_receivable_applications%ROWTYPE;

138: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE,
139: p_applied_rec_app_id IN ar_receivable_applications.applied_rec_app_id%TYPE,
140: x_claim_reason_name OUT NOCOPY VARCHAR2) IS
141:
142: l_rec_ra_rec ar_receivable_applications%ROWTYPE;
143: l_currency_code ar_cash_receipts.currency_code%TYPE;
144: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
145: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
146: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;

Line 480: from ar_receivable_applications app

476:
477: CURSOR get_app_C(l_app_id NUMBER) IS
478: select app.receivable_application_id app_id,
479: app.cash_receipt_id cr_id
480: from ar_receivable_applications app
481: where app.receivable_application_id = l_app_id
482: and nvl(app.confirmed_flag,'Y') = 'Y' --confirmed records have accounting only
483: and exists (select 'x'
484: from ar_distributions ard

Line 489: lr_ra_rec ar_receivable_applications%ROWTYPE;

485: where ard.source_table = 'RA'
486: and ard.source_id = app.receivable_application_id);
487:
488: lr_ps_rec ar_payment_schedules%ROWTYPE;
489: lr_ra_rec ar_receivable_applications%ROWTYPE;
490:
491: ln_amount_applied NUMBER;
492: ln_acctd_amount_applied_from NUMBER;
493: ln_cash_receipt_id NUMBER;

Line 526: from ar_receivable_applications ra

522: ra.acctd_amount_applied_from
523: into ln_cash_receipt_id,
524: ln_amount_applied,
525: ln_acctd_amount_applied_from
526: from ar_receivable_applications ra
527: where ra.receivable_application_id = p_ra_id;
528:
529: --
530: --Release 11.5 delete child accounting records associated with

Line 556: p_table_name => 'AR_RECEIVABLE_APPLICATIONS',

552: +---------------------------------*/
553:
554: ar_mrc_engine.maintain_mrc_data(
555: p_event_mode => 'DELETE',
556: p_table_name => 'AR_RECEIVABLE_APPLICATIONS',
557: p_mode => 'SINGLE',
558: p_key_value => p_ra_id);
559:
560: --Bug#2750340

Line 589: from ar_receivable_applications ra

585: END IF;
586: -- Get the receivable application id for the UNAPP row.
587: select ra.receivable_application_id
588: into ln_unapp_ra_id
589: from ar_receivable_applications ra
590: where ra.cash_receipt_id = ln_cash_receipt_id
591: and ra.status = 'UNAPP';
592:
593: IF PG_DEBUG in ('Y', 'C') THEN