91: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
92:
93: PROCEDURE get_header_defaults(
94: p_batch_source_id IN
95: ra_batch_sources.batch_source_id%type,
96: p_batch_batch_source_id IN
97: ra_batch_sources.batch_source_id%type,
98: p_profile_batch_source_id IN
99: ra_batch_sources.batch_source_id%type,
93: PROCEDURE get_header_defaults(
94: p_batch_source_id IN
95: ra_batch_sources.batch_source_id%type,
96: p_batch_batch_source_id IN
97: ra_batch_sources.batch_source_id%type,
98: p_profile_batch_source_id IN
99: ra_batch_sources.batch_source_id%type,
100: p_customer_trx_id IN
101: ra_customer_trx.customer_trx_id%type,
95: ra_batch_sources.batch_source_id%type,
96: p_batch_batch_source_id IN
97: ra_batch_sources.batch_source_id%type,
98: p_profile_batch_source_id IN
99: ra_batch_sources.batch_source_id%type,
100: p_customer_trx_id IN
101: ra_customer_trx.customer_trx_id%type,
102: p_cust_trx_type_id IN
103: ra_cust_trx_types.cust_trx_type_id%type,
131: ra_cust_trx_line_gl_dist.gl_date%type,
132: p_batch_gl_date IN
133: ra_cust_trx_line_gl_dist.gl_date%type,
134: p_default_batch_source_id OUT NOCOPY
135: ra_batch_sources.batch_source_id%type,
136: p_default_batch_source_name OUT NOCOPY
137: ra_batch_sources.name%type,
138: p_auto_trx_numbering_flag OUT NOCOPY
139: ra_batch_sources.auto_trx_numbering_flag%type,
133: ra_cust_trx_line_gl_dist.gl_date%type,
134: p_default_batch_source_id OUT NOCOPY
135: ra_batch_sources.batch_source_id%type,
136: p_default_batch_source_name OUT NOCOPY
137: ra_batch_sources.name%type,
138: p_auto_trx_numbering_flag OUT NOCOPY
139: ra_batch_sources.auto_trx_numbering_flag%type,
140: p_batch_source_type OUT NOCOPY
141: ra_batch_sources.batch_source_type%type,
135: ra_batch_sources.batch_source_id%type,
136: p_default_batch_source_name OUT NOCOPY
137: ra_batch_sources.name%type,
138: p_auto_trx_numbering_flag OUT NOCOPY
139: ra_batch_sources.auto_trx_numbering_flag%type,
140: p_batch_source_type OUT NOCOPY
141: ra_batch_sources.batch_source_type%type,
142: p_copy_doc_number_flag OUT NOCOPY
143: ra_batch_sources.copy_doc_number_flag%type,
137: ra_batch_sources.name%type,
138: p_auto_trx_numbering_flag OUT NOCOPY
139: ra_batch_sources.auto_trx_numbering_flag%type,
140: p_batch_source_type OUT NOCOPY
141: ra_batch_sources.batch_source_type%type,
142: p_copy_doc_number_flag OUT NOCOPY
143: ra_batch_sources.copy_doc_number_flag%type,
144: p_bs_default_cust_trx_type_id OUT NOCOPY
145: ra_cust_trx_types.cust_trx_type_id%type,
139: ra_batch_sources.auto_trx_numbering_flag%type,
140: p_batch_source_type OUT NOCOPY
141: ra_batch_sources.batch_source_type%type,
142: p_copy_doc_number_flag OUT NOCOPY
143: ra_batch_sources.copy_doc_number_flag%type,
144: p_bs_default_cust_trx_type_id OUT NOCOPY
145: ra_cust_trx_types.cust_trx_type_id%type,
146: p_default_cust_trx_type_id OUT NOCOPY
147: ra_cust_trx_types.cust_trx_type_id%type,
189: p_security_commit_enter_flag IN
190: varchar2 DEFAULT 'Y'
191: ) IS
192:
193: l_batch_source_id ra_batch_sources.batch_source_id%type;
194: l_default_batch_source_name ra_batch_sources.name%type;
195: l_auto_trx_numbering_flag ra_batch_sources.auto_trx_numbering_flag%type;
196: l_batch_source_type ra_batch_sources.batch_source_type%type;
197: l_copy_doc_number_flag ra_batch_sources.copy_doc_number_flag%type;
190: varchar2 DEFAULT 'Y'
191: ) IS
192:
193: l_batch_source_id ra_batch_sources.batch_source_id%type;
194: l_default_batch_source_name ra_batch_sources.name%type;
195: l_auto_trx_numbering_flag ra_batch_sources.auto_trx_numbering_flag%type;
196: l_batch_source_type ra_batch_sources.batch_source_type%type;
197: l_copy_doc_number_flag ra_batch_sources.copy_doc_number_flag%type;
198: l_bs_default_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
191: ) IS
192:
193: l_batch_source_id ra_batch_sources.batch_source_id%type;
194: l_default_batch_source_name ra_batch_sources.name%type;
195: l_auto_trx_numbering_flag ra_batch_sources.auto_trx_numbering_flag%type;
196: l_batch_source_type ra_batch_sources.batch_source_type%type;
197: l_copy_doc_number_flag ra_batch_sources.copy_doc_number_flag%type;
198: l_bs_default_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
199: l_default_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
192:
193: l_batch_source_id ra_batch_sources.batch_source_id%type;
194: l_default_batch_source_name ra_batch_sources.name%type;
195: l_auto_trx_numbering_flag ra_batch_sources.auto_trx_numbering_flag%type;
196: l_batch_source_type ra_batch_sources.batch_source_type%type;
197: l_copy_doc_number_flag ra_batch_sources.copy_doc_number_flag%type;
198: l_bs_default_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
199: l_default_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
200: l_default_status_code ar_lookups.lookup_code%type;
193: l_batch_source_id ra_batch_sources.batch_source_id%type;
194: l_default_batch_source_name ra_batch_sources.name%type;
195: l_auto_trx_numbering_flag ra_batch_sources.auto_trx_numbering_flag%type;
196: l_batch_source_type ra_batch_sources.batch_source_type%type;
197: l_copy_doc_number_flag ra_batch_sources.copy_doc_number_flag%type;
198: l_bs_default_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
199: l_default_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
200: l_default_status_code ar_lookups.lookup_code%type;
201: l_default_printing_option_code ar_lookups.lookup_code%type;