APPS.HR_ORGANIZATION dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 1093: -- Do Any rows Exist in PER_ORG_STRUCTURE_ELEMENTS.

1089: end;
1090: --
1091: --
1092: begin
1093: -- Do Any rows Exist in PER_ORG_STRUCTURE_ELEMENTS.
1094: hr_utility.set_location('hr_organization.org_predel_check',3);
1095: select '1'
1096: into l_test_func
1097: from sys.dual

Line 1099: from PER_ORG_STRUCTURE_ELEMENTS x

1095: select '1'
1096: into l_test_func
1097: from sys.dual
1098: where exists ( select 1
1099: from PER_ORG_STRUCTURE_ELEMENTS x
1100: where x.business_group_id = p_business_group_id);
1101: --
1102: if SQL%ROWCOUNT >0 THEN
1103: hr_utility.set_message(801,'HR_6569_ORG_IN_HIERARCHY');

Line 1116: -- Do Any rows Exist in PER_ORG_STRUCTURE_ELEMENTS.

1112: --
1113: -- Now do all Organization specific checks.
1114: --
1115: begin
1116: -- Do Any rows Exist in PER_ORG_STRUCTURE_ELEMENTS.
1117: hr_utility.set_location('hr_organization.org_predel_check',4);
1118: select '1'
1119: into l_test_func
1120: from sys.dual

Line 1122: from PER_ORG_STRUCTURE_ELEMENTS x

1118: select '1'
1119: into l_test_func
1120: from sys.dual
1121: where exists ( select 1
1122: from PER_ORG_STRUCTURE_ELEMENTS x
1123: where x.organization_id_child = p_organization_id);
1124: --
1125: if SQL%ROWCOUNT >0 THEN
1126: hr_utility.set_message(801,'HR_6569_ORG_IN_HIERARCHY');

Line 1135: -- Do Any rows Exist in PER_ORG_STRUCTURE_ELEMENTS.

1131: null;
1132: end;
1133: --
1134: begin
1135: -- Do Any rows Exist in PER_ORG_STRUCTURE_ELEMENTS.
1136: hr_utility.set_location('hr_organization.org_predel_check',5);
1137: select '1'
1138: into l_test_func
1139: from sys.dual

Line 1141: from PER_ORG_STRUCTURE_ELEMENTS x

1137: select '1'
1138: into l_test_func
1139: from sys.dual
1140: where exists ( select 1
1141: from PER_ORG_STRUCTURE_ELEMENTS x
1142: where x.organization_id_parent = p_organization_id);
1143: --
1144: if SQL%ROWCOUNT >0 THEN
1145: hr_utility.set_message(801,'HR_6569_ORG_IN_HIERARCHY');

Line 1232: -- Doing check on PER_ORG_STRUCTURE_ELEMENTS.

1228: null;
1229: end;
1230: --
1231: begin
1232: -- Doing check on PER_ORG_STRUCTURE_ELEMENTS.
1233: hr_utility.set_location('hr_organization.hr_weak_bg_chk',3);
1234: select '1'
1235: into l_test_func
1236: from sys.dual

Line 1238: from PER_ORG_STRUCTURE_ELEMENTS x

1234: select '1'
1235: into l_test_func
1236: from sys.dual
1237: where exists ( select 1
1238: from PER_ORG_STRUCTURE_ELEMENTS x
1239: where x.ORGANIZATION_ID_PARENT = p_organization_id);
1240: --
1241: if SQL%ROWCOUNT >0 THEN
1242: hr_utility.set_message(801,'HR_6722_BG_ORG_HIER');

Line 1251: -- Doing check on PER_ORG_STRUCTURE_ELEMENTS.

1247: null;
1248: end;
1249: --
1250: begin
1251: -- Doing check on PER_ORG_STRUCTURE_ELEMENTS.
1252: hr_utility.set_location('hr_organization.hr_weak_bg_chk',4);
1253: select '1'
1254: into l_test_func
1255: from sys.dual

Line 1257: from PER_ORG_STRUCTURE_ELEMENTS x

1253: select '1'
1254: into l_test_func
1255: from sys.dual
1256: where exists ( select 1
1257: from PER_ORG_STRUCTURE_ELEMENTS x
1258: where x.ORGANIZATION_ID_CHILD = p_organization_id);
1259: --
1260: if SQL%ROWCOUNT >0 THEN
1261: hr_utility.set_message(801,'HR_6722_BG_ORG_HIER');