DBA Data[Home] [Help]

APPS.AR_INVOICE_API_PUB dependencies on AR_INVOICE_TABLE_HANDLER

Line 133: request_id = AR_INVOICE_TABLE_HANDLER.g_request_id;

129: ( SELECT hgt.customer_trx_id, hgt.trx_date, hgt.org_id,
130: hgt.set_of_books_id, trx_currency
131: FROM ar_trx_header_gt hgt
132: WHERE lgt.trx_header_id = trx_header_id),
133: request_id = AR_INVOICE_TABLE_HANDLER.g_request_id;
134:
135: IF pg_debug = 'Y'
136: THEN
137: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_lines(-)' );

Line 185: request_id = AR_INVOICE_TABLE_HANDLER.g_request_id,

181: the internals of ar_trx_global_process_dist.insert_row */
182: UPDATE ar_trx_dist_gt dist
183: SET set_of_books_id = nvl(set_of_books_id,
184: p_trx_system_param_rec.set_of_books_id),
185: request_id = AR_INVOICE_TABLE_HANDLER.g_request_id,
186: /* gl_date = nvl(gl_date, nvl(p_batch_source_rec.default_date,
187: sysdate)),
188: Bug 3361235*/
189: (customer_trx_id, customer_trx_line_id, trx_header_id, gl_date) =

Line 248: request_id = AR_INVOICE_TABLE_HANDLER.g_request_id,

244: /* 5921925 - Should remove this. Have to rewrite
245: ar_trx_global_process_salescr.insert_row */
246: UPDATE ar_trx_salescredits_gt sc
247: SET org_id = nvl(org_id, p_trx_system_param_rec.org_id),
248: request_id = AR_INVOICE_TABLE_HANDLER.g_request_id,
249: (customer_trx_id, customer_trx_line_id, trx_header_id) = (
250: SELECT line.customer_trx_id, line.customer_trx_line_id,
251: trx_header_id
252: FROM ar_trx_lines_gt line

Line 302: request_id = ar_invoice_table_handler.g_request_id,

298: /* 5921925 - Should remove this.. Have to rewrite
299: ar_trx_global_process_cont.insert_row */
300: UPDATE ar_trx_contingencies_gt tcg
301: SET org_id = nvl(org_id, p_trx_system_param_rec.org_id),
302: request_id = ar_invoice_table_handler.g_request_id,
303: trx_header_id = (SELECT trx_header_id
304: FROM ar_trx_lines_gt tlg
305: WHERE tlg.trx_line_id = tcg.trx_line_id
306: AND rownum = 1);

Line 504: AR_INVOICE_TABLE_HANDLER.create_batch(

500: mode */
501: IF NOT g_single_invoice
502: THEN
503: -- Create a batch
504: AR_INVOICE_TABLE_HANDLER.create_batch(
505: p_trx_system_parameters_rec => l_trx_system_parameters_rec,
506: p_trx_profile_rec => l_trx_profile_rec,
507: p_batch_source_rec => p_batch_source_rec,
508: p_batch_id => l_batch_id,

Line 522: INTO ar_invoice_table_handler.g_request_id

518: ELSE
519: /* 5921925 - insure that we have a viable request_id for this batch
520: even if its only one transaction */
521: SELECT ra_batches_s.nextval * -1
522: INTO ar_invoice_table_handler.g_request_id
523: FROM dual;
524: END IF;
525:
526: --first popolate the global temp. table based on user passed variables and

Line 790: p_request_id => AR_INVOICE_TABLE_HANDLER.g_request_id,

786: ar_invoice_utils.debug ('vaidate_gdf (+) ');
787: END IF;
788:
789: ar_invoice_utils.validate_gdf(
790: p_request_id => AR_INVOICE_TABLE_HANDLER.g_request_id,
791: x_errmsg => x_errmsg,
792: x_return_status => x_return_status);
793:
794: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

Line 803: ar_invoice_utils.debug ('Calling Table Handler ar_invoice_table_handler.insert_row (+) ');

799: END IF;
800: IF pg_debug = 'Y'
801: THEN
802: ar_invoice_utils.debug ('validate_gdf (-)' );
803: ar_invoice_utils.debug ('Calling Table Handler ar_invoice_table_handler.insert_row (+) ');
804: END IF;
805:
806: AR_INVOICE_TABLE_HANDLER.insert_row(
807: p_trx_system_parameters_rec => l_trx_system_parameters_rec,

Line 806: AR_INVOICE_TABLE_HANDLER.insert_row(

802: ar_invoice_utils.debug ('validate_gdf (-)' );
803: ar_invoice_utils.debug ('Calling Table Handler ar_invoice_table_handler.insert_row (+) ');
804: END IF;
805:
806: AR_INVOICE_TABLE_HANDLER.insert_row(
807: p_trx_system_parameters_rec => l_trx_system_parameters_rec,
808: p_trx_profile_rec => l_trx_profile_rec,
809: p_batch_source_rec => p_batch_source_rec,
810: x_errmsg => x_errmsg,

Line 887: ar_invoice_utils.debug (' Using the request_id :'||AR_INVOICE_TABLE_HANDLER.g_request_id);

883:
884: --{Call creation of the events should outside the loop as not org striped
885: --
886: ar_invoice_utils.debug ('Call creation of XLA events in bulk mode +' );
887: ar_invoice_utils.debug (' Using the request_id :'||AR_INVOICE_TABLE_HANDLER.g_request_id);
888:
889: arp_xla_events.Create_Events_Req(p_request_id => AR_INVOICE_TABLE_HANDLER.g_request_id,
890: p_doc_table => 'CT',
891: p_mode => 'B',

Line 889: arp_xla_events.Create_Events_Req(p_request_id => AR_INVOICE_TABLE_HANDLER.g_request_id,

885: --
886: ar_invoice_utils.debug ('Call creation of XLA events in bulk mode +' );
887: ar_invoice_utils.debug (' Using the request_id :'||AR_INVOICE_TABLE_HANDLER.g_request_id);
888:
889: arp_xla_events.Create_Events_Req(p_request_id => AR_INVOICE_TABLE_HANDLER.g_request_id,
890: p_doc_table => 'CT',
891: p_mode => 'B',
892: p_call => 'B');
893: ar_invoice_utils.debug ('Call creation of XLA events in bulk mode -' );

Line 898: ar_invoice_utils.debug ('Calling Table Handler ar_invoice_table_handler.insert_row (-) ');

894: --}
895:
896: IF pg_debug = 'Y'
897: THEN
898: ar_invoice_utils.debug ('Calling Table Handler ar_invoice_table_handler.insert_row (-) ');
899: ar_invoice_utils.debug ('ar_invoice_api_pub.create_invoice(-)' );
900: END IF;
901:
902: