22: BEGIN
23: delete from pqh_tjr_shadow where txn_job_requirement_id = p_txn_job_requirement_id;
24: END pqh_tjr_shadow_del;
25: --
26: PROCEDURE pqh_pte_shadow_del (p_ptx_extra_info_id IN NUMBER,p_object_version_number IN NUMBER) IS
27: BEGIN
28: delete from pqh_pte_shadow where ptx_extra_info_id = p_ptx_extra_info_id;
29: END pqh_pte_shadow_del;
30:
24: END pqh_tjr_shadow_del;
25: --
26: PROCEDURE pqh_pte_shadow_del (p_ptx_extra_info_id IN NUMBER,p_object_version_number IN NUMBER) IS
27: BEGIN
28: delete from pqh_pte_shadow where ptx_extra_info_id = p_ptx_extra_info_id;
29: END pqh_pte_shadow_del;
30:
31: --
32: END PQH_PURGE_DELETE_APIS;
25: --
26: PROCEDURE pqh_pte_shadow_del (p_ptx_extra_info_id IN NUMBER,p_object_version_number IN NUMBER) IS
27: BEGIN
28: delete from pqh_pte_shadow where ptx_extra_info_id = p_ptx_extra_info_id;
29: END pqh_pte_shadow_del;
30:
31: --
32: END PQH_PURGE_DELETE_APIS;