1 PACKAGE hr_dk_validate_pkg AS
2 /* $Header: pedkvald.pkh 120.2.12000000.1 2007/01/21 21:56:47 appldev ship $ */
3
4 /* Bug fix 4994922, added record type */
5 TYPE l_type IS RECORD (value varchar2(5), date1 varchar2(30), date2 varchar2(30));
6 TYPE l_rec IS VARRAY(20) OF l_type;
7
8
9 PROCEDURE person_validate
10 (p_person_type_id in number
11 ,p_first_name in varchar2 default null
12 ,p_national_identifier in varchar2 default null
13 );
14
15 PROCEDURE applicant_validate
16 (p_business_group_id in number
17 ,p_person_type_id in number
18 ,p_first_name in varchar2 default null
19 ,p_national_identifier in varchar2 default null
20 );
21
22 PROCEDURE employee_validate
23 (p_business_group_id in number
24 ,p_person_type_id in number
25 ,p_first_name in varchar2 default null
26 ,p_national_identifier in varchar2 default null
27 );
28
29 PROCEDURE contact_cwk_validate
30 (p_business_group_id in number
31 ,p_person_type_id in number
32 ,p_first_name in varchar2 default null
33 ,p_national_identifier in varchar2 default null
34 );
35
36 /* Bug Fix 4994922, added parameters p_org_information2 and p_org_information3 */
37 PROCEDURE validate_create_org_inf
38 (p_org_info_type_code in varchar2
39 ,p_organization_id in number
40 ,p_org_information1 in varchar2
41 ,p_org_information2 in varchar2
42 ,p_org_information3 in varchar2
43 ) ;
44
45 /* Bug Fix 4994922, added parameters p_org_information2 and p_org_information3 */
46 PROCEDURE validate_update_org_inf
47 (p_org_info_type_code in varchar2
48 ,p_org_information_id in number
49 ,p_org_information1 in varchar2
50 ,p_org_information2 in varchar2
51 ,p_org_information3 in varchar2
52 );
53
54 PROCEDURE validate_update_emp_asg
55 (p_assignment_id in number
56 ,p_assignment_status_type_id in number
57 ,p_segment6 in varchar2
58 ,p_segment7 in varchar2
59 ,p_segment8 in varchar2
60 ,p_segment9 in varchar2
61 );
62
63 PROCEDURE validate_create_org_cat
64 (p_organization_id in number
65 ,p_org_information1 in varchar2
66 ) ;
67
68 END hr_dk_validate_pkg;
69
[Home] [Help]