1 PACKAGE hr_in_utility as
2 /* $Header: hrinutil.pkh 120.3 2008/01/03 10:09:06 vdabgar ship $ */
3 FUNCTION per_in_full_name(
4 p_first_name IN VARCHAR2
5 ,p_middle_names IN VARCHAR2
6 ,p_last_name IN VARCHAR2
7 ,p_known_as IN VARCHAR2
8 ,p_title IN VARCHAR2
9 ,p_suffix IN VARCHAR2
10 ,p_pre_name_adjunct IN VARCHAR2
11 ,p_per_information1 IN VARCHAR2
12 ,p_per_information2 IN VARCHAR2
13 ,p_per_information3 IN VARCHAR2
14 ,p_per_information4 IN VARCHAR2
15 ,p_per_information5 IN VARCHAR2
16 ,p_per_information6 IN VARCHAR2
17 ,p_per_information7 IN VARCHAR2
18 ,p_per_information8 IN VARCHAR2
19 ,p_per_information9 IN VARCHAR2
20 ,p_per_information10 IN VARCHAR2
21 ,p_per_information11 IN VARCHAR2
22 ,p_per_information12 IN VARCHAR2
23 ,p_per_information13 IN VARCHAR2
24 ,p_per_information14 IN VARCHAR2
25 ,p_per_information15 IN VARCHAR2
26 ,p_per_information16 IN VARCHAR2
27 ,p_per_information17 IN VARCHAR2
28 ,p_per_information18 IN VARCHAR2
29 ,p_per_information19 IN VARCHAR2
30 ,p_per_information20 IN VARCHAR2
31 ,p_per_information21 IN VARCHAR2
32 ,p_per_information22 IN VARCHAR2
33 ,p_per_information23 IN VARCHAR2
34 ,p_per_information24 IN VARCHAR2
35 ,p_per_information25 IN VARCHAR2
36 ,p_per_information26 IN VARCHAR2
37 ,p_per_information27 IN VARCHAR2
38 ,p_per_information28 IN VARCHAR2
39 ,p_per_information29 IN VARCHAR2
40 ,p_per_information30 IN VARCHAR2
41 ) RETURN VARCHAR2 ;
42
43 FUNCTION per_in_full_name(
44 p_first_name IN VARCHAR2
45 ,p_middle_names IN VARCHAR2
46 ,p_last_name IN VARCHAR2
47 ,p_title IN VARCHAR2
48 ) RETURN VARCHAR2 ;
49
50 PROCEDURE derive_hr_loc_address(
51 p_tax_name IN VARCHAR2,
52 p_style IN VARCHAR2,
53 p_address_line_1 IN VARCHAR2,
54 p_address_line_2 IN VARCHAR2,
55 p_address_line_3 IN VARCHAR2,
56 p_town_or_city IN VARCHAR2,
57 p_country IN VARCHAR2,
58 p_postal_code IN VARCHAR2,
59 p_region_1 IN VARCHAR2,
60 p_region_2 IN VARCHAR2,
61 p_region_3 IN VARCHAR2,
62 p_telephone_number_1 IN VARCHAR2,
63 p_telephone_number_2 IN VARCHAR2,
64 p_telephone_number_3 IN VARCHAR2,
65 p_loc_information13 IN VARCHAR2,
66 p_loc_information14 IN VARCHAR2,
67 p_loc_information15 IN VARCHAR2,
68 p_loc_information16 IN VARCHAR2,
69 p_loc_information17 IN VARCHAR2,
70 p_attribute_category IN VARCHAR2,
71 p_attribute1 IN VARCHAR2,
72 p_attribute2 IN VARCHAR2,
73 p_attribute3 IN VARCHAR2,
74 p_attribute4 IN VARCHAR2,
75 p_attribute5 IN VARCHAR2,
76 p_attribute6 IN VARCHAR2,
77 p_attribute7 IN VARCHAR2,
78 p_attribute8 IN VARCHAR2,
79 p_attribute9 IN VARCHAR2,
80 p_attribute10 IN VARCHAR2,
81 p_attribute11 IN VARCHAR2,
82 p_attribute12 IN VARCHAR2,
83 p_attribute13 IN VARCHAR2,
84 p_attribute14 IN VARCHAR2,
85 p_attribute15 IN VARCHAR2,
86 p_attribute16 IN VARCHAR2,
87 p_attribute17 IN VARCHAR2,
88 p_attribute18 IN VARCHAR2,
89 p_attribute19 IN VARCHAR2,
90 p_attribute20 IN VARCHAR2,
91 p_global_attribute_category IN VARCHAR2,
92 p_global_attribute1 IN VARCHAR2,
93 p_global_attribute2 IN VARCHAR2,
94 p_global_attribute3 IN VARCHAR2,
95 p_global_attribute4 IN VARCHAR2,
96 p_global_attribute5 IN VARCHAR2,
97 p_global_attribute6 IN VARCHAR2,
98 p_global_attribute7 IN VARCHAR2,
99 p_global_attribute8 IN VARCHAR2,
100 p_global_attribute9 IN VARCHAR2,
101 p_global_attribute10 IN VARCHAR2,
102 p_global_attribute11 IN VARCHAR2,
103 p_global_attribute12 IN VARCHAR2,
104 p_global_attribute13 IN VARCHAR2,
105 p_global_attribute14 IN VARCHAR2,
106 p_global_attribute15 IN VARCHAR2,
107 p_global_attribute16 IN VARCHAR2,
108 p_global_attribute17 IN VARCHAR2,
109 p_global_attribute18 IN VARCHAR2,
110 p_global_attribute19 IN VARCHAR2,
111 p_global_attribute20 IN VARCHAR2,
112 p_loc_information18 IN VARCHAR2,
113 p_loc_information19 IN VARCHAR2,
114 p_loc_information20 IN VARCHAR2,
115 p_derived_locale OUT NOCOPY VARCHAR2
116 );
117 end hr_in_utility;
[Home] [Help]