1 PACKAGE HR_FI_UTILITY AUTHID CURRENT_USER AS
2 -- $Header: hrfiutil.pkh 120.1.12010000.4 2009/11/20 07:10:49 dchindar 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 FUNCTION validate_account_entered
100 (p_acc_no IN VARCHAR2,
101 p_is_iban_acc IN varchar2) RETURN NUMBER;
102
103
104 -- Checks whether the input is a valid date.
105 --
106 FUNCTION chk_valid_date
107 (p_date IN VARCHAR2
108 ,p_century IN VARCHAR2 ) RETURN VARCHAR2;
109
110 FUNCTION get_employment_information
111 ( p_assignment_id IN NUMBER
112 , p_emp_information_code IN VARCHAR2 ) RETURN VARCHAR2;
113
114 FUNCTION get_retirement_information
115 ( p_person_id IN NUMBER
116 , p_date IN DATE
117 , p_retire_information_code IN VARCHAR2 ) RETURN VARCHAR2;
118
119 FUNCTION get_vehicle_information
120 (p_assignment_id IN NUMBER
121 ,p_business_group_id IN NUMBER
122 ,p_effective_date IN DATE
123 ,p_vehicle_allot_id IN VARCHAR2
124 ,p_model_year OUT NOCOPY NUMBER
125 ,p_price OUT NOCOPY NUMBER
126 ,p_engine_capacity_in_cc OUT NOCOPY NUMBER
127 ,p_vehicle_type OUT NOCOPY VARCHAR2
128 ) RETURN NUMBER ;
129
130 FUNCTION get_message
131 (p_product IN VARCHAR2
132 ,p_message_name IN VARCHAR2
133 ,p_token1 IN VARCHAR2 DEFAULT NULL
134 ,p_token2 IN VARCHAR2 DEFAULT NULL
135 ,p_token3 IN VARCHAR2 DEFAULT NULL)
136 RETURN VARCHAR2;
137
138 FUNCTION get_dependent_number
139 (p_assignment_id IN NUMBER
140 ,p_business_group_id IN NUMBER
141 ,p_process_date IN DATE
142 ) RETURN NUMBER;
143
144 FUNCTION get_court_order_details
145 (p_assignment_id IN NUMBER
146 ,p_effective_date IN DATE
147 ,p_dependent_number OUT NOCOPY NUMBER
148 ,p_third_party OUT NOCOPY NUMBER
149 ,p_court_order_amount OUT NOCOPY NUMBER
150 ,p_periodic_installment OUT NOCOPY NUMBER
151 ,p_number_of_installments OUT NOCOPY NUMBER
152 ,p_suspension_flag OUT NOCOPY VARCHAR2
153 ) RETURN NUMBER;
154
155 FUNCTION get_union_details
156 (p_assignment_id IN NUMBER
157 ,p_effective_date IN DATE
158 ,p_fixed_union_fees OUT NOCOPY NUMBER
159 ,p_percentage_union_fees OUT NOCOPY NUMBER
160 ,p_payment_calculation_mode OUT NOCOPY VARCHAR2
164
161 ) RETURN NUMBER;
162
163 FUNCTION get_IANA_charset RETURN VARCHAR2;
165 -- Function to Check If Contract Reasons are Update in Assignment EIT
166 -- Bug - 8425533
167
168 FUNCTION check_Contract_Reasons
169 (p_assignment_id IN NUMBER
170 ,p_contract_type IN VARCHAR2
171 ) RETURN NUMBER;
172
173 END HR_FI_UTILITY;