1 PACKAGE HR_DE_ORG_INFO AUTHID CURRENT_USER AS
2 /* $Header: pedeorgi.pkh 115.11 2002/11/26 16:32:37 jahobbs noship $ */
3
4 TYPE Insurance_providers_rec is RECORD (
5 status varchar2(150),
6 child_org_id varchar2(150),
7 class_of_risk varchar2(150),
8 Membership_Number varchar2(150),
9 Name varchar2(240));
10
11 TYPE Insurance_providers_table is TABLE OF Insurance_providers_rec index by binary_integer;
12 --
13 --
14 -- Service function to return the current named hioerarchy.
15 --
16 FUNCTION named_hierarchy
17 (p_organization_id NUMBER) RETURN NUMBER;
18 --
19 --
20 -- Service function to return the current version of the named hioerarchy.
21 --
22 FUNCTION latest_named_hierarchy_vers
23 (p_organization_id NUMBER) RETURN NUMBER;
24 --
25 --
26 -- Service function to see if organization belongs to the current primary hioerarchy.
27 --
28 FUNCTION org_exists_in_hierarchy
29 (p_organization_id NUMBER) RETURN VARCHAR2;
30
31
32 Procedure get_org_data_items(p_chamber_contribution_out out nocopy varchar2,
33 p_employer_Betriebsnummer out nocopy varchar2,
34 p_payroll_Betriebsnummer out nocopy varchar2,
35 p_org_id in number);
36
37 Procedure get_insurance_providers (p_org_id in hr_organization_units.organization_id%TYPE
38 ,p_Insurance_providers_Table out nocopy Insurance_providers_table);
39
40 Procedure chk_for_org_in_hierarchy(p_org_id in hr_organization_units.organization_id%TYPE,
41 p_exists out nocopy varchar2);
42
43 -- Functions used in the view HR_DE_WORK_INCIDENTS_REPORT
44 Function get_liab_prov_details(p_assignment_id in per_assignments_f.assignment_id%TYPE,
45 p_incident_date in date)
46 Return varchar2;
47 Function get_liab_prov_name(p_assignment_id in per_assignments_f.assignment_id%TYPE)
48 Return varchar2;
49 Function get_liab_prov_membership_no(p_assignment_id in per_assignments_f.assignment_id%TYPE)
50 Return varchar2;
51
52 Function get_location(p_assignment_id in per_assignments_f.assignment_id%TYPE)
53 Return varchar2;
54 Function get_addr_line1(p_assignment_id in per_assignments_f.assignment_id%TYPE)
55 Return varchar2;
56 Function get_addr_line2(p_assignment_id in per_assignments_f.assignment_id%TYPE)
57 Return varchar2;
58 Function get_addr_line3(p_assignment_id in per_assignments_f.assignment_id%TYPE)
59 Return varchar2;
60 Function get_town(p_assignment_id in per_assignments_f.assignment_id%TYPE)
61 Return varchar2;
62 Function get_country(p_assignment_id in per_assignments_f.assignment_id%TYPE)
63 Return varchar2;
64 Function get_postal_code(p_assignment_id in per_assignments_f.assignment_id%TYPE)
65 Return varchar2;
66
67 Function get_liab_prov_details2(p_assignment_id in per_assignments_f.assignment_id%TYPE,
68 p_incident_date in date)
69 Return varchar2;
70
71 Function get_supervising_off(p_assignment_id in per_assignments_f.assignment_id%TYPE,
72 p_incident_date in date)
73 Return varchar2;
74 Function get_supervising_off_name(p_assignment_id in per_assignments_f.assignment_id%TYPE)
75 Return varchar2;
76 --
77
78 END;