1 Package hr_de_soc_ins_cle_bk2 as
2 /* $Header: hrcleapi.pkh 120.1 2005/10/02 02:00:02 aroussel $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |---------------------------< update_soc_ins_contributions_b >-----------------|
6 -- ----------------------------------------------------------------------------
7 --
8 procedure update_soc_ins_contributions_b
9 (
10 p_soc_ins_contr_lvls_id IN number
11 , p_organization_id IN number
12 , p_normal_percentage IN number
13 , p_normal_amount IN number
14 , p_increased_percentage IN number
15 , p_increased_amount IN number
16 , p_reduced_percentage IN number
17 , p_reduced_amount IN number
18 , p_attribute_category IN varchar2
19 , p_attribute1 IN varchar2
20 , p_attribute2 IN varchar2
21 , p_attribute3 IN varchar2
22 , p_attribute4 IN varchar2
23 , p_attribute5 IN varchar2
24 , p_attribute6 IN varchar2
25 , p_attribute7 IN varchar2
26 , p_attribute8 IN varchar2
27 , p_attribute9 IN varchar2
28 , p_attribute10 IN varchar2
29 , p_attribute11 IN varchar2
30 , p_attribute12 IN varchar2
31 , p_attribute13 IN varchar2
32 , p_attribute14 IN varchar2
33 , p_attribute15 IN varchar2
34 , p_attribute16 IN varchar2
35 , p_attribute17 IN varchar2
36 , p_attribute18 IN varchar2
37 , p_attribute19 IN varchar2
38 , p_attribute20 IN varchar2
39 , p_attribute21 IN varchar2
40 , p_attribute22 IN varchar2
41 , p_attribute23 IN varchar2
42 , p_attribute24 IN varchar2
43 , p_attribute25 IN varchar2
44 , p_attribute26 IN varchar2
45 , p_attribute27 IN varchar2
46 , p_attribute28 IN varchar2
47 , p_attribute29 IN varchar2
48 , p_attribute30 IN varchar2
49 ,p_object_version_number in number
50 ,p_effective_date in date
51 ,p_datetrack_mode in varchar2
52 , p_flat_tax_limit_per_month IN number
53 , p_flat_tax_limit_per_year IN number
54 , p_min_increased_contribution IN number
55 , p_max_increased_contribution IN number
56 , p_month1 IN varchar2
57 , p_month1_min_contribution IN number
58 , p_month1_max_contribution IN number
59 , p_month2 IN varchar2
60 , p_month2_min_contribution IN number
61 , p_month2_max_contribution IN number
62 , p_employee_contribution IN number
63 , p_contribution_level_type IN varchar2
64 );
65 --
66 -- ----------------------------------------------------------------------------
67 -- |---------------------------< update_soc_ins_contributions_a >-----------------|
68 -- ----------------------------------------------------------------------------
69 --
70 procedure update_soc_ins_contributions_a
71 (
72 p_soc_ins_contr_lvls_id IN number
73 , p_organization_id IN number
74 , p_normal_percentage IN number
75 , p_normal_amount IN number
76 , p_increased_percentage IN number
77 , p_increased_amount IN number
78 , p_reduced_percentage IN number
79 , p_reduced_amount IN number
80 , p_attribute_category IN varchar2
81 , p_attribute1 IN varchar2
82 , p_attribute2 IN varchar2
83 , p_attribute3 IN varchar2
84 , p_attribute4 IN varchar2
85 , p_attribute5 IN varchar2
86 , p_attribute6 IN varchar2
87 , p_attribute7 IN varchar2
88 , p_attribute8 IN varchar2
89 , p_attribute9 IN varchar2
90 , p_attribute10 IN varchar2
91 , p_attribute11 IN varchar2
92 , p_attribute12 IN varchar2
93 , p_attribute13 IN varchar2
94 , p_attribute14 IN varchar2
95 , p_attribute15 IN varchar2
96 , p_attribute16 IN varchar2
97 , p_attribute17 IN varchar2
98 , p_attribute18 IN varchar2
99 , p_attribute19 IN varchar2
100 , p_attribute20 IN varchar2
101 , p_attribute21 IN varchar2
102 , p_attribute22 IN varchar2
103 , p_attribute23 IN varchar2
104 , p_attribute24 IN varchar2
105 , p_attribute25 IN varchar2
106 , p_attribute26 IN varchar2
107 , p_attribute27 IN varchar2
108 , p_attribute28 IN varchar2
109 , p_attribute29 IN varchar2
110 , p_attribute30 IN varchar2
111 , p_effective_start_date IN date
112 , p_effective_end_date IN date
113 , p_object_version_number IN number
114 , p_effective_date IN date
115 , p_datetrack_mode IN varchar2
116 , p_flat_tax_limit_per_month IN number
117 , p_flat_tax_limit_per_year IN number
118 , p_min_increased_contribution IN number
119 , p_max_increased_contribution IN number
120 , p_month1 IN varchar2
121 , p_month1_min_contribution IN number
122 , p_month1_max_contribution IN number
123 , p_month2 IN varchar2
124 , p_month2_min_contribution IN number
125 , p_month2_max_contribution IN number
126 , p_employee_contribution IN number
127 , p_contribution_level_type IN varchar2
128 );
129 --
130 end hr_de_soc_ins_cle_bk2;
[Home] [Help]