1 PACKAGE HR_SA_ORG_INFO AUTHID CURRENT_USER AS
2 /* $Header: pesaorgi.pkh 115.2 2004/01/14 07:09:14 abppradh 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 chk_for_org_in_hierarchy(p_org_id in hr_organization_units.organization_id%TYPE,
33 p_exists out nocopy varchar2);
34
35 PROCEDURE get_employer_name (p_org_id in hr_organization_units.organization_id%TYPE,
36 p_employer_name out nocopy varchar2,
37 p_business_group_id hr_organization_units.organization_id%TYPE);
38
39
40 PROCEDURE get_employer_name (p_org_id in hr_organization_units.organization_id%TYPE,
41 p_employer_name out nocopy varchar2,
42 p_business_group_id hr_organization_units.organization_id%TYPE,
43 p_structure_version_id number);
44
45 FUNCTION get_employer_name (p_org_id in hr_organization_units.organization_id%TYPE,
46 p_business_group_id hr_organization_units.organization_id%TYPE,
47 p_structure_version_id number default null) RETURN VARCHAR2;
48
49 END HR_SA_ORG_INFO;
[Home] [Help]