PACKAGE BODY: APPS.PQH_PURGE_DELETE_APIS

Source

1 PACKAGE body PQH_PURGE_DELETE_APIS AS
2 /* $Header: pqpurdel.pkb 115.1 2002/03/22 05:43:20 pkm ship        $ */
3 
4 
5 --
6 PROCEDURE pqh_ptx_shadow_del(p_position_transaction_id IN NUMBER , p_object_version_number IN NUMBER) IS
7 BEGIN
8 delete from pqh_ptx_shadow where position_transaction_id = p_position_transaction_id;
9 END pqh_ptx_shadow_del;
10 --
11 PROCEDURE PQH_PTX_DPF_DF_DEL(p_ptx_deployment_factor_id IN NUMBER ,p_object_version_number IN NUMBER)IS
12 BEGIN
13 delete from pqh_ptx_dpf_df where ptx_deployment_factor_id = p_ptx_deployment_factor_id;
14 END PQH_PTX_DPF_DF_DEL;
15 --
16 PROCEDURE pqh_ptx_dpf_df_shadow_del(p_ptx_deployment_factor_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 --
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;