APPS.HRI_BPL_ORG dependencies on HRI_CS_ORGH_V

Line 14: g_Org_Hierarchy_Version_id hri_cs_orgh_v.ORG_HIERARCHY_VERSION_ID%TYPE := -1;

10: /* Defing empty table for resetting the cache */
11: g_OrgInHrchy_empty_tab g_varchar2_tabtype;
12:
13: /* Define globals for testing whether the cache is valid */
14: g_Org_Hierarchy_Version_id hri_cs_orgh_v.ORG_HIERARCHY_VERSION_ID%TYPE := -1;
15: g_Sup_Organization_id hri_cs_orgh_v.SUP_ORGANIZATION_ID%TYPE := -1;
16:
17: /* define globals for testing if a user can see certain org hrcy versions */
18: g_organization_structure_id

Line 15: g_Sup_Organization_id hri_cs_orgh_v.SUP_ORGANIZATION_ID%TYPE := -1;

11: g_OrgInHrchy_empty_tab g_varchar2_tabtype;
12:
13: /* Define globals for testing whether the cache is valid */
14: g_Org_Hierarchy_Version_id hri_cs_orgh_v.ORG_HIERARCHY_VERSION_ID%TYPE := -1;
15: g_Sup_Organization_id hri_cs_orgh_v.SUP_ORGANIZATION_ID%TYPE := -1;
16:
17: /* define globals for testing if a user can see certain org hrcy versions */
18: g_organization_structure_id
19: per_security_profiles.organization_structure_id%TYPE;

Line 26: ( p_org_hierarchy_version_id IN hri_cs_orgh_v.ORG_HIERARCHY_VERSION_ID%TYPE

22: /******************************************************************************/
23: /* Empties and repopulates the global cache for the values passed in */
24: /******************************************************************************/
25: PROCEDURE reset_subtree_cache
26: ( p_org_hierarchy_version_id IN hri_cs_orgh_v.ORG_HIERARCHY_VERSION_ID%TYPE
27: , p_sup_organization_id IN hri_cs_orgh_v.SUP_ORGANIZATION_ID%TYPE)
28: IS
29:
30: CURSOR csr_orgs_in_subtree

Line 27: , p_sup_organization_id IN hri_cs_orgh_v.SUP_ORGANIZATION_ID%TYPE)

23: /* Empties and repopulates the global cache for the values passed in */
24: /******************************************************************************/
25: PROCEDURE reset_subtree_cache
26: ( p_org_hierarchy_version_id IN hri_cs_orgh_v.ORG_HIERARCHY_VERSION_ID%TYPE
27: , p_sup_organization_id IN hri_cs_orgh_v.SUP_ORGANIZATION_ID%TYPE)
28: IS
29:
30: CURSOR csr_orgs_in_subtree
31: ( cp_org_hierarchy_version_id IN hri_cs_orgh_v.ORG_HIERARCHY_VERSION_ID%TYPE

Line 31: ( cp_org_hierarchy_version_id IN hri_cs_orgh_v.ORG_HIERARCHY_VERSION_ID%TYPE

27: , p_sup_organization_id IN hri_cs_orgh_v.SUP_ORGANIZATION_ID%TYPE)
28: IS
29:
30: CURSOR csr_orgs_in_subtree
31: ( cp_org_hierarchy_version_id IN hri_cs_orgh_v.ORG_HIERARCHY_VERSION_ID%TYPE
32: , cp_sup_organization_id IN hri_cs_orgh_v.SUP_ORGANIZATION_ID%TYPE) IS
33: -- Selects all children of the organization passed in
34: SELECT sub_organization_id
35: FROM hri_cs_orgh_v orh

Line 32: , cp_sup_organization_id IN hri_cs_orgh_v.SUP_ORGANIZATION_ID%TYPE) IS

28: IS
29:
30: CURSOR csr_orgs_in_subtree
31: ( cp_org_hierarchy_version_id IN hri_cs_orgh_v.ORG_HIERARCHY_VERSION_ID%TYPE
32: , cp_sup_organization_id IN hri_cs_orgh_v.SUP_ORGANIZATION_ID%TYPE) IS
33: -- Selects all children of the organization passed in
34: SELECT sub_organization_id
35: FROM hri_cs_orgh_v orh
36: WHERE orh.org_hierarchy_version_id = cp_org_hierarchy_version_id

Line 35: FROM hri_cs_orgh_v orh

31: ( cp_org_hierarchy_version_id IN hri_cs_orgh_v.ORG_HIERARCHY_VERSION_ID%TYPE
32: , cp_sup_organization_id IN hri_cs_orgh_v.SUP_ORGANIZATION_ID%TYPE) IS
33: -- Selects all children of the organization passed in
34: SELECT sub_organization_id
35: FROM hri_cs_orgh_v orh
36: WHERE orh.org_hierarchy_version_id = cp_org_hierarchy_version_id
37: AND orh.sup_organization_id = cp_sup_organization_id;
38:
39: BEGIN

Line 67: ( p_org_hierarchy_version_id IN hri_cs_orgh_v.ORG_HIERARCHY_VERSION_ID%TYPE

63: /* Returns 1 if the test organization is within the subtree of the given */
64: /* organization hierarchy defined by the given top organization */
65: /******************************************************************************/
66: FUNCTION indicate_in_orgh
67: ( p_org_hierarchy_version_id IN hri_cs_orgh_v.ORG_HIERARCHY_VERSION_ID%TYPE
68: , p_top_organization_id IN hri_cs_orgh_v.SUP_ORGANIZATION_ID%TYPE
69: , p_test_organization_id IN hri_cs_orgh_v.SUP_ORGANIZATION_ID%TYPE)
70: RETURN NUMBER IS
71:

Line 68: , p_top_organization_id IN hri_cs_orgh_v.SUP_ORGANIZATION_ID%TYPE

64: /* organization hierarchy defined by the given top organization */
65: /******************************************************************************/
66: FUNCTION indicate_in_orgh
67: ( p_org_hierarchy_version_id IN hri_cs_orgh_v.ORG_HIERARCHY_VERSION_ID%TYPE
68: , p_top_organization_id IN hri_cs_orgh_v.SUP_ORGANIZATION_ID%TYPE
69: , p_test_organization_id IN hri_cs_orgh_v.SUP_ORGANIZATION_ID%TYPE)
70: RETURN NUMBER IS
71:
72: l_return_value NUMBER;

Line 69: , p_test_organization_id IN hri_cs_orgh_v.SUP_ORGANIZATION_ID%TYPE)

65: /******************************************************************************/
66: FUNCTION indicate_in_orgh
67: ( p_org_hierarchy_version_id IN hri_cs_orgh_v.ORG_HIERARCHY_VERSION_ID%TYPE
68: , p_top_organization_id IN hri_cs_orgh_v.SUP_ORGANIZATION_ID%TYPE
69: , p_test_organization_id IN hri_cs_orgh_v.SUP_ORGANIZATION_ID%TYPE)
70: RETURN NUMBER IS
71:
72: l_return_value NUMBER;
73: