DBA Data[Home] [Help]

APPS.BEN_PRTT_PREM_API SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 34

    select ppe.std_prem_val, ppe.actl_prem_id, ppe.prtt_enrt_rslt_id
    from ben_prtt_prem_f ppe
    where ppe.prtt_prem_id = p_prtt_prem_id
    --and p_effective_date between
    and p_date between
        ppe.effective_start_date and ppe.effective_end_date;
Line: 44

    select apr.mlt_cd, apr.pl_id, apr.oipl_id, apr.bnft_rt_typ_cd, apr.val,
           apr.rndg_cd, apr.rndg_rl, apr.upr_lmt_val, apr.lwr_lmt_val,
           apr.upr_lmt_calc_rl, apr.lwr_lmt_calc_rl, prem_asnmt_cd, val_calc_rl
    from ben_actl_prem_f apr
    where apr.actl_prem_id = p_actl_prem_id
    --and p_effective_date between
    and p_date between
        apr.effective_start_date and apr.effective_end_date;
Line: 56

    select ccm.entr_val_at_enrt_flag,
           ccm.cvg_mlt_cd
    from ben_cvg_amt_calc_mthd_f ccm
    where ((ccm.pl_id = p_pl_id and p_oipl_id is null)
    or (ccm.oipl_id = p_oipl_id and p_pl_id is null))
    --and p_effective_date between
    and p_date between
        ccm.effective_start_date and ccm.effective_end_date;
Line: 67

    select pen.bnft_amt, pen.person_id,  pen.pgm_id,
           pen.pl_id, pen.oipl_id, pen.pl_typ_id, pen.per_in_ler_id, pen.ler_id,
           epe.elig_per_elctbl_chc_id, b.enrt_bnft_id, pen.business_group_id,
           b.entr_val_at_enrt_flag, b.cvg_mlt_cd
    from ben_prtt_enrt_rslt_f pen, ben_elig_per_elctbl_chc epe, ben_enrt_bnft b
    where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
    and   pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id
    and   b.elig_per_elctbl_chc_id(+) = epe.elig_per_elctbl_chc_id
    and   pen.prtt_enrt_rslt_stat_cd is null
--    and   (b.entr_val_at_enrt_flag = 'Y' or
--           b.cvg_mlt_cd = 'ERL')
    and p_effective_date between
        pen.effective_start_date and pen.effective_end_date;
Line: 84

    select oipl.opt_id
    from   ben_oipl_f oipl
    where  oipl.oipl_id = p_oipl_id
    --  and  p_effective_date between
      and  p_date between
             oipl.effective_start_date and oipl.effective_end_date;
Line: 95

  select 'X'
    from ben_ACTL_PREM_VRBL_RT_f apv
   where apv.actl_prem_id = p_actl_prem_id
     and p_effective_date between apv.effective_start_date
                              and apv.effective_end_date;
Line: 103

    select pil.LF_EVT_OCRD_DT
    from ben_per_in_ler pil
    where pil.per_in_ler_id = p_per_in_ler_id;
Line: 118

 select *
 from  ben_elig_per_elctbl_chc
 where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id  ;
Line: 355

  ,p_program_update_date            in  date      default null
  ,p_effective_date                 in  date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_prtt_prem_id ben_prtt_prem_f.prtt_prem_id%TYPE;
Line: 425

      ,p_program_update_date            =>  p_program_update_date
      ,p_effective_date                 => trunc(p_effective_date)
      );
Line: 486

    ,p_program_update_date           => p_program_update_date
    ,p_effective_date                => trunc(p_effective_date)
    );
Line: 540

      ,p_program_update_date            =>  p_program_update_date
      ,p_effective_date                      => trunc(p_effective_date)
      );
Line: 648

  ,p_program_update_date            in  date      default null
  ,p_effective_date                 in  date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_prtt_prem_id ben_prtt_prem_f.prtt_prem_id%TYPE;
Line: 662

    select pen.per_in_ler_id
    from   ben_prtt_enrt_rslt_f pen
    where  pen.prtt_enrt_rslt_id=p_prtt_enrt_rslt_id and
           pen.prtt_enrt_rslt_stat_cd is null and
           pen.business_group_id+0=p_business_group_id and
           p_effective_date between
             pen.effective_start_date and pen.effective_end_date;
Line: 732

      ,p_program_update_date            =>  p_program_update_date
      ,p_effective_date                 => trunc(p_effective_date)
      );
Line: 793

    ,p_program_update_date           => p_program_update_date
    ,p_effective_date                => trunc(p_effective_date)
    );
Line: 847

      ,p_program_update_date            =>  p_program_update_date
      ,p_effective_date                      => trunc(p_effective_date)
      );
Line: 909

procedure update_PRTT_PREM
  (p_validate                       in  boolean   default false
  ,p_prtt_prem_id                   in  number
  ,p_effective_start_date           out nocopy date
  ,p_effective_end_date             out nocopy date
  ,p_std_prem_uom                   in  varchar2  default hr_api.g_varchar2
  ,p_std_prem_val                   in  number    default hr_api.g_number
  ,p_actl_prem_id                   in  number    default hr_api.g_number
  ,p_prtt_enrt_rslt_id              in  number    default hr_api.g_number
  ,p_per_in_ler_id              in  number
  ,p_business_group_id              in  number    default hr_api.g_number
  ,p_ppe_attribute_category         in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute1                 in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute2                 in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute3                 in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute4                 in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute5                 in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute6                 in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute7                 in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute8                 in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute9                 in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute10                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute11                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute12                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute13                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute14                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute15                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute16                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute17                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute18                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute19                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute20                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute21                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute22                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute23                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute24                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute25                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute26                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute27                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute28                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute29                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute30                in  varchar2  default hr_api.g_varchar2
  ,p_object_version_number          in out nocopy number
  ,p_request_id                     in  number    default hr_api.g_number
  ,p_program_application_id         in  number    default hr_api.g_number
  ,p_program_id                     in  number    default hr_api.g_number
  ,p_program_update_date            in  date      default hr_api.g_date
  ,p_effective_date                 in  date
  ,p_datetrack_mode                 in  varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_PRTT_PREM';
Line: 973

  savepoint update_PRTT_PREM;
Line: 985

    ben_PRTT_PREM_bk2.update_PRTT_PREM_b
      (
       p_prtt_prem_id                   =>  p_prtt_prem_id
      ,p_std_prem_uom                   =>  p_std_prem_uom
      ,p_std_prem_val                   =>  p_std_prem_val
      ,p_actl_prem_id                   =>  p_actl_prem_id
      ,p_prtt_enrt_rslt_id              =>  p_prtt_enrt_rslt_id
      ,p_per_in_ler_id              =>  p_per_in_ler_id
      ,p_business_group_id              =>  p_business_group_id
      ,p_ppe_attribute_category         =>  p_ppe_attribute_category
      ,p_ppe_attribute1                 =>  p_ppe_attribute1
      ,p_ppe_attribute2                 =>  p_ppe_attribute2
      ,p_ppe_attribute3                 =>  p_ppe_attribute3
      ,p_ppe_attribute4                 =>  p_ppe_attribute4
      ,p_ppe_attribute5                 =>  p_ppe_attribute5
      ,p_ppe_attribute6                 =>  p_ppe_attribute6
      ,p_ppe_attribute7                 =>  p_ppe_attribute7
      ,p_ppe_attribute8                 =>  p_ppe_attribute8
      ,p_ppe_attribute9                 =>  p_ppe_attribute9
      ,p_ppe_attribute10                =>  p_ppe_attribute10
      ,p_ppe_attribute11                =>  p_ppe_attribute11
      ,p_ppe_attribute12                =>  p_ppe_attribute12
      ,p_ppe_attribute13                =>  p_ppe_attribute13
      ,p_ppe_attribute14                =>  p_ppe_attribute14
      ,p_ppe_attribute15                =>  p_ppe_attribute15
      ,p_ppe_attribute16                =>  p_ppe_attribute16
      ,p_ppe_attribute17                =>  p_ppe_attribute17
      ,p_ppe_attribute18                =>  p_ppe_attribute18
      ,p_ppe_attribute19                =>  p_ppe_attribute19
      ,p_ppe_attribute20                =>  p_ppe_attribute20
      ,p_ppe_attribute21                =>  p_ppe_attribute21
      ,p_ppe_attribute22                =>  p_ppe_attribute22
      ,p_ppe_attribute23                =>  p_ppe_attribute23
      ,p_ppe_attribute24                =>  p_ppe_attribute24
      ,p_ppe_attribute25                =>  p_ppe_attribute25
      ,p_ppe_attribute26                =>  p_ppe_attribute26
      ,p_ppe_attribute27                =>  p_ppe_attribute27
      ,p_ppe_attribute28                =>  p_ppe_attribute28
      ,p_ppe_attribute29                =>  p_ppe_attribute29
      ,p_ppe_attribute30                =>  p_ppe_attribute30
      ,p_object_version_number          =>  p_object_version_number
      ,p_request_id                     =>  p_request_id
      ,p_program_application_id         =>  p_program_application_id
      ,p_program_id                     =>  p_program_id
      ,p_program_update_date            =>  p_program_update_date
    ,p_effective_date                      => trunc(p_effective_date)
    ,p_datetrack_mode                      => p_datetrack_mode
      );
Line: 1036

        (p_module_name => 'UPDATE_PRTT_PREM'
        ,p_hook_type   => 'BP'
        );
Line: 1090

    ,p_program_update_date           => p_program_update_date
    ,p_effective_date                => trunc(p_effective_date)
    ,p_datetrack_mode                => p_datetrack_mode
    );
Line: 1099

    ben_PRTT_PREM_bk2.update_PRTT_PREM_a
      (
       p_prtt_prem_id                   =>  p_prtt_prem_id
      ,p_effective_start_date           =>  l_effective_start_date
      ,p_effective_end_date             =>  l_effective_end_date
      ,p_std_prem_uom                   =>  p_std_prem_uom
      ,p_std_prem_val                   =>  p_std_prem_val
      ,p_actl_prem_id                   =>  p_actl_prem_id
      ,p_prtt_enrt_rslt_id              =>  p_prtt_enrt_rslt_id
      ,p_per_in_ler_id              =>  p_per_in_ler_id
      ,p_business_group_id              =>  p_business_group_id
      ,p_ppe_attribute_category         =>  p_ppe_attribute_category
      ,p_ppe_attribute1                 =>  p_ppe_attribute1
      ,p_ppe_attribute2                 =>  p_ppe_attribute2
      ,p_ppe_attribute3                 =>  p_ppe_attribute3
      ,p_ppe_attribute4                 =>  p_ppe_attribute4
      ,p_ppe_attribute5                 =>  p_ppe_attribute5
      ,p_ppe_attribute6                 =>  p_ppe_attribute6
      ,p_ppe_attribute7                 =>  p_ppe_attribute7
      ,p_ppe_attribute8                 =>  p_ppe_attribute8
      ,p_ppe_attribute9                 =>  p_ppe_attribute9
      ,p_ppe_attribute10                =>  p_ppe_attribute10
      ,p_ppe_attribute11                =>  p_ppe_attribute11
      ,p_ppe_attribute12                =>  p_ppe_attribute12
      ,p_ppe_attribute13                =>  p_ppe_attribute13
      ,p_ppe_attribute14                =>  p_ppe_attribute14
      ,p_ppe_attribute15                =>  p_ppe_attribute15
      ,p_ppe_attribute16                =>  p_ppe_attribute16
      ,p_ppe_attribute17                =>  p_ppe_attribute17
      ,p_ppe_attribute18                =>  p_ppe_attribute18
      ,p_ppe_attribute19                =>  p_ppe_attribute19
      ,p_ppe_attribute20                =>  p_ppe_attribute20
      ,p_ppe_attribute21                =>  p_ppe_attribute21
      ,p_ppe_attribute22                =>  p_ppe_attribute22
      ,p_ppe_attribute23                =>  p_ppe_attribute23
      ,p_ppe_attribute24                =>  p_ppe_attribute24
      ,p_ppe_attribute25                =>  p_ppe_attribute25
      ,p_ppe_attribute26                =>  p_ppe_attribute26
      ,p_ppe_attribute27                =>  p_ppe_attribute27
      ,p_ppe_attribute28                =>  p_ppe_attribute28
      ,p_ppe_attribute29                =>  p_ppe_attribute29
      ,p_ppe_attribute30                =>  p_ppe_attribute30
      ,p_object_version_number          =>  l_object_version_number
      ,p_request_id                     =>  p_request_id
      ,p_program_application_id         =>  p_program_application_id
      ,p_program_id                     =>  p_program_id
      ,p_program_update_date            =>  p_program_update_date
      ,p_effective_date                     => trunc(p_effective_date)
      ,p_datetrack_mode                     => p_datetrack_mode
      );
Line: 1152

        (p_module_name => 'UPDATE_PRTT_PREM'
        ,p_hook_type   => 'AP'
        );
Line: 1183

    ROLLBACK TO update_PRTT_PREM;
Line: 1195

    ROLLBACK TO update_PRTT_PREM;
Line: 1198

end update_PRTT_PREM;
Line: 1203

procedure update_PRTT_PREM
  (p_validate                       in  boolean   default false
  ,p_prtt_prem_id                   in  number
  ,p_effective_start_date           out nocopy date
  ,p_effective_end_date             out nocopy date
  ,p_std_prem_uom                   in  varchar2  default hr_api.g_varchar2
  ,p_std_prem_val                   in  number    default hr_api.g_number
  ,p_actl_prem_id                   in  number    default hr_api.g_number
  ,p_prtt_enrt_rslt_id              in  number    default hr_api.g_number
  ,p_business_group_id              in  number    default hr_api.g_number
  ,p_ppe_attribute_category         in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute1                 in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute2                 in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute3                 in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute4                 in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute5                 in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute6                 in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute7                 in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute8                 in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute9                 in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute10                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute11                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute12                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute13                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute14                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute15                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute16                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute17                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute18                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute19                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute20                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute21                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute22                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute23                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute24                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute25                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute26                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute27                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute28                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute29                in  varchar2  default hr_api.g_varchar2
  ,p_ppe_attribute30                in  varchar2  default hr_api.g_varchar2
  ,p_object_version_number          in out nocopy number
  ,p_request_id                     in  number    default hr_api.g_number
  ,p_program_application_id         in  number    default hr_api.g_number
  ,p_program_id                     in  number    default hr_api.g_number
  ,p_program_update_date            in  date      default hr_api.g_date
  ,p_effective_date                 in  date
  ,p_datetrack_mode                 in  varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_PRTT_PREM';
Line: 1262

    select pen.per_in_ler_id
    from   ben_prtt_enrt_rslt_f pen
    where  pen.prtt_enrt_rslt_id=p_prtt_enrt_rslt_id and
           pen.prtt_enrt_rslt_stat_cd is null and
           pen.business_group_id+0=p_business_group_id and
           p_effective_date between
             pen.effective_start_date and pen.effective_end_date;
Line: 1276

  savepoint update_PRTT_PREM;
Line: 1295

    ben_PRTT_PREM_bk2.update_PRTT_PREM_b
      (
       p_prtt_prem_id                   =>  p_prtt_prem_id
      ,p_std_prem_uom                   =>  p_std_prem_uom
      ,p_std_prem_val                   =>  p_std_prem_val
      ,p_actl_prem_id                   =>  p_actl_prem_id
      ,p_prtt_enrt_rslt_id              =>  p_prtt_enrt_rslt_id
      ,p_per_in_ler_id              =>  l_per_in_ler_id
      ,p_business_group_id              =>  p_business_group_id
      ,p_ppe_attribute_category         =>  p_ppe_attribute_category
      ,p_ppe_attribute1                 =>  p_ppe_attribute1
      ,p_ppe_attribute2                 =>  p_ppe_attribute2
      ,p_ppe_attribute3                 =>  p_ppe_attribute3
      ,p_ppe_attribute4                 =>  p_ppe_attribute4
      ,p_ppe_attribute5                 =>  p_ppe_attribute5
      ,p_ppe_attribute6                 =>  p_ppe_attribute6
      ,p_ppe_attribute7                 =>  p_ppe_attribute7
      ,p_ppe_attribute8                 =>  p_ppe_attribute8
      ,p_ppe_attribute9                 =>  p_ppe_attribute9
      ,p_ppe_attribute10                =>  p_ppe_attribute10
      ,p_ppe_attribute11                =>  p_ppe_attribute11
      ,p_ppe_attribute12                =>  p_ppe_attribute12
      ,p_ppe_attribute13                =>  p_ppe_attribute13
      ,p_ppe_attribute14                =>  p_ppe_attribute14
      ,p_ppe_attribute15                =>  p_ppe_attribute15
      ,p_ppe_attribute16                =>  p_ppe_attribute16
      ,p_ppe_attribute17                =>  p_ppe_attribute17
      ,p_ppe_attribute18                =>  p_ppe_attribute18
      ,p_ppe_attribute19                =>  p_ppe_attribute19
      ,p_ppe_attribute20                =>  p_ppe_attribute20
      ,p_ppe_attribute21                =>  p_ppe_attribute21
      ,p_ppe_attribute22                =>  p_ppe_attribute22
      ,p_ppe_attribute23                =>  p_ppe_attribute23
      ,p_ppe_attribute24                =>  p_ppe_attribute24
      ,p_ppe_attribute25                =>  p_ppe_attribute25
      ,p_ppe_attribute26                =>  p_ppe_attribute26
      ,p_ppe_attribute27                =>  p_ppe_attribute27
      ,p_ppe_attribute28                =>  p_ppe_attribute28
      ,p_ppe_attribute29                =>  p_ppe_attribute29
      ,p_ppe_attribute30                =>  p_ppe_attribute30
      ,p_object_version_number          =>  p_object_version_number
      ,p_request_id                     =>  p_request_id
      ,p_program_application_id         =>  p_program_application_id
      ,p_program_id                     =>  p_program_id
      ,p_program_update_date            =>  p_program_update_date
    ,p_effective_date                      => trunc(p_effective_date)
    ,p_datetrack_mode                      => p_datetrack_mode
      );
Line: 1346

        (p_module_name => 'UPDATE_PRTT_PREM'
        ,p_hook_type   => 'BP'
        );
Line: 1400

    ,p_program_update_date           => p_program_update_date
    ,p_effective_date                => trunc(p_effective_date)
    ,p_datetrack_mode                => p_datetrack_mode
    );
Line: 1409

    ben_PRTT_PREM_bk2.update_PRTT_PREM_a
      (
       p_prtt_prem_id                   =>  p_prtt_prem_id
      ,p_effective_start_date           =>  l_effective_start_date
      ,p_effective_end_date             =>  l_effective_end_date
      ,p_std_prem_uom                   =>  p_std_prem_uom
      ,p_std_prem_val                   =>  p_std_prem_val
      ,p_actl_prem_id                   =>  p_actl_prem_id
      ,p_prtt_enrt_rslt_id              =>  p_prtt_enrt_rslt_id
      ,p_per_in_ler_id              =>  l_per_in_ler_id
      ,p_business_group_id              =>  p_business_group_id
      ,p_ppe_attribute_category         =>  p_ppe_attribute_category
      ,p_ppe_attribute1                 =>  p_ppe_attribute1
      ,p_ppe_attribute2                 =>  p_ppe_attribute2
      ,p_ppe_attribute3                 =>  p_ppe_attribute3
      ,p_ppe_attribute4                 =>  p_ppe_attribute4
      ,p_ppe_attribute5                 =>  p_ppe_attribute5
      ,p_ppe_attribute6                 =>  p_ppe_attribute6
      ,p_ppe_attribute7                 =>  p_ppe_attribute7
      ,p_ppe_attribute8                 =>  p_ppe_attribute8
      ,p_ppe_attribute9                 =>  p_ppe_attribute9
      ,p_ppe_attribute10                =>  p_ppe_attribute10
      ,p_ppe_attribute11                =>  p_ppe_attribute11
      ,p_ppe_attribute12                =>  p_ppe_attribute12
      ,p_ppe_attribute13                =>  p_ppe_attribute13
      ,p_ppe_attribute14                =>  p_ppe_attribute14
      ,p_ppe_attribute15                =>  p_ppe_attribute15
      ,p_ppe_attribute16                =>  p_ppe_attribute16
      ,p_ppe_attribute17                =>  p_ppe_attribute17
      ,p_ppe_attribute18                =>  p_ppe_attribute18
      ,p_ppe_attribute19                =>  p_ppe_attribute19
      ,p_ppe_attribute20                =>  p_ppe_attribute20
      ,p_ppe_attribute21                =>  p_ppe_attribute21
      ,p_ppe_attribute22                =>  p_ppe_attribute22
      ,p_ppe_attribute23                =>  p_ppe_attribute23
      ,p_ppe_attribute24                =>  p_ppe_attribute24
      ,p_ppe_attribute25                =>  p_ppe_attribute25
      ,p_ppe_attribute26                =>  p_ppe_attribute26
      ,p_ppe_attribute27                =>  p_ppe_attribute27
      ,p_ppe_attribute28                =>  p_ppe_attribute28
      ,p_ppe_attribute29                =>  p_ppe_attribute29
      ,p_ppe_attribute30                =>  p_ppe_attribute30
      ,p_object_version_number          =>  l_object_version_number
      ,p_request_id                     =>  p_request_id
      ,p_program_application_id         =>  p_program_application_id
      ,p_program_id                     =>  p_program_id
      ,p_program_update_date            =>  p_program_update_date
      ,p_effective_date                     => trunc(p_effective_date)
      ,p_datetrack_mode                     => p_datetrack_mode
      );
Line: 1462

        (p_module_name => 'UPDATE_PRTT_PREM'
        ,p_hook_type   => 'AP'
        );
Line: 1493

    ROLLBACK TO update_PRTT_PREM;
Line: 1505

    ROLLBACK TO update_PRTT_PREM;
Line: 1508

end update_PRTT_PREM;
Line: 1513

procedure delete_PRTT_PREM
  (p_validate                       in  boolean  default false
  ,p_prtt_prem_id                   in  number
  ,p_effective_start_date           out nocopy date
  ,p_effective_end_date             out nocopy date
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in  date
  ,p_datetrack_mode                 in  varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_PRTT_PREM';
Line: 1536

  savepoint delete_PRTT_PREM;
Line: 1549

    ben_PRTT_PREM_bk3.delete_PRTT_PREM_b
      (
       p_prtt_prem_id                   =>  p_prtt_prem_id
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
    ,p_datetrack_mode                      => p_datetrack_mode
      );
Line: 1559

        (p_module_name => 'DELETE_PRTT_PREM'
        ,p_hook_type   => 'BP'
        );
Line: 1581

    ben_PRTT_PREM_bk3.delete_PRTT_PREM_a
      (
       p_prtt_prem_id                   =>  p_prtt_prem_id
      ,p_effective_start_date           =>  l_effective_start_date
      ,p_effective_end_date             =>  l_effective_end_date
      ,p_object_version_number          =>  l_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
    ,p_datetrack_mode                      => p_datetrack_mode
      );
Line: 1593

        (p_module_name => 'DELETE_PRTT_PREM'
        ,p_hook_type   => 'AP'
        );
Line: 1618

    ROLLBACK TO delete_PRTT_PREM;
Line: 1631

    ROLLBACK TO delete_PRTT_PREM;
Line: 1634

end delete_PRTT_PREM;