For some reason we are missing with POET info on purchase orders. So we have a requirement to update POET info on po_distributions_all and we want to run PO account generator to update code_combination_id.
I'm planning on using po_distributions_pkg1.update_row to update POET on po_distributions_all but once we update POET on table how do i need to update code_combination_id. Usually when we update POET from application front end Po Account Generator is automatically kicked off and CCID is updated on po_distributions_all table.
Please advice how can i achieve this functionality,