It is up to you to decide whether you want your changes to be committed to the database immediately or later.
To this end, the p_commit_ind parameter has been provided in some packages. You do not have to pass this parameter to the procedures. The default setting is Y, which means data is committed immediately by the API procedures.
If you pass the value N instead, the API procedures will not commit the data.
m_api_poh.upd_poh (us_id, pk_id, l_col_rec, result); -> Data will be committed.
m_api_poli.ins_poli (us_id, pk_id, l_col_rec, result, ‘Y’); -> Data will be committed.
m_api_ish.upd_ish (us_id, pk_id, l_col_rec, result, ‘N’); -> Data will NOT be committed.
Currently, this feature is supported by all procedures of the following APIs: