1 PACKAGE HR_GB_UTILITY AUTHID CURRENT_USER AS
2 /* $Header: hrgbutil.pkh 120.0.12000000.1 2007/01/21 16:24:59 appldev ship $ */
3 function push_pay_message(p_applid in number,
4 p_msg_name in varchar2,
5 p_level in varchar2) return number;
6 --
7 function push_pay_token(p_tok_name in varchar2,
8 p_tok_value in varchar2) return number;
9 --
10 function place_message_stack(p_pactid in number) return number;
11 --
12 function ni_validate(p_ni_number in varchar2,
13 p_effective_date in date) return number;
14 --
15 function tax_code_validate(p_tax_code in varchar2,
16 p_effective_date in date,
17 p_assignment_id in number) return varchar2;
18 --
19 procedure DERIVE_HR_LOC_ADDRESS
20 (p_tax_name in varchar2,
21 p_style in varchar2,
22 p_address_line_1 in varchar2,
23 p_address_line_2 in varchar2,
24 p_address_line_3 in varchar2,
25 p_town_or_city in varchar2,
26 p_country in varchar2,
27 p_postal_code in varchar2,
28 p_region_1 in varchar2,
29 p_region_2 in varchar2,
30 p_region_3 in varchar2,
31 p_telephone_number_1 in varchar2,
32 p_telephone_number_2 in varchar2,
33 p_telephone_number_3 in varchar2,
34 p_loc_information13 in varchar2,
35 p_loc_information14 in varchar2,
36 p_loc_information15 in varchar2,
37 p_loc_information16 in varchar2,
38 p_loc_information17 in varchar2,
39 p_attribute_category in varchar2,
40 p_attribute1 in varchar2,
41 p_attribute2 in varchar2,
42 p_attribute3 in varchar2,
43 p_attribute4 in varchar2,
44 p_attribute5 in varchar2,
45 p_attribute6 in varchar2,
46 p_attribute7 in varchar2,
47 p_attribute8 in varchar2,
48 p_attribute9 in varchar2,
49 p_attribute10 in varchar2,
50 p_attribute11 in varchar2,
51 p_attribute12 in varchar2,
52 p_attribute13 in varchar2,
53 p_attribute14 in varchar2,
54 p_attribute15 in varchar2,
55 p_attribute16 in varchar2,
56 p_attribute17 in varchar2,
57 p_attribute18 in varchar2,
58 p_attribute19 in varchar2,
59 p_attribute20 in varchar2,
60 p_global_attribute_category in varchar2,
61 p_global_attribute1 in varchar2,
62 p_global_attribute2 in varchar2,
63 p_global_attribute3 in varchar2,
64 p_global_attribute4 in varchar2,
65 p_global_attribute5 in varchar2,
66 p_global_attribute6 in varchar2,
67 p_global_attribute7 in varchar2,
68 p_global_attribute8 in varchar2,
69 p_global_attribute9 in varchar2,
70 p_global_attribute10 in varchar2,
71 p_global_attribute11 in varchar2,
72 p_global_attribute12 in varchar2,
73 p_global_attribute13 in varchar2,
74 p_global_attribute14 in varchar2,
75 p_global_attribute15 in varchar2,
76 p_global_attribute16 in varchar2,
77 p_global_attribute17 in varchar2,
78 p_global_attribute18 in varchar2,
79 p_global_attribute19 in varchar2,
80 p_global_attribute20 in varchar2,
81 p_loc_information18 in varchar2,
82 p_loc_information19 in varchar2,
83 p_loc_information20 in varchar2,
84 p_derived_locale out nocopy varchar2
85 );
86
87 --
88 procedure DERIVE_PER_ADD_ADDRESS
89 (p_style in varchar2,
90 p_address_line1 in varchar2,
91 p_address_line2 in varchar2,
92 p_address_line3 in varchar2,
93 p_country in varchar2,
94 p_date_to in date,
95 p_postal_code in varchar2,
96 p_region_1 in varchar2,
97 p_region_2 in varchar2,
98 p_region_3 in varchar2,
99 p_telephone_number_1 in varchar2,
100 p_telephone_number_2 in varchar2,
101 p_telephone_number_3 in varchar2,
102 p_town_or_city in varchar2,
103 p_addr_attribute_category in varchar2,
104 p_addr_attribute1 in varchar2,
105 p_addr_attribute2 in varchar2,
106 p_addr_attribute3 in varchar2,
107 p_addr_attribute4 in varchar2,
108 p_addr_attribute5 in varchar2,
109 p_addr_attribute6 in varchar2,
110 p_addr_attribute7 in varchar2,
111 p_addr_attribute8 in varchar2,
112 p_addr_attribute9 in varchar2,
113 p_addr_attribute10 in varchar2,
114 p_addr_attribute11 in varchar2,
115 p_addr_attribute12 in varchar2,
116 p_addr_attribute13 in varchar2,
117 p_addr_attribute14 in varchar2,
118 p_addr_attribute15 in varchar2,
119 p_addr_attribute16 in varchar2,
120 p_addr_attribute17 in varchar2,
121 p_addr_attribute18 in varchar2,
122 p_addr_attribute19 in varchar2,
123 p_addr_attribute20 in varchar2,
124 p_add_information13 in varchar2,
125 p_add_information14 in varchar2,
126 p_add_information15 in varchar2,
127 p_add_information16 in varchar2,
128 p_add_information17 in varchar2,
129 p_add_information18 in varchar2,
130 p_add_information19 in varchar2,
131 p_add_information20 in varchar2,
132 p_derived_locale out nocopy varchar2);
133 --
134 FUNCTION per_gb_full_name(
135
136 p_first_name in varchar2
137 ,p_middle_names in varchar2
138 ,p_last_name in varchar2
139 ,p_known_as in varchar2
140 ,p_title in varchar2
141 ,p_suffix in varchar2
142 ,p_pre_name_adjunct in varchar2
143 ,p_per_information1 in varchar2 default hr_api.g_varchar2
144 ,p_per_information2 in varchar2 default hr_api.g_varchar2
145 ,p_per_information3 in varchar2 default hr_api.g_varchar2
146 ,p_per_information4 in varchar2 default hr_api.g_varchar2
147 ,p_per_information5 in varchar2 default hr_api.g_varchar2
148 ,p_per_information6 in varchar2 default hr_api.g_varchar2
149 ,p_per_information7 in varchar2 default hr_api.g_varchar2
150 ,p_per_information8 in varchar2 default hr_api.g_varchar2
151 ,p_per_information9 in varchar2 default hr_api.g_varchar2
152 ,p_per_information10 in varchar2 default hr_api.g_varchar2
153 ,p_per_information11 in varchar2 default hr_api.g_varchar2
154 ,p_per_information12 in varchar2 default hr_api.g_varchar2
155 ,p_per_information13 in varchar2 default hr_api.g_varchar2
156 ,p_per_information14 in varchar2 default hr_api.g_varchar2
157 ,p_per_information15 in varchar2 default hr_api.g_varchar2
158 ,p_per_information16 in varchar2 default hr_api.g_varchar2
159 ,p_per_information17 in varchar2 default hr_api.g_varchar2
160 ,p_per_information18 in varchar2 default hr_api.g_varchar2
161 ,p_per_information19 in varchar2 default hr_api.g_varchar2
162 ,p_per_information20 in varchar2 default hr_api.g_varchar2
163 ,p_per_information21 in varchar2 default hr_api.g_varchar2
164 ,p_per_information22 in varchar2 default hr_api.g_varchar2
165 ,p_per_information23 in varchar2 default hr_api.g_varchar2
166 ,p_per_information24 in varchar2 default hr_api.g_varchar2
167 ,p_per_information25 in varchar2 default hr_api.g_varchar2
168 ,p_per_information26 in varchar2 default hr_api.g_varchar2
169 ,p_per_information27 in varchar2 default hr_api.g_varchar2
170 ,p_per_information28 in varchar2 default hr_api.g_varchar2
171 ,p_per_information29 in varchar2 default hr_api.g_varchar2
172 ,p_per_information30 in VARCHAR2 default hr_api.g_varchar2
173 )
174 RETURN VARCHAR2;
175 --
176 END HR_GB_UTILITY;