1 PACKAGE hr_se_utility AUTHID CURRENT_USER AS
2 -- $Header: hrseutil.pkh 120.1.12010000.2 2009/11/27 10:31:48 dchindar ship $
3 --
4 -- Formats the full name for the Sweden legislation.
5 --
6 FUNCTION per_se_full_name
7 (p_first_name IN VARCHAR2
8 ,p_middle_names IN VARCHAR2
9 ,p_last_name IN VARCHAR2
10 ,p_known_as IN VARCHAR2
11 ,p_title IN VARCHAR2
12 ,p_suffix IN VARCHAR2
13 ,p_pre_name_adjunct IN VARCHAR2
14 ,p_per_information1 IN VARCHAR2
15 ,p_per_information2 IN VARCHAR2
16 ,p_per_information3 IN VARCHAR2
17 ,p_per_information4 IN VARCHAR2
18 ,p_per_information5 IN VARCHAR2
19 ,p_per_information6 IN VARCHAR2
20 ,p_per_information7 IN VARCHAR2
21 ,p_per_information8 IN VARCHAR2
22 ,p_per_information9 IN VARCHAR2
23 ,p_per_information10 IN VARCHAR2
24 ,p_per_information11 IN VARCHAR2
25 ,p_per_information12 IN VARCHAR2
26 ,p_per_information13 IN VARCHAR2
27 ,p_per_information14 IN VARCHAR2
28 ,p_per_information15 IN VARCHAR2
29 ,p_per_information16 IN VARCHAR2
30 ,p_per_information17 IN VARCHAR2
31 ,p_per_information18 IN VARCHAR2
32 ,p_per_information19 IN VARCHAR2
33 ,p_per_information20 IN VARCHAR2
34 ,p_per_information21 IN VARCHAR2
35 ,p_per_information22 IN VARCHAR2
36 ,p_per_information23 IN VARCHAR2
37 ,p_per_information24 IN VARCHAR2
38 ,p_per_information25 IN VARCHAR2
39 ,p_per_information26 IN VARCHAR2
40 ,p_per_information27 IN VARCHAR2
41 ,p_per_information28 IN VARCHAR2
42 ,p_per_information29 IN VARCHAR2
43 ,p_per_information30 in VARCHAR2) RETURN VARCHAR2;
44 --
45 --
46 -- Formats the order name for the Sweden legislation.
47 --
48 FUNCTION per_se_order_name
49 (p_first_name IN VARCHAR2
50 ,p_middle_names IN VARCHAR2
51 ,p_last_name IN VARCHAR2
52 ,p_known_as IN VARCHAR2
53 ,p_title IN VARCHAR2
54 ,p_suffix IN VARCHAR2
55 ,p_pre_name_adjunct IN VARCHAR2
56 ,p_per_information1 IN VARCHAR2
57 ,p_per_information2 IN VARCHAR2
58 ,p_per_information3 IN VARCHAR2
59 ,p_per_information4 IN VARCHAR2
60 ,p_per_information5 IN VARCHAR2
61 ,p_per_information6 IN VARCHAR2
62 ,p_per_information7 IN VARCHAR2
63 ,p_per_information8 IN VARCHAR2
64 ,p_per_information9 IN VARCHAR2
65 ,p_per_information10 IN VARCHAR2
66 ,p_per_information11 IN VARCHAR2
67 ,p_per_information12 IN VARCHAR2
68 ,p_per_information13 IN VARCHAR2
69 ,p_per_information14 IN VARCHAR2
70 ,p_per_information15 IN VARCHAR2
71 ,p_per_information16 IN VARCHAR2
72 ,p_per_information17 IN VARCHAR2
73 ,p_per_information18 IN VARCHAR2
74 ,p_per_information19 IN VARCHAR2
75 ,p_per_information20 IN VARCHAR2
76 ,p_per_information21 IN VARCHAR2
77 ,p_per_information22 IN VARCHAR2
78 ,p_per_information23 IN VARCHAR2
79 ,p_per_information24 IN VARCHAR2
80 ,p_per_information25 IN VARCHAR2
81 ,p_per_information26 IN VARCHAR2
82 ,p_per_information27 IN VARCHAR2
83 ,p_per_information28 IN VARCHAR2
84 ,p_per_information29 IN VARCHAR2
85 ,p_per_information30 IN VARCHAR2) RETURN VARCHAR2;
86 --
87
88 -- Checks whether the input is a valid date.
89 --
90 FUNCTION chk_valid_date
91 (p_date IN VARCHAR2) RETURN VARCHAR2;
92
93
94 -- Validates the bank account number.
95 --
96
97 FUNCTION validate_account_number
98 (p_account_number IN VARCHAR2,
99 p_session_id IN NUMBER,
100 p_bg_id IN NUMBER) RETURN NUMBER;
101
102 FUNCTION validate_account_entered
103 (p_acc_no IN VARCHAR2,
104 p_is_iban_acc IN varchar2,
105 p_session_id IN NUMBER default NULL,
106 p_bg_id IN NUMBER default NULL) RETURN NUMBER;
107
108
109 FUNCTION get_court_order_details
110 (p_assignment_id IN NUMBER
111 ,p_effective_date IN DATE
112 ,p_reserved_amount OUT NOCOPY NUMBER
113 ,p_disdraint_amount OUT NOCOPY NUMBER
114 ,p_suspension_flag OUT NOCOPY VARCHAR2
115 ) RETURN NUMBER;
116
117 FUNCTION GET_COMPANY_MILEAGE_LIMIT
118 (p_effective_date IN DATE
119 ,p_business_group_id IN NUMBER
120 ,p_tax_unit_id IN NUMBER
121 ,p_car_type IN VARCHAR2
122 ) RETURN NUMBER;
123
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) return varchar2;
131
132 FUNCTION get_IANA_charset RETURN VARCHAR2;
133
134 END hr_se_utility ;
135
136
137