1 PACKAGE hr_multi_tenancy_pkg AS
2 /* $Header: permtpkg.pkh 120.0.12010000.6 2008/12/17 08:29:45 ppentapa noship $ */
3
4 -- Called From
5 -- 1. hr_signon
6 -- All PL/SQL Code modified for enterprise should be wrapped in a call
7 -- to this method.
8 FUNCTION is_multi_tenant_system RETURN BOOLEAN;
9
10 -- Called From
11 -- 1. Assign Security Profiles form
12 FUNCTION get_system_model RETURN VARCHAR2;
13
14 -- Called From
15 -- 1. hr_signon with argument null.
16 -- 2. HRMultiTenancyHelper.java(#resetContext) with argument ENT.
17 -- Method to set/reset OLS enterprise context.
18 procedure set_context (p_context_value IN VARCHAR2);
19
20 --
21 --------------------------------------------------------------------
22 --< set_context_for_person >----------------------------------------
23 --------------------------------------------------------------------
24 --
25 -- Description:
26 -- This is a public procedure to set the appropriate Context value
27 -- for a person
28 --
29 PROCEDURE set_context_for_person (p_person_id IN NUMBER);
30
31 --
32 --------------------------------------------------------------------
33 --< set_context_for_enterprise >----------------------------------------
34 --------------------------------------------------------------------
35 --
36 -- Description:
37 -- This is a public procedure to set the appropriate Context value
38 -- for a given enterprise short code
39 --
40 PROCEDURE set_context_for_enterprise (p_enterprise_short_code IN VARCHAR2);
41
42 -- Called From
43 -- 1. HRApplicationModuleImpl.java without argument
44 -- 2. MTHomeAMImpl.java with argument.
45 -- Gets the corporate branding for the passed/current enterprise.
46 FUNCTION get_corporate_branding (p_organization_id IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
47
48 -- Called from HR_SIGNON to RETURN the business group corresponding
49 -- to the enterprise security group for buisness group initialization.
50 FUNCTION get_bus_grp_from_sec_grp (p_security_group_id IN NUMBER) RETURN NUMBER;
51
52 -- Called from HR_API to set proper security group.
53 procedure set_security_group_id (p_security_group_id IN NUMBER);
54
55 -- Used in SSHR to derive the security group from person
56 -- i.e. (Notifications/Workflow)
57 FUNCTION get_org_id_for_person (p_person_id IN NUMBER) RETURN NUMBER;
58
59 -- Used in SSHR New Hire flow
60 -- Gets the HR Enterprise Organization ID in the passed business group belonging to
61 -- to the same enterprise as the passed HR Person.
62 FUNCTION get_org_id_for_person (p_person_id IN NUMBER
63 ,p_business_group_id IN NUMBER) RETURN NUMBER;
64
65 -- Called From PerAppModuleHelper
66 FUNCTION get_label_from_bg (p_business_group_id IN NUMBER) RETURN VARCHAR2;
67
68 -- Called From PerAppModuleHelper
69 FUNCTION get_org_id_from_bg_and_sl (p_business_group_id IN NUMBER
70 ,p_security_label IN VARCHAR2) RETURN NUMBER;
71
72 FUNCTION is_valid_sec_group (p_security_group_id IN NUMBER
73 ,p_business_group_id IN NUMBER) RETURN VARCHAR2;
74
75 PROCEDURE add_language;
76
77 END hr_multi_tenancy_pkg;