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,
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,
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,
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,
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,
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,
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,
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,
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
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:
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
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:
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()+');