[Home] [Help]
PACKAGE: APPS.HR_ES_UTILITY
Source
1 PACKAGE hr_es_utility AS
2 /* $Header: peesutil.pkh 120.0.12010000.1 2008/07/28 04:39:21 appldev 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 FUNCTION validate_account_no(p_bank_code VARCHAR2
54 ,p_branch_code VARCHAR2
55 ,p_account_number VARCHAR2
56 ,p_validation_code VARCHAR2) RETURN NUMBER;
57 --
58 PROCEDURE check_identifier_unique
59 ( p_identifier_type VARCHAR2,
60 p_identifier_value VARCHAR2,
61 p_person_id NUMBER,
62 p_business_group_id NUMBER);
63
64 FUNCTION validate_cac_lookup (p_province_code VARCHAR2) RETURN NUMBER;
65 --
66 PROCEDURE validate_cif(p_org_info VARCHAR2);
67 --
68 PROCEDURE validate_cac(p_org_info VARCHAR2);
69 --
70 PROCEDURE check_leaving_reason(p_leaving_reason VARCHAR2
71 ,p_business_group_id NUMBER);
72 --
73 FUNCTION check_SSI(p_identifier_value VARCHAR2) RETURN VARCHAR2;
74 --
75 FUNCTION get_disability_degree(p_person_id NUMBER
76 ,p_session_date DATE) RETURN NUMBER;
77
78 --
79 FUNCTION get_ssno(p_assignment_id number
80 ,p_element_type_id number
81 ,p_input_value_id number
82 ,p_effective_date date) RETURN VARCHAR2;
83
84 PROCEDURE unique_cac(p_org_info_id NUMBER
85 ,p_context VARCHAR2
86 ,p_org_info VARCHAR2
87 ,p_business_group_id NUMBER
88 ,p_effective_date DATE);
89
90 PROCEDURE unique_cif(p_org_info_id NUMBER
91 ,p_org_info VARCHAR2
92 ,p_business_group_id NUMBER
93 ,p_effective_date DATE);
94
95 PROCEDURE validate_wc_sec_ref(p_context VARCHAR2
96 ,p_org_information1 VARCHAR2
97 ,p_business_group_id NUMBER
98 ,p_effective_date DATE);
99
100 PROCEDURE unique_ss(p_org_info_id NUMBER
101 ,p_context VARCHAR2
102 ,p_org_info VARCHAR2
103 ,p_business_group_id NUMBER
104 ,p_effective_date DATE);
105
106 FUNCTION chk_entry_in_lookup(p_lookup_type IN hr_lookups.lookup_type%TYPE
107 ,p_entry_val IN hr_lookups.meaning%TYPE
108 ,p_effective_date IN hr_lookups.start_date_active%TYPE
109 ,p_message OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
110 --
111 FUNCTION get_message(p_product IN VARCHAR2
112 ,p_message_name IN VARCHAR2
113 ,p_token1 IN VARCHAR2 DEFAULT NULL
114 ,p_token2 IN VARCHAR2 DEFAULT NULL
115 ,p_token3 IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
116 --
117 FUNCTION get_table_value_date(bus_group_id IN NUMBER
118 ,ptab_name IN VARCHAR2
119 ,pcol_name IN VARCHAR2
120 ,prow_value IN VARCHAR2
121 ,peffective_date IN DATE)RETURN NUMBER;
122
123 --
124 FUNCTION get_table_value(bus_group_id IN NUMBER
125 ,peffective_date IN DATE
126 ,ptab_name IN VARCHAR2
127 ,pcol_name IN VARCHAR2
128 ,prow_value IN VARCHAR2)RETURN NUMBER;
129 --
130 FUNCTION get_table_value_char(bus_group_id IN NUMBER
131 ,peffective_date IN DATE
132 ,ptab_name IN VARCHAR2
133 ,pcol_name IN VARCHAR2
134 ,prow_value IN VARCHAR2)RETURN VARCHAR2;
135 --
136 FUNCTION decode_lookup_desc(p_lookup_type VARCHAR2
137 ,p_lookup_code VARCHAR2) RETURN VARCHAR2;
138 END hr_es_utility;