DBA Data[Home] [Help]

APPS.ARP_PROCESS_RECUR_COVER dependencies on RA_RECUR_INTERIM

Line 6: p_customer_trx_id IN ra_recur_interim.customer_trx_id%type,

2: /* $Header: ARTERCCB.pls 120.4 2006/01/17 15:36:38 vcrisost ship $ */
3:
4: PROCEDURE insert_recur_cover( p_form_name IN varchar2 ,
5: p_form_version IN number,
6: p_customer_trx_id IN ra_recur_interim.customer_trx_id%type,
7: p_trx_number IN ra_recur_interim.trx_number%type,
8: p_trx_date IN ra_recur_interim.trx_date%type,
9: p_term_due_date IN ra_recur_interim.term_due_date%type,
10: p_gl_date IN ra_recur_interim.gl_date%type,

Line 7: p_trx_number IN ra_recur_interim.trx_number%type,

3:
4: PROCEDURE insert_recur_cover( p_form_name IN varchar2 ,
5: p_form_version IN number,
6: p_customer_trx_id IN ra_recur_interim.customer_trx_id%type,
7: p_trx_number IN ra_recur_interim.trx_number%type,
8: p_trx_date IN ra_recur_interim.trx_date%type,
9: p_term_due_date IN ra_recur_interim.term_due_date%type,
10: p_gl_date IN ra_recur_interim.gl_date%type,
11: p_term_discount_date IN ra_recur_interim.term_discount_date%type,

Line 8: p_trx_date IN ra_recur_interim.trx_date%type,

4: PROCEDURE insert_recur_cover( p_form_name IN varchar2 ,
5: p_form_version IN number,
6: p_customer_trx_id IN ra_recur_interim.customer_trx_id%type,
7: p_trx_number IN ra_recur_interim.trx_number%type,
8: p_trx_date IN ra_recur_interim.trx_date%type,
9: p_term_due_date IN ra_recur_interim.term_due_date%type,
10: p_gl_date IN ra_recur_interim.gl_date%type,
11: p_term_discount_date IN ra_recur_interim.term_discount_date%type,
12: p_request_id IN ra_recur_interim.request_id%type,

Line 9: p_term_due_date IN ra_recur_interim.term_due_date%type,

5: p_form_version IN number,
6: p_customer_trx_id IN ra_recur_interim.customer_trx_id%type,
7: p_trx_number IN ra_recur_interim.trx_number%type,
8: p_trx_date IN ra_recur_interim.trx_date%type,
9: p_term_due_date IN ra_recur_interim.term_due_date%type,
10: p_gl_date IN ra_recur_interim.gl_date%type,
11: p_term_discount_date IN ra_recur_interim.term_discount_date%type,
12: p_request_id IN ra_recur_interim.request_id%type,
13: p_doc_sequence_value IN ra_recur_interim.doc_sequence_value%type,

Line 10: p_gl_date IN ra_recur_interim.gl_date%type,

6: p_customer_trx_id IN ra_recur_interim.customer_trx_id%type,
7: p_trx_number IN ra_recur_interim.trx_number%type,
8: p_trx_date IN ra_recur_interim.trx_date%type,
9: p_term_due_date IN ra_recur_interim.term_due_date%type,
10: p_gl_date IN ra_recur_interim.gl_date%type,
11: p_term_discount_date IN ra_recur_interim.term_discount_date%type,
12: p_request_id IN ra_recur_interim.request_id%type,
13: p_doc_sequence_value IN ra_recur_interim.doc_sequence_value%type,
14: p_new_customer_trx_id IN ra_recur_interim.new_customer_trx_id%type,

Line 11: p_term_discount_date IN ra_recur_interim.term_discount_date%type,

7: p_trx_number IN ra_recur_interim.trx_number%type,
8: p_trx_date IN ra_recur_interim.trx_date%type,
9: p_term_due_date IN ra_recur_interim.term_due_date%type,
10: p_gl_date IN ra_recur_interim.gl_date%type,
11: p_term_discount_date IN ra_recur_interim.term_discount_date%type,
12: p_request_id IN ra_recur_interim.request_id%type,
13: p_doc_sequence_value IN ra_recur_interim.doc_sequence_value%type,
14: p_new_customer_trx_id IN ra_recur_interim.new_customer_trx_id%type,
15: p_batch_source_id IN ra_batch_sources.batch_source_id%type,

Line 12: p_request_id IN ra_recur_interim.request_id%type,

8: p_trx_date IN ra_recur_interim.trx_date%type,
9: p_term_due_date IN ra_recur_interim.term_due_date%type,
10: p_gl_date IN ra_recur_interim.gl_date%type,
11: p_term_discount_date IN ra_recur_interim.term_discount_date%type,
12: p_request_id IN ra_recur_interim.request_id%type,
13: p_doc_sequence_value IN ra_recur_interim.doc_sequence_value%type,
14: p_new_customer_trx_id IN ra_recur_interim.new_customer_trx_id%type,
15: p_batch_source_id IN ra_batch_sources.batch_source_id%type,
16: p_cust_trx_type_id IN number,

Line 13: p_doc_sequence_value IN ra_recur_interim.doc_sequence_value%type,

9: p_term_due_date IN ra_recur_interim.term_due_date%type,
10: p_gl_date IN ra_recur_interim.gl_date%type,
11: p_term_discount_date IN ra_recur_interim.term_discount_date%type,
12: p_request_id IN ra_recur_interim.request_id%type,
13: p_doc_sequence_value IN ra_recur_interim.doc_sequence_value%type,
14: p_new_customer_trx_id IN ra_recur_interim.new_customer_trx_id%type,
15: p_batch_source_id IN ra_batch_sources.batch_source_id%type,
16: p_cust_trx_type_id IN number,
17: p_trx_no OUT NOCOPY ra_recur_interim.trx_number%type,

Line 14: p_new_customer_trx_id IN ra_recur_interim.new_customer_trx_id%type,

10: p_gl_date IN ra_recur_interim.gl_date%type,
11: p_term_discount_date IN ra_recur_interim.term_discount_date%type,
12: p_request_id IN ra_recur_interim.request_id%type,
13: p_doc_sequence_value IN ra_recur_interim.doc_sequence_value%type,
14: p_new_customer_trx_id IN ra_recur_interim.new_customer_trx_id%type,
15: p_batch_source_id IN ra_batch_sources.batch_source_id%type,
16: p_cust_trx_type_id IN number,
17: p_trx_no OUT NOCOPY ra_recur_interim.trx_number%type,
18: p_billing_date IN ra_recur_interim.billing_date%type DEFAULT NULL) IS

Line 17: p_trx_no OUT NOCOPY ra_recur_interim.trx_number%type,

13: p_doc_sequence_value IN ra_recur_interim.doc_sequence_value%type,
14: p_new_customer_trx_id IN ra_recur_interim.new_customer_trx_id%type,
15: p_batch_source_id IN ra_batch_sources.batch_source_id%type,
16: p_cust_trx_type_id IN number,
17: p_trx_no OUT NOCOPY ra_recur_interim.trx_number%type,
18: p_billing_date IN ra_recur_interim.billing_date%type DEFAULT NULL) IS
19: l_rec_rec ra_recur_interim%rowtype;
20: l_trx_no ra_recur_interim.trx_number%type;
21:

Line 18: p_billing_date IN ra_recur_interim.billing_date%type DEFAULT NULL) IS

14: p_new_customer_trx_id IN ra_recur_interim.new_customer_trx_id%type,
15: p_batch_source_id IN ra_batch_sources.batch_source_id%type,
16: p_cust_trx_type_id IN number,
17: p_trx_no OUT NOCOPY ra_recur_interim.trx_number%type,
18: p_billing_date IN ra_recur_interim.billing_date%type DEFAULT NULL) IS
19: l_rec_rec ra_recur_interim%rowtype;
20: l_trx_no ra_recur_interim.trx_number%type;
21:
22: Begin

Line 19: l_rec_rec ra_recur_interim%rowtype;

15: p_batch_source_id IN ra_batch_sources.batch_source_id%type,
16: p_cust_trx_type_id IN number,
17: p_trx_no OUT NOCOPY ra_recur_interim.trx_number%type,
18: p_billing_date IN ra_recur_interim.billing_date%type DEFAULT NULL) IS
19: l_rec_rec ra_recur_interim%rowtype;
20: l_trx_no ra_recur_interim.trx_number%type;
21:
22: Begin
23:

Line 20: l_trx_no ra_recur_interim.trx_number%type;

16: p_cust_trx_type_id IN number,
17: p_trx_no OUT NOCOPY ra_recur_interim.trx_number%type,
18: p_billing_date IN ra_recur_interim.billing_date%type DEFAULT NULL) IS
19: l_rec_rec ra_recur_interim%rowtype;
20: l_trx_no ra_recur_interim.trx_number%type;
21:
22: Begin
23:
24: arp_util.debug('arp_recur_inv.insert_recur_cover()+');