[Home] [Help]
PACKAGE: APPS.HR_ES_UTILITY
Source
1 PACKAGE hr_es_utility AUTHID CURRENT_USER AS
2 /* $Header: peesutil.pkh 120.0.12010000.2 2009/12/20 07:47:19 rpahune ship $ */
3 --
4 FUNCTION validate_identifier(p_identifier_type VARCHAR2
5 ,p_identifier_value VARCHAR2) RETURN VARCHAR2;
6 --
7 FUNCTION check_DNI(p_identifier_value VARCHAR2) RETURN VARCHAR2;
8 --
9 FUNCTION check_NIF(p_identifier_value VARCHAR2) RETURN VARCHAR2;
10 --
11 FUNCTION check_NIE(p_identifier_value VARCHAR2) RETURN VARCHAR2;
12 --
13 FUNCTION per_es_full_name(
14 p_first_name IN VARCHAR2
15 ,p_middle_names IN VARCHAR2
16 ,p_last_name IN VARCHAR2
17 ,p_known_as IN VARCHAR2
18 ,p_title IN VARCHAR2
19 ,p_suffix IN VARCHAR2
20 ,p_pre_name_adjunct IN VARCHAR2
21 ,p_per_information1 IN VARCHAR2
22 ,p_per_information2 IN VARCHAR2
23 ,p_per_information3 IN VARCHAR2
24 ,p_per_information4 IN VARCHAR2
25 ,p_per_information5 IN VARCHAR2
26 ,p_per_information6 IN VARCHAR2
27 ,p_per_information7 IN VARCHAR2
28 ,p_per_information8 IN VARCHAR2
29 ,p_per_information9 IN VARCHAR2
30 ,p_per_information10 IN VARCHAR2
31 ,p_per_information11 IN VARCHAR2
32 ,p_per_information12 IN VARCHAR2
33 ,p_per_information13 IN VARCHAR2
34 ,p_per_information14 IN VARCHAR2
35 ,p_per_information15 IN VARCHAR2
36 ,p_per_information16 IN VARCHAR2
37 ,p_per_information17 IN VARCHAR2
38 ,p_per_information18 IN VARCHAR2
39 ,p_per_information19 IN VARCHAR2
40 ,p_per_information20 IN VARCHAR2
41 ,p_per_information21 IN VARCHAR2
42 ,p_per_information22 IN VARCHAR2
43 ,p_per_information23 IN VARCHAR2
44 ,p_per_information24 IN VARCHAR2
45 ,p_per_information25 IN VARCHAR2
46 ,p_per_information26 IN VARCHAR2
47 ,p_per_information27 IN VARCHAR2
48 ,p_per_information28 IN VARCHAR2
49 ,p_per_information29 IN VARCHAR2
50 ,p_per_information30 IN VARCHAR2
51 ) RETURN VARCHAR2;
52 --
53 /*--
54 FUNCTION validate_account_no(p_bank_code VARCHAR2
55 ,p_branch_code VARCHAR2
56 ,p_account_number VARCHAR2
57 ,p_validation_code VARCHAR2) RETURN NUMBER;
58 */
59
60
61 FUNCTION validate_non_IBAN_acc_no(p_bank_code VARCHAR2
62 ,p_branch_code VARCHAR2
63 ,p_account_number VARCHAR2
64 ,p_validation_code VARCHAR2) RETURN NUMBER;
65 --
66
67 FUNCTION validate_account_no (p_bank_code VARCHAR2 default null
68 ,p_branch_code VARCHAR2 default null
69 ,p_account_number VARCHAR2 default null
70 ,p_validation_code VARCHAR2 default null
71 ,p_acc_type varchar2
72 ,p_iban_acc varchar2 default null) return number;
73 --
74 FUNCTION validate_iban_acc(p_account_no VARCHAR2
75 )RETURN NUMBER;
76
77
78 --
79 PROCEDURE check_identifier_unique
80 ( p_identifier_type VARCHAR2,
81 p_identifier_value VARCHAR2,
82 p_person_id NUMBER,
83 p_business_group_id NUMBER);
84
85 FUNCTION validate_cac_lookup (p_province_code VARCHAR2) RETURN NUMBER;
86 --
87 PROCEDURE validate_cif(p_org_info VARCHAR2);
88 --
89 PROCEDURE validate_cac(p_org_info VARCHAR2);
90 --
91 PROCEDURE check_leaving_reason(p_leaving_reason VARCHAR2
92 ,p_business_group_id NUMBER);
93 --
94 FUNCTION check_SSI(p_identifier_value VARCHAR2) RETURN VARCHAR2;
95 --
96 FUNCTION get_disability_degree(p_person_id NUMBER
97 ,p_session_date DATE) RETURN NUMBER;
98
99 --
100 FUNCTION get_ssno(p_assignment_id number
101 ,p_element_type_id number
102 ,p_input_value_id number
103 ,p_effective_date date) RETURN VARCHAR2;
104
105 PROCEDURE unique_cac(p_org_info_id NUMBER
106 ,p_context VARCHAR2
107 ,p_org_info VARCHAR2
108 ,p_business_group_id NUMBER
109 ,p_effective_date DATE);
110
111 PROCEDURE unique_cif(p_org_info_id NUMBER
112 ,p_org_info VARCHAR2
113 ,p_business_group_id NUMBER
114 ,p_effective_date DATE);
115
116 PROCEDURE validate_wc_sec_ref(p_context VARCHAR2
117 ,p_org_information1 VARCHAR2
118 ,p_business_group_id NUMBER
119 ,p_effective_date DATE);
120
121 PROCEDURE unique_ss(p_org_info_id NUMBER
122 ,p_context VARCHAR2
123 ,p_org_info VARCHAR2
124 ,p_business_group_id NUMBER
125 ,p_effective_date DATE);
126
127 FUNCTION chk_entry_in_lookup(p_lookup_type IN hr_lookups.lookup_type%TYPE
128 ,p_entry_val IN hr_lookups.meaning%TYPE
129 ,p_effective_date IN hr_lookups.start_date_active%TYPE
130 ,p_message OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
131 --
132 FUNCTION get_message(p_product IN VARCHAR2
133 ,p_message_name IN VARCHAR2
134 ,p_token1 IN VARCHAR2 DEFAULT NULL
135 ,p_token2 IN VARCHAR2 DEFAULT NULL
136 ,p_token3 IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
137 --
138 FUNCTION get_table_value_date(bus_group_id IN NUMBER
139 ,ptab_name IN VARCHAR2
140 ,pcol_name IN VARCHAR2
141 ,prow_value IN VARCHAR2
142 ,peffective_date IN DATE)RETURN NUMBER;
143
144 --
145 FUNCTION get_table_value(bus_group_id IN NUMBER
146 ,peffective_date IN DATE
147 ,ptab_name IN VARCHAR2
148 ,pcol_name IN VARCHAR2
149 ,prow_value IN VARCHAR2)RETURN NUMBER;
150 --
151 FUNCTION get_table_value_char(bus_group_id IN NUMBER
152 ,peffective_date IN DATE
153 ,ptab_name IN VARCHAR2
154 ,pcol_name IN VARCHAR2
155 ,prow_value IN VARCHAR2)RETURN VARCHAR2;
156 --
157 FUNCTION decode_lookup_desc(p_lookup_type VARCHAR2
158 ,p_lookup_code VARCHAR2) RETURN VARCHAR2;
159 END hr_es_utility;