1 PACKAGE hr_dk_utility AUTHID CURRENT_USER AS
2 /* $Header: hrdkutil.pkh 120.2.12010000.2 2009/11/20 07:18:57 dchindar ship $ */
3
4 --
5 --
6 -- Formats the full name for the Danish legislation.
7 --
8 FUNCTION per_dk_full_name
9 (p_first_name IN VARCHAR2
10 ,p_middle_name IN VARCHAR2
11 ,p_last_name IN VARCHAR2
12 ,p_known_as IN VARCHAR2
13 ,p_title IN VARCHAR2
14 ,p_suffix IN VARCHAR2
15 ,p_pre_name_adjunct IN VARCHAR2
16 ,p_per_information1 IN VARCHAR2
17 ,p_per_information2 IN VARCHAR2
18 ,p_per_information3 IN VARCHAR2
19 ,p_per_information4 IN VARCHAR2
20 ,p_per_information5 IN VARCHAR2
21 ,p_per_information6 IN VARCHAR2
22 ,p_per_information7 IN VARCHAR2
23 ,p_per_information8 IN VARCHAR2
24 ,p_per_information9 IN VARCHAR2
25 ,p_per_information10 IN VARCHAR2
26 ,p_per_information11 IN VARCHAR2
27 ,p_per_information12 IN VARCHAR2
28 ,p_per_information13 IN VARCHAR2
29 ,p_per_information14 IN VARCHAR2
30 ,p_per_information15 IN VARCHAR2
31 ,p_per_information16 IN VARCHAR2
32 ,p_per_information17 IN VARCHAR2
33 ,p_per_information18 IN VARCHAR2
34 ,p_per_information19 IN VARCHAR2
35 ,p_per_information20 IN VARCHAR2
36 ,p_per_information21 IN VARCHAR2
37 ,p_per_information22 IN VARCHAR2
38 ,p_per_information23 IN VARCHAR2
39 ,p_per_information24 IN VARCHAR2
40 ,p_per_information25 IN VARCHAR2
41 ,p_per_information26 IN VARCHAR2
42 ,p_per_information27 IN VARCHAR2
43 ,p_per_information28 IN VARCHAR2
44 ,p_per_information29 IN VARCHAR2
45 ,p_per_information30 IN VARCHAR2) RETURN VARCHAR2;
46 --
47 --
48 -- Formats the order name for the Danish legislation.
49 --
50 FUNCTION per_dk_order_name
51 (p_first_name IN VARCHAR2
52 ,p_middle_name IN VARCHAR2
53 ,p_last_name IN VARCHAR2
54 ,p_known_as IN VARCHAR2
55 ,p_title IN VARCHAR2
56 ,p_suffix IN VARCHAR2
57 ,p_pre_name_adjunct IN VARCHAR2
58 ,p_per_information1 IN VARCHAR2
59 ,p_per_information2 IN VARCHAR2
60 ,p_per_information3 IN VARCHAR2
61 ,p_per_information4 IN VARCHAR2
62 ,p_per_information5 IN VARCHAR2
63 ,p_per_information6 IN VARCHAR2
64 ,p_per_information7 IN VARCHAR2
65 ,p_per_information8 IN VARCHAR2
66 ,p_per_information9 IN VARCHAR2
67 ,p_per_information10 IN VARCHAR2
68 ,p_per_information11 IN VARCHAR2
69 ,p_per_information12 IN VARCHAR2
70 ,p_per_information13 IN VARCHAR2
71 ,p_per_information14 IN VARCHAR2
72 ,p_per_information15 IN VARCHAR2
73 ,p_per_information16 IN VARCHAR2
74 ,p_per_information17 IN VARCHAR2
75 ,p_per_information18 IN VARCHAR2
76 ,p_per_information19 IN VARCHAR2
77 ,p_per_information20 IN VARCHAR2
78 ,p_per_information21 IN VARCHAR2
79 ,p_per_information22 IN VARCHAR2
80 ,p_per_information23 IN VARCHAR2
81 ,p_per_information24 IN VARCHAR2
82 ,p_per_information25 IN VARCHAR2
83 ,p_per_information26 IN VARCHAR2
84 ,p_per_information27 IN VARCHAR2
85 ,p_per_information28 IN VARCHAR2
86 ,p_per_information29 IN VARCHAR2
87 ,p_per_information30 IN VARCHAR2) RETURN VARCHAR2;
88
89 --
90 --
91 -- Validates the bank account number.
92 --
93 -- The format is as follows NNNNNNNNNNN
94
95 FUNCTION validate_account_number
96 (p_account_number IN VARCHAR2) RETURN NUMBER;
97
98
99 FUNCTION validate_account_entered
100 (p_acc_no IN VARCHAR2,
101 p_is_iban_acc IN varchar2 ) RETURN NUMBER;
102
103
104 -- function to check for valid date
105
106 FUNCTION chk_valid_date
107 (p_nat_id IN VARCHAR2) RETURN VARCHAR2 ;
108
109
110
111 FUNCTION get_employment_information (
112 p_assignment_id IN number,
113 p_emp_information_code IN varchar2 )
114 RETURN VARCHAR2;
115
116
117
118 function get_message
119 (p_product in varchar2
120 ,p_message_name in varchar2
121 ,p_token1 in varchar2 default null
122 ,p_token2 in varchar2 default null
123 ,p_token3 in varchar2 default null) return varchar2;
124
125 FUNCTION REPLACE_SPECIAL_CHARS(p_xml IN VARCHAR2)
126 RETURN VARCHAR2;
127
128 END hr_dk_utility;