1 Package hr_de_soc_ins_cle_bk1 as
2 /* $Header: hrcleapi.pkh 120.1 2005/10/02 02:00:02 aroussel $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |---------------------------< create_soc_ins_contributions_b >-----------------|
6 -- ----------------------------------------------------------------------------
7 --
8 procedure create_soc_ins_contributions_b
9 (
10
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_effective_date IN date
50 , p_flat_tax_limit_per_month IN number
51 , p_flat_tax_limit_per_year IN number
52 , p_min_increased_contribution IN number
53 , p_max_increased_contribution IN number
54 , p_month1 IN varchar2
55 , p_month1_min_contribution IN number
56 , p_month1_max_contribution IN number
57 , p_month2 IN varchar2
58 , p_month2_min_contribution IN number
59 , p_month2_max_contribution IN number
60 , p_employee_contribution IN number
61 , p_contribution_level_type IN varchar2
62 );
63 --
64 -- ----------------------------------------------------------------------------
65 -- |---------------------------< create_soc_ins_contributions_a >-----------------|
66 -- ----------------------------------------------------------------------------
67 --
68 procedure create_soc_ins_contributions_a
69 (
70 p_soc_ins_contr_lvls_id IN number
71 , p_organization_id IN number
72 , p_normal_percentage IN number
73 , p_normal_amount IN number
74 , p_increased_percentage IN number
75 , p_increased_amount IN number
76 , p_reduced_percentage IN number
77 , p_reduced_amount IN number
78 , p_attribute_category IN varchar2
79 , p_attribute1 IN varchar2
80 , p_attribute2 IN varchar2
81 , p_attribute3 IN varchar2
82 , p_attribute4 IN varchar2
83 , p_attribute5 IN varchar2
84 , p_attribute6 IN varchar2
85 , p_attribute7 IN varchar2
86 , p_attribute8 IN varchar2
87 , p_attribute9 IN varchar2
88 , p_attribute10 IN varchar2
89 , p_attribute11 IN varchar2
90 , p_attribute12 IN varchar2
91 , p_attribute13 IN varchar2
92 , p_attribute14 IN varchar2
93 , p_attribute15 IN varchar2
94 , p_attribute16 IN varchar2
95 , p_attribute17 IN varchar2
96 , p_attribute18 IN varchar2
97 , p_attribute19 IN varchar2
98 , p_attribute20 IN varchar2
99 , p_attribute21 IN varchar2
100 , p_attribute22 IN varchar2
101 , p_attribute23 IN varchar2
102 , p_attribute24 IN varchar2
103 , p_attribute25 IN varchar2
104 , p_attribute26 IN varchar2
105 , p_attribute27 IN varchar2
106 , p_attribute28 IN varchar2
107 , p_attribute29 IN varchar2
108 , p_attribute30 IN varchar2
109 , p_effective_start_date IN date
110 , p_effective_end_date IN date
111 , p_object_version_number IN number
112 , p_effective_date IN date
113 , p_flat_tax_limit_per_month IN number
114 , p_flat_tax_limit_per_year IN number
115 , p_min_increased_contribution IN number
116 , p_max_increased_contribution IN number
117 , p_month1 IN varchar2
118 , p_month1_min_contribution IN number
119 , p_month1_max_contribution IN number
120 , p_month2 IN varchar2
121 , p_month2_min_contribution IN number
122 , p_month2_max_contribution IN number
123 , p_employee_contribution IN number
124 , p_contribution_level_type IN varchar2
125 );
126 --
127 end hr_de_soc_ins_cle_bk1;