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,
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:
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,
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:
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,
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;
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;