1 PACKAGE hr_multi_tenancy_pkg AUTHID CURRENT_USER AS
2 /* $Header: permtpkg.pkh 120.3 2010/09/29 06:40:00 psengupt 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 java layer when a new enterprise is created
15 PROCEDURE process_enterprise (p_enterprise_code IN varchar2 default null, p_enterprise_id number);
16
17 --
18 -- Name
19 -- get_enterprise_for_bg
20 -- Purpose
21 -- The function returns the short code of the enterprise to which
22 -- the business group belongs
23 function get_enterprise_for_bg(p_bg_id number) return varchar2;
24
25 --
26 -- Name
27 -- get_enterprise_for_person
28 -- Purpose
29 -- The function returns the short code of the enterprise to which
30 -- the person belongs
31 function get_enterprise_for_person(p_person_id number) return varchar2;
32
33 -- Called From
34 -- 1. hr_signon with argument null.
35 -- 2. HRMultiTenancyHelper.java(#resetContext) with argument ENT.
36 -- Method to set/reset OLS enterprise context.
37 procedure set_context (p_context_value IN VARCHAR2);
38
39 --
40 --------------------------------------------------------------------
41 --< set_context_for_person >----------------------------------------
42 --------------------------------------------------------------------
43 --
44 -- Description:
45 -- This is a public procedure to set the appropriate Context value
46 -- for a person
47 --
48 PROCEDURE set_context_for_person (p_person_id IN NUMBER);
49
50 --
51 --------------------------------------------------------------------
52 --< set_context_for_enterprise >----------------------------------------
53 --------------------------------------------------------------------
54 --
55 -- Description:
56 -- This is a public procedure to set the appropriate Context value
57 -- for a given enterprise short code
58 --
59 PROCEDURE set_context_for_enterprise (p_enterprise_short_code IN VARCHAR2);
60
61 -- Called From
62 -- 1. HRApplicationModuleImpl.java without argument
63 -- 2. MTHomeAMImpl.java with argument.
64 -- Gets the corporate branding for the passed/current enterprise.
65 FUNCTION get_corporate_branding (p_organization_id IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
66
67 -- Called from HR_SIGNON to RETURN the business group corresponding
68 -- to the enterprise security group for buisness group initialization.
69 FUNCTION get_bus_grp_from_sec_grp (p_security_group_id IN NUMBER) RETURN NUMBER;
70
71 -- Called from HR_API to set proper security group.
72 procedure set_security_group_id (p_security_group_id IN NUMBER);
73
74 -- Used in SSHR to derive the security group from person
75 -- i.e. (Notifications/Workflow)
76 FUNCTION get_org_id_for_person (p_person_id IN NUMBER) RETURN NUMBER;
77
78 -- Used in SSHR New Hire flow
79 -- Gets the HR Enterprise Organization ID in the passed business group belonging to
80 -- to the same enterprise as the passed HR Person.
81 FUNCTION get_org_id_for_person (p_person_id IN NUMBER
82 ,p_business_group_id IN NUMBER) RETURN NUMBER;
83
84 -- Called From PerAppModuleHelper
85 FUNCTION get_label_from_bg (p_business_group_id IN NUMBER) RETURN VARCHAR2;
86
87 -- Called From PerAppModuleHelper
88 FUNCTION get_org_id_from_bg_and_sl (p_business_group_id IN NUMBER
89 ,p_security_label IN VARCHAR2) RETURN NUMBER;
90
91 FUNCTION is_valid_sec_group (p_security_group_id IN NUMBER
92 ,p_business_group_id IN NUMBER) RETURN VARCHAR2;
93
94 PROCEDURE add_language;
95
96 END hr_multi_tenancy_pkg;
[Home] [Help]