DBA Data[Home] [Help]

APPS.AR_DEPOSIT_API_PUB dependencies on RA_BATCH_SOURCES

Line 103: from ra_batch_sources

99: --To make sure that Batch derived from profile option belongs to same org
100: BEGIN
101: IF ar_deposit_lib_pvt.pg_profile_batch_source is not null then
102: select 'X' into l_dummy
103: from ra_batch_sources
104: where batch_source_id = ar_deposit_lib_pvt.pg_profile_batch_source;
105: end if;
106: EXCEPTION
107: when others then

Line 517: l_default_batch_source_id ra_batch_sources.batch_source_id%type;

513: l_api_name CONSTANT VARCHAR2(20) := 'Create_Deposit';
514: l_api_version CONSTANT NUMBER := 1.0;
515:
516: l_deposit_number ra_customer_trx_all.trx_number%type;
517: l_default_batch_source_id ra_batch_sources.batch_source_id%type;
518: l_default_batch_source_name ra_batch_sources.name%type;
519: l_auto_trx_numbering_flag ra_batch_sources.auto_trx_numbering_flag%type;
520: l_batch_source_type ra_batch_sources.batch_source_type%type;
521: l_copy_doc_number_flag ra_batch_sources.copy_doc_number_flag%type;

Line 518: l_default_batch_source_name ra_batch_sources.name%type;

514: l_api_version CONSTANT NUMBER := 1.0;
515:
516: l_deposit_number ra_customer_trx_all.trx_number%type;
517: l_default_batch_source_id ra_batch_sources.batch_source_id%type;
518: l_default_batch_source_name ra_batch_sources.name%type;
519: l_auto_trx_numbering_flag ra_batch_sources.auto_trx_numbering_flag%type;
520: l_batch_source_type ra_batch_sources.batch_source_type%type;
521: l_copy_doc_number_flag ra_batch_sources.copy_doc_number_flag%type;
522: l_bs_default_cust_trx_type_id

Line 519: l_auto_trx_numbering_flag ra_batch_sources.auto_trx_numbering_flag%type;

515:
516: l_deposit_number ra_customer_trx_all.trx_number%type;
517: l_default_batch_source_id ra_batch_sources.batch_source_id%type;
518: l_default_batch_source_name ra_batch_sources.name%type;
519: l_auto_trx_numbering_flag ra_batch_sources.auto_trx_numbering_flag%type;
520: l_batch_source_type ra_batch_sources.batch_source_type%type;
521: l_copy_doc_number_flag ra_batch_sources.copy_doc_number_flag%type;
522: l_bs_default_cust_trx_type_id
523: ra_cust_trx_types.cust_trx_type_id%type;

Line 520: l_batch_source_type ra_batch_sources.batch_source_type%type;

516: l_deposit_number ra_customer_trx_all.trx_number%type;
517: l_default_batch_source_id ra_batch_sources.batch_source_id%type;
518: l_default_batch_source_name ra_batch_sources.name%type;
519: l_auto_trx_numbering_flag ra_batch_sources.auto_trx_numbering_flag%type;
520: l_batch_source_type ra_batch_sources.batch_source_type%type;
521: l_copy_doc_number_flag ra_batch_sources.copy_doc_number_flag%type;
522: l_bs_default_cust_trx_type_id
523: ra_cust_trx_types.cust_trx_type_id%type;
524: l_default_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;

Line 521: l_copy_doc_number_flag ra_batch_sources.copy_doc_number_flag%type;

517: l_default_batch_source_id ra_batch_sources.batch_source_id%type;
518: l_default_batch_source_name ra_batch_sources.name%type;
519: l_auto_trx_numbering_flag ra_batch_sources.auto_trx_numbering_flag%type;
520: l_batch_source_type ra_batch_sources.batch_source_type%type;
521: l_copy_doc_number_flag ra_batch_sources.copy_doc_number_flag%type;
522: l_bs_default_cust_trx_type_id
523: ra_cust_trx_types.cust_trx_type_id%type;
524: l_default_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
525: l_default_type_name ra_cust_trx_types.name%type;

Line 547: l_batch_source_id ra_batch_sources.batch_source_id%type;

543: l_gd_default_gl_date date;
544: l_ctt_default_ctrx_type_id ra_cust_trx_types.cust_trx_type_id%type;
545: l_ctt_default_type_name ra_cust_trx_types.name%type;
546: l_ctt_bs_default_type_name ra_cust_trx_types.name%type;
547: l_batch_source_id ra_batch_sources.batch_source_id%type;
548: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
549: l_term_id ra_terms.term_id%type;
550: l_salesrep_id ra_salesreps.salesrep_id%type;
551: l_default_salesrep_id ra_salesreps.salesrep_id%type;