APPS.JL_AR_AR_PREFIX_TRX_NUM dependencies on RA_BATCH_SOURCES

Line 16: l_imported_source_id ra_batch_sources_all.batch_source_id%TYPE;

12: l_count NUMBER;
13: l_last_trx_date DATE;
14: l_document_letter VARCHAR2(1);
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);

Line 17: l_auto_trx_numbering_flag ra_batch_sources_all.auto_trx_numbering_flag%TYPE;

13: l_last_trx_date DATE;
14: l_document_letter VARCHAR2(1);
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:

Line 18: l_batch_source_type ra_batch_sources_all.batch_source_type%TYPE;

14: l_document_letter VARCHAR2(1);
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:

Line 44: FROM ra_batch_sources

40: l_imported_source_id,
41: l_branch_number,
42: l_document_letter,
43: l_last_trx_date
44: FROM ra_batch_sources
45: WHERE batch_source_id = p_batch_source_id;
46:
47: IF l_batch_source_type = 'INV' THEN
48:

Line 74: FROM ra_batch_sources

70: to_date(global_attribute4,'YYYY/MM/DD HH24:MI:SS')
71: INTO l_branch_number,
72: l_document_letter,
73: l_last_trx_date
74: FROM ra_batch_sources
75: WHERE batch_source_id = l_imported_source_id;
76:
77: p_trx_number := l_document_letter || '-' ||
78: l_branch_number || '-' ||