7: pg_prog_appl_id number;
8: pg_conc_program_id number;
9:
10: PROCEDURE insert_interim(
11: p_customer_trx_id IN ra_recur_interim.customer_trx_id%type,
12: p_trx_date IN DATE,
13: p_term_due_date IN DATE,
14: p_gl_date IN DATE,
15: p_term_discount_date IN DATE,
12: p_trx_date IN DATE,
13: p_term_due_date IN DATE,
14: p_gl_date IN DATE,
15: p_term_discount_date IN DATE,
16: p_request_id IN ra_recur_interim.request_id%type,
17: p_doc_sequence_value IN ra_recur_interim.doc_sequence_value%type,
18: p_new_customer_trx_id IN ra_recur_interim.new_customer_trx_id%type,
19: p_batch_source_id IN ra_batch_sources.batch_source_id%type,
20: p_trx_number_out OUT ra_recur_interim.trx_number%type) IS
13: p_term_due_date IN DATE,
14: p_gl_date IN DATE,
15: p_term_discount_date IN DATE,
16: p_request_id IN ra_recur_interim.request_id%type,
17: p_doc_sequence_value IN ra_recur_interim.doc_sequence_value%type,
18: p_new_customer_trx_id IN ra_recur_interim.new_customer_trx_id%type,
19: p_batch_source_id IN ra_batch_sources.batch_source_id%type,
20: p_trx_number_out OUT ra_recur_interim.trx_number%type) IS
21:
14: p_gl_date IN DATE,
15: p_term_discount_date IN DATE,
16: p_request_id IN ra_recur_interim.request_id%type,
17: p_doc_sequence_value IN ra_recur_interim.doc_sequence_value%type,
18: p_new_customer_trx_id IN ra_recur_interim.new_customer_trx_id%type,
19: p_batch_source_id IN ra_batch_sources.batch_source_id%type,
20: p_trx_number_out OUT ra_recur_interim.trx_number%type) IS
21:
22: l_country_code VARCHAR2(2);
16: p_request_id IN ra_recur_interim.request_id%type,
17: p_doc_sequence_value IN ra_recur_interim.doc_sequence_value%type,
18: p_new_customer_trx_id IN ra_recur_interim.new_customer_trx_id%type,
19: p_batch_source_id IN ra_batch_sources.batch_source_id%type,
20: p_trx_number_out OUT ra_recur_interim.trx_number%type) IS
21:
22: l_country_code VARCHAR2(2);
23: l_trx_num_cursor INTEGER;
24: l_dummy INTEGER;
23: l_trx_num_cursor INTEGER;
24: l_dummy INTEGER;
25: l_org_id INTEGER;
26: l_org_str VARCHAR2(30);
27: l_trx_number ra_recur_interim.trx_number%TYPE;
28: l_trx_date DATE;
29:
30: BEGIN
31: arp_util.debug('arp_process_recur.insert_p()+');
84: l_trx_date);
85: END IF;
86:
87: --
88: -- Insert trx information into ra_recur_interim
89: --
90: INSERT INTO ra_recur_interim
91: (
92: customer_trx_id,
86:
87: --
88: -- Insert trx information into ra_recur_interim
89: --
90: INSERT INTO ra_recur_interim
91: (
92: customer_trx_id,
93: trx_number,
94: created_by,