1: PACKAGE BODY JL_AR_AR_PREFIX_TRX_NUM AS
2: /*$Header: jlarrutb.pls 120.3 2005/04/07 18:24:17 appradha ship $*/
3:
4: PROCEDURE update_trx_number_date (
5: p_batch_source_id IN ra_customer_trx_all.batch_source_id%TYPE,
6: p_trx_number IN OUT NOCOPY ra_customer_trx_all.trx_number%TYPE,
7: p_trx_date IN OUT NOCOPY ra_customer_trx_all.trx_date%TYPE )
8: IS
9:
2: /*$Header: jlarrutb.pls 120.3 2005/04/07 18:24:17 appradha ship $*/
3:
4: PROCEDURE update_trx_number_date (
5: p_batch_source_id IN ra_customer_trx_all.batch_source_id%TYPE,
6: p_trx_number IN OUT NOCOPY ra_customer_trx_all.trx_number%TYPE,
7: p_trx_date IN OUT NOCOPY ra_customer_trx_all.trx_date%TYPE )
8: IS
9:
10: l_trx_num_cursor INTEGER;
3:
4: PROCEDURE update_trx_number_date (
5: p_batch_source_id IN ra_customer_trx_all.batch_source_id%TYPE,
6: p_trx_number IN OUT NOCOPY ra_customer_trx_all.trx_number%TYPE,
7: p_trx_date IN OUT NOCOPY ra_customer_trx_all.trx_date%TYPE )
8: IS
9:
10: l_trx_num_cursor INTEGER;
11: l_org_id NUMBER;
15: l_branch_number VARCHAR2(4);
16: l_imported_source_id ra_batch_sources_all.batch_source_id%TYPE;
17: l_auto_trx_numbering_flag ra_batch_sources_all.auto_trx_numbering_flag%TYPE;
18: l_batch_source_type ra_batch_sources_all.batch_source_type%TYPE;
19: l_trx_number ra_customer_trx_all.trx_number%TYPE;
20: l_country_code VARCHAR2(5);
21:
22:
23: BEGIN