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

Line 76: l_app_comments ar_receivable_applications.comments%TYPE;

72: l_amount NUMBER;
73: l_acctd_amount NUMBER;
74: l_bal_due_remaining NUMBER;
75: l_app_receivables_trx_id NUMBER;
76: l_app_comments ar_receivable_applications.comments%TYPE;
77: l_customer_reference ar_receivable_applications.customer_reference%TYPE;
78: l_claim_reason_name VARCHAR2(80);
79: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
80: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;

Line 77: l_customer_reference ar_receivable_applications.customer_reference%TYPE;

73: l_acctd_amount NUMBER;
74: l_bal_due_remaining NUMBER;
75: l_app_receivables_trx_id NUMBER;
76: l_app_comments ar_receivable_applications.comments%TYPE;
77: l_customer_reference ar_receivable_applications.customer_reference%TYPE;
78: l_claim_reason_name VARCHAR2(80);
79: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
80: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;
81: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;

Line 79: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;

75: l_app_receivables_trx_id NUMBER;
76: l_app_comments ar_receivable_applications.comments%TYPE;
77: l_customer_reference ar_receivable_applications.customer_reference%TYPE;
78: l_claim_reason_name VARCHAR2(80);
79: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
80: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;
81: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
82: l_application_ref_id NUMBER;
83: l_dum_app_ref_type ar_receivable_applications.application_ref_type%TYPE;

Line 80: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;

76: l_app_comments ar_receivable_applications.comments%TYPE;
77: l_customer_reference ar_receivable_applications.customer_reference%TYPE;
78: l_claim_reason_name VARCHAR2(80);
79: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
80: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;
81: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
82: l_application_ref_id NUMBER;
83: l_dum_app_ref_type ar_receivable_applications.application_ref_type%TYPE;
84: l_dum_app_ref_id NUMBER;

Line 81: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;

77: l_customer_reference ar_receivable_applications.customer_reference%TYPE;
78: l_claim_reason_name VARCHAR2(80);
79: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
80: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;
81: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
82: l_application_ref_id NUMBER;
83: l_dum_app_ref_type ar_receivable_applications.application_ref_type%TYPE;
84: l_dum_app_ref_id NUMBER;
85: l_dum_app_ref_num ar_receivable_applications.application_ref_num%TYPE;

Line 83: l_dum_app_ref_type ar_receivable_applications.application_ref_type%TYPE;

79: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
80: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;
81: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
82: l_application_ref_id NUMBER;
83: l_dum_app_ref_type ar_receivable_applications.application_ref_type%TYPE;
84: l_dum_app_ref_id NUMBER;
85: l_dum_app_ref_num ar_receivable_applications.application_ref_num%TYPE;
86: l_dum_sec_app_ref_id NUMBER;
87: l_payment_set_id NUMBER;

Line 85: l_dum_app_ref_num ar_receivable_applications.application_ref_num%TYPE;

81: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
82: l_application_ref_id NUMBER;
83: l_dum_app_ref_type ar_receivable_applications.application_ref_type%TYPE;
84: l_dum_app_ref_id NUMBER;
85: l_dum_app_ref_num ar_receivable_applications.application_ref_num%TYPE;
86: l_dum_sec_app_ref_id NUMBER;
87: l_payment_set_id NUMBER;
88: l_attribute_rec AR_Receipt_API_PUB.attribute_rec_type;
89: l_global_attribute_rec AR_Receipt_API_PUB.global_attribute_rec_type;

Line 117: l_new_claim_num ar_receivable_applications.application_ref_num%TYPE;

113: l_default_gl_date DATE;
114: l_defaulting_rule_used VARCHAR2(50);
115: l_customer_trx_id NUMBER;
116: l_installment ar_payment_schedules.terms_sequence_number%TYPE;
117: l_new_claim_num ar_receivable_applications.application_ref_num%TYPE;
118: l_doc_sequence_id NUMBER := NULL;
119: l_doc_sequence_value ra_customer_trx.doc_sequence_value%TYPE := NULL;
120: l_trx_number ra_customer_trx.trx_number%TYPE;
121: l_new_customer_trx_id NUMBER;

Line 123: l_new_app_ref_num ar_receivable_applications.application_ref_num%TYPE;

119: l_doc_sequence_value ra_customer_trx.doc_sequence_value%TYPE := NULL;
120: l_trx_number ra_customer_trx.trx_number%TYPE;
121: l_new_customer_trx_id NUMBER;
122: l_new_application_id NUMBER;
123: l_new_app_ref_num ar_receivable_applications.application_ref_num%TYPE;
124: l_new_app_ref_id ar_receivable_applications.application_ref_id%TYPE;
125: l_balance NUMBER := 0;
126: l_functional_curr VARCHAR2(100);
127: l_error_message VARCHAR2(2000);

Line 124: l_new_app_ref_id ar_receivable_applications.application_ref_id%TYPE;

120: l_trx_number ra_customer_trx.trx_number%TYPE;
121: l_new_customer_trx_id NUMBER;
122: l_new_application_id NUMBER;
123: l_new_app_ref_num ar_receivable_applications.application_ref_num%TYPE;
124: l_new_app_ref_id ar_receivable_applications.application_ref_id%TYPE;
125: l_balance NUMBER := 0;
126: l_functional_curr VARCHAR2(100);
127: l_error_message VARCHAR2(2000);
128: l_error_count NUMBER := 0;

Line 378: , ar_receivable_applications app

374: , l_global_attribute_rec.global_attribute18
375: , l_global_attribute_rec.global_attribute19
376: , l_global_attribute_rec.global_attribute20
377: FROM ar_payment_schedules ps
378: , ar_receivable_applications app
379: WHERE app.applied_payment_schedule_id = ps.payment_schedule_id
380: AND app.secondary_application_ref_id = p_chargeback_rec.secondary_application_ref_id
381: AND app.application_ref_type = p_chargeback_rec.application_ref_type
382: AND app.applied_payment_schedule_id = ps.payment_schedule_id