DBA Data[Home] [Help]

APPS.PQH_PURGE_DELETE_APIS dependencies on PQH_TJR_SHADOW

Line 21: PROCEDURE pqh_tjr_shadow_del(p_txn_job_requirement_id IN NUMBER,p_object_version_number IN NUMBER) IS

17: BEGIN
18: delete from PQH_PTX_DPF_DF where ptx_deployment_factor_id = p_ptx_deployment_factor_id;
19: END pqh_ptx_dpf_df_shadow_del;
20: --
21: PROCEDURE pqh_tjr_shadow_del(p_txn_job_requirement_id IN NUMBER,p_object_version_number IN NUMBER) IS
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: --

Line 23: delete from pqh_tjr_shadow where txn_job_requirement_id = p_txn_job_requirement_id;

19: END pqh_ptx_dpf_df_shadow_del;
20: --
21: PROCEDURE pqh_tjr_shadow_del(p_txn_job_requirement_id IN NUMBER,p_object_version_number IN NUMBER) IS
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

Line 24: END pqh_tjr_shadow_del;

20: --
21: PROCEDURE pqh_tjr_shadow_del(p_txn_job_requirement_id IN NUMBER,p_object_version_number IN NUMBER) IS
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;