[Home] [Help]
PACKAGE: APPS.PER_JP_DEPENDENT_PKG
Source
1 PACKAGE per_jp_dependent_pkg AUTHID CURRENT_USER AS
2 /* $Header: pejpdepf.pkh 115.1 2002/12/12 11:40:22 ytohya noship $ */
3 --
4 FUNCTION address_count(
5 p_person_id IN NUMBER,
6 p_effective_date IN DATE) RETURN NUMBER;
7 --
8 FUNCTION address_style(
9 p_style IN VARCHAR2) RETURN VARCHAR2;
10 --
11 PROCEDURE address_detail(
12 p_person_id IN NUMBER,
13 p_effective_date IN DATE,
14 p_address_type_meaning OUT NOCOPY VARCHAR2,
15 p_style OUT NOCOPY VARCHAR2,
16 p_primary_flag OUT NOCOPY VARCHAR2,
17 p_address_line1 OUT NOCOPY VARCHAR2,
18 p_address_line2 OUT NOCOPY VARCHAR2,
19 p_address_line3 OUT NOCOPY VARCHAR2,
20 p_country OUT NOCOPY VARCHAR2,
21 p_postal_code OUT NOCOPY VARCHAR2,
22 p_region_1 OUT NOCOPY VARCHAR2,
23 p_region_2 OUT NOCOPY VARCHAR2,
24 p_region_3 OUT NOCOPY VARCHAR2,
25 p_telephone_number_1 OUT NOCOPY VARCHAR2,
26 p_telephone_number_2 OUT NOCOPY VARCHAR2,
27 p_telephone_number_3 OUT NOCOPY VARCHAR2,
28 p_town_or_city OUT NOCOPY VARCHAR2,
29 p_add_information13 OUT NOCOPY VARCHAR2,
30 p_add_information14 OUT NOCOPY VARCHAR2,
31 p_add_information15 OUT NOCOPY VARCHAR2,
32 p_add_information16 OUT NOCOPY VARCHAR2,
33 p_add_information17 OUT NOCOPY VARCHAR2,
34 p_add_information18 OUT NOCOPY VARCHAR2,
35 p_add_information19 OUT NOCOPY VARCHAR2,
36 p_add_information20 OUT NOCOPY VARCHAR2,
37 p_date_from OUT NOCOPY DATE,
38 p_date_to OUT NOCOPY DATE);
39 --
40 PROCEDURE populate_address_fields(
41 p_person_id IN NUMBER,
42 p_effective_date IN DATE,
43 p_count OUT NOCOPY NUMBER,
44 p_d_address_type OUT NOCOPY VARCHAR2,
45 p_style OUT NOCOPY VARCHAR2,
46 p_d_style OUT NOCOPY VARCHAR2,
47 p_primary_flag OUT NOCOPY VARCHAR2,
48 p_address_line1 OUT NOCOPY VARCHAR2,
49 p_address_line2 OUT NOCOPY VARCHAR2,
50 p_address_line3 OUT NOCOPY VARCHAR2,
51 p_country OUT NOCOPY VARCHAR2,
52 p_postal_code OUT NOCOPY VARCHAR2,
53 p_region_1 OUT NOCOPY VARCHAR2,
54 p_region_2 OUT NOCOPY VARCHAR2,
55 p_region_3 OUT NOCOPY VARCHAR2,
56 p_telephone_number_1 OUT NOCOPY VARCHAR2,
57 p_telephone_number_2 OUT NOCOPY VARCHAR2,
58 p_telephone_number_3 OUT NOCOPY VARCHAR2,
59 p_town_or_city OUT NOCOPY VARCHAR2,
60 p_add_information13 OUT NOCOPY VARCHAR2,
61 p_add_information14 OUT NOCOPY VARCHAR2,
62 p_add_information15 OUT NOCOPY VARCHAR2,
63 p_add_information16 OUT NOCOPY VARCHAR2,
64 p_add_information17 OUT NOCOPY VARCHAR2,
65 p_add_information18 OUT NOCOPY VARCHAR2,
66 p_add_information19 OUT NOCOPY VARCHAR2,
67 p_add_information20 OUT NOCOPY VARCHAR2,
68 p_date_from OUT NOCOPY DATE,
69 p_date_to OUT NOCOPY DATE);
70 --
71 FUNCTION phone_count(
72 p_person_id IN NUMBER,
73 p_effective_date IN DATE) RETURN NUMBER;
74 --
75 PROCEDURE phone_detail(
76 p_person_id IN NUMBER,
77 p_effective_date IN DATE,
78 p_phone_type_meaning OUT NOCOPY VARCHAR2,
79 p_phone_number OUT NOCOPY VARCHAR2,
80 p_date_from OUT NOCOPY DATE,
81 p_date_to OUT NOCOPY DATE);
82 --
83 PROCEDURE populate_phone_fields(
84 p_person_id IN NUMBER,
85 p_effective_date IN DATE,
86 p_count OUT NOCOPY NUMBER,
87 p_d_phone_type OUT NOCOPY VARCHAR2,
88 p_phone_number OUT NOCOPY VARCHAR2,
89 p_date_from OUT NOCOPY DATE,
90 p_date_to OUT NOCOPY DATE);
91 --
92 FUNCTION extra_info_count(
93 p_contact_relationship_id IN NUMBER,
94 p_effective_date IN DATE,
95 p_information_type_group IN VARCHAR2) RETURN NUMBER;
96 --
97 PROCEDURE extra_info_detail(
98 p_contact_relationship_id IN NUMBER,
99 p_effective_date IN DATE,
100 p_information_type_group IN VARCHAR2,
101 p_contact_extra_info_id OUT NOCOPY NUMBER,
102 p_information_type OUT NOCOPY VARCHAR2,
103 p_d_information_type OUT NOCOPY VARCHAR2,
104 p_cei_information_category OUT NOCOPY VARCHAR2,
105 p_cei_information1 OUT NOCOPY VARCHAR2,
106 p_cei_information2 OUT NOCOPY VARCHAR2,
107 p_cei_information3 OUT NOCOPY VARCHAR2,
108 p_cei_information4 OUT NOCOPY VARCHAR2,
109 p_cei_information5 OUT NOCOPY VARCHAR2,
110 p_cei_information6 OUT NOCOPY VARCHAR2,
111 p_cei_information7 OUT NOCOPY VARCHAR2,
112 p_cei_information8 OUT NOCOPY VARCHAR2,
113 p_cei_information9 OUT NOCOPY VARCHAR2,
114 p_cei_information10 OUT NOCOPY VARCHAR2,
115 p_cei_information11 OUT NOCOPY VARCHAR2,
116 p_cei_information12 OUT NOCOPY VARCHAR2,
117 p_cei_information13 OUT NOCOPY VARCHAR2,
118 p_cei_information14 OUT NOCOPY VARCHAR2,
119 p_cei_information15 OUT NOCOPY VARCHAR2,
120 p_cei_information16 OUT NOCOPY VARCHAR2,
121 p_cei_information17 OUT NOCOPY VARCHAR2,
122 p_cei_information18 OUT NOCOPY VARCHAR2,
123 p_cei_information19 OUT NOCOPY VARCHAR2,
124 p_cei_information20 OUT NOCOPY VARCHAR2,
125 p_cei_information21 OUT NOCOPY VARCHAR2,
126 p_cei_information22 OUT NOCOPY VARCHAR2,
127 p_cei_information23 OUT NOCOPY VARCHAR2,
128 p_cei_information24 OUT NOCOPY VARCHAR2,
129 p_cei_information25 OUT NOCOPY VARCHAR2,
130 p_cei_information26 OUT NOCOPY VARCHAR2,
131 p_cei_information27 OUT NOCOPY VARCHAR2,
132 p_cei_information28 OUT NOCOPY VARCHAR2,
133 p_cei_information29 OUT NOCOPY VARCHAR2,
134 p_cei_information30 OUT NOCOPY VARCHAR2,
135 p_effective_start_date OUT NOCOPY DATE,
136 p_effective_end_date OUT NOCOPY DATE,
137 p_cei_attribute_category OUT NOCOPY VARCHAR2,
138 p_cei_attribute1 OUT NOCOPY VARCHAR2,
139 p_cei_attribute2 OUT NOCOPY VARCHAR2,
140 p_cei_attribute3 OUT NOCOPY VARCHAR2,
141 p_cei_attribute4 OUT NOCOPY VARCHAR2,
142 p_cei_attribute5 OUT NOCOPY VARCHAR2,
143 p_cei_attribute6 OUT NOCOPY VARCHAR2,
144 p_cei_attribute7 OUT NOCOPY VARCHAR2,
145 p_cei_attribute8 OUT NOCOPY VARCHAR2,
146 p_cei_attribute9 OUT NOCOPY VARCHAR2,
147 p_cei_attribute10 OUT NOCOPY VARCHAR2,
148 p_cei_attribute11 OUT NOCOPY VARCHAR2,
149 p_cei_attribute12 OUT NOCOPY VARCHAR2,
150 p_cei_attribute13 OUT NOCOPY VARCHAR2,
151 p_cei_attribute14 OUT NOCOPY VARCHAR2,
152 p_cei_attribute15 OUT NOCOPY VARCHAR2,
153 p_cei_attribute16 OUT NOCOPY VARCHAR2,
154 p_cei_attribute17 OUT NOCOPY VARCHAR2,
155 p_cei_attribute18 OUT NOCOPY VARCHAR2,
156 p_cei_attribute19 OUT NOCOPY VARCHAR2,
157 p_cei_attribute20 OUT NOCOPY VARCHAR2,
158 p_object_version_number OUT NOCOPY NUMBER,
159 p_last_update_date OUT NOCOPY DATE,
160 p_last_updated_by OUT NOCOPY NUMBER,
161 p_last_update_login OUT NOCOPY NUMBER,
162 p_created_by OUT NOCOPY NUMBER,
163 p_creation_date OUT NOCOPY DATE,
164 p_request_id OUT NOCOPY NUMBER,
165 p_program_application_id OUT NOCOPY NUMBER,
166 p_program_id OUT NOCOPY NUMBER,
167 p_program_update_date OUT NOCOPY DATE);
168 --
169 PROCEDURE populate_extra_info_field(
170 p_contact_relationship_id IN NUMBER,
171 p_effective_date IN DATE,
172 p_information_type_group IN VARCHAR2,
173 p_contact_extra_info_id OUT NOCOPY NUMBER,
174 p_information_type OUT NOCOPY VARCHAR2,
175 p_d_information_type OUT NOCOPY VARCHAR2,
176 p_cei_information_category OUT NOCOPY VARCHAR2,
177 p_cei_information1 OUT NOCOPY VARCHAR2,
178 p_cei_information2 OUT NOCOPY VARCHAR2,
179 p_cei_information3 OUT NOCOPY VARCHAR2,
180 p_cei_information4 OUT NOCOPY VARCHAR2,
181 p_cei_information5 OUT NOCOPY VARCHAR2,
182 p_cei_information6 OUT NOCOPY VARCHAR2,
183 p_cei_information7 OUT NOCOPY VARCHAR2,
184 p_cei_information8 OUT NOCOPY VARCHAR2,
185 p_cei_information9 OUT NOCOPY VARCHAR2,
186 p_cei_information10 OUT NOCOPY VARCHAR2,
187 p_cei_information11 OUT NOCOPY VARCHAR2,
188 p_cei_information12 OUT NOCOPY VARCHAR2,
189 p_cei_information13 OUT NOCOPY VARCHAR2,
190 p_cei_information14 OUT NOCOPY VARCHAR2,
191 p_cei_information15 OUT NOCOPY VARCHAR2,
192 p_cei_information16 OUT NOCOPY VARCHAR2,
193 p_cei_information17 OUT NOCOPY VARCHAR2,
194 p_cei_information18 OUT NOCOPY VARCHAR2,
195 p_cei_information19 OUT NOCOPY VARCHAR2,
196 p_cei_information20 OUT NOCOPY VARCHAR2,
200 p_cei_information24 OUT NOCOPY VARCHAR2,
197 p_cei_information21 OUT NOCOPY VARCHAR2,
198 p_cei_information22 OUT NOCOPY VARCHAR2,
199 p_cei_information23 OUT NOCOPY VARCHAR2,
201 p_cei_information25 OUT NOCOPY VARCHAR2,
202 p_cei_information26 OUT NOCOPY VARCHAR2,
203 p_cei_information27 OUT NOCOPY VARCHAR2,
204 p_cei_information28 OUT NOCOPY VARCHAR2,
205 p_cei_information29 OUT NOCOPY VARCHAR2,
206 p_cei_information30 OUT NOCOPY VARCHAR2,
207 p_effective_start_date OUT NOCOPY DATE,
208 p_effective_end_date OUT NOCOPY DATE,
209 p_cei_attribute_category OUT NOCOPY VARCHAR2,
210 p_cei_attribute1 OUT NOCOPY VARCHAR2,
211 p_cei_attribute2 OUT NOCOPY VARCHAR2,
212 p_cei_attribute3 OUT NOCOPY VARCHAR2,
213 p_cei_attribute4 OUT NOCOPY VARCHAR2,
214 p_cei_attribute5 OUT NOCOPY VARCHAR2,
215 p_cei_attribute6 OUT NOCOPY VARCHAR2,
216 p_cei_attribute7 OUT NOCOPY VARCHAR2,
217 p_cei_attribute8 OUT NOCOPY VARCHAR2,
218 p_cei_attribute9 OUT NOCOPY VARCHAR2,
219 p_cei_attribute10 OUT NOCOPY VARCHAR2,
220 p_cei_attribute11 OUT NOCOPY VARCHAR2,
221 p_cei_attribute12 OUT NOCOPY VARCHAR2,
222 p_cei_attribute13 OUT NOCOPY VARCHAR2,
223 p_cei_attribute14 OUT NOCOPY VARCHAR2,
224 p_cei_attribute15 OUT NOCOPY VARCHAR2,
225 p_cei_attribute16 OUT NOCOPY VARCHAR2,
226 p_cei_attribute17 OUT NOCOPY VARCHAR2,
227 p_cei_attribute18 OUT NOCOPY VARCHAR2,
228 p_cei_attribute19 OUT NOCOPY VARCHAR2,
229 p_cei_attribute20 OUT NOCOPY VARCHAR2,
230 p_object_version_number OUT NOCOPY NUMBER,
231 p_last_update_date OUT NOCOPY DATE,
232 p_last_updated_by OUT NOCOPY NUMBER,
233 p_last_update_login OUT NOCOPY NUMBER,
234 p_created_by OUT NOCOPY NUMBER,
235 p_creation_date OUT NOCOPY DATE,
236 p_request_id OUT NOCOPY NUMBER,
237 p_program_application_id OUT NOCOPY NUMBER,
238 p_program_id OUT NOCOPY NUMBER,
239 p_program_update_date OUT NOCOPY DATE,
240 p_extra_info_count OUT NOCOPY NUMBER);
241 --
242 PROCEDURE populate_itax_result_field(
246 p_deductible_spouse_status OUT NOCOPY VARCHAR2,
243 p_person_id IN NUMBER,
244 p_effective_date IN DATE,
245 p_itax_type_iv_id IN NUMBER,
247 p_disabled_spouse_status OUT NOCOPY VARCHAR2,
248 p_dependents OUT NOCOPY NUMBER,
249 p_aged_dependents OUT NOCOPY NUMBER,
250 p_aged_parents OUT NOCOPY NUMBER,
251 p_specified_dependents OUT NOCOPY NUMBER,
252 p_ordinary_disabled OUT NOCOPY NUMBER,
253 p_severely_disabled OUT NOCOPY NUMBER,
254 p_severely_disabled_live_with OUT NOCOPY NUMBER);
255 --
256 END per_jp_dependent_pkg;