1 package ben_dt_trgr_handle AUTHID CURRENT_USER as
2 /*$Header: bendttrg.pkh 120.1 2005/06/01 11:52:20 ikasire noship $*/
3 --
4 --
5 procedure person(p_rowid in VARCHAR2
6 ,p_business_group_id in NUMBER
7 ,p_person_id in NUMBER
8 ,p_effective_start_date in DATE
9 ,p_effective_end_date in DATE
10 ,p_date_of_birth in DATE
11 ,p_date_of_death in DATE
12 ,p_marital_status in VARCHAR2
13 ,p_on_military_service in VARCHAR2
14 ,p_registered_disabled_flag in VARCHAR2
15 ,p_sex in VARCHAR2
16 ,p_student_status in VARCHAR2
17 ,p_coord_ben_med_pln_no in VARCHAR2
18 ,p_coord_ben_no_cvg_flag in VARCHAR2
19 ,p_uses_tobacco_flag in VARCHAR2
20 ,p_benefit_group_id in NUMBER
21 ,p_per_information10 in VARCHAR2
22 ,p_dpdnt_vlntry_svce_flag in VARCHAR2
23 ,p_receipt_of_death_cert_date in DATE
24 ,p_attribute1 in VARCHAR2
25 ,p_attribute2 in VARCHAR2
26 ,p_attribute3 in VARCHAR2
27 ,p_attribute4 in VARCHAR2
28 ,p_attribute5 in VARCHAR2
29 ,p_attribute6 in VARCHAR2
30 ,p_attribute7 in VARCHAR2
31 ,p_attribute8 in VARCHAR2
32 ,p_attribute9 in VARCHAR2
33 ,p_attribute10 in VARCHAR2
34 ,p_attribute11 in VARCHAR2
35 ,p_attribute12 in VARCHAR2
36 ,p_attribute13 in VARCHAR2
37 ,p_attribute14 in VARCHAR2
38 ,p_attribute15 in VARCHAR2
39 ,p_attribute16 in VARCHAR2
40 ,p_attribute17 in VARCHAR2
41 ,p_attribute18 in VARCHAR2
42 ,p_attribute19 in VARCHAR2
43 ,p_attribute20 in VARCHAR2
44 ,p_attribute21 in VARCHAR2
45 ,p_attribute22 in VARCHAR2
46 ,p_attribute23 in VARCHAR2
47 ,p_attribute24 in VARCHAR2
48 ,p_attribute25 in VARCHAR2
49 ,p_attribute26 in VARCHAR2
50 ,p_attribute27 in VARCHAR2
51 ,p_attribute28 in VARCHAR2
52 ,p_attribute29 in VARCHAR2
53 ,p_attribute30 in VARCHAR2
54 );
55 procedure person(p_rowid in VARCHAR2
56 ,p_business_group_id in NUMBER
57 ,p_person_id in NUMBER
58 ,p_effective_start_date in DATE
59 ,p_effective_end_date in DATE
60 ,p_date_of_birth in DATE
61 ,p_date_of_death in DATE
62 ,p_marital_status in VARCHAR2
63 ,p_on_military_service in VARCHAR2
64 ,p_registered_disabled_flag in VARCHAR2
65 ,p_sex in VARCHAR2
66 ,p_student_status in VARCHAR2
67 ,p_coord_ben_med_pln_no in VARCHAR2
68 ,p_coord_ben_no_cvg_flag in VARCHAR2
69 ,p_uses_tobacco_flag in VARCHAR2
70 ,p_benefit_group_id in NUMBER
71 ,p_per_information10 in VARCHAR2
72 ,p_original_date_of_hire in DATE
73 ,p_dpdnt_vlntry_svce_flag in VARCHAR2
74 ,p_receipt_of_death_cert_date in DATE
75 ,p_attribute1 in VARCHAR2
76 ,p_attribute2 in VARCHAR2
77 ,p_attribute3 in VARCHAR2
78 ,p_attribute4 in VARCHAR2
79 ,p_attribute5 in VARCHAR2
80 ,p_attribute6 in VARCHAR2
81 ,p_attribute7 in VARCHAR2
82 ,p_attribute8 in VARCHAR2
83 ,p_attribute9 in VARCHAR2
84 ,p_attribute10 in VARCHAR2
85 ,p_attribute11 in VARCHAR2
86 ,p_attribute12 in VARCHAR2
87 ,p_attribute13 in VARCHAR2
88 ,p_attribute14 in VARCHAR2
89 ,p_attribute15 in VARCHAR2
90 ,p_attribute16 in VARCHAR2
91 ,p_attribute17 in VARCHAR2
92 ,p_attribute18 in VARCHAR2
93 ,p_attribute19 in VARCHAR2
94 ,p_attribute20 in VARCHAR2
95 ,p_attribute21 in VARCHAR2
96 ,p_attribute22 in VARCHAR2
97 ,p_attribute23 in VARCHAR2
98 ,p_attribute24 in VARCHAR2
99 ,p_attribute25 in VARCHAR2
100 ,p_attribute26 in VARCHAR2
101 ,p_attribute27 in VARCHAR2
102 ,p_attribute28 in VARCHAR2
103 ,p_attribute29 in VARCHAR2
104 ,p_attribute30 in VARCHAR2
105 );
106 procedure assignment
107 (p_rowid IN VARCHAR2
108 ,p_assignment_id IN NUMBER
109 ,p_business_group_id IN NUMBER
110 ,p_person_id in NUMBER
111 ,p_effective_start_date in DATE
112 ,p_effective_end_date in DATE
113 ,p_assignment_status_type_id IN NUMBER
114 ,p_assignment_type IN VARCHAR2
115 ,p_organization_id IN NUMBER
116 ,p_primary_flag IN VARCHAR2
117 ,p_change_reason IN VARCHAR2
118 ,p_employment_category IN VARCHAR2
119 ,p_frequency IN VARCHAR2
120 ,p_grade_id IN NUMBER
121 ,p_job_id IN NUMBER
122 ,p_position_id IN NUMBER
123 ,p_location_id IN NUMBER
124 ,p_normal_hours IN VARCHAR2
125 ,p_payroll_id in NUMBER
126 ,p_pay_basis_id IN NUMBER
127 ,p_bargaining_unit_code IN VARCHAR2
128 ,p_labour_union_member_flag IN VARCHAR2
129 ,p_hourly_salaried_code IN VARCHAR2
130 ,p_people_group_id IN NUMBER
131 ,p_ass_attribute1 in VARCHAR2
132 ,p_ass_attribute2 in VARCHAR2
133 ,p_ass_attribute3 in VARCHAR2
134 ,p_ass_attribute4 in VARCHAR2
135 ,p_ass_attribute5 in VARCHAR2
136 ,p_ass_attribute6 in VARCHAR2
137 ,p_ass_attribute7 in VARCHAR2
138 ,p_ass_attribute8 in VARCHAR2
139 ,p_ass_attribute9 in VARCHAR2
140 ,p_ass_attribute10 in VARCHAR2
141 ,p_ass_attribute11 in VARCHAR2
142 ,p_ass_attribute12 in VARCHAR2
143 ,p_ass_attribute13 in VARCHAR2
144 ,p_ass_attribute14 in VARCHAR2
145 ,p_ass_attribute15 in VARCHAR2
146 ,p_ass_attribute16 in VARCHAR2
147 ,p_ass_attribute17 in VARCHAR2
148 ,p_ass_attribute18 in VARCHAR2
149 ,p_ass_attribute19 in VARCHAR2
150 ,p_ass_attribute20 in VARCHAR2
151 ,p_ass_attribute21 in VARCHAR2
152 ,p_ass_attribute22 in VARCHAR2
153 ,p_ass_attribute23 in VARCHAR2
154 ,p_ass_attribute24 in VARCHAR2
155 ,p_ass_attribute25 in VARCHAR2
156 ,p_ass_attribute26 in VARCHAR2
157 ,p_ass_attribute27 in VARCHAR2
158 ,p_ass_attribute28 in VARCHAR2
159 ,p_ass_attribute29 in VARCHAR2
160 ,p_ass_attribute30 in VARCHAR2
161 );
162 /*
163 procedure person_type_usages(p_rowid in VARCHAR2
164 ,p_person_id IN NUMBER
165 ,p_person_type_id IN NUMBER
166 -- ,p_effective_start_date in DATE
167 --p_effective_end_date in DATE
168 );
169 */
170 procedure periods_of_service
171 (p_rowid in VARCHAR2
172 ,p_person_id IN NUMBER
173 ,p_pds_atd IN date
174 ,p_pds_leaving_reason in VARCHAR2
175 ,p_pds_fpd IN date
176 ,p_pds_old_atd IN date default null
177 );
178 procedure bnfts_bal
179 (p_rowid in VARCHAR2
180 ,p_business_group_id IN NUMBER
181 ,p_person_id IN NUMBER
182 ,p_effective_start_date in DATE
183 ,p_effective_end_date in DATE
184 ,p_val IN NUMBER
185 ,p_bnfts_bal_id in NUMBER
186 );
187 --
188 procedure bnfts_bal
189 (p_rowid in VARCHAR2
190 ,p_per_bnfts_bal_id in NUMBER
191 ,p_business_group_id IN NUMBER
192 ,p_person_id IN NUMBER
193 ,p_effective_start_date in DATE
194 ,p_effective_end_date in DATE
195 ,p_val IN NUMBER
196 ,p_bnfts_bal_id in NUMBER
197 );
198
199 procedure elig_cvrd_dpnt
200 (p_rowid in VARCHAR2
201 ,p_business_group_id IN NUMBER
202 ,p_dpnt_person_id IN NUMBER
203 ,p_prtt_enrt_rslt_id IN NUMBER
204 ,p_effective_start_date in DATE
205 ,p_effective_end_date in DATE
206 ,p_cvg_strt_dt IN DATE
207 ,p_cvg_thru_dt in DATE
208 ,p_ovrdn_flag in VARCHAR2
209 ,p_ovrdn_thru_dt in DATE
210 );
211 --
212 procedure elig_cvrd_dpnt
213 (p_rowid in VARCHAR2
214 ,p_elig_cvrd_dpnt_id in number
215 ,p_business_group_id IN NUMBER
216 ,p_dpnt_person_id IN NUMBER
217 ,p_prtt_enrt_rslt_id IN NUMBER
218 ,p_effective_start_date in DATE
219 ,p_effective_end_date in DATE
220 ,p_cvg_strt_dt IN DATE
221 ,p_cvg_thru_dt in DATE
222 ,p_ovrdn_flag in VARCHAR2
223 ,p_ovrdn_thru_dt in DATE
224 );
225
226 procedure prtt_enrt_rslt
227 (p_rowid in VARCHAR2
228 ,p_business_group_id IN NUMBER
229 ,p_person_id IN NUMBER
230 ,p_enrt_cvg_strt_dt in DATE
231 ,p_enrt_cvg_thru_dt in DATE
232 ,p_bnft_amt IN NUMBER
233 ,p_effective_start_date in DATE
234 ,p_effective_end_date in DATE
235 );
236 --
237 procedure prtt_enrt_rslt
238 (p_rowid in VARCHAR2
239 ,p_prtt_enrt_rslt_id in number
240 ,p_business_group_id IN NUMBER
241 ,p_person_id IN NUMBER
242 ,p_enrt_cvg_strt_dt in DATE
243 ,p_enrt_cvg_thru_dt in DATE
244 ,p_bnft_amt IN NUMBER
245 ,p_effective_start_date in DATE
246 ,p_effective_end_date in DATE
247 );
248
249 --procedure elem_entry_values
250 -- (p_rowid in VARCHAR2
251 -- ,p_element_entry_value_id IN NUMBER
252 -- ,p_screen_entry_value IN VARCHAR2
253 --);
254
255 --procedure asgn_budget_values
256 -- (p_rowid in VARCHAR2
257 -- ,p_assignment_id IN NUMBER
258 -- ,p_business_group_id IN NUMBER
259 -- ,p_value IN NUMBER
260 -- ,p_assignment_budget_value_id IN NUMBER
261 --/*** ,effective_start_date DATE
262 -- ,effective_end_date DATE ***/
263 --);
264
265 end ben_dt_trgr_handle;