DBA Data[Home] [Help]

PACKAGE: APPS.BEN_BNFT_POOL_RLOVR_RQMT_BK2

Source


1 Package ben_Bnft_Pool_Rlovr_Rqmt_bk2 as
2 /* $Header: bebprapi.pkh 120.0 2005/05/28 00:49:04 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |---------------------------< update_Bnft_Pool_Rlovr_Rqmt_b >-----------------|
6 -- ----------------------------------------------------------------------------
7 --
8 procedure update_Bnft_Pool_Rlovr_Rqmt_b
9   (
10    p_bnft_pool_rlovr_rqmt_id        in  number
11   ,p_no_mn_rlovr_pct_dfnd_flag      in  varchar2
12   ,p_no_mx_rlovr_pct_dfnd_flag      in  varchar2
13   ,p_no_mn_rlovr_val_dfnd_flag      in  varchar2
14   ,p_no_mx_rlovr_val_dfnd_flag      in  varchar2
15   ,p_rlovr_val_incrmt_num           in  number
16   ,p_rlovr_val_rl                   in  number
17   ,p_mn_rlovr_val                   in  number
18   ,p_mx_rlovr_val                   in  number
19   ,p_val_rndg_cd                    in  varchar2
20   ,p_val_rndg_rl                    in  number
21   ,p_pct_rndg_cd                    in  varchar2
22   ,p_pct_rndg_rl                    in  number
23   ,p_prtt_elig_rlovr_rl             in  number
24   ,p_mx_rchd_dflt_ordr_num          in  number
25   ,p_pct_rlovr_incrmt_num           in  number
26   ,p_mn_rlovr_pct_num               in  number
27   ,p_mx_rlovr_pct_num               in  number
28   ,p_crs_rlovr_procg_cd             in  varchar2
29   ,p_mx_pct_ttl_crs_cn_roll_num     in  number
30   ,p_bnft_prvdr_pool_id             in  number
31   ,p_acty_base_rt_id                in  number
32   ,p_business_group_id              in  number
33   ,p_bpr_attribute_category         in  varchar2
34   ,p_bpr_attribute1                 in  varchar2
35   ,p_bpr_attribute2                 in  varchar2
36   ,p_bpr_attribute3                 in  varchar2
37   ,p_bpr_attribute4                 in  varchar2
38   ,p_bpr_attribute5                 in  varchar2
39   ,p_bpr_attribute6                 in  varchar2
40   ,p_bpr_attribute7                 in  varchar2
41   ,p_bpr_attribute8                 in  varchar2
42   ,p_bpr_attribute9                 in  varchar2
43   ,p_bpr_attribute10                in  varchar2
44   ,p_bpr_attribute11                in  varchar2
45   ,p_bpr_attribute12                in  varchar2
46   ,p_bpr_attribute13                in  varchar2
47   ,p_bpr_attribute14                in  varchar2
48   ,p_bpr_attribute15                in  varchar2
49   ,p_bpr_attribute16                in  varchar2
50   ,p_bpr_attribute17                in  varchar2
51   ,p_bpr_attribute18                in  varchar2
52   ,p_bpr_attribute19                in  varchar2
53   ,p_bpr_attribute20                in  varchar2
54   ,p_bpr_attribute21                in  varchar2
55   ,p_bpr_attribute22                in  varchar2
56   ,p_bpr_attribute23                in  varchar2
57   ,p_bpr_attribute24                in  varchar2
58   ,p_bpr_attribute25                in  varchar2
59   ,p_bpr_attribute26                in  varchar2
60   ,p_bpr_attribute27                in  varchar2
61   ,p_bpr_attribute28                in  varchar2
62   ,p_bpr_attribute29                in  varchar2
63   ,p_bpr_attribute30                in  varchar2
64   ,p_object_version_number          in  number
65   ,p_effective_date                 in  date
66   ,p_datetrack_mode                 in  varchar2
67   );
68 --
69 -- ----------------------------------------------------------------------------
70 -- |---------------------------< update_Bnft_Pool_Rlovr_Rqmt_a >-----------------|
71 -- ----------------------------------------------------------------------------
72 --
73 procedure update_Bnft_Pool_Rlovr_Rqmt_a
74   (
75    p_bnft_pool_rlovr_rqmt_id        in  number
76   ,p_effective_start_date           in  date
77   ,p_effective_end_date             in  date
78   ,p_no_mn_rlovr_pct_dfnd_flag      in  varchar2
79   ,p_no_mx_rlovr_pct_dfnd_flag      in  varchar2
80   ,p_no_mn_rlovr_val_dfnd_flag      in  varchar2
81   ,p_no_mx_rlovr_val_dfnd_flag      in  varchar2
82   ,p_rlovr_val_incrmt_num           in  number
83   ,p_rlovr_val_rl                   in  number
84   ,p_mn_rlovr_val                   in  number
85   ,p_mx_rlovr_val                   in  number
86   ,p_val_rndg_cd                    in  varchar2
87   ,p_val_rndg_rl                    in  number
88   ,p_pct_rndg_cd                    in  varchar2
89   ,p_pct_rndg_rl                    in  number
90   ,p_prtt_elig_rlovr_rl             in  number
91   ,p_mx_rchd_dflt_ordr_num          in  number
92   ,p_pct_rlovr_incrmt_num           in  number
93   ,p_mn_rlovr_pct_num               in  number
94   ,p_mx_rlovr_pct_num               in  number
95   ,p_crs_rlovr_procg_cd             in  varchar2
96   ,p_mx_pct_ttl_crs_cn_roll_num     in  number
97   ,p_bnft_prvdr_pool_id             in  number
98   ,p_acty_base_rt_id                in  number
99   ,p_business_group_id              in  number
100   ,p_bpr_attribute_category         in  varchar2
101   ,p_bpr_attribute1                 in  varchar2
102   ,p_bpr_attribute2                 in  varchar2
103   ,p_bpr_attribute3                 in  varchar2
104   ,p_bpr_attribute4                 in  varchar2
105   ,p_bpr_attribute5                 in  varchar2
106   ,p_bpr_attribute6                 in  varchar2
107   ,p_bpr_attribute7                 in  varchar2
108   ,p_bpr_attribute8                 in  varchar2
109   ,p_bpr_attribute9                 in  varchar2
110   ,p_bpr_attribute10                in  varchar2
111   ,p_bpr_attribute11                in  varchar2
112   ,p_bpr_attribute12                in  varchar2
113   ,p_bpr_attribute13                in  varchar2
114   ,p_bpr_attribute14                in  varchar2
115   ,p_bpr_attribute15                in  varchar2
116   ,p_bpr_attribute16                in  varchar2
117   ,p_bpr_attribute17                in  varchar2
118   ,p_bpr_attribute18                in  varchar2
119   ,p_bpr_attribute19                in  varchar2
120   ,p_bpr_attribute20                in  varchar2
121   ,p_bpr_attribute21                in  varchar2
122   ,p_bpr_attribute22                in  varchar2
123   ,p_bpr_attribute23                in  varchar2
124   ,p_bpr_attribute24                in  varchar2
125   ,p_bpr_attribute25                in  varchar2
126   ,p_bpr_attribute26                in  varchar2
127   ,p_bpr_attribute27                in  varchar2
128   ,p_bpr_attribute28                in  varchar2
129   ,p_bpr_attribute29                in  varchar2
130   ,p_bpr_attribute30                in  varchar2
131   ,p_object_version_number          in  number
132   ,p_effective_date                 in  date
133   ,p_datetrack_mode                 in  varchar2
134   );
135 --
136 end ben_Bnft_Pool_Rlovr_Rqmt_bk2;