APPS.ARP_CHARGEBACK_COVER dependencies on RA_CUSTOMER_TRX

Line 54: x_doc_sequence_value OUT NOCOPY ra_customer_trx.doc_sequence_value%TYPE,

50: PROCEDURE create_chargeback (
51: p_chargeback_rec IN arp_chargeback_cover.Chargeback_Rec_Type,
52: p_init_msg_list IN VARCHAR2,
53: x_doc_sequence_id OUT NOCOPY NUMBER,
54: x_doc_sequence_value OUT NOCOPY ra_customer_trx.doc_sequence_value%TYPE,
55: x_trx_number OUT NOCOPY ra_customer_trx.trx_number%TYPE,
56: x_customer_trx_id OUT NOCOPY NUMBER,
57: x_return_status OUT NOCOPY VARCHAR2,
58: x_msg_count OUT NOCOPY NUMBER,

Line 55: x_trx_number OUT NOCOPY ra_customer_trx.trx_number%TYPE,

51: p_chargeback_rec IN arp_chargeback_cover.Chargeback_Rec_Type,
52: p_init_msg_list IN VARCHAR2,
53: x_doc_sequence_id OUT NOCOPY NUMBER,
54: x_doc_sequence_value OUT NOCOPY ra_customer_trx.doc_sequence_value%TYPE,
55: x_trx_number OUT NOCOPY ra_customer_trx.trx_number%TYPE,
56: x_customer_trx_id OUT NOCOPY NUMBER,
57: x_return_status OUT NOCOPY VARCHAR2,
58: x_msg_count OUT NOCOPY NUMBER,
59: x_msg_data OUT NOCOPY VARCHAR2)

Line 119: l_doc_sequence_value ra_customer_trx.doc_sequence_value%TYPE := NULL;

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;
122: l_new_application_id NUMBER;
123: l_new_app_ref_num ar_receivable_applications.application_ref_num%TYPE;

Line 120: l_trx_number ra_customer_trx.trx_number%TYPE;

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;
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;

Line 138: l_legal_entity_id ra_customer_trx.legal_entity_id%TYPE;

134: l_site_required_flag ar_system_parameters.site_required_flag%TYPE := 'N';
135: lp_bill_to_site_use_id NUMBER; --Stores the bill_to_site_id passed from claim
136: l_cb_trx_type ra_cust_trx_types.name%TYPE;
137: l_sequence_name fnd_document_sequences.name%TYPE;
138: l_legal_entity_id ra_customer_trx.legal_entity_id%TYPE;
139:
140: BEGIN
141: IF PG_DEBUG in ('Y', 'C') THEN
142: arp_standard.debug('arp_chargeback_cover.create_chargeback()+');

Line 413: FROM ra_customer_trx

409: trx_date
410: INTO l_customer_id,
411: l_bill_to_site_use_id ,
412: l_trx_date
413: FROM ra_customer_trx
414: WHERE customer_trx_id=l_customer_trx_id;
415: EXCEPTION
416: WHEN no_data_found THEN
417: FND_MESSAGE.SET_NAME('AR','AR_RAPI_TRX_NUM_INVALID');