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 777: p_request_id => AR_INVOICE_TABLE_HANDLER.g_request_id,

773: ar_invoice_utils.debug ('vaidate_gdf (+) ');
774: END IF;
775:
776: ar_invoice_utils.validate_gdf(
777: p_request_id => AR_INVOICE_TABLE_HANDLER.g_request_id,
778: x_errmsg => x_errmsg,
779: x_return_status => x_return_status);
780:
781: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

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

786: END IF;
787: IF pg_debug = 'Y'
788: THEN
789: ar_invoice_utils.debug ('validate_gdf (-)' );
790: ar_invoice_utils.debug ('Calling Table Handler ar_invoice_table_handler.insert_row (+) ');
791: END IF;
792:
793: AR_INVOICE_TABLE_HANDLER.insert_row(
794: p_trx_system_parameters_rec => l_trx_system_parameters_rec,

Line 793: AR_INVOICE_TABLE_HANDLER.insert_row(

789: ar_invoice_utils.debug ('validate_gdf (-)' );
790: ar_invoice_utils.debug ('Calling Table Handler ar_invoice_table_handler.insert_row (+) ');
791: END IF;
792:
793: AR_INVOICE_TABLE_HANDLER.insert_row(
794: p_trx_system_parameters_rec => l_trx_system_parameters_rec,
795: p_trx_profile_rec => l_trx_profile_rec,
796: p_batch_source_rec => p_batch_source_rec,
797: x_errmsg => x_errmsg,

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

816:
817: --{Call creation of the events should outside the loop as not org striped
818: --
819: ar_invoice_utils.debug ('Call creation of XLA events in bulk mode +' );
820: ar_invoice_utils.debug (' Using the request_id :'||AR_INVOICE_TABLE_HANDLER.g_request_id);
821:
822: arp_xla_events.Create_Events_Req(p_request_id => AR_INVOICE_TABLE_HANDLER.g_request_id,
823: p_doc_table => 'CT',
824: p_mode => 'B',

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

818: --
819: ar_invoice_utils.debug ('Call creation of XLA events in bulk mode +' );
820: ar_invoice_utils.debug (' Using the request_id :'||AR_INVOICE_TABLE_HANDLER.g_request_id);
821:
822: arp_xla_events.Create_Events_Req(p_request_id => AR_INVOICE_TABLE_HANDLER.g_request_id,
823: p_doc_table => 'CT',
824: p_mode => 'B',
825: p_call => 'B');
826: ar_invoice_utils.debug ('Call creation of XLA events in bulk mode -' );

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

828:
829:
830: IF pg_debug = 'Y'
831: THEN
832: ar_invoice_utils.debug ('Calling Table Handler ar_invoice_table_handler.insert_row (-) ');
833: ar_invoice_utils.debug ('ar_invoice_api_pub.create_invoice(-)' );
834: END IF;
835:
836: