1 PACKAGE HR_FI_VALIDATE_PKG AUTHID CURRENT_USER AS
2 /* $Header: pefivald.pkh 120.3 2007/03/07 11:15:35 dbehera ship $ */
3
4 PROCEDURE person_validate
5 (p_person_type_id in number
6 ,p_first_name in varchar2 default null
7 ,p_national_identifier in varchar2 default null
8 ,p_date_of_birth in date default null
9 ,p_per_information8 in varchar2 default null
10 );
11
12 PROCEDURE applicant_validate
13 (p_business_group_id in number
14 ,p_person_type_id in number
15 ,p_first_name in varchar2 default null
16 ,p_national_identifier in varchar2 default null
17 ,p_date_of_birth in date default null
18 ,p_per_information8 in varchar2 default null
19 );
20
21 PROCEDURE employee_validate
22 (p_business_group_id in number
23 ,p_person_type_id in number
24 ,p_first_name in varchar2 default null
25 ,p_national_identifier in varchar2 default null
26 ,p_date_of_birth in date default null
27 ,p_per_information8 in varchar2 default null
28 );
29
30 PROCEDURE contact_cwk_validate
31 (p_business_group_id in number
32 ,p_person_type_id in number
33 ,p_first_name in varchar2 default null
34 ,p_national_identifier in varchar2 default null
35 ,p_date_of_birth in date default null
36 ,p_per_information8 in varchar2 default null
37 );
38
39 PROCEDURE qual_insert_validate
40 (p_business_group_id in number
41 ,p_qua_information_category in varchar2 default null
42 ,p_person_id in number
43 ,p_qua_information1 in varchar2 default null
44 ,p_qua_information2 in varchar2 default null
45 );
46
47 PROCEDURE qual_update_validate
48 (p_qua_information_category in varchar2 default null
49 ,p_qualification_id in number
50 ,p_qua_information1 in varchar2 default null
51 ,p_qua_information2 in varchar2 default null
52 );
53 PROCEDURE validate_create_org_inf
54 (p_effective_date IN DATE
55 ,p_org_info_type_code IN VARCHAR2
56 ,p_organization_id IN NUMBER
57 ,p_org_information1 IN VARCHAR2 DEFAULT null
58 ,p_org_information2 IN VARCHAR2 DEFAULT null
59 ,p_org_information3 IN VARCHAR2 DEFAULT null
60 ,p_org_information4 IN VARCHAR2 DEFAULT null
61 ,p_org_information5 IN VARCHAR2 DEFAULT null
62 ,p_org_information6 IN VARCHAR2 DEFAULT null
63 ,p_org_information7 IN VARCHAR2 DEFAULT null
64 ,p_org_information8 IN VARCHAR2 DEFAULT null
65 ,p_org_information9 IN VARCHAR2 DEFAULT null
66 ) ;
67
68 PROCEDURE validate_update_org_inf
69 (p_effective_date IN DATE
70 ,p_org_info_type_code IN VARCHAR2
71 ,p_org_information_id IN NUMBER
72 ,p_org_information1 IN VARCHAR2 DEFAULT null
73 ,p_org_information2 IN VARCHAR2 DEFAULT null
74 ,p_org_information3 IN VARCHAR2 DEFAULT null
75 ,p_org_information4 IN VARCHAR2 DEFAULT null
76 ,p_org_information5 IN VARCHAR2 DEFAULT null
77 ,p_org_information6 IN VARCHAR2 DEFAULT null
78 ,p_org_information7 IN VARCHAR2 DEFAULT null
79 ,p_org_information8 IN VARCHAR2 DEFAULT null
80 ,p_org_information9 IN VARCHAR2 DEFAULT null
81 );
82
83 PROCEDURE CREATE_ASG_VALIDATE
84 (p_scl_segment12 IN VARCHAR2 DEFAULT NULL
85 ,p_effective_date IN DATE
86 ,p_person_id IN NUMBER
87 ,p_organization_id IN NUMBER
88 );
89
90 PROCEDURE UPDATE_ASG_VALIDATE
91 (p_segment2 IN VARCHAR2
92 ,p_segment12 IN VARCHAR2
93 ,p_effective_date IN DATE
94 ,p_assignment_id IN NUMBER
95 );
96 PROCEDURE UPDATE_TERMINATION_VALIDATE
97 (p_leaving_reason IN VARCHAR2
98 );
99 PROCEDURE CREATE_ORG_CLASS_VALIDATE
100 (P_ORGANIZATION_ID IN NUMBER
101 ,P_ORG_INFORMATION1 IN VARCHAR2
102 );
103
104 PROCEDURE VALIDATE_NUMBER
105 (
106 p_number IN VARCHAR2
107 ,p_token IN VARCHAR2
108 ,p_message IN VARCHAR2 DEFAULT NULL
109 );
110
111 PROCEDURE PERSON_ABSENCE_CREATE
112 (
113 p_business_group_id IN number
114 ,p_abs_information_category IN varchar2
115 ,p_person_id IN Number
116 ,p_date_start IN Date
117 ,p_date_end IN Date
118 ,p_abs_information1 IN Varchar2 default NULL
119 ,p_abs_information2 IN Varchar2 default NULL
120 ,p_abs_information3 IN Varchar2 default NULL
121 ,p_abs_information4 IN Varchar2 default NULL
122 ,p_abs_information5 IN Varchar2 default NULL
123 );
124
125 PROCEDURE PERSON_ABSENCE_UPDATE
126 (
127 p_absence_attendance_id IN Number
128 ,p_abs_information_category IN varchar2
129 ,p_date_start IN Date
130 ,p_date_end IN Date
131 ,p_abs_information1 IN Varchar2 default NULL
132 ,p_abs_information2 IN Varchar2 default NULL
133 ,p_abs_information3 IN Varchar2 default NULL
134 ,p_abs_information4 IN Varchar2 default NULL
135 ,p_abs_information5 IN Varchar2 default NULL
136 );
137
138
139
140 END HR_FI_VALIDATE_PKG;
[Home] [Help]