[Home] [Help]
6570: END IF;
6571: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
6572: 'Validation 1 Successfull !');
6573: -- Validation 2:
6574: -- Source Table should be OKL_TXL_AP_INV_LNS_B
6575: IF p_pxlv_rec.source_table NOT IN ( G_TXL_AP_INV_LNS_B )
6576: THEN
6577: -- Raise an Exception
6578: OKL_API.set_message(
7014: -- sty_id, try_id
7015: CURSOR c_ap_fcase_csr (p_header_source_id NUMBER)
7016: IS
7017: SELECT tpl.id source_id
7018: ,'OKL_TXL_AP_INV_LNS_B' source_table
7019: ,tpl.khr_id khr_id
7020: ,tpl.kle_id kle_id
7021: ,tpl.sty_id sty_id
7022: ,tap.try_id try_id
7021: ,tpl.sty_id sty_id
7022: ,tap.try_id try_id
7023: ,tap.vendor_invoice_number trans_number
7024: FROM okl_trx_ap_invoices_b tap
7025: ,okl_txl_ap_inv_lns_b tpl
7026: WHERE tap.id = tpl.tap_id
7027: AND tap.id = p_header_source_id;
7028:
7029: -- Data structures based on the Cursor Variables