want to update TAX_INVOICE_DATE column in ZX_LINES_DET_FACTORS Table.

Hi All,

Here is the my requirement to update the TAX_INVOICE_DATE column in ZX_LINES_DET_FACTORS table for TRANSCATION (AR) event.

For this I requirement I have written below query, after successful ran  oc_event_status,tax_event_type_code is chaninging to  UPDATE but TAX_INVOICE_DATE column is not updating anything.

please check anything went wrong in code or any inputs please.

DECLARE
l_hdr_det_factors_rec ZX_API_PUB.header_det_factors_rec_type;
l_return_status varchar2(3000);
l_msg_count     varchar2(3000);
l_msg_data      varchar2(3000);
l_msg_dummy     varchar2(3000);
l_output        varchar2(3000);