1 PACKAGE hri_bpl_org AUTHID CURRENT_USER AS
2 /* $Header: hriborg.pkh 115.1 2003/03/04 17:39:38 cbridge noship $ */
3
4 FUNCTION indicate_in_orgh
5 ( p_org_hierarchy_version_id IN hri_cs_orgh_v.ORG_HIERARCHY_VERSION_ID%TYPE
6 , p_top_organization_id IN hri_cs_orgh_v.SUP_ORGANIZATION_ID%TYPE
7 , p_test_organization_id IN hri_cs_orgh_v.SUP_ORGANIZATION_ID%TYPE)
8 RETURN NUMBER;
9
10 -- bug 2711570
11 -- returns the organization hierarchy structure id
12 -- attached to the current user/responsibility security profile
13 -- if none is attached, returns -1
14 FUNCTION get_org_structure_id RETURN NUMBER;
15
16 -- bug 2711570
17 -- checks if the current user/responsibility secure profile has an
18 -- organization hierarchy set against it (org security profile form):
19 -- a)if it does, then only return 'TRUE' for any organization
20 -- hierarchy version that has the same org_structure_version_id
21
22 -- b)if the current user/responsibility securite profile does not
23 -- have an organization hierarchy set against it:
24 -- always return 'TRUE' i.e. they can view all hierarchies
25 FUNCTION exist_orghvrsn_for_security(p_org_structure_version_id
26 per_org_structure_versions.org_structure_version_id%type)
27 RETURN VARCHAR2;
28
29 -- bug 2711570
30 -- checks if the current user/responsibility secure profile has an
31 -- organization hierarchy set against it (org security profile form):
32 -- a)if it does, then only return 'TRUE' for the organization
33 -- hierarchy that has the same organization_structure_id
34
35 -- b)if the current user/responsibility securite profile does not
36 -- have an organization hierarchy set against it:
37 -- always return 'TRUE' i.e. they can view all hierarchies
38 FUNCTION exist_orgh_for_security(p_organization_structure_id
39 per_org_structure_versions.organization_structure_id%type)
40 RETURN VARCHAR2;
41
42 END hri_bpl_org;