1 PACKAGE hr_de_extra_api_checks AUTHID CURRENT_USER AS
2 /* $Header: pedehkvl.pkh 115.5 2002/01/03 07:35:37 pkm ship $ */
3 --
4 --
5 -- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
6 -- Service function to validate the betriebsnummer according to the following rules.
7 --
8 -- Format is xxxyyyyz (all numeric) where...
9 --
10 -- xxx is the ID from the unemployment office. Currently allowed values are 010
11 -- to 099 or it must be larger than 110.
12 --
13 -- yyyy is a sequential number issued by unemployment office.
14 --
15 -- z is a check digit.
16 --
17 -- NB. the message name for the error to be raised is passed in as there is more than
18 -- one betriebnummer.
19 -- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
20 --
21 PROCEDURE validate_betriebsnummer
22 (p_betriebsnummer IN VARCHAR2
23 ,p_message_name IN VARCHAR2);
24 --
25 --
26 -- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
27 -- Assignment checks.
28 --
29 -- 1. Union Membership cannot be recorded.
30 --
31 -- 2. The information held in the SCL is valid (see service function validate_scl()
32 -- for details of the rules. To be implemented!
33 -- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
34 --
35 PROCEDURE assignment_checks
36 (p_labour_union_member_flag IN VARCHAR2);
37 --
38 --
39 -- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
40 -- Organization information checks.
41 --
42 -- - German HR organization information.
43 --
44 -- 1. Payroll betriesbenummer and employers betriesnummer (p_org_information2 and 3)
45 -- must conform to a prescribed format (see service function validate_betriebesnumber()
46 -- for details of the rules).
47 -- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
48 --
49 PROCEDURE org_information_checks
50 (p_org_info_type_code IN VARCHAR2
51 ,p_org_information1 IN VARCHAR2
52 ,p_org_information2 IN VARCHAR2);
53 --
54 --
55 -- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
56 -- Person Extra Information checks.
57 --
58 -- - Military Service (DE_MILITARY_SERVICE).
59 --
60 -- 1. The Date From (p_pei_information1) must be on or before Date To (p_pei_information2).
61 --
62 -- - Residence Permit (DE_RESIDENCE_PERMITS).
63 --
64 -- 1. The Effective Date (p_pei_information6) must be on or before Expiry Date
65 -- (p_pei_information7).
66 --
67 -- - Work Permit (DE_WORK_PERMITS).
68 --
69 -- 1. The Effective Date (p_pei_information6) must be on or before Expiry Date
70 -- (p_pei_information7).
71 --
72 -- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
73 --
74 PROCEDURE person_information_checks
75 (p_pei_information_category IN VARCHAR2
76 ,p_pei_information1 IN VARCHAR2
77 ,p_pei_information2 IN VARCHAR2
78 ,p_pei_information6 IN VARCHAR2
79 ,p_pei_information7 IN VARCHAR2);
80 --
81 --
82 -- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
83 -- Work Incident checks.
84 --
85 -- 1. The Work Stop Date (p_inc_information10) must be on or before Work Incident Date
86 -- (p_incident_date).
87 -- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
88 --
89 PROCEDURE work_incident_checks
90 (p_incident_date IN DATE
91 ,p_inc_information3 IN VARCHAR2
92 ,p_inc_information9 IN VARCHAR2
93 ,p_inc_information10 IN VARCHAR2
94 ,p_inc_information11 IN VARCHAR2);
95 END hr_de_extra_api_checks;