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,

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,
141: p_on_acct_cust_id IN ar_receivable_applications.on_acct_cust_id%TYPE DEFAULT NULL,

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,
141: p_on_acct_cust_id IN ar_receivable_applications.on_acct_cust_id%TYPE DEFAULT NULL,
142: p_on_acct_cust_site_use_id IN ar_receivable_applications.on_acct_cust_site_use_id%TYPE DEFAULT NULL,

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,
141: p_on_acct_cust_id IN ar_receivable_applications.on_acct_cust_id%TYPE DEFAULT NULL,
142: p_on_acct_cust_site_use_id IN ar_receivable_applications.on_acct_cust_site_use_id%TYPE DEFAULT NULL,
143: p_on_acct_po_num IN ar_receivable_applications.on_acct_po_num%TYPE DEFAULT NULL

Line 141: p_on_acct_cust_id IN ar_receivable_applications.on_acct_cust_id%TYPE DEFAULT NULL,

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,
141: p_on_acct_cust_id IN ar_receivable_applications.on_acct_cust_id%TYPE DEFAULT NULL,
142: p_on_acct_cust_site_use_id IN ar_receivable_applications.on_acct_cust_site_use_id%TYPE DEFAULT NULL,
143: p_on_acct_po_num IN ar_receivable_applications.on_acct_po_num%TYPE DEFAULT NULL
144: ) IS
145:

Line 142: p_on_acct_cust_site_use_id IN ar_receivable_applications.on_acct_cust_site_use_id%TYPE DEFAULT NULL,

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,
141: p_on_acct_cust_id IN ar_receivable_applications.on_acct_cust_id%TYPE DEFAULT NULL,
142: p_on_acct_cust_site_use_id IN ar_receivable_applications.on_acct_cust_site_use_id%TYPE DEFAULT NULL,
143: p_on_acct_po_num IN ar_receivable_applications.on_acct_po_num%TYPE DEFAULT NULL
144: ) IS
145:
146: l_rec_ra_rec ar_receivable_applications%ROWTYPE;

Line 143: p_on_acct_po_num IN ar_receivable_applications.on_acct_po_num%TYPE DEFAULT NULL

139: p_applied_rec_app_id IN ar_receivable_applications.applied_rec_app_id%TYPE,
140: x_claim_reason_name OUT NOCOPY VARCHAR2,
141: p_on_acct_cust_id IN ar_receivable_applications.on_acct_cust_id%TYPE DEFAULT NULL,
142: p_on_acct_cust_site_use_id IN ar_receivable_applications.on_acct_cust_site_use_id%TYPE DEFAULT NULL,
143: p_on_acct_po_num IN ar_receivable_applications.on_acct_po_num%TYPE DEFAULT NULL
144: ) IS
145:
146: l_rec_ra_rec ar_receivable_applications%ROWTYPE;
147: l_currency_code ar_cash_receipts.currency_code%TYPE;

Line 146: l_rec_ra_rec ar_receivable_applications%ROWTYPE;

142: p_on_acct_cust_site_use_id IN ar_receivable_applications.on_acct_cust_site_use_id%TYPE DEFAULT NULL,
143: p_on_acct_po_num IN ar_receivable_applications.on_acct_po_num%TYPE DEFAULT NULL
144: ) IS
145:
146: l_rec_ra_rec ar_receivable_applications%ROWTYPE;
147: l_currency_code ar_cash_receipts.currency_code%TYPE;
148: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
149: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
150: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;

Line 491: from ar_receivable_applications app

487:
488: CURSOR get_app_C(l_app_id NUMBER) IS
489: select app.receivable_application_id app_id,
490: app.cash_receipt_id cr_id
491: from ar_receivable_applications app
492: where app.receivable_application_id = l_app_id
493: and nvl(app.confirmed_flag,'Y') = 'Y' --confirmed records have accounting only
494: and exists (select 'x'
495: from ar_distributions ard

Line 500: lr_ra_rec ar_receivable_applications%ROWTYPE;

496: where ard.source_table = 'RA'
497: and ard.source_id = app.receivable_application_id);
498:
499: lr_ps_rec ar_payment_schedules%ROWTYPE;
500: lr_ra_rec ar_receivable_applications%ROWTYPE;
501:
502: ln_amount_applied NUMBER;
503: ln_acctd_amount_applied_from NUMBER;
504: ln_cash_receipt_id NUMBER;

Line 537: from ar_receivable_applications ra

533: ra.acctd_amount_applied_from
534: into ln_cash_receipt_id,
535: ln_amount_applied,
536: ln_acctd_amount_applied_from
537: from ar_receivable_applications ra
538: where ra.receivable_application_id = p_ra_id;
539:
540: --
541: --Release 11.5 delete child accounting records associated with

Line 567: p_table_name => 'AR_RECEIVABLE_APPLICATIONS',

563: +---------------------------------*/
564:
565: ar_mrc_engine.maintain_mrc_data(
566: p_event_mode => 'DELETE',
567: p_table_name => 'AR_RECEIVABLE_APPLICATIONS',
568: p_mode => 'SINGLE',
569: p_key_value => p_ra_id);
570:
571: --Bug#2750340

Line 600: from ar_receivable_applications ra

596: END IF;
597: -- Get the receivable application id for the UNAPP row.
598: select ra.receivable_application_id
599: into ln_unapp_ra_id
600: from ar_receivable_applications ra
601: where ra.cash_receipt_id = ln_cash_receipt_id
602: and ra.status = 'UNAPP';
603:
604: IF PG_DEBUG in ('Y', 'C') THEN

Line 680: | on ar_receivable_applications_all

Line 701: p_on_acct_cust_id IN ar_receivable_applications.on_acct_cust_id%TYPE DEFAULT NULL,

697: | 28/03/2006 Surendra Rajan Created - Enh: 4696620
698: +===========================================================================*/
699: PROCEDURE update_onacct_cust_app(
700: p_ra_id IN NUMBER,
701: p_on_acct_cust_id IN ar_receivable_applications.on_acct_cust_id%TYPE DEFAULT NULL,
702: p_on_acct_cust_site_use_id IN ar_receivable_applications.on_acct_cust_site_use_id%TYPE DEFAULT NULL,
703: p_on_acct_po_num IN ar_receivable_applications.on_acct_po_num%TYPE DEFAULT NULL
704: ) IS
705: l_ra_rec ar_receivable_applications%ROWTYPE;

Line 702: p_on_acct_cust_site_use_id IN ar_receivable_applications.on_acct_cust_site_use_id%TYPE DEFAULT NULL,

698: +===========================================================================*/
699: PROCEDURE update_onacct_cust_app(
700: p_ra_id IN NUMBER,
701: p_on_acct_cust_id IN ar_receivable_applications.on_acct_cust_id%TYPE DEFAULT NULL,
702: p_on_acct_cust_site_use_id IN ar_receivable_applications.on_acct_cust_site_use_id%TYPE DEFAULT NULL,
703: p_on_acct_po_num IN ar_receivable_applications.on_acct_po_num%TYPE DEFAULT NULL
704: ) IS
705: l_ra_rec ar_receivable_applications%ROWTYPE;
706:

Line 703: p_on_acct_po_num IN ar_receivable_applications.on_acct_po_num%TYPE DEFAULT NULL

699: PROCEDURE update_onacct_cust_app(
700: p_ra_id IN NUMBER,
701: p_on_acct_cust_id IN ar_receivable_applications.on_acct_cust_id%TYPE DEFAULT NULL,
702: p_on_acct_cust_site_use_id IN ar_receivable_applications.on_acct_cust_site_use_id%TYPE DEFAULT NULL,
703: p_on_acct_po_num IN ar_receivable_applications.on_acct_po_num%TYPE DEFAULT NULL
704: ) IS
705: l_ra_rec ar_receivable_applications%ROWTYPE;
706:
707: Begin

Line 705: l_ra_rec ar_receivable_applications%ROWTYPE;

701: p_on_acct_cust_id IN ar_receivable_applications.on_acct_cust_id%TYPE DEFAULT NULL,
702: p_on_acct_cust_site_use_id IN ar_receivable_applications.on_acct_cust_site_use_id%TYPE DEFAULT NULL,
703: p_on_acct_po_num IN ar_receivable_applications.on_acct_po_num%TYPE DEFAULT NULL
704: ) IS
705: l_ra_rec ar_receivable_applications%ROWTYPE;
706:
707: Begin
708: IF PG_DEBUG in ('Y', 'C') THEN
709: arp_standard.debug( 'arp_process_application.update_onacct_cust_app()+');