[Home] [Help]
5099: IS
5100: SELECT tai.trx_number trans_number
5101: -- ,tai.tcn_id tai_tcn_id -- added qte_id below. racheruv 15978873
5102: ,tai.qte_id qte_id
5103: FROM okl_trx_ar_invoices_b tai
5104: WHERE tai.id = p_header_source_id;
5105:
5106: -- Cursor to fetch the Qte_id from the AR Transaction Header
5107: --
5768: ,tld.khr_id khr_id
5769: ,tld.kle_id kle_id
5770: ,tld.sty_id sty_id
5771: ,tai.try_id try_id
5772: FROM okl_trx_ar_invoices_b tai
5773: ,okl_txl_ar_inv_lns_b til
5774: ,okl_txd_ar_ln_dtls_b tld
5775: WHERE tld.til_id_details = til.id
5776: AND til.tai_id = tai.id
5866: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
5867: 'Header SOURCE_ID= ' || p_rxhv_rec.source_id || ' SOURCE_TABLE=' || p_rxhv_rec.source_table );
5868: -- Validation 2: The Header Source Table should be either the
5869: -- OKL AR Invoice Trx Header or OKL AR Adjustment Trx. Header table only
5870: -- ie. it should be either OKL_TRX_AR_INVOICES_B or OKL_TRX_AR_ADJSTS_B only
5871: IF UPPER(p_rxhv_rec.source_table) NOT IN ( G_TRX_AR_INVOICES_B, G_TRX_AR_ADJSTS_B)
5872: THEN
5873: OKL_API.set_message(
5874: p_app_name => G_APP_NAME
5911: END IF;
5912:
5913: -- Loop on the details for the current transaction header
5914: -- Call the populate_tld_sources
5915: IF l_header_source_table = 'OKL_TRX_AR_INVOICES_B'
5916: THEN
5917: -- As we wanted to store the records in the PL/SQL table starting from 1
5918: -- and after the loop, the tld_index should be nothing but the count of the
5919: -- Transaction Detail Lines fetched ...
6115: RAISE OKL_API.G_EXCEPTION_ERROR;
6116: END IF;
6117: END IF; -- IF l_capture_sources = 'Y'
6118: END LOOP; -- Loop on l_trx_ar_adj_lines_tbl ..
6119: END IF; -- IF l_header_source_table = 'OKL_TRX_AR_INVOICES_B'
6120: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
6121: 'Calling okl_api.end_activity');
6122: okl_api.end_activity(
6123: x_msg_count => x_msg_count