DBA Data[Home] [Help]

APPS.HR_API dependencies on PER_ORGANIZATION_UNITS

Line 163: (p_name in per_organization_units.name%TYPE)

159: --
160: -- ------------------------ return_business_group_id -------------------------
161: --
162: Function return_business_group_id
163: (p_name in per_organization_units.name%TYPE)
164: Return per_organization_units.business_group_id%TYPE Is
165: --
166: l_business_group_id per_organization_units.business_group_id%TYPE;
167: l_proc varchar2(72) := hr_api.g_package||'return_business_group_id';

Line 164: Return per_organization_units.business_group_id%TYPE Is

160: -- ------------------------ return_business_group_id -------------------------
161: --
162: Function return_business_group_id
163: (p_name in per_organization_units.name%TYPE)
164: Return per_organization_units.business_group_id%TYPE Is
165: --
166: l_business_group_id per_organization_units.business_group_id%TYPE;
167: l_proc varchar2(72) := hr_api.g_package||'return_business_group_id';
168: --

Line 166: l_business_group_id per_organization_units.business_group_id%TYPE;

162: Function return_business_group_id
163: (p_name in per_organization_units.name%TYPE)
164: Return per_organization_units.business_group_id%TYPE Is
165: --
166: l_business_group_id per_organization_units.business_group_id%TYPE;
167: l_proc varchar2(72) := hr_api.g_package||'return_business_group_id';
168: --
169: -- Note: This cursor statement should not require a distinct, as
170: -- business group names should be unique. It has been