APPS.PER_DB_PER_SETUP dependencies on HR_ORGANIZATION

Line 30: HR Organizations,

26: create all 'set up' entities in Personnel.
27: That is:
28:
29: Business Groups,
30: HR Organizations,
31: Legal Companies,
32: Positions,
33: Jobs and
34: Grades.

Line 122: SELECT hr_organization_units_s.nextval

118: end if;
119: --
120: hr_utility.set_location('per_db_per_setup.insert_organization_unit',1);
121: --
122: SELECT hr_organization_units_s.nextval
123: INTO l_organization_id
124: FROM sys.dual ;
125: --
126: hr_organization.unique_name(p_business_group_id,l_organization_id,p_name);

Line 126: hr_organization.unique_name(p_business_group_id,l_organization_id,p_name);

122: SELECT hr_organization_units_s.nextval
123: INTO l_organization_id
124: FROM sys.dual ;
125: --
126: hr_organization.unique_name(p_business_group_id,l_organization_id,p_name);
127: --
128: --
129: hr_organization.date_range(nvl(p_date_from,trunc(SYSDATE)),p_date_to);
130: --

Line 129: hr_organization.date_range(nvl(p_date_from,trunc(SYSDATE)),p_date_to);

125: --
126: hr_organization.unique_name(p_business_group_id,l_organization_id,p_name);
127: --
128: --
129: hr_organization.date_range(nvl(p_date_from,trunc(SYSDATE)),p_date_to);
130: --
131: --
132: --
133: hr_utility.set_location('per_db_per_setup.insert_organization_unit',2);

Line 258: FROM hr_organization_units

254: --
255: hr_utility.set_location('per_db_per_setup.insert_org_information',5);
256: SELECT organization_id
257: INTO l_organization_id
258: FROM hr_organization_units
259: WHERE organization_id = p_organization_id;
260: --
261: hr_utility.set_location('per_db_per_setup.insert_org_information',8);
262: if p_org_information_context = 'CLASS' then

Line 276: FROM hr_organization_information hoi

272: begin
273: hr_utility.set_location('per_db_per_setup.insert_org_information',10);
274: SELECT oit.org_information_type
275: INTO l_org_information_type
276: FROM hr_organization_information hoi
277: , hr_org_info_types_by_class tbc
278: , hr_org_information_types oit
279: WHERE oit.org_information_type = p_org_information_context
280: AND oit.org_information_type = tbc.org_information_type

Line 298: FROM hr_organization_information

294: begin
295: hr_utility.set_location('per_db_per_setup.insert_org_information',15);
296: SELECT 'Y'
297: INTO l_check
298: FROM hr_organization_information
299: WHERE organization_id = l_organization_id
300: AND org_information_context = l_org_information_type
301: AND org_information1 = l_org_information1;
302: --

Line 314: SELECT hr_organization_information_s.nextval

310: exception when NO_DATA_FOUND then null;
311: end;
312: --
313: hr_utility.set_location('per_db_per_setup.insert_org_information',20);
314: SELECT hr_organization_information_s.nextval
315: INTO l_org_information_id
316: FROM sys.dual;
317: --
318: hr_utility.set_location('per_db_per_setup.insert_org_information',25);

Line 319: INSERT INTO HR_ORGANIZATION_INFORMATION

315: INTO l_org_information_id
316: FROM sys.dual;
317: --
318: hr_utility.set_location('per_db_per_setup.insert_org_information',25);
319: INSERT INTO HR_ORGANIZATION_INFORMATION
320: (org_information_id
321: ,organization_id
322: ,attribute_category
323: ,org_information_context

Line 378: FROM hr_organization_units hou

374: ,hou.last_updated_by
375: ,hou.last_update_login
376: ,hou.created_by
377: ,hou.creation_date
378: FROM hr_organization_units hou
379: WHERE hou.organization_id = p_organization_id;
380: --
381: return l_org_information_id;
382: --