1 PACKAGE hr_pl_utility AUTHID CURRENT_USER AS
2 /* $Header: peplutil.pkh 120.4.12010000.2 2009/12/18 10:53:26 bkeshary ship $ */
3 FUNCTION per_pl_full_name(
4 p_first_name IN VARCHAR2
5 ,p_middle_names IN VARCHAR2
6 ,p_last_name IN VARCHAR2
7 ,p_known_as IN VARCHAR2
8 ,p_title IN VARCHAR2
9 ,p_suffix IN VARCHAR2
10 ,p_pre_name_adjunct IN VARCHAR2
11 ,p_per_information1 IN VARCHAR2
12 ,p_per_information2 IN VARCHAR2
13 ,p_per_information3 IN VARCHAR2
14 ,p_per_information4 IN VARCHAR2
15 ,p_per_information5 IN VARCHAR2
16 ,p_per_information6 IN VARCHAR2
17 ,p_per_information7 IN VARCHAR2
18 ,p_per_information8 IN VARCHAR2
19 ,p_per_information9 IN VARCHAR2
20 ,p_per_information10 IN VARCHAR2
21 ,p_per_information11 IN VARCHAR2
22 ,p_per_information12 IN VARCHAR2
23 ,p_per_information13 IN VARCHAR2
24 ,p_per_information14 IN VARCHAR2
25 ,p_per_information15 IN VARCHAR2
26 ,p_per_information16 IN VARCHAR2
27 ,p_per_information17 IN VARCHAR2
28 ,p_per_information18 IN VARCHAR2
29 ,p_per_information19 IN VARCHAR2
30 ,p_per_information20 IN VARCHAR2
31 ,p_per_information21 IN VARCHAR2
32 ,p_per_information22 IN VARCHAR2
33 ,p_per_information23 IN VARCHAR2
34 ,p_per_information24 IN VARCHAR2
35 ,p_per_information25 IN VARCHAR2
36 ,p_per_information26 IN VARCHAR2
37 ,p_per_information27 IN VARCHAR2
38 ,p_per_information28 IN VARCHAR2
39 ,p_per_information29 IN VARCHAR2
40 ,p_per_information30 IN VARCHAR2
41 ) RETURN VARCHAR2;
42 --
43 FUNCTION per_pl_order_name(
44 p_first_name IN VARCHAR2
45 ,p_middle_names IN VARCHAR2
46 ,p_last_name IN VARCHAR2
47 ,p_known_as IN VARCHAR2
48 ,p_title IN VARCHAR2
49 ,p_suffix IN VARCHAR2
50 ,p_pre_name_adjunct IN VARCHAR2
51 ,p_per_information1 IN VARCHAR2
52 ,p_per_information2 IN VARCHAR2
53 ,p_per_information3 IN VARCHAR2
54 ,p_per_information4 IN VARCHAR2
55 ,p_per_information5 IN VARCHAR2
56 ,p_per_information6 IN VARCHAR2
57 ,p_per_information7 IN VARCHAR2
58 ,p_per_information8 IN VARCHAR2
59 ,p_per_information9 IN VARCHAR2
60 ,p_per_information10 IN VARCHAR2
61 ,p_per_information11 IN VARCHAR2
62 ,p_per_information12 IN VARCHAR2
63 ,p_per_information13 IN VARCHAR2
64 ,p_per_information14 IN VARCHAR2
65 ,p_per_information15 IN VARCHAR2
66 ,p_per_information16 IN VARCHAR2
67 ,p_per_information17 IN VARCHAR2
68 ,p_per_information18 IN VARCHAR2
69 ,p_per_information19 IN VARCHAR2
70 ,p_per_information20 IN VARCHAR2
71 ,p_per_information21 IN VARCHAR2
72 ,p_per_information22 IN VARCHAR2
73 ,p_per_information23 IN VARCHAR2
74 ,p_per_information24 IN VARCHAR2
75 ,p_per_information25 IN VARCHAR2
76 ,p_per_information26 IN VARCHAR2
77 ,p_per_information27 IN VARCHAR2
78 ,p_per_information28 IN VARCHAR2
79 ,p_per_information29 IN VARCHAR2
80 ,p_per_information30 IN VARCHAR2
81 ) RETURN VARCHAR2;
82
83 --
84
85 FUNCTION per_pl_chk_valid_date (p_date IN VARCHAR2) RETURN VARCHAR2;
86
87 --
88
89 PROCEDURE per_pl_nip_validate(p_nip_number IN varchar2,
90 p_person_id IN number,
91 p_business_group_id in number,
92 p_legal_employer IN varchar2,
93 p_nationality IN varchar2 ,
94 p_citizenship IN varchar2
95 );
96
97 --
98
99 PROCEDURE per_pl_chk_gender(nat_id varchar2,gender IN OUT NOCOPY varchar2);
100
101 Procedure per_pl_validate(pesel varchar2);
102
103 FUNCTION validate_account_no(p_check_digit varchar2,
104 p_bank_id VARCHAR2,
105 p_account_number VARCHAR2
106 ) RETURN NUMBER ;
107
108 FUNCTION validate_account_entered
109 (p_acc_no IN VARCHAR2,
110 p_is_iban_acc IN varchar2,
111 p_bank_chk_dig IN varchar2 DEFAULT NULL,
112 p_bank_id IN Varchar2 DEFAULT NULL) RETURN NUMBER;
113
114 FUNCTION validate_iban_acc
115 (p_account_no IN VARCHAR2)RETURN NUMBER;
116
117 FUNCTION validate_bank_id(p_bank_id varchar2) RETURN NUMBER;
118
119 PROCEDURE per_pl_calc_periods(p_start_date IN DATE,
120 p_end_date IN DATE,
121 p_days IN OUT NOCOPY NUMBER,
122 p_months IN OUT NOCOPY NUMBER,
123 p_years IN OUT NOCOPY NUMBER);
124
125 FUNCTION GET_LENGTH_OF_SERVICE(P_PERSON_ID IN NUMBER,
126 P_TYPE_OF_SERVICE IN VARCHAR2, -- This is the code of the Category
127 l_years OUT NOCOPY NUMBER,
128 l_months OUT NOCOPY NUMBER,
129 l_days OUT NOCOPY NUMBER,
130 l_message OUT NOCOPY VARCHAR2) RETURN NUMBER;
131
132 FUNCTION CHECK_CONTRIBUTION_TYPE(P_ENTRY_VALUE IN VARCHAR2) return NUMBER ;
133
134 FUNCTION GET_VEHICLE_MILEAGE(p_date_earned IN DATE,
135 p_vehicle_allocation_id IN NUMBER,
136 p_monthly_mileage_limit OUT NOCOPY NUMBER,
137 p_engine_capacity_in_cc OUT NOCOPY NUMBER,
138 p_vehicle_type OUT NOCOPY VARCHAR2) RETURN NUMBER;
139
140 FUNCTION GET_TOTAL_PERIOD_OF_SERVICE
141 (p_assignment_id in number,
142 p_date in date,
143 p_years OUT NOCOPY NUMBER,
144 p_months OUT NOCOPY NUMBER,
145 p_days OUT NOCOPY NUMBER) return number;
146 PROCEDURE PER_PL_CHECK_NI_UNIQUE
147 ( p_national_identifier VARCHAR2,
148 p_person_id NUMBER,
149 p_business_group_id NUMBER,
150 p_legal_employer VARCHAR2);
151
152 END hr_pl_utility;