DBA Data[Home] [Help]

APPS.CSI_CZ_INT dependencies on CSI_T_II_RELATIONSHIPS

Line 206: FROM csi_t_ii_relationships cti

202: cti.sub_config_inst_item_id,
203: cti.obj_config_inst_hdr_id,
204: cti.obj_config_inst_rev_num,
205: cti.obj_config_inst_item_id
206: FROM csi_t_ii_relationships cti
207: WHERE cti.relationship_type_code = 'CONNECTED-TO'
208: AND ((
209: cti.sub_config_inst_hdr_id = p_inst_hdr_id
210: AND

Line 864: FROM csi_t_ii_relationships

860: l_parent_hdr_id IN number, l_parent_rev_num IN number, l_parent_item_id IN number) IS
861: SELECT sub_config_inst_hdr_id,
862: sub_config_inst_rev_num,
863: sub_config_inst_item_id
864: FROM csi_t_ii_relationships
865: WHERE obj_config_inst_hdr_id = p_config_inst_header_id
866: AND obj_config_inst_rev_num = p_config_inst_rev_num
867: AND obj_config_inst_item_id = p_config_inst_item_id
868: AND sub_config_inst_hdr_id <> l_parent_hdr_id

Line 878: FROM csi_t_ii_relationships

874: l_parent_hdr_id IN number, l_parent_rev_num IN number, l_parent_item_id IN number) IS
875: SELECT obj_config_inst_hdr_id,
876: obj_config_inst_rev_num,
877: obj_config_inst_item_id
878: FROM csi_t_ii_relationships
879: WHERE sub_config_inst_hdr_id = p_config_inst_header_id
880: AND sub_config_inst_rev_num = p_config_inst_rev_num
881: AND sub_config_inst_item_id = p_config_inst_item_id
882: AND obj_config_inst_hdr_id <> l_parent_hdr_id

Line 1065: -- in CSI_T_II_RELATIONSHIPS. Since we cannot distinguish between configuring and re-configuring

1061: -- Even though the components that are in 1 status are purely because of their
1062: -- connections havig status 2, we still call the populate_connected_tbl routine.
1063: -- This is because during re-configuring API will lock the components which are not
1064: -- there in the order with status 1. Obviously, such configurations won't be there
1065: -- in CSI_T_II_RELATIONSHIPS. Since we cannot distinguish between configuring and re-configuring
1066: -- we always call the below routine to look for component's connections.
1067: --
1068: populate_connected_tbl(
1069: p_config_inst_header_id => comp_rec.config_inst_hdr_id,