1 PACKAGE hr_de_extra_org_checks AS
2 /* $Header: hrdeorgv.pkh 120.0.12000000.1 2007/01/22 14:44:46 appldev 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 -- Organization information checks.
28 --
29 -- - German HR organization information.
30 --
31 -- 1. Payroll betriesbenummer and employers betriesnummer (p_org_information2 and 3)
32 -- must conform to a prescribed format (see service function validate_betriebesnumber()
33 -- for details of the rules).
34 -- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
35 --
36 PROCEDURE org_information_checks
37 (p_org_info_type_code IN VARCHAR2
38 ,p_org_information1 IN VARCHAR2
39 ,p_org_information2 IN VARCHAR2);
40 END hr_de_extra_org_checks;