1 PACKAGE hr_de_organization_upload AUTHID CURRENT_USER AS
2 /* $Header: pedeoupl.pkh 115.2 2002/11/26 16:32:55 jahobbs noship $ */
3 --
4 --
5 -- --------------------------------------------------------------------------
6 -- This uploads the definitions for tax offices as organizations in the HRMS
7 -- system.
8 --
9 -- The definitions for the tax offices are held in a user table named
10 -- HR_DE_TAX_OFFICE_DEFINITION which can be seen by using a view named
11 -- HR_DE_TAX_DEFINITION_V.
12 --
13 -- The parameters are defined as follows...
14 --
15 -- p_business_group_id: the business group for which this upload is being run.
16 -- p_effective_date : the date on which the changes are made.
17 -- p_upload_mode : the mode is either 'Merge' or 'Analyse' (see below for
18 -- details).
19 -- p_bundesland : can be used to identify a subset of the tax offices
20 -- NB. leaving this blank means load all tax offices.
21 --
22 -- The mode of 'Merge' only adds tax offices that do not already exist, while
23 -- 'Analyse' produces a summary of what would happen if 'Merge' was used.
24 -- --------------------------------------------------------------------------
25 --
26 PROCEDURE upload_tax_offices
27 (errbuf OUT NOCOPY VARCHAR2
28 ,retcode OUT NOCOPY NUMBER
29 ,p_business_group_id NUMBER
30 ,p_effective_date VARCHAR2
31 ,p_upload_mode VARCHAR2
32 ,p_bundesland VARCHAR2);
33 --
34 --
35 -- --------------------------------------------------------------------------
36 -- This uploads the definitions for social insurance providers as organizations
37 -- in the HRMS system.
38 --
39 -- The definitions for the social insurance providers are held in a user table
40 -- named HR_DE_SOC_INS_PROV_DEFINITION which can be seen by using a view named
41 -- HR_DE_SOCINS_PROV_DEFINITION_V.
42 --
43 -- The parameters are defined as follows...
44 --
45 -- p_business_group_id: the business group for which this upload is being run.
46 -- p_effective_date : the date on which the changes are made.
47 -- p_upload_mode : the mode is either 'Merge' or 'Analyse' (see below for
48 -- details).
49 -- p_provider_type : can be used to identify a subset of the social insurance
50 -- providers e.g. mandatory health providers, mandatory
51 -- pension providers, etc.
52 --
53 -- The mode of 'Merge' only adds social insurance providers that do not already
54 -- exist, while 'Analyse' produces a summary of what would happen if 'Merge'
55 -- was used.
56 -- --------------------------------------------------------------------------
57 --
58 PROCEDURE upload_soc_ins_providers
59 (errbuf OUT NOCOPY VARCHAR2
60 ,retcode OUT NOCOPY NUMBER
61 ,p_business_group_id NUMBER
62 ,p_effective_date VARCHAR2
63 ,p_upload_mode VARCHAR2
64 ,p_provider_type VARCHAR2);
65 END hr_de_organization_upload;