APPS.HR_ORGANIZATION_INTERNAL dependencies on HR_ALL_ORGANIZATION_UNITS

Line 47: hr_all_organization_units ho1,

43: cursor check_ou_exists is
44: select hou1.org_information_id,hou1.org_information_context,hou1.object_version_number
45: ,ho1.object_version_number
46: from
47: hr_all_organization_units ho1,
48: hr_organization_information hou1
49: where ho1.organization_id=l_organization_id
50: and hou1.organization_id=ho1.organization_id
51: and hou1.org_information_context='Exp Organization Defaults';

Line 56: from hr_all_organization_units

52:
53: -- Cursor to make sure that internal_external flag is not allowed to update
54: cursor get_internal_external_flag is
55: select 'Y'
56: from hr_all_organization_units
57: where organization_id=l_organization_id
58: and nvl(internal_external_flag,'X')=nvl(l_internal_external_flag,'X');
59:
60: -- Cursor to check orgname, start_date or end_date is modified or not, If modified return object_version_number.

Line 63: from hr_all_organization_units

59:
60: -- Cursor to check orgname, start_date or end_date is modified or not, If modified return object_version_number.
61: cursor get_object_version_number is
62: select object_version_number
63: from hr_all_organization_units
64: where organization_id=l_organization_id
65: and
66: (name <> l_organization_name
67: or date_from <> l_date_from

Line 80: select 'Y' from hr_all_organization_units

76: and organization_id = p_operating_unit;
77:
78: -- Cursor to check valid organization name is passed or not.
79: cursor is_valid_name is
80: select 'Y' from hr_all_organization_units
81: where business_group_id = l_business_group_id
82: and name = l_organization_name ;
83: --
84: begin

Line 105: from hr_all_organization_units

101: open is_valid_name ;
102: fetch is_valid_name into l_name_check ;
103: if ( is_valid_name %found ) THEN -- Organization exists, update needed
104: select organization_id into l_organization_id
105: from hr_all_organization_units
106: where business_group_id = l_business_group_id
107: and name = l_organization_name ;
108: /***********
109: hr_utility.set_location ('Error!!' || l_organization_name, 1002);

Line 199: --Update row in HR_ALL_ORGANIZATION_UNITS Table

195: begin
196: open get_object_version_number;
197: fetch get_object_version_number into l_object_version_number_org;
198: hr_utility.set_location(l_object_version_number_org,99);
199: --Update row in HR_ALL_ORGANIZATION_UNITS Table
200: if get_object_version_number%found then
201: hr_organization_api.update_organization(
202: p_effective_date =>sysdate
203: ,p_name =>l_organization_name