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