1 PACKAGE hr_mx_utility AUTHID CURRENT_USER AS
2 /* $Header: hrmxutil.pkh 120.6.12010000.1 2008/07/28 03:32:01 appldev ship $ */
3
4 --------------------------------------------------------------------
5 -- This function is used to support the full_name trigger for
6 -- Mexico legislation.
7 --------------------------------------------------------------------
8 FUNCTION per_mx_full_name(
9 p_first_name IN VARCHAR2
10 ,p_middle_names IN VARCHAR2
11 ,p_last_name IN VARCHAR2
12 ,p_known_as IN VARCHAR2
13 ,p_title IN VARCHAR2
14 ,p_suffix IN VARCHAR2
15 ,p_pre_name_adjunct IN VARCHAR2
16 ,p_per_information1 IN VARCHAR2
17 ,p_per_information2 IN VARCHAR2
18 ,p_per_information3 IN VARCHAR2
19 ,p_per_information4 IN VARCHAR2
20 ,p_per_information5 IN VARCHAR2
21 ,p_per_information6 IN VARCHAR2
22 ,p_per_information7 IN VARCHAR2
23 ,p_per_information8 IN VARCHAR2
24 ,p_per_information9 IN VARCHAR2
25 ,p_per_information10 IN VARCHAR2
26 ,p_per_information11 IN VARCHAR2
27 ,p_per_information12 IN VARCHAR2
28 ,p_per_information13 IN VARCHAR2
29 ,p_per_information14 IN VARCHAR2
30 ,p_per_information15 IN VARCHAR2
31 ,p_per_information16 IN VARCHAR2
32 ,p_per_information17 IN VARCHAR2
33 ,p_per_information18 IN VARCHAR2
34 ,p_per_information19 IN VARCHAR2
35 ,p_per_information20 IN VARCHAR2
36 ,p_per_information21 IN VARCHAR2
37 ,p_per_information22 IN VARCHAR2
38 ,p_per_information23 IN VARCHAR2
39 ,p_per_information24 IN VARCHAR2
40 ,p_per_information25 IN VARCHAR2
41 ,p_per_information26 IN VARCHAR2
42 ,p_per_information27 IN VARCHAR2
43 ,p_per_information28 IN VARCHAR2
44 ,p_per_information29 IN VARCHAR2
45 ,p_per_information30 IN VARCHAR2
46 ) RETURN VARCHAR2;
47
48
49 FUNCTION get_GRE_from_location(p_location_id IN NUMBER,
50 p_business_group_id IN NUMBER, -- Bug 4129001
51 p_session_date IN DATE,
52 p_is_ambiguous OUT NOCOPY BOOLEAN,
53 p_missing_gre OUT NOCOPY BOOLEAN
54 ) RETURN NUMBER;
55
56 FUNCTION get_GRE_from_scl(p_soft_coding_keyflex_id IN NUMBER
57 ) RETURN NUMBER;
58
59
60 PROCEDURE check_bus_grp (p_business_group_id IN NUMBER
61 ,p_legislation_code IN VARCHAR2);
62
63
64 FUNCTION GET_BG_FROM_PERSON (
65 p_person_id per_all_people_f.person_id%TYPE)
66 RETURN per_all_people_f.business_group_id%TYPE;
67
68 FUNCTION GET_BG_FROM_ASSIGNMENT (
69 p_assignment_id per_all_assignments_f.assignment_id%TYPE)
70 RETURN per_all_assignments_f.business_group_id%TYPE;
71
72 FUNCTION get_tax_subsidy_percent(p_business_group_id IN NUMBER,
73 p_tax_unit_id IN NUMBER) RETURN NUMBER;
74
75 FUNCTION get_tax_subsidy_percent(p_business_group_id IN NUMBER,
76 p_tax_unit_id IN NUMBER,
77 p_effective_date IN DATE) RETURN NUMBER;
78
79 FUNCTION get_wrip(p_business_group_id IN NUMBER,
80 p_tax_unit_id IN NUMBER) RETURN NUMBER;
81
82 FUNCTION get_legal_employer(p_business_group_id NUMBER,
83 p_tax_unit_id NUMBER) RETURN NUMBER;
84
85 FUNCTION get_legal_employer(p_business_group_id NUMBER,
86 p_tax_unit_id NUMBER,
87 p_effective_date DATE) RETURN NUMBER;
88
89 FUNCTION get_hire_anniversary(p_person_id NUMBER,
90 p_effective_date DATE) RETURN DATE;
91
92 FUNCTION get_seniority_social_security(p_person_id NUMBER,
93 p_effective_date DATE) RETURN NUMBER;
94
95 FUNCTION get_seniority(p_business_group_id IN NUMBER
96 ,p_tax_unit_id IN NUMBER
97 ,p_payroll_id IN NUMBER
98 ,p_person_id IN NUMBER
99 ,p_effective_date IN DATE) RETURN NUMBER;
100
101 FUNCTION get_IANA_charset RETURN VARCHAR2;
102
103 FUNCTION chk_entry_in_lookup
104 (p_lookup_type IN hr_lookups.lookup_type%TYPE
105 ,p_entry_val IN hr_lookups.meaning%TYPE
106 ,p_effective_date IN hr_lookups.start_date_active%TYPE
107 ,p_message OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
108
109
110 --
111 procedure DERIVE_HR_LOC_ADDRESS
112 (p_tax_name in varchar2,
113 p_style in varchar2,
114 p_address_line_1 in varchar2,
115 p_address_line_2 in varchar2,
116 p_address_line_3 in varchar2,
117 p_town_or_city in varchar2,
118 p_country in varchar2,
119 p_postal_code in varchar2,
120 p_region_1 in varchar2,
121 p_region_2 in varchar2,
122 p_region_3 in varchar2,
123 p_telephone_number_1 in varchar2,
124 p_telephone_number_2 in varchar2,
125 p_telephone_number_3 in varchar2,
126 p_loc_information13 in varchar2,
127 p_loc_information14 in varchar2,
128 p_loc_information15 in varchar2,
129 p_loc_information16 in varchar2,
130 p_loc_information17 in varchar2,
131 p_attribute_category in varchar2,
132 p_attribute1 in varchar2,
133 p_attribute2 in varchar2,
134 p_attribute3 in varchar2,
135 p_attribute4 in varchar2,
136 p_attribute5 in varchar2,
137 p_attribute6 in varchar2,
138 p_attribute7 in varchar2,
139 p_attribute8 in varchar2,
140 p_attribute9 in varchar2,
141 p_attribute10 in varchar2,
142 p_attribute11 in varchar2,
143 p_attribute12 in varchar2,
144 p_attribute13 in varchar2,
145 p_attribute14 in varchar2,
146 p_attribute15 in varchar2,
147 p_attribute16 in varchar2,
148 p_attribute17 in varchar2,
149 p_attribute18 in varchar2,
150 p_attribute19 in varchar2,
151 p_attribute20 in varchar2,
152 p_global_attribute_category in varchar2,
153 p_global_attribute1 in varchar2,
154 p_global_attribute2 in varchar2,
155 p_global_attribute3 in varchar2,
156 p_global_attribute4 in varchar2,
157 p_global_attribute5 in varchar2,
158 p_global_attribute6 in varchar2,
159 p_global_attribute7 in varchar2,
160 p_global_attribute8 in varchar2,
161 p_global_attribute9 in varchar2,
162 p_global_attribute10 in varchar2,
163 p_global_attribute11 in varchar2,
164 p_global_attribute12 in varchar2,
165 p_global_attribute13 in varchar2,
166 p_global_attribute14 in varchar2,
167 p_global_attribute15 in varchar2,
168 p_global_attribute16 in varchar2,
169 p_global_attribute17 in varchar2,
170 p_global_attribute18 in varchar2,
171 p_global_attribute19 in varchar2,
172 p_global_attribute20 in varchar2,
173 p_loc_information18 in varchar2,
174 p_loc_information19 in varchar2,
175 p_loc_information20 in varchar2,
176 p_derived_locale out nocopy varchar2
177 );
178 --
179 procedure DERIVE_PER_ADD_ADDRESS
180 (p_style in varchar2,
181 p_address_line1 in varchar2,
182 p_address_line2 in varchar2,
183 p_address_line3 in varchar2,
184 p_country in varchar2,
185 p_date_to in date,
186 p_postal_code in varchar2,
187 p_region_1 in varchar2,
188 p_region_2 in varchar2,
189 p_region_3 in varchar2,
190 p_telephone_number_1 in varchar2,
191 p_telephone_number_2 in varchar2,
192 p_telephone_number_3 in varchar2,
193 p_town_or_city in varchar2,
194 p_addr_attribute_category in varchar2,
195 p_addr_attribute1 in varchar2,
196 p_addr_attribute2 in varchar2,
197 p_addr_attribute3 in varchar2,
198 p_addr_attribute4 in varchar2,
199 p_addr_attribute5 in varchar2,
200 p_addr_attribute6 in varchar2,
201 p_addr_attribute7 in varchar2,
202 p_addr_attribute8 in varchar2,
203 p_addr_attribute9 in varchar2,
204 p_addr_attribute10 in varchar2,
205 p_addr_attribute11 in varchar2,
206 p_addr_attribute12 in varchar2,
207 p_addr_attribute13 in varchar2,
208 p_addr_attribute14 in varchar2,
209 p_addr_attribute15 in varchar2,
210 p_addr_attribute16 in varchar2,
211 p_addr_attribute17 in varchar2,
212 p_addr_attribute18 in varchar2,
213 p_addr_attribute19 in varchar2,
214 p_addr_attribute20 in varchar2,
215 p_add_information13 in varchar2,
216 p_add_information14 in varchar2,
217 p_add_information15 in varchar2,
218 p_add_information16 in varchar2,
219 p_add_information17 in varchar2,
220 p_add_information18 in varchar2,
221 p_add_information19 in varchar2,
222 p_add_information20 in varchar2,
223 p_derived_locale out nocopy varchar2);
224 --
225 END hr_mx_utility;