DBA Data[Home] [Help]

APPS.HR_SA_ORG_INFO dependencies on HR_ORGANIZATION_UNITS

Line 32: Procedure chk_for_org_in_hierarchy(p_org_id in hr_organization_units.organization_id%TYPE,

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,

Line 35: PROCEDURE get_employer_name (p_org_id in hr_organization_units.organization_id%TYPE,

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:

Line 37: p_business_group_id 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:
40: PROCEDURE get_employer_name (p_org_id in hr_organization_units.organization_id%TYPE,
41: p_employer_name out nocopy varchar2,

Line 40: 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,
42: p_business_group_id hr_organization_units.organization_id%TYPE,
43: p_structure_version_id number);
44:

Line 42: 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:
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,

Line 45: FUNCTION 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,
47: p_structure_version_id number default null) RETURN VARCHAR2;
48:
49: END HR_SA_ORG_INFO;

Line 46: p_business_group_id hr_organization_units.organization_id%TYPE,

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;