1 package BEN_CWB_CUSTOM_PERSON_PKG as
2 /* $Header: bencwbpr.pkh 120.0 2005/05/28 04:00:51 appldev noship $ */
3 -- --------------------------------------------------------------------------
4 -- |---------------------------< get_custom_name >---------------------------|
5 -- --------------------------------------------------------------------------
6 -- Description
7 -- This function returns the custom name
8 --
9 function get_custom_name(p_person_id in number
10 ,p_assignment_id in number
11 ,p_legislation_code in varchar2
12 ,p_group_pl_id in number
13 ,p_lf_evt_ocrd_dt in date
14 ,p_effective_date in date)
15 return varchar2;
16 --
17 -- --------------------------------------------------------------------------
18 -- |-------------------------< get_custom_segment1 >-------------------------|
19 -- --------------------------------------------------------------------------
20 -- Description
21 -- This function returns the custom_segment1
22 --
23 function get_custom_segment1(p_person_id in number
24 ,p_assignment_id in number
25 ,p_legislation_code in varchar2
26 ,p_group_pl_id in number
27 ,p_lf_evt_ocrd_dt in date
28 ,p_effective_date in date)
29 return varchar2;
30 --
31 -- --------------------------------------------------------------------------
32 -- |-------------------------< get_custom_segment2 >-------------------------|
33 -- --------------------------------------------------------------------------
34 -- Description
35 -- This function returns the custom_segment2
36 --
37 function get_custom_segment2(p_person_id in number
38 ,p_assignment_id in number
39 ,p_legislation_code in varchar2
40 ,p_group_pl_id in number
41 ,p_lf_evt_ocrd_dt in date
42 ,p_effective_date in date)
43 return varchar2;
44 --
45 -- --------------------------------------------------------------------------
46 -- |-------------------------< get_custom_segment3 >-------------------------|
47 -- --------------------------------------------------------------------------
48 -- Description
49 -- This function returns the custom_segment3
50 --
51 function get_custom_segment3(p_person_id in number
52 ,p_assignment_id in number
53 ,p_legislation_code in varchar2
54 ,p_group_pl_id in number
55 ,p_lf_evt_ocrd_dt in date
56 ,p_effective_date in date)
57 return varchar2;
58 --
59 -- --------------------------------------------------------------------------
60 -- |-------------------------< get_custom_segment4 >-------------------------|
61 -- --------------------------------------------------------------------------
62 -- Description
63 -- This function returns the custom_segment4
64 --
65 --
66 function get_custom_segment4(p_person_id in number
67 ,p_assignment_id in number
68 ,p_legislation_code in varchar2
69 ,p_group_pl_id in number
70 ,p_lf_evt_ocrd_dt in date
71 ,p_effective_date in date)
72 return varchar2;
73 --
74 -- --------------------------------------------------------------------------
75 -- |-------------------------< get_custom_segment5 >-------------------------|
76 -- --------------------------------------------------------------------------
77 -- Description
78 -- This function returns the custom_segment5
79 --
80 --
81 function get_custom_segment5(p_person_id in number
82 ,p_assignment_id in number
83 ,p_legislation_code in varchar2
84 ,p_group_pl_id in number
85 ,p_lf_evt_ocrd_dt in date
86 ,p_effective_date in date)
87 return varchar2;
88 --
89 -- --------------------------------------------------------------------------
90 -- |-------------------------< get_custom_segment6 >-------------------------|
91 -- --------------------------------------------------------------------------
92 -- Description
93 -- This function returns the custom_segment6
94 --
95 --
96 function get_custom_segment6(p_person_id in number
97 ,p_assignment_id in number
98 ,p_legislation_code in varchar2
99 ,p_group_pl_id in number
100 ,p_lf_evt_ocrd_dt in date
101 ,p_effective_date in date)
102 return varchar2;
103 --
104 -- --------------------------------------------------------------------------
105 -- |-------------------------< get_custom_segment7 >-------------------------|
106 -- --------------------------------------------------------------------------
107 -- Description
108 -- This function returns the custom_segment7
109 --
110 --
111 function get_custom_segment7(p_person_id in number
112 ,p_assignment_id in number
113 ,p_legislation_code in varchar2
114 ,p_group_pl_id in number
115 ,p_lf_evt_ocrd_dt in date
116 ,p_effective_date in date)
117 return varchar2;
118 --
119 -- --------------------------------------------------------------------------
120 -- |-------------------------< get_custom_segment8 >-------------------------|
121 -- --------------------------------------------------------------------------
122 -- Description
123 -- This function returns the custom_segment8
124 --
125 --
126 function get_custom_segment8(p_person_id in number
127 ,p_assignment_id in number
131 ,p_effective_date in date)
128 ,p_legislation_code in varchar2
129 ,p_group_pl_id in number
130 ,p_lf_evt_ocrd_dt in date
135 -- |-------------------------< get_custom_segment9 >-------------------------|
132 return varchar2;
133 --
134 -- --------------------------------------------------------------------------
136 -- --------------------------------------------------------------------------
137 -- Description
138 -- This function returns the custom_segment9
139 --
140 --
141 function get_custom_segment9(p_person_id in number
142 ,p_assignment_id in number
143 ,p_legislation_code in varchar2
144 ,p_group_pl_id in number
145 ,p_lf_evt_ocrd_dt in date
146 ,p_effective_date in date)
147 return varchar2;
148 --
149 -- --------------------------------------------------------------------------
150 -- |-------------------------< get_custom_segment10 >------------------------|
151 -- --------------------------------------------------------------------------
152 -- Description
153 -- This function returns the custom_segment10
154 --
155 --
156 function get_custom_segment10(p_person_id in number
157 ,p_assignment_id in number
158 ,p_legislation_code in varchar2
159 ,p_group_pl_id in number
160 ,p_lf_evt_ocrd_dt in date
161 ,p_effective_date in date)
162 return varchar2;
163 --
164 -- --------------------------------------------------------------------------
165 -- |-------------------------< get_custom_segment11 >-------------------------|
166 -- --------------------------------------------------------------------------
167 -- Description
168 -- This function returns the custom_segment11
169 --
170 function get_custom_segment11(p_person_id in number
171 ,p_assignment_id in number
172 ,p_legislation_code in varchar2
173 ,p_group_pl_id in number
174 ,p_lf_evt_ocrd_dt in date
175 ,p_effective_date in date)
176 return number;
177 --
178 -- --------------------------------------------------------------------------
179 -- |-------------------------< get_custom_segment12 >-------------------------|
180 -- --------------------------------------------------------------------------
181 -- Description
182 -- This function returns the custom_segment12
183 --
184 function get_custom_segment12(p_person_id in number
185 ,p_assignment_id in number
186 ,p_legislation_code in varchar2
187 ,p_group_pl_id in number
188 ,p_lf_evt_ocrd_dt in date
189 ,p_effective_date in date)
190 return number;
191 --
192 -- --------------------------------------------------------------------------
193 -- |-------------------------< get_custom_segment13 >-------------------------|
194 -- --------------------------------------------------------------------------
195 -- Description
196 -- This function returns the custom_segment13
197 --
198 function get_custom_segment13(p_person_id in number
202 ,p_lf_evt_ocrd_dt in date
199 ,p_assignment_id in number
200 ,p_legislation_code in varchar2
201 ,p_group_pl_id in number
203 ,p_effective_date in date)
204 return number;
205 --
206 -- --------------------------------------------------------------------------
207 -- |-------------------------< get_custom_segment14 >-------------------------|
208 -- --------------------------------------------------------------------------
209 -- Description
210 -- This function returns the custom_segment14
211 --
212 --
213 function get_custom_segment14(p_person_id in number
214 ,p_assignment_id in number
215 ,p_legislation_code in varchar2
216 ,p_group_pl_id in number
217 ,p_lf_evt_ocrd_dt in date
218 ,p_effective_date in date)
219 return number;
220 --
221 -- --------------------------------------------------------------------------
222 -- |-------------------------< get_custom_segment15 >-------------------------|
223 -- --------------------------------------------------------------------------
224 -- Description
225 -- This function returns the custom_segment15
226 --
227 --
228 function get_custom_segment15(p_person_id in number
229 ,p_assignment_id in number
230 ,p_legislation_code in varchar2
231 ,p_group_pl_id in number
232 ,p_lf_evt_ocrd_dt in date
233 ,p_effective_date in date)
234 return number;
235 --
236 -- --------------------------------------------------------------------------
237 -- |-------------------------< get_custom_segment16 >-------------------------|
241 --
238 -- --------------------------------------------------------------------------
239 -- Description
240 -- This function returns the custom_segment16
242 --
243 function get_custom_segment16(p_person_id in number
244 ,p_assignment_id in number
245 ,p_legislation_code in varchar2
246 ,p_group_pl_id in number
247 ,p_lf_evt_ocrd_dt in date
248 ,p_effective_date in date)
249 return number;
250 --
251 -- --------------------------------------------------------------------------
252 -- |-------------------------< get_custom_segment17 >-------------------------|
253 -- --------------------------------------------------------------------------
254 -- Description
255 -- This function returns the custom_segment17
256 --
257 --
258 function get_custom_segment17(p_person_id in number
259 ,p_assignment_id in number
260 ,p_legislation_code in varchar2
261 ,p_group_pl_id in number
262 ,p_lf_evt_ocrd_dt in date
263 ,p_effective_date in date)
264 return number;
265 --
266 -- --------------------------------------------------------------------------
267 -- |-------------------------< get_custom_segment18 >-------------------------|
268 -- --------------------------------------------------------------------------
269 -- Description
270 -- This function returns the custom_segment18
271 --
272 --
273 function get_custom_segment18(p_person_id in number
274 ,p_assignment_id in number
275 ,p_legislation_code in varchar2
276 ,p_group_pl_id in number
277 ,p_lf_evt_ocrd_dt in date
278 ,p_effective_date in date)
279 return number;
280 --
281 -- --------------------------------------------------------------------------
282 -- |-------------------------< get_custom_segment19 >-------------------------|
283 -- --------------------------------------------------------------------------
284 -- Description
285 -- This function returns the custom_segment19
286 --
287 --
291 ,p_group_pl_id in number
288 function get_custom_segment19(p_person_id in number
289 ,p_assignment_id in number
290 ,p_legislation_code in varchar2
292 ,p_lf_evt_ocrd_dt in date
293 ,p_effective_date in date)
294 return number;
295 --
296 -- --------------------------------------------------------------------------
297 -- |-------------------------< get_custom_segment20 >-------------------------|
298 -- --------------------------------------------------------------------------
299 -- Description
300 -- This function returns the custom_segment20
301 --
302 --
303 function get_custom_segment20(p_person_id in number
304 ,p_assignment_id in number
305 ,p_legislation_code in varchar2
306 ,p_group_pl_id in number
307 ,p_lf_evt_ocrd_dt in date
308 ,p_effective_date in date)
309 return number;
310 --
311
312
313 end BEN_CWB_CUSTOM_PERSON_PKG;
314