[Home] [Help]
154: AND CSR.subject_id = CSI.instance_id -- SB rules are created for non-root positions
155: AND CSR.position_reference = TO_CHAR(c_relationship_id)
156: AND CSR.relationship_type_code = 'COMPONENT-OF'
157: AND TRUNC(NVL(CSR.active_end_date, SYSDATE+1)) > TRUNC(SYSDATE)
158: AND AHL_UTIL_UC_PKG.get_sub_uc_header_id(CSR.object_id) = c_uc_header_id;
159:
160: --
161: l_api_version CONSTANT NUMBER := 1.0;
162: l_api_name CONSTANT VARCHAR2(30) := 'Check_Unit_Completeness';
487: END IF;
488: CLOSE chk_instance_id_csr;
489:
490: -- Get the immediate unit for the instance
491: l_uc_header_id := AHL_UTIL_UC_PKG.get_sub_uc_header_id(p_csi_instance_id);
492: OPEN get_unit_name_csr(l_uc_header_id);
493: FETCH get_unit_name_csr INTO l_unit_name;
494: IF (get_unit_name_csr%NOTFOUND) THEN
495: -- invalid unit header id
1718: AND CSR.subject_id = CSI.instance_id -- SB rules are created for non-root positions
1719: AND CSR.position_reference = TO_CHAR(c_relationship_id)
1720: AND CSR.relationship_type_code = 'COMPONENT-OF'
1721: AND TRUNC(NVL(CSR.active_end_date, SYSDATE+1)) > TRUNC(SYSDATE)
1722: AND AHL_UTIL_UC_PKG.get_sub_uc_header_id(CSR.object_id) = c_uc_header_id;
1723:
1724: -- cursor to get the instance id for a given unit and relationship
1725: CURSOR get_instance_id_csr (c_uc_header_id NUMBER,
1726: c_relationship_id NUMBER) IS
1728: FROM CSI_II_RELATIONSHIPS
1729: WHERE position_reference = TO_CHAR(c_relationship_id)
1730: AND relationship_type_code = 'COMPONENT-OF'
1731: AND TRUNC(NVL(active_end_date, SYSDATE+1)) > TRUNC(SYSDATE)
1732: AND AHL_UTIL_UC_PKG.get_sub_uc_header_id(object_id) = c_uc_header_id; -- SB rules are created for non-root positions
1733:
1734: --
1735: l_api_version CONSTANT NUMBER := 1.0;
1736: l_api_name CONSTANT VARCHAR2(30) := 'Get_Violated_Instances';