948: begin
949:
950: select install_location_type_code
951: into l_loc_type_code
952: from csi_item_instances
953: where instance_id = p_instance_id;
954:
955:
956: exception
965: BEGIN
966:
967: SELECT install_location_id
968: into l_install_loc_id
969: from csi_item_instances
970: where instance_id = p_instance_id;
971:
972: exception
973:
1030: BEGIN
1031:
1032: SELECT install_location_id
1033: into l_install_loc_id
1034: from csi_item_instances
1035: where instance_id = p_instance_id;
1036:
1037: exception
1038: