DBA Data[Home] [Help]

APPS.JL_AR_RECUR_PKG dependencies on RA_RECUR_INTERIM

Line 11: p_customer_trx_id IN ra_recur_interim.customer_trx_id%type,

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,

Line 16: p_request_id IN ra_recur_interim.request_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,
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

Line 17: p_doc_sequence_value IN ra_recur_interim.doc_sequence_value%type,

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:

Line 18: p_new_customer_trx_id IN ra_recur_interim.new_customer_trx_id%type,

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

Line 20: p_trx_number_out OUT ra_recur_interim.trx_number%type) IS

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;

Line 27: l_trx_number ra_recur_interim.trx_number%TYPE;

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

Line 88: -- Insert trx information into ra_recur_interim

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,

Line 90: INSERT INTO ra_recur_interim

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,