1 PACKAGE HR_FI_UTILITY AUTHID CURRENT_USER AS
2 -- $Header: hrfiutil.pkh 120.1.12010000.2 2008/08/06 08:41:20 ubhat ship $
3 --
4 -- Formats the full name for the Finland legislation.
5
6 --
7 FUNCTION per_fi_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 --
47 -- Formats the order name for the Finland legislation.
48 --
49 FUNCTION per_fi_order_name
50 (p_first_name IN VARCHAR2
51 ,p_middle_names IN VARCHAR2
52 ,p_last_name IN VARCHAR2
53 ,p_known_as IN VARCHAR2
54 ,p_title IN VARCHAR2
55 ,p_suffix IN VARCHAR2
56 ,p_pre_name_adjunct IN VARCHAR2
57 ,p_per_information1 IN VARCHAR2
58 ,p_per_information2 IN VARCHAR2
59 ,p_per_information3 IN VARCHAR2
60 ,p_per_information4 IN VARCHAR2
61 ,p_per_information5 IN VARCHAR2
62 ,p_per_information6 IN VARCHAR2
63 ,p_per_information7 IN VARCHAR2
64 ,p_per_information8 IN VARCHAR2
65 ,p_per_information9 IN VARCHAR2
66 ,p_per_information10 IN VARCHAR2
67 ,p_per_information11 IN VARCHAR2
68 ,p_per_information12 IN VARCHAR2
69 ,p_per_information13 IN VARCHAR2
70 ,p_per_information14 IN VARCHAR2
71 ,p_per_information15 IN VARCHAR2
72 ,p_per_information16 IN VARCHAR2
73 ,p_per_information17 IN VARCHAR2
74 ,p_per_information18 IN VARCHAR2
75 ,p_per_information19 IN VARCHAR2
76 ,p_per_information20 IN VARCHAR2
77 ,p_per_information21 IN VARCHAR2
78 ,p_per_information22 IN VARCHAR2
79 ,p_per_information23 IN VARCHAR2
80 ,p_per_information24 IN VARCHAR2
81 ,p_per_information25 IN VARCHAR2
82 ,p_per_information26 IN VARCHAR2
83 ,p_per_information27 IN VARCHAR2
84 ,p_per_information28 IN VARCHAR2
85 ,p_per_information29 IN VARCHAR2
86 ,p_per_information30 IN VARCHAR2) RETURN VARCHAR2;
87 --
88 -- Validates the bank account number.
89 --
90 -- The format is as follows BC-ACCX where
91 --
92 -- BC = 6 Digits representing the Branch Code
93 -- X = 1 Digit representing the Validation Code
94 -- Acc = Between 2 to 7 Digits
95
96 FUNCTION validate_account_number
97 (p_account_number IN VARCHAR2 ) RETURN NUMBER;
98
99 -- Checks whether the input is a valid date.
100 --
101 FUNCTION chk_valid_date
102 (p_date IN VARCHAR2
103 ,p_century IN VARCHAR2 ) RETURN VARCHAR2;
104
105 FUNCTION get_employment_information
106 ( p_assignment_id IN NUMBER
107 , p_emp_information_code IN VARCHAR2 ) RETURN VARCHAR2;
108
109 FUNCTION get_retirement_information
110 ( p_person_id IN NUMBER
111 , p_date IN DATE
112 , p_retire_information_code IN VARCHAR2 ) RETURN VARCHAR2;
113
114 FUNCTION get_vehicle_information
115 (p_assignment_id IN NUMBER
116 ,p_business_group_id IN NUMBER
117 ,p_effective_date IN DATE
118 ,p_vehicle_allot_id IN VARCHAR2
119 ,p_model_year OUT NOCOPY NUMBER
120 ,p_price OUT NOCOPY NUMBER
121 ,p_engine_capacity_in_cc OUT NOCOPY NUMBER
122 ,p_vehicle_type OUT NOCOPY VARCHAR2
123 ) RETURN NUMBER ;
124
125 FUNCTION get_message
126 (p_product IN VARCHAR2
127 ,p_message_name IN VARCHAR2
128 ,p_token1 IN VARCHAR2 DEFAULT NULL
129 ,p_token2 IN VARCHAR2 DEFAULT NULL
130 ,p_token3 IN VARCHAR2 DEFAULT NULL)
131 RETURN VARCHAR2;
132
133 FUNCTION get_dependent_number
134 (p_assignment_id IN NUMBER
135 ,p_business_group_id IN NUMBER
136 ,p_process_date IN DATE
137 ) RETURN NUMBER;
138
139 FUNCTION get_court_order_details
140 (p_assignment_id IN NUMBER
141 ,p_effective_date IN DATE
142 ,p_dependent_number OUT NOCOPY NUMBER
143 ,p_third_party OUT NOCOPY NUMBER
144 ,p_court_order_amount OUT NOCOPY NUMBER
145 ,p_periodic_installment OUT NOCOPY NUMBER
146 ,p_number_of_installments OUT NOCOPY NUMBER
147 ,p_suspension_flag OUT NOCOPY VARCHAR2
148 ) RETURN NUMBER;
149
150 FUNCTION get_union_details
151 (p_assignment_id IN NUMBER
152 ,p_effective_date IN DATE
153 ,p_fixed_union_fees OUT NOCOPY NUMBER
154 ,p_percentage_union_fees OUT NOCOPY NUMBER
155 ,p_payment_calculation_mode OUT NOCOPY VARCHAR2
156 ) RETURN NUMBER;
157
158 FUNCTION get_IANA_charset RETURN VARCHAR2;
159
160 END HR_FI_UTILITY;